View In:   ArcGIS Online Map Viewer

Name: Device Inventory (Active) - Viewer

Display Field: NLFID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -9441768.1977
YMin: 4637812.189800002
XMax: -8963849.093
YMax: 5214741.938199997
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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

Type ID Field:

Fields:

• NLFID ( type: esriFieldTypeString, alias: NLFID, editable: true, nullable: true, length: 14, defaultValue: null, modelName: NLFID , Coded Values: [SADASR00032**C: SADASR00032**C] , [SADASR00032**N: SADASR00032**N] , [SADASR00041**C: SADASR00041**C] , ...7323 more... )
• CRS ( type: esriFieldTypeString, alias: CRS, editable: true, nullable: true, length: 17, defaultValue: null, modelName: CRS )
• ODOT_DISTRICT ( type: esriFieldTypeString, alias: ODOT District, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ODOT_DISTRICT )
• COUNTY ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 10, defaultValue: null, modelName: COUNTY )
• COUNTY_CD ( type: esriFieldTypeString, alias: County CD, editable: true, nullable: true, length: 3, defaultValue: null, modelName: COUNTY_CD )
• ROUTE_TYPE ( type: esriFieldTypeString, alias: Route Type, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ROUTE_TYPE , Coded Values: [IR: Interstate] , [US: United States Route] , [SR: State Route] , ...18 more... )
• ROUTE_NBR ( type: esriFieldTypeString, alias: Route Number, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ROUTE_NBR )
• ROUTE_SUFFIX ( type: esriFieldTypeString, alias: Route Suffix, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ROUTE_SUFFIX )
• CTL_BEGIN_NBR ( type: esriFieldTypeDouble, alias: CTL Begin Number, editable: true, nullable: true, defaultValue: null, modelName: CTL_BEGIN_NBR )
• STL_BEGIN_NBR ( type: esriFieldTypeDouble, alias: STL Begin Number, editable: true, nullable: true, defaultValue: null, modelName: STL_BEGIN_NBR )
• LATITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: Latitude DD Begin, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE_DD_BEGIN )
• LONGITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: Longitude DD Begin, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE_DD_BEGIN )
• PERP_DATE ( type: esriFieldTypeDate, alias: PERP Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PERP_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... )
• INSTALLATION_DATE ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLATION_DATE )
• PID ( type: esriFieldTypeInteger, alias: PID, editable: true, nullable: true, defaultValue: null, modelName: PID , Range: [0, 999999] )
• LET_PLANS_URL ( type: esriFieldTypeString, alias: Let Plans URL, editable: true, nullable: true, length: 150, defaultValue: null, modelName: LET_PLANS_URL )
• END_CONSTRUCTION_DATE ( type: esriFieldTypeDate, alias: End of Construction Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: END_CONSTRUCTION_DATE )
• MAINTAIN_RESPONSIBLE ( type: esriFieldTypeString, alias: Maintenance Responsibility, editable: true, nullable: true, length: 1, defaultValue: S, modelName: MAINTAIN_RESPONSIBLE , Coded Values: [S: State] , [C: County] , [T: Township] , ...4 more... )
• QA_COMPLETE ( type: esriFieldTypeString, alias: QA Complete, editable: true, nullable: true, length: 1, defaultValue: N, modelName: QA_COMPLETE , Coded Values: [Y: Yes] , [N: No] )
• INTERSECTION_ID ( type: esriFieldTypeString, alias: Intersection ID, editable: true, nullable: true, length: 36, defaultValue: null, modelName: INTERSECTION_ID )
• CROSS_ROUTE_LEG_ID ( type: esriFieldTypeString, alias: Approach ID, editable: true, nullable: true, length: 36, defaultValue: null, modelName: CROSS_ROUTE_LEG_ID )
• DEVICE_FILE_NUMBER_1 ( type: esriFieldTypeString, alias: Inv (1) - Device File Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DEVICE_FILE_NUMBER_1 )
• DEVICE_TYPE_2 ( type: esriFieldTypeString, alias: Inv (2) - Device Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: DEVICE_TYPE_2 , Coded Values: [Signalized Intersection: Signalized Intersection] , [CCTV: CCTV (Closed Circuit Television)] , [School Flashers: School Flashers] , ...18 more... )
• DEVICE_OWNER_3 ( type: esriFieldTypeString, alias: Inv (3) - Device Owner, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEVICE_OWNER_3 , Coded Values: [ODOT - CO Traffic: ODOT - CO Traffic] , [ODOT - D01: ODOT - D01] , [ODOT - D02: ODOT - D02] , ...945 more... )
• SOLAR_POWER_4 ( type: esriFieldTypeString, alias: Inv (4) - Solar Powered, editable: true, nullable: true, length: 1, defaultValue: N, modelName: SOLAR_POWER_4 , Coded Values: [Y: Yes] , [N: No] )
• MAKE_MODEL_NUMBER_5 ( type: esriFieldTypeString, alias: Inv (5) - Make/Model Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MAKE_MODEL_NUMBER_5 )
• LOCATION_DESCRIPTION_6 ( type: esriFieldTypeString, alias: Inv (6) - Location Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATION_DESCRIPTION_6 )
• FILTER_SIZE_109 ( type: esriFieldTypeString, alias: Inv (109) - Filter Size, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FILTER_SIZE_109 , Coded Values: [16x25x1: 16x25x1] , [12x16x1: 12x16x1] )
• COMMUNICATION_TYPE_7 ( type: esriFieldTypeString, alias: Inv (7) - Communication Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: COMMUNICATION_TYPE_7 , Coded Values: [High Speed Ethernet Radio: High Speed Ethernet Radio] , [Spread Spectrum Radio: Spread Spectrum Radio] , [Modem: Modem] , ...3 more... )
• COMMUNICATION_BRAND_8 ( type: esriFieldTypeString, alias: Inv (8) - Communication Sub-Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: COMMUNICATION_BRAND_8 , Coded Values: [HSER-M5: HSER-M5] , [HSER-M900: HSER-M900] , [HSER-Other: HSER-Other] , ...13 more... )
• COMM_INSTALLATION_DATE_9 ( type: esriFieldTypeDate, alias: Inv (9) - Communication Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: COMM_INSTALLATION_DATE_9 )
• SWITCHES_10 ( type: esriFieldTypeString, alias: Inv (10) - Switches, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SWITCHES_10 , Coded Values: [Y: Yes] , [N: No] )
• SUPPORT_TYPE_11 ( type: esriFieldTypeString, alias: Inv (11) - Support Type, editable: true, nullable: true, length: 18, defaultValue: null, modelName: SUPPORT_TYPE_11 , Coded Values: [Mast Arm: Mast Arm] , [Span Wire: Span Wire] , [Pedestal: Pedestal] , ...10 more... )
• CTVDMSSTRCT_INSTALL_DT_12 ( type: esriFieldTypeDate, alias: Inv (12) - CCTV Pole/DMS Structure Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CTVDMSSTRCT_INSTALL_DT_12 )
• NUMBER_OF_SUPPORTS_13 ( type: esriFieldTypeInteger, alias: Inv (13) - Number of Supports, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_OF_SUPPORTS_13 , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...7 more... )
• POLE_HEIGHT_FT_14 ( type: esriFieldTypeInteger, alias: Inv (14) - Pole Height (ft), editable: true, nullable: true, defaultValue: null, modelName: POLE_HEIGHT_FT_14 , Coded Values: [0: 0] , [5: 5] , [10: 10] , ...18 more... )
• BEAM_HEIGHT_FT_15 ( type: esriFieldTypeSingle, alias: Inv (15) - Beam Height (ft), editable: true, nullable: true, defaultValue: null, modelName: BEAM_HEIGHT_FT_15 , Range: [5, 30] )
• BEAM_TYPE_16 ( type: esriFieldTypeString, alias: Inv (16) - Beam Type, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BEAM_TYPE_16 , Coded Values: [S4 X 7.7: S4 X 7.7] , [W6 X 9: W6 X 9] , [W10 X 12: W10 X 12] , ...3 more... )
• EMBEDMENT_DEPTH_FT_17 ( type: esriFieldTypeInteger, alias: Inv (17) - Embedment Depth (ft), editable: true, nullable: true, defaultValue: null, modelName: EMBEDMENT_DEPTH_FT_17 , Range: [0, 99] )
• LOWERING_DEVICE_18 ( type: esriFieldTypeString, alias: Inv (18) - Lowering Device, editable: true, nullable: true, length: 1, defaultValue: null, modelName: LOWERING_DEVICE_18 , Coded Values: [Y: Yes] , [N: No] )
• NUMBER_OF_BEAMS_19 ( type: esriFieldTypeInteger, alias: Inv (19) - Number of Beams, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_OF_BEAMS_19 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• NUMBER_OF_DESTINATIONS_20 ( type: esriFieldTypeInteger, alias: Inv (20) - Number of Destinations, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_OF_DESTINATIONS_20 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• LADDER_21 ( type: esriFieldTypeString, alias: Inv (21) - Ladder, editable: true, nullable: true, length: 5, defaultValue: null, modelName: LADDER_21 , Coded Values: [Right: Right] , [Left: Left] , [None: None] )
• WALK_IN_22 ( type: esriFieldTypeString, alias: Inv (22) - Walk In, editable: true, nullable: true, length: 1, defaultValue: null, modelName: WALK_IN_22 , Coded Values: [Y: Yes] , [N: No] )
• ANCHOR_BOLTS_PER_RING_23 ( type: esriFieldTypeInteger, alias: Inv (23) - Number of Anchor Bolts per Ring, editable: true, nullable: true, defaultValue: null, modelName: ANCHOR_BOLTS_PER_RING_23 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...97 more... )
• ANCHOR_BOLTS_TOTAL_24 ( type: esriFieldTypeInteger, alias: Inv (24) - Number of Anchor Bolts Total, editable: true, nullable: true, defaultValue: null, modelName: ANCHOR_BOLTS_TOTAL_24 , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...18 more... )
• ANCHOR_BOLT_DIAMETER_25 ( type: esriFieldTypeInteger, alias: Inv (25) - Anchor Bolt Diameter (in), editable: true, nullable: true, defaultValue: null, modelName: ANCHOR_BOLT_DIAMETER_25 , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...8 more... )
• ANCHOR_BOLT_NUT_DIAM_26 ( type: esriFieldTypeInteger, alias: Inv (26) - Anchor Bolt Nut Diameter (in), editable: true, nullable: true, defaultValue: null, modelName: ANCHOR_BOLT_NUT_DIAM_26 , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...8 more... )
• NUMBER_OF_SOLAR_PANELS_27 ( type: esriFieldTypeInteger, alias: Inv (27) - Number of Solar Panels, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_OF_SOLAR_PANELS_27 , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...7 more... )
• NUMBER_OF_BATTERIES_28 ( type: esriFieldTypeInteger, alias: Inv (28) - Number of Batteries, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_OF_BATTERIES_28 , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...7 more... )
• BATTERY_INSTALL_DATE_29 ( type: esriFieldTypeDate, alias: Inv (29) - Battery Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BATTERY_INSTALL_DATE_29 )
• CAMERA_30 ( type: esriFieldTypeString, alias: Inv (30) - Camera, editable: true, nullable: true, length: 1, defaultValue: null, modelName: CAMERA_30 , Coded Values: [Y: Yes] , [N: No] )
• RADAR_31 ( type: esriFieldTypeString, alias: Inv (31) - Radar, editable: true, nullable: true, length: 1, defaultValue: null, modelName: RADAR_31 , Coded Values: [Y: Yes] , [N: No] )
• SIGN_WITH_LED_ENHANCED_32 ( type: esriFieldTypeString, alias: Inv (32) - Sign with LED Enhanced, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SIGN_WITH_LED_ENHANCED_32 , Coded Values: [Y: Yes] , [N: No] )
• ATR_BRAND_NAME_33 ( type: esriFieldTypeString, alias: Inv (33) - ATR Brand Name, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ATR_BRAND_NAME_33 , Coded Values: [ISS: ISS] , [Wavetronix: Wavetronix] , [Other: Other] )
• ATR_RADAR_TYPE_34 ( type: esriFieldTypeString, alias: Inv (34) - ATR Radar Type, editable: true, nullable: true, length: 6, defaultValue: null, modelName: ATR_RADAR_TYPE_34 , Coded Values: [X3: X3] , [G4: G4] , [SX-300: SX-300] , ...2 more... )
• INTERFACE_WITH_RM_35 ( type: esriFieldTypeString, alias: Inv (35) - Interface with Ramp Meter, editable: true, nullable: true, length: 1, defaultValue: null, modelName: INTERFACE_WITH_RM_35 , Coded Values: [Y: Yes] , [N: No] )
• BEACONS_36 ( type: esriFieldTypeString, alias: Inv (36) - Beacons, editable: true, nullable: true, length: 1, defaultValue: null, modelName: BEACONS_36 , Coded Values: [Y: Yes] , [N: No] )
• SITE_NUMBER_37 ( type: esriFieldTypeInteger, alias: Inv (37) - Site Number, editable: true, nullable: true, defaultValue: null, modelName: SITE_NUMBER_37 )
• COUNT_OF_COMPONENT_38 ( type: esriFieldTypeInteger, alias: Inv (38) - Count of Component, editable: true, nullable: true, defaultValue: null, modelName: COUNT_OF_COMPONENT_38 , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...7 more... )
• COMPONENT_TYPE_39 ( type: esriFieldTypeString, alias: Inv (39) - Component Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: COMPONENT_TYPE_39 , Coded Values: [Antenna: Antenna] , [Arrestor: Arrestor] , [Cabinet: Cabinet] , ...17 more... )
• COMPONENT_BRAND_40 ( type: esriFieldTypeString, alias: Inv (40) - Component Brand, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMPONENT_BRAND_40 , Coded Values: [900 MHZ Omni Fiberglass Antenna: 900 MHZ Omni Fiberglass Antenna] , [Outdoor 698-896/1700 MHZ: Outdoor 698-896/1700 MHZ] , [Outdoor Omni Antenna: Outdoor Omni Antenna] , ...57 more... )
• NUMBER_OF_SENSORS_41 ( type: esriFieldTypeInteger, alias: Inv (41) - Number of Sensors, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_OF_SENSORS_41 , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...7 more... )
• LANE_NUMBER_42 ( type: esriFieldTypeInteger, alias: Inv (42) - Lane Number, editable: true, nullable: true, defaultValue: null, modelName: LANE_NUMBER_42 , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...7 more... )
• LANE_DIRECTION_43 ( type: esriFieldTypeString, alias: Inv (43) - Lane Direction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: LANE_DIRECTION_43 , Coded Values: [NB: NB] , [EB: EB] , [SB: SB] , ...1 more... )
• SERIAL_NUMBER_44 ( type: esriFieldTypeString, alias: Inv (44) - Serial Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SERIAL_NUMBER_44 )
• MAINLINE_DETECTION_45 ( type: esriFieldTypeString, alias: Inv (45) - Mainline Detection, editable: true, nullable: true, length: 1, defaultValue: null, modelName: MAINLINE_DETECTION_45 , Coded Values: [Y: Yes] , [N: No] )
• MAINLINE_DETECTION_TYP_46 ( type: esriFieldTypeString, alias: Inv (46) - Mainline Detection Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: MAINLINE_DETECTION_TYP_46 , Coded Values: [Loops: Loops] , [Radar: Radar] , [Video: Video] , ...2 more... )
• SIDE_STREET_DETECTION_47 ( type: esriFieldTypeString, alias: Inv (47) - Side Street Detection, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SIDE_STREET_DETECTION_47 , Coded Values: [Y: Yes] , [N: No] )
• SIDESTREET_DETECT_TYPE_48 ( type: esriFieldTypeString, alias: Inv (48) - Side Street Detection Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SIDESTREET_DETECT_TYPE_48 , Coded Values: [Loops: Loops] , [Radar: Radar] , [Video: Video] , ...2 more... )
• REAR_FACING_BEACON_49 ( type: esriFieldTypeString, alias: Inv (49) - Rear-facing Beacon, editable: true, nullable: true, length: 1, defaultValue: null, modelName: REAR_FACING_BEACON_49 , Coded Values: [Y: Yes] , [N: No] )
• SF_CONTROLLER_TYPES_50 ( type: esriFieldTypeString, alias: Inv (50) - School Flasher Controller Types, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SF_CONTROLLER_TYPES_50 , Coded Values: [Electrotechnics TC-18 : Electrotechnics TC-18 ] , [RTC AP41 : RTC AP41 ] , [RTC AP22 : RTC AP22 ] , ...9 more... )
• FLASH_TYPE_51 ( type: esriFieldTypeString, alias: Inv (51) - Flash Type, editable: true, nullable: true, length: 7, defaultValue: null, modelName: FLASH_TYPE_51 , Coded Values: [All Red: All Red] , [Y/R: Y/R] )
• SPANWIRE_CONFIGURATION_52 ( type: esriFieldTypeString, alias: Inv (52) - Spanwire Configuration, editable: true, nullable: true, length: 14, defaultValue: null, modelName: SPANWIRE_CONFIGURATION_52 , Coded Values: [Box with Tails: Box with Tails] , [Simple: Simple] , [Box: Box] , ...4 more... )
• VISOR_TYPE_53 ( type: esriFieldTypeString, alias: Inv (53) - Visor Type, editable: true, nullable: true, length: 7, defaultValue: null, modelName: VISOR_TYPE_53 , Coded Values: [Cutaway: Cutaway] , [Tunnel: Tunnel] , [Other: Other] )
• DETECTION_TYPE_54 ( type: esriFieldTypeString, alias: Inv (54) - Detection Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DETECTION_TYPE_54 , Coded Values: [Loops: Loops] , [Radar: Radar] , [Video: Video] , ...2 more... )
• DIST_GORE_TO_UPSTREAM_55 ( type: esriFieldTypeInteger, alias: Inv (55) - Distance From Gore to Upstream Radar, editable: true, nullable: true, defaultValue: null, modelName: DIST_GORE_TO_UPSTREAM_55 , Range: [0, 2000] )
• DIST_GORE_TO_DWNSTREAM_56 ( type: esriFieldTypeInteger, alias: Inv (56) - Distance From Gore to Downstream Radar, editable: true, nullable: true, defaultValue: null, modelName: DIST_GORE_TO_DWNSTREAM_56 , Range: [0, 2000] )
• DIST_ART_TO_STOP_LINE_57 ( type: esriFieldTypeInteger, alias: Inv (57) - Distance From Arterial to Stop Line, editable: true, nullable: true, defaultValue: null, modelName: DIST_ART_TO_STOP_LINE_57 , Range: [0, 2000] )
• DIST_QUEUE_LOOP_STOP_58 ( type: esriFieldTypeInteger, alias: Inv (58) - Distance From Queue Loop to Stop Line, editable: true, nullable: true, defaultValue: null, modelName: DIST_QUEUE_LOOP_STOP_58 , Range: [0, 2000] )
• DIST_ART_TO_QUEUE_LOOP_59 ( type: esriFieldTypeInteger, alias: Inv (59) - Distance From Arterial to Queue Loop, editable: true, nullable: true, defaultValue: null, modelName: DIST_ART_TO_QUEUE_LOOP_59 , Range: [0, 2000] )
• DIST_STOP_LINE_TO_GORE_60 ( type: esriFieldTypeInteger, alias: Inv (60) - Distance From Stop Line to Gore, editable: true, nullable: true, defaultValue: null, modelName: DIST_STOP_LINE_TO_GORE_60 , Range: [0, 2000] )
• ACCELERATION_LENGTH_61 ( type: esriFieldTypeInteger, alias: Inv (61) - Acceleration Length, editable: true, nullable: true, defaultValue: null, modelName: ACCELERATION_LENGTH_61 , Range: [0, 2000] )
• NUMBER_OF_METERED_LANE_62 ( type: esriFieldTypeInteger, alias: Inv (62) - Number of Metered Lanes, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_OF_METERED_LANE_62 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• LANES_MAINLINE_BY_RM_63 ( type: esriFieldTypeInteger, alias: Inv (63) - Number of Lanes on Mainline by RM, editable: true, nullable: true, defaultValue: null, modelName: LANES_MAINLINE_BY_RM_63 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...7 more... )
• MAINLINE_LANES_DETECT_64 ( type: esriFieldTypeInteger, alias: Inv (64) - Number of Lanes on Mainline by Detection, editable: true, nullable: true, defaultValue: null, modelName: MAINLINE_LANES_DETECT_64 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...7 more... )
• RM_SIGNAL_SUPPORT_TYPE_65 ( type: esriFieldTypeString, alias: Inv (65) - Signal Support Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RM_SIGNAL_SUPPORT_TYPE_65 , Coded Values: [Pedestal: Pedestal] , [Mast Arm: Mast Arm] )
• SIGNAL_MOUNTING_TYPE_66 ( type: esriFieldTypeString, alias: Inv (66) - Signal Mounting Type, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SIGNAL_MOUNTING_TYPE_66 , Coded Values: [Ground: Ground] , [Barrier Wall: Barrier Wall] , [Both: Both] )
• VSH_FOR_RAMP_TRAFFIC_67 ( type: esriFieldTypeInteger, alias: Inv (67) - Number of VSHs for Ramp Traffic, editable: true, nullable: true, defaultValue: null, modelName: VSH_FOR_RAMP_TRAFFIC_67 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...7 more... )
• VSH_FOR_ENFORCEMENT_68 ( type: esriFieldTypeInteger, alias: Inv (68) - Number of VSHs for Enforcement, editable: true, nullable: true, defaultValue: null, modelName: VSH_FOR_ENFORCEMENT_68 , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• CONTROLLER_TYPE_69 ( type: esriFieldTypeString, alias: Inv (69) - Controller Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CONTROLLER_TYPE_69 , Coded Values: [Intelight 2070 LDX Ramp Meter: Intelight 2070 LDX Ramp Meter] , [Intelight 2070 E Ramp Meter: Intelight 2070 E Ramp Meter] )
• DETECTOR_INPUT_70 ( type: esriFieldTypeString, alias: Inv (70) - Detector Input, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DETECTOR_INPUT_70 , Coded Values: [Side Mtd: Side Mtd] , [Direct: Direct] )
• DETECTOR_TYPE_STOPLINE_71 ( type: esriFieldTypeString, alias: Inv (71) - Stop Line Detector Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: DETECTOR_TYPE_STOPLINE_71 , Coded Values: [Loops: Loops] , [Radar: Radar] , [Video: Video] , ...2 more... )
• DETECTOR_TYPE_QUEUE_72 ( type: esriFieldTypeString, alias: Inv (72) - Queue Detector Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: DETECTOR_TYPE_QUEUE_72 , Coded Values: [Loops: Loops] , [Radar: Radar] , [Video: Video] , ...2 more... )
• STOP_LINE_73 ( type: esriFieldTypeString, alias: Inv (73) - Stop Line, editable: true, nullable: true, length: 6, defaultValue: null, modelName: STOP_LINE_73 , Coded Values: [Thermo: Thermo] , [Paint: Paint] , [None: None] )
• ONE_VEHICLE_GREEN_SIGN_74 ( type: esriFieldTypeString, alias: Inv (74) - One Vehicle Per Green Sign (R10-28), editable: true, nullable: true, length: 1, defaultValue: null, modelName: ONE_VEHICLE_GREEN_SIGN_74 , Coded Values: [Y: Yes] , [N: No] )
• STOP_HERE_ON_RED_SIGN_75 ( type: esriFieldTypeString, alias: Inv (75) - Stop Here on Red Sign (R10-6), editable: true, nullable: true, length: 1, defaultValue: null, modelName: STOP_HERE_ON_RED_SIGN_75 , Coded Values: [Y: Yes] , [N: No] )
• ONE_VEHICLE_LANE_SIGN_76 ( type: esriFieldTypeString, alias: Inv (76) - One Vehicle Per Green Per Lane Sign (R10-H29A), editable: true, nullable: true, length: 1, defaultValue: null, modelName: ONE_VEHICLE_LANE_SIGN_76 , Coded Values: [Y: Yes] , [N: No] )
• FORM_TWO_LANES_SIGN_77 ( type: esriFieldTypeString, alias: Inv (77) - Form Two Lanes Sign (Special - No Code), editable: true, nullable: true, length: 1, defaultValue: null, modelName: FORM_TWO_LANES_SIGN_77 , Coded Values: [Y: Yes] , [N: No] )
• RADAR_BREAKOUT_BOX_COM_78 ( type: esriFieldTypeString, alias: Inv (78) - Radar Breakout Box Communication Type, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RADAR_BREAKOUT_BOX_COM_78 , Coded Values: [RS-232: RS-232] , [Ethernet: Ethernet] , [Both: Both] )
• PART_OF_SIGNAL_SYSTEM_79 ( type: esriFieldTypeString, alias: Inv (79) - Part of Signal System, editable: true, nullable: true, length: 3, defaultValue: null, modelName: PART_OF_SIGNAL_SYSTEM_79 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• MASTERCABINET_LOCATION_80 ( type: esriFieldTypeString, alias: Inv (80) - Master Cabinet Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MASTERCABINET_LOCATION_80 , Coded Values: [ALL SR-117/309: ALL SR-117/309] , [ALL SR-309: ALL SR-309] , [LUC US-20 Central Ave.: LUC US-20 Central Ave.] , ...120 more... )
• MULTI_JURIS_CORRIDOR_81 ( type: esriFieldTypeString, alias: Inv (81) - Multi-Jurisdiction Corridor, editable: true, nullable: true, length: 3, defaultValue: null, modelName: MULTI_JURIS_CORRIDOR_81 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• WRITTEN_AGREEMENT_82 ( type: esriFieldTypeString, alias: Inv (82) - Written Agreement in Place, editable: true, nullable: true, length: 3, defaultValue: null, modelName: WRITTEN_AGREEMENT_82 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• SIGN_CODE_83 ( type: esriFieldTypeString, alias: Inv (83) - Sign Code, editable: true, nullable: true, length: 7, defaultValue: null, modelName: SIGN_CODE_83 , Coded Values: [R10-23: R10-23 Crosswalk-Stop on Red] , [R10-23a: R10-23a Crosswalk-Stop on Red-Proceed on Flashing Red when Clear] , [W3-3: W3-3 Signal Ahead] , ...23 more... )
• CONTROLLER_MAKE_MODEL_84 ( type: esriFieldTypeString, alias: Inv (84) - Controller Make & Model, editable: true, nullable: true, length: 52, defaultValue: null, modelName: CONTROLLER_MAKE_MODEL_84 , Coded Values: [Econolite Cobalt (TS1 or TS2 Cabinet): Econolite Cobalt (TS1 or TS2 Cabinet)] , [Econolite ASC3 (TS1 or TS2 Cabinet): Econolite ASC3 (TS1 or TS2 Cabinet)] , [Siemens m50 (TS1 or TS2 Cabinet): Siemens m50 (TS1 or TS2 Cabinet)] , ...6 more... )
• CONTROLLER_SERIAL_NUM_85 ( type: esriFieldTypeString, alias: Inv (85) - Controller Serial Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CONTROLLER_SERIAL_NUM_85 )
• MONITOR_MAKE_MODEL_86 ( type: esriFieldTypeString, alias: Inv (86) - Monitor Make & Model, editable: true, nullable: true, length: 11, defaultValue: null, modelName: MONITOR_MAKE_MODEL_86 , Coded Values: [2010 ECL: 2010 ECL] , [2010 ECLIP: 2010 ECLIP] , [2018 ECL: 2018 ECL] , ...14 more... )
• MONITOR_SERIAL_NUMBER_87 ( type: esriFieldTypeString, alias: Inv (87) - Monitor Serial Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MONITOR_SERIAL_NUMBER_87 )
• UPS_MAKE_88 ( type: esriFieldTypeString, alias: Inv (88) - UPS Make, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UPS_MAKE_88 , Coded Values: [Alpha: Alpha] , [Multilink: Multilink] , [Dimensions: Dimensions] , ...1 more... )
• UPS_SERIAL_NUMBER_89 ( type: esriFieldTypeString, alias: Inv (89) - UPS Serial Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: UPS_SERIAL_NUMBER_89 )
• UPS_BATTERY_TYPE_90 ( type: esriFieldTypeString, alias: Inv (90) - UPS Battery Type, editable: true, nullable: true, length: 11, defaultValue: null, modelName: UPS_BATTERY_TYPE_90 , Coded Values: [AGM: AGM] , [Gel: Gel] , [Nickel Zinc: Nickel Zinc] )
• UPS_BATT_INSTALL_DATE_91 ( type: esriFieldTypeDate, alias: Inv (91) - UPS Battery Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UPS_BATT_INSTALL_DATE_91 )
• TETHERED_92 ( type: esriFieldTypeString, alias: Inv (92) - Tethered, editable: true, nullable: true, length: 1, defaultValue: null, modelName: TETHERED_92 , Coded Values: [Y: Yes] , [N: No] )
• BACKPLATES_93 ( type: esriFieldTypeString, alias: Inv (93) - Backplates, editable: true, nullable: true, length: 1, defaultValue: null, modelName: BACKPLATES_93 , Coded Values: [Y: Yes] , [N: No] )
• BACKPLATES_DIRECTION_94 ( type: esriFieldTypeString, alias: Inv (94) - Backplates Direction, editable: true, nullable: true, length: 23, defaultValue: null, modelName: BACKPLATES_DIRECTION_94 , Coded Values: [Mainline Only: Mainline Only] , [Entire Span: Entire Span] , [Sidestreet Only: Sidestreet Only] , ...10 more... )
• ADVNCEWARNING_SIGNCODE_95 ( type: esriFieldTypeString, alias: Inv (95) - Advanced Warning Sign Code, editable: true, nullable: true, length: 7, defaultValue: null, modelName: ADVNCEWARNING_SIGNCODE_95 , Coded Values: [R10-23: R10-23 Crosswalk-Stop on Red] , [R10-23a: R10-23a Crosswalk-Stop on Red-Proceed on Flashing Red when Clear] , [W3-3: W3-3 Signal Ahead] , ...23 more... )
• ADVNCEWARNING_BEACON_96 ( type: esriFieldTypeString, alias: Inv (96) - Advanced Warning Beacon, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ADVNCEWARNING_BEACON_96 , Coded Values: [Y: Yes] , [N: No] )
• ADVNCEWARNING_LED_97 ( type: esriFieldTypeString, alias: Inv (97) - Advanced Warning LED Enhanced, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ADVNCEWARNING_LED_97 , Coded Values: [Y: Yes] , [N: No] )
• LED_INSTALLATION_DATE_98 ( type: esriFieldTypeDate, alias: Inv (98) - LED Installation/Re-lamp Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LED_INSTALLATION_DATE_98 )
• PED_SIGNAL_HEADS_99 ( type: esriFieldTypeString, alias: Inv (99) - Pedestrian Signal Heads, editable: true, nullable: true, length: 1, defaultValue: null, modelName: PED_SIGNAL_HEADS_99 , Coded Values: [Y: Yes] , [N: No] )
• PED_SIGNAL_HEADS_QTY_100 ( type: esriFieldTypeInteger, alias: Inv (100) - Pedestrian Signal Heads Quantity , editable: true, nullable: true, defaultValue: null, modelName: PED_SIGNAL_HEADS_QTY_100 )
• FLASHING_YELLOW_ARROW_101 ( type: esriFieldTypeString, alias: Inv (101) - Flashing Yellow Arrow, editable: true, nullable: true, length: 1, defaultValue: null, modelName: FLASHING_YELLOW_ARROW_101 , Coded Values: [Y: Yes] , [N: No] )
• BLANKOUT_SIGN_102 ( type: esriFieldTypeString, alias: Inv (102) - Blankout Sign, editable: true, nullable: true, length: 1, defaultValue: null, modelName: BLANKOUT_SIGN_102 , Coded Values: [Y: Yes] , [N: No] )
• BLANKOUT_SIGN_QTY_103 ( type: esriFieldTypeInteger, alias: Inv (103) - Blankout Sign Quantity, editable: true, nullable: true, defaultValue: null, modelName: BLANKOUT_SIGN_QTY_103 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• BLANKOUT_SIGN_DIR_104 ( type: esriFieldTypeString, alias: Inv (104) - Blankout Sign Direction, editable: true, nullable: true, length: 23, defaultValue: null, modelName: BLANKOUT_SIGN_DIR_104 , Coded Values: [Mainline Only: Mainline Only] , [Entire Span: Entire Span] , [Sidestreet Only: Sidestreet Only] , ...10 more... )
• BLANKOUT_INSTALL_DATE_105 ( type: esriFieldTypeDate, alias: Inv (105) - Blankout Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BLANKOUT_INSTALL_DATE_105 )
• NUMBER_OF_STOP_LINE_106 ( type: esriFieldTypeInteger, alias: Inv (106) - Number of Stop Line, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_OF_STOP_LINE_106 )
• NUMBER_DILEMMA_ZONE_107 ( type: esriFieldTypeInteger, alias: Inv (107) - Number Dilemma Zone, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_DILEMMA_ZONE_107 )
• INVENTORY_COMMENTS_108 ( type: esriFieldTypeString, alias: Inv (108) - Inventory Comments, editable: true, nullable: true, length: 2500, defaultValue: null, modelName: INVENTORY_COMMENTS_108 )
• 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: Device Inventory (Active) - Viewer
  Description:
  Prototype:
  sys_updated_date: null
  NLFID: null
  CRS: null
  ODOT_DISTRICT: null
  COUNTY: null
  COUNTY_CD: null
  ROUTE_TYPE: null
  ROUTE_NBR: null
  ROUTE_SUFFIX: null
  CTL_BEGIN_NBR: null
  STL_BEGIN_NBR: null
  LATITUDE_DD_BEGIN: null
  LONGITUDE_DD_BEGIN: null
  PERP_DATE: null
  STATUS: A
  INSTALLATION_DATE: null
  PID: null
  LET_PLANS_URL: null
  END_CONSTRUCTION_DATE: null
  MAINTAIN_RESPONSIBLE: S
  QA_COMPLETE: N
  INTERSECTION_ID: null
  CROSS_ROUTE_LEG_ID: null
  DEVICE_FILE_NUMBER_1: null
  DEVICE_TYPE_2: null
  DEVICE_OWNER_3: null
  SOLAR_POWER_4: N
  MAKE_MODEL_NUMBER_5: null
  LOCATION_DESCRIPTION_6: null
  FILTER_SIZE_109: null
  COMMUNICATION_TYPE_7: null
  COMMUNICATION_BRAND_8: null
  COMM_INSTALLATION_DATE_9: null
  SWITCHES_10: null
  SUPPORT_TYPE_11: null
  CTVDMSSTRCT_INSTALL_DT_12: null
  NUMBER_OF_SUPPORTS_13: null
  POLE_HEIGHT_FT_14: null
  BEAM_HEIGHT_FT_15: null
  BEAM_TYPE_16: null
  EMBEDMENT_DEPTH_FT_17: null
  LOWERING_DEVICE_18: null
  NUMBER_OF_BEAMS_19: null
  NUMBER_OF_DESTINATIONS_20: null
  LADDER_21: null
  WALK_IN_22: null
  ANCHOR_BOLTS_PER_RING_23: null
  ANCHOR_BOLTS_TOTAL_24: null
  ANCHOR_BOLT_DIAMETER_25: null
  ANCHOR_BOLT_NUT_DIAM_26: null
  NUMBER_OF_SOLAR_PANELS_27: null
  NUMBER_OF_BATTERIES_28: null
  BATTERY_INSTALL_DATE_29: null
  CAMERA_30: null
  RADAR_31: null
  SIGN_WITH_LED_ENHANCED_32: null
  ATR_BRAND_NAME_33: null
  ATR_RADAR_TYPE_34: null
  INTERFACE_WITH_RM_35: null
  BEACONS_36: null
  SITE_NUMBER_37: null
  COUNT_OF_COMPONENT_38: null
  COMPONENT_TYPE_39: null
  COMPONENT_BRAND_40: null
  NUMBER_OF_SENSORS_41: null
  LANE_NUMBER_42: null
  LANE_DIRECTION_43: null
  SERIAL_NUMBER_44: null
  MAINLINE_DETECTION_45: null
  MAINLINE_DETECTION_TYP_46: null
  SIDE_STREET_DETECTION_47: null
  SIDESTREET_DETECT_TYPE_48: null
  REAR_FACING_BEACON_49: null
  SF_CONTROLLER_TYPES_50: null
  FLASH_TYPE_51: null
  SPANWIRE_CONFIGURATION_52: null
  VISOR_TYPE_53: null
  DETECTION_TYPE_54: null
  DIST_GORE_TO_UPSTREAM_55: null
  DIST_GORE_TO_DWNSTREAM_56: null
  DIST_ART_TO_STOP_LINE_57: null
  DIST_QUEUE_LOOP_STOP_58: null
  DIST_ART_TO_QUEUE_LOOP_59: null
  DIST_STOP_LINE_TO_GORE_60: null
  ACCELERATION_LENGTH_61: null
  NUMBER_OF_METERED_LANE_62: null
  LANES_MAINLINE_BY_RM_63: null
  MAINLINE_LANES_DETECT_64: null
  RM_SIGNAL_SUPPORT_TYPE_65: null
  SIGNAL_MOUNTING_TYPE_66: null
  VSH_FOR_RAMP_TRAFFIC_67: null
  VSH_FOR_ENFORCEMENT_68: null
  CONTROLLER_TYPE_69: null
  DETECTOR_INPUT_70: null
  DETECTOR_TYPE_STOPLINE_71: null
  DETECTOR_TYPE_QUEUE_72: null
  STOP_LINE_73: null
  ONE_VEHICLE_GREEN_SIGN_74: null
  STOP_HERE_ON_RED_SIGN_75: null
  ONE_VEHICLE_LANE_SIGN_76: null
  FORM_TWO_LANES_SIGN_77: null
  RADAR_BREAKOUT_BOX_COM_78: null
  PART_OF_SIGNAL_SYSTEM_79: null
  MASTERCABINET_LOCATION_80: null
  MULTI_JURIS_CORRIDOR_81: null
  WRITTEN_AGREEMENT_82: null
  SIGN_CODE_83: null
  CONTROLLER_MAKE_MODEL_84: null
  CONTROLLER_SERIAL_NUM_85: null
  MONITOR_MAKE_MODEL_86: null
  MONITOR_SERIAL_NUMBER_87: null
  UPS_MAKE_88: null
  UPS_SERIAL_NUMBER_89: null
  UPS_BATTERY_TYPE_90: null
  UPS_BATT_INSTALL_DATE_91: null
  TETHERED_92: null
  BACKPLATES_93: null
  BACKPLATES_DIRECTION_94: null
  ADVNCEWARNING_SIGNCODE_95: null
  ADVNCEWARNING_BEACON_96: null
  ADVNCEWARNING_LED_97: null
  LED_INSTALLATION_DATE_98: null
  PED_SIGNAL_HEADS_99: null
  PED_SIGNAL_HEADS_QTY_100: null
  FLASHING_YELLOW_ARROW_101: null
  BLANKOUT_SIGN_102: null
  BLANKOUT_SIGN_QTY_103: null
  BLANKOUT_SIGN_DIR_104: null
  BLANKOUT_INSTALL_DATE_105: null
  NUMBER_OF_STOP_LINE_106: null
  NUMBER_DILEMMA_ZONE_107: null
  INVENTORY_COMMENTS_108: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• COLLECTOR.ITS_DEVICE_SI_ELEMENT_INVENTORY (2) -- Related To: ITS Device SI Element Inventory - Viewer (27)
• COLLECTOR.ITS_DEVICE_INSPECTION (4) -- Related To: ITS Device Inspection - Viewer (21)
• COLLECTOR.ITS_MAINTENANCE (3) -- Related To: ITS Maintenance - Viewer (23)

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

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