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
<[EMAIL PROTECTED]> wrote:
> From: Paragon Corporation <[EMAIL PROTECTED]>
> Subject: RE: [postgis-users] How to access PostGIS
directly from R (rgdal)
> To: "'PostGIS Users Discussion'"
<[email protected]>
> 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: [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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
