MEDIAN_TYPE
this dataset is an inventory of existing medians along Hawaii Highways. Information includes location, condition of the median, median protection (Flexible, Semi-rigid, rigid, unspecified) type of median (Curbed •Flex •Rigid •Semi-rigid •Unprotected •Painted - Passing •Painted - No Passing •No Median) https://highways.hidot.hawaii.gov/dataset/Median-Type/sz7m-p92t
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 \"highways-hidot-hawaii-gov/mediantype-hxfv-n4kj\".\"mediantype\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.