Name: ITS Device Inspection - Viewer

Display Field: DEVICE_TYPE

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

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: false
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: true
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: N/A

Fields:

• DEVICE_TYPE ( type: esriFieldTypeString, alias: Device Type, length: 25 )
• SITE_CLEARING_GRUBBING_1 ( type: esriFieldTypeString, alias: Insp (1) - Site Needs Clearing and Grubbing (CMS 201.03), length: 9 )
• DEVICE_CONDITION_2 ( type: esriFieldTypeString, alias: Insp (2) - Device Condition (and pole if applicable), length: 9 )
• DUCT_SEAL_CONDUIT_ENTR_3 ( type: esriFieldTypeString, alias: Insp (3) - Duct Seal Installed on Conduit Entrances (CMS 625.12, 632.08, 632.09), length: 9 )
• T_BASE_CONDITION_4 ( type: esriFieldTypeString, alias: Insp (4) - T-base Condition, length: 9 )
• UNOBSTRUCTED_VIEW_5 ( type: esriFieldTypeString, alias: Insp (5) - Camera's Field of View Unobstructed (SS 809.05), length: 9 )
• VEHICLE_MOWER_DAMAGE_6 ( type: esriFieldTypeString, alias: Insp (6) - Vehicle/Mower Damage, length: 9 )
• SLOPE_WASHOUTS_7 ( type: esriFieldTypeString, alias: Insp (7) - Slope Washouts, length: 9 )
• QUICK_LINK_PRESENT_8 ( type: esriFieldTypeString, alias: Insp (8) - Quick-link Present Holding Lowering Cable Inside the Pole Hand-hole (ITS-12.10), length: 9 )
• SET_SCREW_PRESENT_9 ( type: esriFieldTypeString, alias: Insp (9) - Set-Screw Present in Pole Hand-hole where the Lowering Unit Wench Connects (SS 809.06), length: 9 )
• LOW_UNIT_CABLE_INSTALL_10 ( type: esriFieldTypeString, alias: Insp (10) - Lowering Unit Cable Tie-Knot Installed Correctly (SS 809.06), length: 9 )
• CAM_LOWER_UNIT_LATCH_11 ( type: esriFieldTypeString, alias: Insp (11) - Camera Lowering Unit Latch and Unlatch Fine (SS 809 & 909), length: 9 )
• POLE_CPLING_HOLES_PLUG_12 ( type: esriFieldTypeString, alias: Insp (12) - Pole Coupling Holes Plugged (with threaded PVC) if not used (SS 809.06), length: 9 )
• HEX_SCREWS_PRESENT_13 ( type: esriFieldTypeString, alias: Insp (13) - Pole Hand-hole Cover have hex-screws Present and Functional (SS 809.06), length: 9 )
• DEVICE_WORK_PAD_BASE_14 ( type: esriFieldTypeString, alias: Insp (14) - Work Pad at Base of Device (SS 809, ITS-10.11, ITS-11.11), length: 9 )
• WARRANTY_STICKERS_15 ( type: esriFieldTypeString, alias: Insp (15) - Warranty Stickers on Device and Field Box if CCTV, length: 9 )
• DMS_ENCLOSUR_DUCT_SEAL_16 ( type: esriFieldTypeString, alias: Insp (16) - Duct Seal on Conduit Entrances to the DMS Enclosure (CMS 625.12), length: 9 )
• UNUSED_HOLES_PLUGGED_17 ( type: esriFieldTypeString, alias: Insp (17) - All Unused Holes Plugged (CMS 625.12, 732.11, TC-81.11, TC-81.22), length: 9 )
• RODENT_PREVENT_SCREEN_18 ( type: esriFieldTypeString, alias: Insp (18) - Rodent Prevention Screening at Base of Structure (ITS-30.13), length: 9 )
• GENERAL_CHECKS_COMMENT_19 ( type: esriFieldTypeString, alias: Insp (19) - General Checks Comments, length: 2500 )
• CAM_LOWERING_UNIT_FUNC_20 ( type: esriFieldTypeString, alias: Insp (20) - Camera Lowering Unit Conditon and Fully Functional (SS 809 & 909), length: 9 )
• CAMERA_FUNCTIONAL_21 ( type: esriFieldTypeString, alias: Insp (21) - Camera Function Correctly (SS 809.05), length: 9 )
• LOCAL_CAMERA_CTRL_FUNC_22 ( type: esriFieldTypeString, alias: Insp (22) - Local Camera Control Box Function Correctly (SS 809.05), length: 9 )
• SIGN_PIXELS_WORK_23 ( type: esriFieldTypeString, alias: Insp (23) - Do All the Pixels on the Sign Work (SS 809, 909), length: 9 )
• LIVE_AUDIO_BROADCAS_AM_24 ( type: esriFieldTypeString, alias: Insp (24) - Can You Clearly Hear the Live Audio Broadcast on the AM Radio, length: 9 )
• BUILD_AS_DESIGNED_SCD_25 ( type: esriFieldTypeString, alias: Insp (25) - Built as Designed in the Standard Construction Drawing, length: 9 )
• POLE_CONDUIT_CONDITION_26 ( type: esriFieldTypeString, alias: Insp (26) - Conduit on Pole Condition, length: 9 )
• CONTROLLER_RADAR_COMMS_27 ( type: esriFieldTypeString, alias: Insp (27) - Controller and Radar Have Communications, length: 9 )
• SIGN_LEDS_28 ( type: esriFieldTypeString, alias: Insp (28) - All LEDs on the Sign Work, length: 9 )
• LOOP_DETECTOR_INPUTS_29 ( type: esriFieldTypeString, alias: Insp (29) - Loop Detectors Picking Up the Correct Inputs, length: 9 )
• DC_ISOLATOR_INPUTS_30 ( type: esriFieldTypeString, alias: Insp (30) - DC Isolators Showing Inputs from the Radar Unit, length: 9 )
• RADAR_DETECT_ALL_LANES_31 ( type: esriFieldTypeString, alias: Insp (31) - Radar Detecting All Lanes of Traffic, length: 9 )
• FLASHING_SIGN_BEACON_32 ( type: esriFieldTypeString, alias: Insp (32) - "Ramp Metered When Flashing" Sign Work and Beacons Flash Simultaneously, length: 9 )
• SIGNAL_HEADS_WORK_33 ( type: esriFieldTypeString, alias: Insp (33) - Signal Heads Work, length: 9 )
• SIGNAL_HEADS_WORK_LANE_34 ( type: esriFieldTypeString, alias: Insp (34) - Two Lane Ramp Meters - Signal Heads Work with Their Respective Lanes, length: 9 )
• SIGNALS_REST_IN_RED_35 ( type: esriFieldTypeString, alias: Insp (35) - Signals Rest in Red (When Metering), length: 9 )
• DEMAND_LOOP_TRIG_GREEN_36 ( type: esriFieldTypeString, alias: Insp (36) - Demand Loops Trigger a Green Indication (When Metering), length: 9 )
• PASSAGE_LOOP_TRIG_RED_37 ( type: esriFieldTypeString, alias: Insp (37) - Passage Loops Trigger a Red Indication (When Metering), length: 9 )
• OPS_CHECKS_COMMENTS_38 ( type: esriFieldTypeString, alias: Insp (38) - Operational Checks Comments, length: 2500 )
• SUPPORT_HARDWARE_39 ( type: esriFieldTypeString, alias: Insp (39) - All the Hardware on the Supports, length: 9 )
• PED_SCRW_LOCK_NUT_TGHT_40 ( type: esriFieldTypeString, alias: Insp (40) - Set Screws and Locking Nuts Tight (Pedestal), length: 9 )
• PED_SUPPORT_CONDITION_41 ( type: esriFieldTypeString, alias: Insp (41) - Pedestal Support Condition, length: 9 )
• PED_SUPPORT_COMMENTS_42 ( type: esriFieldTypeString, alias: Insp (42) - Pedestal Support Comments, length: 2500 )
• CONCRETE_CRACKS_43 ( type: esriFieldTypeInteger, alias: Insp (43) - Foundation Concrete Cracks )
• CONCRETE_SPALLING_44 ( type: esriFieldTypeInteger, alias: Insp (44) - Foundation Concrete Spalling )
• BURIED_COVERED_45 ( type: esriFieldTypeInteger, alias: Insp (45) - Foundation Buried / Covered )
• SOIL_EROSION_46 ( type: esriFieldTypeInteger, alias: Insp (46) - Foundation Soil Erosion )
• FOUNDATION_OTHER_47 ( type: esriFieldTypeInteger, alias: Insp (47) - Foundation Other )
• ANCHOR_BOLTS_CORROSION_48 ( type: esriFieldTypeInteger, alias: Insp (48) - Anchor Bolts Corrosion )
• ANCHOR_BOLTS_CRACKS_49 ( type: esriFieldTypeInteger, alias: Insp (49) - Anchor Bolts Cracks )
• NUTS_CORROSION_50 ( type: esriFieldTypeInteger, alias: Insp (50) - Nuts Corrosion )
• NUTS_CRACKS_51 ( type: esriFieldTypeInteger, alias: Insp (51) - Nuts Cracks )
• NUTS_LOOSE_52 ( type: esriFieldTypeInteger, alias: Insp (52) - Nuts Loose )
• MISSING_WASHERS_53 ( type: esriFieldTypeInteger, alias: Insp (53) - Missing Washers )
• FOUNDATION_COMMENTS_54 ( type: esriFieldTypeString, alias: Insp (54) - Foundation Comments, length: 2500 )
• ENDFRAMEPOLE_CORROS_55 ( type: esriFieldTypeInteger, alias: Insp (55) - End Frame/Pole Corrosion )
• ENDFRAMEPOLE_DAMAGE_56 ( type: esriFieldTypeInteger, alias: Insp (56) - End Frame/Pole Damage )
• ENDFRAMEPOLE_CRACK_57 ( type: esriFieldTypeInteger, alias: Insp (57) - End Frame/Pole Cracking )
• WIRE_ENT_CAP_MISSING_58 ( type: esriFieldTypeInteger, alias: Insp (58) - End Frame/Pole Wire Entrance Cap Missing )
• HANDHOLE_COVER_MISSING_59 ( type: esriFieldTypeInteger, alias: Insp (59) - End Frame/Pole Handhole Covers Missing )
• ENDFRAMEPOLE_CAP_MISS_60 ( type: esriFieldTypeInteger, alias: Insp (60) - End Frame/Pole Cap Missing )
• ENDFRAMEPOLE_BLT_CORRO_61 ( type: esriFieldTypeInteger, alias: Insp (61) - End Frame/Pole Bolt Corrosion )
• ENDFRAMEPOLE_MISS_BOLT_62 ( type: esriFieldTypeInteger, alias: Insp (62) - End Frame/Pole Missing Bolts )
• ENDFRAMEPOLE_WLD_CORRO_63 ( type: esriFieldTypeInteger, alias: Insp (63) - End Frame/Pole Weld Corrosion )
• ENDFRAMEPOLE_WLD_CRACK_64 ( type: esriFieldTypeInteger, alias: Insp (64) - End Frame/Pole Weld Cracking )
• ENDFRAMEPOLE_OTHER_65 ( type: esriFieldTypeInteger, alias: Insp (65) - End Frame/Pole Other )
• ENDFRAMEPOLE_COMMENTS_66 ( type: esriFieldTypeString, alias: Insp (66) - End Frame/Pole Comments, length: 2500 )
• CANTILEVERSPAN_CORROS_67 ( type: esriFieldTypeInteger, alias: Insp (67) - Cantilever/Span Corrosion )
• CANTILEVERSPAN_DAMAGE_68 ( type: esriFieldTypeInteger, alias: Insp (68) - Cantilever/Span Damage )
• CANTILEVERSPAN_CRACK_69 ( type: esriFieldTypeInteger, alias: Insp (69) - Cantilever/Span Cracking )
• CANTILEVERSPAN_FG_CRCK_70 ( type: esriFieldTypeInteger, alias: Insp (70) - Cantilever/Span Flange Cracking )
• CANTILEVERSPAN_BLT_COR_71 ( type: esriFieldTypeInteger, alias: Insp (71) - Cantilever/Span Bolt Corrosion )
• CANTSPAN_MISS_BOLT_72 ( type: esriFieldTypeInteger, alias: Insp (72) - Cantilever/Span Missing Bolts )
• CANTSPAN_WLD_CORROS_73 ( type: esriFieldTypeInteger, alias: Insp (73) - Cantilever/Span Weld Corrosion )
• CANTSPAN_WLD_CRACKING_74 ( type: esriFieldTypeInteger, alias: Insp (74) - Cantilever/Span Weld Cracking )
• CANTSPAN_ENDCAPS_MISS_75 ( type: esriFieldTypeInteger, alias: Insp (75) - Cantilever/Span End Caps Missing )
• CANTILEVERSPAN_OTHER_76 ( type: esriFieldTypeInteger, alias: Insp (76) - Cantilever/Span Other )
• CANTSPAN_COMMENTS_77 ( type: esriFieldTypeString, alias: Insp (77) - Cantilever/Span Comments, length: 2500 )
• CATWALKLADDER_CORROS_78 ( type: esriFieldTypeInteger, alias: Insp (78) - Catwalk/Ladder Corrosion )
• CATWALKLADDER_DAMAGE_79 ( type: esriFieldTypeInteger, alias: Insp (79) - Catwalk/Ladder Damage )
• CATWALKLADDER_CRACK_80 ( type: esriFieldTypeInteger, alias: Insp (80) - Catwalk/Ladder Cracking )
• CATWALKLADDER_BLT_CORR_81 ( type: esriFieldTypeInteger, alias: Insp (81) - Catwalk/Ladder Bolt Corrosion )
• CATWALKLADDER_MIS_BOLT_82 ( type: esriFieldTypeInteger, alias: Insp (82) - Catwalk/Ladder Missing Bolts )
• CATWALKLADDER_WLD_CORR_83 ( type: esriFieldTypeInteger, alias: Insp (83) - Catwalk/Ladder Weld Corrosion )
• CATWALKLADDER_WLD_CRCK_84 ( type: esriFieldTypeInteger, alias: Insp (84) - Catwalk/Ladder Weld Cracks )
• CATWALKLADDER_OTHER_85 ( type: esriFieldTypeInteger, alias: Insp (85) - Catwalk/Ladder Other )
• CATWALKLADDER_COMMENTS_86 ( type: esriFieldTypeString, alias: Insp (86) - Catwalk/Ladder Comments, length: 2500 )
• ATTACHMENT_CORROSION_87 ( type: esriFieldTypeInteger, alias: Insp (87) - Sign Attachment Corrosion )
• ATTACHMENT_DEFOR_88 ( type: esriFieldTypeInteger, alias: Insp (88) - Sign Attachment Deformations )
• ATTACH_MISS_HARDWARE_89 ( type: esriFieldTypeInteger, alias: Insp (89) - Sign Attachment Missing Hardware )
• SIGN_DAMAGE_90 ( type: esriFieldTypeInteger, alias: Insp (90) - Sign Damage )
• LIGHTING_MISS_HARDWARE_91 ( type: esriFieldTypeInteger, alias: Insp (91) - Sign Lighting Missing Hardware )
• OBSTRUCTION_OVERGROWTH_92 ( type: esriFieldTypeInteger, alias: Insp (92) - Sign Obstruction/Overgrowth )
• SIGN_COMMENTS_93 ( type: esriFieldTypeString, alias: Insp (93) - Sign Comments, length: 2500 )
• DMS_SUPPORT_CONDITION_94 ( type: esriFieldTypeInteger, alias: Insp (94) - Overall Support Condition )
• STOP_LINE_LOCATION_95 ( type: esriFieldTypeString, alias: Insp (95) - Stop Line Located Between Demand and Passage Loops, length: 9 )
• SIGN_ON_STOP_LINE_96 ( type: esriFieldTypeString, alias: Insp (96) - The "Stop Here on Red" Sign Placed on Stop Line on Both Sides, length: 9 )
• SIGN_ON_BOTH_SIDES_RMP_97 ( type: esriFieldTypeString, alias: Insp (97) - The "One Vehicle per Green" Sign Installed on Both Sides of the Ramp, length: 9 )
• PAV_MARK_SIGN_COMMENTS_98 ( type: esriFieldTypeString, alias: Insp (98) - Pavement Marking and Signing Comments, length: 2500 )
• SIGNAL_HEADS_ALIGNED_99 ( type: esriFieldTypeString, alias: Insp (99) - Signal Heads Aligned Properly, length: 9 )
• SCREWS_LOCK_NUTS_TIGHT_100 ( type: esriFieldTypeString, alias: Insp (100) - Set Screws and Locking Nuts Tight on Signal Head, length: 9 )
• SH_UNUSED_OPENING_PLUG_101 ( type: esriFieldTypeString, alias: Insp (101) - Unused Openings Plugged/Capped, length: 9 )
• ALIGNMENT_HEAD_ORIENT_102 ( type: esriFieldTypeString, alias: Insp (102) - Alignment & Head Orientation (CMS 632.06 & TC-85.20), length: 14 )
• CLEARANCE_HEIGHT_103 ( type: esriFieldTypeString, alias: Insp (103) - Clearance Height (TC-81.22), length: 14 )
• CLEARANCE_HEIGHT_FT_104 ( type: esriFieldTypeString, alias: Insp (104) - Clearance Height (ft), length: 28 )
• NORTH_SPAN_HEIGHT_235 ( type: esriFieldTypeString, alias: Insp (235) - North Span Height (ft), length: 28 )
• SOUTH_SPAN_HEIGHT_236 ( type: esriFieldTypeString, alias: Insp (236) - South Span Height (ft), length: 28 )
• EAST_SPAN_HEIGHT_237 ( type: esriFieldTypeString, alias: Insp (237) - East Span Height (ft), length: 28 )
• WEST_SPAN_HEIGHT_238 ( type: esriFieldTypeString, alias: Insp (238) - West Span Height (ft), length: 28 )
• LED_CONDITION_105 ( type: esriFieldTypeString, alias: Insp (105) - LED Condition, length: 14 )
• LEDS_AIMED_PROPERLY_106 ( type: esriFieldTypeString, alias: Insp (106) - LEDs Aimed Properly, length: 14 )
• SIGNAL_HEAD_CONDITION_107 ( type: esriFieldTypeString, alias: Insp (107) - Signal Head Condition, length: 14 )
• VISOR_CONDITION_108 ( type: esriFieldTypeString, alias: Insp (108) - Visor Condition, length: 14 )
• BACKPLATE_CONDITION_109 ( type: esriFieldTypeString, alias: Insp (109) - Backplate Condition, length: 14 )
• CABLE_CONDITION_110 ( type: esriFieldTypeString, alias: Insp (110) - Signal/Radar Cable Condition, length: 14 )
• SIGN_CONDITION_111 ( type: esriFieldTypeString, alias: Insp (111) - Blank Out / Signal warning / PTSWF Sign Condition, length: 14 )
• SIGNAL_HEADS_COMMENTS_112 ( type: esriFieldTypeString, alias: Insp (112) - Traffic Signal Heads Comments, length: 2500 )
• MESSENG_WIRE_CONDITION_113 ( type: esriFieldTypeString, alias: Insp (113) - Messenger Wire Condition, length: 14 )
• GUY_GRIPS_CONDITION_114 ( type: esriFieldTypeString, alias: Insp (114) - Guy Grips Condition (CMS 632.21), length: 14 )
• BOLT_CLAMPS_CONDITION_115 ( type: esriFieldTypeString, alias: Insp (115) - 3-bolt Clamps Condition (TC-84.20), length: 14 )
• POLE_CLAMP_BOLTS_TIGHT_116 ( type: esriFieldTypeString, alias: Insp (116) - Pole Clamp Bolts Tight (TC-84.20), length: 14 )
• WIRE_ENT_PIN_CONDITION_117 ( type: esriFieldTypeString, alias: Insp (117) - Wire Enterance and Pin Condition (TC-85.20), length: 14 )
• SPANWIRE_SGN_CONDITION_118 ( type: esriFieldTypeString, alias: Insp (118) - Span Wire Signing Condition, length: 14 )
• POLE_CLAMP_PIN_COND_119 ( type: esriFieldTypeString, alias: Insp (119) - Pole Clamp Assembly and Clevis Pin Condition (TC-84.20), length: 14 )
• LASHING_ROD_CONDITION_120 ( type: esriFieldTypeString, alias: Insp (120) - Lashing Rod Condition, length: 14 )
• SIGNAL_CABLE_CONDITION_121 ( type: esriFieldTypeString, alias: Insp (121) - Signal Cable Condition, length: 14 )
• S_HOOK_CONDITION_122 ( type: esriFieldTypeString, alias: Insp (122) - S-hook Condition, length: 14 )
• BOT_SIGNAL_CLAMP_COND_123 ( type: esriFieldTypeString, alias: Insp (123) - Bottom Signal Clamp Condition (TC-85.21), length: 14 )
• S_HOOK_TURNBUCKLE_POLE_124 ( type: esriFieldTypeString, alias: Insp (124) - Turnbuckle on Pole Side of S-Hook (TC-85.21), length: 14 )
• SH_RIGID_MOUNT_COND_125 ( type: esriFieldTypeString, alias: Insp (125) - Signal Head Rigid Mount Condition, length: 14 )
• DRILLED_HOLES_GROMMETS_126 ( type: esriFieldTypeString, alias: Insp (126) - Field Drilled Holes Have Grommets (TC-85.10), length: 14 )
• DAMPER_CONDITION_127 ( type: esriFieldTypeString, alias: Insp (127) - Damper Condition, length: 14 )
• OH_SIGNAL_SPT_COMMENTS_128 ( type: esriFieldTypeString, alias: Insp (128) - Overhead Signal Support System Comments, length: 2500 )
• INTERSECTION_DOCS_129 ( type: esriFieldTypeString, alias: Insp (129) - Intersection Documentation, length: 21 )
• VEHICLE_DETECTION_OPS_130 ( type: esriFieldTypeString, alias: Insp (130) - Vehicle Detection Operational, length: 21 )
• PED_DETECTION_OPS_131 ( type: esriFieldTypeString, alias: Insp (131) - Pedestrian Detection Operational, length: 21 )
• LAST_MONITOR_TEST_DATE_132 ( type: esriFieldTypeDate, alias: Insp (132) - Conflict Monitor or MMU Last Tested Date, length: 8 )
• CABINET_SEALED_FOUND_133 ( type: esriFieldTypeString, alias: Insp (133) - Cabinet Sealed to Foundation (TC-83.20 & CMS 633.08), length: 14 )
• LOCK_CONDITION_134 ( type: esriFieldTypeString, alias: Insp (134) - Lock Condition, length: 14 )
• FILTER_REPLACED_135 ( type: esriFieldTypeString, alias: Insp (135) - Filter Replaced (CMS 733.03), length: 14 )
• GFCI_RECEPTACLE_TESTED_136 ( type: esriFieldTypeString, alias: Insp (136) - GFCI Receptacle Tested (CMS 733.03), length: 14 )
• WIRE_TERMINATIONS_TGHT_137 ( type: esriFieldTypeString, alias: Insp (137) - Wire Terminations Tight (CMS 633.08), length: 14 )
• PREPARE_STOP_FLASHING_138 ( type: esriFieldTypeString, alias: Insp (138) - Prepare to Stop When Flashing, length: 14 )
• LOAD_SWITCH_INDICATORS_139 ( type: esriFieldTypeString, alias: Insp (139) - Load Switch Indicators Working, length: 14 )
• PREEMPTION_WORKING_140 ( type: esriFieldTypeString, alias: Insp (140) - Preemption Working, length: 14 )
• CABINET_EARTH_GROUND_141 ( type: esriFieldTypeString, alias: Insp (141) - Cabinet Earth Ground (10 Ohms or less is Passable; CMS 625.16), length: 14 )
• CABINET_GROUND_OHMS_142 ( type: esriFieldTypeDouble, alias: Insp (142) - Cabinet Earth Ground Ohms )
• LIGHTNING_ARRESTERS_143 ( type: esriFieldTypeString, alias: Insp (143) - Lightning Arresters, length: 14 )
• CABINET_CONDUIT_SEALED_144 ( type: esriFieldTypeString, alias: Insp (144) - Cabinet Conduit Sealed (CMS 625.12), length: 14 )
• CABINET_FAN_145 ( type: esriFieldTypeString, alias: Insp (145) - Cabinet Fan, length: 14 )
• CABINET_THERMOSTAT_146 ( type: esriFieldTypeString, alias: Insp (146) - Cabinet Thermostat, length: 14 )
• CABINET_LIGHTING_147 ( type: esriFieldTypeString, alias: Insp (147) - Cabinet Lighting, length: 14 )
• CABINET_CLEAN_148 ( type: esriFieldTypeString, alias: Insp (148) - Cabinet Clean / Free of Debris / Excrement, length: 14 )
• HINGES_LOCK_LUBRICATED_149 ( type: esriFieldTypeString, alias: Insp (149) - Hinges & Locks Lubricated, length: 14 )
• SIGNAL_OPERATING_150 ( type: esriFieldTypeString, alias: Insp (150) - Signal Operating Properly, length: 14 )
• BACKUP_CONTROLLER_DATA_151 ( type: esriFieldTypeString, alias: Insp (151) - Backup Controller Data to Key/USB/SD Card, length: 1 )
• UPLOAD_CONTROLLER_DATA_152 ( type: esriFieldTypeString, alias: Insp (152) - Upload Controller Data to Centracs, length: 1 )
• CNTRLR_CABNET_COMMENTS_153 ( type: esriFieldTypeString, alias: Insp (153) - Controller and Cabinet Comments, length: 2500 )
• SUPPORT_ANCH_BLT_COND_154 ( type: esriFieldTypeString, alias: Insp (154) - Support Anchor Bolts Condition, length: 14 )
• SUPPORT_CONDITION_155 ( type: esriFieldTypeString, alias: Insp (155) - Support Condition, length: 14 )
• SUPPORT_RUSTING_156 ( type: esriFieldTypeString, alias: Insp (156) - Support Rusting, length: 14 )
• SUPPORT_HANDHOLE_157 ( type: esriFieldTypeString, alias: Insp (157) - Support Handhole in Place, length: 14 )
• SUPPORT_GROUNDING_158 ( type: esriFieldTypeString, alias: Insp (158) - Support Grounding (25 Ohms or less is Passable; CMS 625.16), length: 14 )
• SUPPORT_GROUNDING_OHMS_159 ( type: esriFieldTypeInteger, alias: Insp (159) - Support Grounding Ohms )
• SUPPORT_POLE_CAP_160 ( type: esriFieldTypeString, alias: Insp (160) - Support Pole Cap in Place, length: 14 )
• SUPPORT_STRUCTRAL_CONN_161 ( type: esriFieldTypeString, alias: Insp (161) - Support Structural Connections, length: 14 )
• FOUND_CONDUIT_SEALED_162 ( type: esriFieldTypeString, alias: Insp (162) - Foundation Conduit Sealed (CMS 625.12), length: 14 )
• FOUNDATION_CONDITION_163 ( type: esriFieldTypeString, alias: Insp (163) - Foundation Condition, length: 14 )
• FOUND_SOIL_CONDITION_164 ( type: esriFieldTypeString, alias: Insp (164) - Soil Condition Around Foundation, length: 14 )
• DOWNGUY_WIRE_CONDITION_165 ( type: esriFieldTypeString, alias: Insp (165) - Down Guy Wire Condition, length: 14 )
• OVERHEAD_SIGN_PRESENT_166 ( type: esriFieldTypeString, alias: Insp (166) - Overhead Sign Present, length: 1 )
• SIGN_CONDITION_167 ( type: esriFieldTypeString, alias: Insp (167) - Sign Condition, length: 14 )
• SIGN_ATTACH_CONDITION_168 ( type: esriFieldTypeString, alias: Insp (168) - Sign Attachment Conditon, length: 14 )
• SIGNAL_SPT_FD_COMMENTS_169 ( type: esriFieldTypeString, alias: Insp (169) - Signal Supports and Foundations Comments, length: 2500 )
• WEATHERHEAD_CONDITION_170 ( type: esriFieldTypeString, alias: Insp (170) - Weatherhead Condition, length: 14 )
• WIRE_CONDITION_171 ( type: esriFieldTypeString, alias: Insp (171) - Wire Condition, length: 14 )
• SPLICE_TOP_OF_POLE_172 ( type: esriFieldTypeString, alias: Insp (172) - Splice at Top of Pole, length: 14 )
• DISC_SWITCH_CONDITION_173 ( type: esriFieldTypeString, alias: Insp (173) - Disconnect Switch Condition, length: 14 )
• METER_BASE_CONDITION_174 ( type: esriFieldTypeString, alias: Insp (174) - Meter Base Condition, length: 14 )
• DISCONNECT_LOCKED_175 ( type: esriFieldTypeString, alias: Insp (175) - Disconnect is Locked, length: 14 )
• NO_WATER_INSTRUSION_176 ( type: esriFieldTypeString, alias: Insp (176) - No Water Instrusion, length: 14 )
• MULTIPLE_PS_LABELED_177 ( type: esriFieldTypeString, alias: Insp (177) - Multiple Power Services Properly Labeled, length: 14 )
• POWER_SERVICE_COMMENTS_178 ( type: esriFieldTypeString, alias: Insp (178) - Power Service Comments, length: 2500 )
• PASSGE_DEMAN_LOOP_COND_179 ( type: esriFieldTypeString, alias: Insp (179) - Passage and Demand Loops Condition, length: 9 )
• QUEUE_LOOPS_CONDITION_180 ( type: esriFieldTypeString, alias: Insp (180) - Queue Loops Condition, length: 9 )
• CRACKS_FILLED_SEALANT_181 ( type: esriFieldTypeString, alias: Insp (181) - Cracks Filled with Sealant, length: 14 )
• NO_EXPOSED_WIRES_182 ( type: esriFieldTypeString, alias: Insp (182) - No Exposed Wires, length: 14 )
• NO_PAVEMENT_CRACKS_183 ( type: esriFieldTypeString, alias: Insp (183) - No Pavement Cracks, length: 14 )
• DETEC_SEALANT_COMMENTS_184 ( type: esriFieldTypeString, alias: Insp (184) - Loop Detectors and Sealant Comments, length: 2500 )
• PED_HEAD_AIM_ALIGNMENT_185 ( type: esriFieldTypeString, alias: Insp (185) - Pedestrian Head Aim/Alignment, length: 14 )
• PED_HEAD_WORKING_186 ( type: esriFieldTypeString, alias: Insp (186) - Pedestrian Head Working, length: 14 )
• PED_ADA_COMPLIANCE_187 ( type: esriFieldTypeString, alias: Insp (187) - Check ADA Pedestrian Device Compliance, length: 14 )
• PED_SIG_HEAD_COMMENTS_188 ( type: esriFieldTypeString, alias: Insp (188) - Pedestrian Signal Heads Comments, length: 2500 )
• BOLT_IN_PS_PULLBOX_LID_189 ( type: esriFieldTypeString, alias: Insp (189) - Bolts in Power Service Pull Box Lid, length: 9 )
• SEALED_OPENINGS_COND_190 ( type: esriFieldTypeString, alias: Insp (190) - Sealed Openings Around Conduits or Knockouts, length: 9 )
• TAGS_IN_PLACE_LEGIBLE_191 ( type: esriFieldTypeString, alias: Insp (191) - Tags/Labels in Place and Legible, length: 9 )
• PULL_BOX_DRAINS_INSTAL_192 ( type: esriFieldTypeString, alias: Insp (192) - Pull Box Drains Installed, length: 9 )
• WATER_IN_PULL_BOX_193 ( type: esriFieldTypeString, alias: Insp (193) - Pull Box Drainage Condition, length: 9 )
• CONDUIT_DUCT_SEAL_32IN_194 ( type: esriFieldTypeString, alias: Insp (194) - Duct Seal in Conduit - 32" Pull Box to Cabinet, length: 9 )
• CONDUIT_DUCT_SEAL_18IN_195 ( type: esriFieldTypeString, alias: Insp (195) - Duct Seal in Conduit - 18" Pull Box to Cabinet, length: 9 )
• CONCRETE_PAD_32_IN_PB_196 ( type: esriFieldTypeString, alias: Insp (196) - Concrete Pad Around 32" Pull Box, length: 9 )
• PULL_BOXES_AT_GRADE_197 ( type: esriFieldTypeString, alias: Insp (197) - Pull Boxes at Grade, length: 9 )
• PULL_BOX_LOCATED_198 ( type: esriFieldTypeString, alias: Insp (198) - All Pull Boxes Located, length: 14 )
• PULL_BOX_LIDS_199 ( type: esriFieldTypeString, alias: Insp (199) - Lids on All Pull Boxes, length: 14 )
• PULL_BOXES_DRAINING_200 ( type: esriFieldTypeString, alias: Insp (200) - Pull Boxes Draining Properly, length: 14 )
• WIRES_CABLES_LABELED_201 ( type: esriFieldTypeString, alias: Insp (201) - Wires and Cables Labeled, length: 14 )
• WIRE_CONDUIT_CONDITION_202 ( type: esriFieldTypeString, alias: Insp (202) - Wires and Conduits Condition, length: 14 )
• CONDUIT_SEALED_203 ( type: esriFieldTypeString, alias: Insp (203) - Conduit Sealed, length: 14 )
• LID_MARKED_TRAFFIC_204 ( type: esriFieldTypeString, alias: Insp (204) - Lid Marked "Traffic, length: 14 )
• WATER_LOOP_SPLICE_KITS_205 ( type: esriFieldTypeString, alias: Insp (205) - Water in Loop Splice Kits, length: 14 )
• PULL_BOXES_COMMENTS_206 ( type: esriFieldTypeString, alias: Insp (206) - Pull Boxes Comments, length: 2500 )
• DRIP_LOOP_IN_CABLE_207 ( type: esriFieldTypeString, alias: Insp (207) - Drip Loop in Cable from Radar Unit to Conduit Entrance, length: 9 )
• CONDUIT_BRACKET_SEALED_208 ( type: esriFieldTypeString, alias: Insp (208) - Conduit Entrances and End of Bracket Arms Sealed, length: 9 )
• CABLES_TAGGED_209 ( type: esriFieldTypeString, alias: Insp (209) - Cables Tagged, length: 9 )
• ETHERNET_IN_PLACE_210 ( type: esriFieldTypeString, alias: Insp (210) - Ethernet to Serial Converter in Place, length: 9 )
• RADAR_BREAKOUT_BOX_COM_211 ( type: esriFieldTypeString, alias: Insp (211) - Communication at the Radar Breakout Box, length: 9 )
• SENSORS_ALIGNED_212 ( type: esriFieldTypeString, alias: Insp (212) - Sensors Aligned Properly, length: 14 )
• FIRMWARE_UP_TO_DATE_213 ( type: esriFieldTypeString, alias: Insp (213) - Correct/Up-to-date Firmware, length: 14 )
• DETECTION_CALL_CHANNEL_214 ( type: esriFieldTypeString, alias: Insp (214) - Detection Calling Correct Channels/Phases, length: 14 )
• SENSORS_GROUNDED_215 ( type: esriFieldTypeString, alias: Insp (215) - Sensors Grounded Properly, length: 14 )
• LOOPS_STRAIN_RELIEF_216 ( type: esriFieldTypeString, alias: Insp (216) - Drip Loops & Proper Cable Strain Relief, length: 14 )
• RADAR_DETECT_COMMENTS_217 ( type: esriFieldTypeString, alias: Insp (217) - Radar Detection Comments, length: 2500 )
• DISC_ACTIVATES_UPS_218 ( type: esriFieldTypeString, alias: Insp (218) - UPS Activates when the Disconnect is Used, length: 14 )
• UPS_CONFIRMATION_LIGHT_219 ( type: esriFieldTypeString, alias: Insp (219) - UPS Confirmation Light Works, length: 14 )
• INVERTOR_LED_ACTIVE_220 ( type: esriFieldTypeString, alias: Insp (220) - LED Display on Invertor is Active, length: 14 )
• MANUAL_BYPASS_SWITCH_221 ( type: esriFieldTypeString, alias: Insp (221) - Manual Bypass Switch Works, length: 14 )
• DISCONNECT_LOAD_TEST_222 ( type: esriFieldTypeString, alias: Insp (222) - Disconnect and Load Test Each Battery, length: 14 )
• GENERATOR_RUN_SIGNAL_223 ( type: esriFieldTypeString, alias: Insp (223) - Does Generator Properly Run Signal, length: 14 )
• BATTERY_CONDITION_224 ( type: esriFieldTypeString, alias: Insp (224) - Battery Condition, length: 14 )
• BATTERY_INSTALL_DATE_225 ( type: esriFieldTypeString, alias: Insp (225) - Check Battery Install Date, length: 14 )
• UPS_COMMENTS_226 ( type: esriFieldTypeString, alias: Insp (226) - UPS Comments, length: 2500 )
• COMM_EQUIP_CAMERA_POWR_227 ( type: esriFieldTypeString, alias: Insp (227) - Communication Equipment and Camera Has Power, length: 14 )
• COMM_EQUIP_PLUG_NONGFI_228 ( type: esriFieldTypeString, alias: Insp (228) - Communication Equipment Plugged into NON-GFI, length: 14 )
• EXT_CABINET_ANT_SEALED_229 ( type: esriFieldTypeString, alias: Insp (229) - Exterior Cabinet Mounted Antenna Sealed, length: 14 )
• CTRLR_COMM_TO_CENTRACS_230 ( type: esriFieldTypeString, alias: Insp (230) - Controller Communicating to Centracs, length: 14 )
• DEVICES_CONNECTED_COMM_231 ( type: esriFieldTypeString, alias: Insp (231) - All Devices Connected and Communicating, length: 14 )
• CAMERA_ON_OHGO_DISPLAY_232 ( type: esriFieldTypeString, alias: Insp (232) - Camera is Displaying on OHGO, length: 14 )
• ETHRNET_RADIO_DRP_LOOP_233 ( type: esriFieldTypeString, alias: Insp (233) - Ethernet Radios Have Drip Loops, length: 14 )
• COMMS_CCTV_COMMENTS_234 ( type: esriFieldTypeString, alias: Insp (234) - Communications and CCTV Cameras Comments, length: 2500 )
• OVERAL_CONDITION_SCORE ( type: esriFieldTypeInteger, alias: Overall Condition & Score )
• OVERAL_COND_SCR_COM ( type: esriFieldTypeString, alias: Overall Condition & Score Comments, length: 2500 )
• WERE_PICTURES_TAKEN ( type: esriFieldTypeString, alias: Were Pictures Taken, length: 1 )
• INSPECTOR ( type: esriFieldTypeString, alias: Inspector(s), length: 255 )
• INSPECTION_DATE ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• MAINTENANCE_COMPLETED ( type: esriFieldTypeString, alias: Maintenance Completed, length: 1 )
• MAINTENANCE_DATE ( type: esriFieldTypeDate, alias: Maintenance Completed Date, length: 8 )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• sys_updated_date ( type: esriFieldTypeDate, alias: sys_updated_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• COLLECTOR.ITS_DEVICE_INVENTORY (4) -- Related To: Device Inventory (Active) - Viewer (1)
• COLLECTOR.ITS_DEVICE_INVENTORY (10) -- Related To: Device Inventory (Non-Active) - Viewer (5)
• COLLECTOR.ITS_DEVICE_INVENTORY (17) -- Related To: Device Inventory (Non-State) - Viewer (9)
• COLLECTOR.ITS_DEVICE_INVENTORY (27) -- Related To: ITS_DEVICE_INVENTORY_ALL (16)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata