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

Mon Jun 18 09:07:01 PDT 2007

Hey all,

I'm just wondering if this thread should move back to the plr-general
list.  In particular, I think it would be good if Joe is able to add a
link to the installer on the PL/R web page.  I just tried the installer,
and it works great - nice work David.

I did notice, however, that it claims to be installing PgRouting in the
welcome screen, and it appears as PgRouting in the Windows uninstall
list.  Also, I think more than is needed is being added to the Path
variable.  In my case, this is what gets added after the installer is done:

"\;C:\Program Files\R\R-2.5.0\bin;C:\Program
Files\PostgreSQL\8.2\bin;C:\Program Files\PostgreSQL\8.2\lib"

When I had installed PL/R manually, I seemed to be able to get away with
adding just ";C:\Program Files\R\R-2.5.0\bin".  Also, if I happen to
re-install PL/R, the entire string above will appear multiple times in
the Path variable.  Is it possible for the installer to check for that?

Regards,
Mike

TECHER David wrote:
> Hi Regina,
> 
> Many thanks for these interesting link! Very excellent!
> 
> I will wait for the next series of your articles!
> 
> --david;
> 
> Obe, Regina a écrit :
>> 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. *
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 