This presentation was originally presented at the Library 2.019 "Open Data" virtual conference on June 5, 2019.

PDF of slide deck

Direct links to tools:

Planning and Pondering

1) Define it in a fun way for stakeholders!
https://theodi.org/article/what-is-open-data-and-why-should-we-care/

2) Find resources that support and justify and prototype open data initiatives:
http://opendatahandbook.org/resources/

3) Get some community context with resources from NNIP:
https://www.neighborhoodindicators.org/data-tech/training

Finding

4) Public Open Data Catalogs
https://data.gov ← US open data portal
(state / county / local portals)
US Library Data: https://imls.gov
MIT state GIS portal https://libguides.mit.edu/gis/states

5) Google Dataset Search
https://toolbox.google.com/datasetsearch

6) AwesomeData List
https://github.com/awesomedata/awesome-public-datasets

7) Base Map Cartographic Boundary Files from Census.gov
https://www.census.gov/geographies/mapping-files.html

8) Scrape it!
https://news.ycombinator.com/item?id=15694118

Managing & Wrangling

9) Google Sheets can import tables from web pages!
https://support.google.com/docs/answer/3093339?hl=en

10) The Linux/OSX command line!
https://github.com/rufuspollock/command-line-data-wrangling

11) R 
https://www.r-project.org/about.html
https://software-carpentry.org/lessons/

12) Clean it up!!  OpenRefine:
http://openrefine.org/

13) Parse and manage massive amounts of it with PapaParse JS CSV parser:
https://www.papaparse.com/

14) Geocoding with Google Sheets!
http://willgeary.github.io/data/2016/11/04/Geocoding-with-Google-Sheets....

15) (USA) Geocode from Census.Gov (10K limit/batch):
https://geocoding.geo.census.gov/geocoder/locations/addressbatch?form

16) Data Science Toolkit:
http://www.datasciencetoolkit.org/

17) Protect Patron Privacy by Anonymizing (De-Identifying) Data:
https://queue.acm.org/detail.cfm?ref=rss&id=2838930

Presentation and Visualization

18) CSV=>HTML TABLE:
https://github.com/derekeder/csv-to-html-table

19) Tableau Public:
https://public.tableau.com/en-us/s/
https://www.emeraldinsight.com/doi/abs/10.1108/LHTN-02-2018-0008?af=R&
https://datasf.org/academy/intro-to-tableau/

20) Historical Map Georeferencing Tutorial:
https://www.nypl.org/blog/2015/01/05/web-maps-primer
example: http://publications.newberry.org/faith-in-the-city/

21) Spot Data-Viz-Liars By Learning The Data-Viz Cheat Techniques!
http://nautil.us/issue/19/illusions/five-ways-to-lie-with-charts

22) WebJunction's Data Viz for Libraries Webinar:
https://www.webjunction.org/events/webjunction/data-visualization-for-th...

23) DataVisualization.ch's Selected Viz Tools Explorer:
http://selection.datavisualization.ch/

24) Publish it with Data Catalog Software!
https://ckan.org/
https://getdkan.org/

25) Start or join your local open data movement:
https://brigade.codeforamerica.org/
https://codeforall.org/