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
Last revisionBoth sides next revision
tips:overpass [2020/11/17 15:51] – scipiotips:overpass [2020/11/17 15:59] – scipio
Line 25: Line 25:
  
 <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 34:
 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