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

[obrl soil]

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.pebesma at 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 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
>
> _______________________________________________
> R-sig-Geo mailing list
> R-sig-Geo at r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-geo