Name: ArterialStreetPavementCondition

Display Field: ROAD_CLASS

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Created to replace paving inspections layer that is outdated.

Copyright Text: 2022 City of Oklahoma City, Public Works, GIS

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: -10890534.6743324
YMin: 4203147.22319837
XMax: -10811476.7973359
YMax: 4257062.68624719
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[129,140,35,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• STREET_ID (type: esriFieldTypeInteger, alias: STREET_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PCI (type: esriFieldTypeDouble, alias: PCI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PCI_Date (type: esriFieldTypeDate, alias: PCI_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PCR (type: esriFieldTypeDouble, alias: PCR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PCR_DATE (type: esriFieldTypeDate, alias: PCR_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• IRI (type: esriFieldTypeSmallInteger, alias: IRI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROAD_CLASS (type: esriFieldTypeString, alias: RANK, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• FED_ROAD_CLASS (type: esriFieldTypeString, alias: FED_ROAD_CLASS, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• Street_TYPOLOGY (type: esriFieldTypeString, alias: Street_Typology, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• SPEEDLIMIT (type: esriFieldTypeSmallInteger, alias: SpeedLimit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• XSTREET_NA (type: esriFieldTypeString, alias: XSTREET_NA, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• XLOCATION_BEG (type: esriFieldTypeString, alias: XLOCATION_BEG, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• XLOCATION_END (type: esriFieldTypeString, alias: XLOCATION_END, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• RESIDENTIALQTR (type: esriFieldTypeString, alias: RESIDENTIALQTR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• WARD_A (type: esriFieldTypeSmallInteger, alias: WARD_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WARD_B (type: esriFieldTypeSmallInteger, alias: WARD_B, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WARD_C (type: esriFieldTypeSmallInteger, alias: WARD_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SHARED_RESPONSIBLE (type: esriFieldTypeString, alias: SHARED_RESPONSIBLE, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• COUNTY_COMM_DIST (type: esriFieldTypeString, alias: COUNTY_COMM_DIST, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LENGTH (type: esriFieldTypeDouble, alias: LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LANES (type: esriFieldTypeSmallInteger, alias: Lanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WIDTH (type: esriFieldTypeInteger, alias: WIDTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PVMT_TYPE (type: esriFieldTypeString, alias: SURFACE_A, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• ASPHALT_AREA (type: esriFieldTypeDouble, alias: ASPHALT_AREA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASPHALT_THICKNESS (type: esriFieldTypeDouble, alias: SURFACE_A_THICKNESS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONCRETE_AREA (type: esriFieldTypeString, alias: SURFACE_B, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• CONCRETE_THICKNESS (type: esriFieldTypeDouble, alias: SURFACE_B_THICKNESS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CHIPANDOIL_AREA (type: esriFieldTypeDouble, alias: CHIPANDOIL_AREA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GRAVEL_AREA (type: esriFieldTypeDouble, alias: GRAVEL_AREA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SURFACE_NOTES (type: esriFieldTypeString, alias: SURFACE_NOTES, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• INTERLAYER_DESC (type: esriFieldTypeString, alias: INTERLAYER_DESC, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• INTERLAYER_INST_DATE (type: esriFieldTypeDate, alias: INTERLAYER_INST_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PVMT_AREA (type: esriFieldTypeDouble, alias: PVMT_AREA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_VOL_BELOW (type: esriFieldTypeDouble, alias: TOTAL_VOL_BELOW, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_VOL_ABOVE (type: esriFieldTypeDouble, alias: TOTAL_VOL_ABOVE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POTHOLE_HIGH_TILES (type: esriFieldTypeString, alias: POTHOLE_HIGH_TILES, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• RUTTING_HIGH_TILES (type: esriFieldTypeString, alias: RUTTING_HIGH_TILES, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• CURBS (type: esriFieldTypeString, alias: CURBS, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• STRIPING_INST_DATE (type: esriFieldTypeDate, alias: STRIPING_INST_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• STRIPING_CONDITION (type: esriFieldTypeString, alias: STRIPING_CONDITION, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• STRIPING_INSPECT_DATE (type: esriFieldTypeDate, alias: STRIPING_INSPECT_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WO_COST (type: esriFieldTypeString, alias: WO_COST, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• WO_COUNT (type: esriFieldTypeString, alias: WO_COUNT, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• WO_DATA_UPDATE_DATE (type: esriFieldTypeDate, alias: WO_DATA_UPDATE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PROJECT_NUM (type: esriFieldTypeString, alias: PROJECT_NUM, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• PROJ_DATE (type: esriFieldTypeDate, alias: PROJ_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LAST_MAINT_ACT (type: esriFieldTypeString, alias: LAST_MAINT_ACT, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• LAST_MAINT_ACT_DATE (type: esriFieldTypeDate, alias: LAST_MAINT_ACT_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EST_TRCOUNT (type: esriFieldTypeDouble, alias: EST_TRCOUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B4_BIGDATA (type: esriFieldTypeDouble, alias: B4_BIGDATA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TR_COUNT (type: esriFieldTypeInteger, alias: TR_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TR_COUNT_DATE (type: esriFieldTypeDate, alias: TR_COUNT_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TR_COUNT_ID (type: esriFieldTypeInteger, alias: TR_COUNT_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAINTENANCE (type: esriFieldTypeString, alias: MAINTENANCE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• STREETLIGHT_ADT_2022 (type: esriFieldTypeInteger, alias: STREETLIGHT_ADT_2022, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STREETLIGHT_ADT_2023 (type: esriFieldTypeInteger, alias: STREETLIGHT_ADT_2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TruckVolumeMedium2023 (type: esriFieldTypeInteger, alias: TruckVolumeMedium2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TruckVolumeHeavy2023 (type: esriFieldTypeInteger, alias: TruckVolumeHeavy2023, SQL Type: sqlTypeOther, nullable: true, editable: true)
• 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)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: ArterialStreetPavementCondition
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/11/2025 5:04:01 PM

Schema Last Edit Date: 12/11/2025 5:04:01 PM

Data Last Edit Date: 12/11/2025 5:04:01 PM

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