Strategic Measure_Street Segment Condition Data Aggregated

This table contains aggregated street condition data for each fiscal year beginning in FY2018. A contract vendor surveys street conditions for one-third to one-half of the City of Austin each year. The reported value each year represents the aggregate reported conditions for the three most recent years as of the year reported. Detailed condition data for the most recent fiscal year can be found in the dataset Strategic Measure_Street Segment Condition Data.

View more details and insights related to this data set on the story page: https://data.austintexas.gov/stories/s/kara-xhcd.

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/strategic-measurestreet-segment-condition-data-hik3-m8t2\".\"strategic_measurestreet_segment_condition_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.