[GIS] Splitting other_tags from .osm file

ogr2ogropenstreetmapother-tags

I am converting an .osm file to a .shp file with OGR2OGR:

ogr2ogr.exe --config OSM_USE_CUSTOM_INDEXING NO -skipfailures -f "ESRI Shapefile" output.shp input.osm

In osmconf.ini the other_tags is set to "yes" (other_tags=yes).

This creates an attribute other_tags which consists of a huge block of text, containing a lot of different tags.

Is it possible to somehow tell the OGR2OGR to split the other_tags into all of those tags it contains?

I searched, and found out that both in ArcGIS and QGIS there are options on how this can be done. but I am interested in doing it from OGR2OGR only.

Best Answer

In QGIS 3.6, it is now possible to explode the "other_tags" HStore field. The algorithm will create one field for each unique key.

Related Solutions

[GIS] How to search within a string to extract data from OSM other_tags

I'd suggest an alternative approach: Download raw OSM data and use OGR to prepare your data in such a way that the relevant tags are not mashed together in the "other_tags" column. This can be achieved by customizing OGR's osmconf.ini file as documented in http://www.gdal.org/drv_osm.html.

Look for the lines

# keys to report as OGR fields
attributes=name,highway,waterway,aerialway,barrier,man_made

and add your keys such as foot, horse, and tracktype.

Then you can, for example, create a Spatialite database using ogr2ogr

>ogr2ogr -f "SQLite" -dsco SPATIALITE=YES -spat 2.59 46.58 -1.44 47.07 noirmoutier.db noirmoutier.pbf

as described in http://anitagraser.com/2014/05/31/a-guide-to-googlemaps-like-maps-with-osm-in-qgis/

[GIS] ogr2ogr clip all shapefiles in a directory

Modifying the referenced answer, in the Windows command line:

for /R %f in (*.shp) do ogr2ogr "%~dpnf_clipped.shp" -clipsrc clipper.shp "%f"

You just add _clipped to the output. Note, this will also clip the clipping file, and work recursively, so it will also clip the shapefiles in sub-folders.

If you don't want it recursive:

for %f in (*.shp) do ogr2ogr "%~dpnf_clipped.shp" -clipsrc clipper.shp "%f"

To run it into a subfolder without changing names of the files, although it cannot create the folder, so an empty "clipped" folder needs to exist:

for %f in (*.shp) do ogr2ogr ".\clipped\%~nf.shp" -clipsrc clipper.shp "%f"

And finally for a different folder in the same path. So instead of "C:\data" to get it into "C:\clipped" you can do:

for %f in (*.shp) do ogr2ogr ".\..\clipped\%~nf.shp" -clipsrc clipper.shp "%f"

Like with the previous command, that folder needs to exist.

Best Answer

Related Solutions

[GIS] How to search within a string to extract data from OSM other_tags

[GIS] ogr2ogr clip all shapefiles in a directory

Related Question