<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-15"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
<font face="Times New Roman, Times, serif">You could do this
completely within R by installing both rgdal and rpostresql
(<a class="moz-txt-link-freetext" href="http://code.google.com/p/rpostgresql/">http://code.google.com/p/rpostgresql/</a>). You'll have to split your
queries in an attribute part (rpostgresql) and a geometry part
(rgdal, returning sp items) and combining them afterwards. I have
never done this but it should work. Moreover, one of the
developers of rpostgesql is Joe Conway, the maker of PL/R. He'll
certainly anser questions on the PL/R mailing list.<br>
<br>
Jan </font><br>
<br>
On 11/17/10 14:09, David Potts wrote:
<blockquote
cite="mid:62262.153.98.68.197.1289999375.squirrel@dp2642.force9.co.uk"
type="cite">
<pre wrap="">I want to draw some graphs from an some data from a table that has
geometry column, before starting anything I wanted to ensure that the
software could handle it.
</pre>
<blockquote type="cite">
<pre wrap="">You could install rgdal in R and then use that R-version for PL/R
(<a class="moz-txt-link-freetext" href="http://cran.r-project.org/web/packages/rgdal/index.html">http://cran.r-project.org/web/packages/rgdal/index.html</a>) . It's a bit
round-about of course: do you use PostGIS from R, or R from PostGIS?
Jan
On 11/17/10 12:46, David Potts wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
<pre wrap="">
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
</pre>
</blockquote>
</body>
</html>