Re: [R] [R-sig-Geo] Connecting to PostgreSQL/PostGIS from R (rgdal?)

From: Tim Keitt <tkeitt_at_gmail.com>
Date: Wed, 30 May 2007 16:31:27 -0500

I would also recommend you take a look at RODBC for general purpose database access. My impression is that it has received a lot more maintenance attention lately.

I can't comment on the windows gdal binaries as I'm not too familiar with that platform.

THK On 5/30/07, Mike Leahy <mgleahy_at_alumni.uwaterloo.ca> wrote:
> Hello,
>
> I've been trying every now and then to find a cross operating system
> solution that would let me access PostgreSQL (and PostGIS) from R, or to
> access R from PostgreSQL. I know of pl/r, which accomplishes the
> latter, but has yet to be successfully ported to Windows. Similarly,
> I've tried to use Rdbi and DBI, but I haven't had luck with those on
> Windows either for connecting to PostgreSQL from R. Can anyone suggest
> a solution for this?
>
> It would seem that rgdal could also help me in this case. Unfortunately,
> the version of the GDAL library that is included in the rdgal binary
> available on CRAN (for windows) doesn't include the PostgreSQL driver
> for OGR (i.e., it's not listed by the ogrDrivers() function).
>
> I compiled rgdal on Windows myself using the GDAL library from
> FWTools-1.3.1, but I was unsuccessful at creating a proper binary
> package for R. I was only able to get it to work by substituting the
> rgdal.dll that was installed by CRAN with the one that I compiled that
> links against the GDAL library from FWTools. Even though it works (at
> first glance with ogrInfo(), and readOGR()), I still get a warning
> message when I load the libary: "DLL attempted to change FPU control
> word from 8001f to 9001f".
>
> So my question with respect to rgdal is a) is it likely that an rgdal
> package is going to be released in the future with the PostgreSQL driver
> included in GDAL/OGR, or b) are there any suggestions/instructions that
> might get me through the compilation and packaging process for rgdal
> with better success?
>
> Thanks in advance for any help,
> Mike
>
> _______________________________________________
> R-sig-Geo mailing list
> R-sig-Geo_at_stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-geo
>

-- 
Timothy H. Keitt, University of Texas at Austin
Contact info and schedule at http://www.keittlab.org/tkeitt/
Reprints at http://www.keittlab.org/tkeitt/papers/
ODF attachment? See http://www.openoffice.org/

______________________________________________
R-help_at_stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Received on Wed 30 May 2007 - 21:57:37 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 30 May 2007 - 22:31:16 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.