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

[pcreso at pcreso.com]

Thanks Regina,
 
 PL/R is not a solution in this case. We want to be able to
 load PostGIS geometries as R objects, not return the result
 of an R function applied to PostGIS data via SQL.
 
 The idea is to use PostGIS to manage all the data &
 have R access it natively. We can then have one PostGIS
 cluster to maintain, and our QGIS/gvSIG/JUMP/uDIG users can
 access it natively, Mapinfo & ESRI users can access it
 via WMS/WFS as appropriate, GMT users can use ogr2ogr &
 R users can use rgdal.
 
 It will be pretty neat if we can get it all working
 smoothly. We are also looking at using PostGIS as our ESRI
 geodatabase, but still providing access via the same
 protocols to all the other apps. Much better than
 shapefiles, etc being passed around...
 
 
 Cheers,
 
    Brent Wood
 
 --- On Wed, 10/29/08, Paragon Corporation
 <lr at pcorp.us> wrote:
 
 > From: Paragon Corporation <lr at pcorp.us>
 > Subject: RE: [postgis-users] How to access PostGIS
 directly from R (rgdal)
 > To: "'PostGIS Users Discussion'"
 <postgis-users at postgis.refractions.net>
 > Date: Wednesday, October 29, 2008, 2:13 PM
 > Brent,
 > I suppose calling RGDAL from PostgreSQL is not an
 option? 
 >
 > http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut03
 > 
 > 
 > 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
> > 
> > 
> > 
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> >
> http://postgis.refractions.net/mailman/listinfo/postgis-users