[postgis-users] Postgis & R language

[Paragon Corporation]

David,

 

Not sure how complex what you have is to graph.  I do wish there was a
package in R that could read ST_AsBinary format directly from PL/R and stuff
it into a spatial dataframe. Maybe someone else knows of that.  The closest
we found was an SQLite driver one for spatial lite which looked like it
could be retrofit to make a standalong binary digester. Can't recall where
that is.

 

If it's of any help to you we do have an example of using ST_DumpPoints
(introduced in PostGIS 1.5) and using that to populate R spatial data
frames.  The code can be downloaded from

http://www.postgis.us/chapter_10

 

And of course if you buy the book http://www.postgis.us/page_buy_book
(directly from Manning you get the beta book now (you get all chapters
complete but undergoing revision and polishing) ) and the final book (eBook
or hard-copy), which we hope we will be DONE DONE around January (or
mid-late December if we are lucky).

 

http://www.postgis.us

Leo and Regina

 

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
pcreso at pcreso.com
Sent: Wednesday, November 17, 2010 1:24 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Postgis & R language

 


Hi David,

You can use PL/R to access R functionality from a Postgres SQL command line,
or you can use rgdal to read Postgis data into R.

So it depends on whether you want to work in the DB & add R capabilities, or
work in R & access Postgis data.

See: 

http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tu
t01
http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tu
t02

for a useful introduction to PL/R; and for rgdal, see:

http://rgdal.sourceforge.net/
http://cran.r-project.org/web/packages/rgdal/rgdal.pdf
http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tu
t03

HTH,

  Brent Wood


--- On Thu, 11/18/10, David Potts <dave.potts at pinan.co.uk> wrote:


From: David Potts <dave.potts at pinan.co.uk>
Subject: [postgis-users] Postgis & R language
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Date: Thursday, November 18, 2010, 12:46 AM


Hi List

Has anybody ever tried to read the value of geometry column from a table
into a R-language application  using the plr handler, is this a support
option?

Thanks in advance.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Any views expressed in this message are those of the individual sender,
except where the sender specifically states them to be the views of the
Pinan Software


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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20101117/d0b30888/attachment.html>