As I’ve been tracking the ongoing crisis in Syria I often felt I was only getting half the story not being able to read Arabic. This was especially frustrating when I’d check out all the rich data being generated by SyriaTracker. Citizens in Syria are reporting on the violence through social media and text messages creating a unique perspective. Ushahidi via Crowdmap does brilliant work powering the platform, but my lack of language skills limited what I could understand.
Fortunately Crowdmap has a great data download button – one of our favorite features of any platform. So, I downloaded the data and pushed it up into Google Spreadsheets. Turns out Google Spreadsheets has this brilliant feature that allows you to insert a translation function to a data cell. You just plug in:
=GoogleTranslate(“text”, “source language”,”target language”)
For the language you use the two letter ISO code for the language, and the Goog supports over 40. Since I wanted to translate from Arabic to English I plugged in:
=GoogleTranslate(A1, “ar”, “en”)
Then I just cut and paste the equation to all the cells I wanted translated. You can find the results at this URL. Then I grabbed the URL for the CSV link from the Google Spreadheet and loaded it into GeoCommons. For specifics on linking Google Spreadsheets to GeoCommons check out the post here. The end result was a dynamically linked dataset on GeoCommons that you can grab in a half dozen format or create maps/analysis with.
Can’t finish off without a custom map:
Welcome to the Esri DC Development Center blog. We write about features of our work on big data analytics, open platforms, and open data, what is new and exciting in the Esri and community, and general industry thought leadership and discussions of geospatial data visualization and analysis.
Please explore what we're working on and let us know if you have any questions or ideas!