[R-sig-Geo] Create ESRI personal geodatabase (.mdb) in R?

Dan Putler dan.putler at sauder.ubc.ca
Fri Oct 23 21:11:14 CEST 2009


Hi Mark,

The natural way to do something like this in R is using the RGDAL
package to take advantage of the OGR library. At this time OGR has the
ability to read .mdb personal geodatabase files, but not write them, and
since R's functionality in this area is dependent on what the GDAL/OGR
library can do, I don't think you can avoid the third step in your
workflow. You could have R write out shapefile sets, which might be an
improvement over your current workflow.

Dan

On Fri, 2009-10-23 at 13:00 -0600, Mark Na wrote:
> Hello,
> I would like to write spatial data to an ESRI personal geodatabase (.mdb)
> and I wonder if anyone has experience with this.
> 
> My workflow, at present, is as follows:
> 
> 1. Read spatial data into R (from a .csv file).
> 
> 2. Manipulate the data in various ways.
> 
> 3. Export the data from R as a .csv file, import that into ArcGIS, add XY,
> save the data as a table in an existing personal geodatabase (.mdb).
> 
> I would like to automate step 3 by creating the .mdb in R and saving various
> dataframes as tables within the .mdb, so nothing has to be done in ArcGIS.
> 
> I would appreciate any help you might be able to provide with this.
> 
> Many thanks, Mark
> 
> 	[[alternative HTML version deleted]]
> 
> _______________________________________________
> R-sig-Geo mailing list
> R-sig-Geo at stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-geo
-- 
Dan Putler
Sauder School of Business
University of British Columbia



More information about the R-sig-Geo mailing list