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: [email protected] [mailto:[email protected]] On Behalf Of [email protected] 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 <[email protected]> wrote: From: David Potts <[email protected]> Subject: [postgis-users] Postgis & R language To: "PostGIS Users Discussion" <[email protected]> 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 [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
