tips:overpass [Galileo Labs]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Overpass ======

https://overpass-turbo.eu/

select box and export all streets
<code>
[out:xml][timeout:25];
(
  way["highway"]({{bbox}});
);

out body;
>;
out skel qt;
</code>

selezionare direttamente l'area parcheggi di fes
<code>
[out:xml][timeout:25];
(way["highway"](34.02389, -5.01483, 34.04701, -4.99196););
out body;
>;
out skel qt;
</code>

export data in OSM

create db
<code>
spatialite_osm_net -o fes.osm -d fes.sqlite -T roads
echo 'SELECT CreateSpatialIndex('roads', 'geometry');' | spatialite  fes.sqlite
</code>


<code>
# MakePoint(longitude, latitude)
SELECT a.distance,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.007247, 34.032262) and max_items=2;
</code>


<code>
sqlite3 /tmp/test.db
SELECT load_extension('mod_spatialite');




</code>