[[OpenStreetMap]]-Tool

GDAL [[https://www.gisinternals.com/query.html?content=filelist&file=release-1929-gdal-3-12-1-mapserver-8-6-0.zip]]

<code>
ogrinfo at.pmtiles
ogrinfo.exe at.pmtiles poi -so
ogrinfo.exe at.pmtiles -dialect SQLite -sql "SELECT DISTINCT class FROM poi"
ogrinfo.exe at.pmtiles -dialect SQLite -sql "SELECT DISTINCT class FROM poi" -feature -json

ogrinfo.exe at.pmtiles building -so
</code>

<code>
ogr2ogr.exe -f GeoJSON -t_srs EPSG:4326 tram.geojson at.pmtiles -sql "SELECT * FROM poi WHERE subclass = 'tram_stop'"

ogr2ogr.exe -f GeoJSON -t_srs EPSG:4326 bus.geojson at.pmtiles -sql "SELECT * FROM poi WHERE subclass = 'bus_stop'"
</code>

<code>
ogr2ogr.exe -f GeoJSON -t_srs EPSG:4326 tram.geojson austria.osm.pbf points -sql "SELECT * FROM points WHERE other_tags LIKE '%\"railway\"=>\"tram_stop\"%'" -dialect sqlite

ogr2ogr.exe -f GeoJSON -t_srs EPSG:4326 bus.geojson austria.osm.pbf points -sql "SELECT * FROM points WHERE highway = 'bus_stop'" -dialect sqlite
</code>

<code>
ogr2ogr -f GeoJSON buildings.geojson input.osm.pbf multipolygons -where "building IS NOT NULL"
</code>

<code>
# supermarkets
ogr2ogr -f GeoJSON supermarkets.geojson wien.osm.pbf points -where "other_tags LIKE '%\"shop\"=>\"supermarket\"%'
# Restaurants
ogr2ogr -f GeoJSON restaurant.geojson wien.osm.pbf points -sql "SELECT * FROM points WHERE other_tags LIKE '%\"amenity\"=>\"restaurant\"%'" -dialect sqlite
</code>

<code>
ogr2ogr -f GeoJSON bus-stops.geojson wien.osm.pbf points -where "highway = 'bus_stop' OR (other_tags LIKE '%\"bus\"=>\"yes\"%' AND (other_tags LIKE '%\"public_transport\"=>\"platform\"%' OR other_tags LIKE '%\"public_transport\"=>\"stop_position\"%'))"

ogr2ogr -f GeoJSON tram-stops.geojson wien.osm.pbf points -where "(other_tags LIKE '%\"tram\"=>\"yes\"%' AND (other_tags LIKE '%\"public_transport\"=>\"platform\"%' OR other_tags LIKE '%\"public_transport\"=>\"stop_position\"%'))"

# nur ubahn stationen
ogr2ogr -f GeoJSON subway-stops.geojson wien.osm.pbf points -where "(other_tags LIKE '%\"subway\"=>\"yes\"%' AND (other_tags NOT LIKE '%\"public_transport\"=>\"platform\"%' AND other_tags NOT LIKE '%\"public_transport\"=>\"stop_position\"%'))"

# ubahn stationen und bahnsteige extra
ogr2ogr -f GeoJSON subway-stops.geojson wien.osm.pbf points -where "(other_tags LIKE '%\"subway\"=>\"yes\"%' AND (other_tags LIKE '%\"public_transport\"=>\"platform\"%' OR other_tags LIKE '%\"public_transport\"=>\"stop_position\"%'))"

# nur train stationen
ogr2ogr -f GeoJSON train-stops.geojson wien.osm.pbf points -where "(other_tags LIKE '%\"train\"=>\"yes\"%' AND (other_tags NOT LIKE '%\"public_transport\"=>\"platform\"%' AND other_tags NOT LIKE '%\"public_transport\"=>\"stop_position\"%'))

# train stationen + bahnsteige extra
ogr2ogr -f GeoJSON train-stops.geojson wien.osm.pbf points -where "(other_tags LIKE '%\"train\"=>\"yes\"%' AND (other_tags LIKE '%\"public_transport\"=>\"platform\"%' OR other_tags LIKE '%\"public_transport\"=>\"stop_position\"%'))"
</code>