File geodatabase (fgdb) includes numerous file geodatabase tables. As far as I know they exist as dbf files, but are within a Database.gdb.
In ArcCatalog, the file pathway resembles C:\Users\...\Database.gdb\Stats_AA.
How to read all of these dbf files into R (a statistical software)? What is the correct pathway to supply? The function used is read.dbf (in the foreign package).
Variants of
test<-read.dbf(file="C:/Users..Database.gdb/Stats_AA.dbf")
and
test<-read.dbf(file="C:/Users..Database/Stats_AA.dbf")
don't work. What's the correct "form" of the file name to be used, or, do I need to export all of the file geodatabase tables into some other form or location?
Answer
A simple solution is to use Table to dBase (multiple) to export your tables (Right click FGDB > Export > To dBase (multiple). You can also use this tool to export attribute tables contained within FGDB feature classes. Just drag and drop tables and or feature classes into the tool and specify an output folder. Of course, then you can loop through the folder containing the new dBase files using R.
No comments:
Post a Comment