Asset Management Parks System (AMPS) – Comments
This table all comments for all tables in AMPS. The record for each comment indicates which record and table the comment pertains to. Each record is a single comment. The ADD_CODE field can be joined to another table according to the value in ADD_ENTITY.
For the User Guide, please follow <a href="https://docs.google.com/document/d/1UwyGGncb6oFMiOfgz73G-iM8Yea9ubz4931hPeBO9YQ/edit?usp=sharing">this link</a>
For the Data Dictionary, please follow <a href="https://docs.google.com/spreadsheets/d/1pDr-BUe4LS7DvATfbOnd8UrV6s77krJgzqdq_gVYWqc/edit?usp=sharing">this link </a>
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \ -H "Content-Type: application/json" \ -d@-<<EOF {"sql": " SELECT * FROM \"cityofnewyork-us/asset-management-parks-system-amps-comments-kw9y-h36n\".\"asset_management_parks_system_amps_comments\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.