View In:   ArcGIS Online Map Viewer

Name: Brownfields

Display Field: primary_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

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.

Service Item Id: 22aaf2e337974faf8369d53ce09ae988

Copyright Text: Original Data Source: "ACRES: Assessment, Cleanup and Redevelopment Exchange System," Environmental Protection Agency [https://www.epa.gov/frs/geospatial-data-download-service]

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -1.88794879702E7
YMin: 1509804.9657999985
XMax: 1.6230686773100004E7
YMax: 1.1496866317500003E7
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [115, 38, 0, 255]
Size: 10.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• pgm_sys_id ( modelName: pgm_sys_id, nullable: true, editable: true, defaultValue: null, alias: PGM_SYS_ID, type: esriFieldTypeInteger )
• oid_ ( modelName: oid_, nullable: true, editable: true, defaultValue: null, alias: OID_, type: esriFieldTypeInteger )
• primary_name ( modelName: primary_name, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PRIMARY_NAME, type: esriFieldTypeString )
• location_address ( modelName: location_address, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: LOCATION_ADDRESS, type: esriFieldTypeString )
• city_name ( modelName: city_name, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CITY_NAME, type: esriFieldTypeString )
• county_name ( modelName: county_name, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: COUNTY_NAME, type: esriFieldTypeString )
• fips_code ( modelName: fips_code, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: FIPS_CODE, type: esriFieldTypeString )
• state_code ( modelName: state_code, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: STATE_CODE, type: esriFieldTypeString )
• postal_code ( modelName: postal_code, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: POSTAL_CODE, type: esriFieldTypeString )
• latitude83 ( modelName: latitude83, nullable: true, editable: true, defaultValue: null, alias: LATITUDE83, type: esriFieldTypeDouble )
• longitude83 ( modelName: longitude83, nullable: true, editable: true, defaultValue: null, alias: LONGITUDE83, type: esriFieldTypeDouble )
• huc8_code ( modelName: huc8_code, nullable: true, editable: true, defaultValue: null, alias: HUC8_CODE, type: esriFieldTypeDouble )
• accuracy_value ( modelName: accuracy_value, nullable: true, editable: true, defaultValue: null, alias: ACCURACY_VALUE, type: esriFieldTypeDouble )
• collect_mth_desc ( modelName: collect_mth_desc, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: COLLECT_MTH_DESC, type: esriFieldTypeString )
• ref_point_desc ( modelName: ref_point_desc, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: REF_POINT_DESC, type: esriFieldTypeString )
• create_date ( modelName: create_date, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: CREATE_DATE, type: esriFieldTypeString )
• update_date ( modelName: update_date, nullable: true, editable: true, defaultValue: null, alias: UPDATE_DATE, type: esriFieldTypeDouble )
• last_reported_date ( modelName: last_reported_date, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: LAST_REPORTED_DATE, type: esriFieldTypeString )
• fac_url ( modelName: fac_url, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: FAC_URL, type: esriFieldTypeString )
• pgm_sys_acrnm ( modelName: pgm_sys_acrnm, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PGM_SYS_ACRNM, type: esriFieldTypeString )
• interest_type ( modelName: interest_type, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: INTEREST_TYPE, type: esriFieldTypeString )
• program_url ( modelName: program_url, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PROGRAM_URL, type: esriFieldTypeString )
• pgm_report_url ( modelName: pgm_report_url, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PGM_REPORT_URL, type: esriFieldTypeString )
• public_ind ( modelName: public_ind, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PUBLIC_IND, type: esriFieldTypeString )
• active_status ( modelName: active_status, nullable: true, editable: true, defaultValue: null, alias: ACTIVE_STATUS, type: esriFieldTypeDouble )
• federal_agency_name ( modelName: federal_agency_name, nullable: true, editable: true, defaultValue: null, alias: FEDERAL_AGENCY_NAME, type: esriFieldTypeDouble )
• huc_12 ( modelName: huc_12, nullable: true, editable: true, defaultValue: null, alias: HUC_12, type: esriFieldTypeDouble )
• federal_land_ind ( modelName: federal_land_ind, nullable: true, editable: true, defaultValue: null, alias: FEDERAL_LAND_IND, type: esriFieldTypeDouble )
• fed_facility_code ( modelName: fed_facility_code, nullable: true, editable: true, defaultValue: null, alias: FED_FACILITY_CODE, type: esriFieldTypeDouble )
• epa_region_code ( modelName: epa_region_code, nullable: true, editable: true, defaultValue: null, alias: EPA_REGION_CODE, type: esriFieldTypeInteger )
• key_field ( modelName: key_field, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: KEY_FIELD, type: esriFieldTypeString )
• pgm_sys_id_url ( modelName: pgm_sys_id_url, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PGM_SYS_ID_URL, type: esriFieldTypeString )
• size_in_acres ( modelName: size_in_acres, nullable: true, editable: true, defaultValue: null, alias: SIZE_IN_ACRES, type: esriFieldTypeDouble )
• owner_operator ( modelName: owner_operator, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: OWNER_OPERATOR, type: esriFieldTypeString )
• property_highlights ( modelName: property_highlights, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PROPERTY_HIGHLIGHTS, type: esriFieldTypeString )
• former_use ( modelName: former_use, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: FORMER_USE, type: esriFieldTypeString )
• naics_all ( modelName: naics_all, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: NAICS_ALL, type: esriFieldTypeString )
• naics_industry_code ( modelName: naics_industry_code, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: NAICS_INDUSTRY_CODE, type: esriFieldTypeString )
• naics_industry_name ( modelName: naics_industry_name, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: NAICS_INDUSTRY_NAME, type: esriFieldTypeString )
• proposed_industry ( modelName: proposed_industry, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: PROPOSED_INDUSTRY, type: esriFieldTypeString )

Templates:

• Name: Brownfields
  Description:
  Prototype:
  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
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata