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

Asset Management Parks System (AMPS) - Work Orders

This table is the primary table for information about work orders, and contains general information - including a description of the work, assigned title, request date and completion date - about each work order. Each row represents a single work order. The primary key field is EVT_CODE. The EVT_OBJECT field can be joined to the Assets table on OBJ_CODE to know which asset the work order was for.

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-work-orders-8sdw-8vja\".\"asset_management_parks_system_amps_work_orders\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • asset_management_parks_system_amps_work_orders
Upstream Metadata