[postgis-users] Combined Windows version of PostGIS/P-LR

Sun Jun 17 13:30:08 PDT 2007

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: postgis-users-bounces at postgis.refractions.net 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
>>>> postgis-users at postgis.refractions.net
>>>> 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
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> 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
postgis-users at postgis.refractions.net
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070617/9dcf8853/attachment.html>