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

Sun Jun 17 13:55:40 PDT 2007

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