[postgis-users] About Invalid OGC WKT Error

[Kralidis,Tom [Burlington]]

Here's what shows up in my error logs when MapServer attempts to access
when I have MapServer in debugging mode:

# MapServer def
DATA "the_geom from service_endpoints"

# error_log
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5] [Wed Feb  2
18:45:22 2005].363256
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5]
msPOSTGISLayerOpen called datastatement: the_geom from service_endpoints
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5] [Wed Feb  2
18:45:22 2005].364533
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5]
MSPOSTGISLayerOpen -- shared connection not available.
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5] [Wed Feb  2
18:45:22 2005].399054
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5]
msConnPoolRegister(service_endpoints,user=postgres
dbname=devgeodb,0x8305d20)
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5] [Wed Feb  2
18:45:22 2005].400004
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5]
msPOSTGISLayerFreeItemInfo called
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5] [Wed Feb  2
18:45:22 2005].400676
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5]
msPOSTGISLayerWhichShapes called
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5] [Wed Feb  2
18:45:22 2005].401341
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5]
msPOSTGISLayerParseData: unique column = OID, srid='', geom_column_name
= the_geom, table_name=service_endpoints
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5] [Wed Feb  2
18:45:22 2005].403436
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5]
query_string_0_6:DECLARE mycursor BINARY CURSOR FOR 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') )
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5] [Wed Feb  2
18:45:22 2005].440329
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5]
msPOSTGISLayerFreeItemInfo called
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5] [Wed Feb  2
18:45:22 2005].441009
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5]
msPOSTGISLayerResultClose: the_geom from service_endpoints
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5] [Wed Feb  2
18:45:22 2005].442809
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5]
msPOSTGISLayerClose datastatement: the_geom from service_endpoints
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5] [Wed Feb  2
18:45:22 2005].443538
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5]
msPOSTGISLayerClose -- query_result is NULL
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5] [Wed Feb  2
18:45:22 2005].444325
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5]
msConnPoolRelease(service_endpoints,user=postgres
dbname=devgeodb,0x8305d20)
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5] [Wed Feb  2
18:45:22 2005].445100
[Wed Feb 02 18:45:22 2005] [error] [client 192.75.68.5]
msConnPoolClose(user=postgres dbname=devgeodb,0x8305d20)

...one thing I noticed was that SRID didn't get set.  When I tried to
set this explicitly in MapServer (i.e. adding "USING SRID=4326"), the
SRID showed up in the logfile, but other than that the output from the
log was identical.

Any hints?

PS -- I'm not sure where this is best posted to: mapserver-users or
postgis-users


> -----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: Wednesday, 02 February, 2005 13:31
> To: PostGIS Users Discussion
> Subject: RE: [postgis-users] About Invalid OGC WKT Error
> 
> 
> 
> > > 
> > > MapServer connects via (user config):
> > > 
> > > DATA "the_geom from table_name"
> > > 
> > > Does one need to pass a function (like asEWKT(the_geom from
> > table) on
> > > this?  I'm not sure how this is evaluated in the MapServer
> > / PostGIS
> > > connector code itself, though.
> > 
> > I think it should be transparent. Did you have problems ? --strk;
> > 
> 
> Yes, I can't see any data when requesting from MapServer 
> WFS/WMS.  I can't however, see the table structure through 
> WFS DescribeFeatureType, so that tells me it's connecting and 
> can see the table schema, but can't fetch the data.  Any suggestions?
> 
> I'm using MapServer CVS and PostGIS 1.0.0RC2 
> _______________________________________________
> postgis-users mailing list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>