Aberdeen Flood Depths 11-27-18

1. This dataset provides summary data needed to help determine the premium for a flood insurance policy.

2. The elevation and depth data come from approximate methods and could be one foot or more off. A FEMA Elevation Certificate is needed to provide the more accurate data required to write a policy. The dataset was compiled by French & Associates with support from the Washington State Department of Ecology. The source elevation information came from the Federal Emergency Management Agency’s Flood Depth Grid for Grays Harbor County. Property information came from Grays Harbor County, with help from the City of Aberdeen.

3. Download instructions for getting a floor level for flood insurance elevation rating at https://bit.ly/2BJDdTi.

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 \"wa-gov/aberdeen-flood-depths-112718-7yy6-89nx\".\"aberdeen_flood_depths_112718\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.