Schema
NFHL / Water Lines / v1.0.0
Schema from part-000.parquet, gcp-portolan-published, 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: — |
| DFIRM_ID | string | No | 0 | — | — Range: —Length: 6 | Examples: 29001C, 29019C, 29019C, 29019C, 29003C Values: 29001C, 29003C, 29007C, 29009C, 29011C, 29013C, 29015C, 29019C |
| VERSION_ID | string | No | 0 | — | — Range: —Length: 7 | Examples: 2.7.5.6, 1.1.1.0, 1.1.1.0, 1.1.1.0, 1.1.1.0 Values: 1.1.1.0, 2.3.3.2, 2.7.5.6 |
| WTR_LN_ID | string | No | 0 | — | — Range: —Length: 12 | Examples: 29001C_399, 29019C_2114, 29019C_3117, 29019C_2853, 29003C_217 Values: — |
| WTR_NM | string | No | 0 | — | — Range: —Length: 47 | Examples: North Fork South Fabius River, SCOTTS BRANCH, ROCKY FORK CREEK, UNNAMED TRIBUTARY 1437, Bull Creek Values: — |
| SHOWN_FIRM | string | Yes | 1,179 | — | — Range: —Length: 1 | Examples: , , F, , Values: , F |
| SHOWN_INDX | string | Yes | 1,179 | — | — Range: —Length: 1 | Examples: , , F, , Values: , F, T, U |
| SOURCE_CIT | string | No | 0 | — | — Range: —Length: 13 | Examples: 29001C_STUDY1, 29019C_BASE8, 29019C_BASE8, 29019C_BASE8, 29003C_BASE5 Values: 29001C_STUDY1, 29003C_BASE5, 29007C_BASE5, 29009C_STUDY1, 29011C_BASE2, 29013C_BASE2, 29015C_BASE3, 29019C_BASE8, 29019C_FIS1, 29019C_LOMC5, 29019C_STUDY1 |
| GFID | string | Yes | 790 | — | — Range: —Length: 36 | Examples: 5bca1a91-81df-4194-ba92-22ef119dd972, 5bca1a91-81df-4194-ba92-22ef119dd972, 5bca1a91-81df-4194-ba92-22ef119dd972, 54fa1224-819f-4b22-9dc0-316b67f6a1fd, 5bca1a91-81df-4194-ba92-22ef119dd972 Values: 20110317, 20110418, 54fa1224-819f-4b22-9dc0-316b67f6a1fd, 5bca1a91-81df-4194-ba92-22ef119dd972 |
| SHAPE_Length | float | No | 0 | — | — Range: 9.496446761060015e-7 to 0.6181260487803258Length: — | Examples: 0.14889712333110822, 0.00012590194526820912, 0.00025840362571822044, 0.007439374181664513, 0.03695076826028956 Values: — |
| src_gdb | string | No | 0 | — | — Range: —Length: 20 | Examples: NFHL_29_20250528.gdb, NFHL_29_20250528.gdb, NFHL_29_20250528.gdb, NFHL_29_20250528.gdb, NFHL_29_20250528.gdb Values: NFHL_29_20250528.gdb |
