Name: TrafficSignPole

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text: Traffic Engineering

Min. Scale: 20000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 508666.311739586
YMin: 1554828.68532784
XMax: 643721.642350171
YMax: 1637342.59018159
Spatial Reference: 102658 (2236)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[85,255,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• AssetID (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 12, nullable: false, editable: true)
• LaneDirection (type: esriFieldTypeString, alias: Lane Direction, SQL Type: sqlTypeOther, length: 2, nullable: false, editable: true, Coded Values: [NB: NB], [SB: SB], [EB: EB], ... 1 more ...)
• PostType (type: esriFieldTypeString, alias: Post Type, SQL Type: sqlTypeOther, length: 18, nullable: false, editable: true, Coded Values: [UCHANNEL: U-Channel], [ROUNDSTEEL: Round Steel], [ROUNDALUM: Round Aluminium], ... 3 more ...)
• PostInvNo (type: esriFieldTypeString, alias: Post Inventory, SQL Type: sqlTypeOther, length: 24, nullable: false, editable: true, Coded Values: [OTHER: Other - see notes], [TP1-10: 10 ft U Channel Post], [TP1-12A: 2' X 12 ft Rnd Post], ... 5 more ...)
• PostCondition (type: esriFieldTypeString, alias: Post Condition, SQL Type: sqlTypeOther, length: 10, nullable: false, editable: true, Coded Values: [Good: Good], [Replace: Replace], [New: New], ... 3 more ...)
• SignNumber (type: esriFieldTypeSmallInteger, alias: No of Signs, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 5 more ...)
• Sign1Type (type: esriFieldTypeString, alias: Sign 1 type, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true, Coded Values: [OTHER: Other- see notes], [GUIDE: Guide], [HARDWARE: Hardware], ... 11 more ...)
• Sign1Condition (type: esriFieldTypeString, alias: Sign 1 Condition, SQL Type: sqlTypeOther, length: 10, nullable: false, editable: true, Coded Values: [Good: Good], [Replace: Replace], [New: New], ... 3 more ...)
• Sign1Direction (type: esriFieldTypeString, alias: Sign 1 Direction, SQL Type: sqlTypeOther, length: 2, nullable: false, editable: true, Coded Values: [E: E], [W: W], [N: N], ... 2 more ...)
• Sign1InstalDate (type: esriFieldTypeDate, alias: Sign 1 Instal, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: true)
• Sign1Grade (type: esriFieldTypeString, alias: Sign 1 grade, SQL Type: sqlTypeOther, length: 16, nullable: false, editable: true, Coded Values: [ENG: Engineer], [HI: High Intensity], [PRISM: Prismatic])
• Sign2type (type: esriFieldTypeString, alias: Sign 2 type, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true, Coded Values: [OTHER: Other- see notes], [GUIDE: Guide], [HARDWARE: Hardware], ... 11 more ...)
• Sign2Conditiion (type: esriFieldTypeString, alias: Sign 2 Condition, SQL Type: sqlTypeOther, length: 10, nullable: false, editable: true, Coded Values: [Good: Good], [Replace: Replace], [New: New], ... 3 more ...)
• Sign2Direction (type: esriFieldTypeString, alias: Sign 2 Direction, SQL Type: sqlTypeOther, length: 2, nullable: false, editable: true, Coded Values: [E: E], [W: W], [N: N], ... 2 more ...)
• Sign2InstalDate (type: esriFieldTypeDate, alias: Sign 2 Instal, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Sign2Grade (type: esriFieldTypeString, alias: Sign 2 grade, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true, Coded Values: [ENG: Engineer], [HI: High Intensity], [PRISM: Prismatic])
• Sign3Type (type: esriFieldTypeString, alias: Sign 3 type, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true, Coded Values: [OTHER: Other- see notes], [GUIDE: Guide], [HARDWARE: Hardware], ... 11 more ...)
• Sign3Condition (type: esriFieldTypeString, alias: Sign 3 Condition, SQL Type: sqlTypeOther, length: 10, nullable: false, editable: true, Coded Values: [Good: Good], [Replace: Replace], [New: New], ... 3 more ...)
• Sign3Direction (type: esriFieldTypeString, alias: Sign 3 Direction, SQL Type: sqlTypeOther, length: 2, nullable: false, editable: true, Coded Values: [E: E], [W: W], [N: N], ... 2 more ...)
• Sign3InstalDate (type: esriFieldTypeDate, alias: Sign 3 Instal, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Sign3Grade (type: esriFieldTypeString, alias: Sign 3 grade, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true, Coded Values: [ENG: Engineer], [HI: High Intensity], [PRISM: Prismatic])
• Sign4Type (type: esriFieldTypeString, alias: Sign 4 Type, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true, Coded Values: [OTHER: Other- see notes], [GUIDE: Guide], [HARDWARE: Hardware], ... 11 more ...)
• Sign4Condition (type: esriFieldTypeString, alias: Sign 4 Condition, SQL Type: sqlTypeOther, length: 10, nullable: false, editable: true, Coded Values: [Good: Good], [Replace: Replace], [New: New], ... 3 more ...)
• Sign4Direction (type: esriFieldTypeString, alias: Sign 4 Direction, SQL Type: sqlTypeOther, length: 2, nullable: false, editable: true, Coded Values: [E: E], [W: W], [N: N], ... 2 more ...)
• Sign4InstalDate (type: esriFieldTypeDate, alias: Sign 4 Instal, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Sign4Grade (type: esriFieldTypeString, alias: Sign 4 grade, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true, Coded Values: [ENG: Engineer], [HI: High Intensity], [PRISM: Prismatic])
• PhotoID (type: esriFieldTypeString, alias: Photo ID, SQL Type: sqlTypeOther, length: 15, nullable: false, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• Inspector (type: esriFieldTypeString, alias: Inspector, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true, Coded Values: [GA: Gibson Andre], [BC: Ben Chisolm], [DW: Darren Worthey], ... 6 more ...)
• Colldate (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CrossStreet (type: esriFieldTypeString, alias: CrossStreet, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TrafficSignSize (type: esriFieldTypeString, alias: Odd Size, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [18x24: 18x24], [18x30: 18x30], [24x30: 24x30], ... 5 more ...)
• PhotoPath (type: esriFieldTypeString, alias: Photo Link, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• XCoordinate (type: esriFieldTypeDouble, alias: XCoordinate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YCoordinate (type: esriFieldTypeDouble, alias: YCoordinate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Sign1Code (type: esriFieldTypeString, alias: Sign1Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Sign2Code (type: esriFieldTypeString, alias: Sign2Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Sign3Code (type: esriFieldTypeString, alias: Sign3Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Sign4Code (type: esriFieldTypeString, alias: Sign4Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SignCategory (type: esriFieldTypeString, alias: SignCategory, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Animal: Animal], [BumpHump: Bump or Hump], [Chevrons: Chevrons], ... 10 more ...)
• District (type: esriFieldTypeSmallInteger, alias: District, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IDNumberOnly (type: esriFieldTypeInteger, alias: IDNumberOnly, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InitialEnteredDate (type: esriFieldTypeDate, alias: InitialEnteredDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• InitialEnteredUserLoginID (type: esriFieldTypeString, alias: InitialEnteredUserLoginID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LastUpdateDate (type: esriFieldTypeDate, alias: LastUpdateDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LastUpdateLoginID (type: esriFieldTypeString, alias: LastUpdateLoginID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ChangesMade (type: esriFieldTypeString, alias: ChangesMade, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Relocated: Sign Relocated], [Moved: Moved for Accuracy], [Decommissioned: Decommissioned - Delete], ... 2 more ...)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: TrafficSignPole
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• PostType: UCHANNEL
• PostInvNo: TP1-12
• PostCondition: Good
• Sign2type: NONE
• Sign2Conditiion: NA
• Sign3Type: NONE
• Sign3Condition: NA
• Sign4Type: NONE
• Sign4Condition: NA
• PhotoID: 0
• Notes: N
• AssetID: 0
• SignNumber: 1
• Sign1Condition: Good
• Sign2Direction: NA
• Sign3Direction: NA
• Sign4Direction: NA
• Inspector: TE
• TrafficSignSize: None

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/21/2026 2:48:35 PM

Schema Last Edit Date: 7/8/2025 8:08:06 PM

Data Last Edit Date: 7/21/2026 2:48:35 PM

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