Home -
General /
All posts - Drawing from db WKT stored in MS Access
sclose 25 post(s) |
I have dataset compiled with a one:many relationship in MS Access, where each record has spatial value stored in a WKT field. Manifold allows for easy linking to any table in a *.mdb or *.accdb, but how do I encourage Manifold to recognize the WKT for drawing the polygons? Thanks!
|
volker  1,099 post(s) |
I dont`t believe that Manifold create a Drawing from a WKT Geometry. WKB isn`t a problem but i don`t find a possibility to do this with WKT. Curios cause is no problem to make a WKB to WKT in Manfiold. ogr2ogr should do this but i never tried it... http://giswiki.hsr.ch/HowTo_OGR2OGR
http://www.thegisservicesector.de |
|
"Just import the table in and you can create a linked drawing from the table with SQL: SELECT CGeomWKB([wktfield]),[thetable].* FROM [thetable] that will create an OGC WKB field. If you want a Manifold geometry then you can do this: CGeom(CGeomWKB([wktfield])),[thetable].* This clause takes the WKB and turns it into a Manifold geometry." Quote from elsewhere in this forum.
http://www.mppng.nl/manifold/pointlabeler |