Since Dave was doing his part, I figured I would help out the cause a
little. R is pretty new to me too but looks like it could be very useful.
I drafted up a quick getting started and included David's link in there.
http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut01
Let me know any parts that seem unclear or where I went wrong. The
steps seemed to work for me.
Thanks,
Regina
------------------------------------------------------------------------
*From:* [EMAIL PROTECTED] on behalf of
TECHER David
*Sent:* Sun 6/17/2007 2:53 AM
*To:* PostGIS Users Discussion
*Subject:* Re: [postgis-users] Combined Windows version of PostGIS/P-LR
Dear Jan,
I begun to use PL/R. As you know, I'm not a expert in R
Compiling with PostgreSQL 8.2.4 on win32 ...no problem!
These release is available at
http://www.davidgis.fr/download/plr-8.2.0.4_0_win32.exe
I've tryed to see here if
first R 2.5.0 is available on the computer where you want to install it.
else it stop!
The installer updates the R_HOME environment variable
and update the PATH in order to adding 'R_HOME'/bin directory
Let me know if it works for you
createdb testR
psql -d testR -f / "path/to/your/postgresql/dir"/share/contrib/plr.sql
psql testR
select load_r_modules();
select * from plr_environ();
and so on
--david;
Jan Hartmann a écrit :
> I agree. A separate installer for PL/R would be the first thing to
> create. Am I right that that would not be very difficult? After that,
> though, I would very much like to have a *combined* version, with PL/R
> and PostGIS both enabled. I am not sure how difficult that would be,
> but, as I said, it would be a marvelous example of Open Source
> software cooperation. The additional packages Mike mentioned don't
> have to be installed prior to installing PL/R; you can install them in
> the regular way in R (R INSTALL), and an existing PostgreSQL database
> with PL/R will recognise them after a restart.
>
> BTW: deldir was a major reason for me to experimnt with a combined
> version: the power of voronoi diagrams in a PostGIS database!
>
> Jan
>
> Mike Leahy wrote:
>> David/Jan:
>>
>> Although PostGIS and PL/R can be complimentary tools, I think a
separate
>> installer (for now at least) would make the most sense for PL/R. At
>> least that way there is still the option for other users to install
PL/R
>> without PostGIS, and vice-versa.
>>
>> At the same time, however, I can see how a including PL/R as an option
>> in the PostGIS installer could be useful - particularly if a set of
>> pre-defined functions were included with the setup that made use of
PL/R
>> for spatial statistical operations within PostGIS. But this might get a
>> bit complicated, considering the requirements involved (e.g., having R
>> installed, as well as packages installed in R - such as deldir for
>> making voronoi polygons).
>>
>> Mike
>>
>> TECHER David wrote:
>>> Hi Jan,
>>>
>>> Before I made a mistake, all you want is only a win32-installer for
>>> PL/R?
>>>
>>> because I think you know that's postgis win32-installer already exist?
>>>
>>> See http://www.postgis.org/download/windows/
>>>
>>> --david;
>>>
>>>
>>> Jan Hartmann a écrit :
>>>> Hi folks (sorry for crossposting),
>>>>
>>>> Joe Conway just announced that PL/R will soon be available for
>>>> Windows. See the thread starting at:
>>>>
>>>>
http://gborg.postgresql.org/pipermail/plr-general/2007-June/000235.html
>>>>
>>>>
>>>> PL/R is an implementation of the statistical package R within
>>>> PostgreSQL. See:
>>>>
>>>> http://www.joeconway.com/plr/
>>>> http://www.r-project.org <http://www.r-project.org/>
>>>>
>>>> It's installed the same way as postGIS, but until now only a Linux
>>>> version was available. I have them both enabled on my server at SARA
>>>> computing center, and the functionality is unbelievable. My own
>>>> organisation, however, doesn't allow me to install Linux servers, and
>>>> even if they did, neither staff nor students would be willing or even
>>>> able to work with them. I guess this is not a unique situation, so
>>>> this Windows port is really important. Moreover, a PostgreSQl
>>>> implementation with full GIS and statistical functionality is
>>>> something that doesn't exist in the commercial world as far as I
know.
>>>> An easy installable Windows version would IMO really be a showpiece
>>>> for Open Source software. I would really appreciate if people in the
>>>> know on both these lists would put their heads together to implement
>>>> this. I don't really know much about Windows installers, but my
>>>> feeling is that it is not enormously difficult.
>>>>
>>>> Regards,
>>>>
>>>> Jan Hartmann
>>>>
>>>> Dr. J. Hartmann
>>>> Department of Geography
>>>> University of Amsterdam
>>>> _______________________________________________
>>>> postgis-users mailing list
>>>> [email protected]
>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>
>>>
>>>
>>>
>>>
___________________________________________________________________________
>>>
>>> Yahoo! Mail r�invente le mail ! D�couvrez le nouveau Yahoo! Mail
et son
>>> interface r�volutionnaire.
>>> http://fr.mail.yahoo.com <http://fr.mail.yahoo.com/>
>>> _______________________________________________
>>> 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
>
___________________________________________________________________________
Yahoo! Mail rinvente le mail ! Dcouvrez le nouveau Yahoo! Mail et son
interface rvolutionnaire.
http://fr.mail.yahoo.com <http://fr.mail.yahoo.com/>
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
------------------------------------------------------------------------
*The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended solely for the
addressee. If you received this in error, please contact the sender
and delete the material from any computer. *
------------------------------------------------------------------------
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
