extra spatial filter for OVF source

Huub Fleuren hfl at HOME.NL
Wed Mar 22 05:42:48 EST 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 &gt; 190000) and (w.x &lt; 200000) and (w.y &gt; 500000) 
and (w.y &lt; 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