Docstoc

Coding Sheet PAPRN (Excel download)

Document Sample
Coding Sheet PAPRN (Excel download) Powered By Docstoc
					                CDC Physical Activity Policy Research Network 399927fd-fd65-4829-9a33-a7b63612472a.xls                                                                         Analysis of Master Plans study
         ITEM                    VARIABLE DESCRIPTION                              VARIABLE KEY                                                  CODE       TEXT   When typing in a cell, ALT-Enter for a new line.    PAGE #

                                 Coding Sheet Version - 080807
    st
1 Rater: NAME, phone, email@u.edu                                                  PAPRN site:                                          Date:
                                                                                                            (CO/HARV/MD/NC/SDSU/SLU/UH/UW)                              __ /__/2008                                    Item set
2nd Rater: NAME, phone, email@u.edu                                                PAPRN site:                                          Date:
                                                                                                            (CO/HARV/MD/NC/SDSU/SLU/UH/UW)                              __ /__/2008                                    Item set
                                 TABLE OF CONTENTS:                                INSTRUCTIONS:                                                 ITEM SET Coding Shading reference:
                            1.   General Plan Information                            Confused about terms? See Glossary section for clarification.  1.4    CORE SET - no shading
                            2.   Plan components/presentation                        1. First skim entire plan before starting coding.              1.5    EXTENDED SET - shaded
                            3.   Planning Process and Public Engagement              2. Enter Name, PAPRN site, Date, item shading.                  9.1        University X Custom
                            4.   Plan Goals & Objectives                             3. Read through plan, entering coding info.                     10.1       Researcher Y Custom
                            5.   Current Conditions and Trends                       4. Page # references are to the print document (not pdf).
                            6.   Policies & Proposals                                5. Use CODE column to enter numerical or categorized data.
                            7.   Implementation                                      6. Use TEXT column for descriptive data.
                         8.      Overall Comments                                    7. Use Excel's "New Comment" feature to for comments about coding data.
                    Sheet 2      Glossary Section                                    8. Leave adequate time to enter comments in section 8.                  NOTE: Do not insert rows, as this will affet the links.


         ITEM                    VARIABLE DESCRIPTION                              VARIABLE KEY                                                  CODE       TEXT   When typing in a cell, ALT-Enter for a new line.    PAGE #
1                                General Plan Information
         1.0                     Title of the Plan                                 Text

         1.1                     FIPS Code (a geographical reference)              Obtain from administrator                                     ADMIN
         1.2                     Year of publication                               Text for year (999=no date found)
         1.3                     Approval                                          1=Draft; 2=Released; 3=Departmental (director
                                                                                   sig); 4=Adopted (formal resolution); 5=Other;
                                                                                   999=none found
         1.4                     Type of Plan                                      1=Ped; 2=Bike; 3=Ped/Bike or Non-motorized;
                                                                                   4=Comp Plan; 5=Multi-modal Transportation
                                                                                   Plan; 9=Other
         1.5                     Geographic Scope                                  1=City or municipality; 2=County; 3=Region;
                                                                                   4=State; 5=Neighborhood; 6=Campus; 9=Other

         1.6                     Plan version (New? Update to an existing plan?)   1=First such master plan; 2=At least one
                                                                                   previous master plan was approved; 3=At least
                                                                                   two previous plans approved; etc.; Note the
                                                                                   years of previous releases in Text field. 0=Not
                                                                                   possible to determine.
         1.7                     Main contact regarding plan development           Text (Name, title, contact info, if available)
         1.8                     Consultant hired for plan development             999=Not possible to determin;1=Yes; 0=No
                                                                                   Text for Consulting Firm name(s)
         1.9                     Number of pages - Body                            Text for number of pages
                    1.9.1        Number of pages - Appendicies                     Text for number of pages or "Not Available"
                                 Document format referenced for Coding?            4=Full Color Printed Document; 3=Full Color
                                                                                   PDF Doc; 2=Black, white & grey Print or PDF
                                                                                   Doc; 1=Black & White only print or PDF doc
         1.10
2                                Plan components/presentation
         2.1                     Table of contents                                 1=Yes; 0=No
      399927fd-fd65-4829-9a33-a7b63612472a.xls                                                                                                                                                       Page 2/22
2.1
ITEM                VARIABLE DESCRIPTION                                          VARIABLE KEY                                          CODE   TEXT   When typing in a cell, ALT-Enter for a new line.     PAGE #
          2.1.1     Page Numbering                                                0=Sequential numbering from start; 1=Use of
                                                                                  introductory page numbering? (i.e. ii, iii, iv);
                                                                                  2=Section numbering (i.e., 1-9, 2-1, 2-2)
2.2                 Executive summary                                             1=Yes; 0=No. Text page number.

2.3                 Are maps included?                                            1=Yes; 0=No
                                                                                                    If no, skip to 2.4
          2.3.1     Maps of current on-street facilities transportation           2=Clear and usable (especially with respect to
                    system or for pedestrians or bicyclists (e.g., sidewalks,     pedestrian facilities);
                    crosswalk, bike lanes, etc.)                                  1=Limited or difficult to read;
                                                                                  0=Nonexistent
          2.3.2     Maps of current off-road facilities (paved or un-paved) 2=Clear and usable (especially with respect to
                    for pedestrians or bicyclists (e.g., multi-use trails, bike   pedestrian facilities);
                    paths, park facilities, institutional access routes, activity 1=Limited or difficult to read;
                    trails)                                                       0=Nonexistent
          2.3.3     Maps of major land uses and trip attractors (i.e.,        2=Clear and usable (especially with respect to
                    destinations that generate walking & bicycling trips such pedestrian facilities);
                    as parks and schools)                                     1=Limited or difficult to read;
                                                                                  0=Nonexistent
                                                                                                    If no, skip to 2.3.4
          2.3.3.1   If yes, please specify which trip attractors are       Text
                    explicitly referenced (grocery stores, parks, schools,
                    retail areas, etc.)
          2.3.4     Maps of major motorized transportation facilities like 2=Extensive, clear and usable;
                    freeways and roads?                                    1=Limited or difficult to read;
                                                                                  0=Nonexistent
          2.3.5     Connections with fixed route transit system(s)                2=The plan discusses an existing transit system;
                                                                                  1=The plan discusses a future transit system (if
                                                                                  the community does not currently have transit);
                                                                                  0=Not mentioned

                                                                                                    If no, skip to 2.3.6
          2.3.5.1   If the community has transit, maps of major transit           2=Extensive, clear and usable;
                    facilities like rail and bus routes connections?              1=Limited or difficult to read;
                                                                                  0=Nonexistent
          2.3.6     Crash maps of ped/bike injury or fatality locations           2=Extensive, clear and usable;
                                                                                  1=Limited or difficult to read;
                                                                                  0=Nonexistent
          2.3.7     Connections across jurisdictions identified                   2=Extensive, clear and usable;
                                                                                  1=Limited or difficult to read;
                                                                                  0=Nonexistent
2.4                 Tables of data or other information that was not              1=Yes; 0=No
                    conveyed on a map
2.5                 Photographs                                                   1=Yes; 0=No
2.6                 Design drawings or specifications                             1=Yes; 0=No
2.7                 Quotations from citizen participants                          1=Yes; 0=No
2.8                 Is all language clear or explained? (via glossary or          1=Yes; 0=No
                    explaination in text)
2.9                 Rate the overall clarity of the plan's layout as a            2=Overall presentation is clear and usable;
                    complete document (is the entire plan easy to read and        1=Overall presentation is mixed (some sections
                    understand)                                                   are clear, while others are limited or difficult to
                                                                                  read);
                                                                                  0=Overall presentation is poor
           399927fd-fd65-4829-9a33-a7b63612472a.xls                                                                                                                                           Page 3/22
    ITEM               VARIABLE DESCRIPTION                                       VARIABLE KEY                                   CODE   TEXT   When typing in a cell, ALT-Enter for a new line.     PAGE #
    2.10               Does the Plan cite references for recommendations or       2=Extensive, clear and usable;
                       decisions? (such as research publications or best          1=Limited or ambiguous;
                       practices found in other cities)                           0=Nonexistent
    2.11               Is the plan readily accessible online?                     3=Via Plan Web site and Downloadable as PDF;
                                                                                  2=Via Plan Web site; 1=Via downloadable PDF;
                                                                                  0=No
    2.12               Free Text (add your overall impression of the plan’s       Text
                       presentation and any other important information)
3                      Planning Process and Public Participation
    3.1                Does the plan include any information about the "pre-      1=Yes; 0=No
                       history" of the plan, specifically with respect to
                       planning or participation in the community, before this
                       planning process was initated? Does the plan describe
                       the history of stakeholder involvement that occurred
                       prior to the development of the plan? (stakeholders may
                       include citizens, public officials, advocacy groups,
                       agencies, non-profits, or anyone with an “interest” in the
                       plan)
                                                                                                    If no, skip to 3.2
               3.1.1   If yes, provide a brief summary of the stakeholders        Text (be sure to include page number)
                       involved and any other relevant information that may
                       foster greater understanding of the process. Examples
                       (policy sciences framework) include: Which groups
                       promoted specific courses of action? Which institutional
                       values are being promoted (or dismissed), and which
                       groups’ interests are served? Whose interests are not
                       being considered?

               3.1.2   Does the plan reference any prior community-driven         1=Yes; 0=No
                       planning efforts? (e.g., process to develop a
                       neighborhood plan)
    3.2                Is there a description of the public participation         2 = Present and detailed;
                       processes for developing the plan?                         1 = Present but not detailed (described only
                                                                                  briefly or suggested in the plan);
                                                                                  0 = Not present
                                                                                                If not present, skip to 3.7
               3.2.1   If present in any form, is the description of the public   1 = Integrated within the plan;
                       participation process integrated within the plan, or       0 = Separate
                       isolated in a separate section apart from the main
                       body of the plan (e.g., in an appendix)

    3.3                Were public meetings used?                                 1=Yes; 0=No
                                                                                                    If no, skip to 3.4
               3.3.1   Number of meetings                                         Number (999=missing)
               3.3.2   Total number of participants in all public meetings        Total Number (999=missing)
               3.3.3   Where were meetings held?                                  Text
3.3

      399927fd-fd65-4829-9a33-a7b63612472a.xls                                                                                                                                                  Page 4/22
ITEM                VARIABLE DESCRIPTION                                       VARIABLE KEY                                        CODE   TEXT   When typing in a cell, ALT-Enter for a new line.     PAGE #
          3.3.4     Communication style at meetings or public forums           3=Two-way communication;
                    (e.g., two-way communication is a dynamic process in       2=One-way communication (citizens to
                    which information is conveyed by planners to the public,   planners);
                    and the public gives feedback to planners). One-way        1=One-way communication (planners to
                                                                               citizens);
                    communication involves planners speaking to citizens
                                                                               0=Not specified
                    (for example, an information forum), and/or citizens
                    speaking to planners, but no dynamic feedback process.

3.4                 Which strategies to receive public input were used?
                    (besides meetings)
          3.4.1     Call-in phone number                                       1=Yes; 0=No
          3.4.2     Telephone or Print Surveys/questionnaire                   1=Yes; 0=No
          3.4.2.1   Online survey                                              1=Yes; 0=No
          3.4.3     Focus group                                                1=Yes; 0=No
          3.4.4     Website blog and listserv                                  1=Yes; 0=No
          3.4.5     Design workshop (also known as "Charettes")                1=Yes; 0=No
          3.4.6     Map mark-up                                                1=Yes; 0=No
          3.4.7     Community walks or bicycle rides                           1=Yes; 0=No
3.5                 Other public participation strategies or forms of          Text
                    public input not listed above (e.g., citizen complaints,
                    call-in numbers, emails)?
3.6                 Are any sociodemographic characteristics of                1=Yes; 0=No
                    participants provided about public participation?
                                                                                                 If no, skip to 3.7
          3.6.1     If yes, for which aspects of participation or outreach?    Text

          3.6.2     Enter sociodemographic info on age                         Write in Text field information about age (range
                                                                               and or mean/median age);
                                                                               0=Not given
          3.6.3     Enter sociodemographic info on gender                      Write in Text field the PERCENT FEMALE (e.g.
                                                                               60%) or the absolute number of women if the
                                                                               percent is not given (e.g. 72 women);
                                                                               0=Not given
          3.6.4     Enter sociodemographic info on race/ethnicity              Write in Text field the PERCENT NON-WHITE
                                                                               (include Hispanic ethnicity as non-white) (e.g.
                                                                               60%) or the absolute number of non-white
                                                                               participants if the percent is not given (e.g. 72
                                                                               nonwhite);
                                                                               0=Not given
          3.6.5     Enter sociodemographic info on income                      Write in Text field information about income
                                                                               (range and or mean/median, percent in low-vs.
                                                                               high income groups,etc.);
                                                                               0=Not given
          3.6.6     Enter sociodemographic info on education                   Write in Text field information about education
                                                                               (range and or mean/median, percent with
                                                                               college education, etc.);
                                                                               0=Not given
          3.6.7     FREE TEXT (enter any other information that you feel       Text
                    may help to describe the racial/ethnic composition of
                    participants)
      399927fd-fd65-4829-9a33-a7b63612472a.xls                                                                                                                                            Page 5/22
ITEM                  VARIABLE DESCRIPTION                                   VARIABLE KEY                                    CODE   TEXT   When typing in a cell, ALT-Enter for a new line.     PAGE #
3.7                   Which of the following stakeholders were involved in
                      developing the plan? (mentioned specifically)

          3.7.1       Who Convened the Plan Development Process?             0=Not mentioned; 1=City Agency; 2=Advocacy
                                                                             organization; 3=Consultant; 4=Other (specify)

          3.7.1.1     Specific name of convenor organization, agency, or     Text
                      department (e.g., City Council, Cityname Bike Club,
                      Department of Transportation, etc.)

          3.7.2       Was there a Committee/steering/advisory board of      1=Yes; 0=Not mentioned
                      stakeholders? (e.g., composed of citizens and elected
                      or appointed officials)
          3.7.2.1     Evidence cited regarding prior collaboration among 1=Yes; 0=Not mentioned
                      participants dating back >3 years?
          3.7.3       Agency staff at the local or state levels:            1=Yes; 0=Not mentioned

                                                                                             If no, skip to 3.7.4
          3.7.3.1     Land use planning (includes “Planning”)                1=Yes; 0=Not mentioned
          3.7.3.2     Transportation planning                                1=Yes; 0=Not mentioned
          3.7.3.2.1   Local transportation planning                          1=Yes; 0=Not mentioned
          3.7.3.2.2   Regional transportation planning (RPO/MPO)             1=Yes; 0=Not mentioned
          3.7.3.2.3   State transportation planning (State DOT)              1=Yes; 0=Not mentioned
          3.7.3.3     Engineering/public works                               1=Yes; 0=Not mentioned
          3.7.3.4     Parks and recreation                                   1=Yes; 0=Not mentioned
          3.7.3.5     Public Health (local /county health department)        1=Yes; 0=Not mentioned
          3.7.3.6     Law enforcement                                        1=Yes; 0=Not mentioned
          3.7.3.7     Mayor or City Manager                                  1=Yes; 0=Not mentioned
          3.7.3.8     City Council members                                   1=Yes; 0=Not mentioned
          3.7.3.9     Fire Department                                        1=Yes; 0=Not mentioned
          3.7.3.10    Water/Sewer agency                                     1=Yes; 0=Not mentioned
          3.7.3.11    Electric utility                                       1=Yes; 0=Not mentioned
          3.7.3.12    Arts commission                                        1=Yes; 0=Not mentioned
          3.7.3.13    Air Quality agency                                     1=Yes; 0=Not mentioned
          3.7.3.14    Department of Neighborhoods                            1=Yes; 0=Not mentioned
          3.7.3.15    Senior/Disability Services                             1=Yes; 0=Not mentioned
          3.7.3.16    Courts or City Attorney's office                       1=Yes; 0=Not mentioned
          3.7.3.17    Schools representative                                 1=Yes; 0=Not mentioned
          3.7.3.18    Transit agency                                         1=Yes; 0=Not mentioned
          3.7.3.19    Other government agencies                              Text
          3.7.4       Business Sector Groups                                 1=Yes; 0=Not mentioned
                                                                                     If no business sector, skip to 3.7.5
          3.7.4.1     Grocery store owners                                   1=Yes; 0=Not mentioned
          3.7.4.2     Café, Restaurant, Tavern proprietors                   1=Yes; 0=Not mentioned
          3.7.4.3     Convenience Store owners                               1=Yes; 0=Not mentioned
          3.7.4.4     Event organizers (e.g., festivals, marathons, walks)   1=Yes; 0=Not mentioned
          3.7.4.5     Health/Medical other than public health                1=Yes; 0=Not mentioned
          3.7.4.6     Freight Transportation/Trucking                        1=Yes; 0=Not mentioned
          3.7.4.7     Chamber of Commerce                                    1=Yes; 0=Not mentioned
          3.7.4.8     Media companies                                        1=Yes; 0=Not mentioned
          3.7.4.9     Major Employers                                        1=Yes; 0=Not mentioned
       399927fd-fd65-4829-9a33-a7b63612472a.xls                                                                                                                                               Page 6/22
ITEM                  VARIABLE DESCRIPTION                                          VARIABLE KEY                                 CODE   TEXT   When typing in a cell, ALT-Enter for a new line.     PAGE #
           3.7.4.10   Developers & Real estates                                     1=Yes; 0=Not mentioned
           3.7.4.11   Construction contractors                                      1=Yes; 0=Not mentioned
           3.7.4.12   Customer Service or Retailers                                 1=Yes; 0=Not mentioned
           3.7.4.13   Architects & Planner Consultants                              1=Yes; 0=Not mentioned
           3.7.4.14   Other Business Sector                                         Text
           3.7.5      Foundations                                                   1=Yes; 0=Not mentioned
           3.7.6      Community Sector Participants                                 1=Yes; 0=Not mentioned
                                                                                           If no community sector, skip to 3.8
           3.7.6.1    Environmental/Conservation groups                             1=Yes; 0=Not mentioned
           3.7.6.2    Community-Based Organizations (e.g., Churches,                1=Yes; 0=Not mentioned
                      Rotary Club,
           3.7.6.3    Social Justice/Civil Rights groups                            1=Yes; 0=Not mentioned
           3.7.6.4    Neighborhood Councils                                         1=Yes; 0=Not mentioned
           3.7.6.5    Economic/community development associations                   1=Yes; 0=Not mentioned
           3.7.6.6    Blind or Disability Organizations                             1=Yes; 0=Not mentioned
           3.7.6.7    PTA/Parent Teacher Student Organizations                      1=Yes; 0=Not mentioned
           3.7.6.8    Older Adults                                                  1=Yes; 0=Not mentioned
           3.7.6.9    Crash victims or their family members                         1=Yes; 0=Not mentioned
           3.7.6.10   Pedestrian advocacy organizations (potential member of        1=Yes; 0=Not mentioned
                      national America Walks, for example)
           3.7.6.11   Bicycle advocacy organizations (potential member of           1=Yes; 0=Not mentioned
                      national Thunderhead Alliance, for example)
           3.7.6.12   Trail, Path, Greenway, or Parks group                         1=Yes; 0=Not mentioned
           3.7.6.12   Walking or bicycling clubs (e.g., member of the               1=Yes; 0=Not mentioned
                      American Volkssport Assoc.)
           3.7.6.13   Health advocacy organizations (e.g., local chapter of the     1=Yes; 0=Not mentioned
                      American Diabetes, Heart or Lung Association)
           3.7.6.14   Youth organizations (e.g., Boys & Girls Club)                 1=Yes; 0=Not mentioned
           3.7.6.15   Other Community Sector (please specify)                       Text
3.8                   Was there a publicly circulated preliminary draft?            1=Yes; 0=Not mentioned
                      (prior to the final version)
           3.8.1      Were there any specific Trust building activities in the      1=Yes; 0=Not mentioned
                      plan process?
           3.8.2      Did the process work to directly listen to children and       1=Yes; 0=Not mentioned
                      their concerns, ideas, or opinions?
           3.8.3      Did the process specifically work to strengthen the clarity   1=Yes; 0=Not mentioned
                      or power of community voices?
3.9                   Are there recommendations to create new groups                1=Yes; 0=Not mentioned
                      (such as a ped/bike advocacy group, new steering
                      committee or task force) ?
                                                                                                    If no, skip to 3.10
           3.9.1      If yes, please specify                                        Text



3.10                  Was any research specifically contracted as part of      1=Yes; 0=Not mentioned
                      the plan development?                                    If yes, please specify with whom.
3.11                  Free Text (e.g., details about which individuals/groups  Text
                      participated, which groups did NOT participate, selected
                      comments from participants, etc.)
          399927fd-fd65-4829-9a33-a7b63612472a.xls                                                                                                                                                   Page 7/22
    ITEM               VARIABLE DESCRIPTION                                        VARIABLE KEY                                         CODE   TEXT   When typing in a cell, ALT-Enter for a new line.     PAGE #
4                      Plan Goals & Objectives
    4.1                Is there a vision statement or "mission" statement for 1=Yes; 0=No
                       the plan?
                                                                                                      If no, skip to 4.2
              4.1.1       If yes, provide a brief summary of the vision            Text (be sure to include page number)
                          statement /mission statement
              4.1.2       Reference to readiness for change in the community       1=Yes; 0=No
                          regarding becoming more walkable/bikable or
                          increasing walking/biking
    4.2                Is a clear statement of Goals presented? (e.g.,             3=Goals are identified and most goals (>50%)
                       included and delineated with an explicit caption, heading   are linked to measurable objectives;
                       or section)                                                 2=Goals are identified and some goals (<=50%)
                                                                                   are linked to measurable objectives;
                                                                                   1=Goals are identified, but not linked to
                                                                                   measurable objectives;
                                                                                   0=No goals specified

                                                                                              If no clear statement, skip to 4.4
                       Which of the following specific items are incorporated Use for items 4.2.1-4.2.30:
                       in the statement of goals?                             1=Yes;
                                                                                   0=Not in GOALS/OBJECTIVES section but may
                                                                                   be elsewhere in plan (in which case list in the
                                                                                   text field for that question any items included
                                                                                   elsewhere)
              4.2.1    Take advantage of funding/resource availability (e.g.       1=Yes; 0=Not mentioned in section
                       State DOT grants)
              4.2.2    Enhance quality of life                                     1=Yes; 0=Not mentioned in section
              4.2.3    Improve pubic health                                        1=Yes; 0=Not mentioned in section
                                                                                           If public health not listed, skip to 4.2.5
              4.2.4    If specific health conditions are mentioned, please         Text
                       specify (e.g., cardiovascular disease, diabetes, obesity,
                       injuries, asthma)
              4.2.5    Encourage physical activity for leisure                     1=Yes; 0=Not mentioned in section
              4.2.6    Encourage physical activity for transportation              1=Yes; 0=Not mentioned in section
              4.2.7    Improve safety; prevent injuries/accidents                  1=Yes; 0=Not mentioned in section
              4.2.8    Create walkable community or “Active Community              1=Yes; 0=Not mentioned in section
                       Environments”
              4.2.9    Create a stronger “sense of place” or more                  1=Yes; 0=Not mentioned in section
                       meaningful environment for gathering
              4.2.10   Enhance aesthetics and community appearance                 1=Yes; 0=Not mentioned in section
              4.2.11   Support historic preservation/ cultural values              1=Yes; 0=Not mentioned in section
              4.2.12   Protect or preserve natural environment (e.g., land         1=Yes; 0=Not mentioned in section
                       conservation, protect open space, water quality)

              4.2.13   Address global climate change (e.g., reduce carbon    1=Yes; 0=Not mentioned in section
                       emissions)
              4.2.14   Protection from flooding, snow, natural hazards, etc. 1=Yes; 0=Not mentioned in section
                       (e.g. buffers, drainage designs, levies)
              4.2.15   Promote social equity                                 1=Yes; 0=Not mentioned in section
              4.2.16   Create a balanced transportation system; support non- 1=Yes; 0=Not mentioned in section
                       automobile travel
      399927fd-fd65-4829-9a33-a7b63612472a.xls                                                                                                                                                Page 8/22
ITEM               VARIABLE DESCRIPTION                                          VARIABLE KEY                                    CODE   TEXT   When typing in a cell, ALT-Enter for a new line.     PAGE #
          4.2.17   Instigate a cultural and attitudinal shift to accept          1=Yes; 0=Not mentioned in section
                   pedestrian/bicycle travel
          4.2.18   Enhance Ped or Bike network connectivity                      1=Yes; 0=Not mentioned in section
          4.2.19   Improve or maintain existing Ped/Bike facilities              1=Yes; 0=Not mentioned in section
          4.2.20   Reduce motor vehicle traffic congestion                       1=Yes; 0=Not mentioned in section
          4.2.21   Promote specific development patterns (e.g. facilitate        1=Yes; 0=Not mentioned in section
                   “smart growth” or “sustainable development”; reduce
                   “sprawl”; mixed use)
          4.2.22   Promote economic development                                  1=Yes; 0=Not mentioned in section
          4.2.23   Improve coordination among governments or                     1=Yes; 0=Not mentioned in section
                   between local, regional and state governments
          4.2.24   Comply with other policies mandated by state and              1=Yes; 0=Not mentioned in section
                   federal regulations (such as vehicle miles traveled
                   reductions)
          4.2.25   Improve policies to guide future investments and              1=Yes; 0=Not mentioned in section
                   coordinate with other community activities
          4.2.26   Increase encouragement activities                             1=Yes; 0=Not mentioned in section
          4.2.27   Improve educational programs                                  1=Yes; 0=Not mentioned in section
          4.2.28   Improve institutional treatment of ped/bike issues            1=Yes; 0=Not mentioned in section
          4.2.29   Integrate and coordinate with other plans                     1=Yes; 0=Not mentioned in section
          4.2.30   Encourage or increase social interaction or general           1=Yes; 0=Not mentioned in section
                   recreation (may include activities like picnicking, people-
                   watching, sitting in public squares, etc.)

          4.2.31   Other goals                                               Text
4.3                Are any procedural goals identified? (These include 1=Yes; 0=No
                   goals that would help to improve the process of plan-
                   making or public participation. For example, establishing
                   a Pedestrian or Bicycle Advocacy group, a new task
                   force, or new public participation strategies).

                                                                                                 If no, skip to 4.4
          4.3.1    If yes, please specify                                        Text
4.4                Use of SMART objectives? Does the plan articulate             3=Goals are identified and most goals (>50%)
                   Specific, Measurable, Actionable, Results-oriented, or        are linked to objectives;
                   Time-based objectives for stated goals?                       2=Goals are identified and some goals (<=50%)
                                                                                 are linked to objectives;
                                                                                 1=Goals are identified, but not linked to
                                                                                 objectives;
                                                                                 0=No goals specified
                                                                                                 If no, skip to 4.5
          4.4.1    Specific (Goals stated are unambiguous or are clarified 2=Yes, extensively; 1=Yes, some; 0=No
                   with objectives that do not require interpretation)

          4.4.2    Measurable (Includes quantitative or objective ways to        2=Yes, extensively; 1=Yes, some; 0=No
                   determine progress toward goals)
          4.4.3    Actionable (Goals can be acted upon, are realistic)           2=Yes, extensively; 1=Yes, some; 0=No
          4.4.4    Results-oriented (Defines what the intended outcome           2=Yes, extensively; 1=Yes, some; 0=No
                   or result is)
          4.4.5    Time-based (includes clear timeframes)                        2=Yes, extensively; 1=Yes, some; 0=No
          399927fd-fd65-4829-9a33-a7b63612472a.xls                                                                                                                                                          Page 9/22
    ITEM                VARIABLE DESCRIPTION                                             VARIABLE KEY                                          CODE   TEXT   When typing in a cell, ALT-Enter for a new line.     PAGE #
    4.5                 What is the plan's planning time horizon?                        Enter the explicit planning horizon in years (e.g.,
                        (many plans state 10 or 20 year planning horizons)               10) or enter 0 if none is stated.
              4.5.1     Are Short term goals stated? (1-2 years)                         1=Yes; 0=No
              4.5.2     Are Medium term goals stated? (3-7 years)                        1=Yes; 0=No
              4.5.3     Are Long term goals stated? (8-20 years)                         1=Yes; 0=No
    4.6                 Enter any other goals found elsewhere in the plan                Text
                        (other than in the goal section)
    4.7                 Theory of Change or Logic Model included                         2 = Present and detailed;
                        (Does the plan include a model or overall framework or           1 = Present but not detailed (described only
                        theory of change for achieving better conditions for             briefly or suggested in the plan);
                        pedestrians/bicyclists?)                                         0 = Not present
    4.8                 Free Text (any additional text that helps to provide a           Text (be sure to include page number)
                        qualitative “feel” for the plan’s vision, goals, and policies)
                        prompted by checklist. (Public participation, Health
                        related, Accident related, Air quality, Congestion, Equity,
                        Use & effectiveness, Funding, Collaboration, Integration
                        in other plans, Changes in perception of biking/walking,
                        Infrastructure related/CIP, Policy, Institutionalization,
                        Other)

5                       Analysis of Current Conditions and Trends
    5.1                 Does the plan provide an inventory, assessment, or               Inventory means "presence"; Asssessment
                        analysis of the following:                                       includes measures of quality or condition;
                                                                                         Analysis extends beyond the Inventory &
                                                                                         Assessement data to derive additional
                                                                                         observations.
              5.1.1     Existing facilities on-road and off-road for peds or             1=Yes; 0=No
                        bicycles (such as sidewalks, intersections, crosswalks,          If yes, specify
                        trails, greenways, footpaths)
              5.1.2     Connectivity between major trip origins and                      1=Yes; 0=No
                        destinations                                                     If yes, specify
              5.1.3     Barriers, obstructions, or hazards to pedestrian or              1=Yes; 0=No
                        bicycle travel (e.g., cul-de-sacs or unconnected                 If yes, specify
                        development; obstacles in sidewalks; poor or obstructed
                        lines of sight; high-speed traffic; natural barriers such as
                        steep terrain or river)
              5.1.4     Description of physical characteristics of pedestrian            1=Yes; 0=No
                        or bicycle facilities (e.g., lateral clearance, quality of       If yes, specify
                        surface)
              5.1.5     Condition of pedestrian or bicycle facilities (may               1=Yes; 0=No
                        include maintenance)                                             If yes, specify
              5.1.6     Adherence/compliance with current design standards               1=Yes; 0=No
                        for pedestrian and bicycle facilities (e.g., ASHTO/ADA,          If yes, specify
                        with respect to width, grade, curvature, sight distance,
                        markings, bridge requirements, intersection treatments)

              5.1.7     Description of current ped/bike demand                           1=Yes; 0=No
                        (e.g., downtown pedestrian counts, trail counts, use by          If yes, specify
                        peak and non-peak hours)
                                                                                                           If no, skip to 5.1.8
              5.1.7.1   If yes, please specify                                           Text
      399927fd-fd65-4829-9a33-a7b63612472a.xls                                                                                                                                        Page 10/22
ITEM                 VARIABLE DESCRIPTION                                          VARIABLE KEY                            CODE   TEXT   When typing in a cell, ALT-Enter for a new line.    PAGE #
          5.1.8    Analysis/description of trends with respect to          1=Yes; 0=No
                   pedestrian or bicycle demand and need for facilities
                   (historical trends and/or future forecasts)
5.2       Land use analysis
          5.2.1    Is there any analysis/description of land uses?         1=Yes; 0=No
                   (For example: trends for future development, discussion
                   of current land uses)
                                                                                                 If no, skip to 5.3
          5.2.1.1  If yes, does land use analysis identify areas of        1=Yes; 0=No
                   concentration of pedestrian or bicycle activity?
          5.2.2    Places of Employment or Major Employers                 1=Yes; 0=No
          5.2.3    Grocery stores/Shopping/Commercial/Retail areas         1=Yes; 0=No
          5.2.4    Residential areas                                       1=Yes; 0=No
          5.2.5    Mixed use development (e.g., both residential &         1=Yes; 0=No
                   commercial spaces combined in one building)
          5.2.6    Schools                                                 1=Yes; 0=No
          5.2.7    Health Care Destinations                                1=Yes; 0=No
          5.2.8    Parks & Recreation Centers                              1=Yes; 0=No
          5.2.9    Libraries                                               1=Yes; 0=No
          5.2.10   Other (please specify)                                  1=Yes; 0=No
5.3       Transportation analysis relative to planning pedestrian/bicycle facilities
          5.3.1    Are the locations of major roads identified?            1=Yes; 0=No
          5.3.2    Are pedestrian and bicycle facilities in relation to    1=Yes; 0=No
                   existing roads discussed?
          5.3.3    If the community has fixed-route transit, are the       999=Community does not have transit;
                   locations of major transit routes and stops identified? 1=Yes; 0=No

                                                                                                 If no, skip to 5.4
          5.3.3.1    Is pedestrian access to and from transit stops                1=Yes; 0=No
                     discussed? (e.g., ability to get to transit stops, shelters
                     and street furniture, sidewalk leading to stop, paved
                     landing, bus bay, way-finding signs, lighting)?

          5.3.3.2   Bikes on transit policies (racks or on-board)                  1=Yes; 0=No
5.4       Relationship to other plans - Which of the below are mentioned?
          5.4.1     Greenway plans                                        1=Yes; 0=No
          5.4.2     Open space plans                                      1=Yes; 0=No
          5.4.3     Parks and recreation plans                            1=Yes; 0=No
          5.4.4     A local complementary non-motorized mode plan         1=Separate plan or development of a separate
                                                                          plan is referenced;
                    (i.e., pedestrian plan if reviewing a bicycle plan; bicycle
                    plan if reviewing a ped plan)                         0=No separate plan is referenced or not
                                                                          applicable
          5.4.5      Regional or State Bicycle/Pedestrian Plans           1=Yes; 0=No
          5.4.6      Comprehensive land use plans ("Comp Plan")           1=Yes; 0=No
          5.4.6.1     Extent of integration/coordination with "Comp Plan" 2=Discussed in detail and/or uses strong
                                                                          language (such as “required”, “shall”);
                                                                          1=Mentioned only briefly or uses weak language
                                                                          (such as “should”, “may”);
                                                                          0=Not mentioned
          5.4.7      Neighborhood, subdivision, or area-level plans       1=Yes; 0=No
                     (includes Transit Oriented Development or "TODs")
          399927fd-fd65-4829-9a33-a7b63612472a.xls                                                                                                                                               Page 11/22
    ITEM               VARIABLE DESCRIPTION                                        VARIABLE KEY                                       CODE   TEXT   When typing in a cell, ALT-Enter for a new line.    PAGE #
              5.4.8    Capital Improvement Program ("CIP") or                      1=Yes; 0=No
                       Transportation Improvement Program (TIP)
              5.4.9    Plans for regional or adjacent jurisdictions          1=Yes; 0=No
              5.4.10   Corridor plans or route improvement plans             1=Yes; 0=No
              5.4.11   Transit plans                                         1=Yes; 0=No
              5.4.12   To what extent are these plans integrated with this   2=This Plan discusses integration with most of
                       Plan?                                                 the plans mentioned (>50%);
                                                                             1=This Plan discusses integration with some of
                                                                             the plans (<=50%);
                                                                             0=This Plan does not discuss integration with
                                                                             any of the above plans
              5.4.13   To what degree does the Plan discuss integration with 4=Most Plans (>50%) discussed in detail and/or
                       plans referenced in 5.4.1-5.4.11?                     uses strong language (such as “required”,
                                                                             “must”);
                                                                             3=Some plans (<=50%) discussed in detail
                                                                             and/or uses strong language (such as
                                                                             “required”, “must”);
                                                                             2=Most Plans (>50%) mentioned only briefly or
                                                                             uses weak language;1=Some plans (<=50%)
                                                                             mentioned only briefly);
                                                                             0=Not mentioned
              5.4.14   Are other plans mentioned? (please specify)           Text
              5.4.15   Free Text                                             Text
    5.5                Are Current Programs Described or Evaluated?          2=Discussed in detail; 1=Mentioned only briefly;
                                                                             0=No
                                                                                                     If no, skip to 5.6
              5.5.1    School-based education program (e.g., safe routes to        2=Discussed in detail; 1=Mentioned only briefly;
                       school or basics of bicycling)                              0=Not present
              5.5.2    Safety Campaign or targeted enforcement for peds or         2=Discussed in detail; 1=Mentioned only briefly;
                       bikes (e.g., "Yield to Peds", "Share the Road")             0=Not present
              5.5.3    Walk-to-School Day/Month                                    2=Discussed in detail; 1=Mentioned only briefly;
                                                                                   0=Not present
              5.5.4    Bike to Work Day                                            2=Discussed in detail; 1=Mentioned only briefly;
                                                                                   0=Not present
              5.5.5    Other (please specify)                                      2=Discussed in detail; 1=Mentioned only briefly;
                                                                                   0=Not present
    5.6                Free Text about current conditions & trends                 Text (be sure to include page number)
6                      Policies and Proposals
    6.1                Restrictions or burdens on Ped/Bicycle mobility
              6.1.1    Is riding bicycles on sidewalks permitted?                  3=Citywide restriction in place or proposed
                                                                                   2=Restriction proposed or in place for some
                                                                                   areas (e.g., downtown)
                                                                                   1=No prohibition for riding on sidewalks
                                                                                   proposed; 0=Not mentioned
              6.1.2    Are new restrictive or burdensome policies                  2=Mandated by the plan with prescriptive policy;
                       recommended or introduced in the plan? (e.g.,               1=Suggested in the plan; 0=No
                       walking or bicycling to school not permitted, restricting   If present, please specify
                       ped crossings across thoroughfares, etc.)
              6.1.3    Are pre-existing policies that restrict or burden           2=Discussed in detail; 1=Mentioned only briefly;
                       pedestrian or bicycle mobility discussed?                   0=No
                                                                                   If 2 or 1, please specify
      399927fd-fd65-4829-9a33-a7b63612472a.xls                                                                                                                                              Page 12/22
ITEM                 VARIABLE DESCRIPTION                                       VARIABLE KEY                                     CODE   TEXT   When typing in a cell, ALT-Enter for a new line.    PAGE #
6.2                  Are specific policies (or policy changes) proposed? If, For items 6.1-6.2.5
                     so select which of the following from the list below. 2=Discussed in detail; 1=Mentioned only briefly;
                                                                                0=Not present
                                                                                                 If no, skip to 6.3
          6.2.1      Traffic-calming initiatives (including speed humps, curb 2=Discussed in detail or mandated by the plan;
                     extensions, chicanes, "road diets", etc.)                1=Mentioned only briefly or suggested in the
                                                                                plan; 0=Not present
          6.2.2      Transit interface enhancements (e.g., shelters,            2=Discussed in detail or mandated by the plan;
                     marked stops, kiosks, landscaping)                         1=Mentioned only briefly or suggested in the
                                                                                plan; 0=Not present
          6.2.2.1    Other policies (please specify)                            Text
          6.2.3      Pedestrian or bicycle infrastructure projects &            2=Discussed in detail or mandated by the plan;
                     policies? If so, select which of the following from the    1=Mentioned only briefly or suggested in the
                     list below.                                                plan; 0=Not present
                                                                                                If no, skip to 6.2.4
          6.2.3.1    Maintenance of pedestrian or bicycle facilities (e.g.,     2=Discussed in detail or mandated by the plan;
                     policies pertaining to the maintenance of sidewalks,       1=Mentioned only briefly or suggested in the
                     trails, footpaths, crosswalks)                             plan; 0=Not present
          6.2.3.2    Retrofitting or upgrading existing pedestrian or           2=Discussed in detail or mandated by the plan;
                     bicycle facilities (includes surface improvements;         1=Mentioned only briefly or suggested in the
                     removal of barriers/obstructions, Crosswalk guidelines)    plan; 0=Not present

          6.2.3.3    Building new sidewalks/trails/greenways               2=Discussed in detail or mandated by the plan;
                                                                           1=Mentioned only briefly or suggested in the
                                                                           plan; 0=Not present
          6.2.3.4    New development (e.g., including or improving         2=Discussed in detail or mandated by the plan;
                     pedestrian or bicycle facilities in new development,  1=Mentioned only briefly or suggested in the
                     enhancing on-site pedestrian access from developments plan; 0=Not present
                     to curbside; enhancing off-site access to connect to
                     existing sidewalks)
          6.2.3.5    Encouraging worksites or firms to enhance access to        2=Discussed in detail or mandated by the plan;
                     pedestrian or bicycle facilities                           1=Mentioned only briefly or suggested in the
                                                                                plan; 0=Not present
          6.2.3.6    Recommending “Complete Streets” efforts?                   2=Discussed in detail or mandated by the plan;
                                                                                1=Mentioned only briefly or suggested in the
                                                                                plan; 0=Not present
          6.2.3.7    Policies or projects that specifically address             2=Discussed in detail or mandated by the plan;
                     equity/social justice (e.g., improving access to           1=Mentioned only briefly or suggested in the
                     ped/bike facilities in lower-income neighborhoods)         plan; 0=Not present
          6.2.3.8    Signal timing (Leading pedestrian intervals, shorter       2=Discussed in detail or mandated by the plan;
                     cycle times, "walk" phase assumption about walking         1=Mentioned only briefly or suggested in the
                     speeds, etc.)                                              plan; 0=Not present
          6.2.3.9    Visual diability policies or projects with mobility        2=Discussed in detail or mandated by the plan;
                     enhancements for vision-impaired people (blind, low-       1=Mentioned only briefly or suggested in the
                     vision)                                                    plan; 0=Not present
          6.2.3.10   Physical disability policies or projects with mobility     2=Discussed in detail or mandated by the plan;
                     enhancements for mobility-impaired people                  1=Mentioned only briefly or suggested in the
                     (wheelchair users, people with walkers, etc.)              plan; 0=Not present
          6.2.4      School policies facilitating walking/bicycling to local    2=Discussed in detail or mandated by the plan;
                     school                                                     1=Mentioned only briefly or suggested in the
                                                                                plan; 0=Not present
      399927fd-fd65-4829-9a33-a7b63612472a.xls                                                                                                                                                     Page 13/22
ITEM                VARIABLE DESCRIPTION                                           VARIABLE KEY                                         CODE   TEXT   When typing in a cell, ALT-Enter for a new line.    PAGE #
          6.2.5     Bicycle helmet law (for adults and/or children under at        3=Existing or recommended policy applies to all
                    certain age) Note in text if the law already exists or if it   riders; 2=Existing or recommended policy
                    is proposed.                                                   applies to children only; 1=It is noted that there
                                                                                   is no helmet law and a law is not recommended;
                                                                                   0=Not present
6.3                 Are specific land use implementation tools                     1=Yes; 0=No
                    mentioned? If yes, select which from the list below.
                                                                                                    If no, skip to 6.4
          6.3.1     Land Trusts                                                    1=Yes; 0=No
          6.3.2     Conservation easements                                         1=Yes; 0=No
          6.3.3     Transfer/Purchase of development rights                        1=Yes; 0=No
          6.3.4     Impact Fees                                                    1=Yes; 0=No
          6.3.5     Zoning Ordinances such as subdivision ordinances,              1=Yes; 0=No
                    and "concurrency" requirements (items governing
                    development and supporting infrastructure)

          6.3.6     If a unique or unusual type of ordinance is                    Text
                    mentioned, please specify
          6.3.7     Creation of special, explicit pedestrian-oriented              1=Yes; 0=No
                    zoning designations for walkable commercial centers
                    or neighborhood areas
          6.3.8     Other (Text)                                                   Text
6.4                 Which of the following requirements or guidelines
                    for projects are proposed or discussed:
          6.4.1     State requirements/guidelines regarding the presence           1=Yes; 0=No
                    of facilities (for example State Department of
                    Transportation adopted guidelines or warrants for
                    pedestrian crossings, or policies for sidewalks on
                    bridges or along roads, or bicycle access to limited
                    access freeways)
          6.4.2     Federal requirements and guidelines (such as the               2=Compliance transition plan included; 1=Yes;
                    Americans with Disabilities Act/ADA)                           0=No
          6.4.2.1   Is the concept of "universal design" mentioned in the          1=Yes; 0=No
                    plan?
          6.4.3.    Area-wide transportation projects contained in the             1=Yes; 0=No
                    transportation improvement program (TIP) or the capital
                    improvement plan (CIP), including an update of their
                    project development stage
          6.4.4     Specific design guidelines                                     1=Yes; 0=No
          6.4.5     Urban form guidelines (e.g., form-based codes)+D299            1=Yes; 0=No

          6.4.6     Zoning changes                                                 1=Yes; 0=No
          6.4.7     School siting guidelines                                       1=Yes; 0=No
6.5                 Which of the following incentives, programs, or
                    encouragement strategies are specifically discussed
                    or proposed:
          6.5.1     Incentive programs (e.g., parking cash-out, bicycle to         1=Yes; 0=No
                    work reward programs)
          6.5.2     Commuter alternative programs (Ride-share, free bus            1=Yes; 0=No
                    pass)
      399927fd-fd65-4829-9a33-a7b63612472a.xls                                                                                                                                        Page 14/22
ITEM              VARIABLE DESCRIPTION                                      VARIABLE KEY                                   CODE   TEXT   When typing in a cell, ALT-Enter for a new line.    PAGE #
          6.5.3   Health-related programs to promote biking/walking         1=Yes; 0=No
                  (e.g., programs sponsored by Hospitals, HMOs, Public
                  Health, or Health Advocacy organizations)
          6.5.4   On-going promotional activities or that engage            1=Yes; 0=No
                  individuals in physical activity indirectly (e.g., Safe
                  Routes to School, Earth Day, Walk to School Day, and
                  other advocacy initiatives)
          6.5.5   Recreational walking programs (e.g., parks & rec          1=Yes; 0=No
                  walking groups, organized bicycle rides)
6.6               Are any safety and/or educational programs                1=Yes; 0=No
                  discussed or proposed? If yes, select which from the
                  list below
                                                                                            If no, skip to 6.7
          6.6.1   Law Enforcement Programs (e.g., enforcement of            1=Yes; 0=No
                  jaywalking, yield to pedestrians, speed control, etc.)
          6.6.2   Faith-based programs                                      1=Yes; 0=No
          6.6.3   Youth-organization programs                               1=Yes; 0=No
          6.6.4   Local agency initiatives                                  1=Yes; 0=No
          6.6.5   School-based initiatives                                  1=Yes; 0=No
          6.6.6   Driver training/driver education initiatives              1=Yes; 0=No
          6.6.7   Local non-governmental programs (e.g., League of          1=Yes; 0=No
                  American Bicyclists' (LAB) courses)
          6.6.8   Is funding for research recommended?                      1=Yes; 0=No
          6.6.9   Other                                                     Text
6.7               Are policies proposed to address the needs of             1=Yes; 0=No
                  special populations (e.g., minority groups, lower
                  income groups, persons with disabilities)?
                                                                                            If no, skip to 6.8
          6.7.1   If yes, please specify                                    Text




6.8               Are Funding amounts for implementation mentioned?         1=Yes; 0=No

                                                                                            If no, skip to 6.9
          6.8.1   Do funding recommendations include specific budget        2=Detailed budget breakdown by plan
                  needs?                                                    component; 1=Budget request provided at the
                                                                            agency level; 0=No detail provided
          6.8.2   Are funding timeframes specified?                         3=Multi-year budgets proposed with annual
                                                                            budget detail; 2=Budget proposed based on
                                                                            phased implementation; 1=Timeline for budget
                                                                            but unclear or difficult to understand; 0=No
                                                                            specific timeframes referenced
6.9               Are policies proposed to take advantage of unique         1=Yes; 0=No
                  opportunities? (e.g., unique funding opportunities;
                  "piggybacking" on a highway project to build a sidewalk;
                  making use of brownfield sites)
          6.9.1   Does the plan mention the use of gas tax funds (in NC 1=Yes; 0=No
                  the Powell Bill) for pedestrian improvements?
       399927fd-fd65-4829-9a33-a7b63612472a.xls                                                                                                                             Page 15/22
ITEM                 VARIABLE DESCRIPTION                                       VARIABLE KEY                     CODE   TEXT   When typing in a cell, ALT-Enter for a new line.    PAGE #
6.10                 Does the plan make specific recommendations to              999=Community does not have a
                     modify the comprehensive plan regarding pedestrian comprehensive plan;
                     or bicycle issues (e.g., to include policies promoting      1=Yes; 0=No
                     ped/bike access or safety, amend language to
                     strengthen existing policies, improve pedestrian
                     facilities, monitor the use of pedestrian facilities, etc.)

6.11                 Other funding sources or resource mobilization            Text
                     strategies used, including non-governmental funding or
                     initiatives (if any)
6.12                 Which of the following facilities and improvements
                     (physical projects) are specifically recommended:
           6.12.1    Intersection & crosswalk treatments (e.g., curb cuts, 1=Yes; 0=No
                     traffic signals, count-down ped signals, crosswalks, mid-
                     block crossings, median islands, bulb-outs)

           6.12.2    Streetscape improvements (lighting, planting,              1=Yes; 0=No
                     buffering)
           6.12.3    Pedestrian or bicycle way-finding aides and markers        1=Yes; 0=No
                     (e.g., signals, signs, signed bicycle routes--not bike
                     lanes)
           6.12.4    Increasing number or quality of street trees               1=Yes; 0=No
           6.12.5    Bicycle lanes                                              1=Yes; 0=No
           6.12.6    Bicycle boulevards (reduced vehicle traffic streets with   1=Yes; 0=No
                     through-routes for bicycles only)
           6.12.7    Segregated on-street bicycle facilities (bicycle tracks    1=Yes; 0=No
                     or raised bicycle lanes)
           6.12.8    Dedicated bicycle signals                                  1=Yes; 0=No
           6.12.9    Sharrows (shared lane pavement markings)                   1=Yes; 0=No
           6.12.10   Pedestrian crosswalk flags                                 1=Yes; 0=No
           6.12.11   Specific recommendations for innovative signage or         1=Yes; 0=No
                     pavement treatments (e.g., painted "bike boxes" at
                     intersections)
6.13                 Were policies developed to specifically address            1=Yes; 0=No
                     certain demographic groups within the population?          Text
                     (Specifiy which users were targeted)
           6.13.1    Experienced/committed bike riders/walkers,                 1=Yes; 0=No
                     Inexperienced/casual bike riders/walkers
           6.13.2    Very young children (under 5), older                       1=Yes; 0=No
                     children/teenagers (5 - 18), or Older adults
           6.13.3    Urban, suburban, or rural populations                      1=Yes; 0=No
           6.13.4    Other (specify)                                            1=Yes; 0=No
6.14                 Are any restrictions or fees for automobiles               1=Yes; 0=No
                     discussed?
           6.14.1    Parking fees                                               1=Yes; 0=No
           6.14.2    Restrictions on vehicle access                             1=Yes; 0=No
           6.14.3    Weekly street closures (for community markets,             1=Yes; 0=No
                     pedestrian, or bicycle activities)
           6.14.4    Car-Free Streets                                           1=Yes; 0=No
           6.14.5    Speed limit reductions                                     1=Yes; 0=No
           399927fd-fd65-4829-9a33-a7b63612472a.xls                                                                                                                                     Page 16/22
    ITEM                  VARIABLE DESCRIPTION                                       VARIABLE KEY                            CODE   TEXT   When typing in a cell, ALT-Enter for a new line.    PAGE #
               6.14.6     Lane reductions or "road diets"                            1=Yes; 0=No
               6.14.7     Other                                                      1=Yes; 0=No
    6.15                  Free Text                                                  Text
7                         Implementation
    7.1                   Are indicators of outcomes provided? If yes, select        2=Yes, numerical (quantitative);
                          which from the list below.                                 1=Yes, qualitative only; 0=No mention
                                                                                                      If no, skip to 7.2
               7.1.1      "Level of Service" (LOS, "Quality of Service", etc.)       1=Yes; 0=No
               7.1.2      Mode share (percent using non-auto modes)                  1=Yes; 0=No
               7.1.3      Sidewalks (percent of streets w/ sidewalks)                1=Yes; 0=No
               7.1.4      Percent of population accessing transit by walking         1=Yes; 0=No
               7.1.5      Percent of population near transit route                   1=Yes; 0=No
               7.1.6      Percent of population living near bikeway/trail            1=Yes; 0=No
               7.1.7      Percent of population obese or overweight                  1=Yes; 0=No
               7.1.8      Percent of population meeting physical activity            1=Yes; 0=No
                          guidelines (e.g., CDC/ACSM/IOM)
               7.1.9      Measures of use of multi-use trails/Bike paths             1=Yes; 0=No
               7.1.10     Any pedestrian counts / bicycle counts                     1=Yes; 0=No
               7.1.10.1   Routine bicycle cordon counts                              1=Yes; 0=No
               7.1.10.2   Routine pedestrian counts in specified areas               1=Yes; 0=No
               7.1.11     Percent destinations accessible within walking time        1=Yes; 0=No
                          (for pedestrians)
               7.1.12     Miles of sidewalks/trails                                  1=Yes; 0=No
               7.1.13     Pedestrian/Bicycle safety - injury/fatality rates          1=Yes; 0=No
               7.1.14     Rates of walking to school                                 1=Yes; 0=No
               7.1.15     Enforcement campaigns accomplished                         1=Yes; 0=No
               7.1.16     Other (as necessary or useful, please provide detailed     Text
                          parameters for any of above)
    7.2                   Are indicators for specific population subgroups           1=Yes; 0=No
                          mentioned? (e.g., age groups, minority populations,
                          persons with disabilities)
                                                                                                      If no, skip to 7.3
               7.2.1      If yes, please specify                                     Text
    7.3                   Are indicators for other specific issues identified?       1=Yes; 0=No
                          (e.g., safety)
                                                                                                      If no, skip to 7.4
               7.3.1      If yes, please specify                                     Text
    7.4                   Are implementation priorities identified, or is a          1=Yes; 0=No
                          phased approach recommended?
                                                                                                      If no, skip to 7.5
               7.4.1      If yes, are the criteria for selecting priorities clear?   1=Yes; 0=No
                                                                                                      If no, skip to 7.5
               7.4.1.1    If yes, provide a brief summary (optional)                Text
    7.5                   Are there maps of priority areas or corridors for         1=Yes; 0=No
                          projects, investments or treatments, because of actual or
                          perceived concerns?
    7.6                   Are there maps of locations of proposed projects          1=Yes; 0=No
                          relative to key landmarks?
       399927fd-fd65-4829-9a33-a7b63612472a.xls                                                                                                                                             Page 17/22
ITEM                  VARIABLE DESCRIPTION                                      VARIABLE KEY                                     CODE   TEXT   When typing in a cell, ALT-Enter for a new line.    PAGE #
7.7                   Are there maps with overlays of relevant                  1=Yes; 0=No
                      complementary investments and plans
                      (comprehensive transportation plan, the transportation
                      improvement program, the capital improvements plan,
                      and the proposed land use plan of the area)?

7.8                   Are implementation actions tied spatially to corridors,   1=Yes; 0=No
                      priority areas, or distinct locations?
7.9                   Are specific actions, tasks, or recommendations to        2=Discussed in detail or mandated;
                      motivate implementation of the plan discussed or          1=Mentioned only briefly or suggested;
                      proposed?                                                 0 = No specific actions mentioned
           7.9.1      Enouragement campaign?                                    1=Yes; 0=No
           7.9.2      Public Education campaign?                                1=Yes; 0=No
           7.9.3      Enforcement campaign?                                     1=Yes; 0=No
7.10                  Are person/organizations/agencies accountable for         1=Yes; 0=No
                      implementation clearly identified? (this is separate
                      accountability from monitoring/evaluation)

           7.10.1     Identification of a coordinator agency to implement       1=Yes; 0=No
                      plan?
           7.10.1.1   Which agency is the lead?                                 Transportation; Public Works; Development &
                                                                                Land Use; Strategic Planning (separate entity
                                                                                from DOT or PW); Parks & Rec; Mayor's office;
                                                                                City Council; Other department; Non-
                                                                                Governmental Organization; Other external
                                                                                agency
           7.10.1.2   Is a specific coordinator position identified to          1=Yes; 0=No
                      implement the plan?
           7.10.1.3   Is education or training for professionals in planning    2=Discussed in detail or mandated by the plan;
                      and transportation included in the plan?                  1=Mentioned only briefly or suggested in the
                                                                                plan; 0 = None mentioned
                      Is there a commitment for implementation from             1=Yes; 0=No
           7.10.2     agencies other than transportation/public works?
                                                                                                 If no, skip to 7.11
           7.10.2.1   Specify government agencies                           Text
           7.10.2.2   Non-governmental partners in implementation           Text
7.11                  Are changes in resources proposed? (e.g., staffing or 1=Yes; 0=No
                      other resources)

7.12                  Are specific funding strategies identified for each       1=Yes; 0=No
                      implementation action?

           7.12.1     Innovative funding ideas?                             1=Yes; 0=No
           7.12.2     Is language recommending funding equity included? 1=Yes; 0=No
                      (non-motorized planning at a comparable rate to other
                      modes recommended?
           399927fd-fd65-4829-9a33-a7b63612472a.xls                                                                                                                                                  Page 18/22
    ITEM                VARIABLE DESCRIPTION                                          VARIABLE KEY                                        CODE   TEXT   When typing in a cell, ALT-Enter for a new line.    PAGE #
    7.13                Are policies and proposals mandatory / strongly               2=Discussed in detail or mandated by the plan
                        worded (shall /require) as opposed to suggestive /            (i.e., prescriptive policy statement using strong
                        weakly worded (should / may)?                                 language such as “required”, “shall”);
                                                                                      1=Mentioned only briefly or suggested in the
                                                                                      plan (i.e., exhortative policy statement using
                                                                                      weak language such as “should”, “may”);
                                                                                      0 = No policies/proposals
    7.14                Is a timeline for implementation of various tasks             2 =Yes, and timeline identifies
                        provided?                                                     resources/investments tied to specific funding
                                                                                      sources;
                                                                                      1=Yes, but timeline does NOT identify
                                                                                      resources/investments tied to specific funding
                                                                                      sources;
                                                                                      0 = No timeline for implementation
    7.15                Does the plan recommend an evaluation plan or ways            1=Yes; 0=No
                        to specifically measure progress?
                                                                                                        If no, skip to 7.16
               7.15.1   If yes, are persons/organizations/agencies accountable        1=Yes; 0=No
                        for evaluation clearly identified?
               7.15.2   Proposed evaluation categories?                               Text
                        (e.g., Health (obesity, PA, disease), Crashes, Air quality,
                        Congestion, Use, Mode share, Investment,
                        Collaboration, Integration in other plans, Change in
                        perception of importance of bike/ped issues/facilities,
                        Infrastructure created)
               7.15.3   Proposed evaluation methods?                                  Text
               7.15.4   Include ped-bike modes in transportation surveys              1=Yes; 0=No
                        and models
               7.15.5   Perform user surveys to identify problems and barriers        1=Yes; 0=No
                        to ped-bike travel?
    7.16                Are any possible barriers to implementation                   1=Yes; 0=No
                        mentioned in the plan?
               7.16.1   Liability concerns mentioned                                  1=Yes; 0=No
               7.16.2   Presence of a hostile environment created by cars             1=Yes; 0=No

               7.16.3   Lack of technical skill or experience                         1=Yes; 0=No
               7.16.4   Reference to any possible opponents to the plan               1=Yes; 0=No
    7.17                Does the Master Plan have a proposed public                   1=Yes; 0=No
                        notification process to alert the public to progress? E.g.
                        websites, newsletters etc.
    7.18                Free Text - Provide any additional comments relevant to       Text
                        implementation
8                       Overall Comments
    8.1                 Comments on document structure & organization.                Text

    8.2                 Comments on intended audience of the plan.                    Text

    8.3                 Does the plan make it clear what the policy impacts Text
                        of the plan are? (above and beyond any recommended
                        project list or construction)
      399927fd-fd65-4829-9a33-a7b63612472a.xls                                                                                                                                                Page 19/22
ITEM              VARIABLE DESCRIPTION                                       VARIABLE KEY                                          CODE   TEXT   When typing in a cell, ALT-Enter for a new line.    PAGE #
8.4               Names of individuals & consultants credited for the Text
                  plan's development as staff, consultants, or advisory
                  committee members (if possible to copy and paste from
                  Plan)
8.5               Any other comments about the plan's process.                Text
                  Were any parallel processes or programs taking place
                  while this plan was being developed that may have
                  influenced the outcomes in the region and affected the
                  priorities or scope of the effort positively or negatively?

8.6               FREE TEXT                                                  Text
                  Provide any additional comments that reflect your
                  impression of the plan as a whole.
                  Propose here any questions or suggestions for
                  further research.
8.7               Overall, where would you rate this plan as a model         5=Exemplary plan in many aspects;
                  plan on a scale of 1-5. (Extent to which other             4=Exemplary in one or a few aspects;
                  communities could learn from the achievements of this      3=Notable efforts and approaches;
                  planning process or planning document.)                    2=Not meriting additional attention;
                                                                             1=Undistinguished
                                                                             TEXT - For '3' or '4' ratings only, please list the
                                                                             elements you consider model.
END                                                                                                                                       END
9   Glossary   Add Terms as Discovered in either Coding Sheet or Plans
    Item       Term
               Bulb-out = Curb Extension =
               Bump out = Curb Bulb
    3.7.1      Advocacy Organization
ered in either Coding Sheet or Plans
           Definition                                              Page
          A way to narrow the distance required to cross the
          street by widening the sidewalk into the street. This
          also has the and Non-Governmental organization
          A Non-profit effect of slowing down the turning speed.
          promotes change, serves as a key voice on an issue,
          and engages in political processes.
Geographic_Scope
City
County
Region
State
Other…

Plan_type
Pedestrian
Bicycle
Bike-Ped
Non-motorized
Multi-modal Transportation Plan
Comp Plan
Trails Plan
Parks & Recreation
Sidewalks Plan
Other…

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:14
posted:8/16/2011
language:English
pages:22