Analyze Boston at data.boston.gov is "is the City of Boston's open data hub" with over 134 datasets and this Analyze Boston SQL Client is a tool for executing queries and displaying the results.
A dataset like Property Assesment has a resource key which can be found in the preview link, like
https://data.boston.gov/dataset/property-assessment/resource/fd351943-c2c6-4630-992d-3f895360febd on which you can run SQL. This tool uses the SQL endpoint (documentation.)
To see error messages enable this extension allow-control-allow-origin:* otherwise you will just get generic errors.
The tool uses CKAN DataStore, which is a thin layer on top of a PostgreSQL database, so the PostgreSQL docs are very helpful. MySQL users may want to read Things to find out about when moving from MySQL to PostgreSQL.
Common Problems Include:
- A system identifiers (e.g field names, table names, etc) wasn't doublequoted
- A string wasn't single quoted
- A nonexistent field was referenced