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 12:21] – 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 19: Line 28:
 create db create db
 <code> <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>
 +
 +
 +<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> <code>
 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