Layer: ProjectsViewerPRSMFeatures

View In: Map Viewer

Name: ProjectsViewerPRSMFeatures_NR

Display Field: project_nickname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Has Views: true

Source Schema Changes Allowed: true

Views

Description: This linear feature layer is derived from the Caltrans PRSM (Project Resource and Schedule Management) database, and represents locations of Caltrans North Region (Districts 1,2 and 3) projects in various phases. This feature layer is intended for use within the North Region Projects Viewer Dashboard web application (hosted on ArcGIS Online, D3). PRSM project phases to phases for the Project Viewer are as follows (format: PRSM phase = Project Viewer phase): PID/Pre-PID = Planned, PAED or PSE = Programmed, Construction = Construction, Closeout = Complete, and any project designated as a Maintenance project will be assigned to the Maintenance phase. Additionally, any emergency projects will be labeled as 'Emergency Project.'The original PRSM source data have been queried and adjusted in order to fit the needs of the current Project Viewer Dashboard. Archived projects as well as projects that have a been completed for more than year are not displayed within this data. Data is updated on a monthly basis, as it becomes available through the PRSM database. If this data is accessed via ArcGIS Online, it is a hosted feature layer. Otherwise, it is a geodatabase feature class.

Copyright Text: Copyright © State of California, California Department of Transportation, 2025, NRGIS

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"alt_project_phase","uniqueValueGroups":[{"heading":"alt_project_phase","classes":[{"label":"Complete","description":"Complete","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[1,169,75,255],"width":4},"values":[["Complete"]]},{"label":"Construction","description":"Construction","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[229,174,24,255],"width":4},"values":[["Construction"]]},{"label":"Emergency Project","description":"Emergency Project","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[223,115,255,255],"width":4},"values":[["Emergency Project"]]},{"label":"Maintenance","description":"Maintenance","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,138,255],"width":4},"values":[["Maintenance"]]},{"label":"Planned","description":"Planned","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,252,1,255],"width":4},"values":[["Planned"]]},{"label":"Programmed","description":"Programmed","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":4},"values":[["Programmed"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[1,169,75,255],"width":4},"value":"Complete","label":"Complete"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[229,174,24,255],"width":4},"value":"Construction","label":"Construction"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[223,115,255,255],"width":4},"value":"Emergency Project","label":"Emergency Project"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,138,255],"width":4},"value":"Maintenance","label":"Maintenance"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,252,1,255],"width":4},"value":"Planned","label":"Planned"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":4},"value":"Programmed","label":"Programmed"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[236,182,252,255],"toColor":[236,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,252,182,255],"toColor":[184,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,207,184,255],"toColor":[252,207,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[189,242,252,255],"toColor":[189,242,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,199,252,255],"toColor":[179,199,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[242,252,210,255],"toColor":[242,252,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,210,237,255],"toColor":[252,210,237,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[189,252,223,255],"toColor":[189,252,223,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,185,255],"toColor":[252,179,185,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[223,207,252,255],"toColor":[223,207,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,222,255],"toColor":[252,179,222,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,223,252,255],"toColor":[184,223,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[245,252,179,255],"toColor":[245,252,179,255]}]}}},"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:

Global ID Field:

Type ID Field: alt_project_phase

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
project_efis (type: esriFieldTypeString, alias: project_efis, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
district (type: esriFieldTypeString, alias: district, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
project_ea (type: esriFieldTypeString, alias: project_ea, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
county (type: esriFieldTypeString, alias: county, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
route (type: esriFieldTypeString, alias: route, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
begin_postmile (type: esriFieldTypeString, alias: begin_postmile, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
end_postmile (type: esriFieldTypeString, alias: end_postmile, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
project_nickname (type: esriFieldTypeString, alias: project_nickname, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
work_description (type: esriFieldTypeString, alias: work_description, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
project_description (type: esriFieldTypeString, alias: project_description, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
program_category (type: esriFieldTypeString, alias: program_category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
subprogram (type: esriFieldTypeString, alias: subprogram, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
project_manager (type: esriFieldTypeString, alias: project_manager, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
project_phase (type: esriFieldTypeString, alias: project_phase, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
alt_project_phase (type: esriFieldTypeString, alias: alt_project_phase, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
m500_date (type: esriFieldTypeString, alias: m500_date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
m600_date (type: esriFieldTypeString, alias: m600_date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
m600_percent (type: esriFieldTypeString, alias: m600_percent, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
total_budget (type: esriFieldTypeString, alias: total_budget, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
district_project_category (type: esriFieldTypeString, alias: district_project_category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
integer_cost (type: esriFieldTypeInteger, alias: integer_cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
agency (type: esriFieldTypeString, alias: agency, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
source_date (type: esriFieldTypeString, alias: source_date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

alt_project_phase: Complete

alt_project_phase: Construction

alt_project_phase: Emergency Project

alt_project_phase: Maintenance

alt_project_phase: Planned

alt_project_phase: Programmed

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/22/2026 5:57:41 PM

Schema Last Edit Date: 6/18/2026 8:28:05 PM

Data Last Edit Date: 6/22/2026 5:57:41 PM

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

Layer: ProjectsViewerPRSMFeatures_NR (ID:0)