my subscriptions
bittybrains 2 points

Routes were calculated from the API with Python

Sorry, that's what I meant. I imagine calculating all the route weights took far longer than generating the image itself, which is why I wondered whether a faster language could be used instead of Python, and maybe get away with not having to pre-process anything.

From the point of view of making this into an App, and especially for large maps, rather than having to wait ages for it to finish calculating all the routes before generating an image, it would be cool to watch it generate the routes in real-time, branching out slowly from your starting point.

I've downloaded some map data to play around with, thanks for sharing!

Tjukanov 3 points

Just to clarify, I had the (java) routing engine running locally on my machine and just did the API calls with Python. I think you can’t avoid pre-processing. But I would be happy to be wrong.

[deleted] 1 point

Did you try OSRM? It should be considerably faster.

Tjukanov 1 point

I have tried it, but setting up GraphHopper worked fast enough for my purpose.

Load more comments
ricckli 1 point

I know that arcmap can do this. Would be interested if Topi [OP] ever tried it out and wether he can compare both approaches.

Tjukanov 1 point


I don't have accessibility to any ESRI licenses at the moment as I do these just for fun on my own laptop. So no, I haven't tried it out.

tseepra 1 point

Great post, very thorough.

What's the background map on the train visualisation?

Tjukanov 2 points

Cheers. The background is all Finnish roads (and nothing else). It's open data and I have it in my PostGIS. Just looks like a background map when visualized that way.

Tjukanov 8 points

Five hours of train traffc from last Sunday in Finland animated. Circle size relative to train speed. Link to my original tweet 1. What is it with the circles? Can't you see the train speed anyhow from the animation? Sure, but I just thought it looked nice and made the trains look like bubbles. 2. What tools did you use? Python, PostGIS, QGIS with Time Manager plugin and GIMP 3. Where's the code for this? Well there's only the code for getting the data from the API (other things done in the database and on desktop software) and that's here 4. Can you do one for [insert country name here]? Sure if you point me to an open GeoJSON API first.

dkrupp24 3 points

Nice work! The circle size represents train speed? It could be interesting to test color instead, especially if the train speed is changing along the route. It might also help to add a supporting chart (maybe line?) to make the overall amount of traffic easier to see.

Tjukanov 2 points

Good idea. Thanks!

Tjukanov 16 points

It’s really simple Python script to get the data. I’ll put it to GitHub later.

Tjukanov 1 point

Here it is. And please note that I'm not really a Python dev, but hope this is helpful to someone:

stoic_goes 2 points

This is awesome. I’m a GIS Analyst but over the years have never ventured too far from the ESRI environment, mostly because my jobs have all been with ESRI software or proprietary tools. I’m starting to dip my toe into open source projects and would love to do projects like this in my free time.

Other than documentation, can you recommend any helpful resources or tutorials?

Tjukanov 1 point

YouTube is a great resource for QGIS stuff, as stupid as it may sound. Here’s one tutorial I wrote earlier

Welcome to the world of open source!

Load more comments
Space0asis 3 points

What do the different colors mean?

Tjukanov 4 points

The colors also represent the age. Dark purple = very old & light yellow = new. TBH maybe it needs a legend in the last frame.

Tjukanov 8 points

Year in the bottom right shows the year and buildings appear at the time when they were (according to the data) built. Thanks to u/daniskarma for the the great static maps with the same data. Those gave me the idea to do this animation. I mostly post this kind of stuff on my Twitter. Created with QGIS Time Manager + PostGIS.. Data can be found here.

Tjukanov commented on a post in r/dataisbeautiful
daniskarma 3 points

Of course, for theses maps I used a shortcut. QGIS has a plugin named Spanish Inspire Catastral Downloader that let you choose a province and automatically download the data. In the building layer you have a field named "end" which is the end of construction date.

If you want to make a manual donwload, you'll have to go to the catastro main page and select: "Descarga de datos y cartografía por municipio", then you have to donwload the shapefiles and the CAT files (which contain the age of construction data). But a electronic certificate is needed in order to download this data (It's free to make but it takes some paperwork to get one). I prefer to use the QGIS plugin.

All of this work for all Spain but Navarra and Euskadi, both of them have their own Catastro system. Althought the process is quite similar.

Tjukanov 1 point

Awesome maps and thanks for the data link. Loading the data now myself...

jurassicjesus 1 point

I would like to ask if you had a list of hurricanes that reached Indiana, obviously they would have been weaker tropical storm by then. But I'm still curious.

Tjukanov 1 point

Yes it could be extracted from the data.

MegadethRulz 1 point

Any chance you have the time to make this happen? I am quite interested in seeing this actually. I'm sure it would be a pain in the balls but it would be really interesting to see each path go through a color gradient corresponding to the the strength of the storm during its journey. I'm sure the data for that kind of thing would only be able to be applied to the more recent storms though.

Edit: Come to think of it, is there even record of the categories reached by each storm going back 100 years?

Tjukanov 2 points

I might do it in the whole world version. Thanks for the feedback.

Load more comments
Allanon124 1 point

I teach 6th grade social studies and would love to have a high res copy of this to put on my wall. Is that something you would be ok with?

Tjukanov 1 point

You mean doing a high res yourself? Sure, go for it! Meaning that I'd do a high res? Not promising anything, as I have quite a lot of other projects ongoing.

rakelllama 1 point

also /u/Tjukanov how did you pull the OSM road data into QGIS? I'm assuming that's a huge dataset and I thought with OSM you could only pull a certain extent at a time. Would be curious how you did it.

Tjukanov 1 point

The planet file has been imported to PostGIS

Load more comments
USITTravel 1 point

Hey, this is incredible congrats on such a cool project. We're an Irish travel company specialising in US travel and was hoping you'd allow us to share this with graphic with our audience with a full credit linking back to your Twitter/Reddit or other account? Thanks in advance, Donnacha USIT Travel

Tjukanov 2 points

Sure. Just add a link to my Twitter profile and remember to credit Openstreetmap (that's the original source of the road data) as their license requires by adding the following text there: "© OpenStreetMap contributors". Check:

jianantonic 1 point

Apologies if this has been asked, but I didn't see an answer -- what do the different colors represent? Boyfriend and I are arguing over this :)

Tjukanov 2 points

The dots are green, but the features have a blending mode where overlapping features turn lighter and eventually white. So more white --> more destinations are using that route.

Load more comments
33,743 Karma
27,915 Post Karma
5,828 Comment Karma

Following this user will show all the posts they make to their profile on your front page.

About tjukanov

  • Reddit Birthday

    July 17, 2017

Other Interesting Profiles

    Want to make posts on your
    own profile?

    Sign up to test the Reddit post to profile beta.

    Sign up