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