Data Sharing Agreement - University of Notre Dame - Better Paving Practices through Data Analysis and Modeling

Home Browse Search

EXHIBIT A PROJECTI)ESCRIPTION 1. Summary of Research Question Please provide a brief summary of the proposed project. Include details of the teams impacted by this work, the desired outcome, etc. This project will involve analyzing data related to paving schedules, traffic, and pothole work orders. The objective of the project is to optimize the paving schedule such that the cost of filling potholes is minimized over time. This data will be used by the Department of Public Works, specifically the Streets division, to inform their paving program. Preferably the deliverable will include maps and other visualizations that can be used by leadership to inform their paving strategy, 2. Data Sets Available Please describe the data sets available for this project. Include details such as number of rows, variables, etc. Include also details of missing data, data that will require an NDA, etc. Indiana LRSA Report (Annual Operational Report for Local Roads and Streets) • Rows o Varies by year. 2016 has over 1400 rows of road/street projects, plus additional information on equipment and financials. Variables o Project type (paving, alleys, concrete, etc.) © Project location • Project area o Type of work (New construction, rehabilitation, resurfacing, etc.) a Project cost Can be shared (public record) Traffic Data (MACOG) • Rows - 83,560, • Variables - Aadt,, Counts, County Name, Max Date of Site, Max Date AAdt, Description, Latitude, Longitude, Northeast, Peak Hour, Site #, Southwest, Speed, Street, Strucks, Trucks, Ttrucks • Missing data o Description (20) o Also some location data is 0, unclear if this will be an issue • Available online from MACOG: http,4Ln1p s.njq!�o count-site.htrnl _j2_ qgorn/traffic Pothole Service Requests (since October 2016), • Rows: 734 • Variables • Service Request Number • Service Request Type 6