Coming back with another bcn map. this time I’m not representing anything from open data, but I’m playing around the network analysis tool available with Qgis. The following distances map has been generated using those tools:
Tag Archives: life
Barcelona unemployment evolution 2012-2019
Keeping with the row of Barcelona data, I present here a map of the unemployment rate per neighbourhood since 2012 up to 2019.
The data comes from Barcelona open data estat-atur-pes dataset. This dataset contains the column pes_atur for each month of each year. In the presented visualizations I simply used the value of January for each year.
pes_atur is the percentage of the unemployed registered citizens in each neighbourhood over the number of registered citizens for that neighbourhood with ages comprised between 16 and 64 years old.
Long definition, but clear idea.
Again, using a choropleth map similar to the one from the mean rent prices map. I just used a different colour scheme from white (almost no unemployment) to red (heavy unemployment).
First an animated gif of all the maps:
And now, all the individual maps per year.
There was no data prior to 2012, so what we can mostly see from here is a kind of recovery from the 2009 financial crisis. We come from 2012 when most neighbourhoods had over 11% of registered unemployment, to 2019 when we can see lighter tones, showing unemployment rates under 9% in most areas.
This is clearly not an in-depth review, just a quick take on the presented data. More information can be seen in the official Barcelona website, or the small publications from newspapers.
References
Barcelona trees
Here I am again, this time with something that I love, trees!
It’s mostly common knowledge that the tree of Barcelona is the Platanus (bear with me with tree names, since the names in english confuse me most of the time 🙂 ). I’ve been looking for an excuse to dive back to Barcelona open data, and to create a hex-grid-map.
For this two images, I’ve used the street trees dataset, which only takes into account trees planted along streets, parks and green zones are not taken into account.
And from this excuse, two new data visualizations emerged!
Barcelona traffic accidents 2018
Following the quick map of Barcelona mean renting prices, I took it to play a little bit more with datasets of Barcelona.
I came across an interesting one, traffic accidents in Barcelona, which could map quite nicely as a Heatmap:
Unsurprisingly there are accidents all over Barcelona, but the city center concentrates the highest amount of them.
The dataset splits the accidents by accident type (alcohol, bad signs etc), but the majority of points are classified as Not provided so there’s no way to prepare more specific maps.
There are datasets from 2014 upwards, to be frank, after checking them the hot points are more or less the same, so 2018 is probably enough to get an idea 🙂
Some extra fun (vehicle type)
I had some extra fun playing with this datasets, I filtered by different vehicle types to generate different heatmaps.
Buses are all over the place (which make sense, since those are running almost non-stop all over the city). On the other hand, Taxis are quite focused in the city center and l’Eixample, not surprising those being the most traffic packed zones.
Personal car accidents appear in the city center too, but we can see some highlights in the two arteries of the city, ronda de dalt and ronda litoral, those motorways are the main way to cross Barcelona connecting to bigger highways and neighbouring cities. There are daily jams in those two motorways.
Bike accidents appear mainly in the center, eixample and close to wide streets (like Diagonal and Meridiana). In other neigbourhoods it looks quite safe 🙂
Some extra fun (vehicle color)
Find here a clunky non-stylized bar graph of total accidents by vehicle colours. Colour names are in catalan, but the bars match the name so it’s quite international. Yes, apparently there’s a category for black-yellow vehicles, which I guess are Taxis.
What about the insurance myth about red cars?. Well, I don’t know about that, but it’s clear that there’s a big bar of red vehicles having accidents 🙂 But since I don’t have the number of red cars running around Barcelona it could just be that it’s a popular colour. White and Black cars are very common (from a quick walk around in Bcn you confirm that statement) and as you can see those have the most accidents.
To be safe, just buy a pink car 😉 (not really)
Conclusion
Making smallish maps of my area is fun, so I might get more datasets to present different aspects of Barcelona in the future :-D.
References
Barcelona Series
Barcelona mean rent price
A couple of Barcelona neighbourhood mean renting prices maps I’ve made today simply because…. no reason at all. I’m not performing any analysis of the provided data, just a picture 😛
The dropped posts, and 2017 closing
I’m not constant in my writing. Some ideas come, some ideas go, some get written, some get lost.
For the end of 2017 I deleted a backlog of drafts that were half written. Some of them were actually quite nice but unfinished. The problem being that I may have lost the content that was discussed in those posts, or just forgot what I was writing about. It’s not a new year’s thing, but let’s start clean here 😀
When I was ready to press the button I felt sad for those posts, so here’s a list of the posts lost in battle.
- Arduino Clock Time Reading. (The arduino clock posts)
- Arduino Clock Display usage. (more arduino clock posts)
- littlebits.cc (I never got around to even touch those, but looked awesome)
- A serial terminal with python and custom commands. (Used as a complement on embedded projects at IDNEO)
- DynamoDB Django Python middleware. (What a combo! but actually I’m using this daily :-p even if I barely remember what I did there)
- Static websites with Hugo. (Liked the idea, stayed in wordpress so far. With my combo of wordpress + it’s all text + gvim.. sadly It’s all text does not work anymore)
- Python and Pyinstaller. (It was mostly finished, but it seemed too shallow)
- Some book reviews (Never was too fond of them anyway)
- A small map I made after a short hike.
- A small classification of Barcelona neighbourhoods according to rent price and buildings age (Yes, I did that when hunting for a new apartment)
- A small labyrinth game in Game Boy assembler.
Nevertheless, 2017 has been a good year for me personally. Changed from an Embedded job too far away from home (1.5h commute by train) to an Embedded Linux job too close (5min walk), been very involved in a personal project and enjoyed my free time playing drums and kayaking 😀 .
Blogwise it is the first year that I ALMOST accomplished the one post per month mark! (sorry, summer is summer)… I am not a journalist and this blog is not my priority so it is surprising that I’ve found the time to keep it updated and half interesting. This year we had:
- Europe DBpedia map (an update of an old map)
- The Dbpedia live website map (I’ll keep it for a while, but since it costs me a little to maintain it will probably die),
- The excel to CSV (oh, I remember that nightmare),
- My new laptop (Not my best decision of 2017. I think that DELL was the way to go),
- Some vector graphics thingy with Inkscape (I’m a man of multiple faces),
- An example of using WMS in google earth
- Then the summer appeared, and I spent it kayaking around.
- A small set of git configuration
- The Tenma DC power supply controller via serial interface
- The Tenma DC power supply controller indicator
And the “previously” page got updated with a bunch of games and books that I liked this year. I played more than what I’ve read….. this is something to think about.
I never talk about the site stats. It is a small place after all. Nevertheless, this blog has maintained something like 1000 visits per month. That feels like a lot to me, so thanks to everyone who read my stuff and got something useful from it 😀
It has been a long way since I started in 2012, from a 25 year old guy that was bored during a master degree and wanted to improve his English writing skills, to a slightly older guy (you do the math) that is doing something completely different but enjoying it.
That’s it, no more retrospectives, 2017 has ended and we are still alive, let’s go to 2018.
PD: I have nothing written yet for 2018, I’m going to lose my monthly post combo 😛
Castells 