Differences

This shows you the differences between two versions of the page.

--- tips:overpass [2020/11/16 18:40] – created scipio
+++ tips:overpass [2020/11/17 15:59] – scipio
@@ Line 5: / Line 5: @@
 select box and export all streets
 <code>
-[out:json][timeout:25];
+[out:xml][timeout:25];
 (
   way["highway"]({{bbox}});
@@ Line 13: / Line 13: @@
 >;
 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>