Name: PublicWorks.DBO.transportation_pavement

Display Field: TYPE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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: 2788214.08949383
YMin: 945830.776423819
XMax: 2817349.87931925
YMax: 974008.688899904
Spatial Reference: 102698 (102698)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSDash","color":[189,189,197,255],"width":1}},"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)
• FROMLEFT (type: esriFieldTypeDouble, alias: FROMLEFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOLEFT (type: esriFieldTypeDouble, alias: TOLEFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FROMRIGHT (type: esriFieldTypeDouble, alias: FROMRIGHT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TORIGHT (type: esriFieldTypeDouble, alias: TORIGHT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STR_DIR (type: esriFieldTypeString, alias: STR_DIR, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• STR_NAME (type: esriFieldTypeString, alias: STR_NAME, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• STR_TYPE (type: esriFieldTypeString, alias: STR_TYPE, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• BUILT (type: esriFieldTypeDate, alias: BUILT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TYPE (type: esriFieldTypeString, alias: TYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ESN_RT (type: esriFieldTypeSmallInteger, alias: ESN_RT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESN_LT (type: esriFieldTypeSmallInteger, alias: ESN_LT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SNOW (type: esriFieldTypeString, alias: SNOW, SQL Type: sqlTypeOther, length: 50, 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)
• CURB (type: esriFieldTypeSmallInteger, alias: CURB, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Avg_Slope (type: esriFieldTypeDouble, alias: Avg_Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Dwelling_count (type: esriFieldTypeSmallInteger, alias: Dwelling_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GISID (type: esriFieldTypeSmallInteger, alias: GISID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AssetManagement_DBO_pavement_Ar (type: esriFieldTypeDouble, alias: AssetManagement.DBO.pavement.Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Area_unit (type: esriFieldTypeString, alias: Area_unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Description (type: esriFieldTypeString, alias: Description1, 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)
• NumberofLanes (type: esriFieldTypeInteger, alias: NumberofLanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FunctionalClassification (type: esriFieldTypeString, alias: FunctionalClassification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PavementClassification (type: esriFieldTypeString, alias: PavementClassification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Subdivision (type: esriFieldTypeString, alias: Subdivision, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Length (type: esriFieldTypeDouble, alias: Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Length_unit (type: esriFieldTypeString, alias: Length_unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RightOfWayWidth (type: esriFieldTypeDouble, alias: RightOfWayWidth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RightOfWayWidth_unit (type: esriFieldTypeString, alias: RightOfWayWidth_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)
• 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)
• CartegraphID (type: esriFieldTypeString, alias: CartegraphID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TotalCost (type: esriFieldTypeDouble, alias: TotalCost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ConditionGroup (type: esriFieldTypeString, alias: ConditionGroup, 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)
• EstimatedOCI (type: esriFieldTypeDouble, alias: EstimatedOCI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PredictionGroup (type: esriFieldTypeString, alias: PredictionGroup, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LocationDescription (type: esriFieldTypeString, alias: LocationDescription, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EstimatedOCR (type: esriFieldTypeString, alias: EstimatedOCR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EstimatedCCR (type: esriFieldTypeString, alias: EstimatedCCR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CriticalityFactor (type: esriFieldTypeDouble, alias: CriticalityFactor, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CurrentInspectionID (type: esriFieldTypeString, alias: CurrentInspectionID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EstimatedCCI (type: esriFieldTypeDouble, alias: EstimatedCCI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ActBefore (type: esriFieldTypeDate, alias: ActBefore, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, 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)
• CurrentInspectionDate (type: esriFieldTypeDate, alias: CurrentInspectionDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CurrentInspectionOCI (type: esriFieldTypeDouble, alias: CurrentInspectionOCI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CurrentInspectionOCR (type: esriFieldTypeString, alias: CurrentInspectionOCR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CurrentInspectionNotes (type: esriFieldTypeString, alias: CurrentInspectionNotes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cgRiskScore (type: esriFieldTypeDouble, alias: cgRiskScore, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cgRiskRating (type: esriFieldTypeString, alias: cgRiskRating, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cgConsequenceOfFailureScore (type: esriFieldTypeDouble, alias: cgConsequenceOfFailureScore, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cgProbabilityOfFailureScore (type: esriFieldTypeDouble, alias: cgProbabilityOfFailureScore, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cgRedundancyValue (type: esriFieldTypeDouble, alias: cgRedundancyValue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cgRedundancyValue_unit (type: esriFieldTypeString, alias: cgRedundancyValue_unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: PublicWorks.DBO.transportation_pavement
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Width_unit: ft
• Length_unit: miles
• RightOfWayWidth_unit: ft
• SpeedZone_unit: MPH
• Jurisdiction: City of Raymore
• County: Cass
• StateValue: MO
• City: Raymore

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/24/2026 6:23:29 PM

Schema Last Edit Date: 6/4/2026 6:52:18 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 Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat