011808AttachmentIIIP - County of San Diego

Document Sample
011808AttachmentIIIP - County of San Diego Powered By Docstoc
					Proposition 1B Local Streets and Roads Funding Proposals
Instructions for completing data entry in the Project List Outline Excel Spreadsheet:
     General:
      ● Please change the title of the spreadsheet to reflect the name of your city or county and
         e-mail the completed form under that name. Otherwise, it will not feed into the website data base
         properly and we may have to ask that you resubmit your plan.
      ● Please limit descriptions to no more than 25 words. (Field will automatically expand to fit data entered.)
      ● Please remember that the purpose of submitting the plans in this electronic format is so that
         they can be used for public consumption. Please make sure that plans and descriptions read in
         a clear and understandable way.
      ● Please do not attempt to change any of the fields or formats in any way. The sheets are designed
         to feed into a data base that requires the existing formatting parameters.

    This workbook contains 4 worksheets (or tabs) that require data entry. The worksheets are:
     ● A-General (Entity Level)
     ● B-Maintenance Program
     ● C-Minor Projects
     ● D-Major Projects

    All worksheets are protected to retain the integrity of the workbook and the accuracy of the entered data.
    The cells that require data entry are filled with the color yellow, and are 'unlocked' to allow data entry.
    If a cell is not filled with the color yellow, data entry in those cells is not allowed.

    All worksheets identify the title/type of data entry that is required and each yellow data entry cell is formatted
    for the data that is entered.

    For example:
     ● To enter the date of September 30, 2009, enter the month number / day number / and year number as
         follows: 9/30/09
     ● To enter a dollar amount, enter the amount in whole dollars, without any commas or dollar signs.
         For $9,245,000 enter the numbers 9245000 and the amount will be properly displayed with the $ and
         commas.

    The Major Projects Initial List worksheet contain lines for the data entry of 6 projects. If you have more
    than 6 projects and require additional lines, click on the gray macro button that begins "To insert a line . .".
    Each time you click the macro button, one line will be added. If the macro buttons do not operate, your
    computer probably has the security level set to very high. If you re-set the security level to a lower
    level, the macros should operate as designed.

    For questions or problems, please contact Jim Parks or Mark Tollefson at the Department of Finance
    for assistance, at (916) 322-2263 or by e-mail at: Prop1B_LSR@dof.ca.gov.
Proposition 1B Local Streets and Roads Funding Proposals
                                                                                                       2007-08 Data
Mandatory Information:
 Entity Name (City or County)                                                         County of San Diego
 County in which Recipient Entity is Located                                          County of San Diego
 Principal Contact Data for Prop 1B Program:
   Name                                                                               Donna K. Turbyfill
   E-mail Address                                                                     Donna.Turbyfill@sdcounty.ca.gov
   Phone Number                                                                       858-505-6470
                                                                                      5555 Overland Ave, Suite 2156, San Diego CA
   Address                                                                            92123
  Date Local Prop1B Streets & Roads Program Budget Adopted by Board/Council                 December 5, 2007 (Item 11) Attached
  Total from other tabs                                                                $                                   28,050,095
  Total 2007-08 allocation (should tie to totals on all other tabs)                   $27,991,050

Highly Recommended Information:
 Local web link (for additional overall program information, such as maps, detailed
 project information, etc. provided by city or county)                                http://www.sdcounty.ca.gov/dpw/




The following tabs provide separate sheets for three categories of Prop 1B Local Street & Road Maintenance Projects: Maintenance, Minor
Projects, and Major Projects.




D:\Docstoc\Working\pdf\d8c619ac-1d4f-4af0-8af6-fcf713c09ace.xls
4/12/2010, 10:00 PM A-General (Entity Level) Tab                                                                                          page 2 of 7
           Proposition 1B Local Streets and Roads Funding Proposals
           Maintenance Program
           Note: Major maintenance projects (over $400,000) may be included here or on the Major Projects spreadsheet.
                                                                                                                             2007-08 Data
           Project Proposals:
            Mandatory Information:
              Total Prop 1B Funding to be Used for Local Maintenance Category (in whole dollars)                         $                  -
              Estimated Prop 1B Program Completion Date (MM/DD/YYYY)
              Average Estimated Useful Life of all Maintenance Category Work Funded with Prop 1B Funds (in years)

             Highly Recommended Information:
              Backlog of Maintenance Work as of 7/1/07 (in whole dollars)
              Anticipated Backlog of Maintenance Work as of 6/30/08 (in whole dollars)
              Un-obligated Balance in Local Road Account as of 6/30/07 (in whole dollars)

             Optional Information (in whole dollars):
                Total Prop 1B Funding for Pavement Repairs (pothole filling/crack filling/minor pavement patching)
                Total Prop 1B Funding for Slurry Seals
                Total Prop 1B Funding for Resurfacing, Including Full or Partial Reconstruction
                Total Prop 1B Funding for Bridge Repair and Replacement
                Total Prop 1B Funding for non-Driving Surface Work (landscaping/signage/safety/ADA/sidewalks, etc.)
                Total Prop 1B Funding for Weather and Accident Repairs and Snow Removal
                    Total (should equal Maintenance Category total at top of page)                                       $                  -




D:\Docstoc\Working\pdf\d8c619ac-1d4f-4af0-8af6-fcf713c09ace.xls
4/12/2010, 10:00 PM B-Maintenance Program Tab                                                                                                   page 3 of 7
Proposition 1B Local Streets and Roads Funding Proposals
Minor Projects (Projects costing less than $400,000)
                                                                                                              2007-08 Data
Project Proposals:
 Required Information:
   Total Prop 1B Funding for Minor non-Maintenance Project Category-Projects Costing Less than $400,000
   (in whole dollars)                                                                                     $        70,274
   Estimated Prop 1B Program Completion Date (MM/DD/YYYY)                                                  12/2/2007 (11)
   Average Expected Useful Life of Minor Projects Funded with Prop 1B Funds (in years)                          20+

  Optional Information (in whole dollars):
   Total Prop 1B Funding for New Traffic Signals
   Total Prop 1B Funding for Street Extensions and New Streets
   Total Prop 1B Funding for New/Improved Landscaping/Signage/Safety/et. al.                              $          70,274
   Total Prop 1B Funding for Transit related Projects
       Total (should equal total Minor Project Category total at top of page)                             $          70,274




D:\Docstoc\Working\pdf\d8c619ac-1d4f-4af0-8af6-fcf713c09ace.xls
4/12/2010, 10:00 PM C-Minor Projects Tab                                                                                      page 4 of 7
    Proposition 1B Local Streets and Roads Funding Proposals
    Major Projects (Projects costing more than $400,000)


    Proposed Projects                                                                                                                                                                                                                                                               Description     (Required)
                                                                                                       Description
                              Project Name (List Each Project Separately)                                                                         Location                                                              Project Budget (in whole dollars)
                                                                                                     (Type of Work,
                                                                                                                                                                                                       Funding from     Funding from                               Other                          Planning &         Planning &
                                                                                                    Major Materials,                                                                                                                           Other Local                      Other Federal
                                                                                                                            Street/Road Name(s)      Starting Point & Ending Point       Total Cost      Prop 1B -         other                                   State                        Environmental-     Environmental-
                                                                                                        New, or                                                                                                                                 Funding                           Funding
                                                                                                                                                                                                          LS&Rs           Prop 1B                                 Funding                       Beginning Date      Ending Date
                                                                                                      Replacement)
    Valley Center Road improvements Phase 2 (Construction Contract Augmentation)                   Road Widening        Valley Center Road          4000' So of    700' East of
1                                                                                                                                                   Ridge Ranch    Cole Grade Rd     $    52,160,000       $5,000,000                      $     47,160,000
    Install Metal Beam Guard Rails and Various Locations Throughout the County                     New Guard Rails      Various (see list)          Road on
                                                                                                                                                    See List       See List of Web
2                                                                                                                                                   Web Site       Site              $     1,234,000   $     932,000                       $        302,000                                       N/A (Cat Ex)     N/A (Cat Exempt)
    Countywide Maintained Road Asphalt Concrete Overlay and Culvert Replacement Project            Resurfacing and      Various (see list)          See List on    See List of Web
                                                                                                   Culvert                                          Web Site       Site
3                                                                                                  Replacements                                                                      $    25,000,000   $   22,047,821                      $      3,000,000                                       N/A (Cat Ex)     NA (Cat Exempt)
4
5
6
                                                                                                                                                                          Total      $    78,394,000   $   27,979,821   $              -   $     50,462,000   $             -   $           -


    Optional Information (in whole dollars):
       Project Type Categories (individual projects may fit into more than one category):
          Total Prop 1B Funding for Traffic Signals
          Total Prop 1B Funding for Major Pavement Maintenance and Rehabilitation                  $      22,000,000
          Total Prop 1B Funding for Street Extensions, Lane Additions, and New Streets             $       5,000,000
          Total Prop 1B Funding for Landscaping/signage/safety/ADA/et. al.
          Total Prop 1B Funding for Bridge Repair, Replacement, and New Construction               $        1,234,000
          Total Prop 1B Funding for Transit related Projects
              Total (should equal total of Prop 1B LS&Rs funding from Project Budget data above)   $      28,234,000




               D:\Docstoc\Working\pdf\d8c619ac-1d4f-4af0-8af6-fcf713c09ace.xls
               4/12/2010, 10:00 PM D-Major Projects Initial List Tab                                                                                                                                                                                                                                       page 5 of 7
    Proposition 1B Local Streets and Roads Funding Proposals
    Major Projects (Projects costing more than $400,000)


    Proposed Projects                                         Description        (Required)                                                                                                                                                                                   Expected Benefit       (Highly Recommende
                              Project Name (List Each Project Separately)                                             Project Timeline - Scheduled completion dates (MM/DD/YYYY)                                                                                           Daily        Expected
                                                                                                                                                                                                                                    Expected Useful                        Travel         Daily
                                                                                                                                                                                                                                                       Lane Miles
                                                                                                                                     Right-of-Way    Right-of-Way                                  Project Closed                         Life                              Time           Use
                                                                                                      Design-       Design-Ending                                    Construction-  Construction-                  Project Closed                        Added
                                                                                                                                     Acquisition-    Acquisition-                                  Out-Beginning                       (in years)                         Savings      (vehicles /
                                                                                                   Beginning Date        Date                                       Beginning Date Completion Date                Out-Ending Date
                                                                                                                                    Beginning Date   Ending Date                                        Date                                                              (hours)        riders)
    Valley Center Road improvements Phase 2 (Construction Contract Augmentation)
1                                                                                                                                                                      12/1/2005      6/24/2009       6/25/2009      6/25/2010           20+                        8
    Install Metal Beam Guard Rails and Various Locations Throughout the County
2                                                                                                     1/2/2008        2/26/2008          N/A             N/A           5/22/2008      8/30/2008       9/12/2008      9/12/2009           20+          N/A               N/A           N/A
    Countywide Maintained Road Asphalt Concrete Overlay and Culvert Replacement Project

3                                                                                                     8/1/2007        2/14/2008          N/A             N/A           5/12/2008     10/12/2008       12/1/2008       2/1/2009           20+          N/A               N/A           N/A
4
5
6




    Optional Information (in whole dollars):
       Project Type Categories (individual projects may fit into more than one category):
          Total Prop 1B Funding for Traffic Signals
          Total Prop 1B Funding for Major Pavement Maintenance and Rehabilitation
          Total Prop 1B Funding for Street Extensions, Lane Additions, and New Streets
          Total Prop 1B Funding for Landscaping/signage/safety/ADA/et. al.
          Total Prop 1B Funding for Bridge Repair, Replacement, and New Construction
          Total Prop 1B Funding for Transit related Projects
              Total (should equal total of Prop 1B LS&Rs funding from Project Budget data above)




               D:\Docstoc\Working\pdf\d8c619ac-1d4f-4af0-8af6-fcf713c09ace.xls
               4/12/2010, 10:00 PM D-Major Projects Initial List Tab                                                                                                                                                                                                                        page 6 of 7
    Proposition 1B Local Streets and Roads Funding Proposals
    Major Projects (Projects costing more than $400,000)


    Proposed Projects                                                            Expected Benefit   (Highly Recommended)                           Additional Information (Optional)
                              Project Name (List Each Project Separately)                                                            Useful Life
                                                                                                          Annual
                                                                                                                         Lane        Extension                         Project Contact
                                                                                                       Reduction in                                 Link to Maps
                                                                                                                         Miles         (major                         (e-mail, website,
                                                                                                      the Number of                                  or Pictures
                                                                                                                       Maintained   maintenance                           or phone)
                                                                                                        Accidents
                                                                                                                                      in years)
    Valley Center Road improvements Phase 2 (Construction Contract Augmentation)                                                                                   Michael.Long@sdcounty
1                                                                                                                                                                  .ca.gov 858-495-5794
    Install Metal Beam Guard Rails and Various Locations Throughout the County                                                                                     Steve.Ron#scdcounty.c
2                                                                                                     N/A             N/A           N/A                            a.gov 858-694-2567
    Countywide Maintained Road Asphalt Concrete Overlay and Culvert Replacement Project
                                                                                                                                                                   Eric.Swanson@sdcount
3                                                                                                     N/A             N/A           20+                            y.ca.gov 858-874-4061
4
5
6




    Optional Information (in whole dollars):
       Project Type Categories (individual projects may fit into more than one category):
          Total Prop 1B Funding for Traffic Signals
          Total Prop 1B Funding for Major Pavement Maintenance and Rehabilitation
          Total Prop 1B Funding for Street Extensions, Lane Additions, and New Streets
          Total Prop 1B Funding for Landscaping/signage/safety/ADA/et. al.
          Total Prop 1B Funding for Bridge Repair, Replacement, and New Construction
          Total Prop 1B Funding for Transit related Projects
              Total (should equal total of Prop 1B LS&Rs funding from Project Budget data above)




               D:\Docstoc\Working\pdf\d8c619ac-1d4f-4af0-8af6-fcf713c09ace.xls
               4/12/2010, 10:00 PM D-Major Projects Initial List Tab                                                                                                                       page 7 of 7

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7
posted:4/13/2010
language:English
pages:7