Schema
NFHL / FIRM Panels / v1.0.0
Schema from firm-panels-1.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: 82 to 11912Length: — | Examples: 480, 9972, 11508, 10825, 769 Values: — |
| DFIRM_ID | string | No | 0 | — | — Range: —Length: 6 | Examples: 01013C, 05017C, 06005C, 05093C, 01023C 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, 2.3.2.1, 2.3.3.0, 2.3.3.2, 2.3.3.3, 2.4.3.5, 2.6.4.4 |
| FIRM_ID | string | No | 0 | — | — Range: —Length: 14 | Examples: 01013C_304, 05017C_101, 06005C_22, 05093C_140, 01023C_3 Values: — |
| ST_FIPS | string | No | 0 | — | — Range: —Length: 2 | Examples: 01, 5, 06, 05, 01 Values: 01, 02, 04, 05, 06, 1, 4, 5 |
| PCOMM | string | No | 0 | — | — Range: —Length: 4 | Examples: 013C, 017C, 005C, 093C, 023C Values: — |
| PANEL | string | No | 0 | — | — Range: —Length: 4 | Examples: 0180, 0325, 0585, 0430, 0275 Values: — |
| SUFFIX | string | No | 0 | — | — Range: —Length: 1 | Examples: C, D, F, E, D Values: A, B, C, D, E, F, G, H, J, M |
| FIRM_PAN | string | No | 0 | — | — Range: —Length: 11 | Examples: 01013C0180C, 05017C0325D, 06005C0585F, 05093C0430E, 01023C0275D Values: — |
| PANEL_TYP | string | No | 0 | — | — Range: —Length: 30 | Examples: Countywide, Panel Printed, Countywide, Panel Printed, Countywide, Panel Printed, Countywide, Panel Printed, Countywide, Panel Printed Values: Community Based, Not Printed, Community Based, Panel Printed, Countywide, Not Printed, Countywide, Panel Printed |
| PRE_DATE | string | Yes | 133 | — | — Range: —Length: 10 | Examples: 9999-09-09, 9999-09-09, 2017-07-21, 9999-09-09, 9999-09-09 Values: 2016-05-13, 2017-03-29, 2017-07-21, 2018-06-18, 8888-08-08, 9999-09-09 |
| EFF_DATE | string | No | 0 | — | — Range: —Length: 10 | Examples: 2009-09-11, 2012-10-02, 2010-05-20, 2010-06-18, 2010-09-03 Values: — |
| SCALE | string | No | 0 | — | — Range: —Length: 5 | Examples: 12000, 24000, 12000, 12000, 24000 Values: 12000, 24000, 6000 |
| PNP_REASON | string | Yes | 4,558 | — | — Range: —Length: 50 | Examples: AREA OUTSIDE OF COUNTY BOUNDARY, AREA IN ZONE D, AREA IN ZONE D, ALL ZONE D, PANEL NOT PRINTED - ALL ZONE X Values: — |
| BASE_TYP | string | No | 0 | — | — Range: —Length: 10 | Examples: NP, NP, NP, NP, NP Values: NP, Orthophoto, Vector |
| SOURCE_CIT | string | No | 0 | — | — Range: —Length: 13 | Examples: 01013C_BASE1, 05017C_BASE4, 06005C_STUDY1, 05093C_STUDY1, 01023C_STUDY2 Values: — |
| GFID | string | Yes | 1,123 | — | — Range: —Length: 36 | Examples: 20110503, 20110916, a427acb0-7358-4933-86c1-c9f1ddf77a37, b28549fd-1760-4636-bc8a-03e016b44512, ab1bd93a-570b-4cea-8ac3-782f01eaf93f Values: — |
| SHAPE | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| GlobalID | string | No | 0 | — | — Range: —Length: 38 | Examples: {87C7FAFD-1D18-4854-9BEE-85174C91788D}, {9DCCC743-F4FE-4369-A090-F19A015F1EFE}, {8791626A-458F-4BDB-85C1-14FD0037D84C}, {5D062796-20C9-472F-A700-47BB3A35C8DB}, {857ACC75-EF47-4394-BEF4-E119E7230674} Values: — |
| SHAPESTAre | float | No | 0 | — | — Range: 0.000242228100274 to 0.015820653842733Length: — | Examples: 0.003907541111598, 0.01562500857269, 0.003906243957643, 0.003906225908778, 0.015626255157964 Values: — |
| SHAPESTLen | float | No | 0 | — | — Range: 0.083294791569543 to 0.687502425141441Length: — | Examples: 0.250041324069003, 0.500000137163016, 0.249999806646908, 0.24999923326873, 0.500001982865469 Values: — |
| id | integer | No | 0 | — | — Range: 82 to 11912Length: — | Examples: 480, 9972, 11508, 10825, 769 Values: — |
