Layer: Workplan and Asset Preservation (ID:0)

View In: Map Viewer

Name: Workplan and Asset Preservation

Display Field: C_WORKCODE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 4000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

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

HasM: true

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

T_BASE_YEAR (type: esriFieldTypeDouble, alias: Base Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
C_JOB_PIECE (type: esriFieldTypeDouble, alias: JP No., SQL Type: sqlTypeOther, nullable: true, editable: true)
C_WORKCODE (type: esriFieldTypeString, alias: Work Code, SQL Type: sqlTypeOther, length: 2, 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: Loc. 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: PS, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
MAINTENANCE_DIV (type: esriFieldTypeDouble, alias: Maint. Div., SQL Type: sqlTypeOther, nullable: true, editable: true)
HWY_COMM_DIST (type: esriFieldTypeDouble, alias: Hwy Comm. Dist., SQL Type: sqlTypeOther, 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: National Hwy, 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: Prog. Fed. Yr., SQL Type: sqlTypeOther, nullable: true, editable: true)
T_LET_DATE_YEAR (type: esriFieldTypeString, alias: Let Date Yr., SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
T_LET_DATE_MONTH (type: esriFieldTypeString, alias: Let Date Mo., SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
T_INITIATED_YEAR (type: esriFieldTypeString, alias: Initiated Yr., SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
T_INITIATED_MONTH (type: esriFieldTypeString, alias: Inititated Mo., 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 Mo., SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
S_FED_PARTICIPATE (type: esriFieldTypeString, alias: Fed. Participation, 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: US 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 Proj. 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: Project Work 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)
I_WORKPLAN_YORN (type: esriFieldTypeString, alias: Workplan Proj Type, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
WP_ROUTE_ID (type: esriFieldTypeString, alias: RouteID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
I_NEW_PROJECT (type: esriFieldTypeString, alias: New Project, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
OID_1 (type: esriFieldTypeDouble, alias: OID, SQL Type: sqlTypeOther, nullable: true, editable: true)
SHOULDER_PRJ (type: esriFieldTypeString, alias: SHOULDER_PRJ, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
PAVEMENT_PRJ (type: esriFieldTypeString, alias: PAVEMENT_PRJ, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
SAFETYOP_PRJ (type: esriFieldTypeString, alias: SAFETYOP_PRJ, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
BRIDGE_PRJ (type: esriFieldTypeString, alias: BRIDGE_PRJ, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
PRELIMENG_PRJ (type: esriFieldTypeString, alias: PRELIMENG_PRJ, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
LOC_ERROR (type: esriFieldTypeString, alias: LOC_ERROR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/27/2025 3:16:44 PM

Schema Last Edit Date: 5/27/2025 3:16:44 PM

Data Last Edit Date: 5/27/2025 3:16:44 PM

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