Reef Sites

Artificial reef programs site, manage and develop reefs, but also have the responsibility to communicate the locations of reef material placements to anglers in order to facilitate enhanced fishing opportunities, one of the major goals of the effort. Because angler and boater funds (excise taxes) are primarily used for reef development, it is important to communicate this information to anglers and it is part of the federal aid project.

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 \"delaware-gov/reef-sites-35bu-5jjg\".\"reef_sites\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.