1 / 24

Once Upon A Datum: Graphing Crime Incidents with Google Charts – “ The Rapid Fire Version ”

Once Upon A Datum: Graphing Crime Incidents with Google Charts – “ The Rapid Fire Version ”. Michelle Minkoff , Interactive Producer, The Associated Press. Where to get resources. Bit.ly/onagraphingcrimestats Working sample These slides Formatted data, so you can play along

chuck
Download Presentation

Once Upon A Datum: Graphing Crime Incidents with Google Charts – “ The Rapid Fire Version ”

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Once Upon A Datum: Graphing Crime Incidents with Google Charts – “The Rapid Fire Version” Michelle Minkoff, Interactive Producer, The Associated Press

  2. Where to get resources • Bit.ly/onagraphingcrimestats • Working sample • These slides • Formatted data, so you can play along • Tutorial walkthrough • Cheat sheat with other charting tips/tricks to know • Find me to exchange ideas/ask questions/point out errors, etc. Best way is @michelleminkoff on Twitter or meminkoff@gmail.com.

  3. Crime stats released this week • Often, developing charts is done too fast to be done well, or done well, but not at deadline speed • Prepare for a story • Data released, what to do? Graphs help you report, and tell a story. • Go to FBI crime stats page: http://www.fbi.gov/about-us/cjis/ucr/crime-in-the-u.s/2010/crime-in-the-u.s.-2010

  4. How did categories of crime change (if at all)?

  5. What we’re after: michelleminkoff.com/crime-stats

  6. Ah, deadline! What graphing library to use? • What is a graphing library? Tradeoff of flexibility/difficulty • Protovis • Raphael • Flot • Google Image Charts • Google Chart Tools (prev. Google Visualization API)

  7. Get the data • Download an Excel file

  8. Format the data in Excel

  9. Excel > JSON • Use Mr. Data Converter - http://shancarter.com/data_converter/ • Paste data in top box

  10. Excel > JSON • Select JSON > Row Arrays • Copy text that is returned to you

  11. JSON > JSON file • Save that formatted data!

  12. Basic HTML

  13. Souped-up HTML

  14. Quick CSS

  15. Draw the graph

  16. Draw the graph (2/2)

  17. How do I choose my colors?

  18. Format numbers

  19. Insert it in HTML • As easy as bringing that code in and calling the drawVisualization() function from <script> tags in your CMS, and including the div name • But I’m not satisfied! • I want to switch states – enter the change fuction

  20. Changing states

  21. Put it all together

  22. How do I get it in my CMS/on my website? • CMS: Just need to load API • The inline script tag, loading the chart you’re using • Code that’s in our drawVisualization() function • A div with the same id that’s referred to in drawVisualization() • Whole page: Upload a four-file structure in same folder, like what we created today

  23. Voila! • And there you have it! • Thanks!

More Related