RE: [MI-L] Spatialware to Well known text

[Robert Crossley]

Thanks Lars again,   That worked like a charm for me too.  HG_IsValid was the function I needed. The following statement worked without errors; exec sp_spatial_query 'select HG_AsText(SW_GEOMETRY) from dbo.T_AMAL_HARV_OPS where sw_geometry is not null and HG_Is_Valid(sw_geometry)'   I will have a bit of a look at the HG functions and see what other goodies there are there…     R   ------------------------------------------- Robert Crossley Agtrix P/L Australia   Far Southern Queensland Office: 9 Short Street PO Box 63 New Brighton 2483   P: 61 2 6680 1309 F: 61 2 6680 5214 E: [EMAIL PROTECTED] W: www.agtrix.com   Brisbane Office: 109 Milsom St Cooparoo  4151 Queensland P: 61 7 3843 3363       From: Lars I. Nielsen (GisPro) [mailto:[EMAIL PROTECTED] Sent: 19 May 2006 23:21 To: Robert Crossley Subject: Re: [MI-L] Spatialware to Well known text   Hi Robert, I did a quick run on my SpW 4.8 installation, and it worked like a charm, even without sp_sw_spatialize_column I think you have errornous spatial objects in your table, apart from the NULL's. Try to see if this returns anything : exec sp_spatial_query 'select count(*) from dbo.T_AMAL_HARV_OPS where sw_geometry is not null and not HG_Is_Valid(sw_geometry)' Best regards / Med venlig hilsen Lars I. Nielsen GisPro Robert Crossley wrote: Lars,   you are right, this was an error in the question.  It was actually sw_geometry that I was trying to filter to get rid of any records that may not have had a spatial object.  I did notice this later and tried with SW_GEOMETRY, but it gave the same error anyway.   Exec sp_spatial_query 'Select C_LINKCODE, HG_AsText(SW_GEOMETRY) From dbo.T_AMAL_HARV_OPS where SW_ GEOMETRY IS NOT NULL'   R   From: Lars I. Nielsen (GisPro) [mailto:[EMAIL PROTECTED]] Sent: 19 May 2006 16:29 To: Robert Crossley Subject: Re: [MI-L] Spatialware to Well known text   Hi Robert, Oughtn't sw_member be a primary unique index column, i.e. auto-numbered ?  How can it then be NULL, as you test for ?? Best regards / Med venlig hilsenLars I. NielsenGisPro Robert Crossley wrote: Hi all,   I am trying to get a recordset from Spatialware, and extract the geometry object as a well known text or binary.  The SQL statement below works well (if a little slow), but while it returns the data, it gives the error message below.  Any ideas?  I don’t get it when I run the statement on a table that only contains points.  This table only contains polygons.   R   Exec sp_spatial_query 'Select C_LINKCODE, HG_AsText(SW_GEOMETRY) From dbo.T_AMAL_HARV_OPS where SW_MEMBER IS NOT NULL'     Server: Msg 70201, Level 11, State 1, Line 0 SW-70201: Error from spatial operator: hggeo_ogc_output_wkt_v1       ------------------------------------------- Robert Crossley Agtrix P/L Australia   Far Southern Queensland Office: 9 Short Street PO Box 63 New Brighton 2483   P: 61 2 6680 1309 F: 61 2 6680 5214 E: [EMAIL PROTECTED] W: www.agtrix.com   Brisbane Office: 109 Milsom St Cooparoo  4151 Queensland P: 61 7 3843 3363                _______________________________________________MapInfo-L mailing listMapInfo-L@lists.directionsmag.comhttp://www.directionsmag.com/mailman/listinfo/mapinfo-l     _______________________________________________MapInfo-L mailing listMapInfo-L@lists.directionsmag.comhttp://www.directionsmag.com/mailman/listinfo/mapinfo-l

_______________________________________________
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l