Back to file

Schema

EPA Disaster Debris Recovery Data / epa-disaster-debris-recovery-data / v1.0.0

View metadata

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

Columns
27 columns
Features
22,877
Geometry
Point
ColumnTypeNullableNullsUniqueDescriptionExamples / Values
geometrygeometryNo0
Range: Length:
Examples:
Values:
CompanystringNo0
Range: Length: 93
Examples: Choctaw County Regional Landfill, ADT Auto Service, Key Corporation, WATERFORD, TOWN OF, Alsobrook Recycling
Values:
AddressstringNo0
Range: Length: 85
Examples: 239 Fire Tower Rd, 293 Worcester Road, 170 Fiore Industrial Dr, 366 VALLEY RD, 3605 Hiram Douglasvile Hwy
Values:
CitystringNo0
Range: Length: 25
Examples: Butler, Charlton, WAKEFIELD, Waterford, Hiram
Values:
StatestringNo0
Range: Length: 2
Examples: AL, MA, RI, ME, GA
Values: AL, CT, FL, GA, KY, MA, ME, MS, NC, NH, RI, SC, TN, VT
ZipstringNo0
Range: Length: 6
Examples: 36904, 01507, 02879, 04088, 30141
Values:
PhonestringNo0
Range: Length: 12
Examples: 205-459-3148, 508-248-6800, 401-723-2000, 207-583-4403, 678-567-5544
Values:
LatitudefloatNo0
Range: 24.5684177105 to 47.305038Length:
Examples: 31.6933907389, 42.14732, 41.463359, 44.203519, 33.8423111712
Values:
LongitudefloatNo0
Range: -91.39732007 to -66.995372Length:
Examples: -86.6835370862, -71.941942, -71.499902, -70.732702, -84.7578322941
Values:
RecoveryintegerNo0
Range: 0 to 1Length:
Examples: 0, 1, 1, 1, 1
Values:
LandfillintegerNo0
Range: 0 to 1Length:
Examples: 1, 0, 0, 0, 0
Values:
C_DintegerNo0
Range: 0 to 1Length:
Examples: 0, 0, 0, 0, 0
Values:
CompostingintegerNo0
Range: 0 to 1Length:
Examples: 0, 0, 0, 0, 0
Values:
DemolitionintegerNo0
Range: 0 to 1Length:
Examples: 0, 0, 1, 0, 0
Values:
ElectronicsintegerNo0
Range: 0 to 1Length:
Examples: 0, 0, 0, 0, 0
Values:
HHWintegerNo0
Range: 0 to 1Length:
Examples: 0, 0, 0, 0, 0
Values:
MetalsintegerNo0
Range: 0 to 1Length:
Examples: 0, 0, 0, 0, 1
Values:
TiresintegerNo0
Range: 0 to 1Length:
Examples: 0, 0, 0, 0, 0
Values:
Transfer_StationintegerNo0
Range: 0 to 1Length:
Examples: 0, 0, 0, 1, 0
Values:
VehiclesintegerNo0
Range: 0 to 1Length:
Examples: 0, 1, 0, 0, 0
Values:
LF_C_DintegerNo0
Range: 0 to 1Length:
Examples: 0, 0, 0, 0, 0
Values:
LF_HWintegerNo0
Range: 0 to 1Length:
Examples: 0, 0, 0, 0, 0
Values:
LF_MSWintegerNo0
Range: 0 to 1Length:
Examples: 1, 0, 0, 0, 0
Values:
RegionintegerNo0
Range: 1 to 4Length:
Examples: 4, 1, 1, 1, 4
Values:
FRS_IDstringYes3,974
Range: Length: 12
Examples: 110008415704, 110043697522, 110070007515, 110009717182, 110039666313
Values:
FRS_REPORT_URLstringYes3,974
Range: Length: 109
Examples: https://frs-public.epa.gov/ords/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110008415704, https://frs-public.epa.gov/ords/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110043697522, https://frs-public.epa.gov/ords/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110070007515, https://frs-public.epa.gov/ords/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110009717182, https://frs-public.epa.gov/ords/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110039666313
Values:
GlobalIDstringNo0
Range: Length: 38
Examples: {E0B47EE6-8A33-4E48-ADE0-02C7A26D846A}, {C697F64D-54CF-48F1-B13C-3617929CB092}, {3A9B0EAC-399A-408F-AF7B-2EA5921B8A50}, {4005B304-0B30-48C1-8D44-8A177B8E49FA}, {EAD865BF-551B-47B4-87CF-457D72E888DF}
Values:
Invalid geometry count: 0
Columns hash: e7211ecb9968365b33c31a73b0b3e7967363b3764f9833031c375dd336601220