{ "isCoGoEnabled": false, "extent": { "ymin": 1509804.9657999985, "xmin": -1.88794879702E7, "ymax": 1.1496866317500003E7, "xmax": 1.6230686773100004E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 33, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Brownfields", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "pgm_sys_id": null, "public_ind": null, "ref_point_desc": null, "fips_code": null, "collect_mth_desc": null, "pgm_report_url": null, "fed_facility_code": null, "naics_industry_name": null, "pgm_sys_id_url": null, "city_name": null, "last_reported_date": null, "federal_agency_name": null, "accuracy_value": null, "latitude83": null, "owner_operator": null, "fac_url": null, "create_date": null, "pgm_sys_acrnm": null, "huc_12": null, "size_in_acres": null, "location_address": null, "oid_": null, "interest_type": null, "proposed_industry": null, "property_highlights": null, "federal_land_ind": null, "county_name": null, "naics_industry_code": null, "update_date": null, "former_use": null, "naics_all": null, "huc8_code": null, "active_status": null, "key_field": null, "program_url": null, "primary_name": null, "state_code": null, "postal_code": null, "epa_region_code": null, "longitude83": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Brownfields", "allowTrueCurvesUpdates": false, "displayField": "primary_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "pgm_sys_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pgm_sys_id", "alias": "PGM_SYS_ID", "type": "esriFieldTypeInteger" }, { "modelName": "oid_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "oid_", "alias": "OID_", "type": "esriFieldTypeInteger" }, { "modelName": "primary_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "primary_name", "length": 2147483647, "alias": "PRIMARY_NAME", "type": "esriFieldTypeString" }, { "modelName": "location_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location_address", "length": 2147483647, "alias": "LOCATION_ADDRESS", "type": "esriFieldTypeString" }, { "modelName": "city_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city_name", "length": 2147483647, "alias": "CITY_NAME", "type": "esriFieldTypeString" }, { "modelName": "county_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "county_name", "length": 2147483647, "alias": "COUNTY_NAME", "type": "esriFieldTypeString" }, { "modelName": "fips_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fips_code", "length": 2147483647, "alias": "FIPS_CODE", "type": "esriFieldTypeString" }, { "modelName": "state_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state_code", "length": 2147483647, "alias": "STATE_CODE", "type": "esriFieldTypeString" }, { "modelName": "postal_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "postal_code", "length": 2147483647, "alias": "POSTAL_CODE", "type": "esriFieldTypeString" }, { "modelName": "latitude83", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "latitude83", "alias": "LATITUDE83", "type": "esriFieldTypeDouble" }, { "modelName": "longitude83", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "longitude83", "alias": "LONGITUDE83", "type": "esriFieldTypeDouble" }, { "modelName": "huc8_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "huc8_code", "alias": "HUC8_CODE", "type": "esriFieldTypeDouble" }, { "modelName": "accuracy_value", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "accuracy_value", "alias": "ACCURACY_VALUE", "type": "esriFieldTypeDouble" }, { "modelName": "collect_mth_desc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "collect_mth_desc", "length": 2147483647, "alias": "COLLECT_MTH_DESC", "type": "esriFieldTypeString" }, { "modelName": "ref_point_desc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ref_point_desc", "length": 2147483647, "alias": "REF_POINT_DESC", "type": "esriFieldTypeString" }, { "modelName": "create_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "create_date", "length": 2147483647, "alias": "CREATE_DATE", "type": "esriFieldTypeString" }, { "modelName": "update_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "update_date", "alias": "UPDATE_DATE", "type": "esriFieldTypeDouble" }, { "modelName": "last_reported_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "last_reported_date", "length": 2147483647, "alias": "LAST_REPORTED_DATE", "type": "esriFieldTypeString" }, { "modelName": "fac_url", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fac_url", "length": 2147483647, "alias": "FAC_URL", "type": "esriFieldTypeString" }, { "modelName": "pgm_sys_acrnm", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pgm_sys_acrnm", "length": 2147483647, "alias": "PGM_SYS_ACRNM", "type": "esriFieldTypeString" }, { "modelName": "interest_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "interest_type", "length": 2147483647, "alias": "INTEREST_TYPE", "type": "esriFieldTypeString" }, { "modelName": "program_url", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "program_url", "length": 2147483647, "alias": "PROGRAM_URL", "type": "esriFieldTypeString" }, { "modelName": "pgm_report_url", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pgm_report_url", "length": 2147483647, "alias": "PGM_REPORT_URL", "type": "esriFieldTypeString" }, { "modelName": "public_ind", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "public_ind", "length": 2147483647, "alias": "PUBLIC_IND", "type": "esriFieldTypeString" }, { "modelName": "active_status", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "active_status", "alias": "ACTIVE_STATUS", "type": "esriFieldTypeDouble" }, { "modelName": "federal_agency_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "federal_agency_name", "alias": "FEDERAL_AGENCY_NAME", "type": "esriFieldTypeDouble" }, { "modelName": "huc_12", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "huc_12", "alias": "HUC_12", "type": "esriFieldTypeDouble" }, { "modelName": "federal_land_ind", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "federal_land_ind", "alias": "FEDERAL_LAND_IND", "type": "esriFieldTypeDouble" }, { "modelName": "fed_facility_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fed_facility_code", "alias": "FED_FACILITY_CODE", "type": "esriFieldTypeDouble" }, { "modelName": "epa_region_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "epa_region_code", "alias": "EPA_REGION_CODE", "type": "esriFieldTypeInteger" }, { "modelName": "key_field", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "key_field", "length": 2147483647, "alias": "KEY_FIELD", "type": "esriFieldTypeString" }, { "modelName": "pgm_sys_id_url", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pgm_sys_id_url", "length": 2147483647, "alias": "PGM_SYS_ID_URL", "type": "esriFieldTypeString" }, { "modelName": "size_in_acres", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "size_in_acres", "alias": "SIZE_IN_ACRES", "type": "esriFieldTypeDouble" }, { "modelName": "owner_operator", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "owner_operator", "length": 2147483647, "alias": "OWNER_OPERATOR", "type": "esriFieldTypeString" }, { "modelName": "property_highlights", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "property_highlights", "length": 2147483647, "alias": "PROPERTY_HIGHLIGHTS", "type": "esriFieldTypeString" }, { "modelName": "former_use", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "former_use", "length": 2147483647, "alias": "FORMER_USE", "type": "esriFieldTypeString" }, { "modelName": "naics_all", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "naics_all", "length": 2147483647, "alias": "NAICS_ALL", "type": "esriFieldTypeString" }, { "modelName": "naics_industry_code", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "naics_industry_code", "length": 2147483647, "alias": "NAICS_INDUSTRY_CODE", "type": "esriFieldTypeString" }, { "modelName": "naics_industry_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "naics_industry_name", "length": 2147483647, "alias": "NAICS_INDUSTRY_NAME", "type": "esriFieldTypeString" }, { "modelName": "proposed_industry", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "proposed_industry", "length": 2147483647, "alias": "PROPOSED_INDUSTRY", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "Brownfields are properties potentially complicated by the presence of hazardous substances. This dataset not only includes locations of these sites but also offers a detailed perspective on their characteristics, historical use, and potential industry associations, making it valuable for environmental assessment and urban planning.AttributesPROPERTY_HIGHLIGHTS: Text extracted from each site's 'Property Highlights' section, detailing features and environmental considerations.FORMER_USE: A subset of PROPERTY_HIGHLIGHTS, focusing on the text following 'Former Use:' to specify previous site usage.PGM_SYS_ID_URL: A generated URL for each site, created using the PGM_SYS_ID value, providing direct access to more detailed information.NAICS_ALL: NAICS codes scraped from the PGM_SYS_ID_URL, reflecting the full range of industry classifications associated with each site.NAICS_INDUSTRY_CODE: The first two digits of the NAICS_ALL code, representing the broad industry category.NAICS_INDUSTRY_NAME: The name corresponding to the NAICS_INDUSTRY_CODE, providing a textual description of the industry sector.PROPOSED_INDUSTRY: Industry classification inferred from matching keywords in PROPERTY_HIGHLIGHTS to predefined industry-specific keywords.OWNER_OPERATOR: Information about the owner or operator of the site, extracted via web scraping.SIZE_IN_ACRES: Area of the site in acres.MethodologyURL Generation: Creating direct links to additional site-specific information using PGM_SYS_ID values.Web Scraping: Custom scripts to collect data from specific URLs related to each Brownfield site.Text Matching & Analysis: Utilizing keywords for industry type inference and extracting specific data points like FORMER_USE.Industry Classification: Using NAICS codes and keywords to classify and understand the potential industry background of each site.Industry Type Assignment Keywords: These keywords were used to analyze and categorize the text in the PROPERTY_HIGHLIGHTS column of the dataset, contributing to the identification of potential industry types associated with each site.Agriculture, Forestry, Fishing, and Hunting (11): agriculture, agricultural, farm, crop, livestock, harvest, timber, fishery, greenhouseMining, Quarrying, and Oil and Gas Extraction (21): mining, quarry, oil, extract, extraction, mineral extract, coal, ore, petroleum, natural gas, mineUtilities (22): electric power, natural gas, steam, sewer, treatment, sewageConstruction (23): constructionManufacturing (31-33): manufacturing, manufacture, manufacturer, plant, factories, factory, mill, processingWholesale Trade (42): wholesale, trade, wholesaling, warehouse, distribution, merchants, sales, sorting, packaging, labeling, marketing servicesRetail Trade (44-45): retail, merchandise, consumer good, shopping, mall, boutique, department store, grocery store, clothing store, storeTransportation and Warehousing (48-49): transport, warehousing, storage, cargo, airport, rail, train, ship, road, pipeline, postal, courierInformation (51): information sector, library, libraries, publishing, broadcasting, information servicesFinance and Insurance (52): finance, insuranceReal Estate and Rental and Leasing (53): real estate, rental, leasingProfessional, Scientific, and Technical Services (54): professional, scientific, technical, legal, accounting, firm, consulting, laboratory, laboratoriesManagement of Companies and Enterprises (55): management sector, companies management, enterprises managementAdministrative and Support and Waste Management and Remediation Services (56): waste disposal, waste management, waste collection, waste treatment, waste disposal, dump, septic pump, landfill, incineratorEducational Services (61): education, school, college, universities, university, academicHealth Care and Social Assistance (62): health care, social assistance, medical, health service, hospital, clinic, nursing, social service, public healthArts, Entertainment, and Recreation (71): event, exhibit, cultural, historical, museum, zoo, garden, amusement park, theme park, casino, entertainment, recreational, leisure, open space, park, landmarkAccommodation and Food Services (72): lodging, food service, restaurant, hotel, motel, inn, bed and breakfast, cafe, bar, food preparation, hospitality, dining, camping, campgroundOther Services (except Public Administration) (81): equipment repair, machinery repair, religious, church, laundromat, laundry, dry cleaning, salon, funeral, pet care, photofinish, parking garage, parking lot, barber, cemetery, crematorPublic Administration (92)* public administration, courthouse, public safety, defense, fire stations, police stations, armory, fire station, police, firestation, military, baseLimitationsAccuracy of Industry Classification: The PROPOSED_INDUSTRY is based on keyword matching and may not reflect the actual industry.Dependence on Web Sources: Changes in web page structures can affect data scraping accuracy.Scope of Data: The dataset focuses on specific attributes and might not cover all aspects of each Brownfield site.", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "r4711_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a4515_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "22aaf2e337974faf8369d53ce09ae988", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": false, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0 }, "color": [ 115, 38, 0, 255 ], "size": 10, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "shape", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "Shape", "type": "esriFieldTypeGeometry" }, "copyrightText": "Original Data Source:\n\"ACRES: Assessment, Cleanup and Redevelopment Exchange System,\" Environmental Protection Agency [https://www.epa.gov/frs/geospatial-data-download-service]", "zDefault": 0, "geometryType": "esriGeometryPoint" }