So we have spent some time looking through the tabs ins Easy Street Analysis and discovering some of the pavement management tools that are at your disposal. Before we are ready to run the first analysis, however, it is very common for a municipality to have several committed projects on certain streets in the network. This is referred to as “planned work” and in order for the pavement management system to accurately reflect your network, we want to make sure all of the planned work has been entered into the right place. Let’s take a look at how this is done.
Feel free to follow along the instructions in the video below:
ESA is a powerful pavement management platform, but it is only as good as the information it is given. If you want an accurate pavement rehabilitation plan, you better make sure the system knows any predetermined commitments that the city has made toward pavement projects. The rehabilitation activity, as well as the year the work is planned must be manually entered.
The first step is to navigate to the Network Analysis tab of the ESA Spreadsheet. Here you will find a long list of segments. Since most planned work tends to utilize multiple segments, lets make sure we sort the data set by project id, so it will be easier for us to plow the data into each one of the segments that will be part of your planned project. (if you need help sorting the projects, be sure to follow along with the step by step instructions in the video linked above) Now make sure the “Committed Projects” column is unhidden. ESA has macro buttons located at the top of the sheet to hide and unhide these columns.
Now that the segments are sorted by project id, search for the particular id of the project you are looking to manually add work into. It can be helpful to highlight the rows you are working on so you don’t lose track.
Typically column BU will be the start of the committed projects section. In this column we want to add the year of the planned work. Make sure this information is repeated for each row that will be part of this project.
In the column right next to the year you will need to select the rehab type. This will appear as a long list of numbers that coincide with various rehab types and costs. To find the specific number of the activity you are looking for, jump over to the rehab activities tab and identify the proper rehab code. Make sure you select the rehab code for each of the segments within the selected project.
In the very next column you will have the option of including or excluding this particular project in the analysis. Select 1 to include it, and 0 to exclude it. Make sure this is done for each of the segments within the project.
Now that you have chosen the year/ rehab type/ segments and enabled the selection to be part of the analysis, simply scroll to the right and look at the selections that typically start in column IW. This information should reflect the selections that you have made so far. Confirm that the information is accurate and, congratulations, you have successfully added your first planned work selections into the ESA Analysis. The final step is to click on the “create Inventory” button on the network analysis tab to refresh the inventory CSV file that is used in the Arc Map project. After a moment, return to Arc Map and turn on the “planned work” filter. You should see your new project with the selected rehab activity and year reflected on the map.
You know your town better than anyone, so now with the ability to schedule planned work within your ESA analysis you are taking your first steps towards a pavement management plan that is uniquely positioned to meet your level of service goals.
Next week we will talk about running a budget within the ESA system, and how to interpret some of the graphs and charts that are outputs of the analysis.