Hi list,
I'm trying to port some OGC WKT strings into SpatialWare blobs, but
can't seem to get it right.
Has anyone got an example of a polygon WKT string that the
GeometryFromText function in SpatialWare will accept ? The manual is
sorely lacking in that respect.
--
My attempts started with these strings, all fail.
update Test_WKT set sw_geometry = ' HG_GeometryFromText (
mi_poly_wkt ) '
update Test_WKT set sw_geometry = ' HG_GeometryFromText (' +
mi_poly_wkt + ') '
even
update Test_WKT set sw_geometry = mi_poly_wkt
where the mi_poly_wkt column has (varchar) values as given below :
GEOMETRYCOLLECTION ( POLYGON (( x1 y1 , x2 y2 , x3 y3 , .... , x1 y1
)) )
This format matches what the reverse function HG_AsText spits out when
given a valid polygon geometry blob (sw_geometry), so I assumed it would
work as input. Alas.
Even when using a hard coded value instead of the mi_poly_wkt column, it
errs. The error message is always :
Server: Msg 70509, Level 11, State 1, Line 0
SW-70509: Invalid geometry detected: (ID=1):xp_rtree_insert_trigger
--
Yes, the Test_WKT table has been spatialized and an R-Tree index has
been created.
--
Can anyone help me out ?
Using SpatialWare 4.8 on MS/SQL 2000.
--
Best regards / Med venlig hilsen
Lars I. Nielsen
GisPro
_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
