Name: Device Inventory (Non-Active) - Viewer

Display Field: ATR_BRAND_NAME_33

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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:
Unique Value Renderer:
Field 1: STATUS
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: P
  Label: Proposed
  Description: N/A
  Symbol:
  
• Value: R
  Label: Retired
  Description: N/A
  Symbol:
  
• Value: X
  Label: Abandoned
  Description: N/A
  Symbol:
  
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: 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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: N/A

Fields:

• NLFID ( type: esriFieldTypeString, alias: NLFID, length: 14 )
• CRS ( type: esriFieldTypeString, alias: CRS, length: 17 )
• ODOT_DISTRICT ( type: esriFieldTypeString, alias: ODOT District, length: 2 )
• COUNTY ( type: esriFieldTypeString, alias: County, length: 10 )
• COUNTY_CD ( type: esriFieldTypeString, alias: County CD, length: 3 )
• ROUTE_TYPE ( type: esriFieldTypeString, alias: Route Type, length: 2 )
• ROUTE_NBR ( type: esriFieldTypeString, alias: Route Number, length: 5 )
• ROUTE_SUFFIX ( type: esriFieldTypeString, alias: Route Suffix, length: 1 )
• CTL_BEGIN_NBR ( type: esriFieldTypeDouble, alias: CTL Begin Number )
• STL_BEGIN_NBR ( type: esriFieldTypeDouble, alias: STL Begin Number )
• LATITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: Latitude DD Begin )
• LONGITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: Longitude DD Begin )
• PERP_DATE ( type: esriFieldTypeDate, alias: PERP Date, length: 8 )
• STATUS ( type: esriFieldTypeString, alias: Status, length: 1 )
• INSTALLATION_DATE ( type: esriFieldTypeDate, alias: Installation Date, length: 8 )
• PID ( type: esriFieldTypeInteger, alias: PID )
• LET_PLANS_URL ( type: esriFieldTypeString, alias: Let Plans URL, length: 150 )
• END_CONSTRUCTION_DATE ( type: esriFieldTypeDate, alias: End of Construction Date, length: 8 )
• MAINTAIN_RESPONSIBLE ( type: esriFieldTypeString, alias: Maintenance Responsibility, length: 1 )
• QA_COMPLETE ( type: esriFieldTypeString, alias: QA Complete, length: 1 )
• INTERSECTION_ID ( type: esriFieldTypeString, alias: Intersection ID, length: 36 )
• CROSS_ROUTE_LEG_ID ( type: esriFieldTypeString, alias: Approach ID, length: 36 )
• DEVICE_FILE_NUMBER_1 ( type: esriFieldTypeString, alias: Inv (1) - Device File Number, length: 10 )
• DEVICE_TYPE_2 ( type: esriFieldTypeString, alias: Inv (2) - Device Type, length: 25 )
• DEVICE_OWNER_3 ( type: esriFieldTypeString, alias: Inv (3) - Device Owner, length: 50 )
• SOLAR_POWER_4 ( type: esriFieldTypeString, alias: Inv (4) - Solar Powered, length: 1 )
• MAKE_MODEL_NUMBER_5 ( type: esriFieldTypeString, alias: Inv (5) - Make/Model Number, length: 255 )
• LOCATION_DESCRIPTION_6 ( type: esriFieldTypeString, alias: Inv (6) - Location Description, length: 255 )
• FILTER_SIZE_109 ( type: esriFieldTypeString, alias: Inv (109) - Filter Size, length: 8 )
• COMMUNICATION_TYPE_7 ( type: esriFieldTypeString, alias: Inv (7) - Communication Type, length: 25 )
• COMMUNICATION_BRAND_8 ( type: esriFieldTypeString, alias: Inv (8) - Communication Sub-Type, length: 25 )
• COMM_INSTALLATION_DATE_9 ( type: esriFieldTypeDate, alias: Inv (9) - Communication Installation Date, length: 8 )
• SWITCHES_10 ( type: esriFieldTypeString, alias: Inv (10) - Switches, length: 10 )
• SUPPORT_TYPE_11 ( type: esriFieldTypeString, alias: Inv (11) - Support Type, length: 18 )
• CTVDMSSTRCT_INSTALL_DT_12 ( type: esriFieldTypeDate, alias: Inv (12) - CCTV Pole/DMS Structure Installation Date, length: 8 )
• NUMBER_OF_SUPPORTS_13 ( type: esriFieldTypeInteger, alias: Inv (13) - Number of Supports )
• POLE_HEIGHT_FT_14 ( type: esriFieldTypeInteger, alias: Inv (14) - Pole Height (ft) )
• BEAM_HEIGHT_FT_15 ( type: esriFieldTypeSingle, alias: Inv (15) - Beam Height (ft) )
• BEAM_TYPE_16 ( type: esriFieldTypeString, alias: Inv (16) - Beam Type, length: 8 )
• EMBEDMENT_DEPTH_FT_17 ( type: esriFieldTypeInteger, alias: Inv (17) - Embedment Depth (ft) )
• LOWERING_DEVICE_18 ( type: esriFieldTypeString, alias: Inv (18) - Lowering Device, length: 1 )
• NUMBER_OF_BEAMS_19 ( type: esriFieldTypeInteger, alias: Inv (19) - Number of Beams )
• NUMBER_OF_DESTINATIONS_20 ( type: esriFieldTypeInteger, alias: Inv (20) - Number of Destinations )
• LADDER_21 ( type: esriFieldTypeString, alias: Inv (21) - Ladder, length: 5 )
• WALK_IN_22 ( type: esriFieldTypeString, alias: Inv (22) - Walk In, length: 1 )
• ANCHOR_BOLTS_PER_RING_23 ( type: esriFieldTypeInteger, alias: Inv (23) - Number of Anchor Bolts per Ring )
• ANCHOR_BOLTS_TOTAL_24 ( type: esriFieldTypeInteger, alias: Inv (24) - Number of Anchor Bolts Total )
• ANCHOR_BOLT_DIAMETER_25 ( type: esriFieldTypeInteger, alias: Inv (25) - Anchor Bolt Diameter (in) )
• ANCHOR_BOLT_NUT_DIAM_26 ( type: esriFieldTypeInteger, alias: Inv (26) - Anchor Bolt Nut Diameter (in) )
• NUMBER_OF_SOLAR_PANELS_27 ( type: esriFieldTypeInteger, alias: Inv (27) - Number of Solar Panels )
• NUMBER_OF_BATTERIES_28 ( type: esriFieldTypeInteger, alias: Inv (28) - Number of Batteries )
• BATTERY_INSTALL_DATE_29 ( type: esriFieldTypeDate, alias: Inv (29) - Battery Installation Date, length: 8 )
• CAMERA_30 ( type: esriFieldTypeString, alias: Inv (30) - Camera, length: 1 )
• RADAR_31 ( type: esriFieldTypeString, alias: Inv (31) - Radar, length: 1 )
• SIGN_WITH_LED_ENHANCED_32 ( type: esriFieldTypeString, alias: Inv (32) - Sign with LED Enhanced, length: 1 )
• ATR_BRAND_NAME_33 ( type: esriFieldTypeString, alias: Inv (33) - ATR Brand Name, length: 10 )
• ATR_RADAR_TYPE_34 ( type: esriFieldTypeString, alias: Inv (34) - ATR Radar Type, length: 6 )
• INTERFACE_WITH_RM_35 ( type: esriFieldTypeString, alias: Inv (35) - Interface with Ramp Meter, length: 1 )
• BEACONS_36 ( type: esriFieldTypeString, alias: Inv (36) - Beacons, length: 1 )
• SITE_NUMBER_37 ( type: esriFieldTypeInteger, alias: Inv (37) - Site Number )
• COUNT_OF_COMPONENT_38 ( type: esriFieldTypeInteger, alias: Inv (38) - Count of Component )
• COMPONENT_TYPE_39 ( type: esriFieldTypeString, alias: Inv (39) - Component Type, length: 25 )
• COMPONENT_BRAND_40 ( type: esriFieldTypeString, alias: Inv (40) - Component Brand, length: 50 )
• NUMBER_OF_SENSORS_41 ( type: esriFieldTypeInteger, alias: Inv (41) - Number of Sensors )
• LANE_NUMBER_42 ( type: esriFieldTypeInteger, alias: Inv (42) - Lane Number )
• LANE_DIRECTION_43 ( type: esriFieldTypeString, alias: Inv (43) - Lane Direction, length: 2 )
• SERIAL_NUMBER_44 ( type: esriFieldTypeString, alias: Inv (44) - Serial Number, length: 30 )
• MAINLINE_DETECTION_45 ( type: esriFieldTypeString, alias: Inv (45) - Mainline Detection, length: 1 )
• MAINLINE_DETECTION_TYP_46 ( type: esriFieldTypeString, alias: Inv (46) - Mainline Detection Type, length: 5 )
• SIDE_STREET_DETECTION_47 ( type: esriFieldTypeString, alias: Inv (47) - Side Street Detection, length: 1 )
• SIDESTREET_DETECT_TYPE_48 ( type: esriFieldTypeString, alias: Inv (48) - Side Street Detection Type, length: 5 )
• REAR_FACING_BEACON_49 ( type: esriFieldTypeString, alias: Inv (49) - Rear-facing Beacon, length: 1 )
• SF_CONTROLLER_TYPES_50 ( type: esriFieldTypeString, alias: Inv (50) - School Flasher Controller Types, length: 50 )
• FLASH_TYPE_51 ( type: esriFieldTypeString, alias: Inv (51) - Flash Type, length: 7 )
• SPANWIRE_CONFIGURATION_52 ( type: esriFieldTypeString, alias: Inv (52) - Spanwire Configuration, length: 14 )
• VISOR_TYPE_53 ( type: esriFieldTypeString, alias: Inv (53) - Visor Type, length: 7 )
• DETECTION_TYPE_54 ( type: esriFieldTypeString, alias: Inv (54) - Detection Type, length: 10 )
• DIST_GORE_TO_UPSTREAM_55 ( type: esriFieldTypeInteger, alias: Inv (55) - Distance From Gore to Upstream Radar )
• DIST_GORE_TO_DWNSTREAM_56 ( type: esriFieldTypeInteger, alias: Inv (56) - Distance From Gore to Downstream Radar )
• DIST_ART_TO_STOP_LINE_57 ( type: esriFieldTypeInteger, alias: Inv (57) - Distance From Arterial to Stop Line )
• DIST_QUEUE_LOOP_STOP_58 ( type: esriFieldTypeInteger, alias: Inv (58) - Distance From Queue Loop to Stop Line )
• DIST_ART_TO_QUEUE_LOOP_59 ( type: esriFieldTypeInteger, alias: Inv (59) - Distance From Arterial to Queue Loop )
• DIST_STOP_LINE_TO_GORE_60 ( type: esriFieldTypeInteger, alias: Inv (60) - Distance From Stop Line to Gore )
• ACCELERATION_LENGTH_61 ( type: esriFieldTypeInteger, alias: Inv (61) - Acceleration Length )
• NUMBER_OF_METERED_LANE_62 ( type: esriFieldTypeInteger, alias: Inv (62) - Number of Metered Lanes )
• LANES_MAINLINE_BY_RM_63 ( type: esriFieldTypeInteger, alias: Inv (63) - Number of Lanes on Mainline by RM )
• MAINLINE_LANES_DETECT_64 ( type: esriFieldTypeInteger, alias: Inv (64) - Number of Lanes on Mainline by Detection )
• RM_SIGNAL_SUPPORT_TYPE_65 ( type: esriFieldTypeString, alias: Inv (65) - Signal Support Type, length: 10 )
• SIGNAL_MOUNTING_TYPE_66 ( type: esriFieldTypeString, alias: Inv (66) - Signal Mounting Type, length: 12 )
• VSH_FOR_RAMP_TRAFFIC_67 ( type: esriFieldTypeInteger, alias: Inv (67) - Number of VSHs for Ramp Traffic )
• VSH_FOR_ENFORCEMENT_68 ( type: esriFieldTypeInteger, alias: Inv (68) - Number of VSHs for Enforcement )
• CONTROLLER_TYPE_69 ( type: esriFieldTypeString, alias: Inv (69) - Controller Type, length: 30 )
• DETECTOR_INPUT_70 ( type: esriFieldTypeString, alias: Inv (70) - Detector Input, length: 8 )
• DETECTOR_TYPE_STOPLINE_71 ( type: esriFieldTypeString, alias: Inv (71) - Stop Line Detector Type, length: 5 )
• DETECTOR_TYPE_QUEUE_72 ( type: esriFieldTypeString, alias: Inv (72) - Queue Detector Type, length: 5 )
• STOP_LINE_73 ( type: esriFieldTypeString, alias: Inv (73) - Stop Line, length: 6 )
• ONE_VEHICLE_GREEN_SIGN_74 ( type: esriFieldTypeString, alias: Inv (74) - One Vehicle Per Green Sign (R10-28), length: 1 )
• STOP_HERE_ON_RED_SIGN_75 ( type: esriFieldTypeString, alias: Inv (75) - Stop Here on Red Sign (R10-6), length: 1 )
• ONE_VEHICLE_LANE_SIGN_76 ( type: esriFieldTypeString, alias: Inv (76) - One Vehicle Per Green Per Lane Sign (R10-H29A), length: 1 )
• FORM_TWO_LANES_SIGN_77 ( type: esriFieldTypeString, alias: Inv (77) - Form Two Lanes Sign (Special - No Code), length: 1 )
• RADAR_BREAKOUT_BOX_COM_78 ( type: esriFieldTypeString, alias: Inv (78) - Radar Breakout Box Communication Type, length: 8 )
• PART_OF_SIGNAL_SYSTEM_79 ( type: esriFieldTypeString, alias: Inv (79) - Part of Signal System, length: 3 )
• MASTERCABINET_LOCATION_80 ( type: esriFieldTypeString, alias: Inv (80) - Master Cabinet Location, length: 50 )
• MULTI_JURIS_CORRIDOR_81 ( type: esriFieldTypeString, alias: Inv (81) - Multi-Jurisdiction Corridor, length: 3 )
• WRITTEN_AGREEMENT_82 ( type: esriFieldTypeString, alias: Inv (82) - Written Agreement in Place, length: 3 )
• SIGN_CODE_83 ( type: esriFieldTypeString, alias: Inv (83) - Sign Code, length: 7 )
• CONTROLLER_MAKE_MODEL_84 ( type: esriFieldTypeString, alias: Inv (84) - Controller Make & Model, length: 52 )
• CONTROLLER_SERIAL_NUM_85 ( type: esriFieldTypeString, alias: Inv (85) - Controller Serial Number, length: 30 )
• MONITOR_MAKE_MODEL_86 ( type: esriFieldTypeString, alias: Inv (86) - Monitor Make & Model, length: 11 )
• MONITOR_SERIAL_NUMBER_87 ( type: esriFieldTypeString, alias: Inv (87) - Monitor Serial Number, length: 30 )
• UPS_MAKE_88 ( type: esriFieldTypeString, alias: Inv (88) - UPS Make, length: 10 )
• UPS_SERIAL_NUMBER_89 ( type: esriFieldTypeString, alias: Inv (89) - UPS Serial Number, length: 30 )
• UPS_BATTERY_TYPE_90 ( type: esriFieldTypeString, alias: Inv (90) - UPS Battery Type, length: 11 )
• UPS_BATT_INSTALL_DATE_91 ( type: esriFieldTypeDate, alias: Inv (91) - UPS Battery Installation Date, length: 8 )
• TETHERED_92 ( type: esriFieldTypeString, alias: Inv (92) - Tethered, length: 1 )
• BACKPLATES_93 ( type: esriFieldTypeString, alias: Inv (93) - Backplates, length: 1 )
• BACKPLATES_DIRECTION_94 ( type: esriFieldTypeString, alias: Inv (94) - Backplates Direction, length: 23 )
• ADVNCEWARNING_SIGNCODE_95 ( type: esriFieldTypeString, alias: Inv (95) - Advanced Warning Sign Code, length: 7 )
• ADVNCEWARNING_BEACON_96 ( type: esriFieldTypeString, alias: Inv (96) - Advanced Warning Beacon, length: 1 )
• ADVNCEWARNING_LED_97 ( type: esriFieldTypeString, alias: Inv (97) - Advanced Warning LED Enhanced, length: 1 )
• LED_INSTALLATION_DATE_98 ( type: esriFieldTypeDate, alias: Inv (98) - LED Installation/Re-lamp Date, length: 8 )
• PED_SIGNAL_HEADS_99 ( type: esriFieldTypeString, alias: Inv (99) - Pedestrian Signal Heads, length: 1 )
• PED_SIGNAL_HEADS_QTY_100 ( type: esriFieldTypeInteger, alias: Inv (100) - Pedestrian Signal Heads Quantity )
• FLASHING_YELLOW_ARROW_101 ( type: esriFieldTypeString, alias: Inv (101) - Flashing Yellow Arrow, length: 1 )
• BLANKOUT_SIGN_102 ( type: esriFieldTypeString, alias: Inv (102) - Blankout Sign, length: 1 )
• BLANKOUT_SIGN_QTY_103 ( type: esriFieldTypeInteger, alias: Inv (103) - Blankout Sign Quantity )
• BLANKOUT_SIGN_DIR_104 ( type: esriFieldTypeString, alias: Inv (104) - Blankout Sign Direction, length: 23 )
• BLANKOUT_INSTALL_DATE_105 ( type: esriFieldTypeDate, alias: Inv (105) - Blankout Installation Date, length: 8 )
• NUMBER_OF_STOP_LINE_106 ( type: esriFieldTypeInteger, alias: Inv (106) - Number of Stop Line )
• NUMBER_DILEMMA_ZONE_107 ( type: esriFieldTypeInteger, alias: Inv (107) - Number Dilemma Zone )
• INVENTORY_COMMENTS_108 ( type: esriFieldTypeString, alias: Inv (108) - Inventory Comments, length: 2500 )
• 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 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• COLLECTOR.ITS_DEVICE_SI_ELEMENT_INVENTORY (12) -- Related To: ITS Device SI Element Inventory - Viewer (27)
• COLLECTOR.ITS_DEVICE_INSPECTION (10) -- Related To: ITS Device Inspection - Viewer (21)
• COLLECTOR.ITS_MAINTENANCE (11) -- Related To: ITS Maintenance - Viewer (23)

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

  Iteminfo   Thumbnail   Metadata