search

CartoDB / cartodb

Location Intelligence & Data Visualization tool
http://carto.com
BSD 3-Clause "New" or "Revised" License
2.75k stars 652 forks source link

Importer should support File Geodatabase #2610

Closed pramsey closed 6 years ago

pramsey commented 9 years ago

File Geodatabase (fgbd) is now a very common format in the professional GIS world: folks building geodata will likely have these files lying around their desks. OGR supports reading file geodatabase as of 1.11 using the "OpenFileGeodatabase" driver. FGDB files can contain multiple tables, so one FGDB import might create multiple tables in CartoDB.

FGDB can also contain non-spatial tables that relate to the spatial ones (commonly, FGDB data is better normalized than Shape data). They can also contain hundreds of files. In general, being able to select which tables get imported will be the next feature requested once the basic format support is added.

andrewbt commented 9 years ago

+1000 would recommend to a friend

ztephm commented 9 years ago

It's being requested by users in S/B: 5467978

jaimecartodb commented 9 years ago

Several big clients asking for this. +1

nygeog commented 8 years ago

File Geodatabase is a really robust format for creating GIS data, w/ domains, and topology rules, it is really great for creating new data. Certain industries in GIS really love the database schema's and guidelines w/ FGDB put forth by Esri and other industry leaders. Also, it can hold a huge amount of data.

xavijam commented 7 years ago

There has been no activity on this issue for more several months. We are closing it. If you think this still needs to be addressed please open a new issue.

pramsey commented 6 years ago

@inigomedina this should be low-hanging fruit now, since OGR supports FGDW read natively now, no extra libraries required

inigomedina commented 6 years ago

Sounds great @pramsey.

In terms of user experience, it would be a good feature, for sure.

How do you feel about it in terms of our codebase? Could we go directly for an implementation of this? Would we need to prepare anything previously?

pramsey commented 6 years ago

The current importer GDAL version seems to be pegged at 2.1 (would be nicer if it was 2.2.3, but hey) and OpenFGDB driver dates back to 1.11 so from a core infrastructure point-of-view, everything should already be in place. The same logic that can handle a GPKG import, which is also a multi-layer format, should be able to handle an FGDB import.

inigomedina commented 6 years ago

Ok. Sounds good.

Do we have any kind of doc/spec describing this feature?

pramsey commented 6 years ago

Not to my knowledge. IMO anything more than "support FGDB import, make it work the same as GPKG" would be overkill.

nygeog commented 6 years ago

@pramsey awesome. Glad for this integration, makes Carto more enterprise-ready :) cc @andrewbt

ramiroaznar commented 6 years ago

Closing in favor of https://github.com/CartoDB/cartodb/issues/10730