About this Dataset

Floodplains From 1985

Insurance applications include enforcement of the mandatory purchase requirement of the Flood Disaster Protection Act, which requires the purchase of flood insurance by property owners who are being assisted by Federal programs or by Federally supervised, regulated or insured agencies or institutions in the acquisition or improvement of land facilities located or to be located in identified areas having special flood hazards, Section 2 (b) (4) of the Flood Disaster Protection Act of 1973. In addition to the identification of Special Flood Hazard Areas (SFHAs), the risk zones shown on the FIRMs are the basis for the establishment of premium rates for flood coverage offered through the NFIP. The DFIRM Database presents the flood risk information depicted on the FIRM in a digital format suitable for use in electronic mapping applications. The DFIRM database is a subset of the Digital FIS database that serves to archive the information collected during the FIS. For more information, visit https://msc.fema.gov/portal/home.
Organization: District of Columbia
Last updated: 2024-04-30T17:54:09.421730
Tags: dc, district-of-columbia, doee, environment, fema, firm, floodplain, insurance, washington-dc, water

Tables

Table 1

@usgov.district_of_columbia_floodplains_from_1985.table_1

19.66 KB
257 rows
25 columns


CREATE TABLE table_1 (
  "zone" VARCHAR,
  "floodway" VARCHAR,
  "firm_panel" VARCHAR,
  "quad" VARCHAR,
  "quad_unit" VARCHAR,
  "community" BIGINT,
  "cobra" VARCHAR,
  "sfha" VARCHAR,
  "symbol" BIGINT,
  "panel_typ" VARCHAR,
  "fips" BIGINT,
  "st_fips" BIGINT,
  "co_fips" BIGINT,
  "state" BIGINT,
  "pcomm" BIGINT,
  "panel" VARCHAR,
  "source" VARCHAR,
  "web_url" VARCHAR,
  "url" VARCHAR,
  "latitude" BIGINT,
  "longitude" BIGINT,
  "objectid_1" BIGINT,
  "objectid" BIGINT,
  "shapearea" BIGINT,
  "shapelen" BIGINT
);