Pedestrian and Bicycle Transportation Along Existing Roads—ActiveTrans Priority Tool Guidebook (2015) / Chapter Skim
Currently Skimming:
Pages 52-69
The Chapter Skim interface presents what we've algorithmically identified as the most significant single chunk of text within every page in the chapter.
Select key terms on the right to highlight them within pages of the chapter.
From page 52... ...
52 A P P E N D I X A Introduction The ActiveTrans Priority Tool (APT) was developed based on previous research, transportation agency input, professional guidelines and reports, and practical experience, which is described in detail in the NCHRP Project 07-17 Final Report.
|
From page 53... ...
Programmed Spreadsheet User Guide 53 Figure A-1. APT methodology.
|
From page 54... ...
54 Pedestrian and Bicycle Transportation Along Existing Roads -- ActiveTrans Priority Tool Guidebook The four location types are defined in general below. Transportation agencies can make these definitions more specific for their own prioritization purposes.
|
From page 55... ...
Programmed Spreadsheet User Guide 55 Neighborhood/Area A neighborhood/area is a geographic region that is not constrained to a single roadway or roadway corridor. Agencies often analyze the attributes of both intersections and roadway segments when analyzing neighborhoods or areas.
|
From page 56... ...
56 Pedestrian and Bicycle Transportation Along Existing Roads -- ActiveTrans Priority Tool Guidebook Step 4: Select Variables This worksheet (Figure A-6) corresponds to Step 4 of the APT.
|
From page 57... ...
Figure A-6. View of Step 4: Select Variables worksheet.
|
From page 58... ...
58 Pedestrian and Bicycle Transportation Along Existing Roads -- ActiveTrans Priority Tool Guidebook Variable Weighting The programmed spreadsheet is set up to apply weights at the factor rather than variable level. However, variable weights can be applied by adjusting the formulas on the Step 10: Calc Priority Score tab to incorporate variable weights.
|
From page 59... ...
Programmed Spreadsheet User Guide 59 Step 7: Set Up Prioritization Tool This worksheet (Figure A-9) corresponds to Step 7 in the APT.
|
From page 60... ...
60 Pedestrian and Bicycle Transportation Along Existing Roads -- ActiveTrans Priority Tool Guidebook Before entering any other data, users should fill in the location identification field ("ID") , or common key, in Column A with unique numbers (e.g., 1, 2, 3, .
|
From page 61... ...
Programmed Spreadsheet User Guide 61 It is important for users to understand that the process of scaling will have an impact on the final prioritization rankings, so it should be done thoughtfully and transparently. Table A-1 shows how different scaling methods can produce different scaled values.
|
From page 62... ...
62 Pedestrian and Bicycle Transportation Along Existing Roads -- ActiveTrans Priority Tool Guidebook Methods for Scaling Numeric Values to the Common Scale Proportionate Scaling and Inverse Proportionate Scaling If the range of values does not include outliers (i.e., minimum or maximum values that are much larger or much smaller than other values) , then it is appropriate to adjust the raw numeric values proportionately to fit the common scale.
|
From page 63... ...
Programmed Spreadsheet User Guide 63 • Inverse proportionate scaling involves assigning 0 to the maximum raw value and the highest value in the common scale to the lowest raw value. In Table A-2, the maximum raw value is 5, the scale is 0 to 10, and the raw values are adjusted using proportionate scaling.
|
From page 64... ...
64 Pedestrian and Bicycle Transportation Along Existing Roads -- ActiveTrans Priority Tool Guidebook Table A-5 is the same as Table A-4 except that the raw values are scaled using inverse quantile scaling. To scale raw numeric values in the programmed spreadsheet using quantile scaling, users should select either the "Quantile Scaling 4 Quantiles" or "Quantile Scaling 10 Quantiles" options from the "Select Scaling Method" dropdown.
|
From page 65... ...
Programmed Spreadsheet User Guide 65 Quantile Scaling 4 Quantiles" or "Inverse Quantile Scaling 10 Quantiles" options. The choice between 4 or 10 quantiles depends on the number of improvement locations and how the data is distributed.
|
From page 66... ...
66 Pedestrian and Bicycle Transportation Along Existing Roads -- ActiveTrans Priority Tool Guidebook Scaling Non-Numeric Values to the Common Scale Variables with non-numeric values must be converted to numeric values as part of the scaling process. Converting these values requires users to rank the non-numeric values and convert the ranked values to the common scale.
|
From page 67... ...
Programmed Spreadsheet User Guide 67 Table A-8 illustrates this process for a case in which the non-numeric values to be scaled are "excellent," "good," "fair," and "poor." In the programmed spreadsheet, non-numeric values can be converted to the common scale by copying and pasting them into the "SCALED" column and using the spreadsheet's "Find and Replace" feature to convert them to numeric values. Table A-9 provides guidance for this type of conversion based on the number of discrete non-numeric values, how the discrete non-numeric values are ranked, and a scale of 0 to 10.
|
From page 68... ...
68 Pedestrian and Bicycle Transportation Along Existing Roads -- ActiveTrans Priority Tool Guidebook variable) to derive a prioritization score for each improvement location.
|
From page 69... ...
Programmed Spreadsheet User Guide 69 Tip It is important for practitioners to review the results of any prioritization scoring and ranking process carefully to understand how weighting, scaling, correlation of variables, and other issues may affect the results. The level of review should be proportional to the level of complexity of the process (i.e., the more factors and variables used, the more scrutiny the process demands)
|
Key Terms
This material may be derived from roughly machine-read images, and so is provided only to facilitate research.
More
information on Chapter Skim is available.