Back to fileView metadata
Schema
NFIP Community Boundaries / NFIP Community Layer Comprehensive / v1.0.0
Schema from comprehensive.parquet, gcs-hifld-next-datasets-prod, v1.0.0.
Columns
23 columns
Features
51,943
Geometry
MultiPolygon
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| id | integer | No | 0 | — | — Range: 1 to 5000Length: — | Examples: 399, 3834, 4837, 4573, 637 Values: — |
| communityIdNumber | string | Yes | 735 | — | — Range: —Length: 6 | Examples: 360168, 270453, 280116, 190922, 170981 Values: — |
| stateCode | string | Yes | 182 | — | — Range: —Length: 2 | Examples: 34, 19, 49, 01, 09 Values: — |
| countyCode | string | Yes | 182 | — | — Range: —Length: 5 | Examples: 34035, 19107, 49011, 01057, 09190 Values: — |
| censusGeoid | string | Yes | 210 | — | — Range: —Length: 10 | Examples: 0117968, 0119648, 5336045, 4809250, 4711280 Values: — |
| county | string | Yes | 182 | — | — Range: —Length: 24 | Examples: Somerset, Keokuk, Davis, Fayette, Western Connecticut Values: — |
| communityName | string | Yes | 735 | — | — Range: —Length: 50 | Examples: PLATTSBURGH, CITY OF, RICHMOND, CITY OF, AMORY, CITY OF, DURANT, CITY OF, PHILO, VILLAGE OF Values: — |
| communityNameShort | string | Yes | 735 | — | — Range: —Length: 50 | Examples: PLATTSBURGH, RICHMOND, AMORY, DURANT, PHILO Values: — |
| censusYear | integer | No | 0 | — | — Range: 2023 to 2023Length: — | Examples: 2023, 2023, 2023, 2023, 2023 Values: — |
| censusPopulationEntire | float | Yes | 715 | — | — Range: 0 to 897041Length: — | Examples: 3128.0, 6569.0, 422.0, 46461.0, 329.0 Values: — |
| censusHousingUnitsEntire | float | Yes | 715 | — | — Range: 0 to 402518Length: — | Examples: 1122.0, 2957.0, 167.0, 19097.0, 156.0 Values: — |
| landAreaEntire | float | No | 0 | — | — Range: 0.0000053918 to 380476.84Length: — | Examples: 1.8512617, 1.1589689, 0.7129966, 11.729687, 20.200932 Values: — |
| cisType | string | Yes | 736 | — | — Range: —Length: 23 | Examples: CITY, TOWN, TOWN, VILLAGE, TOWN Values: BOROUGH, CHARTER TOWNSHIP, CITY, CONSOLIDATED GOVERNMENT, COUNTY, COUNTY*, MAINE ISLAND, MAINE PLANTATION, MUNICIPALITY, SLUA, TERRITORY, TOWN, TOWNSHIP, TRIBE, VILLAGE |
| cisSource | string | Yes | 735 | — | — Range: —Length: 5 | Examples: PIVOT, PIVOT, PIVOT, PIVOT, PIVOT Values: PIVOT |
| geometrySource | string | No | 0 | — | — Range: —Length: 17 | Examples: Census Place, Census Place, Census Place, NFHL, Census Place Values: Census Concity, Census County, Census Cousub, Census Funcstat S, Census Place, Maine State GIS, NFHL |
| alternateGeoid | string | Yes | 4,058 | — | — Range: —Length: 22 | Examples: 37163C_370637, 13090, 13090, 38057C_380721, 48157C_481590 Values: — |
| alternateName | string | No | 0 | — | — Range: —Length: 85 | Examples: Hedley, Keystone, Eddyville, TOWN OF HERTFORD ETJ, EXTRATERRITORIAL JURISDICTION, HERTFORD ETJ, Midway Values: — |
| alternateLongName | string | Yes | 210 | — | — Range: —Length: 47 | Examples: County Line town, Daphne city, Kittitas city, Bolivar Peninsula CDP, Carthage town Values: — |
| layerCreationNotes | string | Yes | 4,264 | — | — Range: —Length: 99 | Examples: alt_geoid, alt_name, geometry from Maine GIS; geoid and alt_namelsad from census using spatial join, alt_geoid, alt_name, geometry from Maine GIS; geoid and alt_namelsad from census using spatial join, alt_geoid, alt_name, geometry from Maine GIS; geoid and alt_namelsad from census using spatial join, alt_geoid, alt_name, geometry from Maine GIS; geoid and alt_namelsad from census using spatial join, alt_geoid, alt_name, geometry from Maine GIS; geoid and alt_namelsad from census using spatial join Values: alt_geoid, alt_name, geometry from Maine GIS; geoid and alt_namelsad from census using spatial join |
| censusClassCodes | string | Yes | 210 | — | — Range: —Length: 2 | Examples: C1, C1, C1, U1, C1 Values: C1, C2, C3, C5, C6, C7, C9, H1, H4, H5, H6, M2, T1, U1, U2, Z1, Z2 |
| censusFunctionalStatusCodes | string | Yes | 792 | — | — Range: —Length: 1 | Examples: A, A, A, A, A Values: A, B, C, F, I, N, S |
| layerTypeCode | string | No | 0 | — | — Range: —Length: 20 | Examples: Place, Place, Place, ETJ, Place Values: Consolidated City, County, County Subdivision, ETJ, Maine Town/Township, Place, Place (multi-county), SLUA, Statistical Area, TRIBE |
Quality checks: Passed
Invalid geometry count: 0
Columns hash: 6bbe5a570595255d302034ee174031abc9460375d1b1391504b0e2300229d164