Name: ITS Power Service Inspection

Display Field: PS_POLE_CONDITION

Type: Table

Geometry Type: N/A

Description:

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• PS_POLE_CONDITION ( type: esriFieldTypeString, alias: Power Service and Pole Condition (CMS 625.15), editable: true, nullable: true, length: 9, defaultValue: null, modelName: PS_POLE_CONDITION , Coded Values: [Meets: Meets] , [Deficient: Deficient] , [N/A: N/A] )
• LOCKS_ON_DISCONNECT ( type: esriFieldTypeString, alias: 2 Pad Locks on the Disconnect (CMS 625.15.B), editable: true, nullable: true, length: 9, defaultValue: null, modelName: LOCKS_ON_DISCONNECT , Coded Values: [Meets: Meets] , [Deficient: Deficient] , [N/A: N/A] )
• SEALED_CONNECTIONS ( type: esriFieldTypeString, alias: Sealed Connections (632.24), editable: true, nullable: true, length: 9, defaultValue: null, modelName: SEALED_CONNECTIONS , Coded Values: [Meets: Meets] , [Deficient: Deficient] , [N/A: N/A] )
• LUGS_TERMINATION_DEOX ( type: esriFieldTypeString, alias: Lugs/Terminations Deox, editable: true, nullable: true, length: 9, defaultValue: null, modelName: LUGS_TERMINATION_DEOX , Coded Values: [Meets: Meets] , [Deficient: Deficient] , [N/A: N/A] )
• DISCONNECT_SWITCH_RUST ( type: esriFieldTypeString, alias: Disconnect Switch Rust/Corrosion, editable: true, nullable: true, length: 9, defaultValue: null, modelName: DISCONNECT_SWITCH_RUST , Coded Values: [Meets: Meets] , [Deficient: Deficient] , [N/A: N/A] )
• DIS_SWITCH_DUCT_SEAL ( type: esriFieldTypeString, alias: Disconnect Switch Duct Seal, editable: true, nullable: true, length: 9, defaultValue: null, modelName: DIS_SWITCH_DUCT_SEAL , Coded Values: [Meets: Meets] , [Deficient: Deficient] , [N/A: N/A] )
• GROUND_BELOW_25_OHMS ( type: esriFieldTypeString, alias: Grounding (25 Ohms or less is Passable; CMS 625.16, ITS-50.10), editable: true, nullable: true, length: 9, defaultValue: null, modelName: GROUND_BELOW_25_OHMS , Coded Values: [Meets: Meets] , [Deficient: Deficient] , [N/A: N/A] )
• INSTALL_STD_CONSTRUC ( type: esriFieldTypeString, alias: Installed per Standard Construction Drawing (ITS-15.10 or -15.11), editable: true, nullable: true, length: 9, defaultValue: null, modelName: INSTALL_STD_CONSTRUC , Coded Values: [Meets: Meets] , [Deficient: Deficient] , [N/A: N/A] )
• REGION_STANDARD_SETUP ( type: esriFieldTypeString, alias: Region Standard Setup, editable: true, nullable: true, length: 1, defaultValue: null, modelName: REGION_STANDARD_SETUP , Coded Values: [Y: Yes] , [N: No] )
• METER_BASE_CONDITION ( type: esriFieldTypeString, alias: Meter Base Condition, editable: true, nullable: true, length: 15, defaultValue: null, modelName: METER_BASE_CONDITION , Coded Values: [Needs Replaced: Needs Replaced] , [Minor Issues: Minor Issues] , [Good Condition: Good Condition] )
• DISCONNECT_CONDITION ( type: esriFieldTypeString, alias: Disconnect Condition, editable: true, nullable: true, length: 15, defaultValue: null, modelName: DISCONNECT_CONDITION , Coded Values: [Needs Replaced: Needs Replaced] , [Minor Issues: Minor Issues] , [Good Condition: Good Condition] )
• MYERS_HUB_CONDITION ( type: esriFieldTypeString, alias: Myers Hub Condition, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MYERS_HUB_CONDITION , Coded Values: [Needs Replaced: Needs Replaced] , [Minor Issues: Minor Issues] , [Good Condition: Good Condition] )
• OVERAL_CONDITION_SCORE ( type: esriFieldTypeInteger, alias: Overall Condition & Score, editable: true, nullable: true, defaultValue: null, modelName: OVERAL_CONDITION_SCORE , Coded Values: [1: 1 - Good (Requires no planned feasible action)] , [2: 2 - Fair (Requires repair and/or increase inspection)] , [3: 3 - Poor (Requires repair or replacement of element within next year)] , ...1 more... )
• OVERAL_COND_SCR_COM ( type: esriFieldTypeString, alias: Overall Condition & Score Comments, editable: true, nullable: true, length: 2500, defaultValue: null, modelName: OVERAL_COND_SCR_COM )
• INSPECTOR ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 255, defaultValue: null, modelName: INSPECTOR )
• INSPECTION_DATE ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSPECTION_DATE )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: REL_GLOBALID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• sys_updated_date ( type: esriFieldTypeDate, alias: sys_updated_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: sys_updated_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: ITS Power Service Inspection
  Description:
  Prototype:
  sys_updated_date: null
  PS_POLE_CONDITION: null
  LOCKS_ON_DISCONNECT: null
  SEALED_CONNECTIONS: null
  LUGS_TERMINATION_DEOX: null
  DISCONNECT_SWITCH_RUST: null
  DIS_SWITCH_DUCT_SEAL: null
  GROUND_BELOW_25_OHMS: null
  INSTALL_STD_CONSTRUC: null
  REGION_STANDARD_SETUP: null
  METER_BASE_CONDITION: null
  DISCONNECT_CONDITION: null
  MYERS_HUB_CONDITION: null
  OVERAL_CONDITION_SCORE: null
  OVERAL_COND_SCR_COM: null
  INSPECTOR: null
  INSPECTION_DATE: null
  REL_GLOBALID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• COLLECTOR.ITS_POWER_SERVICE_INVENTORY (6) -- Related To: Power Service (9)

Capabilities: Query,Sync,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

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