Reading feature class in file geodatabase using R?

Question

I have a feature contained in a geodatabase that is larger than 2GB as an exported shapefile. I need to run an extract function in R to attribute the polygons with data from a raster file. Exporting the feature as a table is not a solution. How can I read feature classes contained within an Esri file geodatabase?

Answer 1

You can use rgdal to access feature classes in Esri file geodatabases.

require(rgdal)
# The input file geodatabase
fgdb <- "C:/path/to/your/filegeodatabase.gdb"
# List all feature classes in a file geodatabase
subset(ogrDrivers(), grepl("GDB", name))
fc_list <- ogrListLayers(fgdb)
print(fc_list)
# Read the feature class
fc <- readOGR(dsn=fgdb,layer="some_featureclass")
# Determine the FC extent, projection, and attribute information
summary(fc)
# View the feature class
plot(fc)

• Jeffrey Evans: Previously, you could only do this if you downloaded the ESRI filegeodatabase API and compiled GDAL against it. If you use OSGeo4W to install GDAL there is an option to do this automatically. However, this may have changed in later releases of GDAL and it could now be native so, if I am incorrect I apologize.
• Aaron: @JeffreyEvans This is native now.
• Cotton.Rockwood: While it is native for windows, it does not seem to be included currently for other platforms (at least Debian Jessie).
• whuber: +1 Works nicely. It helps to know that the layer argument may be omitted when there is just one feature class in the GDB.
• MichaelChirico: For those who know nothing about gdb files, fgdb in this answer here is a directory and ogrListLayers() works on this directory...

Answer 2

As already posted in this answer, this now also works very nicely with sf:

require(sf)
fc <- sf::st_read("C:/path/to/your/filegeodatabase.gdb", layer = "some_featureclass")

(削除) But writing into a fgdb ist not implemented (yet?), you'd have to have a ArcGIS / ArcMap License as well as the R library `arcgisbinding` (see https://github.com/R-ArcGIS/r-bridge) (削除ここまで)

---

Writing to a fgdb is now implemented as well

st_drivers()$write[st_drivers()$long_name == "ESRI FileGDB"]
#> [1] TRUE

• Jeffrey Evans: Writing is now implemented for gdal.org/drivers/vector/filegdb.html#vector-filegdb But, true to ESRI with the caveat: "The FileGDB SDK API does not allow to create a feature with a FID specified by the user. Starting with GDAL 2.1, the FileGDB driver implements a special FID remapping technique to enable the user to create features at the FID of their choice."