The download wasn’t zipped correctly I think – after unzipping, add extension .gdb to the folder name.
@obrl_soil On Sun, Feb 11, 2018 at 10:47 PM, Edzer Pebesma <edzer.pebe...@uni-muenster.de> wrote: > > > 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 _______________________________________________ R-sig-Geo mailing list R-sig-Geo@r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-geo