Broward County I-95 Corridor Mobility Planning Project March 14, 2014
How to Use the Database of Strategies and Examples
The Database of Strategies and Examples is a comprehensive listing of 411 various strategies that each partner can undertake to work towards the vision for the future. These strategies were compiled through a series of listening sessions between FDOT and all of the planning partners in Fall 2013. The simple task of compiling all of these strategies into one master list shows the complexity and interconnectedness of transportation and land use decisions.
The Database contains five objectives (Column P), which each contain a handful of strategy categories (Column Q), each of which contain a listing of individual strategies (Column R). Each strategy has one or more examples (Column S). The examples each contain information about which partner spoke of the example (Column T), the agency who has or will implement the example of the strategy (Column U), the timeline of the example (Column V), and a ‘tag’ that indicates if the example applies to the system as a whole, a particular facility type, or a particular place type (Columns W – AF). The ‘tags’ indicate which function (A, B, C, D, E, or X) the example fulfills.
How to Use the Database
The full list of 413 examples may be too long and complex for most users. The Database is designed to allow the user to filter and query the list of strategies and examples in several ways.
1. Filter by Objective, Strategy Category, and Strategy
Columns P, Q, and R have down arrows in the lower right corner of the column headers – these are the filter buttons.
Click on the filter button for the objectives. A menu will appear that lists the five objectives with check boxes next to them, with an additional option for (Select All) at the top. Notice that all six check boxes are checked.
Uncheck the (Select All) check box, and notice that the other boxes are automatically unchecked. You can now select which of the objectives you would like to view in the database. Only the strategies and examples that correspond to the objectives you have checked will appear. The status bar on the bottom of the window will indicate how many records you are showing from the original 411 (e.g. 70 of 411 records found).
You can filter the Strategy Categories and Strategies columns in the same way. Filter the Objectives column first, then the Strategy Categories column to narrow down the list of strategies and examples accordingly.
2. Filter by Agency
You can search the Database by the type of agency who would be responsible for implementing each strategy.
To use this filter and the others described subsequently, unhide Columns D through O. Please note that Column B is a reference column for the drop down menus in cells N2 and N3, and should not be changed. It is recommended that users keep Column B hidden while working with the database.
Notice that cells N2 and N3 are in orange. To search by implementing agency, click in cell N2. Note that a drop down arrow appears to the right of the cell. Click on the drop down arrow. You will see a list of types of agencies from which you can select one.
Once you have selected a type of agency, some of the cells in Column N will populate with the agency type you have selected, depending on whether or not the agency you selected is the implementing agency for that example. Click on the filter button next to the Agency column header in cell N4, and uncheck (Select All). Check the box for the agency type you have selected. This will show only those strategies and examples for which that agency type is responsible for implementing, as shown in Column U.
3. Filter by Facility Type, Place Type, or System
You can filter the Database to show the strategies and examples that are applicable to the system as a whole, to a particular facility type, or a particular place type. For example, you can search all strategies that are applicable to lower intensity mixed use areas.
To search for all strategies and examples that are applicable for a facility type or place type, regardless of the function, make sure cell N3 is set to All. Click the filter button on the facility type or place type for which you would like to search. Uncheck the box next to 0. This will hide all strategies and examples that are not applicable to that particular facility type or place type.
You can use this method to search for strategies and examples that are applicable to the system as a whole. Simply repeat this method for Column D.
4. Filter by Function
You can also filter the Database to show the strategies and examples that are applicable for each function, as defined in the function tables for facility types and place types.
Click on cell N3, click on the drop down button, and select a function (X, A, B, C, D, or E). This will populate the cells in Columns D – O, according to whether the example in a row is applicable to the selected function.
To see all strategies and examples for which this function is applicable, regardless of facility type or place type, click the filter button on cell O4 (Function column), and uncheck the box for (Blanks).
Alternatively, to see the strategies and example for which this function is applicable, for a particular facility type or place type, click the filter button on the header cell for that particular column, and uncheck the box for (Blanks). For example, to see the strategies and examples that are applicable to Hybrid facilities by way of function A, click the filter button on cell H4.
Using Multiple Filters
You may find that using a combination of these filters will help to identify particular strategies that meet multiple criteria. If you have familiarity with Excel’s filtering capabilities, you can set up additional filters for other criteria, such as timeline and agency who brought up the idea. Users are encourages to use the flexibility that the filters provide to query the strategies and examples that would be most useful to them.
How to Use the Database of Strategies and Examples Page 4