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/[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 > 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>
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up | Frank Warmerdam, [EMAIL PROTECTED]
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | President OSGF, http://osgeo.org
