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 revisionBoth sides next revision
tips:overpass [2020/11/17 12:21] – scipiotips:overpass [2020/11/17 15:36] – scipio
Line 19: Line 19:
 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/
 +SELECT a.pos,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.01057, 34.020940) and max_items=2;
 +</code>
 +
  
 <code> <code>
  • tips/overpass.txt
  • Last modified: 2020/11/17 16:36
  • by scipio