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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] 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 [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
