Roadway Markings Work Orders

This dataset contains records of in-progress and work completed from June 2018 to present for the purpose of tracking the installation and maintenance of roadway markings in the City of Austin full purpose jurisdiction. This work is managed by the Signs & Markings Division (SMD) of the City of Austin Transportation and Public Works (TPW) department.

The records are managed in a work management system tracker and the dataset is automatically updated twice per day.

You may also be interested in these related datasets, which can be joined together using the work order ID columns:

• Road Markings Jobs: https://data.austintexas.gov/dataset/Work-Order-Markings-Jobs/vey3-7n3x

• Signs and Markings Time Logs: https://data.austintexas.gov/dataset/Work-Order-Signs-Markings-Time-Logs/qvth-gwdv

• Signs and Markings Reimbursements: https://data.austintexas.gov/dataset/Signs-and-Markings-Reimbursement-Tracking/pma8-yy5k

Division website: http://www.austintexas.gov/department/signs-markings

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 \"datahub-austintexas-gov/roadway-markings-work-orders-nyhn-669r\".\"roadway_markings_work_orders\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.