tips:overpass

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
tips:overpass [2020/11/17 15:51] – scipiotips: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; out body;
 >; >;
Line 25: Line 34:
  
 <code> <code>
-SELECT a.pos,b.name FROM knn AS a JOIN roads AS b ON (b.id = a.fid) +# 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;  WHERE f_table_name = 'roads' AND ref_geometry = MakePoint(-5.007247, 34.032262) and max_items=2;
 </code> </code>
Line 33: Line 43:
 sqlite3 /tmp/test.db sqlite3 /tmp/test.db
 SELECT load_extension('mod_spatialite'); SELECT load_extension('mod_spatialite');
-//SELECT load_extension('/lab/gianoobserver/lib38/lib/mod_spatialite'); 
  
  
-SELECT ImportGeoJSON('./fes.geojson', 'test');+
  
 </code> </code>
  • tips/overpass.txt
  • Last modified: 2020/11/17 16:36
  • by scipio