About this Dataset

Floodplain General Structures

Location and attributes for flood control structures shown on the flood profile and FIRM. This table is required whenever hydraulic structures are shown in the flood profile. It is also required when channels containing the flooding are shown on the FIRM or any other structure that impacts the area’s flood risk is shown on the FIRM. This table contains both riverine and coastal structure types. Spatial elements representing general structures are represented by lines. The lines must represent the primary characteristic of the structure. For example, bridges must be represented by the transportation centerline carried by the bridge. Dams must be represented by a line corresponding to the top of the dam. A line corresponding to the centerline of the main barrel must represent a culvert.
Organization: District of Columbia
Last updated: 2024-04-30T18:36:51.445163
Tags: dc, dfirm, digital-flood-insurance-rate-map, district-of-columbia, environment, fema-firm, flood, flood-insurance-rate-map, floodplain, hydrology, inland-waters, nfip, washington-dc

Tables

Table 1

@usgov.district_of_columbia_floodplain_general_structures.table_1

30.47 KB
283 rows
18 columns


CREATE TABLE table_1 (
  "struct_nm" VARCHAR,
  "struc_desc" VARCHAR,
  "struct_typ" VARCHAR,
  "struct_id" VARCHAR,
  "wtr_nm" VARCHAR,
  "source_cit" VARCHAR,
  "dfirm_id" BIGINT,
  "version_id" VARCHAR,
  "cst_struct" VARCHAR,
  "loc_desc" VARCHAR,
  "shown_firm" VARCHAR,
  "gfid" VARCHAR,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "created" TIMESTAMP,
  "edited" TIMESTAMP,
  "objectid" BIGINT,
  "shapelen" BIGINT
);