Layers:

Layer: Spill Point for Public Reporting (0)

Name: Spill Point for Public Reporting

Display Field: USER_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: -1.14656381585E7
YMin: -4551401.113600001
XMax: 0.0
YMax: 4866488.6875
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)



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 )
• SPILL_ID ( type: esriFieldTypeString, alias: SPILL_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SPILL_ID )
• NOTIFICATION_DATE_TXT ( type: esriFieldTypeString, alias: NOTIFICATION_DATE_TXT, editable: true, nullable: true, length: 30, defaultValue: null, modelName: NOTIFICATION_DATE_TXT )
• SPILL_COMPLAINT ( type: esriFieldTypeString, alias: SPILL_COMPLAINT, editable: true, nullable: true, length: 500, defaultValue: null, modelName: SPILL_COMPLAINT )
• NOTIFICATION_BY ( type: esriFieldTypeString, alias: NOTIFICATION_BY, editable: true, nullable: true, length: 500, defaultValue: null, modelName: NOTIFICATION_BY )
• USER_NAME ( type: esriFieldTypeString, alias: USER_NAME, editable: true, nullable: true, length: 500, defaultValue: null, modelName: USER_NAME )
• NRC_NOTIFIED ( type: esriFieldTypeString, alias: NRC_NOTIFIED, editable: true, nullable: true, length: 500, defaultValue: null, modelName: NRC_NOTIFIED )
• NRC_NUMBER ( type: esriFieldTypeString, alias: NRC_NUMBER, editable: true, nullable: true, length: 500, defaultValue: null, modelName: NRC_NUMBER )
• INCIDENT_NO ( type: esriFieldTypeString, alias: INCIDENT_NO, editable: true, nullable: true, length: 500, defaultValue: null, modelName: INCIDENT_NO )
• EPA_RESPOND ( type: esriFieldTypeString, alias: EPA_RESPOND, editable: true, nullable: true, length: 500, defaultValue: null, modelName: EPA_RESPOND )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: STATUS )
• CON_REQUEST ( type: esriFieldTypeString, alias: CON_REQUEST, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CON_REQUEST )
• CALLER_NAME ( type: esriFieldTypeString, alias: CALLER_NAME, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CALLER_NAME )
• CALLER_ORGANIZATION ( type: esriFieldTypeString, alias: CALLER_ORGANIZATION, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CALLER_ORGANIZATION )
• CALLER_ORG_TYPE ( type: esriFieldTypeString, alias: CALLER_ORG_TYPE, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CALLER_ORG_TYPE )
• CALLER_PHONE ( type: esriFieldTypeString, alias: CALLER_PHONE, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CALLER_PHONE )
• CALLER_ADDRESS ( type: esriFieldTypeString, alias: CALLER_ADDRESS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CALLER_ADDRESS )
• CALLER_CITY ( type: esriFieldTypeString, alias: CALLER_CITY, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CALLER_CITY )
• CALLER_STATE ( type: esriFieldTypeString, alias: CALLER_STATE, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CALLER_STATE )
• CALLER_ZIP ( type: esriFieldTypeString, alias: CALLER_ZIP, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CALLER_ZIP )
• SPILLER_ORGANIZATION ( type: esriFieldTypeString, alias: SPILLER_ORGANIZATION, editable: true, nullable: true, length: 500, defaultValue: null, modelName: SPILLER_ORGANIZATION )
• ORGANIZATION_TYPE ( type: esriFieldTypeString, alias: ORGANIZATION_TYPE, editable: true, nullable: true, length: 500, defaultValue: null, modelName: ORGANIZATION_TYPE )
• SPILLER_PHONE ( type: esriFieldTypeString, alias: SPILLER_PHONE, editable: true, nullable: true, length: 500, defaultValue: null, modelName: SPILLER_PHONE )
• CONTACT_NAME ( type: esriFieldTypeString, alias: CONTACT_NAME, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CONTACT_NAME )
• SPILLER_LICENSE ( type: esriFieldTypeString, alias: SPILLER_LICENSE, editable: true, nullable: true, length: 500, defaultValue: null, modelName: SPILLER_LICENSE )
• SPILLER_ADDRESS ( type: esriFieldTypeString, alias: SPILLER_ADDRESS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: SPILLER_ADDRESS )
• SPILLER_CITY ( type: esriFieldTypeString, alias: SPILLER_CITY, editable: true, nullable: true, length: 500, defaultValue: null, modelName: SPILLER_CITY )
• SPILLER_STATE ( type: esriFieldTypeString, alias: SPILLER_STATE, editable: true, nullable: true, length: 500, defaultValue: null, modelName: SPILLER_STATE )
• SPILLER_ZIP ( type: esriFieldTypeString, alias: SPILLER_ZIP, editable: true, nullable: true, length: 500, defaultValue: null, modelName: SPILLER_ZIP )
• FACILITY_ADDRESS ( type: esriFieldTypeString, alias: FACILITY_ADDRESS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: FACILITY_ADDRESS )
• LOCATION_CITY ( type: esriFieldTypeString, alias: LOCATION_CITY, editable: true, nullable: true, length: 500, defaultValue: null, modelName: LOCATION_CITY )
• MAPPING_ZIPCODE ( type: esriFieldTypeString, alias: MAPPING_ZIPCODE, editable: true, nullable: true, length: 500, defaultValue: null, modelName: MAPPING_ZIPCODE )
• LOCATION_COUNTY ( type: esriFieldTypeString, alias: LOCATION_COUNTY, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: LOCATION_COUNTY )
• KDHE_DISTRICT ( type: esriFieldTypeString, alias: KDHE_DISTRICT, editable: true, nullable: true, length: 500, defaultValue: null, modelName: KDHE_DISTRICT )
• LEGAL_DESCRIPTION ( type: esriFieldTypeString, alias: LEGAL_DESCRIPTION, editable: true, nullable: true, length: 1500, defaultValue: null, modelName: LEGAL_DESCRIPTION )
• FACILITY_NAME ( type: esriFieldTypeString, alias: FACILITY_NAME, editable: true, nullable: true, length: 500, defaultValue: null, modelName: FACILITY_NAME )
• APPROX_LOCATION ( type: esriFieldTypeString, alias: APPROX_LOCATION, editable: true, nullable: true, length: 500, defaultValue: null, modelName: APPROX_LOCATION )
• FACILITY_NO ( type: esriFieldTypeString, alias: FACILITY_NO, editable: true, nullable: true, length: 500, defaultValue: null, modelName: FACILITY_NO )
• KCC_DISTRICT ( type: esriFieldTypeString, alias: KCC_DISTRICT, editable: true, nullable: true, length: 500, defaultValue: null, modelName: KCC_DISTRICT )
• LOCATION_LAT ( type: esriFieldTypeString, alias: LOCATION_LAT, editable: true, nullable: true, length: 500, defaultValue: null, modelName: LOCATION_LAT )
• LOCATION_LONG ( type: esriFieldTypeString, alias: LOCATION_LONG, editable: true, nullable: true, length: 500, defaultValue: null, modelName: LOCATION_LONG )
• LOCATION_COMMENT ( type: esriFieldTypeString, alias: LOCATION_COMMENT, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LOCATION_COMMENT )
• 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 )
• INCIDENT_DATE_TXT ( type: esriFieldTypeString, alias: INCIDENT_DATE_TXT, editable: true, nullable: true, length: 30, defaultValue: null, modelName: INCIDENT_DATE_TXT )
• DISCOVERY_DATE_TXT ( type: esriFieldTypeString, alias: DISCOVERY_DATE_TXT, editable: true, nullable: true, length: 30, defaultValue: null, modelName: DISCOVERY_DATE_TXT )
• CLOSED_DATE_TXT ( type: esriFieldTypeString, alias: CLOSED_DATE_TXT, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CLOSED_DATE_TXT )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, editable: true, nullable: true, length: 500, defaultValue: null, modelName: SOURCE )
• TRUCK_NO ( type: esriFieldTypeString, alias: TRUCK_NO, editable: true, nullable: true, length: 500, defaultValue: null, modelName: TRUCK_NO )
• CONTAINER_CAPACITY ( type: esriFieldTypeString, alias: CONTAINER_CAPACITY, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CONTAINER_CAPACITY )
• CONTAINER_UNITS ( type: esriFieldTypeString, alias: CONTAINER_UNITS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CONTAINER_UNITS )
• SOURCE_COMMENT ( type: esriFieldTypeString, alias: SOURCE_COMMENT, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SOURCE_COMMENT )
• MEDIUM_AFFECTED ( type: esriFieldTypeString, alias: MEDIUM_AFFECTED, editable: true, nullable: true, length: 1002, defaultValue: null, modelName: MEDIUM_AFFECTED )
• WATER_WAY_TYPE ( type: esriFieldTypeString, alias: WATER_WAY_TYPE, editable: true, nullable: true, length: 500, defaultValue: null, modelName: WATER_WAY_TYPE )
• WATER_WAY_NAME ( type: esriFieldTypeString, alias: WATER_WAY_NAME, editable: true, nullable: true, length: 500, defaultValue: null, modelName: WATER_WAY_NAME )
• CAUSE ( type: esriFieldTypeString, alias: CAUSE, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CAUSE )
• CAUSE_COMMENT ( type: esriFieldTypeString, alias: CAUSE_COMMENT, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CAUSE_COMMENT )
• NUMBER_OF_INJURIES ( type: esriFieldTypeString, alias: NUMBER_OF_INJURIES, editable: true, nullable: true, length: 500, defaultValue: null, modelName: NUMBER_OF_INJURIES )
• NUMBER_OF_FATALITIES ( type: esriFieldTypeString, alias: NUMBER_OF_FATALITIES, editable: true, nullable: true, length: 500, defaultValue: null, modelName: NUMBER_OF_FATALITIES )
• ENVIRONMENTAL_IMPACT ( type: esriFieldTypeString, alias: ENVIRONMENTAL_IMPACT, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ENVIRONMENTAL_IMPACT )
• EVACUATIONS ( type: esriFieldTypeString, alias: EVACUATIONS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EVACUATIONS )
• RESPONDERS_ON_SCENE ( type: esriFieldTypeString, alias: RESPONDERS_ON_SCENE, editable: true, nullable: true, length: 500, defaultValue: null, modelName: RESPONDERS_ON_SCENE )
• ACTIONS_TAKEN ( type: esriFieldTypeString, alias: ACTIONS_TAKEN, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ACTIONS_TAKEN )
• AGENCY_COMMENT ( type: esriFieldTypeString, alias: AGENCY_COMMENT, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: AGENCY_COMMENT )
• LEAD_AGENCY ( type: esriFieldTypeString, alias: LEAD_AGENCY, editable: true, nullable: true, length: 500, defaultValue: null, modelName: LEAD_AGENCY )
• KDHE_VISITED ( type: esriFieldTypeString, alias: KDHE_VISITED, editable: true, nullable: true, length: 500, defaultValue: null, modelName: KDHE_VISITED )
• INVEST_AGENCY ( type: esriFieldTypeString, alias: INVEST_AGENCY, editable: true, nullable: true, length: 500, defaultValue: null, modelName: INVEST_AGENCY )
• INVESTIGATORS ( type: esriFieldTypeString, alias: INVESTIGATORS, editable: true, nullable: true, length: 200, defaultValue: null, modelName: INVESTIGATORS )
• CLEANUP_METHOD ( type: esriFieldTypeString, alias: CLEANUP_METHOD, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CLEANUP_METHOD )
• CLEANUP_DESCRIPTION ( type: esriFieldTypeString, alias: CLEANUP_DESCRIPTION, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: CLEANUP_DESCRIPTION )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: COMMENTS )
Templates:
• Name: Spill Point for Public Reporting
  Description:
  Prototype:
  CLEANUP_DESCRIPTION: null
  COMMENTS: null
  SPILL_ID: null
  NOTIFICATION_DATE_TXT: null
  SPILL_COMPLAINT: null
  NOTIFICATION_BY: null
  USER_NAME: null
  NRC_NOTIFIED: null
  NRC_NUMBER: null
  INCIDENT_NO: null
  EPA_RESPOND: null
  STATUS: null
  CON_REQUEST: null
  CALLER_NAME: null
  CALLER_ORGANIZATION: null
  CALLER_ORG_TYPE: null
  CALLER_PHONE: null
  CALLER_ADDRESS: null
  CALLER_CITY: null
  CALLER_STATE: null
  CALLER_ZIP: null
  SPILLER_ORGANIZATION: null
  ORGANIZATION_TYPE: null
  SPILLER_PHONE: null
  CONTACT_NAME: null
  SPILLER_LICENSE: null
  SPILLER_ADDRESS: null
  SPILLER_CITY: null
  SPILLER_STATE: null
  SPILLER_ZIP: null
  FACILITY_ADDRESS: null
  LOCATION_CITY: null
  MAPPING_ZIPCODE: null
  LOCATION_COUNTY: null
  KDHE_DISTRICT: null
  LEGAL_DESCRIPTION: null
  FACILITY_NAME: null
  APPROX_LOCATION: null
  FACILITY_NO: null
  KCC_DISTRICT: null
  LOCATION_LAT: null
  LOCATION_LONG: null
  LOCATION_COMMENT: null
  LATITUDE: null
  LONGITUDE: null
  INCIDENT_DATE_TXT: null
  DISCOVERY_DATE_TXT: null
  CLOSED_DATE_TXT: null
  SOURCE: null
  TRUCK_NO: null
  CONTAINER_CAPACITY: null
  CONTAINER_UNITS: null
  SOURCE_COMMENT: null
  MEDIUM_AFFECTED: null
  WATER_WAY_TYPE: null
  WATER_WAY_NAME: null
  CAUSE: null
  CAUSE_COMMENT: null
  NUMBER_OF_INJURIES: null
  NUMBER_OF_FATALITIES: null
  ENVIRONMENTAL_IMPACT: null
  EVACUATIONS: null
  RESPONDERS_ON_SCENE: null
  ACTIONS_TAKEN: null
  AGENCY_COMMENT: null
  LEAD_AGENCY: null
  KDHE_VISITED: null
  INVEST_AGENCY: null
  INVESTIGATORS: null
  CLEANUP_METHOD: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• SDE.BER_SPILLPOINT_REPORT_MATERIAL (0) -- Related To: Spill Material Related Table (1)

Tables:

Table: Spill Material Related Table (1)

Name: Spill Material Related Table

Display Field: MATERIAL_ID

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• INCIDENT_NO ( type: esriFieldTypeString, alias: INCIDENT_NO, editable: true, nullable: true, length: 500, defaultValue: null, modelName: INCIDENT_NO )
• MATERIAL_SPILLED ( type: esriFieldTypeString, alias: Material Spilled, editable: true, nullable: true, length: 500, defaultValue: null, modelName: MATERIAL_SPILLED )
• MATERIAL_DESC ( type: esriFieldTypeString, alias: Material Name, editable: true, nullable: true, length: 500, defaultValue: null, modelName: MATERIAL_DESC )
• CAS ( type: esriFieldTypeString, alias: CAS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CAS )
• UN_DOT ( type: esriFieldTypeString, alias: UN_DOT, editable: true, nullable: true, length: 500, defaultValue: null, modelName: UN_DOT )
• QUANTITY_SPILLED ( type: esriFieldTypeString, alias: Quantity Spilled, editable: true, nullable: true, length: 1001, defaultValue: null, modelName: QUANTITY_SPILLED )
• QUANTITY_RECOVERED ( type: esriFieldTypeString, alias: Quantity Recovered, editable: true, nullable: true, length: 1001, defaultValue: null, modelName: QUANTITY_RECOVERED )
Templates:
• Name: Spill Material Related Table
  Description:
  Prototype:
  QUANTITY_SPILLED: null
  QUANTITY_RECOVERED: null
  INCIDENT_NO: null
  MATERIAL_SPILLED: null
  MATERIAL_DESC: null
  CAS: null
  UN_DOT: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SDE.BER_SPILLPOINT_REPORT_FEATURECLASS (0) -- Related To: Spill Point for Public Reporting (0)