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/[EMAIL PROTECTED]</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

Reply via email to