[Chameleon] Query postgis layer

[Mark M]

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.

Thanks again,
Mark

----- 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?
> 
> Mark,
> 
> Try adding:
> TOLERANCE 5
> TOLERANCEUNITS pixels
> 
> to your POSTGIS layer.
> 
> Eric
> 
> 
> 

-- 
_______________________________________________
The coolest e-mail address on the web and it’s FREE!  Sign-up today for Beer Mail @ beer.com.