[Chameleon] Query postgis layer
fosters4all at beer.com
Sun Nov 14 18:07:27 EST 2004
Arghh, sorry, can't believe I missed that. Changing from TOLERANCE 0 to TOLERANCE 5 fixed it. Interesting enought the layres for the shape files (that I got from elsewhere) don't include TOLERANCE or TOLERANCEUNITS however they still work.
----- Original Message -----
From: Eric Bridger <eric at gomoos.org>
To: Mark M <fosters4all at beer.com>
Subject: Re: [Chameleon] Query postgis layer
Date: 12 Nov 2004 17:05:18 -0500
> On Fri, 2004-11-12 at 14:33, Mark M wrote:
> > Hi,
> > I can plot and query information from shp files. When I add a layer from postgis as in ,
> > CONNECTION "user=postgres dbname=water host='127.0.0.1'"
> > CONNECTIONTYPE POSTGIS
> > DATA "the_geom from (SELECT local_coordinates AS the_geom, locale.oid AS oid, name
> > from locale)
> > USING UNIQUE oid USING SRID=-1"
> > TEMPLATE "ttt_query.html"
> > I can see the points but when I try to query them I get 'The layers did not return any results'. I can still query the shp files without a probelm. Any idea what's up?
> Try adding:
> TOLERANCE 5
> TOLERANCEUNITS pixels
> to your POSTGIS layer.
The coolest e-mail address on the web and its FREE! Sign-up today for Beer Mail @ beer.com.
More information about the Chameleon