Currently Adopted

<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>A visual representation of the currently "adopted" sections of highway in Iowa. Additionally, this map displays the sections of highway that are never available for adoption. This data is updated hourly at the top of the hour.</SPAN></P></DIV></DIV></DIV>

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 \"mydata-iowa-gov/currently-adopted-2scp-hv4d\".\"currently_adopted\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.