Category Archives: curious

Barcelona trees

Coat of Arms Barcelona

|Catalan|English|

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!

show me those trees

Leave a comment

Filed under curious, Life, Maps

Barcelona traffic accidents 2018

Coat of Arms Barcelona

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

2 Comments

Filed under curious, Life, Maps

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 πŸ˜›

more

3 Comments

Filed under curious, Life, Maps

The DM16L (swiss micros or HP)

Almost half a decade ago (haha, fancy way to say 4 years) I purchased on a whim a beautiful calculator from swiss micros. I’ve been using the spartan dc in the command line since I discovered it and battled to understand what was going on. Quite similar to my first foray with vim almost 15 years go (oh well, getting old here). But since then, I got used to what’s called the Reverse Polish Notation, and swiss micros provides just that, RPN calculators.

This is a very niche post about a piece of hardware made out of love and nostalgia for the old HP calculators. I don’t even know why I write about it, more than it’s been my companion calculator for those 4 years, always in my backpack and I needed an excuse for a post.

more

Leave a comment

Filed under curious

Geo Django Raster Metadata

I’ve been using GeoDjango for some time now, and found myself in a situation where I wanted to retrieve raster metadata using the ST_MetaData function on some datasets stored in PostGIS.

To do so, you can of course use the raw function from the db Manager, but for this I went the extra mile (although, it’s more like the extra half-mile, since it’s very easy)

the ST_Metadata in GeoDjango

Leave a comment

Filed under code, curious, tips

Children of Time

Another book post, how boring!

Children of Time is one of those presents that I knew was coming (Pestering for it for quite some time), and once it was in my hand it took me a couple of weeks to finish, it is one of the most exciting science fiction books I’ve read in a while.

The idea is an interesting one. Humanity has reached a point where it starts colonizing and terraforming other planets, but disaster ensues, and we’re brought back to less technological times, while some of the terraformed planets still inhabited start their own story.

Flash forward lots of years from the fall of that technologically advanced civilization, the earth is dying, and some groups start some sort of Noah’s ark spaceship only with people inside with the hope that they can reach one of those old fabled terraformed planets. But they will have to deal with whatever has evolved there (hint, it has 8 legs).

Interestingly, those inhabitants are not painted as horrible mutations that humanity has to fight, but a relatable nascent civilization that has its own fears and hopes. The book dabbles in both storylines, one of the humans travelling and their social problems inside the spaceship, and the spiders, how their society progresses in strange ways for us, and their own way of seeing the world. All of it coming altogether for the book finale.

This is an open ended book, and as far as I’ve checked online the second book should come soon enough (2019 according to wikipedia)

Leave a comment

Filed under books, curious