Name: Workplan History 2010-2023

Display Field: ARC_ID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

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: -102.837825070082
YMin: 33.6386797999819
XMax: -94.3423915704549
YMax: 37.077685301784
Spatial Reference: 4326 (4326)

Drawing Info:

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

HasZ: false

HasM: true

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)
• ARC_ID (type: esriFieldTypeString, alias: ARC_ID, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• T_BASE_YEAR (type: esriFieldTypeDouble, alias: Base Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C_JOB_PIECE (type: esriFieldTypeDouble, alias: Job Piece, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C_WORKCODE (type: esriFieldTypeDouble, alias: Work Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WP_NLF_ID (type: esriFieldTypeString, alias: NLF ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• C_PROJ_SUFFIX (type: esriFieldTypeString, alias: Proj. Suffix, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• NLF (type: esriFieldTypeString, alias: NLF, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• COUNTY_NO (type: esriFieldTypeString, alias: County No., SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• CONTROL_SEC (type: esriFieldTypeString, alias: Control Section, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• LOC_CONTROL_SUFFIX (type: esriFieldTypeString, alias: Location Control Suffix, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• A_START (type: esriFieldTypeSingle, alias: LRS Start Point, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_END (type: esriFieldTypeSingle, alias: LRS End Point, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_LENGTH (type: esriFieldTypeSingle, alias: LRS Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_TOTAL_PIECE_LENGTH (type: esriFieldTypeSingle, alias: Total Piece Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• P_S (type: esriFieldTypeString, alias: P S, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• MAINTENANCE_DIV (type: esriFieldTypeString, alias: Maintenance Div., SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• HWY_COMM_DIST (type: esriFieldTypeString, alias: Hwy. Comm. Dist., SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• C_PROJECT_TYPE (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• C_HIGHWAY_NO (type: esriFieldTypeString, alias: Highway No, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• I_PROGRAM_CATEGORY (type: esriFieldTypeString, alias: Program Category, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• S_NATIONAL_HWY (type: esriFieldTypeString, alias: Is National Highway, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• S_NHS_OVERSIGHT (type: esriFieldTypeString, alias: NHS Oversight, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• I_LET_CODE (type: esriFieldTypeString, alias: Let Code, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• PROGRAM_FED_YR (type: esriFieldTypeDouble, alias: Program Fed Yr., SQL Type: sqlTypeOther, nullable: true, editable: true)
• T_LET_DATE_YEAR (type: esriFieldTypeString, alias: Let Date Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• T_LET_DATE_MONTH (type: esriFieldTypeString, alias: Let Date Month, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• T_INITIATED_YEAR (type: esriFieldTypeString, alias: Initiated Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• T_INITIATED_MONTH (type: esriFieldTypeString, alias: Initiated Month, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• T_COMM_ACT_YEAR (type: esriFieldTypeString, alias: Comm Act Yr., SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• T_COMM_ACT_MONTH (type: esriFieldTypeString, alias: Comm Act Month, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• S_FED_PARTICIPATE (type: esriFieldTypeString, alias: Fed Participate, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• C_IMPROVEMENT_TYPE (type: esriFieldTypeString, alias: Improvement Type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• CONGRESS_DIST (type: esriFieldTypeString, alias: Congress Dist., SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• OK_SENATE_DIST (type: esriFieldTypeString, alias: OK Senate Dist., SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• OK_HOUSE_DIST (type: esriFieldTypeString, alias: OK House Dist., SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• C_ACCOUNT (type: esriFieldTypeString, alias: Account, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• C_ACCOUNT_PROJECT_TYPE (type: esriFieldTypeString, alias: Account Type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• S_IS_LEDGER_CLOSED (type: esriFieldTypeString, alias: Is Ledger Closed, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• T_PROJECT_ID (type: esriFieldTypeString, alias: Project ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• T_PROJ_WORK_DESC (type: esriFieldTypeString, alias: Proj. Work Code Desc., SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• T_JP_DESC (type: esriFieldTypeString, alias: JP Desc., SQL Type: sqlTypeOther, length: 151, nullable: true, editable: true)
• A_TOTAL_FED_INFL (type: esriFieldTypeDouble, alias: Total Fed Infl., SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_TOTAL_ST_INFL (type: esriFieldTypeDouble, alias: Total State Infl., SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_TOTAL_AMT_INFL (type: esriFieldTypeDouble, alias: Total Amt Infl., SQL Type: sqlTypeOther, nullable: true, editable: true)
• WORKPLAN_PROJ_TYPE (type: esriFieldTypeDouble, alias: Work Plan Proj. Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Workplan History 2010-2023
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/13/2025 7:54:15 PM

Schema Last Edit Date: 3/13/2025 7:54:15 PM

Data Last Edit Date: 2/21/2023 3:00:52 PM

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