Name: Under Construction Projects (2021 - 2023)
Display Field: C_JOB_PIECE
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.643319216936
YMin: 33.6561251008074
XMax: -94.3424188851992
YMax: 37.0776853025565
Spatial Reference: 4326 (4326)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[31,51,137,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:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- COUNTY_NO (type: esriFieldTypeInteger, alias: COUNTY_NO, SQL Type: sqlTypeOther, nullable: true, editable: true)
- JP_NO (type: esriFieldTypeString, alias: JP_NO, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- C_JOB_PIECE (type: esriFieldTypeInteger, alias: C_JOB_PIECE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- T_PROJECT_ID (type: esriFieldTypeString, alias: T_PROJECT_ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- C_PROJ_SUFFIX (type: esriFieldTypeString, alias: C_PROJ_SUFFIX, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- C_HIGHWAY_NO (type: esriFieldTypeString, alias: C_HIGHWAY_NO, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- T_PROJ_WORK_DESC (type: esriFieldTypeString, alias: T_PROJ_WORK_DESC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- C_WORKCODE (type: esriFieldTypeString, alias: C_WORKCODE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- T_JP_DESC (type: esriFieldTypeString, alias: T_JP_DESC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Division (type: esriFieldTypeString, alias: Division, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- MAINTENANCE_DIV (type: esriFieldTypeString, alias: MAINTENANCE_DIV, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CONTROL_SEC (type: esriFieldTypeString, alias: CONTROL_SEC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- WP_ROUTE_ID (type: esriFieldTypeString, alias: WP_ROUTE_ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- A_START (type: esriFieldTypeDouble, alias: A_START, SQL Type: sqlTypeOther, nullable: true, editable: true)
- A_END (type: esriFieldTypeDouble, alias: A_END, SQL Type: sqlTypeOther, nullable: true, editable: true)
- A_TOTAL_PIECE_LENGTH (type: esriFieldTypeDouble, alias: A_TOTAL_PIECE_LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
- T_BASE_YEAR (type: esriFieldTypeString, alias: T_BASE_YEAR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- FHWA_Auth_Date (type: esriFieldTypeDate, alias: FHWA_Auth_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Let_Date (type: esriFieldTypeString, alias: Let_Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- A_TOTAL_AMT_INFL (type: esriFieldTypeInteger, 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: 255, 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: Under Construction Projects (2021 - 2023)
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 5/28/2024 8:09:15 PM
Schema Last Edit Date: 5/28/2024 8:09:15 PM
Data Last Edit Date: 8/9/2023 2:25:42 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat