Name: Inspections

Display Field: creator

Type: Table

Geometry Type: N/A

Description:

Service Item Id: df0452a7230b4f39bf7399f98a760df4

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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 )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, editable: false, nullable: false, length: 38, defaultValue: null, modelName: globalid )
• creator ( type: esriFieldTypeString, alias: creator, editable: false, nullable: true, length: 255, defaultValue: null, modelName: creator )
• created ( type: esriFieldTypeDate, alias: created, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created )
• editor ( type: esriFieldTypeString, alias: editor, editable: false, nullable: true, length: 255, defaultValue: null, modelName: editor )
• edited ( type: esriFieldTypeDate, alias: edited, editable: false, nullable: true, length: 8, defaultValue: null, modelName: edited )
• mn_nid_guid ( type: esriFieldTypeGUID, alias: mn_nid_guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: mn_nid_guid )
• inspecting_group ( type: esriFieldTypeString, alias: inspecting_group, editable: true, nullable: true, length: 50, defaultValue: null, modelName: inspecting_group , Coded Values: [BIA: BIA] , [Check: Check] , [DamSafety: DamSafety] , ...9 more... )
• next_insp_year ( type: esriFieldTypeInteger, alias: next_insp_year, editable: true, nullable: true, defaultValue: null, modelName: next_insp_year , Coded Values: [1111: 1111] , [2020: 2020] , [2021: 2021] , ...14 more... )
• insp_date ( type: esriFieldTypeDate, alias: insp_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: insp_date )
• rpt_writer_assi ( type: esriFieldTypeString, alias: rpt_writer_assi, editable: true, nullable: true, length: 25, defaultValue: null, modelName: rpt_writer_assi , Coded Values: [Consultant: Consultant] , [Dan Zwilling: Dan Zwilling] , [Dana Dostert: Dana Dostert] , ...6 more... )
• insp_rpt_comp_date ( type: esriFieldTypeDate, alias: insp_rpt_comp_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: insp_rpt_comp_date )
• condition_date ( type: esriFieldTypeDate, alias: condition_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: condition_date )
• condition_assessment ( type: esriFieldTypeString, alias: condition_assessment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: condition_assessment , Coded Values: [Fair: Fair] , [Not Rated: Not Rated] , [Poor: Poor] , ...2 more... )
• operationalstatus ( type: esriFieldTypeString, alias: operationalstatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: operationalstatus , Coded Values: [Enforcement Pending/Ongoing: Enforcement Pending/Ongoing] , [Normal Operations: Normal Operations] , [Not Applicable: Not Applicable] , ...2 more... )
• insp_freq ( type: esriFieldTypeSmallInteger, alias: insp_freq, editable: true, nullable: true, defaultValue: null, modelName: insp_freq , Coded Values: [1: 1] , [10: 10] , [4: 4] , ...1 more... )
• initial_inspection_year ( type: esriFieldTypeSmallInteger, alias: initial_inspection_year, editable: true, nullable: true, defaultValue: null, modelName: initial_inspection_year )
• pre_inspection_comments ( type: esriFieldTypeString, alias: pre_inspection_comments, editable: true, nullable: true, length: 300, defaultValue: null, modelName: pre_inspection_comments )
• inspection_notice_date_sent ( type: esriFieldTypeDate, alias: inspection_notice_date_sent, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inspection_notice_date_sent )
• inspection_notice_action ( type: esriFieldTypeString, alias: inspection_notice_action, editable: true, nullable: true, length: 30, defaultValue: null, modelName: inspection_notice_action , Coded Values: [Call: Call] , [Inspection by Others: Inspection by Others] , [Mining: Mining] , ...3 more... )
• dam_name ( type: esriFieldTypeString, alias: dam_name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: dam_name )

Templates:

• Name: Inspections
  Description:
  Prototype:
  inspection_notice_action: null
  dam_name: null
  inspection_notice_date_sent: null
  pre_inspection_comments: null
  initial_inspection_year: null
  insp_freq: null
  mn_nid_guid: null
  inspecting_group: null
  next_insp_year: null
  insp_date: null
  rpt_writer_assi: null
  insp_rpt_comp_date: null
  condition_date: null
  condition_assessment: null
  operationalstatus: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• mn_nid (3) -- Related To: Dam Locations (0)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: Created
• Creator Field: Creator
• Edit Date Field: Edited
• Editor Field: Editor

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata