Layer: Signs (ID:0)

View In: Map Viewer

Name: Signs

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPoint

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":"esriSMS","style":"esriSMSCircle","color":[135,72,67,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"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:

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: Sign ID, SQL Type: sqlTypeOther, length: 50, 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 1, 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 ...)
facing (type: esriFieldTypeString, alias: Facing Direction, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [East: East], [North: North], [South: South], ... 9 more ...)
lateraloffset (type: esriFieldTypeDouble, alias: Lateral Offset (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
mountheight (type: esriFieldTypeDouble, alias: Mounting Ht. (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
locdesc (type: esriFieldTypeString, alias: Nearest Location, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
inspectdate (type: esriFieldTypeDate, alias: Inspected On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
condition (type: esriFieldTypeSmallInteger, alias: Overall Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: Very Good], [4: Good], [3: Fair], ... 4 more ...)
maintenance (type: esriFieldTypeString, alias: Needs Maintenance, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [TBD: To be Determined])
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)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
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)
PoleDamaged (type: esriFieldTypeString, alias: Pole Damaged?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
PoleCorrosion (type: esriFieldTypeString, alias: Pole Corrosion?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
PoleAppearance (type: esriFieldTypeString, alias: Pole Appearance, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Good: Good (No Apparent Damage or Paint Loss)], [Fair: Fair (Corrison < 20%)], [Poor: Poor (Corrison > 20% w/ Pitting or Other Damage)])
PoleBaseCover (type: esriFieldTypeString, alias: Pole Base Cover, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Attached: Attached], [Detached: Detached], [Damaged: Damaged], ... 1 more ...)
PoleBaseMountingBracket (type: esriFieldTypeString, alias: Pole Base Mounting Bracket, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Corrosion: Corrosion (> 20%)], [Damaged: Damaged], [Damaged and Corrison: Damaged and Corrison (> 20%)], ... 1 more ...)
SignCovering (type: esriFieldTypeString, alias: Sign Covering, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Good: Good], [Peeling: Peeling], [Faded: Faded], ... 2 more ...)
SignSubstrate (type: esriFieldTypeString, alias: Sign Substrate, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Damaged: Damaged], [Corrosion: Corrosion], [Damaged with Corrosion: Damaged with Corrosion], ... 1 more ...)
SignAppearance (type: esriFieldTypeString, alias: Sign Appearance, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Good: Good (No Structural Damage and Intact Covering)], [Fair: Fair (Minor/Edge Peeling of Covering <10%)], [Poor: Poor (Damaged or Cover/Message Peeling >10%)])
SignDirectional (type: esriFieldTypeString, alias: Sign Directional?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
SignText2 (type: esriFieldTypeString, alias: Sign Text 2, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
SignText3 (type: esriFieldTypeString, alias: Sign Text 3, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
SignText4 (type: esriFieldTypeString, alias: Sign Text 4, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
SignMaterial (type: esriFieldTypeString, alias: Sign Material, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Good: Good], [Needs Maintenance: Needs Maintenance], [Damaged: Damaged])
WayfindingType (type: esriFieldTypeString, alias: Wayfinding Sign Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Gateway: Gateway], [Arterial Directional: Arterial Directional], [Downtown Directional: Downtown Directional], ... 1 more ...)
height_in (type: esriFieldTypeDouble, alias: Height (in), SQL Type: sqlTypeOther, nullable: true, editable: true)
width_in (type: esriFieldTypeDouble, alias: Width (in), SQL Type: sqlTypeOther, nullable: true, editable: true)
CouncilDistrict (type: esriFieldTypeSmallInteger, alias: CouncilDistrict, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/10/2025 2:49:35 PM

Schema Last Edit Date: 2/10/2025 2:49:35 PM

Data Last Edit Date: 2/10/2025 2:49:35 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Query Attachments Generate Renderer Validate SQL Get Estimates ConvertFormat