[GIS] Convert GeoJSON directly to geodatabase

convertfile-geodatabasegeojson

I'm looking for a way to convert a GeoJSON File (from overpass-turbo.eu) directly into a Feature Class in an Esri geodatabase.

Normally I'm doing this by loading the GeoJSON into QGIS, Export it to a shapefile and then import it into ArcGIS Pro. There I can just export the data into my geodatabase. The problem is the limited space within the Attribute Table of shapefiles, which leads to a loss of data which I need in my current project.

Unfortunately I don't have access to the ArcGIS Data Interoperability Tool, so I have to find an open source way.

Best Answer

It is possible to use ogr2ogr:

ogr2ogr -f "FileGDB" output.gdb input.geojson

Related Solutions

[GIS] How to get WKT or GEOJson by country or city name with Overpass API

I would use the area feature of the Overpass API in order to achieve this goal.

[out:json];
area
   ["name"="France"]
   ["boundary"="administrative"]
   ["admin_level"="2"];
(._;(pivot:);>;);
out body qt;

Lines 2-5 are selecting the correct area.

Line 6 creates an union consisting of:

the area itself
the pivot element of this area (the relationship/way/... from which this area was generated)
the ways/nodes referenced by the pivot element

Line 7 just prints out the results. The qt parameter is just a performance optimization and not necessary (http://wiki.openstreetmap.org/wiki/Overpass_API/Language_Guide#order_attribute)

By setting admin_level to 2 you can make sure, that you will only get national borders. You will need to adapt this value in order to get different types of boundaries. A list of the meaning of admin_level's values can be found at http://wiki.openstreetmap.org/wiki/Admin_level#admin_level.

By the way: Areas are created by the Overpass-API server and are not part of the original OpenStreetMap database. Internally, the Overpass server is doing exactly what scai wrote: It is gathering together the data from relationships. (see wiki.openstreetmap.org/wiki/Overpass_API/Areas)

ArcGIS – How to Convert Shapefiles in Nested Folder to Geodatabase

This is a temporary fix to get your mxd files working. You can create an additional Alias to your data by using Windows symbolic links. This means you can make your data appear to be located at the old location for the mxds to open properly. The shapefiles, etc will not move or be copied. There is a command line tool called mklink that will create a link. You may only need a link to your root data folder. If you are interested in this, search the web for symbolic link or junction.

Best Answer

Related Solutions

[GIS] How to get WKT or GEOJson by country or city name with Overpass API

ArcGIS – How to Convert Shapefiles in Nested Folder to Geodatabase

Related Question