Floodplains From 2023

District of Columbia

@usgov.district_of_columbia_floodplains_from_2023

Table List

1 table(28.89 KB)

Table 1

@usgov.district_of_columbia_floodplains_from_2023.table_1

28.89 KB
402 rows
34 columns

objectid OBJECTID	dfirm_id DFIRM ID	version_id VERSION ID	fld_ar_id FLD AR ID	fld_zone FLD ZONE	zone_subty ZONE SUBTY	sfha_tf SFHA TF	static_bfe STATIC BFE	depth DEPTH	velocity VELOCITY	bfe_revert BFE REVERT	dep_revert DEP REVERT	source_cit SOURCE CIT	study_typ STUDY TYP	zone ZONE	url URL	gis_id GIS ID	creator CREATOR	created CREATED	editor EDITOR	edited EDITED	gfid GFID
1	110001	1.1.1.0	110001_138	X	AREA OF MINIMAL FLOOD HAZARD	F	-9999	-9999	-9999	-9999	-9999	110001_STUDY1	NP	X	https://msc.fema.gov/portal/home	FldPlnPly_778	JLAY	Wed Sep 20 2023 19:56:52 GMT+0000 (Coordinated Universal Time)	JLAY	Wed Sep 20 2023 20:00:09 GMT+0000 (Coordinated Universal Time)	4202017e-ec13-401d-999b-041a9ba244cf
2	110001	1.1.1.0	110001_75	X	AREA OF MINIMAL FLOOD HAZARD	F	-9999	-9999	-9999	-9999	-9999	110001_STUDY1	NP	X	https://msc.fema.gov/portal/home	FldPlnPly_715	JLAY	Wed Sep 20 2023 19:56:52 GMT+0000 (Coordinated Universal Time)	JLAY	Wed Sep 20 2023 20:00:09 GMT+0000 (Coordinated Universal Time)	4202017e-ec13-401d-999b-041a9ba244cf
3	110001	1.1.1.0	110001_76	X	AREA OF MINIMAL FLOOD HAZARD	F	-9999	-9999	-9999	-9999	-9999	110001_STUDY1	NP	X	https://msc.fema.gov/portal/home	FldPlnPly_716	JLAY	Wed Sep 20 2023 19:56:52 GMT+0000 (Coordinated Universal Time)	JLAY	Wed Sep 20 2023 20:00:09 GMT+0000 (Coordinated Universal Time)	4202017e-ec13-401d-999b-041a9ba244cf
4	110001	1.1.1.0	110001_84	X	AREA OF MINIMAL FLOOD HAZARD	F	-9999	-9999	-9999	-9999	-9999	110001_STUDY1	NP	X	https://msc.fema.gov/portal/home	FldPlnPly_724	JLAY	Wed Sep 20 2023 19:56:52 GMT+0000 (Coordinated Universal Time)	JLAY	Wed Sep 20 2023 20:00:09 GMT+0000 (Coordinated Universal Time)	4202017e-ec13-401d-999b-041a9ba244cf
5	110001	1.1.1.0	110001_85	X	AREA OF MINIMAL FLOOD HAZARD	F	-9999	-9999	-9999	-9999	-9999	110001_STUDY1	NP	X	https://msc.fema.gov/portal/home	FldPlnPly_725	JLAY	Wed Sep 20 2023 19:56:52 GMT+0000 (Coordinated Universal Time)	JLAY	Wed Sep 20 2023 20:00:09 GMT+0000 (Coordinated Universal Time)	4202017e-ec13-401d-999b-041a9ba244cf
6	110001	1.1.1.0	110001_87	X	AREA OF MINIMAL FLOOD HAZARD	F	-9999	-9999	-9999	-9999	-9999	110001_STUDY1	NP	X	https://msc.fema.gov/portal/home	FldPlnPly_727	JLAY	Wed Sep 20 2023 19:56:52 GMT+0000 (Coordinated Universal Time)	JLAY	Wed Sep 20 2023 20:00:09 GMT+0000 (Coordinated Universal Time)	4202017e-ec13-401d-999b-041a9ba244cf
7	110001	1.1.1.0	110001_88	X	AREA OF MINIMAL FLOOD HAZARD	F	-9999	-9999	-9999	-9999	-9999	110001_STUDY1	NP	X	https://msc.fema.gov/portal/home	FldPlnPly_728	JLAY	Wed Sep 20 2023 19:56:52 GMT+0000 (Coordinated Universal Time)	JLAY	Wed Sep 20 2023 20:00:09 GMT+0000 (Coordinated Universal Time)	4202017e-ec13-401d-999b-041a9ba244cf
8	110001	1.1.1.0	110001_189	X	AREA OF MINIMAL FLOOD HAZARD	F	-9999	-9999	-9999	-9999	-9999	110001_STUDY1	NP	X	https://msc.fema.gov/portal/home	FldPlnPly_829	JLAY	Wed Sep 20 2023 19:56:52 GMT+0000 (Coordinated Universal Time)	JLAY	Wed Sep 20 2023 20:00:09 GMT+0000 (Coordinated Universal Time)	4202017e-ec13-401d-999b-041a9ba244cf
9	110001	1.1.1.0	110001_142	X	AREA OF MINIMAL FLOOD HAZARD	F	-9999	-9999	-9999	-9999	-9999	110001_STUDY1	NP	X	https://msc.fema.gov/portal/home	FldPlnPly_782	JLAY	Wed Sep 20 2023 19:56:52 GMT+0000 (Coordinated Universal Time)	JLAY	Wed Sep 20 2023 20:00:09 GMT+0000 (Coordinated Universal Time)	4202017e-ec13-401d-999b-041a9ba244cf
10	110001	1.1.1.0	110001_144	X	AREA OF MINIMAL FLOOD HAZARD	F	-9999	-9999	-9999	-9999	-9999	110001_STUDY1	NP	X	https://msc.fema.gov/portal/home	FldPlnPly_784	JLAY	Wed Sep 20 2023 19:56:52 GMT+0000 (Coordinated Universal Time)	JLAY	Wed Sep 20 2023 20:00:09 GMT+0000 (Coordinated Universal Time)	4202017e-ec13-401d-999b-041a9ba244cf


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "dfirm_id" BIGINT,
  "version_id" VARCHAR,
  "fld_ar_id" VARCHAR,
  "fld_zone" VARCHAR,
  "zone_subty" VARCHAR,
  "floodway" VARCHAR,
  "sfha_tf" VARCHAR,
  "static_bfe" DOUBLE,
  "v_datum" VARCHAR,
  "depth" BIGINT,
  "len_unit" VARCHAR,
  "velocity" BIGINT,
  "vel_unit" VARCHAR,
  "ar_revert" VARCHAR,
  "bfe_revert" BIGINT,
  "dep_revert" BIGINT,
  "source_cit" VARCHAR,
  "hydro_id" VARCHAR,
  "cst_mdl_id" VARCHAR,
  "ar_subtrv" VARCHAR,
  "study_typ" VARCHAR,
  "dual_zone" VARCHAR,
  "zone" VARCHAR,
  "url" VARCHAR,
  "gis_id" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "creator" VARCHAR,
  "created" TIMESTAMP,
  "editor" VARCHAR,
  "edited" TIMESTAMP,
  "gfid" VARCHAR,
  "shapearea" BIGINT,
  "shapelen" BIGINT
);