This is an old revision of the document!
Overpass
select box and export all streets
[out:xml][timeout:25]; ( way["highway"]({{bbox}}); ); out body; >; out skel qt;
export data in OSM
create db
spatialite_osm_net -o fes.osm -d fes.sqlite -T roads echo 'SELECT CreateSpatialIndex('roads', 'geometry');' | spatialite fes.sqlite
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.007247, 34.032262) and max_items=2;
sqlite3 /tmp/test.db SELECT load_extension('mod_spatialite'); //SELECT load_extension('/lab/gianoobserver/lib38/lib/mod_spatialite'); SELECT ImportGeoJSON('./fes.geojson', 'test');