New answers tagged wkt
If you are willing to program python: arcpy has the "fromWKT" function, which can read a WKT string and return a geometry object. See http://resources.arcgis.com/en/help/main/10.1/index.html#//018v0000008s000000 . FME has a WKT reader also: http://docs.safe.com/fme/html/FME_ReadersWriters/Default.htm#wkt/wkt.htm
Yes, you just need to add a header line to tell the imported the name of your geometry column, otherwise I guess it doesn't work, for instance: Geom, "POLYGON((-125 52, -125 21, -98 21, -98 52, -125 52),(-120 50, -120 35, -100 35, -100 50, -120 50))" I would also put quotation marks around the text as I have done. The importer should recognise that this ...
In Sql Server Spatial select geometry::STGeomFromWKB(0x01030000000100000005000000E968ED3E66CF1D41BD6859D5EEE15941E968ED3E66CF1D41844B22F8E1E959417156F69608241F41844B22F8E1E959417156F69608241F41BD6859D5EEE15941E968ED3E66CF1D41BD6859D5EEE15941,3857).ToString();
I suggest class from .NET framework: DbGeography DbGeography dbg = DbGeography.FromText(wkt_string);
MS SQL server Create new table or add new column. Use STGeomFromWKB to convert WKB to Geometry , then in FME do following. Add "MS SQL spatial reader" , point it to correct table ( You can do this with SQLExecute too , that eliminates need for table containing geometry type and you can just use something like SELECT STGeomFRomWKB(wkb) as geom , id from xxx ...
Top 50 recent answers are included