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

[Roger Bivand]

On Tue, 13 Oct 2009, Tom Gottfried 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().

No, not implemented. Please use ogr2ogr externally for this, implementing 
it internally would be duplicating code.

Roger

>
> Thanks!
> Tom
>
> _______________________________________________
> R-sig-Geo mailing list
> R-sig-Geo at stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-geo
>

-- 
Roger Bivand
Economic Geography Section, Department of Economics, Norwegian School of
Economics and Business Administration, Helleveien 30, N-5045 Bergen,
Norway. voice: +47 55 95 93 55; fax +47 55 95 95 43
e-mail: Roger.Bivand at nhh.no