[R-sig-Geo] passing SQL through readOGR()

[Barry Rowlingson]

On Tue, Oct 13, 2009 at 4:34 PM, Tom Gottfried <tom.gottfried at wzw.tum.de> wrote:
> Hi list,
>
> is there a way to pass any SQL-statement through readOGR (as with the -sql Option to ogr2ogr). I
> want to import a subset of a large dataset from PostGIS into R. I know it's possible with for
> example RODBC and then coercing the resulting data.frame to an sp-class, but I wonder if I can do it
> directly through readOGR().

 If you cant get the sql into readOGR directly (and I anticipate a
post from Roger telling you how to do that to appear about three
seconds after I hit 'send') then you might be able to do it with the
OGR virtual driver:

http://www.gdal.org/ogr/drv_vrt.html

There's an example there with some SQL embedded in the XML.

Barry

3...2...1....