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:
Like many people who love trees and work in the geospatial field, I was fascinated (and disheartened) by a recent article I read in the New York Times called Since When Hav...Use Cases
Most Data Scientists and Analysts understand that visualizing datasets can be a crucial way for users to engage with data. Knowing where median household income is across a...Use Cases
The urban growth of metropolitan areas around the world can be affected by a number of factors. During the industrial revolution the explosion in job availability fueled mu...Use Cases
Please fill out the below form and we'll be in touch real soon.