Schema
NFHL / Alluvial Fans / v1.0.0
Schema from alluvial-fans.parquet, gcs-hifld-next-datasets-prod, v1.0.0.
The National Flood Hazard Layer (NFHL) is a compilation of GIS data that comprises a nationwide digital Flood Insurance Rate Map. The GIS data and services are designed to provide the user with the ability to determine the flood zone, base flood elevation, and floodway status for a particular location. It also has information about the NFIP communities, map panels, cross sections, hydraulic structures, Coastal Barrier Resource System, and base maps such as road, stream, and public land survey data. Through flood studies, FEMA produces Flood Insurance Study Reports, FIRM Panels, and FIRM Databases. FIRM Databases that become effective are incorporated into the NFHL. Updates to the NFHL are issued through Letters of Map Revision (LOMRs) and Letters of Map Amendment (LOMAs). Continuously updated, the NFHL serves as a Digital Flood Insurance Rate Map representing the current effective flood data for those communities where maps have been digitized. NFHL data can be viewed with widely available GIS software, including freely available programs that work with GIS shapefiles. For more information on the NFHL, see the online resources referenced herein. Using base maps: The minimum horizontal positional accuracy for base map hydrographic and transportation features used with the NFHL is the NSSDA radial accuracy of 38 feet. Letter of Map Amendment (LOMA) point locations are approximate. The location of the LOMA is referenced in the legal description of the letter itself. LOMA points can be viewed in the NFHL Interactive Map on the FEMA GeoPlatform.
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| OBJECTID | integer | No | 0 | — | — Range: 4360 to 16649Length: — | Examples: 4366, 16436, 16596, 16514, 16386 Values: — |
| DFIRM_ID | string | No | 0 | — | — Range: —Length: 6 | Examples: 53073C, 06065C, 06065C, 06065C, 06065C Values: 06025C, 06065C, 06073C, 53073C |
| VERSION_ID | string | No | 0 | — | — Range: —Length: 7 | Examples: 2.3.2.1, 2.4.3.0, 2.4.3.0, 2.4.3.0, 2.4.3.0 Values: 2.3.2.1, 2.4.3.0 |
| ALLUVL_ID | string | No | 0 | — | — Range: —Length: 10 | Examples: 53073C_7, 06065C_87, 06065C_247, 06065C_165, 06065C_37 Values: — |
| ACTIVE_FAN | string | No | 0 | — | — Range: —Length: 1 | Examples: T, T, T, T, T Values: T |
| FANAPEX_DA | float | No | 0 | — | — Range: 0.01 to 47.49Length: — | Examples: 0.06, 12.12, 7.45, 5.26, 47.49 Values: — |
| AREA_UNITS | string | No | 0 | — | — Range: —Length: 12 | Examples: Square Miles, Square Miles, Square Miles, Square Miles, Square Miles Values: Square Miles |
| FANAPEX_Q | integer | No | 0 | — | — Range: -8888 to 26417Length: — | Examples: -8888, 9543, 9142, 6040, 26417 Values: — |
| DISCH_UNIT | string | No | 0 | — | — Range: —Length: 3 | Examples: CFS, CFS, CFS, CFS, CFS Values: CFS |
| FAN_VEL_MN | float | No | 0 | — | — Range: -9999 to 3.5Length: — | Examples: -9999.0, 3.5, 3.5, 3.5, 3.5 Values: — |
| FAN_VEL_MX | float | No | 0 | — | — Range: -9999 to 10.5Length: — | Examples: -9999.0, 8.5, 6.5, 7.5, 10.5 Values: — |
| VEL_UNIT | string | No | 0 | — | — Range: —Length: 13 | Examples: NP, Feet / Second, Feet / Second, Feet / Second, Feet / Second Values: Feet / Second, NP |
| DEPTH | integer | No | 0 | — | — Range: -9999 to 6Length: — | Examples: -9999, -9999, -9999, 2, 5 Values: — |
| DEPTH_UNIT | string | Yes | 134 | — | — Range: —Length: 4 | Examples: Feet, Feet, Feet, Feet, Feet Values: Feet, NP |
| FLD_ZONE | string | No | 0 | — | — Range: —Length: 2 | Examples: X, A, X, AO, AO Values: A, AE, AO, X |
| ZONE_SUBTY | string | Yes | 225 | — | — Range: —Length: 41 | Examples: AREA OF MINIMAL FLOOD HAZARD, 0.2 PCT ANNUAL CHANCE FLOOD HAZARD, AREA OF MINIMAL FLOOD HAZARD, 0.2 PCT ANNUAL CHANCE FLOOD HAZARD, 0.2 PCT ANNUAL CHANCE FLOOD HAZARD Values: 0.2 PCT ANNUAL CHANCE FLOOD HAZARD, 1 PCT DEPTH LESS THAN 1 FOOT, AREA OF MINIMAL FLOOD HAZARD, AREA WITH REDUCED FLOOD RISK DUE TO LEVEE |
| METH_DESC | string | Yes | 27 | — | — Range: —Length: 17 | Examples: FEMA FAN Analysis, FEMA FAN Analysis, FEMA FAN Analysis, FEMA FAN Analysis, FEMA FAN Analysis Values: FEMA FAN Analysis |
| SOURCE_CIT | string | No | 0 | — | — Range: —Length: 14 | Examples: 53073C_FIRM1, 06065C_STUDY4, 06065C_STUDY1, 06065C_STUDY4, 06065C_STUDY4 Values: 06025C_STUDY3, 06065C_LOMC102, 06065C_STUDY1, 06065C_STUDY4, 06073C_STUDY4, 53073C_FIRM1 |
| GFID | string | No | 0 | — | — Range: —Length: 36 | Examples: 266f3568-f2a3-4424-b654-d2d82ba649e6, b215ddb9-fecf-47bd-a3d8-b1f7b851d5e2, b215ddb9-fecf-47bd-a3d8-b1f7b851d5e2, b215ddb9-fecf-47bd-a3d8-b1f7b851d5e2, b215ddb9-fecf-47bd-a3d8-b1f7b851d5e2 Values: 266f3568-f2a3-4424-b654-d2d82ba649e6, b215ddb9-fecf-47bd-a3d8-b1f7b851d5e2, bad5e9fe-7914-4800-abfc-010f54b49d24, fba221a3-6531-4fd2-8f52-09cf40fe63a4 |
| GlobalID | string | No | 0 | — | — Range: —Length: 38 | Examples: {565507D2-5566-49FE-9287-4C4F8671B0F5}, {57ECABB5-30EB-4A9C-8CF6-F36EECC4EAFC}, {34ED05F5-70D4-423C-AC05-3593E20C9904}, {85E794A8-3710-47EE-AEA8-FD8ECE7459FC}, {FC5B9AAF-180C-42AF-A9C5-3A0A7E635304} Values: — |
| SHAPESTAre | float | No | 0 | — | — Range: 4.5808e-11 to 0.002979591016301Length: — | Examples: 4.2322626148e-05, 9.96177106e-07, 4.6868423e-08, 3.8663155345e-05, 5.17680687e-07 Values: — |
| SHAPESTLen | float | No | 0 | — | — Range: 0.000088378238548 to 0.504260731027231Length: — | Examples: 0.045935000480042, 0.010868499327954, 0.003920709538843, 0.026118996783504, 0.002979764481808 Values: — |
| id | integer | No | 0 | — | — Range: 4360 to 16649Length: — | Examples: 4366, 16436, 16596, 16514, 16386 Values: — |
