Layer: SDE.StreetSigns (ID:0)

View In: Map Viewer

Name: SDE.StreetSigns

Display Field: facingdirection

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

","uniqueValueGroups":[{"heading":"Condition","classes":[{"label":"Unknown","description":"Unknown","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[209,252,182,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["0"]]},{"label":"Very Poor","description":"Very Poor","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,170,0,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"values":[["1"]]},{"label":"Poor","description":"Poor","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[197,0,255,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"values":[["2"]]},{"label":"Fair","description":"Fair","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[85,255,0,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"values":[["3"]]},{"label":"Good","description":"Good","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,112,255,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"values":[["4"]]},{"label":"Very Good","description":"Very Good","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,0,0,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"values":[["5"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[209,252,182,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"0","label":"Unknown"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,170,0,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"value":"1","label":"Very Poor"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[197,0,255,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"value":"2","label":"Poor"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[85,255,0,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"value":"3","label":"Fair"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,112,255,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"value":"4","label":"Good"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,0,0,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"value":"5","label":"Very Good"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,184,255],"toColor":[179,252,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[241,179,252,255],"toColor":[241,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,208,192,255],"toColor":[252,208,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[194,231,252,255],"toColor":[194,231,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,252,189,255],"toColor":[252,252,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,241,255],"toColor":[252,215,241,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[202,252,226,255],"toColor":[202,252,226,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,193,252,255],"toColor":[184,193,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,197,255],"toColor":[252,184,197,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,242,210,255],"toColor":[252,242,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[230,252,207,255],"toColor":[230,252,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[220,215,252,255],"toColor":[220,215,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,252,250,255],"toColor":[182,252,250,255]}]}}},"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: condition

Fields:

installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, 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)
mountheight (type: esriFieldTypeDouble, alias: Mounting Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
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])
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 ...)
supplemental (type: esriFieldTypeString, alias: Supplemental Plaque, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
maintenance (type: esriFieldTypeString, alias: Needs Maintenance, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
maintstatus (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 ...)
mainttype (type: esriFieldTypeString, alias: Maintenance Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Anti-Theft Measures: Anti-Theft Measures], [Paint Removal: Paint Removal], [Sign Cleaning: Sign Cleaning], ... 5 more ...)
inspectedstatus (type: esriFieldTypeString, alias: Inspection Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
text (type: esriFieldTypeString, alias: Sign Text, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
code (type: esriFieldTypeString, alias: MUTCD Code, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true, Coded Values: [D14-2: Acknowledgement - (D14-2)], [W4-3: Added Lane - (W4-3)], [W3-1: Advanced Traffic Control - (W3-1)], ... 138 more ...)
type (type: esriFieldTypeString, alias: Sign Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Custom: Custom], [No Parking (NP): No Parking (NP)], [Speed Limit: Speed Limit], ... 4 more ...)
replacement (type: esriFieldTypeString, alias: Needs Replacement, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
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 ...)
notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
municipality (type: esriFieldTypeString, alias: Municipality, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [City of Sherman: City of Sherman], [Other: Other])
retired (type: esriFieldTypeString, alias: Is Retired, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
last_edited_user (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [CHarmpn: CHarmon], [CoryR: CoryR], [Other: Other])
curbregulations (type: esriFieldTypeString, alias: Curb Regulations, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
dimunits (type: esriFieldTypeString, alias: Sign Dimension Units, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Inches: Inches], [Centimeters: Centimeters])
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)

Types:

Field Name: condition
Inherited
Field Name: ownedby
Inherited
Field Name: collectedby
Inherited
Field Name: reflectivity
Inherited
Field Name: facingdirection
Inherited
Field Name: supplemental
Inherited
Field Name: maintenance
Inherited
Field Name: maintstatus
Inherited
Field Name: mainttype
Inherited
Field Name: inspectedstatus
Inherited
Field Name: code
Inherited
Field Name: type
Inherited
Field Name: replacement
Inherited
Field Name: color
Inherited
Field Name: sheeting
Inherited
Field Name: substrate
Inherited
Field Name: retired
Inherited
Field Name: curbregulations
Inherited
Field Name: dimunits
Inherited

Field Name: condition
Inherited
Field Name: ownedby
Inherited
Field Name: collectedby
Inherited
Field Name: reflectivity
Inherited
Field Name: facingdirection
Inherited
Field Name: supplemental
Inherited
Field Name: maintenance
Inherited
Field Name: maintstatus
Inherited
Field Name: mainttype
Inherited
Field Name: inspectedstatus
Inherited
Field Name: code
Inherited
Field Name: type
Inherited
Field Name: replacement
Inherited
Field Name: color
Inherited
Field Name: sheeting
Inherited
Field Name: substrate
Inherited
Field Name: retired
Inherited
Field Name: curbregulations
Inherited
Field Name: dimunits
Inherited

Field Name: condition
Inherited
Field Name: ownedby
Inherited
Field Name: collectedby
Inherited
Field Name: reflectivity
Inherited
Field Name: facingdirection
Inherited
Field Name: supplemental
Inherited
Field Name: maintenance
Inherited
Field Name: maintstatus
Inherited
Field Name: mainttype
Inherited
Field Name: inspectedstatus
Inherited
Field Name: code
Inherited
Field Name: type
Inherited
Field Name: replacement
Inherited
Field Name: color
Inherited
Field Name: sheeting
Inherited
Field Name: substrate
Inherited
Field Name: retired
Inherited
Field Name: curbregulations
Inherited
Field Name: dimunits
Inherited

Field Name: condition
Inherited
Field Name: ownedby
Inherited
Field Name: collectedby
Inherited
Field Name: reflectivity
Inherited
Field Name: facingdirection
Inherited
Field Name: supplemental
Inherited
Field Name: maintenance
Inherited
Field Name: maintstatus
Inherited
Field Name: mainttype
Inherited
Field Name: inspectedstatus
Inherited
Field Name: code
Inherited
Field Name: type
Inherited
Field Name: replacement
Inherited
Field Name: color
Inherited
Field Name: sheeting
Inherited
Field Name: substrate
Inherited
Field Name: retired
Inherited
Field Name: curbregulations
Inherited
Field Name: dimunits
Inherited

Field Name: condition
Inherited
Field Name: ownedby
Inherited
Field Name: collectedby
Inherited
Field Name: reflectivity
Inherited
Field Name: facingdirection
Inherited
Field Name: supplemental
Inherited
Field Name: maintenance
Inherited
Field Name: maintstatus
Inherited
Field Name: mainttype
Inherited
Field Name: inspectedstatus
Inherited
Field Name: code
Inherited
Field Name: type
Inherited
Field Name: replacement
Inherited
Field Name: color
Inherited
Field Name: sheeting
Inherited
Field Name: substrate
Inherited
Field Name: retired
Inherited
Field Name: curbregulations
Inherited
Field Name: dimunits
Inherited

Field Name: condition
Inherited
Field Name: ownedby
Inherited
Field Name: collectedby
Inherited
Field Name: reflectivity
Inherited
Field Name: facingdirection
Inherited
Field Name: supplemental
Inherited
Field Name: maintenance
Inherited
Field Name: maintstatus
Inherited
Field Name: mainttype
Inherited
Field Name: inspectedstatus
Inherited
Field Name: code
Inherited
Field Name: type
Inherited
Field Name: replacement
Inherited
Field Name: color
Inherited
Field Name: sheeting
Inherited
Field Name: substrate
Inherited
Field Name: retired
Inherited
Field Name: curbregulations
Inherited
Field Name: dimunits
Inherited

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/18/2026 7:11:30 PM

Schema Last Edit Date: 8/18/2026 7:11:30 PM

Data Last Edit Date: 8/18/2026 7:11:30 PM

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