Timeline for How to build a Spatialite road network from OSM data
Current License: CC BY-SA 3.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 20, 2013 at 11:38 | vote | accept | tema.krukovets | ||
| Nov 20, 2013 at 11:16 | comment | added | BradHards | Have you seen the tools and samples at gaia-gis.it/fossil/spatialite-tools/wiki?name=OSM+tools ? That should allow you to extract what you need. | |
| Nov 20, 2013 at 10:52 | answer | added | Uffe Kousgaard | timeline score: 1 | |
| Nov 20, 2013 at 10:24 | comment | added | scai | This is not quite correct. The first and the last node don't have to be links, the way can have one or even two open ends. Furthermore every node in the way can be part of one or more other ways, thus creating a junction. This is not limited to the first and last node. | |
| Nov 20, 2013 at 4:53 | comment | added | tema.krukovets | @BradHard Actually I don't understand how to define junctions(links) throw all this data. My first idea was that all ways could be used as the arcs of graph. But I'm not sure if they doesn't consist links inside them. I mean that in <way> first and last nodes always links and only they, whereas other nodes mentioned in this <way> is used only for geometry of they way. | |
| Nov 19, 2013 at 22:33 | history | edited | RyanKDalton | CC BY-SA 3.0 |
edited title
|
| Nov 19, 2013 at 21:33 | comment | added | BradHards | Extracting the coordinates shouldn't be a problem - you already have them (after all, you put them into the database at the start). What is the particular issue - writing the query, the wrong format, or something else? | |
| Nov 19, 2013 at 21:23 | comment | added | Mapperz♦ | Postgis does not need a server - it can run locally on a pc without issue. It can even be portable gis.stackexchange.com/questions/41060/… | |
| Nov 19, 2013 at 21:14 | review | First posts | |||
| Nov 19, 2013 at 21:26 | |||||
| Nov 19, 2013 at 21:08 | comment | added | tema.krukovets | @Mapperz yes, but using Postgres assumes working with "not-lite" SQL DB. In my opinion sqlite is better as it doesn't need server for working. | |
| Nov 19, 2013 at 21:03 | comment | added | Mapperz♦ | You would find it beneficial to use postGIS and postgres with pgrouting. example anitagraser.com/2011/02/07/a-beginners-guide-to-pgrouting | |
| Nov 19, 2013 at 20:57 | history | asked | tema.krukovets | CC BY-SA 3.0 |