[postgis-users] About Invalid OGC WKT Error

[Mark Cave-Ayland]

Hi Tom,

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Kralidis,Tom [Burlington]
> Sent: 02 February 2005 23:46
> To: PostGIS Users Discussion; Paul Ramsey
> Subject: RE: [postgis-users] About Invalid OGC WKT Error

(cut)

> > What happens when you plug the query into psql?
> > 
> > SELECT
> > astext(force_collection(force_2d(the_geom)),'NDR'),OID::text 
> > from service_endpoints WHERE the_geom && 
> > setSRID('BOX3D(-141.089 36.392987,-52.089 89.784987)'::BOX3D,
> > find_srid('','service_endpoints','the_geom') )

The query above doesn't look right: you need to replace astext() with
asbinary() to get the exact query issued by Mapserver.

SELECT asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from
service_endpoints WHERE the_geom && setSRID('BOX3D(-141.089
36.392987,-52.089 89.784987)'::BOX3D,
find_srid('','service_endpoints','the_geom') )

Could you let us know whether this works for you?


Kind regards,

Mark.

------------------------
WebBased Ltd
South West Technology Centre
Tamar Science Park
Plymouth
PL6 8BT 

T: +44 (0)1752 791021
F: +44 (0)1752 791023
W: http://www.webbased.co.uk