extra spatial filter for OVF source
Huub Fleuren
hfl at HOME.NL
Wed Mar 22 02:42:48 PST 2006
Hi List
http://www.google.com/search?hl=en&lr=&rls=GGLD%2CGGLD%3A2004-28%2CGGLD%3Aen&q=ODBC+gdal+spatial+filters+VRT+format+howto
I was hoping that i could put an extra spatial filter (a polygon : find
all point within the polygon) to the following OVF source
Is it possible?
How?
Thanks in advance
<OGRVRTDataSource>
<OGRVRTLayer name='wwal'>
<SrcDataSource>ODBC:admin/admin at anwb</SrcDataSource>
<SrcSQL>SELECT k.kp_nr as kp_nr,k.x as x, k.y as y,
w.wegbeheerdercode as wegbeheerdercode, w.onderhoudsinstantiecode as
onderhoudsinstantiecode FROM wwall w, kpxy k WHERE NOT (k.soort LIKE
'D') and (w.x > 190000) and (w.x < 200000) and (w.y > 500000)
and (w.y < 520000) and (w.kruispuntnummer = k.kp_nr)</SrcSQL>
<GeometryType>wkbPoint</GeometryType>
<LayerSRS>WGS84</LayerSRS>
<GeometryField encoding='PointFromColumns' x='x' y='y'/>
</OGRVRTLayer>
</OGRVRTDataSource>
Regards, Huub
More information about the MapServer-users
mailing list