Erosion Control Work, Park and Preserve Trails and Roads

Work on trails and roads in the County of Marin's parks and preserves, in efforts to reduce erosion. The work has three main benefits: (1) maintain the sustainability and serviceability of the trails and roads; (2) reduce sediment deposition within the watershed; and (3) improve the visitor experience. Data is updated annually.

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 \"marincounty/erosion-control-work-park-and-preserve-trails-and-rd7e-6bb2\".\"erosion_control_work_park_and_preserve_trails_and\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.