On 02/11/2018 05:22 AM, Michael Treglia wrote: > Hi All, > > I have a file geodatabase with non-spatial tables that can be joined to > other spatial objects. Is there a best/easiest way to import the > non-spatial tables in R these days? > > I've seen some solutions here: > https://gis.stackexchange.com/questions/184013/read-a-table-from-an-esri-file-geodatabase-gdb-using-r > but figured I'd see if I'm missing anything within sf. > > If it helps, the dataset I'm looking at is here: > https://data.cityofnewyork.us/Environment/NYC-Urban-Tree-Canopy-Assessment-Metrics-2010/hnxz-kkn5 > > When I try sf::st_read, as follows, I get the subsequent error: >> comdists_data <- > sf::st_read(dsn=fgdb,table="LandCover_Metrics_NYC_Community_Districts_Version10C") > > Error in st_sf(x, ..., agr = agr, sf_column_name = sf_column_name) : > no simple features geometry column present.
I didn't even get that far. I tried: > st_read(dsn="NYC_20Urban_20Tree_20Canopy_20Assessment_20Metrics_202010.zip",table="LandCover_Metrics_NYC_Community_Districts_Version10C") Cannot open data source /tmp/NYC_20Urban_20Tree_20Canopy_20Assessment_20Metrics_202010.zip Error in CPL_read_ogr(dsn, layer, as.character(options), quiet, type, : Open failed. but I'm not sure about the dsn argument; in your example, it is not clear what fgdb stands for. I tried unzipping the file in a directory, and use the directory name for dsn, but without success. Would appreciate pointers to what I'm doing wrong. > > Thanks all - best regards, > Mike T > > [[alternative HTML version deleted]] > > _______________________________________________ > R-sig-Geo mailing list > R-sig-Geo@r-project.org > https://stat.ethz.ch/mailman/listinfo/r-sig-geo > -- Edzer Pebesma Institute for Geoinformatics Heisenbergstrasse 2, 48151 Muenster, Germany Phone: +49 251 8333081 _______________________________________________ R-sig-Geo mailing list R-sig-Geo@r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-geo