[postgis-users] About Invalid OGC WKT Error

[Kralidis,Tom [Burlington]]

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Mark Cave-Ayland
> Sent: Thursday, 03 February, 2005 09:10
> To: 'PostGIS Users Discussion'; 'Paul Ramsey'
> Subject: RE: [postgis-users] About Invalid OGC WKT Error
> 
> 
> 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?
> 

This is my output:

[devgeo:/usr/local/wwwsites/apache/devgeo.cciw.ca/apps/mapserv/services/
eccat/dbadmin]$ /usr/local/pgsql/bin/psql -d devgeodb -f ./b.sql -U
postgres

asbinary
         |  oid
------------------------------------------------------------------------
------------------------------------------------------------------------
------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------
---------+-------
 \001\007\000\000\000\001\000\000\000\001\003\000\000
\346\020\000\000\001\000\000\000\005\000\000\000\002+\207\026\331\242a\3
00\374\251\361\322M2B@\002+\20
7\026\331\242a\300\012\327\243p=rV@\010\254\034Zd\013J\300\012\327\243p=
rV@\010\254\034Zd\013J\300\374\251\361\322M2B@\002+\207\026\331\242a\300
\374\251\361
\322M2B@ | 28517
(1 row)



> 
> 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
> 
> 
> _______________________________________________
> postgis-users mailing list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>