Name: MPCA Remediation Sites

Display Field: item_id

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 53bfdc20c89a4aff863706b8cc0a8d0a

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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

Feature Draw Order:

N/A

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: 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 )
• item_id ( type: esriFieldTypeString, alias: item_id, editable: true, nullable: true, length: 75, defaultValue: null, modelName: item_id )
• ai_id ( type: esriFieldTypeDouble, alias: ai_id, editable: true, nullable: true, defaultValue: null, modelName: ai_id )
• site_id ( type: esriFieldTypeString, alias: site_id, editable: true, nullable: true, length: 100, defaultValue: null, modelName: site_id )
• si_cat ( type: esriFieldTypeString, alias: si_cat, editable: true, nullable: true, length: 4, defaultValue: null, modelName: si_cat )
• si_id ( type: esriFieldTypeDouble, alias: si_id, editable: true, nullable: true, defaultValue: null, modelName: si_id )
• activity_id ( type: esriFieldTypeString, alias: activity_id, editable: true, nullable: true, length: 27, defaultValue: null, modelName: activity_id )
• activity_type_desc ( type: esriFieldTypeString, alias: activity_type_desc, editable: true, nullable: true, length: 100, defaultValue: null, modelName: activity_type_desc )
• activity_class_code ( type: esriFieldTypeString, alias: activity_class_code, editable: true, nullable: true, length: 3, defaultValue: null, modelName: activity_class_code )
• activity_year ( type: esriFieldTypeSmallInteger, alias: activity_year, editable: true, nullable: true, defaultValue: null, modelName: activity_year )
• activity_num ( type: esriFieldTypeInteger, alias: activity_num, editable: true, nullable: true, defaultValue: null, modelName: activity_num )
• site_start ( type: esriFieldTypeDate, alias: site_start, editable: true, nullable: true, length: 8, defaultValue: null, modelName: site_start )
• leak_discovered ( type: esriFieldTypeDate, alias: leak_discovered, editable: true, nullable: true, length: 8, defaultValue: null, modelName: leak_discovered )
• leak_reported ( type: esriFieldTypeDate, alias: leak_reported, editable: true, nullable: true, length: 8, defaultValue: null, modelName: leak_reported )
• leak_reopened ( type: esriFieldTypeDate, alias: leak_reopened, editable: true, nullable: true, length: 8, defaultValue: null, modelName: leak_reopened )
• received ( type: esriFieldTypeDate, alias: received, editable: true, nullable: true, length: 8, defaultValue: null, modelName: received )
• discovered ( type: esriFieldTypeDate, alias: discovered, editable: true, nullable: true, length: 8, defaultValue: null, modelName: discovered )
• staff_assigned ( type: esriFieldTypeDate, alias: staff_assigned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: staff_assigned )
• app_completed ( type: esriFieldTypeDate, alias: app_completed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: app_completed )
• site_closed ( type: esriFieldTypeDate, alias: site_closed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: site_closed )
• npl_list ( type: esriFieldTypeDate, alias: npl_list, editable: true, nullable: true, length: 8, defaultValue: null, modelName: npl_list )
• npl_delete ( type: esriFieldTypeDate, alias: npl_delete, editable: true, nullable: true, length: 8, defaultValue: null, modelName: npl_delete )
• plp_list ( type: esriFieldTypeDate, alias: plp_list, editable: true, nullable: true, length: 8, defaultValue: null, modelName: plp_list )
• plp_delist ( type: esriFieldTypeDate, alias: plp_delist, editable: true, nullable: true, length: 8, defaultValue: null, modelName: plp_delist )
• ff_aproved ( type: esriFieldTypeDate, alias: ff_aproved, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ff_aproved )
• ff_closed ( type: esriFieldTypeDate, alias: ff_closed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ff_closed )
• inv_completed ( type: esriFieldTypeDate, alias: inv_completed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inv_completed )
• er_site_eval ( type: esriFieldTypeDate, alias: er_site_eval, editable: true, nullable: true, length: 8, defaultValue: null, modelName: er_site_eval )
• remedy_implemented ( type: esriFieldTypeDate, alias: remedy_implemented, editable: true, nullable: true, length: 8, defaultValue: null, modelName: remedy_implemented )
• remedy_selected ( type: esriFieldTypeDate, alias: remedy_selected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: remedy_selected )
• asmt_completed ( type: esriFieldTypeDate, alias: asmt_completed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: asmt_completed )
• nfa_decision ( type: esriFieldTypeDate, alias: nfa_decision, editable: true, nullable: true, length: 8, defaultValue: null, modelName: nfa_decision )

Templates:

• Name: MPCA Remediation Sites
  Description:
  Prototype:
  asmt_completed: null
  nfa_decision: null
  item_id: null
  ai_id: null
  site_id: null
  si_cat: null
  si_id: null
  activity_id: null
  activity_type_desc: null
  activity_class_code: null
  activity_year: null
  activity_num: null
  site_start: null
  leak_discovered: null
  leak_reported: null
  leak_reopened: null
  received: null
  discovered: null
  staff_assigned: null
  app_completed: null
  site_closed: null
  npl_list: null
  npl_delete: null
  plp_list: null
  plp_delist: null
  ff_aproved: null
  ff_closed: null
  inv_completed: null
  er_site_eval: null
  remedy_implemented: null
  remedy_selected: null
  
  Drawing Tool: esriFeatureEditToolNone

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: false

Child Resources:

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