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

[Edzer Pebesma]

Bingo! Thanks,

On 02/11/2018 01:52 PM, obrl soil wrote:
> 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

-- 
Edzer Pebesma
Institute for Geoinformatics
Heisenbergstrasse 2, 48151 Muenster, Germany
Phone: +49 251 8333081