tips:overpass

This is an old revision of the document!


Overpass

https://overpass-turbo.eu/

select box and export all streets

[out:xml][timeout:25];
(
  way["highway"]({{bbox}});
);

out body;
>;
out skel qt;

export data in OSM

create db

spatialite_osm_net -o fes.osm -d fes.sqlite -T roads
echo 'SELECT CreateSpatialIndex('roads', 'geometry');' | spatialite  fes.sqlite
SELECT a.pos,b.name FROM knn AS a JOIN roads AS b ON (b.id = a.fid) WHERE f_table_name = 'roads' AND ref_geometry = MakePoint(-5.01057, 34.020940) and max_items=2;

sqlite3 /tmp/test.db
SELECT load_extension('mod_spatialite');
//SELECT load_extension('/lab/gianoobserver/lib38/lib/mod_spatialite');


SELECT ImportGeoJSON('./fes.geojson', 'test');
  • tips/overpass.1605623791.txt.gz
  • Last modified: 2020/11/17 15:36
  • by scipio