WKB_Geometry - Am I being more stupid than the local village idiot?

Topics: General Topics
Sep 6, 2006 at 8:55 AM

Hopefully a very quick one...

I have inserted a SHP file into MSSQL 2005, using SharpMap.Data.Providers.MsSql.CreateDataTable.

Is it possible to convert the WKBGeometry (Well-Known Binary) column using T-SQL into a readable form? Also I would like to generate data for the WKBGeometry based on data held within my existing coordinate tables, is this also possible using only T-SQL/or CLR?

Thanks to all!

James Chapman
Coordinator
Sep 6, 2006 at 11:02 AM
Hi,

Please look at http://www.codeplex.com/Wiki/View.aspx?ProjectName=MsSqlSpatial
I hope this covers your needs.
Sep 7, 2006 at 12:40 PM
Thanks!!!

I haven't had chance to run-thru it yet, but it looks as though it's exactly what I need. Is this something similar to SpatialWare???

Thanks

James
Developer
Sep 7, 2006 at 4:12 PM
It has taken an idea from SpatialWare (notation of helper table-valued functions such as "select * from ST.FilterQuery#dbo#table#column( blah blah...") but it's mainly modelled after OGC specifications and PostGIS implementation.