extra spatial filter for OVF source

[Frank Warmerdam]

Huub Fleuren wrote:
> 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?

Huub,

I don't know how this would be accomplished without changing some code,
though I can see that it would be an interesting capability for the OGR
VRT (OVF) driver.  If you just wanted a one time static extract it wouldn't
be to hard to setup with a Python script but doing it dynamically is
not currently supported.

Best regards,

> 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>


-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGF, http://osgeo.org