Group items tagged

How to use APIs from Twitter, Google & Facebook to find data, ideas by Katharine Jarmul Published Aug. 8, 2011 1:27 pm Updated Aug. 9, 2011 12:02 am As more and more journalists are finding, APIs are a great way to get data for your Web applications and projects. An API, or application programming interface, enables software programs to communicate with one another. (Chrys Wu wrote a helpful intro here.) To give you a better understanding of how they can help you, I’ve outlined some of the best APIs for finding content and explained how you can use open-source programming tools to glean information from them.

Constructing the Open Data Landscape Posted on September 7, 2011 by Nicola Hughes In an article in today’s Telegraph regarding Francis Maude’s Public Data Corporation, Michael Cross asks: “What makes the state think it can be at the cutting edge of the knowledge economy“. He writes in terms of market and business share, giving the example of the satnav market worth over $100bn a year yet it’s based on free data from the US Government’s GPS system. He credits the internet revolution for transforming public sector data into ‘cashable proposition’. We, along with many other start-ups, foundations and civic coding groups, are part of this ‘geeky world’ of Open Data. So we’d like to add our piece concerning the Open Data movement. Michael has the right to ask this question because there is this constant custodial battle being fought every day, every scrape and every script on the web for the rights to data. So let me tell you about the geeks’ take on Open Data.

Understanding how to clean  data is an important skill every reporter needs. Demographic, financial and other data is available on a city, county, state and national level in the United States. But understanding how to take a large data file and distill it into a usable form can be daunting. In this tutorial, you'll learn how spreadsheets work, basic data-cleaning workflow and how to use formulas and functions to clean data. This is a general tutorial and it doesn't delve deeply into one program. We'll use Microsoft Excel but most of the same techniques work in Google Spreadsheets and other programs.

<< previous blog | recent blogs | next blog >> #bbcsms: BBC processes for verifying social media content Alex Murray | Wednesday 18 May 2011, 10:40 From Tunisia, via Egypt, to Libya and Syria, verifying and acquiring eyewitness/citizen journalist/user-generated content has become increasingly complicated as the material has become more sophisticated. At the UGC (user-generated content) Hub in the BBC Newsroom in London, our process has become much more forensic in nature and includes: - Referencing locations against maps and existing images from, in particular, geo-located ones. - Working with our colleagues in BBC Arabic and BBC Monitoring to ascertain that accents and language are correct for the location. - Searching for the original source of the upload/sequences as an indicator of date. - Examining weather reports and shadows to confirm that the conditions shown fit with the claimed date and time. - Maintaining lists of previously verified material to act as reference for colleagues covering the stories. - Checking weaponry, vehicles and licence plates against those known for the given country. That's not an exhaustive list, but those are some of the most common things we do in BBC News.

Reactions to Osama bin Laden’s death: Female and non-U.S. residents more ambivalent. Via the NYT Reactions Matrix

Beautiful but Terrible Pyramids: Tableau Edition by Jorge Camoes on July 12, 2011 // Well, here is my first chart in Tableau, finally! After publishing my experiments with population pyramids (using Excel), I thought I could try Tableau Public with the same dataset from the US Census Bureau. Here is the result. I never really played before with Tableau Public and it took my less than an hour to upload the data and make this chart, without reading a manual or watching a tutorial (changing line colors was the hard part). It says a lot about its usability.

A bold experiment in distributed education, "Introduction to Databases" will be offered free and online to students worldwide during the fall of 2011. Students will have access to lecture videos, receive regular feedback on progress, and receive answers to questions. When you successfully complete this class, you will also receive a statement of accomplishment. Taught by Professor Jennifer Widom, the curriculum draws from Stanford's popular Introduction to Databases course. A syllabus and more information is available here. Sign up below to receive additional information about participating in the online version when it becomes available.

Shape to Fusion Hi. This website lets you import a shapefile to Google Fusion Tables. This blog post has some details on how it was built. To continue, you will need to authorize this site to access your Fusion Tables data on your behalf. Site by Josh Livni. Source code available at http://code.google.com/p/shpescape/

Download Download your Esri Maps for Office. Esri Maps for Office requires Office 2010 or later. Esri Maps for Office Add-In (x86) 32-bit (70MB) Esri Maps for Office Add-In (x64) 64-bit (70MB) Download the version of Esri Maps for Office that matches the bit version of Microsoft Office 2010 you have installed, not the version of your operating system (OS). If you are not sure, open Excel (or other Office application), click the File tab, and select Help. In the About Microsoft Excel section on the right, the version information states whether the Microsoft Office 2010 installation is 32-bit or 64-bit. Once your download is complete, open Excel.

Places & Spaces: Mapping Science is meant to inspire cross-disciplinary discussion on how to best track and communicate human activity and scientific progress on a global scale. It has two components: the physical part supports the close inspection of high quality reproductions of maps for display at conferences and education centers; the online counterpart provides links to a selected series of maps and their makers along with detailed explanations of how these maps work. The exhibit is a 10-year effort. Each year, 10 new maps are added resulting in 100 maps total in 2014.