Tag Info

New answers tagged

2

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 ...


0

I finally ended up write my own parser in python to parse the polygon string returned by sql server. Note that the simplekml library and the xml.etree library are used. from xml.etree import ElementTree import simplekml def ParsexmlString(xmlstring): rxml = ElementTree.fromstring(xmlstring) drivetime = rxml.find('./Polygons/').get('duration') ...



Top 50 recent answers are included