Back to file

Schema

NFHL / LOMAs / v1.0.0

View metadata

Schema from lomas-1.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.

Columns
19 columns
Features
529,406
Geometry
Point
ColumnTypeNullableNullsUniqueDescriptionExamples / Values
geometrygeometryNo0——
Range: —Length: —
Examples: —
Values: —
OBJECTIDintegerNo0——
Range: 1 to 5000Length: —
Examples: 399, 3834, 4837, 4573, 637
Values: —
CASENUMBERstringNo0——
Range: —Length: 12
Examples: 00-03-1418A, 01-01-0518A, 01-04-2268A, 01-04-0802A, 00-04-0754A
Values: —
STATUSstringNo0——
Range: —Length: 9
Examples: Completed, Completed, Completed, Completed, Completed
Values: Completed
PROJECTNAMstringYes5——
Range: —Length: 121
Examples: VILLAROSA "M" AND "O", CLARKSON'S FIRST ADDITION, BLOCK 35, LOT 4 -- 403 BANNER STREET, W 1/2 OF SW 1/4 SEC 5; T29; R22 NORTH OF RAILROAD ROW; WESTGATE & OLD WILLARD ROAD, MORRIS HEIGHTS FILING NO. 7, BLOCK 72, LOT 11 -- 2689 ZION STREET, APPLETON ROAD
Values: —
PROJECTCATstringNo0——
Range: —Length: 7
Examples: LOMA, LOMA, LOMA, LOMA, LOMR-F
Values: LOMA, LOMR-F, LOMR-FW
DATEENDEDstringNo0——
Range: —Length: 10
Examples: 2000-09-28, 2001-02-28, 2001-02-28, 2001-03-28, 2000-02-03
Values: —
DATEENDEDSstringYes5,000——
Range: —Length: —
Examples: —
Values: —
CIDstringNo0——
Range: —Length: 6
Examples: 510303, 250261, 125107, 130404, 120112
Values: —
COMMUNITYNstringNo0——
Range: —Length: 50
Examples: ISLE OF WIGHT COUNTY *, BROCKTON, CITY OF, GAINESVILLE, CITY OF, TIFT COUNTY *, HILLSBOROUGH COUNTY*
Values: —
DETERMINATstringNo0——
Range: —Length: 12
Examples: DetermLetter, DetermLetter, DetermLetter, DetermLetter, DetermLetter
Values: DetermLetter
LATfloatNo0——
Range: 17.95 to 64.85Length: —
Examples: 36.92, 42.056, 29.653, 31.52, 27.88869
Values: —
LONfloatNo0——
Range: -149.91933 to -65.902Length: —
Examples: -76.508, -70.994, -82.381, -83.397, -82.32738
Values: —
PDFHYPERLIstringNo0——
Range: —Length: 19
Examples: 00-03-1418A-510303, 01-01-0518A-250261, 01-04-2268A-125107, 01-04-0802A-130404, 00-04-0754A-120112
Values: —
REVAL_STATstringNo0——
Range: —Length: 16
Examples: Not incorporated, Not incorporated, Not incorporated, Not incorporated, Not incorporated
Values: Incorporated, Not incorporated, Reevaluated, Superseded
LOTTYPEstringNo0——
Range: —Length: 12
Examples: Single lot, Single lot, Single lot, Single lot, Multiple lot
Values: Multiple lot, Single lot
OUTCOMEstringYes308——
Range: —Length: 51
Examples: Structure removed-Property partially inundated, Portion of property removed, Structure removed-Property partially inundated, Structure removed-Property partially inundated, Structure removed-Property partially inundated
Values: Multiple, Portion of property out as shown, Portion of property removed, Property out as shown, Property removed, Structure, Structure out as shown-Property partially inundated, Structure removed-Property partially inundated, UNKNOWN
GlobalIDstringNo0——
Range: —Length: 38
Examples: {F8A645DD-AF15-4408-AA85-C752FA2DE490}, {ED949A2A-9360-4405-AB16-73F0D8BA4F27}, {25E3A8A0-7CA9-4A28-A4C9-E0F5734A6C86}, {1593685C-3045-4245-AB70-DD4F752E0047}, {7C444AED-0CF0-4928-A12C-EEB911EE17F3}
Values: —
idintegerNo0——
Range: 1 to 5000Length: —
Examples: 399, 3834, 4837, 4573, 637
Values: —
Quality checks: Passed
Invalid geometry count: 0
Columns hash: da3a7b58bfc8dfa92ca5cc5691bf43f9b297d78156be365fa7eeb0b62404d067