[postgis-users] How to access PostGIS directly from R (rgdal)

[Paragon Corporation]

Brent,
I suppose calling RGDAL from PostgreSQL is not an option? 
http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tu
t03


Hope that helps,
Regina



-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
pcreso at pcreso.com
Sent: Tuesday, October 28, 2008 8:15 PM
To: PostGIS Users Discussion
Subject: [postgis-users] How to access PostGIS directly from R (rgdal)

Hi,

This may be better suited to the R or GDAL lists, but I don't frequent
those, so I'll try here first.

We have PostGIS databases we are looking to use behind a WMS/WFS server & as
a generic spatial data repository for my organisation.

We have a lot of R users, & I'd like to be able to have them able to access
the topo data (coastlines, roads, rivers, lakes, cities, etc) for use with
some of our R mapping functionality.

I had hoped rgdal would support this, but having installed it, it does not
support Postgres/PostGIS databases as an OGR source. We could use something
like shapefiles as an intermediate format if there is nothing better, but
I'm hoping for some pointers in how to enable Postgis access directly.

We can use ODBC, via dbi, etc, but this means reinventing ways of
interpreting geometry datatype data.

Does anyone have any suggestions?

Thanks,

   Brent Wood
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users