View In:   ArcGIS Online Map Viewer

Name: Historic Spills and Releases

Display Field: Product

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This contains spills reported to Ohio EPA since 2001. Initially stored in the RRS database, began using P1 CAD in May 2017. Current year data not included in this dataset.

Service Item Id: a0653839da8a4e0db4c85d301930b45a

Copyright Text: Ohio EPA, Division of Environmental Response

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 9244648.868618

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -85.165560499
YMin: 38.34054282
XMax: -80.470392377
YMax: 41.980841565000006
Spatial Reference: 4326  (4326)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: true
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: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• PRODUCT ( type: esriFieldTypeString, alias: Product, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Product )
• AMOUNT ( type: esriFieldTypeDouble, alias: Amount, editable: true, nullable: true, defaultValue: null, modelName: Amount )
• UNIT ( type: esriFieldTypeString, alias: Unit, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Unit )
• REPORTEDON ( type: esriFieldTypeDate, alias: ReportedOn, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ReportedOn )
• SPILLSIZE ( type: esriFieldTypeString, alias: SpillSize, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SpillSize )
• SPILLTYPE ( type: esriFieldTypeString, alias: SpillType, editable: true, nullable: true, length: 150, defaultValue: null, modelName: SpillType )
• EXTHAZ ( type: esriFieldTypeString, alias: ExtHaz, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ExtHaz )
• OEPADIST ( type: esriFieldTypeString, alias: OEPA District Office, editable: true, nullable: true, length: 25, defaultValue: null, modelName: OEPADist )
• COUNTY ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 10, defaultValue: null, modelName: County )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• CITY_TWN ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 150, defaultValue: null, modelName: City_Twn )
• INCIDENTTYPECODE ( type: esriFieldTypeString, alias: Incident Type Code, editable: true, nullable: true, length: 2, defaultValue: null, modelName: IncidentTypecode )
• INCIDENTTYPECODEDESC ( type: esriFieldTypeString, alias: Type Code Desc, editable: true, nullable: true, length: 20, defaultValue: null, modelName: IncidentTypeCodeDesc )
• MODIFYINGCIRCUMSTANCECODE ( type: esriFieldTypeString, alias: Modifying Circumstance Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ModifyingCircumstanceCode )
• MODIFYINGCIRCUMSTANCEDESC ( type: esriFieldTypeString, alias: Modifying Circumstance Desc, editable: true, nullable: true, length: 256, defaultValue: null, modelName: ModifyingCircumstanceDesc )
• DISPOSITION ( type: esriFieldTypeString, alias: Disposition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Disposition )
• SPILLID ( type: esriFieldTypeString, alias: Spillid, editable: true, nullable: true, length: 14, defaultValue: null, modelName: Spillid )
• SPILLYEAR ( type: esriFieldTypeInteger, alias: SpillYear, editable: true, nullable: true, defaultValue: null, modelName: SpillYear )
• SPILLMONTH ( type: esriFieldTypeString, alias: SpillMonth, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SpillMonth )
• SPILLMONTHN ( type: esriFieldTypeInteger, alias: SpillMonthN, editable: true, nullable: true, defaultValue: null, modelName: SpillMonthN )
• SPILLDOM ( type: esriFieldTypeInteger, alias: SpillDOM, editable: true, nullable: true, defaultValue: null, modelName: SpillDOM )
• SPILLDOY ( type: esriFieldTypeInteger, alias: SpillDOY, editable: true, nullable: true, defaultValue: null, modelName: SpillDOY )
• LATITUDE ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Longitude )

Templates:

• Name: Historic Spills and Releases
  Description:
  Prototype:
  LATITUDE: null
  LONGITUDE: null
  PRODUCT: null
  AMOUNT: null
  UNIT: null
  REPORTEDON: null
  SPILLSIZE: null
  SPILLTYPE: null
  EXTHAZ: null
  OEPADIST: null
  COUNTY: null
  LOCATION: null
  CITY_TWN: null
  INCIDENTTYPECODE: null
  INCIDENTTYPECODEDESC: null
  MODIFYINGCIRCUMSTANCECODE: null
  MODIFYINGCIRCUMSTANCEDESC: null
  DISPOSITION: null
  SPILLID: null
  SPILLYEAR: null
  SPILLMONTH: null
  SPILLMONTHN: null
  SPILLDOM: null
  SPILLDOY: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata