Back to file

Schema

NFHL / study-info / v1.0.0

View metadata

Schema from GeoPackage, GCS hifld-next-datasets-prod, v1.0.0.

Columns
33 columns
Features
2,614
Geometry
ColumnTypeNullableNullsUniqueDescriptionExamples / Values
geometrygeometryYes2,614
Range: Length:
Examples:
Values:
OBJECTIDintegerNo0
Range: 1541 to 129370Length:
Examples: 121720, 129151, 129095, 123819, 128795
Values:
DFIRM_IDstringYes1
Range: Length: 6
Examples: 41009C, 51009C, 28083C, 36059C, 42019C
Values:
VERSION_IDstringYes1
Range: Length: 7
Examples: 1.1.1.0, 2.6.4.6, 2.5.3.6, 1.1.1.0, 1.1.1.0
Values:
STD_NFO_IDstringYes31
Range: Length: 30
Examples: 54063C_1, 17167C_1, 20017C_1, 31065C, 51031C_1
Values:
STUDY_PREstringYes2,411
Range: Length: 19
Examples: <Null>, <Null>, <Null>, <Null>, <Null>
Values: 1, <Null>, Borough Of, Borough of, C, City And County Of, City Of, City and County of, City of, County, NP, Null, Other, Town And Village Of, Town and Village of, Town of, Township of, Village Of, Village of
STUDY_NMstringYes4
Range: Length: 104
Examples: MIDDLESEX COUNTY, JACKSON COUNTY, EDWARDS COUNTY, Larimer County PMR, GAGE COUNTY
Values:
STATE_NMstringYes1
Range: Length: 24
Examples: Oregon, Virginia, Mississippi, New York, Pennsylvania
Values:
CNTY_NMstringYes3
Range: Length: 50
Examples: Winneshiek County, CARTERET COUNTY, EDWARDS COUNTY, DOUGLAS COUNTY, AUDUBON COUNTY
Values:
JURIS_TYPstringYes33
Range: Length: 22
Examples: And Incorporated Areas, And Incorporated Areas, And Incorporated Areas, And Incorporated Areas, And Incorporated Areas
Values:
LG_PAN_NOstringYes3
Range: Length: 4
Examples: 0625, 8580, 500, 0495, 0375
Values:
OPP_TFstringYes1
Range: Length: 1
Examples: F, F, F, F, F
Values: F, T, U
H_DATUMstringYes1
Range: Length: 30
Examples: North American Datum 1983, North American Datum 1983, North American Datum 1983, North American Datum 1983, North American Datum 1983
Values: NAD 83, NAD27, NAD83, NAD83 (NSRS2007), NAD83 HARN, NAD83NSPNU, NP, North American Datum 1927, North American Datum 1983, North American Datum 1983 HARN, WGS84
V_DATUMstringYes2
Range: Length: 17
Examples: NAVD88, NAVD88, NAVD88, NAVD88, NAVD88
Values: ASVD02, GUVD03, LOCAL TIDAL DATUM, MLLW, MSL, NAVD88, NGVD29
PROJECTIONstringYes4
Range: Length: 75
Examples: UNIVERSAL TRANSVERSE MERCATOR, STATE PLANE LAMBERT CONFORMAL CONIC, ARKANSAS NORTH ZONE, UTM, UNIVERSAL TRANSVERSE MERCATOR, UNIVERSAL TRANSVERSE MERCATOR
Values:
PROJ_ZONEstringYes32
Range: Length: 5
Examples: 17, 1702, 1600, 2600, 4202
Values:
PROJ_UNITstringYes10
Range: Length: 18
Examples: Meters, Meters, NP, US Survey Feet, NP
Values: Decimal Degrees, International Feet, METERS, Meters, NP, U.S. Survey Feet, US SURVEY FEET, US Survey Feet
PROJ_SECNDstringYes1,828
Range: Length: 64
Examples: UNIVERSAL TRANSVERSE MERCATOR, UNIVERSAL TRANSVERSE MERCATOR, UNIVERSAL TRANSVERSE MERCATOR, UNIVERSAL TRANSVERSE MERCATOR, STATE PLANE LAMBERT CONFORMAL CONIC, MONTANA ZONE
Values:
PROJ_SUNITstringYes1,832
Range: Length: 18
Examples: US Survey Feet, Meters, Meters, Meters, Meters
Values: Decimal Degrees, Feet, International Feet, Meters, NP, US Survey Feet
PROJ_SZONEstringYes1,915
Range: Length: 5
Examples: 16, 15, 16, 4501, 0102
Values:
LANDWD_VALfloatYes3
Range: -9999 to 601.1Length:
Examples: -9999.0, -8888.0, -8888.0, 0.0, -8888.0
Values:
CW_TFstringYes1
Range: Length: 1
Examples: T, T, T, T, T
Values: F, T
RTROFT_TFstringYes2
Range: Length: 1
Examples: F, F, F, T, T
Values: F, T, U
META_NMstringYes7
Range: Length: 34
Examples: 25017C_20160706_metadata.xml, 05067C_20170607_METADATA.XML, 20047C_20080116_METADATA, 17187C_20210810_metadata.xml, 51121C_20120106_metadata.txt
Values:
FIS_NMstringYes6
Range: Length: 15
Examples: NP, NP, NP, 26151CV000B.pdf, 01045CV000B.pdf
Values:
LOGO_NMstringYes41
Range: Length: 41
Examples: FEMA.jpeg, NP, NP, NP, NP
Values:
INDX_EFFDTstringYes2
Range: Length: 10
Examples: 2021-05-04, 2025-01-17, 8888-08-08, 2021-08-10, 2016-05-02
Values:
DBREV_DTstringYes787
Range: Length: 10
Examples: 2018-02-16, 2019-10-07, 2017-12-21, 2011-04-25, 2022-11-17
Values:
AVG_CFACTRfloatYes9
Range: -9999 to 9Length:
Examples: -9999.0, -9999.0, -9999.0, -9999.0, -0.177
Values:
GFIDstringYes515
Range: Length: 36
Examples: 20120106, c56f33ac-a6ce-47f4-b42f-b8bdc76e83d1, 20140630, ca6cd8fd-0928-4e20-b4c3-831e7f8f5d4f, f4b5c638-f185-4e5d-9e2a-0b42411c45b5
Values:
INDX_SUFFXstringYes2,410
Range: Length: 1
Examples: B, C, A, B, C
Values: A, B, C, D, E, F, G, H, I, J, U
GlobalIDstringNo0
Range: Length: 38
Examples: {E524C724-10CB-4C9C-B105-51E3CF2BF73B}, {9FECB9F8-D406-4D68-8361-86DB2342FE38}, {90BCC699-35A6-4E42-BCB0-49355CBD041D}, {5E2CE4BD-13FB-4496-80AF-4355D089DE07}, {E18714CB-6AB3-4BD5-8874-A154375234AA}
Values:
idintegerNo0
Range: 1541 to 129370Length:
Examples: 121720, 129151, 129095, 123819, 128795
Values:
Invalid geometry count: 0
Columns hash: 51a4f903ab112ad23bdca648697a2d383e07805f3be6ca669f22e23b755c65e3