Schema
NFHL / General Structures / v1.0.0
Schema from general-structures.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: 2 to 6367Length: — | Examples: 476, 4804, 6130, 5863, 716 Values: — |
| DFIRM_ID | string | No | 0 | — | — Range: —Length: 6 | Examples: 05005C, 29007C, 35017C, 340342, 05057C Values: — |
| VERSION_ID | string | No | 0 | — | — Range: —Length: 7 | Examples: 1.1.1.0, 1.1.1.0, 1.1.1.0, 1.1.1.0, 1.1.1.0 Values: 1.1.1.0 |
| STRUCT_ID | string | No | 0 | — | — Range: —Length: 14 | Examples: 05005C_77, 29007C_325, 35017C_463, 340342_134, 05057C_25 Values: — |
| STRUCT_TYP | string | No | 0 | — | — Range: —Length: 60 | Examples: Bridge, Dam, Bridge, Wing Wall, Dam Values: 0.2 Pct Annual Chance Flood Discharge Contained In Structure, 1 Pct Annual Chance Flood Discharge Contained In Structure, Aqueduct, Bridge, Canal, Control Structure, Culvert, Dam, Drop Structure, Floodway Contained In Structure, Flume, Footbridge, Gate, Lock, NP, Pump Station, Spillway, Utility Crossing, Weir, Wing Wall |
| CST_STRUCT | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| STRUCT_NM | string | Yes | 3,404 | — | — Range: —Length: 50 | Examples: NP, UNIVERSITY DRIVE, Krei Avenue Bridge, US 169, Springfield Avenue Values: — |
| WTR_NM | string | No | 0 | — | — Range: —Length: 54 | Examples: WALKER CREEK, Lakeview Park Creek, TRIBUTARY 2 TO MAUDES CREEK (UPPER REACH), NP, UNNAMED STREAM Values: — |
| LOC_DESC | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| STRUC_DESC | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| SHOWN_FIRM | string | No | 0 | — | — Range: —Length: 1 | Examples: U, U, U, U, U Values: U |
| SOURCE_CIT | string | No | 0 | — | — Range: —Length: 14 | Examples: 05005C_STUDY1, 29007C_BASE4, 35017C_FIRM1, 340342_FIS1, 05057C_STUDY1 Values: — |
| GFID | string | Yes | 3,055 | — | — Range: —Length: 29 | Examples: 20121218, 20130304, 20110509LOMR, 20110718, 20130304 Values: — |
| GlobalID | string | No | 0 | — | — Range: —Length: 38 | Examples: {873194F2-A166-42A5-A7EA-DF9BBD904FCB}, {D401E09C-5F2D-4B67-8DFC-934C11651EF2}, {0048092B-2868-4386-8F0B-522F3F2F6606}, {20C54D96-D441-42E2-A084-56B6B6B860D6}, {188146C3-DEA2-49B0-8F03-792DD30FCF0B} Values: — |
| SHAPESTLen | float | No | 0 | — | — Range: 1.67638144e-7 to 0.161340616460973Length: — | Examples: 0.000130552686162, 0.000335923149301, 0.000918730288877, 1.4101291308e-05, 0.00095567145953 Values: — |
| id | integer | No | 0 | — | — Range: 2 to 6367Length: — | Examples: 476, 4804, 6130, 5863, 716 Values: — |
