Open-Data-Policy---Tricks-and-Tips

• http://data.civicagency.org/offices
• http://data.civicagency.org/validate
• http://data.civicagency.org/changeset
• http://data.civicagency.org/digitalstrategy
• http://data.civicagency.org/datagov/csv_to_json
• https://github.com/GSA/data.gov/wiki/Resources-for-Data.json-Analysis

Convert JSON to CSV

• Great tool for this

How to count entries in a data.json file.

• Open json file in Chrome.
• Open the browser's console (f12 in chrome)
• enter: 'count entries'

##How to change comma-separated keywords into an array

• Info here

Common problems

• The public data listing automatically downloads instead of opening in the browser.

The problem is most likely some sort of mime type directives in the web server (apache, etc). You can put in directives in the config for webserver or .htaccess for each site that tells it to handle certain file extensions differently and even specify down to path.

• I need to get a table out of a PDF.
• Check out Tabula.