Differences

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

--- tips:overpass [2020/11/17 12:21] – scipio
+++ tips:overpass [2020/11/17 16:36] (current) – scipio
@@ Line 10: / Line 10: @@
 );
+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;
 >;
@@ Line 19: / Line 28: @@
 create db
 <code>
- spatialite_osm_raw -o fes.osm -d fes.sqlite
+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');
-//SELECT load_extension('/lab/gianoobserver/lib38/lib/mod_spatialite');
-SELECT ImportGeoJSON('./fes.geojson', 'test');
 </code>

Galileo Labs