Icon for Socrata external plugin
Open repository in Console
Updated 20 hours ago
Indexed 16 minutes ago

Work Orders

This dataset contains data on Work Orders performed by field crews from the Department of Parks & Recreation, the Department of Transportation, and the Environmental Storm Water Management and Streets & Bridges Divisions of the Department of Public Works. The data comes from the city’s implementation of CentralSquare’s Enterprise Asset Management platform, also known as Lucity. This dataset is updated daily on weekdays.

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 \"norfolk-gov/work-orders-qzfe-wj25\".\"work_orders\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • work_orders