Access PostGIS from R on Windows XP

Question

Is there any easy way how to access PostGis data in R on Windows XP?

I thought I can try rgdal, but there is no easy way how to add PG driver (see file.show(system.file("README.windows", package="rgdal")). Therefore this simple piece of code does not work:

library(rgdal)
mylayer <-readOGR(dsn="PG:host=localhost user=MyUser dbname=MyDb password=Secret port=5432", layer = "MyLayer", verbose = TRUE)

Then I have found qGIS plugin called manageR. Unfortunately, there is a dependency to rpy2 plugin which is not available anymore.

I have no problems using shapefiles, but my intention was to integrate postgis data with current data warehouse and then use R for analytics.

Is there any known simple way how to use PostGIS and R or I have to change OS?

Answer 1

This question has been previously dealt with on the r-sig-geo mailing lists.

Searching for 'postgis rgdal windows' on rseek.org finds previous discussions.

In short - not positive, because the windows rgdal is compiled using a minimal set of drivers - because compiling for lots of others - all of which have different versions - would just transpose the problem into one of the wrong version or missing postgis (in this case).

Going via FWtools may be an option.