All Layers and Tables (Signal_mainthistory_78642165a8a54b6aaf6154a9450d4fcb)

Layers:

Layer: Signal_mainthistory (0)

Name:

Display Field:

Type:

Geometry Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"5a21158c-a5ac-49c4-a6ce-f07ecff0e1a6","imageData":"iVBORw0KGgoAAAANSUhEUgAAABMAAAA6CAYAAABS82IyAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAE5klEQVRYhe2WXWxTZRiAn7anw65dR8dapvtjG25j/MRkEGKADUERZUF02Y0mXmlQL8ToBSFeOE28wIhGE6+USGJIDAQwupiMRTck/IWAKBsbMja2bqOj+2nPaenanR/Tw9gY7enK8MJE3+QkzXfePnm/9/2+J0fgHwzhf9j8erZ9+/ZGVVU/MEpSZBmLkLy9gbFxhgYGP+zpv9E4nRGNxpicnJxOCokiIUkiWxBwOzL1te6AiCMrC4fTOZ03MTExu7J7IxaNEhwfZ1tZCQ1bNlEZva2vmzLtjNhsHL5wif3tnbjz8rBYLInbvBfk9/n4om4r62MRlLMnmRwZmX4fr2fnug3Ubt3MK03N5BcXG8PiFemg4CjyxQtJeySfOkm5x82e4kfZ5/Nhy8xMhMWrKsmyU+N0EGs9TqpQb/l5qbSUI8OjeGOxJLBYlI2lJajePtKKkESVI5PrgVAiTJEVqjxulMsX02JpkkSNK1evDkz3wRR5emoaM003DMGauHT3h8Ui4A+HMd3T0NQwAX9sUj8eiqLOhjmcWRy+3EH9jjqUrs45WSaXiyPX+rHZ7YREKbGyXinMCe8A61esRGm/bAgye9wcFcN4LVYyMjIStxmPHLebd5p/5bPlS9lQVIg6dBNkeaYa2yN6RSex8EnvkH4LIuFwclh8/3kFBbzb0c2O3IXUFxRSaTaBPKk3vEvV9On9FAiR7XKlvk53gfFr0iqK/HS1j2xNJdd6J+26rOonPi8/P+n29az2S39isZiTJowB/lhkuopQ3CaiaAxb8cQqVPXOeOfpM2Zt09BnWRqeXCvE4FqvPD+f1W1x0LCjnKrHpm6G1Yo/LHDoqI9vDg6m77Mv9y6ldpmCNupF670jRw1YBLxVX0Ttk05efuPa3D7TQY9PoA3cTNojbaCfCoeT3TtdfH4ghc9Ki0xsrF6A+lcvqcISEql/ysOxZgmv38hnT7vQxGBK0N2wxCZYVpbB9YGogc8qnWjBYdIJczTChjUOjh6XUvjMakWLzA3TzLMnmeizkUlYkig9I5h/XEnhsx98NGyrRBud27SKzc6xZr+xz3r6NVrPiNQuXQx+494pDidHWifw+hek9tmuPT3se99DzfJFCGIAk6rMbM1q1Stqazfx6f5Aej577+MBXticyYvPuqgqMuvAeI+u9Ksc+16i6UTswXzWdlGk6cQoTruM2zXlswGmfOaen8/GgzAyFv0X+szmWED2IifI4Ovzz89n1ZtWsq5uLZbCLH3dZrFikWTafjxN26FT6fvs9Y9exbbSTWfIz9h9521Nw2oq15bz1a6v5/ZZHGSqWsj5seRfQ+fH+vDk2Fn3Wg3nvztn7DN3QQ751cU0+1J/HtyKhSnbXEFnSweRkYnkPltdu4KhSHo+k+QY7jI33YPdyX1WWF7AYCSQJixKcXUJV1o6jH0Wn1o6IZgTD/ksawRHRWwVeWnBrCYzgfGwsc9ONZ3j7efepDs0t89cVhtnWjqMfTbsvUnX2atUVi2mSzL2mSfDTu8vV/VJpvTZt40HeX53HcWrFjMYlZC1mTtrMwt6RdIfPs4eOJ2ez37e20TFpkqWPbMcx5IcZFXVGx66MUZ7yyW6f+t+MJ/5fh/W/yRkCthddv1dcDD4cN9niihze2pqafmsp/9GIxB/HiqEhwXw34P9DVgTdGkrwOLyAAAAAElFTkSuQmCC","contentType":"image/png","width":14,"height":43,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

assetid (type: esriFieldTypeString, alias: Signal ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
intersectionid (type: esriFieldTypeString, alias: Intersection ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
type (type: esriFieldTypeString, alias: Signal Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Doghouse 5 R, left Y, Y, left G, G: Doghouse 5 R, left Y, Y, left G, G], [Doghouse 5 RY, right Y, G, right G: Doghouse 5 RY, right Y, G, right G], [Horizontal 3 RYG: Horizontal 3 RYG], ... 27 more ...)
bulb (type: esriFieldTypeString, alias: Signal Bulb Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Halogen: Halogen], [Incandescent: Incandescent], [LED: LED], ... 2 more ...)
manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
warrantydate (type: esriFieldTypeDate, alias: Warranty Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
mountmethod (type: esriFieldTypeString, alias: Mounting Method, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Mast Arm: Mast Arm], [Pedestal: Pedestal], [Span Wire: Span Wire], ... 4 more ...)
mountheight (type: esriFieldTypeDouble, alias: Mounting Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
mountunits (type: esriFieldTypeString, alias: Mounting Height Units, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Feet: Feet], [Meters: Meters])
approachdirection (type: esriFieldTypeString, alias: Approach Direction, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [North: North], [South: South], [East: East], ... 5 more ...)
backplate (type: esriFieldTypeString, alias: Backplate, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
preemption (type: esriFieldTypeString, alias: Preemption, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
tsp (type: esriFieldTypeString, alias: Transit Signal Priority, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
locdesc (type: esriFieldTypeString, alias: Nearest Location, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
municipality (type: esriFieldTypeString, alias: Municipality, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
district (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
ownedby (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
maintainedby (type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
collectedby (type: esriFieldTypeSmallInteger, alias: Collected By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
inspectdate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
condition (type: esriFieldTypeSmallInteger, alias: Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: Very Good], [4: Good], [3: Fair], ... 3 more ...)
maintenance (type: esriFieldTypeString, alias: Needs Maintenance, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
replacement (type: esriFieldTypeString, alias: Needs Replacement, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
retired (type: esriFieldTypeString, alias: Is Retired, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
created_user (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
created_date (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
last_edited_user (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
last_edited_date (type: esriFieldTypeDate, alias: Last Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
poleglobalid (type: esriFieldTypeGUID, alias: Pole GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
cabinetglobalid (type: esriFieldTypeGUID, alias: Cabinet GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
esrignss_positionsourcetype (type: esriFieldTypeSmallInteger, alias: Position source type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: User defined], [2: Integrated (System) Location Provider], ... 2 more ...)
esrignss_receiver (type: esriFieldTypeString, alias: Receiver Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
esrignss_latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
esrignss_longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
esrignss_altitude (type: esriFieldTypeDouble, alias: Altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
esrignss_h_rms (type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
esrignss_v_rms (type: esriFieldTypeDouble, alias: Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
esrignss_fixdatetime (type: esriFieldTypeDate, alias: Fix Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
esrignss_fixtype (type: esriFieldTypeSmallInteger, alias: Fix Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Fix not valid], [1: GPS], [2: Differential GPS], ... 2 more ...)
esrignss_correctionage (type: esriFieldTypeDouble, alias: Correction Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
esrignss_stationid (type: esriFieldTypeSmallInteger, alias: Station ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
esrignss_numsats (type: esriFieldTypeSmallInteger, alias: Number of Satellites, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 99])
esrignss_pdop (type: esriFieldTypeDouble, alias: PDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
esrignss_hdop (type: esriFieldTypeDouble, alias: HDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
esrignss_vdop (type: esriFieldTypeDouble, alias: VDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
esrignss_direction (type: esriFieldTypeDouble, alias: Direction of travel (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
esrignss_speed (type: esriFieldTypeDouble, alias: Speed (km/h), SQL Type: sqlTypeOther, nullable: true, editable: true)
esrisnsr_azimuth (type: esriFieldTypeDouble, alias: Compass reading (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
esrignss_avg_h_rms (type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
esrignss_avg_v_rms (type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
esrignss_avg_positions (type: esriFieldTypeInteger, alias: Averaged Positions, SQL Type: sqlTypeOther, nullable: true, editable: true)
esrignss_h_stddev (type: esriFieldTypeDouble, alias: Standard Deviation (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
mainttype (type: esriFieldTypeString, alias: Maintenance type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Signal Repair: Signal Repair], [Signal Replacement: Signal Replacement], [Bulb Replacement: Bulb Replacement], ... 1 more ...)
maintdate (type: esriFieldTypeDate, alias: Maintenance date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
status (type: esriFieldTypeString, alias: Maintenance status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [In Progress: In Progress], [Completed: Completed], [Paused: Paused], ... 1 more ...)
notes_1695295137748 (type: esriFieldTypeString, alias: Maintenance notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
created_user_1695295137748 (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
created_date_1695295137748 (type: esriFieldTypeDate, alias: Created On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
last_edited_user_1695295137748 (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
last_edited_date_1695295137748 (type: esriFieldTypeDate, alias: Last Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
assetglobalid (type: esriFieldTypeGUID, alias: Signal GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
globalid_1695295137748 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Templates:

type: Other
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Vertical 3 RYG
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Vertical 3 left RYG
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Vertical 4 RRYG
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Vertical 4 RY, straight G, left G
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Vertical 4 RYG, left G
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Vertical 5 RY, straight G, left G, right G
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Vertical 5 RYG, left YG
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Vertical 5 RYG, right YG
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Horizontal 3 RYG
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Horizontal 3 left RYG
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Horizontal 4 RRYG
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Horizontal 4 RY, left G, G
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Horizontal 4 RY, left G, straight G
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Horizontal 5 R, left YG, right YG
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Horizontal 5 RY, left G, straight G, right G
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Horizontal 5 RY, left Y, left G, G
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Horizontal 5 RY, left YG, straight G
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Doghouse 5 R, left Y, Y, left G, G
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Doghouse 5 RY, right Y, G, right G
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: T 4 RRYG
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Emergency-vehicle
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Flashing beacon
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Freeway entrance ramp control
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Hybrid beacon
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: In-roadway light
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Lane-use control
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: One-lane two-way control
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Pedestrian
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

type: Toll plaza
mountunits: Feet
ownedby: 0
maintainedby: 0
collectedby: 0
maintenance: No
replacement: No
retired: No

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date: