Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- gisinternals [2026/03/24 03:34]
jango
+++ gisinternals [2026/03/31 18:00] (aktuell)
jango
@@ Zeile 1: / Zeile 1: @@
-[[https://www.gisinternals.com/query.html?content=filelist&file=release-1929-gdal-3-12-1-mapserver-8-6-0.zip99
+[[OpenStreetMap]]-Tool
-https://www.gisinternals.com/query.html?content=filelist&file=release-1929-gdal-3-12-1-mapserver-8-6-0.zip<code>
+GDAL [[https://www.gisinternals.com/query.html?content=filelist&file=release-1929-gdal-3-12-1-mapserver-8-6-0.zip]]
-ogrinfo.exe C:\chroot\xampp\htdocs\at.pmtiles poi
+<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 C:\chroot\xampp\htdocs\haltestellen.geojson C:\chroot\xampp\htdocs\at.pmtiles -sql "SELECT * FROM poi WHERE subclass = 'bus_stop'"
+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>

MBCDN

Benutzer-Werkzeuge

Webseiten-Werkzeuge

Unterschiede

Seiten-Werkzeuge