Reference Post

The feature class contains the reference post sign locations for all the primary routes in the State of Iowa. These signs are often referred to as mileposts, however these signs are not necessarily located at a mile apart. Also a 0 value virtual post is present at the beginning of every route.

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/reference-post-2ki6-z4av\".\"reference_post\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.