[R-sig-Geo] Reading tables without geometry from gdb?

[Edzer Pebesma]

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 at 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