{"links":{"self":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/icis-wastewater-treatment-plants/files/icis-wastewater-treatment-plants","dataset":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/icis-wastewater-treatment-plants","collection":"https://hifld.publicenvirodata.org/api/collections/hifld"},"collection":{"slug":"hifld","description":"HIFLD (Homeland Infrastructure Foundation-Level Data) datasets","id":1,"created_at":"2026-02-13T02:52:43.921817","updated_at":"2026-02-13T02:52:43.921841","name":"HIFLD"},"dataset":{"slug":"icis-wastewater-treatment-plants","name":"Integrated Compliance Information System (ICIS) Wastewater Treatment Plants","id":3140,"description":"The Facility Registry Service (FRS) provides quality facility data to support EPA's mission of protecting human health and the environment by identifying and geospatially locating facilities, sites, or places subject to environmental regulations of environmental interest. Facility data is improved with geospatial processing of incoming data and data curation tools to provide an integrated, dataset to partners and the public through a variety of methods and products. For more detailed information about these facilities, use the FRS Query tool. This layer provides location and facility information for wastewater treatment plants from the Integrated Compliance Information System (ICIS). The data are presented with three different view options at the facility level: 1.) display of Publicly Owned Treatment Works and Federal facilities, 2.) Display of all facilities, categorized as Major, Minor and Other/Nonclassified, and 3.) Display of facilities with Combined Sewer Outfalls. ICIS contains all Federal Administrative and Judicial enforcement actions and a subset of the Permit Compliance System (PCS), which supports the National Pollutant Discharge Elimination System (NPDES). To learn more about ICIS click here or use the Enforcement and Compliance History Online (ECHO) database.","collection_id":1,"tags":{"inventory_name":"icis-wastewater-treatment-plants","categories":["Water Supply","Public Health","Emergency Services"]},"created_at":"2026-02-15T06:48:01.618948","updated_at":"2026-02-15T06:48:01.618972"},"file":{"slug":"icis-wastewater-treatment-plants","layer_name":null,"file_metadata":null,"updated_at":"2026-05-19T21:59:25.685095","id":4357,"name":"icis-wastewater-treatment-plants","dataset_id":3140,"description":"The Facility Registry Service (FRS) provides quality facility data to support EPA's mission of protecting human health and the environment by identifying and geospatially locating facilities, sites, or places subject to environmental regulations of environmental interest. Facility data is improved with geospatial processing of incoming data and data curation tools to provide an integrated, dataset to partners and the public through a variety of methods and products. For more detailed information about these facilities, use the FRS Query tool. This layer provides location and facility information for wastewater treatment plants from the Integrated Compliance Information System (ICIS). The data are presented with three different view options at the facility level: 1.) display of Publicly Owned Treatment Works and Federal facilities, 2.) Display of all facilities, categorized as Major, Minor and Other/Nonclassified, and 3.) Display of facilities with Combined Sewer Outfalls. ICIS contains all Federal Administrative and Judicial enforcement actions and a subset of the Permit Compliance System (PCS), which supports the National Pollutant Discharge Elimination System (NPDES). To learn more about ICIS click here or use the Enforcement and Compliance History Online (ECHO) database.","source_file_path":null,"created_at":"2026-05-19T21:59:25.685069","formats":[{"format":{"description":"ESRI File Geodatabase format for geospatial data storage","format_type":"file_geodatabase","created_at":"2026-02-15T03:18:57.882712","id":7,"name":"File Geodatabase","mime_type":"application/x-esri-shape","updated_at":"2026-02-15T03:18:57.882736"},"file_format":{"id":18140,"format_id":7,"created_at":"2026-05-19T21:59:25.888676","file_id":4357,"updated_at":"2026-05-19T21:59:25.888702"},"sources":[{"storage_location_id":1,"version":"v1.0.0","source_type":"file","references_source_id":null,"updated_at":"2026-08-14T07:01:27.020687","id":18682,"file_format_id":18140,"created_at":"2026-05-19T21:59:26.064535","location":{"type":"file","version":"v1","path":"icis-wastewater-treatment-plants/icis-wastewater-treatment-plants/v1.0.0/file_geodatabase/icis-wastewater-treatment-plants-file_geodatabase.zip"},"source_metadata":{"version":"v1","description":null,"size_bytes":3223926,"mime_type":null,"feature_count":18885,"bounds":[-176.646252,-14.340056,174.107672,71.323851],"geometry_type":"Point","invalid_geometry_count":0,"quality_check_passed":true,"columns_hash":"6fa27353ef118653ef28e6a4a789974f130cf96114c7fbb873c24252fc5334e7","columns":[{"name":"geometry","type":"geometry","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":null,"min":null,"max":null,"length":null,"possible_values":null},{"name":"OBJECTID_1","type":"float","description":null,"nullable":true,"num_null_values":1372,"num_unique_values":null,"example_values":["36159270.0","34842614.0","31586792.0","15516450.0","31706119.0"],"min":12431365,"max":39368547,"length":null,"possible_values":null},{"name":"CWP_DATE_LAST_INST_EPA","type":"string","description":null,"nullable":true,"num_null_values":3493,"num_unique_values":null,"example_values":["1980-06-26T00:00:00+00:00","2019-03-08T00:00:00+00:00","1984-09-17T00:00:00+00:00","1995-04-20T00:00:00+00:00","1991-04-16T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CASE_IDS","type":"string","description":null,"nullable":true,"num_null_values":4890,"num_unique_values":null,"example_values":["02-2020-3008","06-2022-1740","01-2018-2013","05-2020-0308","06-2010-1780"],"min":null,"max":null,"length":77,"possible_values":null},{"name":"CWP_DATE_LAST_PENALTY","type":"string","description":null,"nullable":true,"num_null_values":3783,"num_unique_values":null,"example_values":["2022-01-20T00:00:00+00:00","2003-04-02T00:00:00+00:00","2005-11-02T00:00:00+00:00","2002-08-27T00:00:00+00:00","2015-09-08T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_COMPLIANCE_TRACKING","type":"string","description":null,"nullable":true,"num_null_values":10,"num_unique_values":null,"example_values":["On","On","On","On","Off"],"min":null,"max":null,"length":7,"possible_values":["Off","On","Partial"]},{"name":"CWP_SNC_FLAG","type":"string","description":null,"nullable":true,"num_null_values":4557,"num_unique_values":null,"example_values":["Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit"],"min":null,"max":null,"length":39,"possible_values":["Compliance/Permit Schedule - Reporting","Compliance/Permit Schedule - Violations","Effluent - Monthly Average Limit","Effluent - Non-monthly Average Limit","Failure to Report DMR - Not Received"]},{"name":"CWP_DATE_LAST_IKEA_ST","type":"string","description":null,"nullable":true,"num_null_values":2166,"num_unique_values":null,"example_values":["2022-09-26T00:00:00+00:00","2007-02-07T00:00:00+00:00","2005-04-20T00:00:00+00:00","2014-04-16T00:00:00+00:00","2015-11-30T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_DATE_LAST_FEAT_EPA","type":"string","description":null,"nullable":true,"num_null_values":4222,"num_unique_values":null,"example_values":["2009-09-03T00:00:00+00:00","1991-06-25T00:00:00+00:00","1992-07-20T00:00:00+00:00","2021-12-21T00:00:00+00:00","1986-03-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_DATE_LAST_FEAT_ST","type":"string","description":null,"nullable":true,"num_null_values":2938,"num_unique_values":null,"example_values":["2009-09-28T00:00:00+00:00","2007-10-11T00:00:00+00:00","2021-02-04T00:00:00+00:00","1988-08-26T00:00:00+00:00","2020-02-21T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_DATE_LAST_FEAT","type":"string","description":null,"nullable":true,"num_null_values":2644,"num_unique_values":null,"example_values":["1995-12-11T00:00:00+00:00","2015-07-10T00:00:00+00:00","2018-04-18T00:00:00+00:00","2004-01-15T00:00:00+00:00","2019-04-15T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"STATE_WATER_BODY","type":"string","description":null,"nullable":true,"num_null_values":1234,"num_unique_values":null,"example_values":["WB8533","05030101","58","03070103, 030701030950","05050008"],"min":null,"max":null,"length":43,"possible_values":null},{"name":"CWP_SNC_EVENT_DESC","type":"string","description":null,"nullable":true,"num_null_values":4557,"num_unique_values":null,"example_values":["SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average"],"min":null,"max":null,"length":42,"possible_values":["SNC DMR Non-Receipt Violation","SNC Effluent Violation Monthly Average","SNC Effluent Violation Non-Monthly Average","SNC Schedule Event Violation","SNC Schedule Report Violation"]},{"name":"CWP_CURRENT_SNC_STATUS_DATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":["2022-06-30T00:00:00+00:00"]},{"name":"FEDERAL_AGENCY_NAME","type":"string","description":null,"nullable":true,"num_null_values":4970,"num_unique_values":null,"example_values":["C6800","C6800","C1500","C6800","C6800"],"min":null,"max":null,"length":5,"possible_values":["C1409","C1500","C6800","C9100","D2100","D5700","D9600"]},{"name":"FEDERAL_LAND_IND","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"NPDES_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["MN0003182","AKG573029","CO0043711","TN0022888","PA0092339"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"REGISTRY_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["110056979328","110056343657","110011372068","110006367680","110001060459"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"CWP_NAME","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["LITTLE FALLS WTP","KING SALMON LAGOON","AULT, TOWN OF","LEWISBURG STP","BELL ACRES MUNICIPAL SEW AUTH"],"min":null,"max":null,"length":80,"possible_values":null},{"name":"CWP_STREET","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["100 7TH AVE NE","PO BOX 189","UNKNOWN","100 WATER STREET","GROUSE RIDGE STP"],"min":null,"max":null,"length":50,"possible_values":null},{"name":"CWP_CITY","type":"string","description":null,"nullable":true,"num_null_values":30,"num_unique_values":null,"example_values":["GREENSBURG","GRACEVILLE","EAGLE LAKE","MUNDELEIN","COLUSA"],"min":null,"max":null,"length":45,"possible_values":null},{"name":"CWP_STATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["MN","AK","CO","TN","PA"],"min":null,"max":null,"length":2,"possible_values":null},{"name":"CWP_ZIP","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["563452300","99633","80610","37091","15143"],"min":null,"max":null,"length":10,"possible_values":null},{"name":"CWP_COUNTY","type":"string","description":null,"nullable":true,"num_null_values":175,"num_unique_values":null,"example_values":["Ellis","St. Lawrence","Pinellas","Canadian","Kandiyohi"],"min":null,"max":null,"length":22,"possible_values":null},{"name":"CWP_EPA_REGION","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["05","10","08","04","03"],"min":null,"max":null,"length":2,"possible_values":["01","02","03","04","05","06","07","08","09","10"]},{"name":"CWP_INDIAN_CNTRY_FLG","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"CWP_TRIBAL_LAND_CODE","type":"string","description":null,"nullable":true,"num_null_values":4903,"num_unique_values":null,"example_values":["R751","R202","R201","R202","R430"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"CWP_VERSION_NUMBER","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":0,"length":null,"possible_values":null},{"name":"CWP_EXPIRATION_DATE","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["2025-07-31T00:00:00+00:00","2021-11-30T00:00:00+00:00","2023-07-31T00:00:00+00:00","2018-09-30T00:00:00+00:00","2026-05-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_FACILITY_TYPE_INDICATOR","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["POTW","POTW","POTW","POTW","POTW"],"min":null,"max":null,"length":4,"possible_values":["POTW"]},{"name":"MASTER_EXTERNAL_PERMIT_NUMBER","type":"string","description":null,"nullable":true,"num_null_values":4324,"num_unique_values":null,"example_values":["MTG580000","WV0115924","ILG580000","ILG580000","WV0115924"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"ISSUING_AGENCY","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["State","State","State","State","State"],"min":null,"max":null,"length":5,"possible_values":["EPA","State"]},{"name":"CWP_ISSUE_DATE","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["2020-07-15T00:00:00+00:00","2016-11-02T00:00:00+00:00","2018-06-29T00:00:00+00:00","2013-10-29T00:00:00+00:00","2021-06-01T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_EFFECTIVE_DATE","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["2022-06-24T00:00:00+00:00","2016-12-01T00:00:00+00:00","2018-08-01T00:00:00+00:00","2013-10-29T00:00:00+00:00","2021-06-01T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_TERMINATION_DATE","type":"string","description":null,"nullable":true,"num_null_values":4229,"num_unique_values":null,"example_values":["2022-04-26T00:00:00+00:00","2021-05-01T00:00:00+00:00","2013-01-01T00:00:00+00:00","2018-06-04T00:00:00+00:00","2008-12-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_PERMIT_STATUS_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["EFF","EFF","TRM","EFF","TRM"],"min":null,"max":null,"length":3,"possible_values":["ADC","EFF","EXP","NON","PND","TRM"]},{"name":"CWP_PERMIT_STATUS_DESC","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Effective","Effective","Terminated","Effective","Terminated"],"min":null,"max":null,"length":15,"possible_values":["Admin Continued","Effective","Expired","Not Needed","Pending","Terminated"]},{"name":"CWP_PERMIT_TYPE_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["NPD","GPC","SIN","NPD","NPD"],"min":null,"max":null,"length":3,"possible_values":["GPC","NPD","SIN"]},{"name":"CWP_PERMIT_TYPE_DESC","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["NPDES Individual Permit","General Permit Covered Facility","Individual State Issued Permit (Non-NPDES)","NPDES Individual Permit","NPDES Individual Permit"],"min":null,"max":null,"length":42,"possible_values":["General Permit Covered Facility","Individual State Issued Permit (Non-NPDES)","NPDES Individual Permit"]},{"name":"SIC_CODES","type":"string","description":null,"nullable":true,"num_null_values":70,"num_unique_values":null,"example_values":["4952","1629","4952","4952","1629"],"min":null,"max":null,"length":19,"possible_values":null},{"name":"NAICS_CODES","type":"string","description":null,"nullable":true,"num_null_values":3899,"num_unique_values":null,"example_values":["221320","221320","221320","221320","221320"],"min":null,"max":null,"length":13,"possible_values":["221112","221310","221310 221320","221320","221320 112111","221320 221310","221320 611110","237110","311612","488119","541330","562219","611110","721120","721120 221320","921190","922140 221320","924110"]},{"name":"FAC_DERIVED_FIPS","type":"string","description":null,"nullable":true,"num_null_values":2,"num_unique_values":null,"example_values":["28031","21021","13285","25027","01083"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"FAC_DERIVED_HUC","type":"string","description":null,"nullable":true,"num_null_values":84,"num_unique_values":null,"example_values":["07030001","04040001","02050201","12040104","07080102"],"min":null,"max":null,"length":8,"possible_values":null},{"name":"FAC_US_MEXICO_BORDER_FLG","type":"string","description":null,"nullable":true,"num_null_values":4459,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"CWP_CURRENT_SNC_STATUS","type":"string","description":null,"nullable":true,"num_null_values":4557,"num_unique_values":null,"example_values":["Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit"],"min":null,"max":null,"length":39,"possible_values":["Compliance/Permit Schedule - Reporting","Compliance/Permit Schedule - Violations","Effluent - Monthly Average Limit","Effluent - Non-monthly Average Limit","Failure to Report DMR - Not Received"]},{"name":"CWP_CURRENT_VIOL","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["No","Yes","No","Yes","No"],"min":null,"max":null,"length":3,"possible_values":["No","Yes"]},{"name":"CWP_LAST_INSPECTION","type":"string","description":null,"nullable":true,"num_null_values":368,"num_unique_values":null,"example_values":["2022-02-11T00:00:00+00:00","2010-04-21T00:00:00+00:00","2022-08-31T00:00:00+00:00","2016-09-20T00:00:00+00:00","2022-08-18T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_LAST_INFORMAL_EA","type":"string","description":null,"nullable":true,"num_null_values":2029,"num_unique_values":null,"example_values":["2021-11-10T00:00:00+00:00","2017-06-20T00:00:00+00:00","2020-11-13T00:00:00+00:00","1986-11-05T00:00:00+00:00","2022-10-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_MAJOR_MINOR_TYPE_FLAG","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["M","M","M","N","N"],"min":null,"max":null,"length":1,"possible_values":["M","N"]},{"name":"STATE_WATER_BODY_NAME","type":"string","description":null,"nullable":true,"num_null_values":275,"num_unique_values":null,"example_values":["BOGUE CHITTO CREEK, STRAIGHT FENCE CREEK","POTOMAC RIVER","CLARKS RIVER / EAST FORK, DITCH TO UT TO CLARKS RIVER","KINDERHOOK CK","GREAT MIAMI RIVER, TWO MILE CREEK"],"min":null,"max":null,"length":303,"possible_values":null},{"name":"SOURCE_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["MN0003182","AKG573029","CO0043711","TN0022888","PA0092339"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"FAC_MAP_FLG","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"CWP_13QTRS_COMPL_STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["_____________","__VVSVVSVVVV_","             ","VS__VVVVVVVVV","             "],"min":null,"max":null,"length":13,"possible_values":null},{"name":"FAC_TRI_REPORTER","type":"string","description":null,"nullable":true,"num_null_values":4985,"num_unique_values":null,"example_values":["B","P","P","P","P"],"min":null,"max":null,"length":1,"possible_values":["B","P"]},{"name":"FAC_MAP_ICON","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CWA-IC-MN-4.png","CWA-NC-MN-G.png","CWA-IA-MN-G.png","CWA-NC-MJ-1.png","CWA-IA-MN-G.png"],"min":null,"max":null,"length":16,"possible_values":null},{"name":"CWP_IMP_WATER_FLG","type":"string","description":null,"nullable":true,"num_null_values":2662,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"FAC_FEDERAL_AGENCY_CODE","type":"string","description":null,"nullable":true,"num_null_values":4970,"num_unique_values":null,"example_values":["C6800","C6800","C1500","C6800","C6800"],"min":null,"max":null,"length":5,"possible_values":["C1409","C1500","C6800","C9100","D2100","D5700","D9600"]},{"name":"CWP_DATE_LAST_INST_ST","type":"string","description":null,"nullable":true,"num_null_values":470,"num_unique_values":null,"example_values":["2022-09-06T00:00:00+00:00","2022-08-29T00:00:00+00:00","2010-11-10T00:00:00+00:00","2020-11-17T00:00:00+00:00","2018-07-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_FACILITY_TYPE_DESC","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Non-Federal","Non-Federal","Non-Federal","Non-Federal","Non-Federal"],"min":null,"max":null,"length":11,"possible_values":["Non-Federal"]},{"name":"CWP_CSO_FLAG","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"CWP_MAJOR_MINOR_STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Minor","Minor","Minor","Major","Minor"],"min":null,"max":null,"length":19,"possible_values":["Major","Minor","Other/Nonclassified"]},{"name":"FAC_LAT","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["45.984925","58.703343","40.574417","35.450939999999996","40.588074999999996"],"min":13.5403,"max":71.32385099999999,"length":null,"possible_values":null},{"name":"FAC_LONG","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["-94.359393","-156.735023","-104.733833","-86.78791","-80.17727099999999"],"min":-169.539986,"max":145.75,"length":null,"possible_values":null}]},"url":"https://hifld.publicenvirodata.org/storage/icis-wastewater-treatment-plants/icis-wastewater-treatment-plants/v1.0.0/file_geodatabase/icis-wastewater-treatment-plants-file_geodatabase.zip","storage_uri":"gs://hifld-next-datasets-prod/icis-wastewater-treatment-plants/icis-wastewater-treatment-plants/v1.0.0/file_geodatabase/icis-wastewater-treatment-plants-file_geodatabase.zip","storage_location":{"name":"GCS hifld-next-datasets-prod","description":"Google Cloud Storage production bucket for dataset files","updated_at":"2026-02-13T02:39:54.364528","slug":"gcs-hifld-next-datasets-prod","id":1,"backend_type":"s3","created_at":"2026-02-13T02:39:54.364506","config":{"version":"v1","type":"gcs","base_url":"https://hifld.publicenvirodata.org/storage","bucket":"hifld-next-datasets-prod"}},"links":{"download_zip":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/icis-wastewater-treatment-plants/files/icis-wastewater-treatment-plants/sources/18682/download-zip"}}]},{"format":{"description":"GeoJSON format for encoding geographic data structures","format_type":"geojson","created_at":"2026-02-15T03:18:57.713811","id":6,"name":"GeoJSON","mime_type":"application/geo+json","updated_at":"2026-02-15T03:18:57.713833"},"file_format":{"id":18141,"format_id":6,"created_at":"2026-05-19T21:59:26.379383","file_id":4357,"updated_at":"2026-05-19T21:59:26.379407"},"sources":[{"storage_location_id":1,"version":"v1.0.0","source_type":"file","references_source_id":null,"updated_at":"2026-08-14T07:01:27.058961","id":18683,"file_format_id":18141,"created_at":"2026-05-19T21:59:26.566168","location":{"type":"file","version":"v1","path":"icis-wastewater-treatment-plants/icis-wastewater-treatment-plants/v1.0.0/geojson/icis-wastewater-treatment-plants-geojson.geojson"},"source_metadata":{"version":"v1","description":null,"size_bytes":40158755,"mime_type":null,"feature_count":18885,"bounds":[-176.646252,-14.340056,174.107672,71.323851],"geometry_type":"Point","invalid_geometry_count":0,"quality_check_passed":true,"columns_hash":"6fa27353ef118653ef28e6a4a789974f130cf96114c7fbb873c24252fc5334e7","columns":[{"name":"geometry","type":"geometry","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":null,"min":null,"max":null,"length":null,"possible_values":null},{"name":"OBJECTID_1","type":"float","description":null,"nullable":true,"num_null_values":1372,"num_unique_values":null,"example_values":["36159270.0","34842614.0","31586792.0","15516450.0","31706119.0"],"min":12431365,"max":39368547,"length":null,"possible_values":null},{"name":"CWP_DATE_LAST_INST_EPA","type":"string","description":null,"nullable":true,"num_null_values":3493,"num_unique_values":null,"example_values":["1980-06-26T00:00:00+00:00","2019-03-08T00:00:00+00:00","1984-09-17T00:00:00+00:00","1995-04-20T00:00:00+00:00","1991-04-16T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CASE_IDS","type":"string","description":null,"nullable":true,"num_null_values":4890,"num_unique_values":null,"example_values":["02-2020-3008","06-2022-1740","01-2018-2013","05-2020-0308","06-2010-1780"],"min":null,"max":null,"length":77,"possible_values":null},{"name":"CWP_DATE_LAST_PENALTY","type":"string","description":null,"nullable":true,"num_null_values":3783,"num_unique_values":null,"example_values":["2022-01-20T00:00:00+00:00","2003-04-02T00:00:00+00:00","2005-11-02T00:00:00+00:00","2002-08-27T00:00:00+00:00","2015-09-08T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_COMPLIANCE_TRACKING","type":"string","description":null,"nullable":true,"num_null_values":10,"num_unique_values":null,"example_values":["On","On","On","On","Off"],"min":null,"max":null,"length":7,"possible_values":["Off","On","Partial"]},{"name":"CWP_SNC_FLAG","type":"string","description":null,"nullable":true,"num_null_values":4557,"num_unique_values":null,"example_values":["Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit"],"min":null,"max":null,"length":39,"possible_values":["Compliance/Permit Schedule - Reporting","Compliance/Permit Schedule - Violations","Effluent - Monthly Average Limit","Effluent - Non-monthly Average Limit","Failure to Report DMR - Not Received"]},{"name":"CWP_DATE_LAST_IKEA_ST","type":"string","description":null,"nullable":true,"num_null_values":2166,"num_unique_values":null,"example_values":["2022-09-26T00:00:00+00:00","2007-02-07T00:00:00+00:00","2005-04-20T00:00:00+00:00","2014-04-16T00:00:00+00:00","2015-11-30T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_DATE_LAST_FEAT_EPA","type":"string","description":null,"nullable":true,"num_null_values":4222,"num_unique_values":null,"example_values":["2009-09-03T00:00:00+00:00","1991-06-25T00:00:00+00:00","1992-07-20T00:00:00+00:00","2021-12-21T00:00:00+00:00","1986-03-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_DATE_LAST_FEAT_ST","type":"string","description":null,"nullable":true,"num_null_values":2938,"num_unique_values":null,"example_values":["2009-09-28T00:00:00+00:00","2007-10-11T00:00:00+00:00","2021-02-04T00:00:00+00:00","1988-08-26T00:00:00+00:00","2020-02-21T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_DATE_LAST_FEAT","type":"string","description":null,"nullable":true,"num_null_values":2644,"num_unique_values":null,"example_values":["1995-12-11T00:00:00+00:00","2015-07-10T00:00:00+00:00","2018-04-18T00:00:00+00:00","2004-01-15T00:00:00+00:00","2019-04-15T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"STATE_WATER_BODY","type":"string","description":null,"nullable":true,"num_null_values":1234,"num_unique_values":null,"example_values":["WB8533","05030101","58","03070103, 030701030950","05050008"],"min":null,"max":null,"length":43,"possible_values":null},{"name":"CWP_SNC_EVENT_DESC","type":"string","description":null,"nullable":true,"num_null_values":4557,"num_unique_values":null,"example_values":["SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average"],"min":null,"max":null,"length":42,"possible_values":["SNC DMR Non-Receipt Violation","SNC Effluent Violation Monthly Average","SNC Effluent Violation Non-Monthly Average","SNC Schedule Event Violation","SNC Schedule Report Violation"]},{"name":"CWP_CURRENT_SNC_STATUS_DATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":["2022-06-30T00:00:00+00:00"]},{"name":"FEDERAL_AGENCY_NAME","type":"string","description":null,"nullable":true,"num_null_values":4970,"num_unique_values":null,"example_values":["C6800","C6800","C1500","C6800","C6800"],"min":null,"max":null,"length":5,"possible_values":["C1409","C1500","C6800","C9100","D2100","D5700","D9600"]},{"name":"FEDERAL_LAND_IND","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"NPDES_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["MN0003182","AKG573029","CO0043711","TN0022888","PA0092339"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"REGISTRY_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["110056979328","110056343657","110011372068","110006367680","110001060459"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"CWP_NAME","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["LITTLE FALLS WTP","KING SALMON LAGOON","AULT, TOWN OF","LEWISBURG STP","BELL ACRES MUNICIPAL SEW AUTH"],"min":null,"max":null,"length":80,"possible_values":null},{"name":"CWP_STREET","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["100 7TH AVE NE","PO BOX 189","UNKNOWN","100 WATER STREET","GROUSE RIDGE STP"],"min":null,"max":null,"length":50,"possible_values":null},{"name":"CWP_CITY","type":"string","description":null,"nullable":true,"num_null_values":30,"num_unique_values":null,"example_values":["GREENSBURG","GRACEVILLE","EAGLE LAKE","MUNDELEIN","COLUSA"],"min":null,"max":null,"length":45,"possible_values":null},{"name":"CWP_STATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["MN","AK","CO","TN","PA"],"min":null,"max":null,"length":2,"possible_values":null},{"name":"CWP_ZIP","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["563452300","99633","80610","37091","15143"],"min":null,"max":null,"length":10,"possible_values":null},{"name":"CWP_COUNTY","type":"string","description":null,"nullable":true,"num_null_values":175,"num_unique_values":null,"example_values":["Ellis","St. Lawrence","Pinellas","Canadian","Kandiyohi"],"min":null,"max":null,"length":22,"possible_values":null},{"name":"CWP_EPA_REGION","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["05","10","08","04","03"],"min":null,"max":null,"length":2,"possible_values":["01","02","03","04","05","06","07","08","09","10"]},{"name":"CWP_INDIAN_CNTRY_FLG","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"CWP_TRIBAL_LAND_CODE","type":"string","description":null,"nullable":true,"num_null_values":4903,"num_unique_values":null,"example_values":["R751","R202","R201","R202","R430"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"CWP_VERSION_NUMBER","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":0,"length":null,"possible_values":null},{"name":"CWP_EXPIRATION_DATE","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["2025-07-31T00:00:00+00:00","2021-11-30T00:00:00+00:00","2023-07-31T00:00:00+00:00","2018-09-30T00:00:00+00:00","2026-05-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_FACILITY_TYPE_INDICATOR","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["POTW","POTW","POTW","POTW","POTW"],"min":null,"max":null,"length":4,"possible_values":["POTW"]},{"name":"MASTER_EXTERNAL_PERMIT_NUMBER","type":"string","description":null,"nullable":true,"num_null_values":4324,"num_unique_values":null,"example_values":["MTG580000","WV0115924","ILG580000","ILG580000","WV0115924"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"ISSUING_AGENCY","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["State","State","State","State","State"],"min":null,"max":null,"length":5,"possible_values":["EPA","State"]},{"name":"CWP_ISSUE_DATE","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["2020-07-15T00:00:00+00:00","2016-11-02T00:00:00+00:00","2018-06-29T00:00:00+00:00","2013-10-29T00:00:00+00:00","2021-06-01T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_EFFECTIVE_DATE","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["2022-06-24T00:00:00+00:00","2016-12-01T00:00:00+00:00","2018-08-01T00:00:00+00:00","2013-10-29T00:00:00+00:00","2021-06-01T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_TERMINATION_DATE","type":"string","description":null,"nullable":true,"num_null_values":4229,"num_unique_values":null,"example_values":["2022-04-26T00:00:00+00:00","2021-05-01T00:00:00+00:00","2013-01-01T00:00:00+00:00","2018-06-04T00:00:00+00:00","2008-12-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_PERMIT_STATUS_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["EFF","EFF","TRM","EFF","TRM"],"min":null,"max":null,"length":3,"possible_values":["ADC","EFF","EXP","NON","PND","TRM"]},{"name":"CWP_PERMIT_STATUS_DESC","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Effective","Effective","Terminated","Effective","Terminated"],"min":null,"max":null,"length":15,"possible_values":["Admin Continued","Effective","Expired","Not Needed","Pending","Terminated"]},{"name":"CWP_PERMIT_TYPE_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["NPD","GPC","SIN","NPD","NPD"],"min":null,"max":null,"length":3,"possible_values":["GPC","NPD","SIN"]},{"name":"CWP_PERMIT_TYPE_DESC","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["NPDES Individual Permit","General Permit Covered Facility","Individual State Issued Permit (Non-NPDES)","NPDES Individual Permit","NPDES Individual Permit"],"min":null,"max":null,"length":42,"possible_values":["General Permit Covered Facility","Individual State Issued Permit (Non-NPDES)","NPDES Individual Permit"]},{"name":"SIC_CODES","type":"string","description":null,"nullable":true,"num_null_values":70,"num_unique_values":null,"example_values":["4952","1629","4952","4952","1629"],"min":null,"max":null,"length":19,"possible_values":null},{"name":"NAICS_CODES","type":"string","description":null,"nullable":true,"num_null_values":3899,"num_unique_values":null,"example_values":["221320","221320","221320","221320","221320"],"min":null,"max":null,"length":13,"possible_values":["221112","221310","221310 221320","221320","221320 112111","221320 221310","221320 611110","237110","311612","488119","541330","562219","611110","721120","721120 221320","921190","922140 221320","924110"]},{"name":"FAC_DERIVED_FIPS","type":"string","description":null,"nullable":true,"num_null_values":2,"num_unique_values":null,"example_values":["28031","21021","13285","25027","01083"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"FAC_DERIVED_HUC","type":"string","description":null,"nullable":true,"num_null_values":84,"num_unique_values":null,"example_values":["07030001","04040001","02050201","12040104","07080102"],"min":null,"max":null,"length":8,"possible_values":null},{"name":"FAC_US_MEXICO_BORDER_FLG","type":"string","description":null,"nullable":true,"num_null_values":4459,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"CWP_CURRENT_SNC_STATUS","type":"string","description":null,"nullable":true,"num_null_values":4557,"num_unique_values":null,"example_values":["Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit"],"min":null,"max":null,"length":39,"possible_values":["Compliance/Permit Schedule - Reporting","Compliance/Permit Schedule - Violations","Effluent - Monthly Average Limit","Effluent - Non-monthly Average Limit","Failure to Report DMR - Not Received"]},{"name":"CWP_CURRENT_VIOL","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["No","Yes","No","Yes","No"],"min":null,"max":null,"length":3,"possible_values":["No","Yes"]},{"name":"CWP_LAST_INSPECTION","type":"string","description":null,"nullable":true,"num_null_values":368,"num_unique_values":null,"example_values":["2022-02-11T00:00:00+00:00","2010-04-21T00:00:00+00:00","2022-08-31T00:00:00+00:00","2016-09-20T00:00:00+00:00","2022-08-18T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_LAST_INFORMAL_EA","type":"string","description":null,"nullable":true,"num_null_values":2029,"num_unique_values":null,"example_values":["2021-11-10T00:00:00+00:00","2017-06-20T00:00:00+00:00","2020-11-13T00:00:00+00:00","1986-11-05T00:00:00+00:00","2022-10-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_MAJOR_MINOR_TYPE_FLAG","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["M","M","M","N","N"],"min":null,"max":null,"length":1,"possible_values":["M","N"]},{"name":"STATE_WATER_BODY_NAME","type":"string","description":null,"nullable":true,"num_null_values":275,"num_unique_values":null,"example_values":["BOGUE CHITTO CREEK, STRAIGHT FENCE CREEK","POTOMAC RIVER","CLARKS RIVER / EAST FORK, DITCH TO UT TO CLARKS RIVER","KINDERHOOK CK","GREAT MIAMI RIVER, TWO MILE CREEK"],"min":null,"max":null,"length":303,"possible_values":null},{"name":"SOURCE_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["MN0003182","AKG573029","CO0043711","TN0022888","PA0092339"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"FAC_MAP_FLG","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"CWP_13QTRS_COMPL_STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["_____________","__VVSVVSVVVV_","             ","VS__VVVVVVVVV","             "],"min":null,"max":null,"length":13,"possible_values":null},{"name":"FAC_TRI_REPORTER","type":"string","description":null,"nullable":true,"num_null_values":4985,"num_unique_values":null,"example_values":["B","P","P","P","P"],"min":null,"max":null,"length":1,"possible_values":["B","P"]},{"name":"FAC_MAP_ICON","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CWA-IC-MN-4.png","CWA-NC-MN-G.png","CWA-IA-MN-G.png","CWA-NC-MJ-1.png","CWA-IA-MN-G.png"],"min":null,"max":null,"length":16,"possible_values":null},{"name":"CWP_IMP_WATER_FLG","type":"string","description":null,"nullable":true,"num_null_values":2662,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"FAC_FEDERAL_AGENCY_CODE","type":"string","description":null,"nullable":true,"num_null_values":4970,"num_unique_values":null,"example_values":["C6800","C6800","C1500","C6800","C6800"],"min":null,"max":null,"length":5,"possible_values":["C1409","C1500","C6800","C9100","D2100","D5700","D9600"]},{"name":"CWP_DATE_LAST_INST_ST","type":"string","description":null,"nullable":true,"num_null_values":470,"num_unique_values":null,"example_values":["2022-09-06T00:00:00+00:00","2022-08-29T00:00:00+00:00","2010-11-10T00:00:00+00:00","2020-11-17T00:00:00+00:00","2018-07-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_FACILITY_TYPE_DESC","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Non-Federal","Non-Federal","Non-Federal","Non-Federal","Non-Federal"],"min":null,"max":null,"length":11,"possible_values":["Non-Federal"]},{"name":"CWP_CSO_FLAG","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"CWP_MAJOR_MINOR_STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Minor","Minor","Minor","Major","Minor"],"min":null,"max":null,"length":19,"possible_values":["Major","Minor","Other/Nonclassified"]},{"name":"FAC_LAT","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["45.984925","58.703343","40.574417","35.450939999999996","40.588074999999996"],"min":13.5403,"max":71.32385099999999,"length":null,"possible_values":null},{"name":"FAC_LONG","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["-94.359393","-156.735023","-104.733833","-86.78791","-80.17727099999999"],"min":-169.539986,"max":145.75,"length":null,"possible_values":null}]},"url":"https://hifld.publicenvirodata.org/storage/icis-wastewater-treatment-plants/icis-wastewater-treatment-plants/v1.0.0/geojson/icis-wastewater-treatment-plants-geojson.geojson","storage_uri":"gs://hifld-next-datasets-prod/icis-wastewater-treatment-plants/icis-wastewater-treatment-plants/v1.0.0/geojson/icis-wastewater-treatment-plants-geojson.geojson","storage_location":{"name":"GCS hifld-next-datasets-prod","description":"Google Cloud Storage production bucket for dataset files","updated_at":"2026-02-13T02:39:54.364528","slug":"gcs-hifld-next-datasets-prod","id":1,"backend_type":"s3","created_at":"2026-02-13T02:39:54.364506","config":{"version":"v1","type":"gcs","base_url":"https://hifld.publicenvirodata.org/storage","bucket":"hifld-next-datasets-prod"}},"links":{"download_zip":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/icis-wastewater-treatment-plants/files/icis-wastewater-treatment-plants/sources/18683/download-zip"}}]},{"format":{"description":"GeoPackage format for geospatial data storage and exchange","format_type":"geopackage","created_at":"2026-02-15T03:18:57.332771","id":4,"name":"GeoPackage","mime_type":"application/geopackage+sqlite3","updated_at":"2026-02-15T03:18:57.332796"},"file_format":{"id":18142,"format_id":4,"created_at":"2026-05-19T21:59:26.827715","file_id":4357,"updated_at":"2026-05-19T21:59:26.827738"},"sources":[{"storage_location_id":1,"version":"v1.0.0","source_type":"file","references_source_id":null,"updated_at":"2026-08-14T07:01:27.092529","id":18684,"file_format_id":18142,"created_at":"2026-05-19T21:59:27.000379","location":{"type":"file","version":"v1","path":"icis-wastewater-treatment-plants/icis-wastewater-treatment-plants/v1.0.0/geopackage/icis-wastewater-treatment-plants-geopackage.gpkg"},"source_metadata":{"version":"v1","description":null,"size_bytes":13164544,"mime_type":null,"feature_count":18885,"bounds":[-176.646252,-14.340056,174.107672,71.323851],"geometry_type":"Point","invalid_geometry_count":0,"quality_check_passed":true,"columns_hash":"6fa27353ef118653ef28e6a4a789974f130cf96114c7fbb873c24252fc5334e7","columns":[{"name":"geometry","type":"geometry","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":null,"min":null,"max":null,"length":null,"possible_values":null},{"name":"OBJECTID_1","type":"float","description":null,"nullable":true,"num_null_values":1372,"num_unique_values":null,"example_values":["36159270.0","34842614.0","31586792.0","15516450.0","31706119.0"],"min":12431365,"max":39368547,"length":null,"possible_values":null},{"name":"CWP_DATE_LAST_INST_EPA","type":"string","description":null,"nullable":true,"num_null_values":3493,"num_unique_values":null,"example_values":["1980-06-26T00:00:00+00:00","2019-03-08T00:00:00+00:00","1984-09-17T00:00:00+00:00","1995-04-20T00:00:00+00:00","1991-04-16T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CASE_IDS","type":"string","description":null,"nullable":true,"num_null_values":4890,"num_unique_values":null,"example_values":["02-2020-3008","06-2022-1740","01-2018-2013","05-2020-0308","06-2010-1780"],"min":null,"max":null,"length":77,"possible_values":null},{"name":"CWP_DATE_LAST_PENALTY","type":"string","description":null,"nullable":true,"num_null_values":3783,"num_unique_values":null,"example_values":["2022-01-20T00:00:00+00:00","2003-04-02T00:00:00+00:00","2005-11-02T00:00:00+00:00","2002-08-27T00:00:00+00:00","2015-09-08T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_COMPLIANCE_TRACKING","type":"string","description":null,"nullable":true,"num_null_values":10,"num_unique_values":null,"example_values":["On","On","On","On","Off"],"min":null,"max":null,"length":7,"possible_values":["Off","On","Partial"]},{"name":"CWP_SNC_FLAG","type":"string","description":null,"nullable":true,"num_null_values":4557,"num_unique_values":null,"example_values":["Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit"],"min":null,"max":null,"length":39,"possible_values":["Compliance/Permit Schedule - Reporting","Compliance/Permit Schedule - Violations","Effluent - Monthly Average Limit","Effluent - Non-monthly Average Limit","Failure to Report DMR - Not Received"]},{"name":"CWP_DATE_LAST_IKEA_ST","type":"string","description":null,"nullable":true,"num_null_values":2166,"num_unique_values":null,"example_values":["2022-09-26T00:00:00+00:00","2007-02-07T00:00:00+00:00","2005-04-20T00:00:00+00:00","2014-04-16T00:00:00+00:00","2015-11-30T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_DATE_LAST_FEAT_EPA","type":"string","description":null,"nullable":true,"num_null_values":4222,"num_unique_values":null,"example_values":["2009-09-03T00:00:00+00:00","1991-06-25T00:00:00+00:00","1992-07-20T00:00:00+00:00","2021-12-21T00:00:00+00:00","1986-03-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_DATE_LAST_FEAT_ST","type":"string","description":null,"nullable":true,"num_null_values":2938,"num_unique_values":null,"example_values":["2009-09-28T00:00:00+00:00","2007-10-11T00:00:00+00:00","2021-02-04T00:00:00+00:00","1988-08-26T00:00:00+00:00","2020-02-21T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_DATE_LAST_FEAT","type":"string","description":null,"nullable":true,"num_null_values":2644,"num_unique_values":null,"example_values":["1995-12-11T00:00:00+00:00","2015-07-10T00:00:00+00:00","2018-04-18T00:00:00+00:00","2004-01-15T00:00:00+00:00","2019-04-15T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"STATE_WATER_BODY","type":"string","description":null,"nullable":true,"num_null_values":1234,"num_unique_values":null,"example_values":["WB8533","05030101","58","03070103, 030701030950","05050008"],"min":null,"max":null,"length":43,"possible_values":null},{"name":"CWP_SNC_EVENT_DESC","type":"string","description":null,"nullable":true,"num_null_values":4557,"num_unique_values":null,"example_values":["SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average"],"min":null,"max":null,"length":42,"possible_values":["SNC DMR Non-Receipt Violation","SNC Effluent Violation Monthly Average","SNC Effluent Violation Non-Monthly Average","SNC Schedule Event Violation","SNC Schedule Report Violation"]},{"name":"CWP_CURRENT_SNC_STATUS_DATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":["2022-06-30T00:00:00+00:00"]},{"name":"FEDERAL_AGENCY_NAME","type":"string","description":null,"nullable":true,"num_null_values":4970,"num_unique_values":null,"example_values":["C6800","C6800","C1500","C6800","C6800"],"min":null,"max":null,"length":5,"possible_values":["C1409","C1500","C6800","C9100","D2100","D5700","D9600"]},{"name":"FEDERAL_LAND_IND","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"NPDES_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["MN0003182","AKG573029","CO0043711","TN0022888","PA0092339"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"REGISTRY_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["110056979328","110056343657","110011372068","110006367680","110001060459"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"CWP_NAME","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["LITTLE FALLS WTP","KING SALMON LAGOON","AULT, TOWN OF","LEWISBURG STP","BELL ACRES MUNICIPAL SEW AUTH"],"min":null,"max":null,"length":80,"possible_values":null},{"name":"CWP_STREET","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["100 7TH AVE NE","PO BOX 189","UNKNOWN","100 WATER STREET","GROUSE RIDGE STP"],"min":null,"max":null,"length":50,"possible_values":null},{"name":"CWP_CITY","type":"string","description":null,"nullable":true,"num_null_values":30,"num_unique_values":null,"example_values":["GREENSBURG","GRACEVILLE","EAGLE LAKE","MUNDELEIN","COLUSA"],"min":null,"max":null,"length":45,"possible_values":null},{"name":"CWP_STATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["MN","AK","CO","TN","PA"],"min":null,"max":null,"length":2,"possible_values":null},{"name":"CWP_ZIP","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["563452300","99633","80610","37091","15143"],"min":null,"max":null,"length":10,"possible_values":null},{"name":"CWP_COUNTY","type":"string","description":null,"nullable":true,"num_null_values":175,"num_unique_values":null,"example_values":["Ellis","St. Lawrence","Pinellas","Canadian","Kandiyohi"],"min":null,"max":null,"length":22,"possible_values":null},{"name":"CWP_EPA_REGION","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["05","10","08","04","03"],"min":null,"max":null,"length":2,"possible_values":["01","02","03","04","05","06","07","08","09","10"]},{"name":"CWP_INDIAN_CNTRY_FLG","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"CWP_TRIBAL_LAND_CODE","type":"string","description":null,"nullable":true,"num_null_values":4903,"num_unique_values":null,"example_values":["R751","R202","R201","R202","R430"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"CWP_VERSION_NUMBER","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":0,"length":null,"possible_values":null},{"name":"CWP_EXPIRATION_DATE","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["2025-07-31T00:00:00+00:00","2021-11-30T00:00:00+00:00","2023-07-31T00:00:00+00:00","2018-09-30T00:00:00+00:00","2026-05-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_FACILITY_TYPE_INDICATOR","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["POTW","POTW","POTW","POTW","POTW"],"min":null,"max":null,"length":4,"possible_values":["POTW"]},{"name":"MASTER_EXTERNAL_PERMIT_NUMBER","type":"string","description":null,"nullable":true,"num_null_values":4324,"num_unique_values":null,"example_values":["MTG580000","WV0115924","ILG580000","ILG580000","WV0115924"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"ISSUING_AGENCY","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["State","State","State","State","State"],"min":null,"max":null,"length":5,"possible_values":["EPA","State"]},{"name":"CWP_ISSUE_DATE","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["2020-07-15T00:00:00+00:00","2016-11-02T00:00:00+00:00","2018-06-29T00:00:00+00:00","2013-10-29T00:00:00+00:00","2021-06-01T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_EFFECTIVE_DATE","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["2022-06-24T00:00:00+00:00","2016-12-01T00:00:00+00:00","2018-08-01T00:00:00+00:00","2013-10-29T00:00:00+00:00","2021-06-01T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_TERMINATION_DATE","type":"string","description":null,"nullable":true,"num_null_values":4229,"num_unique_values":null,"example_values":["2022-04-26T00:00:00+00:00","2021-05-01T00:00:00+00:00","2013-01-01T00:00:00+00:00","2018-06-04T00:00:00+00:00","2008-12-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_PERMIT_STATUS_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["EFF","EFF","TRM","EFF","TRM"],"min":null,"max":null,"length":3,"possible_values":["ADC","EFF","EXP","NON","PND","TRM"]},{"name":"CWP_PERMIT_STATUS_DESC","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Effective","Effective","Terminated","Effective","Terminated"],"min":null,"max":null,"length":15,"possible_values":["Admin Continued","Effective","Expired","Not Needed","Pending","Terminated"]},{"name":"CWP_PERMIT_TYPE_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["NPD","GPC","SIN","NPD","NPD"],"min":null,"max":null,"length":3,"possible_values":["GPC","NPD","SIN"]},{"name":"CWP_PERMIT_TYPE_DESC","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["NPDES Individual Permit","General Permit Covered Facility","Individual State Issued Permit (Non-NPDES)","NPDES Individual Permit","NPDES Individual Permit"],"min":null,"max":null,"length":42,"possible_values":["General Permit Covered Facility","Individual State Issued Permit (Non-NPDES)","NPDES Individual Permit"]},{"name":"SIC_CODES","type":"string","description":null,"nullable":true,"num_null_values":70,"num_unique_values":null,"example_values":["4952","1629","4952","4952","1629"],"min":null,"max":null,"length":19,"possible_values":null},{"name":"NAICS_CODES","type":"string","description":null,"nullable":true,"num_null_values":3899,"num_unique_values":null,"example_values":["221320","221320","221320","221320","221320"],"min":null,"max":null,"length":13,"possible_values":["221112","221310","221310 221320","221320","221320 112111","221320 221310","221320 611110","237110","311612","488119","541330","562219","611110","721120","721120 221320","921190","922140 221320","924110"]},{"name":"FAC_DERIVED_FIPS","type":"string","description":null,"nullable":true,"num_null_values":2,"num_unique_values":null,"example_values":["28031","21021","13285","25027","01083"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"FAC_DERIVED_HUC","type":"string","description":null,"nullable":true,"num_null_values":84,"num_unique_values":null,"example_values":["07030001","04040001","02050201","12040104","07080102"],"min":null,"max":null,"length":8,"possible_values":null},{"name":"FAC_US_MEXICO_BORDER_FLG","type":"string","description":null,"nullable":true,"num_null_values":4459,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"CWP_CURRENT_SNC_STATUS","type":"string","description":null,"nullable":true,"num_null_values":4557,"num_unique_values":null,"example_values":["Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit"],"min":null,"max":null,"length":39,"possible_values":["Compliance/Permit Schedule - Reporting","Compliance/Permit Schedule - Violations","Effluent - Monthly Average Limit","Effluent - Non-monthly Average Limit","Failure to Report DMR - Not Received"]},{"name":"CWP_CURRENT_VIOL","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["No","Yes","No","Yes","No"],"min":null,"max":null,"length":3,"possible_values":["No","Yes"]},{"name":"CWP_LAST_INSPECTION","type":"string","description":null,"nullable":true,"num_null_values":368,"num_unique_values":null,"example_values":["2022-02-11T00:00:00+00:00","2010-04-21T00:00:00+00:00","2022-08-31T00:00:00+00:00","2016-09-20T00:00:00+00:00","2022-08-18T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_LAST_INFORMAL_EA","type":"string","description":null,"nullable":true,"num_null_values":2029,"num_unique_values":null,"example_values":["2021-11-10T00:00:00+00:00","2017-06-20T00:00:00+00:00","2020-11-13T00:00:00+00:00","1986-11-05T00:00:00+00:00","2022-10-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_MAJOR_MINOR_TYPE_FLAG","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["M","M","M","N","N"],"min":null,"max":null,"length":1,"possible_values":["M","N"]},{"name":"STATE_WATER_BODY_NAME","type":"string","description":null,"nullable":true,"num_null_values":275,"num_unique_values":null,"example_values":["BOGUE CHITTO CREEK, STRAIGHT FENCE CREEK","POTOMAC RIVER","CLARKS RIVER / EAST FORK, DITCH TO UT TO CLARKS RIVER","KINDERHOOK CK","GREAT MIAMI RIVER, TWO MILE CREEK"],"min":null,"max":null,"length":303,"possible_values":null},{"name":"SOURCE_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["MN0003182","AKG573029","CO0043711","TN0022888","PA0092339"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"FAC_MAP_FLG","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"CWP_13QTRS_COMPL_STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["_____________","__VVSVVSVVVV_","             ","VS__VVVVVVVVV","             "],"min":null,"max":null,"length":13,"possible_values":null},{"name":"FAC_TRI_REPORTER","type":"string","description":null,"nullable":true,"num_null_values":4985,"num_unique_values":null,"example_values":["B","P","P","P","P"],"min":null,"max":null,"length":1,"possible_values":["B","P"]},{"name":"FAC_MAP_ICON","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CWA-IC-MN-4.png","CWA-NC-MN-G.png","CWA-IA-MN-G.png","CWA-NC-MJ-1.png","CWA-IA-MN-G.png"],"min":null,"max":null,"length":16,"possible_values":null},{"name":"CWP_IMP_WATER_FLG","type":"string","description":null,"nullable":true,"num_null_values":2662,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"FAC_FEDERAL_AGENCY_CODE","type":"string","description":null,"nullable":true,"num_null_values":4970,"num_unique_values":null,"example_values":["C6800","C6800","C1500","C6800","C6800"],"min":null,"max":null,"length":5,"possible_values":["C1409","C1500","C6800","C9100","D2100","D5700","D9600"]},{"name":"CWP_DATE_LAST_INST_ST","type":"string","description":null,"nullable":true,"num_null_values":470,"num_unique_values":null,"example_values":["2022-09-06T00:00:00+00:00","2022-08-29T00:00:00+00:00","2010-11-10T00:00:00+00:00","2020-11-17T00:00:00+00:00","2018-07-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_FACILITY_TYPE_DESC","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Non-Federal","Non-Federal","Non-Federal","Non-Federal","Non-Federal"],"min":null,"max":null,"length":11,"possible_values":["Non-Federal"]},{"name":"CWP_CSO_FLAG","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"CWP_MAJOR_MINOR_STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Minor","Minor","Minor","Major","Minor"],"min":null,"max":null,"length":19,"possible_values":["Major","Minor","Other/Nonclassified"]},{"name":"FAC_LAT","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["45.984925","58.703343","40.574417","35.450939999999996","40.588074999999996"],"min":13.5403,"max":71.32385099999999,"length":null,"possible_values":null},{"name":"FAC_LONG","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["-94.359393","-156.735023","-104.733833","-86.78791","-80.17727099999999"],"min":-169.539986,"max":145.75,"length":null,"possible_values":null}]},"url":"https://hifld.publicenvirodata.org/storage/icis-wastewater-treatment-plants/icis-wastewater-treatment-plants/v1.0.0/geopackage/icis-wastewater-treatment-plants-geopackage.gpkg","storage_uri":"gs://hifld-next-datasets-prod/icis-wastewater-treatment-plants/icis-wastewater-treatment-plants/v1.0.0/geopackage/icis-wastewater-treatment-plants-geopackage.gpkg","storage_location":{"name":"GCS hifld-next-datasets-prod","description":"Google Cloud Storage production bucket for dataset files","updated_at":"2026-02-13T02:39:54.364528","slug":"gcs-hifld-next-datasets-prod","id":1,"backend_type":"s3","created_at":"2026-02-13T02:39:54.364506","config":{"version":"v1","type":"gcs","base_url":"https://hifld.publicenvirodata.org/storage","bucket":"hifld-next-datasets-prod"}},"links":{"download_zip":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/icis-wastewater-treatment-plants/files/icis-wastewater-treatment-plants/sources/18684/download-zip"}}]},{"format":{"description":"GeoParquet format for efficient spatial data storage and analysis","format_type":"geoparquet","created_at":"2026-02-13T02:36:11.179416","id":1,"name":"GeoParquet","mime_type":"application/parquet","updated_at":"2026-02-13T02:36:11.179441"},"file_format":{"id":18143,"format_id":1,"created_at":"2026-05-19T21:59:27.261185","file_id":4357,"updated_at":"2026-05-19T21:59:27.261208"},"sources":[{"storage_location_id":1,"version":"v1.0.0","source_type":"file","references_source_id":null,"updated_at":"2026-08-14T07:01:27.130925","id":18685,"file_format_id":18143,"created_at":"2026-05-19T21:59:27.432993","location":{"type":"file","version":"v1","path":"icis-wastewater-treatment-plants/icis-wastewater-treatment-plants/v1.0.0/geoparquet/icis-wastewater-treatment-plants.parquet"},"source_metadata":{"version":"v1","description":null,"size_bytes":3022263,"mime_type":null,"feature_count":18885,"bounds":[-176.646252,-14.340056,174.107672,71.323851],"geometry_type":"Point","invalid_geometry_count":0,"quality_check_passed":true,"columns_hash":"6fa27353ef118653ef28e6a4a789974f130cf96114c7fbb873c24252fc5334e7","columns":[{"name":"geometry","type":"geometry","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":null,"min":null,"max":null,"length":null,"possible_values":null},{"name":"OBJECTID_1","type":"float","description":null,"nullable":true,"num_null_values":1372,"num_unique_values":null,"example_values":["36159270.0","34842614.0","31586792.0","15516450.0","31706119.0"],"min":12431365,"max":39368547,"length":null,"possible_values":null},{"name":"CWP_DATE_LAST_INST_EPA","type":"string","description":null,"nullable":true,"num_null_values":3493,"num_unique_values":null,"example_values":["1980-06-26T00:00:00+00:00","2019-03-08T00:00:00+00:00","1984-09-17T00:00:00+00:00","1995-04-20T00:00:00+00:00","1991-04-16T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CASE_IDS","type":"string","description":null,"nullable":true,"num_null_values":4890,"num_unique_values":null,"example_values":["02-2020-3008","06-2022-1740","01-2018-2013","05-2020-0308","06-2010-1780"],"min":null,"max":null,"length":77,"possible_values":null},{"name":"CWP_DATE_LAST_PENALTY","type":"string","description":null,"nullable":true,"num_null_values":3783,"num_unique_values":null,"example_values":["2022-01-20T00:00:00+00:00","2003-04-02T00:00:00+00:00","2005-11-02T00:00:00+00:00","2002-08-27T00:00:00+00:00","2015-09-08T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_COMPLIANCE_TRACKING","type":"string","description":null,"nullable":true,"num_null_values":10,"num_unique_values":null,"example_values":["On","On","On","On","Off"],"min":null,"max":null,"length":7,"possible_values":["Off","On","Partial"]},{"name":"CWP_SNC_FLAG","type":"string","description":null,"nullable":true,"num_null_values":4557,"num_unique_values":null,"example_values":["Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit"],"min":null,"max":null,"length":39,"possible_values":["Compliance/Permit Schedule - Reporting","Compliance/Permit Schedule - Violations","Effluent - Monthly Average Limit","Effluent - Non-monthly Average Limit","Failure to Report DMR - Not Received"]},{"name":"CWP_DATE_LAST_IKEA_ST","type":"string","description":null,"nullable":true,"num_null_values":2166,"num_unique_values":null,"example_values":["2022-09-26T00:00:00+00:00","2007-02-07T00:00:00+00:00","2005-04-20T00:00:00+00:00","2014-04-16T00:00:00+00:00","2015-11-30T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_DATE_LAST_FEAT_EPA","type":"string","description":null,"nullable":true,"num_null_values":4222,"num_unique_values":null,"example_values":["2009-09-03T00:00:00+00:00","1991-06-25T00:00:00+00:00","1992-07-20T00:00:00+00:00","2021-12-21T00:00:00+00:00","1986-03-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_DATE_LAST_FEAT_ST","type":"string","description":null,"nullable":true,"num_null_values":2938,"num_unique_values":null,"example_values":["2009-09-28T00:00:00+00:00","2007-10-11T00:00:00+00:00","2021-02-04T00:00:00+00:00","1988-08-26T00:00:00+00:00","2020-02-21T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_DATE_LAST_FEAT","type":"string","description":null,"nullable":true,"num_null_values":2644,"num_unique_values":null,"example_values":["1995-12-11T00:00:00+00:00","2015-07-10T00:00:00+00:00","2018-04-18T00:00:00+00:00","2004-01-15T00:00:00+00:00","2019-04-15T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"STATE_WATER_BODY","type":"string","description":null,"nullable":true,"num_null_values":1234,"num_unique_values":null,"example_values":["WB8533","05030101","58","03070103, 030701030950","05050008"],"min":null,"max":null,"length":43,"possible_values":null},{"name":"CWP_SNC_EVENT_DESC","type":"string","description":null,"nullable":true,"num_null_values":4557,"num_unique_values":null,"example_values":["SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average"],"min":null,"max":null,"length":42,"possible_values":["SNC DMR Non-Receipt Violation","SNC Effluent Violation Monthly Average","SNC Effluent Violation Non-Monthly Average","SNC Schedule Event Violation","SNC Schedule Report Violation"]},{"name":"CWP_CURRENT_SNC_STATUS_DATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":["2022-06-30T00:00:00+00:00"]},{"name":"FEDERAL_AGENCY_NAME","type":"string","description":null,"nullable":true,"num_null_values":4970,"num_unique_values":null,"example_values":["C6800","C6800","C1500","C6800","C6800"],"min":null,"max":null,"length":5,"possible_values":["C1409","C1500","C6800","C9100","D2100","D5700","D9600"]},{"name":"FEDERAL_LAND_IND","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"NPDES_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["MN0003182","AKG573029","CO0043711","TN0022888","PA0092339"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"REGISTRY_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["110056979328","110056343657","110011372068","110006367680","110001060459"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"CWP_NAME","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["LITTLE FALLS WTP","KING SALMON LAGOON","AULT, TOWN OF","LEWISBURG STP","BELL ACRES MUNICIPAL SEW AUTH"],"min":null,"max":null,"length":80,"possible_values":null},{"name":"CWP_STREET","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["100 7TH AVE NE","PO BOX 189","UNKNOWN","100 WATER STREET","GROUSE RIDGE STP"],"min":null,"max":null,"length":50,"possible_values":null},{"name":"CWP_CITY","type":"string","description":null,"nullable":true,"num_null_values":30,"num_unique_values":null,"example_values":["GREENSBURG","GRACEVILLE","EAGLE LAKE","MUNDELEIN","COLUSA"],"min":null,"max":null,"length":45,"possible_values":null},{"name":"CWP_STATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["MN","AK","CO","TN","PA"],"min":null,"max":null,"length":2,"possible_values":null},{"name":"CWP_ZIP","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["563452300","99633","80610","37091","15143"],"min":null,"max":null,"length":10,"possible_values":null},{"name":"CWP_COUNTY","type":"string","description":null,"nullable":true,"num_null_values":175,"num_unique_values":null,"example_values":["Ellis","St. Lawrence","Pinellas","Canadian","Kandiyohi"],"min":null,"max":null,"length":22,"possible_values":null},{"name":"CWP_EPA_REGION","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["05","10","08","04","03"],"min":null,"max":null,"length":2,"possible_values":["01","02","03","04","05","06","07","08","09","10"]},{"name":"CWP_INDIAN_CNTRY_FLG","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"CWP_TRIBAL_LAND_CODE","type":"string","description":null,"nullable":true,"num_null_values":4903,"num_unique_values":null,"example_values":["R751","R202","R201","R202","R430"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"CWP_VERSION_NUMBER","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":0,"length":null,"possible_values":null},{"name":"CWP_EXPIRATION_DATE","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["2025-07-31T00:00:00+00:00","2021-11-30T00:00:00+00:00","2023-07-31T00:00:00+00:00","2018-09-30T00:00:00+00:00","2026-05-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_FACILITY_TYPE_INDICATOR","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["POTW","POTW","POTW","POTW","POTW"],"min":null,"max":null,"length":4,"possible_values":["POTW"]},{"name":"MASTER_EXTERNAL_PERMIT_NUMBER","type":"string","description":null,"nullable":true,"num_null_values":4324,"num_unique_values":null,"example_values":["MTG580000","WV0115924","ILG580000","ILG580000","WV0115924"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"ISSUING_AGENCY","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["State","State","State","State","State"],"min":null,"max":null,"length":5,"possible_values":["EPA","State"]},{"name":"CWP_ISSUE_DATE","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["2020-07-15T00:00:00+00:00","2016-11-02T00:00:00+00:00","2018-06-29T00:00:00+00:00","2013-10-29T00:00:00+00:00","2021-06-01T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_EFFECTIVE_DATE","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["2022-06-24T00:00:00+00:00","2016-12-01T00:00:00+00:00","2018-08-01T00:00:00+00:00","2013-10-29T00:00:00+00:00","2021-06-01T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_TERMINATION_DATE","type":"string","description":null,"nullable":true,"num_null_values":4229,"num_unique_values":null,"example_values":["2022-04-26T00:00:00+00:00","2021-05-01T00:00:00+00:00","2013-01-01T00:00:00+00:00","2018-06-04T00:00:00+00:00","2008-12-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_PERMIT_STATUS_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["EFF","EFF","TRM","EFF","TRM"],"min":null,"max":null,"length":3,"possible_values":["ADC","EFF","EXP","NON","PND","TRM"]},{"name":"CWP_PERMIT_STATUS_DESC","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Effective","Effective","Terminated","Effective","Terminated"],"min":null,"max":null,"length":15,"possible_values":["Admin Continued","Effective","Expired","Not Needed","Pending","Terminated"]},{"name":"CWP_PERMIT_TYPE_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["NPD","GPC","SIN","NPD","NPD"],"min":null,"max":null,"length":3,"possible_values":["GPC","NPD","SIN"]},{"name":"CWP_PERMIT_TYPE_DESC","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["NPDES Individual Permit","General Permit Covered Facility","Individual State Issued Permit (Non-NPDES)","NPDES Individual Permit","NPDES Individual Permit"],"min":null,"max":null,"length":42,"possible_values":["General Permit Covered Facility","Individual State Issued Permit (Non-NPDES)","NPDES Individual Permit"]},{"name":"SIC_CODES","type":"string","description":null,"nullable":true,"num_null_values":70,"num_unique_values":null,"example_values":["4952","1629","4952","4952","1629"],"min":null,"max":null,"length":19,"possible_values":null},{"name":"NAICS_CODES","type":"string","description":null,"nullable":true,"num_null_values":3899,"num_unique_values":null,"example_values":["221320","221320","221320","221320","221320"],"min":null,"max":null,"length":13,"possible_values":["221112","221310","221310 221320","221320","221320 112111","221320 221310","221320 611110","237110","311612","488119","541330","562219","611110","721120","721120 221320","921190","922140 221320","924110"]},{"name":"FAC_DERIVED_FIPS","type":"string","description":null,"nullable":true,"num_null_values":2,"num_unique_values":null,"example_values":["28031","21021","13285","25027","01083"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"FAC_DERIVED_HUC","type":"string","description":null,"nullable":true,"num_null_values":84,"num_unique_values":null,"example_values":["07030001","04040001","02050201","12040104","07080102"],"min":null,"max":null,"length":8,"possible_values":null},{"name":"FAC_US_MEXICO_BORDER_FLG","type":"string","description":null,"nullable":true,"num_null_values":4459,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"CWP_CURRENT_SNC_STATUS","type":"string","description":null,"nullable":true,"num_null_values":4557,"num_unique_values":null,"example_values":["Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit"],"min":null,"max":null,"length":39,"possible_values":["Compliance/Permit Schedule - Reporting","Compliance/Permit Schedule - Violations","Effluent - Monthly Average Limit","Effluent - Non-monthly Average Limit","Failure to Report DMR - Not Received"]},{"name":"CWP_CURRENT_VIOL","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["No","Yes","No","Yes","No"],"min":null,"max":null,"length":3,"possible_values":["No","Yes"]},{"name":"CWP_LAST_INSPECTION","type":"string","description":null,"nullable":true,"num_null_values":368,"num_unique_values":null,"example_values":["2022-02-11T00:00:00+00:00","2010-04-21T00:00:00+00:00","2022-08-31T00:00:00+00:00","2016-09-20T00:00:00+00:00","2022-08-18T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_LAST_INFORMAL_EA","type":"string","description":null,"nullable":true,"num_null_values":2029,"num_unique_values":null,"example_values":["2021-11-10T00:00:00+00:00","2017-06-20T00:00:00+00:00","2020-11-13T00:00:00+00:00","1986-11-05T00:00:00+00:00","2022-10-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_MAJOR_MINOR_TYPE_FLAG","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["M","M","M","N","N"],"min":null,"max":null,"length":1,"possible_values":["M","N"]},{"name":"STATE_WATER_BODY_NAME","type":"string","description":null,"nullable":true,"num_null_values":275,"num_unique_values":null,"example_values":["BOGUE CHITTO CREEK, STRAIGHT FENCE CREEK","POTOMAC RIVER","CLARKS RIVER / EAST FORK, DITCH TO UT TO CLARKS RIVER","KINDERHOOK CK","GREAT MIAMI RIVER, TWO MILE CREEK"],"min":null,"max":null,"length":303,"possible_values":null},{"name":"SOURCE_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["MN0003182","AKG573029","CO0043711","TN0022888","PA0092339"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"FAC_MAP_FLG","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"CWP_13QTRS_COMPL_STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["_____________","__VVSVVSVVVV_","             ","VS__VVVVVVVVV","             "],"min":null,"max":null,"length":13,"possible_values":null},{"name":"FAC_TRI_REPORTER","type":"string","description":null,"nullable":true,"num_null_values":4985,"num_unique_values":null,"example_values":["B","P","P","P","P"],"min":null,"max":null,"length":1,"possible_values":["B","P"]},{"name":"FAC_MAP_ICON","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CWA-IC-MN-4.png","CWA-NC-MN-G.png","CWA-IA-MN-G.png","CWA-NC-MJ-1.png","CWA-IA-MN-G.png"],"min":null,"max":null,"length":16,"possible_values":null},{"name":"CWP_IMP_WATER_FLG","type":"string","description":null,"nullable":true,"num_null_values":2662,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"FAC_FEDERAL_AGENCY_CODE","type":"string","description":null,"nullable":true,"num_null_values":4970,"num_unique_values":null,"example_values":["C6800","C6800","C1500","C6800","C6800"],"min":null,"max":null,"length":5,"possible_values":["C1409","C1500","C6800","C9100","D2100","D5700","D9600"]},{"name":"CWP_DATE_LAST_INST_ST","type":"string","description":null,"nullable":true,"num_null_values":470,"num_unique_values":null,"example_values":["2022-09-06T00:00:00+00:00","2022-08-29T00:00:00+00:00","2010-11-10T00:00:00+00:00","2020-11-17T00:00:00+00:00","2018-07-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_FACILITY_TYPE_DESC","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Non-Federal","Non-Federal","Non-Federal","Non-Federal","Non-Federal"],"min":null,"max":null,"length":11,"possible_values":["Non-Federal"]},{"name":"CWP_CSO_FLAG","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"CWP_MAJOR_MINOR_STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Minor","Minor","Minor","Major","Minor"],"min":null,"max":null,"length":19,"possible_values":["Major","Minor","Other/Nonclassified"]},{"name":"FAC_LAT","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["45.984925","58.703343","40.574417","35.450939999999996","40.588074999999996"],"min":13.5403,"max":71.32385099999999,"length":null,"possible_values":null},{"name":"FAC_LONG","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["-94.359393","-156.735023","-104.733833","-86.78791","-80.17727099999999"],"min":-169.539986,"max":145.75,"length":null,"possible_values":null}]},"url":"https://hifld.publicenvirodata.org/storage/icis-wastewater-treatment-plants/icis-wastewater-treatment-plants/v1.0.0/geoparquet/icis-wastewater-treatment-plants.parquet","storage_uri":"gs://hifld-next-datasets-prod/icis-wastewater-treatment-plants/icis-wastewater-treatment-plants/v1.0.0/geoparquet/icis-wastewater-treatment-plants.parquet","storage_location":{"name":"GCS hifld-next-datasets-prod","description":"Google Cloud Storage production bucket for dataset files","updated_at":"2026-02-13T02:39:54.364528","slug":"gcs-hifld-next-datasets-prod","id":1,"backend_type":"s3","created_at":"2026-02-13T02:39:54.364506","config":{"version":"v1","type":"gcs","base_url":"https://hifld.publicenvirodata.org/storage","bucket":"hifld-next-datasets-prod"}},"links":{"download_zip":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/icis-wastewater-treatment-plants/files/icis-wastewater-treatment-plants/sources/18685/download-zip"}}]},{"format":{"description":"PMTiles format for tile serving and web mapping","format_type":"pmtiles","created_at":"2026-02-13T02:36:11.357073","id":2,"name":"PMTiles","mime_type":"application/x-protobuf","updated_at":"2026-02-13T02:36:11.357095"},"file_format":{"id":18144,"format_id":2,"created_at":"2026-05-19T21:59:27.693760","file_id":4357,"updated_at":"2026-05-19T21:59:27.693794"},"sources":[{"storage_location_id":1,"version":"v1.0.0","source_type":"file","references_source_id":null,"updated_at":"2026-08-14T07:01:27.169756","id":18686,"file_format_id":18144,"created_at":"2026-05-19T21:59:27.864981","location":{"type":"file","version":"v1","path":"icis-wastewater-treatment-plants/icis-wastewater-treatment-plants/v1.0.0/pmtiles/icis-wastewater-treatment-plants.pmtiles"},"source_metadata":{"version":"v1","description":null,"size_bytes":9730179,"mime_type":null,"feature_count":18885,"bounds":[-176.646252,-14.340056,174.107672,71.323851],"geometry_type":"Point","invalid_geometry_count":0,"quality_check_passed":true,"columns_hash":"6fa27353ef118653ef28e6a4a789974f130cf96114c7fbb873c24252fc5334e7","columns":[{"name":"geometry","type":"geometry","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":null,"min":null,"max":null,"length":null,"possible_values":null},{"name":"OBJECTID_1","type":"float","description":null,"nullable":true,"num_null_values":1372,"num_unique_values":null,"example_values":["36159270.0","34842614.0","31586792.0","15516450.0","31706119.0"],"min":12431365,"max":39368547,"length":null,"possible_values":null},{"name":"CWP_DATE_LAST_INST_EPA","type":"string","description":null,"nullable":true,"num_null_values":3493,"num_unique_values":null,"example_values":["1980-06-26T00:00:00+00:00","2019-03-08T00:00:00+00:00","1984-09-17T00:00:00+00:00","1995-04-20T00:00:00+00:00","1991-04-16T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CASE_IDS","type":"string","description":null,"nullable":true,"num_null_values":4890,"num_unique_values":null,"example_values":["02-2020-3008","06-2022-1740","01-2018-2013","05-2020-0308","06-2010-1780"],"min":null,"max":null,"length":77,"possible_values":null},{"name":"CWP_DATE_LAST_PENALTY","type":"string","description":null,"nullable":true,"num_null_values":3783,"num_unique_values":null,"example_values":["2022-01-20T00:00:00+00:00","2003-04-02T00:00:00+00:00","2005-11-02T00:00:00+00:00","2002-08-27T00:00:00+00:00","2015-09-08T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_COMPLIANCE_TRACKING","type":"string","description":null,"nullable":true,"num_null_values":10,"num_unique_values":null,"example_values":["On","On","On","On","Off"],"min":null,"max":null,"length":7,"possible_values":["Off","On","Partial"]},{"name":"CWP_SNC_FLAG","type":"string","description":null,"nullable":true,"num_null_values":4557,"num_unique_values":null,"example_values":["Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit"],"min":null,"max":null,"length":39,"possible_values":["Compliance/Permit Schedule - Reporting","Compliance/Permit Schedule - Violations","Effluent - Monthly Average Limit","Effluent - Non-monthly Average Limit","Failure to Report DMR - Not Received"]},{"name":"CWP_DATE_LAST_IKEA_ST","type":"string","description":null,"nullable":true,"num_null_values":2166,"num_unique_values":null,"example_values":["2022-09-26T00:00:00+00:00","2007-02-07T00:00:00+00:00","2005-04-20T00:00:00+00:00","2014-04-16T00:00:00+00:00","2015-11-30T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_DATE_LAST_FEAT_EPA","type":"string","description":null,"nullable":true,"num_null_values":4222,"num_unique_values":null,"example_values":["2009-09-03T00:00:00+00:00","1991-06-25T00:00:00+00:00","1992-07-20T00:00:00+00:00","2021-12-21T00:00:00+00:00","1986-03-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_DATE_LAST_FEAT_ST","type":"string","description":null,"nullable":true,"num_null_values":2938,"num_unique_values":null,"example_values":["2009-09-28T00:00:00+00:00","2007-10-11T00:00:00+00:00","2021-02-04T00:00:00+00:00","1988-08-26T00:00:00+00:00","2020-02-21T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_DATE_LAST_FEAT","type":"string","description":null,"nullable":true,"num_null_values":2644,"num_unique_values":null,"example_values":["1995-12-11T00:00:00+00:00","2015-07-10T00:00:00+00:00","2018-04-18T00:00:00+00:00","2004-01-15T00:00:00+00:00","2019-04-15T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"STATE_WATER_BODY","type":"string","description":null,"nullable":true,"num_null_values":1234,"num_unique_values":null,"example_values":["WB8533","05030101","58","03070103, 030701030950","05050008"],"min":null,"max":null,"length":43,"possible_values":null},{"name":"CWP_SNC_EVENT_DESC","type":"string","description":null,"nullable":true,"num_null_values":4557,"num_unique_values":null,"example_values":["SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average"],"min":null,"max":null,"length":42,"possible_values":["SNC DMR Non-Receipt Violation","SNC Effluent Violation Monthly Average","SNC Effluent Violation Non-Monthly Average","SNC Schedule Event Violation","SNC Schedule Report Violation"]},{"name":"CWP_CURRENT_SNC_STATUS_DATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":["2022-06-30T00:00:00+00:00"]},{"name":"FEDERAL_AGENCY_NAME","type":"string","description":null,"nullable":true,"num_null_values":4970,"num_unique_values":null,"example_values":["C6800","C6800","C1500","C6800","C6800"],"min":null,"max":null,"length":5,"possible_values":["C1409","C1500","C6800","C9100","D2100","D5700","D9600"]},{"name":"FEDERAL_LAND_IND","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"NPDES_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["MN0003182","AKG573029","CO0043711","TN0022888","PA0092339"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"REGISTRY_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["110056979328","110056343657","110011372068","110006367680","110001060459"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"CWP_NAME","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["LITTLE FALLS WTP","KING SALMON LAGOON","AULT, TOWN OF","LEWISBURG STP","BELL ACRES MUNICIPAL SEW AUTH"],"min":null,"max":null,"length":80,"possible_values":null},{"name":"CWP_STREET","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["100 7TH AVE NE","PO BOX 189","UNKNOWN","100 WATER STREET","GROUSE RIDGE STP"],"min":null,"max":null,"length":50,"possible_values":null},{"name":"CWP_CITY","type":"string","description":null,"nullable":true,"num_null_values":30,"num_unique_values":null,"example_values":["GREENSBURG","GRACEVILLE","EAGLE LAKE","MUNDELEIN","COLUSA"],"min":null,"max":null,"length":45,"possible_values":null},{"name":"CWP_STATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["MN","AK","CO","TN","PA"],"min":null,"max":null,"length":2,"possible_values":null},{"name":"CWP_ZIP","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["563452300","99633","80610","37091","15143"],"min":null,"max":null,"length":10,"possible_values":null},{"name":"CWP_COUNTY","type":"string","description":null,"nullable":true,"num_null_values":175,"num_unique_values":null,"example_values":["Ellis","St. Lawrence","Pinellas","Canadian","Kandiyohi"],"min":null,"max":null,"length":22,"possible_values":null},{"name":"CWP_EPA_REGION","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["05","10","08","04","03"],"min":null,"max":null,"length":2,"possible_values":["01","02","03","04","05","06","07","08","09","10"]},{"name":"CWP_INDIAN_CNTRY_FLG","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"CWP_TRIBAL_LAND_CODE","type":"string","description":null,"nullable":true,"num_null_values":4903,"num_unique_values":null,"example_values":["R751","R202","R201","R202","R430"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"CWP_VERSION_NUMBER","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":0,"length":null,"possible_values":null},{"name":"CWP_EXPIRATION_DATE","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["2025-07-31T00:00:00+00:00","2021-11-30T00:00:00+00:00","2023-07-31T00:00:00+00:00","2018-09-30T00:00:00+00:00","2026-05-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_FACILITY_TYPE_INDICATOR","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["POTW","POTW","POTW","POTW","POTW"],"min":null,"max":null,"length":4,"possible_values":["POTW"]},{"name":"MASTER_EXTERNAL_PERMIT_NUMBER","type":"string","description":null,"nullable":true,"num_null_values":4324,"num_unique_values":null,"example_values":["MTG580000","WV0115924","ILG580000","ILG580000","WV0115924"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"ISSUING_AGENCY","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["State","State","State","State","State"],"min":null,"max":null,"length":5,"possible_values":["EPA","State"]},{"name":"CWP_ISSUE_DATE","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["2020-07-15T00:00:00+00:00","2016-11-02T00:00:00+00:00","2018-06-29T00:00:00+00:00","2013-10-29T00:00:00+00:00","2021-06-01T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_EFFECTIVE_DATE","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["2022-06-24T00:00:00+00:00","2016-12-01T00:00:00+00:00","2018-08-01T00:00:00+00:00","2013-10-29T00:00:00+00:00","2021-06-01T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_TERMINATION_DATE","type":"string","description":null,"nullable":true,"num_null_values":4229,"num_unique_values":null,"example_values":["2022-04-26T00:00:00+00:00","2021-05-01T00:00:00+00:00","2013-01-01T00:00:00+00:00","2018-06-04T00:00:00+00:00","2008-12-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_PERMIT_STATUS_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["EFF","EFF","TRM","EFF","TRM"],"min":null,"max":null,"length":3,"possible_values":["ADC","EFF","EXP","NON","PND","TRM"]},{"name":"CWP_PERMIT_STATUS_DESC","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Effective","Effective","Terminated","Effective","Terminated"],"min":null,"max":null,"length":15,"possible_values":["Admin Continued","Effective","Expired","Not Needed","Pending","Terminated"]},{"name":"CWP_PERMIT_TYPE_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["NPD","GPC","SIN","NPD","NPD"],"min":null,"max":null,"length":3,"possible_values":["GPC","NPD","SIN"]},{"name":"CWP_PERMIT_TYPE_DESC","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["NPDES Individual Permit","General Permit Covered Facility","Individual State Issued Permit (Non-NPDES)","NPDES Individual Permit","NPDES Individual Permit"],"min":null,"max":null,"length":42,"possible_values":["General Permit Covered Facility","Individual State Issued Permit (Non-NPDES)","NPDES Individual Permit"]},{"name":"SIC_CODES","type":"string","description":null,"nullable":true,"num_null_values":70,"num_unique_values":null,"example_values":["4952","1629","4952","4952","1629"],"min":null,"max":null,"length":19,"possible_values":null},{"name":"NAICS_CODES","type":"string","description":null,"nullable":true,"num_null_values":3899,"num_unique_values":null,"example_values":["221320","221320","221320","221320","221320"],"min":null,"max":null,"length":13,"possible_values":["221112","221310","221310 221320","221320","221320 112111","221320 221310","221320 611110","237110","311612","488119","541330","562219","611110","721120","721120 221320","921190","922140 221320","924110"]},{"name":"FAC_DERIVED_FIPS","type":"string","description":null,"nullable":true,"num_null_values":2,"num_unique_values":null,"example_values":["28031","21021","13285","25027","01083"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"FAC_DERIVED_HUC","type":"string","description":null,"nullable":true,"num_null_values":84,"num_unique_values":null,"example_values":["07030001","04040001","02050201","12040104","07080102"],"min":null,"max":null,"length":8,"possible_values":null},{"name":"FAC_US_MEXICO_BORDER_FLG","type":"string","description":null,"nullable":true,"num_null_values":4459,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"CWP_CURRENT_SNC_STATUS","type":"string","description":null,"nullable":true,"num_null_values":4557,"num_unique_values":null,"example_values":["Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit"],"min":null,"max":null,"length":39,"possible_values":["Compliance/Permit Schedule - Reporting","Compliance/Permit Schedule - Violations","Effluent - Monthly Average Limit","Effluent - Non-monthly Average Limit","Failure to Report DMR - Not Received"]},{"name":"CWP_CURRENT_VIOL","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["No","Yes","No","Yes","No"],"min":null,"max":null,"length":3,"possible_values":["No","Yes"]},{"name":"CWP_LAST_INSPECTION","type":"string","description":null,"nullable":true,"num_null_values":368,"num_unique_values":null,"example_values":["2022-02-11T00:00:00+00:00","2010-04-21T00:00:00+00:00","2022-08-31T00:00:00+00:00","2016-09-20T00:00:00+00:00","2022-08-18T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_LAST_INFORMAL_EA","type":"string","description":null,"nullable":true,"num_null_values":2029,"num_unique_values":null,"example_values":["2021-11-10T00:00:00+00:00","2017-06-20T00:00:00+00:00","2020-11-13T00:00:00+00:00","1986-11-05T00:00:00+00:00","2022-10-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_MAJOR_MINOR_TYPE_FLAG","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["M","M","M","N","N"],"min":null,"max":null,"length":1,"possible_values":["M","N"]},{"name":"STATE_WATER_BODY_NAME","type":"string","description":null,"nullable":true,"num_null_values":275,"num_unique_values":null,"example_values":["BOGUE CHITTO CREEK, STRAIGHT FENCE CREEK","POTOMAC RIVER","CLARKS RIVER / EAST FORK, DITCH TO UT TO CLARKS RIVER","KINDERHOOK CK","GREAT MIAMI RIVER, TWO MILE CREEK"],"min":null,"max":null,"length":303,"possible_values":null},{"name":"SOURCE_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["MN0003182","AKG573029","CO0043711","TN0022888","PA0092339"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"FAC_MAP_FLG","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"CWP_13QTRS_COMPL_STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["_____________","__VVSVVSVVVV_","             ","VS__VVVVVVVVV","             "],"min":null,"max":null,"length":13,"possible_values":null},{"name":"FAC_TRI_REPORTER","type":"string","description":null,"nullable":true,"num_null_values":4985,"num_unique_values":null,"example_values":["B","P","P","P","P"],"min":null,"max":null,"length":1,"possible_values":["B","P"]},{"name":"FAC_MAP_ICON","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CWA-IC-MN-4.png","CWA-NC-MN-G.png","CWA-IA-MN-G.png","CWA-NC-MJ-1.png","CWA-IA-MN-G.png"],"min":null,"max":null,"length":16,"possible_values":null},{"name":"CWP_IMP_WATER_FLG","type":"string","description":null,"nullable":true,"num_null_values":2662,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"FAC_FEDERAL_AGENCY_CODE","type":"string","description":null,"nullable":true,"num_null_values":4970,"num_unique_values":null,"example_values":["C6800","C6800","C1500","C6800","C6800"],"min":null,"max":null,"length":5,"possible_values":["C1409","C1500","C6800","C9100","D2100","D5700","D9600"]},{"name":"CWP_DATE_LAST_INST_ST","type":"string","description":null,"nullable":true,"num_null_values":470,"num_unique_values":null,"example_values":["2022-09-06T00:00:00+00:00","2022-08-29T00:00:00+00:00","2010-11-10T00:00:00+00:00","2020-11-17T00:00:00+00:00","2018-07-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_FACILITY_TYPE_DESC","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Non-Federal","Non-Federal","Non-Federal","Non-Federal","Non-Federal"],"min":null,"max":null,"length":11,"possible_values":["Non-Federal"]},{"name":"CWP_CSO_FLAG","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"CWP_MAJOR_MINOR_STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Minor","Minor","Minor","Major","Minor"],"min":null,"max":null,"length":19,"possible_values":["Major","Minor","Other/Nonclassified"]},{"name":"FAC_LAT","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["45.984925","58.703343","40.574417","35.450939999999996","40.588074999999996"],"min":13.5403,"max":71.32385099999999,"length":null,"possible_values":null},{"name":"FAC_LONG","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["-94.359393","-156.735023","-104.733833","-86.78791","-80.17727099999999"],"min":-169.539986,"max":145.75,"length":null,"possible_values":null}]},"url":"https://hifld.publicenvirodata.org/storage/icis-wastewater-treatment-plants/icis-wastewater-treatment-plants/v1.0.0/pmtiles/icis-wastewater-treatment-plants.pmtiles","storage_uri":"gs://hifld-next-datasets-prod/icis-wastewater-treatment-plants/icis-wastewater-treatment-plants/v1.0.0/pmtiles/icis-wastewater-treatment-plants.pmtiles","storage_location":{"name":"GCS hifld-next-datasets-prod","description":"Google Cloud Storage production bucket for dataset files","updated_at":"2026-02-13T02:39:54.364528","slug":"gcs-hifld-next-datasets-prod","id":1,"backend_type":"s3","created_at":"2026-02-13T02:39:54.364506","config":{"version":"v1","type":"gcs","base_url":"https://hifld.publicenvirodata.org/storage","bucket":"hifld-next-datasets-prod"}},"links":{"download_zip":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/icis-wastewater-treatment-plants/files/icis-wastewater-treatment-plants/sources/18686/download-zip"}}]},{"format":{"description":"ESRI Shapefile format for geospatial vector data","format_type":"shapefile","created_at":"2026-02-15T03:18:57.546771","id":5,"name":"Shapefile","mime_type":"application/zip","updated_at":"2026-02-15T03:18:57.546794"},"file_format":{"id":18145,"format_id":5,"created_at":"2026-05-19T21:59:28.126671","file_id":4357,"updated_at":"2026-05-19T21:59:28.126696"},"sources":[{"storage_location_id":1,"version":"v1.0.0","source_type":"file","references_source_id":null,"updated_at":"2026-08-14T07:01:27.207365","id":18687,"file_format_id":18145,"created_at":"2026-05-19T21:59:28.303410","location":{"type":"file","version":"v1","path":"icis-wastewater-treatment-plants/icis-wastewater-treatment-plants/v1.0.0/shapefile/icis-wastewater-treatment-plants.zip"},"source_metadata":{"version":"v1","description":null,"size_bytes":4707686,"mime_type":null,"feature_count":18885,"bounds":[-176.646252,-14.340056,174.107672,71.323851],"geometry_type":"Point","invalid_geometry_count":0,"quality_check_passed":true,"columns_hash":"6fa27353ef118653ef28e6a4a789974f130cf96114c7fbb873c24252fc5334e7","columns":[{"name":"geometry","type":"geometry","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":null,"min":null,"max":null,"length":null,"possible_values":null},{"name":"OBJECTID_1","type":"float","description":null,"nullable":true,"num_null_values":1372,"num_unique_values":null,"example_values":["36159270.0","34842614.0","31586792.0","15516450.0","31706119.0"],"min":12431365,"max":39368547,"length":null,"possible_values":null},{"name":"CWP_DATE_LAST_INST_EPA","type":"string","description":null,"nullable":true,"num_null_values":3493,"num_unique_values":null,"example_values":["1980-06-26T00:00:00+00:00","2019-03-08T00:00:00+00:00","1984-09-17T00:00:00+00:00","1995-04-20T00:00:00+00:00","1991-04-16T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CASE_IDS","type":"string","description":null,"nullable":true,"num_null_values":4890,"num_unique_values":null,"example_values":["02-2020-3008","06-2022-1740","01-2018-2013","05-2020-0308","06-2010-1780"],"min":null,"max":null,"length":77,"possible_values":null},{"name":"CWP_DATE_LAST_PENALTY","type":"string","description":null,"nullable":true,"num_null_values":3783,"num_unique_values":null,"example_values":["2022-01-20T00:00:00+00:00","2003-04-02T00:00:00+00:00","2005-11-02T00:00:00+00:00","2002-08-27T00:00:00+00:00","2015-09-08T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_COMPLIANCE_TRACKING","type":"string","description":null,"nullable":true,"num_null_values":10,"num_unique_values":null,"example_values":["On","On","On","On","Off"],"min":null,"max":null,"length":7,"possible_values":["Off","On","Partial"]},{"name":"CWP_SNC_FLAG","type":"string","description":null,"nullable":true,"num_null_values":4557,"num_unique_values":null,"example_values":["Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit"],"min":null,"max":null,"length":39,"possible_values":["Compliance/Permit Schedule - Reporting","Compliance/Permit Schedule - Violations","Effluent - Monthly Average Limit","Effluent - Non-monthly Average Limit","Failure to Report DMR - Not Received"]},{"name":"CWP_DATE_LAST_IKEA_ST","type":"string","description":null,"nullable":true,"num_null_values":2166,"num_unique_values":null,"example_values":["2022-09-26T00:00:00+00:00","2007-02-07T00:00:00+00:00","2005-04-20T00:00:00+00:00","2014-04-16T00:00:00+00:00","2015-11-30T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_DATE_LAST_FEAT_EPA","type":"string","description":null,"nullable":true,"num_null_values":4222,"num_unique_values":null,"example_values":["2009-09-03T00:00:00+00:00","1991-06-25T00:00:00+00:00","1992-07-20T00:00:00+00:00","2021-12-21T00:00:00+00:00","1986-03-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_DATE_LAST_FEAT_ST","type":"string","description":null,"nullable":true,"num_null_values":2938,"num_unique_values":null,"example_values":["2009-09-28T00:00:00+00:00","2007-10-11T00:00:00+00:00","2021-02-04T00:00:00+00:00","1988-08-26T00:00:00+00:00","2020-02-21T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_DATE_LAST_FEAT","type":"string","description":null,"nullable":true,"num_null_values":2644,"num_unique_values":null,"example_values":["1995-12-11T00:00:00+00:00","2015-07-10T00:00:00+00:00","2018-04-18T00:00:00+00:00","2004-01-15T00:00:00+00:00","2019-04-15T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"STATE_WATER_BODY","type":"string","description":null,"nullable":true,"num_null_values":1234,"num_unique_values":null,"example_values":["WB8533","05030101","58","03070103, 030701030950","05050008"],"min":null,"max":null,"length":43,"possible_values":null},{"name":"CWP_SNC_EVENT_DESC","type":"string","description":null,"nullable":true,"num_null_values":4557,"num_unique_values":null,"example_values":["SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average","SNC Effluent Violation Monthly Average"],"min":null,"max":null,"length":42,"possible_values":["SNC DMR Non-Receipt Violation","SNC Effluent Violation Monthly Average","SNC Effluent Violation Non-Monthly Average","SNC Schedule Event Violation","SNC Schedule Report Violation"]},{"name":"CWP_CURRENT_SNC_STATUS_DATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00","2022-06-30T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":["2022-06-30T00:00:00+00:00"]},{"name":"FEDERAL_AGENCY_NAME","type":"string","description":null,"nullable":true,"num_null_values":4970,"num_unique_values":null,"example_values":["C6800","C6800","C1500","C6800","C6800"],"min":null,"max":null,"length":5,"possible_values":["C1409","C1500","C6800","C9100","D2100","D5700","D9600"]},{"name":"FEDERAL_LAND_IND","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"NPDES_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["MN0003182","AKG573029","CO0043711","TN0022888","PA0092339"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"REGISTRY_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["110056979328","110056343657","110011372068","110006367680","110001060459"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"CWP_NAME","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["LITTLE FALLS WTP","KING SALMON LAGOON","AULT, TOWN OF","LEWISBURG STP","BELL ACRES MUNICIPAL SEW AUTH"],"min":null,"max":null,"length":80,"possible_values":null},{"name":"CWP_STREET","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["100 7TH AVE NE","PO BOX 189","UNKNOWN","100 WATER STREET","GROUSE RIDGE STP"],"min":null,"max":null,"length":50,"possible_values":null},{"name":"CWP_CITY","type":"string","description":null,"nullable":true,"num_null_values":30,"num_unique_values":null,"example_values":["GREENSBURG","GRACEVILLE","EAGLE LAKE","MUNDELEIN","COLUSA"],"min":null,"max":null,"length":45,"possible_values":null},{"name":"CWP_STATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["MN","AK","CO","TN","PA"],"min":null,"max":null,"length":2,"possible_values":null},{"name":"CWP_ZIP","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["563452300","99633","80610","37091","15143"],"min":null,"max":null,"length":10,"possible_values":null},{"name":"CWP_COUNTY","type":"string","description":null,"nullable":true,"num_null_values":175,"num_unique_values":null,"example_values":["Ellis","St. Lawrence","Pinellas","Canadian","Kandiyohi"],"min":null,"max":null,"length":22,"possible_values":null},{"name":"CWP_EPA_REGION","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["05","10","08","04","03"],"min":null,"max":null,"length":2,"possible_values":["01","02","03","04","05","06","07","08","09","10"]},{"name":"CWP_INDIAN_CNTRY_FLG","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"CWP_TRIBAL_LAND_CODE","type":"string","description":null,"nullable":true,"num_null_values":4903,"num_unique_values":null,"example_values":["R751","R202","R201","R202","R430"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"CWP_VERSION_NUMBER","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":0,"length":null,"possible_values":null},{"name":"CWP_EXPIRATION_DATE","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["2025-07-31T00:00:00+00:00","2021-11-30T00:00:00+00:00","2023-07-31T00:00:00+00:00","2018-09-30T00:00:00+00:00","2026-05-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_FACILITY_TYPE_INDICATOR","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["POTW","POTW","POTW","POTW","POTW"],"min":null,"max":null,"length":4,"possible_values":["POTW"]},{"name":"MASTER_EXTERNAL_PERMIT_NUMBER","type":"string","description":null,"nullable":true,"num_null_values":4324,"num_unique_values":null,"example_values":["MTG580000","WV0115924","ILG580000","ILG580000","WV0115924"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"ISSUING_AGENCY","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["State","State","State","State","State"],"min":null,"max":null,"length":5,"possible_values":["EPA","State"]},{"name":"CWP_ISSUE_DATE","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["2020-07-15T00:00:00+00:00","2016-11-02T00:00:00+00:00","2018-06-29T00:00:00+00:00","2013-10-29T00:00:00+00:00","2021-06-01T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_EFFECTIVE_DATE","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["2022-06-24T00:00:00+00:00","2016-12-01T00:00:00+00:00","2018-08-01T00:00:00+00:00","2013-10-29T00:00:00+00:00","2021-06-01T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_TERMINATION_DATE","type":"string","description":null,"nullable":true,"num_null_values":4229,"num_unique_values":null,"example_values":["2022-04-26T00:00:00+00:00","2021-05-01T00:00:00+00:00","2013-01-01T00:00:00+00:00","2018-06-04T00:00:00+00:00","2008-12-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_PERMIT_STATUS_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["EFF","EFF","TRM","EFF","TRM"],"min":null,"max":null,"length":3,"possible_values":["ADC","EFF","EXP","NON","PND","TRM"]},{"name":"CWP_PERMIT_STATUS_DESC","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Effective","Effective","Terminated","Effective","Terminated"],"min":null,"max":null,"length":15,"possible_values":["Admin Continued","Effective","Expired","Not Needed","Pending","Terminated"]},{"name":"CWP_PERMIT_TYPE_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["NPD","GPC","SIN","NPD","NPD"],"min":null,"max":null,"length":3,"possible_values":["GPC","NPD","SIN"]},{"name":"CWP_PERMIT_TYPE_DESC","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["NPDES Individual Permit","General Permit Covered Facility","Individual State Issued Permit (Non-NPDES)","NPDES Individual Permit","NPDES Individual Permit"],"min":null,"max":null,"length":42,"possible_values":["General Permit Covered Facility","Individual State Issued Permit (Non-NPDES)","NPDES Individual Permit"]},{"name":"SIC_CODES","type":"string","description":null,"nullable":true,"num_null_values":70,"num_unique_values":null,"example_values":["4952","1629","4952","4952","1629"],"min":null,"max":null,"length":19,"possible_values":null},{"name":"NAICS_CODES","type":"string","description":null,"nullable":true,"num_null_values":3899,"num_unique_values":null,"example_values":["221320","221320","221320","221320","221320"],"min":null,"max":null,"length":13,"possible_values":["221112","221310","221310 221320","221320","221320 112111","221320 221310","221320 611110","237110","311612","488119","541330","562219","611110","721120","721120 221320","921190","922140 221320","924110"]},{"name":"FAC_DERIVED_FIPS","type":"string","description":null,"nullable":true,"num_null_values":2,"num_unique_values":null,"example_values":["28031","21021","13285","25027","01083"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"FAC_DERIVED_HUC","type":"string","description":null,"nullable":true,"num_null_values":84,"num_unique_values":null,"example_values":["07030001","04040001","02050201","12040104","07080102"],"min":null,"max":null,"length":8,"possible_values":null},{"name":"FAC_US_MEXICO_BORDER_FLG","type":"string","description":null,"nullable":true,"num_null_values":4459,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"CWP_CURRENT_SNC_STATUS","type":"string","description":null,"nullable":true,"num_null_values":4557,"num_unique_values":null,"example_values":["Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit","Effluent - Monthly Average Limit"],"min":null,"max":null,"length":39,"possible_values":["Compliance/Permit Schedule - Reporting","Compliance/Permit Schedule - Violations","Effluent - Monthly Average Limit","Effluent - Non-monthly Average Limit","Failure to Report DMR - Not Received"]},{"name":"CWP_CURRENT_VIOL","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["No","Yes","No","Yes","No"],"min":null,"max":null,"length":3,"possible_values":["No","Yes"]},{"name":"CWP_LAST_INSPECTION","type":"string","description":null,"nullable":true,"num_null_values":368,"num_unique_values":null,"example_values":["2022-02-11T00:00:00+00:00","2010-04-21T00:00:00+00:00","2022-08-31T00:00:00+00:00","2016-09-20T00:00:00+00:00","2022-08-18T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_LAST_INFORMAL_EA","type":"string","description":null,"nullable":true,"num_null_values":2029,"num_unique_values":null,"example_values":["2021-11-10T00:00:00+00:00","2017-06-20T00:00:00+00:00","2020-11-13T00:00:00+00:00","1986-11-05T00:00:00+00:00","2022-10-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_MAJOR_MINOR_TYPE_FLAG","type":"string","description":null,"nullable":true,"num_null_values":9,"num_unique_values":null,"example_values":["M","M","M","N","N"],"min":null,"max":null,"length":1,"possible_values":["M","N"]},{"name":"STATE_WATER_BODY_NAME","type":"string","description":null,"nullable":true,"num_null_values":275,"num_unique_values":null,"example_values":["BOGUE CHITTO CREEK, STRAIGHT FENCE CREEK","POTOMAC RIVER","CLARKS RIVER / EAST FORK, DITCH TO UT TO CLARKS RIVER","KINDERHOOK CK","GREAT MIAMI RIVER, TWO MILE CREEK"],"min":null,"max":null,"length":303,"possible_values":null},{"name":"SOURCE_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["MN0003182","AKG573029","CO0043711","TN0022888","PA0092339"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"FAC_MAP_FLG","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"CWP_13QTRS_COMPL_STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["_____________","__VVSVVSVVVV_","             ","VS__VVVVVVVVV","             "],"min":null,"max":null,"length":13,"possible_values":null},{"name":"FAC_TRI_REPORTER","type":"string","description":null,"nullable":true,"num_null_values":4985,"num_unique_values":null,"example_values":["B","P","P","P","P"],"min":null,"max":null,"length":1,"possible_values":["B","P"]},{"name":"FAC_MAP_ICON","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CWA-IC-MN-4.png","CWA-NC-MN-G.png","CWA-IA-MN-G.png","CWA-NC-MJ-1.png","CWA-IA-MN-G.png"],"min":null,"max":null,"length":16,"possible_values":null},{"name":"CWP_IMP_WATER_FLG","type":"string","description":null,"nullable":true,"num_null_values":2662,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"FAC_FEDERAL_AGENCY_CODE","type":"string","description":null,"nullable":true,"num_null_values":4970,"num_unique_values":null,"example_values":["C6800","C6800","C1500","C6800","C6800"],"min":null,"max":null,"length":5,"possible_values":["C1409","C1500","C6800","C9100","D2100","D5700","D9600"]},{"name":"CWP_DATE_LAST_INST_ST","type":"string","description":null,"nullable":true,"num_null_values":470,"num_unique_values":null,"example_values":["2022-09-06T00:00:00+00:00","2022-08-29T00:00:00+00:00","2010-11-10T00:00:00+00:00","2020-11-17T00:00:00+00:00","2018-07-31T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"CWP_FACILITY_TYPE_DESC","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Non-Federal","Non-Federal","Non-Federal","Non-Federal","Non-Federal"],"min":null,"max":null,"length":11,"possible_values":["Non-Federal"]},{"name":"CWP_CSO_FLAG","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"CWP_MAJOR_MINOR_STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Minor","Minor","Minor","Major","Minor"],"min":null,"max":null,"length":19,"possible_values":["Major","Minor","Other/Nonclassified"]},{"name":"FAC_LAT","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["45.984925","58.703343","40.574417","35.450939999999996","40.588074999999996"],"min":13.5403,"max":71.32385099999999,"length":null,"possible_values":null},{"name":"FAC_LONG","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["-94.359393","-156.735023","-104.733833","-86.78791","-80.17727099999999"],"min":-169.539986,"max":145.75,"length":null,"possible_values":null}]},"url":"https://hifld.publicenvirodata.org/storage/icis-wastewater-treatment-plants/icis-wastewater-treatment-plants/v1.0.0/shapefile/icis-wastewater-treatment-plants.zip","storage_uri":"gs://hifld-next-datasets-prod/icis-wastewater-treatment-plants/icis-wastewater-treatment-plants/v1.0.0/shapefile/icis-wastewater-treatment-plants.zip","storage_location":{"name":"GCS hifld-next-datasets-prod","description":"Google Cloud Storage production bucket for dataset files","updated_at":"2026-02-13T02:39:54.364528","slug":"gcs-hifld-next-datasets-prod","id":1,"backend_type":"s3","created_at":"2026-02-13T02:39:54.364506","config":{"version":"v1","type":"gcs","base_url":"https://hifld.publicenvirodata.org/storage","bucket":"hifld-next-datasets-prod"}},"links":{"download_zip":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/icis-wastewater-treatment-plants/files/icis-wastewater-treatment-plants/sources/18687/download-zip"}}]}]}}