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

Asset Management Parks System (AMPS) – Transactions

This table contains information about transactions. A transaction tracks the movement of parts and materials between store houses and work orders. Each record represents a single transaction. The primary key is TRA_CODE. When TRA_TOENTITY is “EVNT” then you can use the TRA_TOCODE field to join to the Work Orders table on EVT_CODE to know which transactions are associated with each work order.

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-transactions-gcys-vvnq\".\"asset_management_parks_system_amps_transactions\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • asset_management_parks_system_amps_transactions
Upstream Metadata