We welcome Dani Latorre in this guest post to let him tell us about a little project in which he has used CartoDB as part of the development. Stay tuned for more stories like this, and if you want, just write and tell us your email@example.com
A couple of months ago I decided to look for information about food banks in Spain. After wasting a couple of hours searching, I found only information at FESBAL website (Federación Española de Bancos de Alimentos). But my objective was to collect all the information about food banks whether they were of that federation, religious organizations or totally self-managed organizations.
I don’t like charity, recently I read a Eduardo Galeano quote: “Unlike solidarity, which is horizontal and is exercised as equals, charity is practiced top-down, humiliates the recipient and never alteres one bit of power relations”. Agreeing with this quote and looking that government solidarity is low at this moment, it’s more important that someone can have a plate of food even for charity.
So I thought about putting my two cents in this front, creating a little project to map all food banks in Spain. CartoDB seemed the right tool for the job. And indeed it was! In less than 2 hours I had the raw data, I had done the map and I finished the integration with the website developed with Sinatrarb.
Let me walk you through the process.
In the CartoDB dashboard I created a new table importing the CSV data file. Once imported I used CartoDB’s georeference tool to automatically georeference using the food bank’s addresses (I had to add some latitudes/longitudes manually for a few rare addresses).
After that I created the visualization from that table and played with visualization wizards. Select map marker styles, infowindows content, map tiles…
The web is also integrated with CartoDB, using SQL API to show all the food banks in a simple list and to allow visitors to add more food banks. In my opinion it’s a powerful API if you have a minimal knowledge about SQL and to handle JSON responses.
In the list only georeferenced food banks are being shown. I’m not showing those who are not yet georeferenced; so I’m using this mechanism to moderate submitted content until it gets reviewed and georeferenced.
Even if you don’t know much about Ruby, the code is pretty self explanatory:
Adding new food banks is also quite evident with a minimum knowledge of SQL, as shown in this code snippet:
As the number of infections and deaths from COVID-19 rises around the world there is understandably a high degree of stress, anxiety and grief from those directly affected ...Use Cases
Since their beginnings in 14th century Turkey, coffee and coffeehouses have had a significant cultural impact, and green, unroasted coffee is one of the most traded agricul...Use Cases
Socio-economic inequalities in the UK have remained persistently high over the last forty years. In the UK, the Gini coefficient, a commonly used measurement of inequality,...Use Cases
Please fill out the below form and we'll be in touch real soon.