About this Dataset

Floodplain FIRM Panels

Location and attributes for FIRM hardcopy map panels. The spatial entities representing FIRM panels are polygons. The polygon for the FIRM panel corresponds to the panel neatlines. FIRM panels must not overlap or have gaps within a study. In situations where a portion of a panel lies outside the jurisdiction being mapped, the user must refer to the S_Pol_Ar table to determine the portion of the panel area where the FIRM Database shows the effective flood hazard data for the mapped jurisdiction.
Organization: District of Columbia
Last updated: 2024-04-30T18:36:58.031846
Tags: dc, dfirm, digital-flood-insurance-rate-map, district-of-columbia, environment, fema-firm-panel, flood, flood-insurance-rate-map, floodplain, hydrology, inland-waters, nfip, washington-dc

Tables

Table 1

@usgov.district_of_columbia_floodplain_firm_panels.table_1

20.95 kB
38 rows
27 columns

CREATE TABLE table_1 (
  "firm_id" VARCHAR,
  "st_fips" BIGINT,
  "pcomm" BIGINT,
  "panel" BIGINT,
  "suffix" VARCHAR,
  "firm_pan" VARCHAR,
  "panel_typ" VARCHAR,
  "eff_date" TIMESTAMP,
  "scale" BIGINT,
  "pnp_reason" VARCHAR,
  "nw_lat" VARCHAR,
  "nw_long" VARCHAR,
  "se_lat" VARCHAR,
  "se_long" VARCHAR,
  "source_cit" VARCHAR,
  "dfirm_id" BIGINT,
  "version_id" VARCHAR,
  "pre_date" VARCHAR,
  "base_typ" VARCHAR,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "created" TIMESTAMP,
  "edited" TIMESTAMP,
  "objectid" BIGINT,
  "gfid" VARCHAR,
  "shapearea" BIGINT,
  "shapelen" BIGINT
);