Name: DERR Database (OEPA-DERR)

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: The Division of Environmental Response and Revitalization (DERR) database is an index of sites for which our district offices maintain files. The database is NOT a record of contaminated sites in Ohio. Not all sites in the database are contaminated, and a site’s absence from the database does not imply that it is uncontaminated. The database is also not a list of brownfield sites. Not all sites in the database meet the federal or state definitions of brownfields, and many properties in Ohio which would qualify as brownfields are not in the database.The DERR database contains basic site information only. Site information maintained in the database includes the name and address of the site; its latitude and longitude; whether the property is, to Ohio EPA’s knowledge, being cleaned up in accordance with the Voluntary Action Program (VAP) or is receiving technical assistance through the VAP; and whether Clean Ohio Fund money has been issued to remediate the site. Detailed information regarding the status of each site can be provided by the appropriate District Office.For questions or more information about the database, please contact:Frank RobertsonDivision of Environmental Response and RevitalizationOhio EPALazarus Government CenterP.O. Box 104950 West Town Street, Suite 700Columbus, OH 43215Phone: (614) 644-2306E-mail: frank.robertson@epa.ohio.govPlease keep in mind that some addresses may not be mapped appropriately due to incomplete records in the OEPA database.Source: http://epa.ohio.gov/derr/DatabaseRequest.aspx#153468673-division-of-environmental-response-and-revitalization-derr-database

Copyright Text: Ohio Environmental Protection Agency

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -9441832.6693
YMin: 4640752.7663
XMax: -8963712.5655
YMax: 5155987.5798999965
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: DERR Database
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ODOT_DISTRICT ( type: esriFieldTypeString, alias: ODOT_DISTRICT, length: 2 )
• COUNTY ( type: esriFieldTypeString, alias: COUNTY, length: 10 )
• LATITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: LATITUDE_DD_BEGIN )
• LONGITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: LONGITUDE_DD_BEGIN )
• DERR_ID ( type: esriFieldTypeDouble, alias: DERR_ID )
• NAME ( type: esriFieldTypeString, alias: NAME, length: 80 )
• ALIAS ( type: esriFieldTypeString, alias: ALIAS, length: 80 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 85 )
• CITY ( type: esriFieldTypeString, alias: CITY, length: 30 )
• ZIP ( type: esriFieldTypeString, alias: ZIP, length: 12 )
• CERCLIS_ID ( type: esriFieldTypeString, alias: CERCLIS_ID, length: 15 )
• ACTIVITY ( type: esriFieldTypeString, alias: ACTIVITY, length: 20 )
• OEPA_DISTRICT ( type: esriFieldTypeString, alias: OEPA_DISTRICT, length: 6 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata