Name: PublicWorks.DBO.transportation_trafficsign

Display Field: OBJECTID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 144448

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2786947.46693181
YMin: 945824.157670654
XMax: 2817439.83673496
YMax: 973980.076875089
Spatial Reference: 102698 (102698)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[230,230,0,255],"size":5,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}}},"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:

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)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• TYPE (type: esriFieldTypeString, alias: TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SIZE_ (type: esriFieldTypeString, alias: SIZE_, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Date (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WrkOrder (type: esriFieldTypeInteger, alias: WrkOrder, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Note (type: esriFieldTypeString, alias: Note, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Reflect (type: esriFieldTypeString, alias: Reflect, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• OWNER (type: esriFieldTypeString, alias: OWNER, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• POLEID (type: esriFieldTypeInteger, alias: POLEID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, 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_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, 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], ... 3 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, Range: [0 - 1023])
• 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: esriFieldTypeSmallInteger, 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)
• Height (type: esriFieldTypeDouble, alias: Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Height_unit (type: esriFieldTypeString, alias: Height_unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BackingMaterial (type: esriFieldTypeString, alias: BackingMaterial, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Illumination (type: esriFieldTypeString, alias: Illumination, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MUTCDCode (type: esriFieldTypeString, alias: MUTCDCode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PlacementPosition (type: esriFieldTypeString, alias: PlacementPosition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Reflectorization (type: esriFieldTypeString, alias: Reflectorization, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SheetingMaterial (type: esriFieldTypeString, alias: SheetingMaterial, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SignDirection (type: esriFieldTypeString, alias: SignDirection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MountingHeight (type: esriFieldTypeDouble, alias: MountingHeight, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MountingHeight_unit (type: esriFieldTypeString, alias: MountingHeight_unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Offset_ (type: esriFieldTypeDouble, alias: Offset, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Offset_unit (type: esriFieldTypeString, alias: Offset_unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SpeedZone (type: esriFieldTypeDouble, alias: SpeedZone, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SpeedZone_unit (type: esriFieldTypeString, alias: SpeedZone_unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Width (type: esriFieldTypeDouble, alias: Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Width_unit (type: esriFieldTypeString, alias: Width_unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VariableText (type: esriFieldTypeString, alias: VariableText, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Retired (type: esriFieldTypeDate, alias: Retired, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Replaced (type: esriFieldTypeDate, alias: Replaced, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Installed (type: esriFieldTypeDate, alias: Installed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AddressNumber (type: esriFieldTypeDouble, alias: AddressNumber, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CartegraphID (type: esriFieldTypeString, alias: CartegraphID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Jurisdiction (type: esriFieldTypeString, alias: Jurisdiction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LocationDescription (type: esriFieldTypeString, alias: LocationDescription, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• StateValue (type: esriFieldTypeString, alias: StateValue, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Support (type: esriFieldTypeString, alias: Support, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• department (type: esriFieldTypeString, alias: department, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• id (type: esriFieldTypeInteger, alias: id, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: PublicWorks.DBO.transportation_trafficsign
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• SpeedZone_unit: mph
• LocatorCity: Raymore
• Jurisdiction: City of Raymore
• County: Cass
• StateValue: MO
• City: Raymore

Relationships:

• PublicWorks.DBO.sign_support_relationship (1) -- Related To: PublicWorks.DBO.sign_support_relationship (16)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/23/2026 1:12:55 PM

Schema Last Edit Date: 9/23/2026 1:12:55 PM

Data Last Edit Date: 9/23/2026 1:12:55 PM

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