Layers:

Layer: Signs (0)


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:

XMin: -9418606.4855
YMin: 4577939.6601
XMax: -9401690.4581
YMax: 4593165.2492
Spatial Reference: 102100 (3857)


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:

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: 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:

Name: Signs
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:


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