This guide assumes that you recently run brew upgrade postgresql and discovered to your dismay that you accidentally bumped from one major version to another: say 9.3.x to 9.4.x. Yes, that is a major version bump in PG land.
First let's check something.
brew info postgresqlThe top of what gets printed as a result is the most important:
| #Connects to the Socrata search API and loads data describing the tabular datasets in the catalog for use by D3 tree map | |
| #This version connects to a list of existing Socrata instances and loops through the ones categorized as city | |
| #Use: python dataportalapi.py > portaldata.json | |
| import requests, json, math, re | |
| def check_categories(d,category): | |
| for i in range(len(d)): | |
| if d[i]['name'] == category: return i | |
| return -1 |