[postgis-users] spatial functions in PostGIS connection

[Paul Ramsey]

Tom,

Can be done, you just need to use a different syntax (this is in the  
documentation somewhere... if you don't like where, maybe you can  
move it somewhere you consider more obvious? or start a postgis/ 
mapserver howto on the cms?)

> DATA "the_geom from (select gid, the_geom from outbreaks where  
> distance(wkb_geometry,'POINT(-122 45)') = 10) as subquery using  
> unique gid using srid=4269"

Paul

On Mar 21, 2006, at 12:27 PM, Kralidis,Tom [Burlington] wrote:

>
> Hi,
>
> I have a point dataset in PostGIS which I display via OGC:WMS with no
> problems:
>
>
>   NAME "outbreaks"
>   CONNECTIONTYPE postgis
>   CONNECTION "user=postgres dbname=devgeodb2"
>   DATA "the_geom from outbreaks"
>
> ..is it possible to embed PostGIS functions in the LAYER/DATA  
> statement
> like:
>
>   NAME "outbreaks"
>   CONNECTIONTYPE postgis
>   CONNECTION "user=postgres dbname=devgeodb2"
>   DATA "the_geom from outbreaks where distance(wkb_geometry,'POINT 
> (-122
> 45)') = 10"
>
> I tried this and got a ServiceException.  I also tried
>
> Thanks
>
> ..Tom
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users