cityofnewyork-us/asset-management-parks-system-amps-comments-kw9y-h36n
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 7 days ago
Indexed 44 minutes ago

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.

 
Preview
  • asset_management_parks_system_amps_comments
     
     
     
     
     
Upstream Metadata