Hello all,
Is it possible to do an intersection on the requested data?
I want to make a data query to the postgis, where the data will be
intersected and delivered to mapserver for display process.
Here is what i already reached:
CONNECTIONTYPE postgis
CONNECTION 'host=127.0.0.1 user=postgres password=postgres dbname=OM'
DATA "the_geom FROM kl_l USING UNIQUE gid USING SRID = 28992"
FILTER "ST_Intersects(kl_l.the_geom , ST_GeomFromText('POLYGON((165607
387820 , 165651 387813 , 165672 387759 , 165598 387800 , 165607 387820
))' , 28992) )"
This works fine. The data returned is the features that intersect. But this
returns the whole feature, instead of the intersection part itself.
So i tried to get the intersection:
CONNECTIONTYPE postgis
CONNECTION 'host=127.0.0.1 user=postgres password=postgres dbname=OM'
DATA "ST_Intersection(kl_l.the_geom , ST_GeomFromText('POLYGON((165607
387820 , 165651 387813 , 165672 387759 , 165598 387800 , 165607 387820
))' , 28992) ) FROM kl_l USING UNIQUE gid USING SRID = 28992"
FILTER "ST_Intersects(kl_l.the_geom , ST_GeomFromText('POLYGON((165607
387820 , 165651 387813 , 165672 387759 , 165598 387800 , 165607 387820
))' , 28992) )"
The full query works fine on the postgis database:
select ST_Intersection(kl_l.the_geom , ST_GeomFromText('POLYGON((165607
387820 , 165651 387813 , 165672 387759 , 165598 387800 , 165607 387820
))' , 28992) ) FROM kl_l where ST_Intersects(kl_l.the_geom ,
ST_GeomFromText('POLYGON((165607 387820 , 165651 387813 , 165672 387759 ,
165598 387800 , 165607 387820 ))' , 28992) )
The part where mapserver is complaining is the single quote just before
POLYGON in the DATA statement.
I tried single quotes inside double quotes, tried double quotes inside
single quotes, both give the same error.
Is there any way of retrieving the intersected features?
Greets
Gerben
--
View this message in context:
http://www.nabble.com/-Postgis--Intersection-on-requested-data-tp20229230p20229230.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
