Does the Dataset Reflect a Particular Time Period? Source Date Daily Start Date 12/21/2017 End Date N/A Dataset Refresh Interval Daily January 2019 Dataset Review Date Data Expiration Date N/A Comments This data set is automatically generated each morning and replaces the prior day’s file. Dataset Definition/Format Data Field Name Format Description CP ID Unique capital project identifier for each project. Project Number MPW Internal Project Number Indicates the categorical type of project, including: Bikeway, Project Category Bridge, Capital, Culvert, Guardrail, Paving, Sidewalk, and Traffic. Indicates the type of project, including: Bridge Replacement, Buffered Bike Lane, Construction Management, Culvert Repairs, Culvert Replacement, Cut Vegetation/Remove Debris, Guardrail Repairs, Intersection Improvements, Project Type Maintenance and Repair Jobs, New Bridge, New Pedestrian Signal, New Roadway, New Sidewalk, New Traffic Signal, Pavement Marking Maintenance, Paving, Project Management, Protected Bike Lane, Roadway Improvement, Shared Bikeway, and Sidewalk Repairs. The name of a specific Capital Project, e.g., 28th Avenue Project Name North Enhancements. The location of the project (which may cross multiple Council Project Location Districts). The name and location of the project are frequently identical.
Does the Dataset Reflect a Particular Time Period? Source Date Daily Start Date 12/21/2017 End Date N/A Dataset Refresh Interval Daily Dataset Review Date January 2019 Data Expiration Date N/A Comments This data set is automatically generated each morning and replaces the prior day’s file. Dataset Definition/Format Data Field Name Format Description CP ID Unique capital project identifier for each project. Project Number MPW Internal Project Number Project Category Indicates the categorical type of project, including: Bikeway, Bridge, Capital, Culvert, Guardrail, Paving, Sidewalk, and Traffic. Project Type Indicates the type of project, including: Bridge Replacement, Buffered Bike Lane, Construction Management, Culvert Repairs, Culvert Replacement, Cut Vegetation/Remove Debris, Guardrail Repairs, Intersection Improvements, Maintenance and Repair Jobs, New Bridge, New Pedestrian Signal, New Roadway, New Sidewalk, New Traffic Signal, Pavement Marking Maintenance, Paving, Project Management, Protected Bike Lane, Roadway Improvement, Shared Bikeway, and Sidewalk Repairs. Project Name The name of a specific Capital Project, e.g., 28th Avenue North Enhancements. Project Location The location of the project (which may cross multiple Council Districts). The name and location of the project are frequently identical.
Public-Works-Capital-Projects-Metadata.docx