Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revisionBoth sides next revision | ||
tips:overpass [2020/11/17 09:24] – scipio | tips:overpass [2020/11/17 15:36] – scipio | ||
---|---|---|---|
Line 5: | Line 5: | ||
select box and export all streets | select box and export all streets | ||
< | < | ||
- | [out:json][timeout: | + | [out:xml][timeout: |
( | ( | ||
way[" | way[" | ||
Line 13: | Line 13: | ||
>; | >; | ||
out skel qt; | out skel qt; | ||
+ | </ | ||
+ | |||
+ | export data in OSM | ||
+ | |||
+ | create db | ||
+ | < | ||
+ | spatialite_osm_net -o fes.osm -d fes.sqlite -T roads | ||
+ | echo ' | ||
+ | </ | ||
+ | |||
+ | |||
+ | <code/ | ||
+ | SELECT a.pos, | ||
+ | WHERE f_table_name = ' | ||
</ | </ | ||
Line 19: | Line 33: | ||
sqlite3 / | sqlite3 / | ||
SELECT load_extension(' | SELECT load_extension(' | ||
+ | //SELECT load_extension('/ | ||
- | SELECT ImportGeoJSON(' | + | SELECT ImportGeoJSON(' |
</ | </ |