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:
Think about this time last year and ask yourself these questions: Has your office location changed? Are you or your family living in a different location? Are you shopping...Use Cases
This project was a collaboration between, SafeGraph, a data company seeking to understand the world and power innovation through open access to geospatial data, Spatial.ai,...Use Cases
Across the globe, real-time dashboards to understand COVID-19 trends are not just reaching data analytics or spatial analysis audiences - they have also become a key part o...Use Cases
Please fill out the below form and we'll be in touch real soon.