Name: Notebook Analysis 2022 FY2023 Projects

Display Field: OID_1

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.837687122691
YMin: 33.6386849907806
XMax: -94.3424188964269
YMax: 37.0776853016141
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[52,127,96,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:

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)
• OID_1 (type: esriFieldTypeDouble, alias: OID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• T_BASE_YEAR (type: esriFieldTypeDouble, alias: T_BASE_YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C_JOB_PIECE (type: esriFieldTypeDouble, alias: C_JOB_PIECE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C_WORKCODE (type: esriFieldTypeString, alias: C_WORKCODE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• WP_NLF_ID (type: esriFieldTypeString, alias: WP_NLF_ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• WP_ROUTE_ID (type: esriFieldTypeString, alias: WP_ROUTE_ID, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true)
• C_PROJ_SUFFIX (type: esriFieldTypeString, alias: C_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)
• RD_OFFSET (type: esriFieldTypeDouble, alias: RD_OFFSET, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COUNTY_NO (type: esriFieldTypeString, alias: COUNTY_NO, SQL Type: sqlTypeOther, length: 2, nullable: false, editable: true)
• CONTROL_SEC (type: esriFieldTypeString, alias: CONTROL_SEC, SQL Type: sqlTypeOther, length: 3, nullable: false, 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: A_START, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_END (type: esriFieldTypeSingle, alias: A_END, SQL Type: sqlTypeOther, nullable: false, editable: true)
• A_LENGTH (type: esriFieldTypeSingle, alias: A_LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_TOTAL_PIECE_LENGTH (type: esriFieldTypeSingle, alias: A_TOTAL_PIECE_LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• P_S (type: esriFieldTypeString, alias: P_S, SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true)
• MAINTENANCE_DIV (type: esriFieldTypeSmallInteger, alias: MAINTENANCE_DIV, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HWY_COMM_DIST (type: esriFieldTypeSmallInteger, alias: HWY_COMM_DIST, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C_PROJECT_TYPE (type: esriFieldTypeString, alias: C_PROJECT_TYPE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• C_HIGHWAY_NO (type: esriFieldTypeString, alias: C_HIGHWAY_NO, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• I_PROGRAM_CATEGORY (type: esriFieldTypeString, alias: I_PROGRAM_CATEGORY, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• S_NATIONAL_HWY (type: esriFieldTypeString, alias: S_NATIONAL_HWY, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• S_NHS_OVERSIGHT (type: esriFieldTypeString, alias: S_NHS_OVERSIGHT, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• I_LET_CODE (type: esriFieldTypeString, alias: I_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: T_LET_DATE_YEAR, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• T_LET_DATE_MONTH (type: esriFieldTypeString, alias: T_LET_DATE_MONTH, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• T_INITIATED_YEAR (type: esriFieldTypeString, alias: T_INITIATED_YEAR, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• T_INITIATED_MONTH (type: esriFieldTypeString, alias: T_INITIATED_MONTH, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• T_COMM_ACT_YEAR (type: esriFieldTypeString, alias: T_COMM_ACT_YEAR, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• T_COMM_ACT_MONTH (type: esriFieldTypeString, alias: T_COMM_ACT_MONTH, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• S_FED_PARTICIPATE (type: esriFieldTypeString, alias: S_FED_PARTICIPATE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• C_IMPROVEMENT_TYPE (type: esriFieldTypeString, alias: C_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: C_ACCOUNT, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• C_ACCOUNT_PROJECT_TYPE (type: esriFieldTypeString, alias: C_ACCOUNT_PROJECT_TYPE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• S_IS_LEDGER_CLOSED (type: esriFieldTypeString, alias: S_IS_LEDGER_CLOSED, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• T_PROJECT_ID (type: esriFieldTypeString, alias: T_PROJECT_ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• T_PROJ_WORK_DESC (type: esriFieldTypeString, alias: T_PROJ_WORK_DESC, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• T_JP_DESC (type: esriFieldTypeString, alias: T_JP_DESC, SQL Type: sqlTypeOther, length: 151, nullable: true, editable: true)
• A_TOTAL_FED_INFL (type: esriFieldTypeDouble, alias: A_TOTAL_FED_INFL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_TOTAL_ST_INFL (type: esriFieldTypeDouble, alias: A_TOTAL_ST_INFL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_TOTAL_AMT_INFL (type: esriFieldTypeDouble, alias: A_TOTAL_AMT_INFL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• I_WORKPLAN_YORN (type: esriFieldTypeString, alias: I_WORKPLAN_YORN, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• I_NEW_PROJECT (type: esriFieldTypeString, alias: I_NEW_PROJECT, SQL Type: sqlTypeOther, length: 1, 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)
• US_CONGRESS (type: esriFieldTypeInteger, alias: US_CONGRESS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OK_SENATE_DISTRICT (type: esriFieldTypeInteger, alias: OK_SENATE_DISTRICT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OK_HOUSE_DISTRICT (type: esriFieldTypeInteger, alias: OK_HOUSE_DISTRICT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COUNTYNUM (type: esriFieldTypeSmallInteger, alias: County Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SUFFIX (type: esriFieldTypeString, alias: Suffix, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LANEID (type: esriFieldTypeString, alias: Lane ID, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• HIGHWAYCOMMDIST (type: esriFieldTypeSmallInteger, alias: Highway Commissioner District, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAINTENANCEDIVISION (type: esriFieldTypeSmallInteger, alias: Maintenance Division, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FUNCTIONALCLASS (type: esriFieldTypeSmallInteger, alias: Functional Class, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NOOFLANES (type: esriFieldTypeSmallInteger, alias: Number of Lanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OKHOUSEDISTRICT (type: esriFieldTypeSmallInteger, alias: State House District, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OKSENATEDISTRICT (type: esriFieldTypeSmallInteger, alias: State Senate District, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OUTSIDESHOULDERTYPE (type: esriFieldTypeSmallInteger, alias: Outside Shoulder Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOLLID (type: esriFieldTypeString, alias: Toll ID, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• URBANAREATYPE (type: esriFieldTypeSmallInteger, alias: Urban Area Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USCONGRESSDISTRICT (type: esriFieldTypeSmallInteger, alias: US Congress District, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AADT_1 (type: esriFieldTypeInteger, alias: AADT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AADT_SINGLE_UNIT (type: esriFieldTypeInteger, alias: AADT_SINGLE_UNIT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AADT_COMBINATION (type: esriFieldTypeInteger, alias: AADT_COMBINATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_FED_CODE (type: esriFieldTypeString, alias: TOTAL_FED_CODE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• Length_Miles (type: esriFieldTypeDouble, alias: Length_Miles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Length_Lane_Miles (type: esriFieldTypeDouble, alias: Length_Lane_Miles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Def_Shoulder (type: esriFieldTypeString, alias: Def_Shoulder, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• DVMT (type: esriFieldTypeDouble, alias: DVMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Vol2Cap (type: esriFieldTypeDouble, alias: Vol2Cap, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Leg_Dist_Pct (type: esriFieldTypeDouble, alias: Leg_Dist_Pct, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Adj_Project_Cost (type: esriFieldTypeDouble, alias: Adj_Project_Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DMVT (type: esriFieldTypeDouble, alias: DMVT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Address_Shldr (type: esriFieldTypeString, alias: Addresses Shoulders, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Address_Pave (type: esriFieldTypeString, alias: Addresses Pavement, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Address_Safety (type: esriFieldTypeString, alias: Addresses Safety, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Address_Engine (type: esriFieldTypeString, alias: Addresses Engineering, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Address_Bridge (type: esriFieldTypeString, alias: Addresses SD Bridge, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Invest_Shldr (type: esriFieldTypeDouble, alias: Investment in Shoulders, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Invest_Pave (type: esriFieldTypeDouble, alias: Investment in Pavement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Invest_Safety (type: esriFieldTypeDouble, alias: Investment in Safety, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Invest_Engine (type: esriFieldTypeDouble, alias: Investment in Engineering, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Invest_Bridge (type: esriFieldTypeDouble, alias: Investment in Bridge, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Adj_Invest_Shldr (type: esriFieldTypeDouble, alias: Adjusted Investment in Shoulders, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Adj_Invest_Pave (type: esriFieldTypeDouble, alias: Adjusted Investment in Pavement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Adj_Invest_Safety (type: esriFieldTypeDouble, alias: Adjusted Investment in Safety, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Adj_Invest_Engine (type: esriFieldTypeDouble, alias: Adjusted Investment in Engine, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Adj_Invest_Bridge (type: esriFieldTypeDouble, alias: Adjusted Investment in Bridge, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Notebook Analysis 2022 FY2023 Projects
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• WP_ROUTE_ID:
• COUNTY_NO:
• CONTROL_SEC:
• A_END: 0
• P_S:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/31/2023 3:04:50 PM

Schema Last Edit Date: 5/31/2023 3:04:50 PM

Data Last Edit Date: 5/31/2023 3:04:50 PM

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