This presentation was originally presented at the Library 2.019 "Open Data" virtual conference on June 5, 2019.
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/app
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: https://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/