Layer: Signs (ID:1)

View In: Map Viewer

Name: Signs

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"59e8a01a-0dfb-4916-9f1c-6ef2a4fae091","imageData":"iVBORw0KGgoAAAANSUhEUgAAACMAAAAsCAYAAADvjwGMAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA4UlEQVRYhc3YwYmEMBiG4TfwNaGerWC3CcERqxjbmBpyEfZoCfYxbcQysmSYgQX3HL/nFMjhfwk5/cKIMCJcY3LOtxjjvcbgvu8ZhuERQnieYnLOX9M07U3T1Ghh2zbWdR1zzt+foL8v06aU2Pe9SkzRdd1rLnCKuZwwIowII8KIMCKMCCPCiDAijAgjwogwIowII8KIMCKMCCPCiDAijAgjwogwIowII8KIMCKMCCPCNObZti3LslQZfBwH4ziWYzrFhBBS2a/FGB81YuZ5LgvGn38XjO+gcnHjIrZ/hqv9ApcELUu2iKY5AAAAAElFTkSuQmCC","contentType":"image/png","width":26,"height":33,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: globalid

Type ID Field: code

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
assetid (type: esriFieldTypeString, alias: Sign 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: Sign Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Regulatory: Regulatory], [Warning: Warning], [Guide: Guide], ... 2 more ...)
code (type: esriFieldTypeString, alias: MUTCD Code, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true, Coded Values: [R2-6bP: $XX Fine (plaque) - (R2-6bP)], [D9-20aP: 24-Hour (plaque) - (D9-20aP)], [W1-15: 270-degree Loop - (W1-15)], ... 737 more ...)
text (type: esriFieldTypeString, alias: Sign Text, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
color (type: esriFieldTypeString, alias: Sign Primary Color, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Black: Black], [Blue: Blue], [Brown: Brown], ... 7 more ...)
sheeting (type: esriFieldTypeString, alias: Sign Sheeting Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Type I (Engineer Grade): Type I (Engineer Grade)], [Type II (Super Engineer Grade): Type II (Super Engineer Grade)], [Type V (Metallized Microprismatic): Type V (Metallized Microprismatic)], ... 10 more ...)
substrate (type: esriFieldTypeString, alias: Sign Substrate, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Aluminum: Aluminum], [Plastic: Plastic], [Wood: Wood], ... 2 more ...)
supplemental (type: esriFieldTypeString, alias: Supplemental Plaque, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
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)
signheight (type: esriFieldTypeDouble, alias: Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
signwidth (type: esriFieldTypeDouble, alias: Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
dimunits (type: esriFieldTypeString, alias: Sign Dimension Units, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Inches: Inches], [Centimeters: Centimeters])
lateraloffset (type: esriFieldTypeDouble, alias: Lateral Offset, SQL Type: sqlTypeOther, nullable: true, editable: true)
latoffsetunits (type: esriFieldTypeString, alias: Lateral Offset Units, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Feet: Feet], [Meters: Meters])
mountheight (type: esriFieldTypeDouble, alias: Mounting Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
mountunits (type: esriFieldTypeString, alias: Mounting Height Units, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Feet: Feet], [Meters: Meters])
facingdirection (type: esriFieldTypeString, alias: Facing Direction, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [East: East], [North: North], [South: South], ... 9 more ...)
angle (type: esriFieldTypeDouble, alias: Angle, SQL Type: sqlTypeOther, nullable: true, editable: true)
curbregulations (type: esriFieldTypeString, alias: Curb Regulations, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
regdirection (type: esriFieldTypeString, alias: Regulation Direction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Left: Left], [Right: Right], [Double: Double], ... 1 more ...)
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 ...)
reflectivity (type: esriFieldTypeSmallInteger, alias: Sign Reflectivity, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Fail], [1: Marginal], [2: Adequate])
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)
poleglobalid (type: esriFieldTypeGUID, alias: Pole GlobalID, SQL Type: sqlTypeOther, length: 38, 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)
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)
AttachedToSignal (type: esriFieldTypeString, alias: Attached to Signal, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])

Types:

code: Other

code: W4-3

code: R3-8

code: M5-1

code: M5-2

code: W3-3

code: R1-3P

code: M4-1

code: M4-1a

code: EM-2

code: W11-1

code: W8-1

code: I-6

code: M4-3

code: M4-2

code: D9-3

code: M3-1

code: M3-2

code: M3-3

code: M3-4

code: W1-8

code: M2-2

code: R5-4

code: M1-6

code: W14-1

code: D1-1

code: D9-11

code: W8-2

code: M6-1

code: M6-2

code: M6-3

code: M6-4

code: M6-5

code: M6-6

code: M6-7

code: W6-1

code: W6-2

code: R10-7

code: R5-1

code: R4-1

code: W12-1

code: D9-11b

code: D9-13

code: R8-4

code: W11-8

code: W11-7

code: W11-5

code: D9-8

code: M1-7

code: D9-7

code: D9-6

code: W11-9

code: W7-1

code: W1-1

code: W1-2

code: W1-3

code: W1-4

code: W1-5

code: D9-2

code: D10-1a

code: D10-2a

code: D10-3a

code: W2-1

code: W2-2

code: W2-3

code: W2-4

code: W2-5

code: M1-1

code: M2-1

code: R4-8

code: R4-8a

code: R11-1

code: R4-7

code: R4-7a

code: W11-3

code: W11-4

code: I-8

code: D9-9

code: W8-9

code: R3-5

code: RS-053

code: W4-1

code: R3-1

code: R3-2

code: R3-3

code: R3-4

code: W5-2

code: R9-4

code: R9-4a

code: R5-6

code: R5-3

code: W14-2

code: R8-3

code: R8-3a

code: R7-107a

code: R7-1

code: R7-107

code: R7-3

code: R7-6

code: W14-3

code: R9-3

code: R9-3a

code: R7-4

code: R5-2

code: R10-11a

code: M1-2

code: W1-6

code: R6-1

code: R6-2

code: R3-6

code: D4-2

code: D4-1

code: R4-2

code: W8-3

code: W11-2

code: R10-2

code: W15-1

code: D9-15

code: D10-1

code: D10-2

code: D10-3

code: R7-8

code: D5-2a

code: R11-2

code: R11-4

code: W5-1

code: W8-8

code: W8-17

code: W8-5

code: R4-3

code: W11-6

code: W8-4

code: R2-1

code: M1-5

type: Regulatory
code: R1-1
text: STOP
color: Red

code: R10-6

code: D9-1

code: R7-201P

code: R7-201aP

code: D9-3a

code: I-7

code: W11-10

code: R14-1

code: W1-7

code: R3-9b

code: W6-3

code: M1-4

code: R9-3bP

code: W16-13P

code: R5-1a

code: R1-2

code: D3-1

Relationships:

Maintenance (3) -- Related To: Sign Maintenance (6)
Pole (4) -- Related To: Poles (4)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/22/2025 9:38:49 PM

Schema Last Edit Date: 7/22/2025 9:38:49 PM

Data Last Edit Date: 7/22/2025 9:38:49 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Query Related Records Query Attachments Add Features Update Features Delete Features Apply Edits Calculate Generate Renderer Validate SQL Get Estimates ConvertFormat