TRANSPORTATION.markings_specialty_point_dates

Related table of specialty markings dates. The work order ID originated from the roadway markings work orders and the contractor work order dataset that pulls from the Signs and Markings Operations Work Order tracking system. The work dates originate from data tracker or were collected in GIS prior to the association of work order IDs to specialty markings assets. Specialty markings are separated into types that include arrows, word legends, parking space boundaries, raised pavement markings (RPM), symbols, and other pavement markings.

This dataset contains related records for the TRANSPORTATION.markings_specialty_point layer: https://data.austintexas.gov/Transportation-and-Mobility/TRANSPORTATION_markings_specialty_point/53jy-y8pj

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/transportationmarkingsspecialtypointdates-nge6-5asq\".\"transportationmarkingsspecialtypointdates\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.