Icon for Socrata external plugin
Open repository in Console
Updated 9 days ago
Indexed 6 days ago

Asset Management Parks System (AMPS) – Transaction Details

This table contains specific information about each part that is included in a transaction. Each record has information about one type of part in the transaction. A single transaction could have multiple lines (one for each type of part) in this table. The TRL_TRANS field can be joined to the Transactions table on TRA_CODE to know which parts were part the transaction.

For the User Guide, please follow <a href="">this link</a>

For the Data Dictionary, please follow <a href="">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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/asset-management-parks-system-amps-transaction-ub9z-gccp\".\"asset_management_parks_system_amps_transaction\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • asset_management_parks_system_amps_transaction
Upstream Metadata