Name: PublicWorks.DBO.transportation_pavementmarkingarea

Display Field: markingtype

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 72224

Max. Scale: 1128

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2789866.59012583
YMin: 952405.155335404
XMax: 2816985.47821073
YMax: 966806.637994804
Spatial Reference: 102698 (102698)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[252,214,217,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: false

Has Attachments: true

Has Geometry Properties: true

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)
• 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)
• assetid (type: esriFieldTypeString, alias: Marking ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• markingtype (type: esriFieldTypeString, alias: Marking Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• markingmaterial (type: esriFieldTypeString, alias: Marking Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• locdesc (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• municipality (type: esriFieldTypeString, alias: Municipality, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ownedby (type: esriFieldTypeString, alias: Owned By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• maintainedby (type: esriFieldTypeString, alias: Maintained By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• shapeArea (type: esriFieldTypeDouble, alias: Marking Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• inspectdate (type: esriFieldTypeDate, alias: Inspected On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• condition (type: esriFieldTypeSmallInteger, alias: Condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
• reflectivity (type: esriFieldTypeString, alias: Marking Retroreflectivity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• retired (type: esriFieldTypeString, alias: Is Retired, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• retiredate (type: esriFieldTypeDate, alias: Date Retired, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• notes (type: esriFieldTypeString, alias: Inspection Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: PublicWorks.DBO.transportation_pavementmarkingarea
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• condition: 4
• municipality: Raymore

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/24/2026 12:04:21 PM

Schema Last Edit Date: 9/24/2026 12:04:21 PM

Data Last Edit Date: 9/24/2026 12:04:21 PM

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