Have a look at:

http://www.joeconway.com/plr/

http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut01



On Fri, May 7, 2010 at 5:35 PM, Tim Romel <tim.romel@vistracks.com> wrote:

> I have the need to bring spatial data into R from a postgres database.  I
> am
> trying to do this right now using rgdal with a command similar to the
> following:
>
> results=readOGR("PG:dbname='dbname' host='hostname' port='portnum'
> user='username' password='pass' <password='P@ssw0rd'>, layer="tablename")
>
> This works in bringing back all data from the entire table.  However, this
> is a very large table and I was wondering if there was a way to run a query
> against the table instead of bringing back all data using readOGR.  I have
> found no examples anywhere and have even seen suggestions that it is not
> possible.  Is this the case?  If there are other libraries that support R's
> SP library that allow access to postgres that would be great to know too.
>
> Any help is much appreaciated.
>
> Thanks.
>
>        [[alternative HTML version deleted]]
>
> _______________________________________________
> R-sig-Geo mailing list
> R-sig-Geo@stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-geo
>

	[[alternative HTML version deleted]]

