Name: ITS Device SI Element Inventory - Viewer

Display Field: ELEMEN_FILE_NUMBER

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:

• ELEMEN_FILE_NUMBER ( type: esriFieldTypeString, alias: Element File Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ELEMEN_FILE_NUMBER )
• SIG_INTERSECT_ELEMENT ( type: esriFieldTypeString, alias: Signalized Intersection Element, editable: true, nullable: true, length: 22, defaultValue: null, modelName: SIG_INTERSECT_ELEMENT , Coded Values: [Support: Support] , [Detection: Detection] , [Vehicle Signal Head: Vehicle Signal Head] , ...1 more... )
• INSTALLATION_DATE ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLATION_DATE )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 1, defaultValue: A, modelName: STATUS , Coded Values: [A: Active] , [R: Retired] , [P: Proposed] , ...1 more... )
• SUPPORT_STYLE ( type: esriFieldTypeString, alias: Support Style, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SUPPORT_STYLE , Coded Values: [Mast Arm: Mast Arm] , [Strain Pole: Strain Pole] , [Wood Pole: Wood Pole] , ...1 more... )
• SUPPORT_TYPE ( type: esriFieldTypeString, alias: Support Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SUPPORT_TYPE , Coded Values: [TC-81.21: TC-81.21] , [TC-81.22: TC-81.22 (post July 2020)] , [TC-12.30: TC-12.30] , ...3 more... )
• MAKE_MODEL_NUMBER ( type: esriFieldTypeString, alias: Make/Model Number, editable: true, nullable: true, length: 225, defaultValue: null, modelName: MAKE_MODEL_NUMBER )
• DESIGN_NUMBER ( type: esriFieldTypeString, alias: Design Number, editable: true, nullable: true, length: 7, defaultValue: null, modelName: DESIGN_NUMBER , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...12 more... )
• TWO_ARM_SUPPORT ( type: esriFieldTypeString, alias: Two Arm Support, editable: true, nullable: true, length: 1, defaultValue: null, modelName: TWO_ARM_SUPPORT , Coded Values: [Y: Yes] , [N: No] )
• MAST_ARM__A_DESIGN_NUM ( type: esriFieldTypeString, alias: Mast Arm A Design Number, editable: true, nullable: true, length: 7, defaultValue: null, modelName: MAST_ARM__A_DESIGN_NUM , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...12 more... )
• MAST_ARM__B_DESIGN_NUM ( type: esriFieldTypeString, alias: Mast Arm B Design Number, editable: true, nullable: true, length: 7, defaultValue: null, modelName: MAST_ARM__B_DESIGN_NUM , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...12 more... )
• SPANWIRE_CONFIGURATION ( type: esriFieldTypeString, alias: Span Wire Configuration, editable: true, nullable: true, length: 15, defaultValue: null, modelName: SPANWIRE_CONFIGURATION , Coded Values: [Box with Tails: Box with Tails] , [Simple: Simple] , [Box: Box] , ...4 more... )
• WOOD_POLE_HEIGHT_FT ( type: esriFieldTypeInteger, alias: Wood Pole Height (ft), editable: true, nullable: true, defaultValue: null, modelName: WOOD_POLE_HEIGHT_FT , Range: [0, 99] )
• WOOD_POLE_CLASS ( type: esriFieldTypeInteger, alias: Wood Pole Class, editable: true, nullable: true, defaultValue: null, modelName: WOOD_POLE_CLASS , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• BANDED_ARM_BRACKET ( type: esriFieldTypeString, alias: Banded Arm Bracket, editable: true, nullable: true, length: 1, defaultValue: null, modelName: BANDED_ARM_BRACKET , Coded Values: [Y: Yes] , [N: No] )
• RADAR_ATTACHED ( type: esriFieldTypeString, alias: Radar Attached to Bracket Arm, editable: true, nullable: true, length: 1, defaultValue: null, modelName: RADAR_ATTACHED , Coded Values: [Y: Yes] , [N: No] )
• HWY_LIGHTING_ATTACHED ( type: esriFieldTypeString, alias: Highway Lighting Attached to Bracket Arm, editable: true, nullable: true, length: 1, defaultValue: null, modelName: HWY_LIGHTING_ATTACHED , Coded Values: [Y: Yes] , [N: No] )
• OTHER_ATTACHED ( type: esriFieldTypeString, alias: Other Attached to Bracket Arm, editable: true, nullable: true, length: 1, defaultValue: null, modelName: OTHER_ATTACHED , Coded Values: [Y: Yes] , [N: No] )
• APPROACH_DIRECTION ( type: esriFieldTypeString, alias: Approach Direction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: APPROACH_DIRECTION , Coded Values: [NB: NB] , [EB: EB] , [SB: SB] , ...1 more... )
• DETECTION_TYPE ( type: esriFieldTypeString, alias: Detection Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: DETECTION_TYPE , Coded Values: [Loops: Loops] , [Radar: Radar] , [Video: Video] , ...2 more... )
• DETECTION ( type: esriFieldTypeString, alias: Detection, editable: true, nullable: true, length: 12, defaultValue: null, modelName: DETECTION , Coded Values: [Stop Line: Stop Line] , [Dilemma Zone: Dilemma Zone] )
• RADAR_TYPE ( type: esriFieldTypeString, alias: Radar Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RADAR_TYPE , Coded Values: [Modular: Modular] , [650: 650] , [656: 656] )
• CLICK_301_INSTALLED ( type: esriFieldTypeString, alias: Click 301 Installed, editable: true, nullable: true, length: 1, defaultValue: null, modelName: CLICK_301_INSTALLED , Coded Values: [Y: Yes] , [N: No] )
• VSH_SECTION ( type: esriFieldTypeString, alias: VSH Section (left to right), editable: true, nullable: true, length: 6, defaultValue: null, modelName: VSH_SECTION , Coded Values: [1-sect: 1-sect] , [2-sect: 2-sect] , [3-sect: 3-sect] , ...2 more... )
• MOVEMENT_TYPE_THRU ( type: esriFieldTypeString, alias: Movement Type - Thru, editable: true, nullable: true, length: 1, defaultValue: N, modelName: MOVEMENT_TYPE_THRU , Coded Values: [Y: Yes] , [N: No] )
• MOVEMENT_TYPE_RT ( type: esriFieldTypeString, alias: Movement Type - RT, editable: true, nullable: true, length: 1, defaultValue: N, modelName: MOVEMENT_TYPE_RT , Coded Values: [Y: Yes] , [N: No] )
• MOVEMENT_TYPE_LT ( type: esriFieldTypeString, alias: Movement Type - LT, editable: true, nullable: true, length: 1, defaultValue: N, modelName: MOVEMENT_TYPE_LT , Coded Values: [Y: Yes] , [N: No] )
• MT_BI_MODAL_YELLOW_ARW ( type: esriFieldTypeString, alias: Movement Type - Bi-modal Flashing Yellow Arrow, editable: true, nullable: true, length: 1, defaultValue: N, modelName: MT_BI_MODAL_YELLOW_ARW , Coded Values: [Y: Yes] , [N: No] )
• MT_FLASHING_YELLOW_ARW ( type: esriFieldTypeString, alias: Movement Type - Flashing Yellow Arrow (FYA), editable: true, nullable: true, length: 1, defaultValue: N, modelName: MT_FLASHING_YELLOW_ARW , Coded Values: [Y: Yes] , [N: No] )
• MT_PERM_ONLY_FYA ( type: esriFieldTypeString, alias: Movement Type - Permissive Only FYA, editable: true, nullable: true, length: 1, defaultValue: N, modelName: MT_PERM_ONLY_FYA , Coded Values: [Y: Yes] , [N: No] )
• MT_PROGRAMMABLE ( type: esriFieldTypeString, alias: Movement Type - Programmable, editable: true, nullable: true, length: 1, defaultValue: N, modelName: MT_PROGRAMMABLE , Coded Values: [Y: Yes] , [N: No] )
• MT_U_TURN ( type: esriFieldTypeString, alias: Movement Type - U-turn, editable: true, nullable: true, length: 1, defaultValue: N, modelName: MT_U_TURN , Coded Values: [Y: Yes] , [N: No] )
• MT_BICYCLE_HEAD ( type: esriFieldTypeString, alias: Movement Type - Bicycle Head, editable: true, nullable: true, length: 1, defaultValue: N, modelName: MT_BICYCLE_HEAD , Coded Values: [Y: Yes] , [N: No] )
• PH_VSH_LABEL ( type: esriFieldTypeString, alias: Ph/VSH Label, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PH_VSH_LABEL , Coded Values: [1A: 1A] , [1B: 1B] , [1C: 1C] , ...53 more... )
• HEAD_TYPE ( type: esriFieldTypeString, alias: Head Type, editable: true, nullable: true, length: 15, defaultValue: Polycarbonate, modelName: HEAD_TYPE , Coded Values: [Polycarbonate: Polycarbonate] , [Aluminum: Aluminum] )
• VISOR_TYPE ( type: esriFieldTypeString, alias: Visor Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: VISOR_TYPE , Coded Values: [Cutaway: Cutaway] , [Tunnel: Tunnel] , [Other: Other] )
• SIDE__MOUNTED_SIG_HEAD ( type: esriFieldTypeString, alias: Side Mounted Signal Head, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SIDE__MOUNTED_SIG_HEAD , Coded Values: [Y: Yes] , [N: No] )
• LEDS ( type: esriFieldTypeString, alias: LEDs, editable: true, nullable: true, length: 1, defaultValue: Y, modelName: LEDS , Coded Values: [Y: Yes] , [N: No] )
• LED_INSTALLATION_DATE ( type: esriFieldTypeDate, alias: LED Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LED_INSTALLATION_DATE )
• HEATED_LED_INSTALL_DT ( type: esriFieldTypeDate, alias: Heated LED Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: HEATED_LED_INSTALL_DT )
• SNOW_SHIELD ( type: esriFieldTypeString, alias: Snow Shield, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SNOW_SHIELD , Coded Values: [Y: Yes] , [N: No] )
• ASSOCIATED_PHASE ( type: esriFieldTypeString, alias: Associated Phase, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ASSOCIATED_PHASE , Coded Values: [1P: 1P] , [2P: 2P] , [3P: 3P] , ...9 more... )
• PEDESTRIAN_PUSHBUTTONS ( type: esriFieldTypeString, alias: Pedestrian Pushbuttons, editable: true, nullable: true, length: 3, defaultValue: null, modelName: PEDESTRIAN_PUSHBUTTONS , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• ACCESS_PED_PUSHBUTTON ( type: esriFieldTypeString, alias: Accessible Ped Pushbutton, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ACCESS_PED_PUSHBUTTON , Coded Values: [Y: Yes] , [N: No] )
• INVENTORY_COMMENTS ( type: esriFieldTypeString, alias: Inventory Comments, editable: true, nullable: true, length: 2500, defaultValue: null, modelName: INVENTORY_COMMENTS )
• 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 Device SI Element Inventory - Viewer
  Description:
  Prototype:
  sys_updated_date: null
  ELEMEN_FILE_NUMBER: null
  SIG_INTERSECT_ELEMENT: null
  INSTALLATION_DATE: null
  STATUS: A
  SUPPORT_STYLE: null
  SUPPORT_TYPE: null
  MAKE_MODEL_NUMBER: null
  DESIGN_NUMBER: null
  TWO_ARM_SUPPORT: null
  MAST_ARM__A_DESIGN_NUM: null
  MAST_ARM__B_DESIGN_NUM: null
  SPANWIRE_CONFIGURATION: null
  WOOD_POLE_HEIGHT_FT: null
  WOOD_POLE_CLASS: null
  BANDED_ARM_BRACKET: null
  RADAR_ATTACHED: null
  HWY_LIGHTING_ATTACHED: null
  OTHER_ATTACHED: null
  APPROACH_DIRECTION: null
  DETECTION_TYPE: null
  DETECTION: null
  RADAR_TYPE: null
  CLICK_301_INSTALLED: null
  VSH_SECTION: null
  MOVEMENT_TYPE_THRU: N
  MOVEMENT_TYPE_RT: N
  MOVEMENT_TYPE_LT: N
  MT_BI_MODAL_YELLOW_ARW: N
  MT_FLASHING_YELLOW_ARW: N
  MT_PERM_ONLY_FYA: N
  MT_PROGRAMMABLE: N
  MT_U_TURN: N
  MT_BICYCLE_HEAD: N
  PH_VSH_LABEL: null
  HEAD_TYPE: Polycarbonate
  VISOR_TYPE: null
  SIDE__MOUNTED_SIG_HEAD: null
  LEDS: Y
  LED_INSTALLATION_DATE: null
  HEATED_LED_INSTALL_DT: null
  SNOW_SHIELD: null
  ASSOCIATED_PHASE: null
  PEDESTRIAN_PUSHBUTTONS: null
  ACCESS_PED_PUSHBUTTON: null
  INVENTORY_COMMENTS: null
  REL_GLOBALID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• COLLECTOR.ITS_DEVICE_INVENTORY (2) -- Related To: Device Inventory (Active) - Viewer (1)
• COLLECTOR.ITS_DEVICE_INVENTORY (12) -- Related To: Device Inventory (Non-Active) - Viewer (5)
• COLLECTOR.ITS_DEVICE_INVENTORY (19) -- Related To: Device Inventory (Non-State) - Viewer (9)
• COLLECTOR.ITS_DEVICE_INVENTORY (25) -- Related To: ITS_DEVICE_INVENTORY_ALL (16)

Capabilities: Query,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