Evolving roads
ߊ߬ ߟߊߦߟߍ߬ߣߍ߲߬ ߦߋ߫ joost schouppe ߓߟߏ߫ 18 January 2017 ߦߋ߫ English ߟߋ߬ ߘߐ߫ ߟߊ߬ߞߎ߬ߘߦߊ߬ߟߌ߬ ߞߐߟߕߊ 27 January 2017 ߘߐ߫In my quest to understand the growth of OSM, I had a little fun today.
I took the 1/1/2017 full history dump for Brussels and I extracted a shapefile with all the versions of all the highway=* that ever existed.
Then I wanted to visualize it to see if there was a pattern in how the roads get mapped: “first real roads, then paths” or “everything all the time”. So I styled the paths clear green, the roads thin black and used a gray background for the current highways. Then I rendered a slide for every month.
It looks really cool, because it doesn’t just show the chaos of our growth. As the black roads are drawn slightly transparent and the monthly slide shows every version of the road in that month, “active areas” show up in heavy black. I think it’s really pretty.
On the occasion that it was a featured image in the Weekly OSM, I made a new version without a gray background and with a more logical image size.
You can download the individual images here and the shapefile (ugh, a shapefile) here
Discussion
ߡߙߌߣߊ߲ ߞߊ߬ ߝߘߊ߫ tyr_asd ߟߊ߫ 18 January 2017 at 17:21 ߘߐ߫
Very nice! Did you use osm-history-renderer to extract the geometries from the history dump, or something else?
ߡߙߌߣߊ߲ ߞߊ߬ ߝߘߊ߫ joost schouppe ߟߊ߫ 18 January 2017 at 19:09 ߘߐ߫
I do use the splitter and importer from that toolchain, but I used psql2shp to extract the data I needed. (I don’t know enough Postgres to be able to do much rendering directly from there, and the renderer itself uses the previous generation OSM rendering which I don’t know how to tweak)
ߡߙߌߣߊ߲ ߞߊ߬ ߝߘߊ߫ derFred ߟߊ߫ 19 January 2017 at 07:22 ߘߐ߫
Pretty cool ;-)
ߡߙߌߣߊ߲ ߞߊ߬ ߝߘߊ߫ jinalfoflia ߟߊ߫ 30 January 2017 at 13:23 ߘߐ߫
This is so cool! :-)
ߡߙߌߣߊ߲ ߞߊ߬ ߝߘߊ߫ florinbadita_telenav ߟߊ߫ 13 September 2017 at 12:08 ߘߐ߫
On what version of linux did you used the importer ?
I`m trying to compile on 16.04, with no luck :(
ߡߙߌߣߊ߲ ߞߊ߬ ߝߘߊ߫ joost schouppe ߟߊ߫ 13 September 2017 at 15:05 ߘߐ߫
I used Ubuntu 14 something. I have a vagrant file that does most of the installing, would that help you? That one does install a very old Postgress version, I’m not sure it would work with a newer version too. There’s also a recent thread (in Spanish); in Chile someone played around with this tool too.
ߡߙߌߣߊ߲ ߞߊ߬ ߝߘߊ߫ florinbadita_telenav ߟߊ߫ 14 September 2017 at 07:19 ߘߐ߫
Hei, it would help, installing directly with the instruction does not seem to work.