DOI: 10.25338/b85k99
title: Data for: Socio-economic and environmental life cycle assessment of complete streets

description: “Complete streets” is a design concept for primarily urban streets and
 intersections (existing and/or new) intended to encourage active
 transportation by bicyclists and pedestrians by making streets safer,
 convenient, and attractive for active transportation; motorized
 transportation and parking are also accommodated in the design concept.
 The social and economic performance indicators included in the social LCA
 (SLCA) framework that was used in this project provide a great deal of
 insight into specific and different potential benefits of a given complete
 streets project. The SLCA framework is based on five categories of
 concerns and 17 performance measures or indicators. The indicators were
 tested in the project and evaluated for final recommendations for use in
 future studies. The results are compared with the existing streets that
 were configured to be vehicle-centric. The case studies were solicited in
 more and less advantaged neighborhoods so that the equity aspects of the
 framework could also be evaluated. Use of the CalEnviroScreen tool from
 the California Environmental Protection Agency was also investigated to
 assess the exposure of neighborhoods and their vulnerability to
 environmental impacts in conjunction with the performance indicators when
 evaluating the potential benefits for disadvantaged neighborhoods. The
 document presents the data that was used for the SLCA, environmental LCA,
 and CalEnviroScreen Tool.
description: The three case studies that are evaluated include projects that
 are in an urban, a suburban, and a suburban/rural area. These projects
 are: San Fernando complete street project
 located in an advantaged neighborhood of San Jose, CA (urban)
 Franklin Boulevard complete street project located in a
 disadvantaged neighborhood of Sacramento, CA (suburban)
 Kentucky Avenue complete street project located in Woodland, CA
 (suburban/rural) The San Fernando Street
 and Kentucky Avenue complete street projects were already built at the
 time of evaluation, therefore this study includes calculations for social
 performance indicators before and after the projects' completion.
 Franklin Boulevard complete street project assessment, on the other hand,
 is based on proposed design documents as this street has not been built
 yet. The social performance measures that are selected
 to be used in this report are presented in Table 1. All performance
 measures description, methodologies, and data resources are explained in
 the final report for each case study.
 <strong>Table 1. Social performance measures selected for
 use in the proposed complete streets LCA
 framework.</strong> 
 <strong>Selected
 Category</strong> <strong>Selected Performance
 Measures</strong> 
 Accessibility
 Access to Community Destinations Access to school Jobs Access to Jobs Job Creation Mobility/Connectivity Active Transportation to Local and Regional Transit Connectivity Index* Connectivity Index Bike/Pedestrian Delay Level of Service (Auto) Safety/Public Health Level of Service (Bicycle Level of Service) Level of Service (Pedestrian level of Service) Level of Service (Bicycle Level of Stress) Crashes Physical Activity and Health Vehicle Miles Traveled (VMT) Impacts Pedestrian Miles Traveled (PMT) Bicycle Miles Traveled (BMT) Livability Green Land Consumption Street Trees   The main challenges in the SLCA study were data collection and the inherent context-specific and qualitative nature of social aspects of each complete street project. The evaluations of performance measures have been interpreted and discussed for each case study separately. All the performance measures were quantified for the three case studies using project-specific data. Assumptions, modeling approaches, and performance measures descriptions and methodologies are explained and available in the final report for each case study. The references to the data sources are also cited in the final report. Data that were used to quantify indicator results are presented in this data summary report. There is no restriction to publishing data, except for the schools’ surveys; however, the results of the survey are published in the final report. <strong>Datasets</strong> The following part of this document contains a data summary for each case study. Each case study, Social LCA for San Fernando St., Franklin Blvd., and Kentucky Ave., has its own directory containing excel files that are described in the following paragraphs. The summary of percentile rankings for environmental and public health burdens and populations for neighborhoods near complete streets from CalEnviroScore is presented in Table 2. The data for environmental LCA for all three case studies are also available as an excel file in this dataset.  <strong>San Fernando St. Complete Street Case Study</strong> The “San Fernando Street history of complete streets projects.xlsx” excel file compares the elements of the complete street considered in this case study. The access to destinations data for San Fernando Street is shown in the “San Fernando-List of destinations.xlsx” excel file. The “San Fernando-Access to jobs-Non-government Office Workers.xlsx” and “San Fernando-Access to jobs-State Workers.xlsx” excel files represent the access to jobs data for San Fernando Street for the non-governmental office workers and state workers, respectively. The Urban, Transit, Bicycle, and Pedestrian Level of Services (LOS) data for San Fernando Street are shown in “San Fernando-Urban LOS.xlsx” and “San Fernando-Transit LOS, BLOS, PLOS.xlsx” excel files. The “San Fernando- Crashes.csv” file, includes crashes data, and belongs to the complete list of San Jose streets and different modes of transportation between 2014 and 2019. <strong>Social LCA Franklin Blvd. Complete Street Case Study</strong> The access to destinations data for Franklin Blvd. is shown in the “Franklin-List of Destinations 2019 and 2015.xlsx” excel file. The “Franklin-Access to jobs-Non-government Office Workers.xlsx” and “Franklin-Access to jobs-State Workers.xlsx” excel files represent the access to jobs data for Franklin Blvd. for the non-governmental office workers and state workers, respectively. The Urban, Transit, Bicycle, and Pedestrian Level of Services (LOS) data for Franklin Blvd. are shown in “Franklin-Urban LOS.xlsx” and “Franklin-Transit LOS, BLOS, PLOS.xlsx” excel files. <strong>Social LCA Kentucky Ave. Complete Street Case Study</strong> The access to destinations data for Kentucky Ave. is shown in the “Kentucky-List of Destinations.xlsx” excel file. The “Kentucky-Access to jobs.xlsx” excel file represents all the access to jobs data for Kentucky Ave. The Urban, Transit, Bicycle, and Pedestrian Level of Services (LOS) data for Kentucky Ave. are shown in “Kentucky -Transit LOS, BLOS, PLOS.xlsx” excel file. <strong>CalEnviroScreen Data</strong> <strong>Table 2. Summary of percentile rankings for environmental and public health burdens and populations for neighborhoods near complete streets from CalEnviroScore.</strong> <strong>Complete Street</strong> <strong>Zip code</strong> <strong>Neighborhood ID number</strong> <strong>0.5 or 2.0 mile distance</strong> <strong>CalEnviroScore percentile (%)</strong> <strong>Population</strong> <strong>San Fernando St.</strong> 95110 6085500300 0.5 55-60 3140 95110 6085500800 0.5 60-65 2600 95112 6085501000 0.5 70-75 4769 95192 6085500901 0.5 55-60 3723 95112 6085501200 0.5 60-65 4186 95128 6085502102 2 55-60 7469 95126 6085502002 2 70-75 4887 95128 6085502001 2 50-55 5022 95126 6085500500 2 30-35 5275 95050 6085505203 2 55-60 4809 95110 6085505100 2 65-70 3027 95110 6085500300 2 55-60 3140 95126 6085500400 2 40-45 2369 95126 6085500600 2 35-40 4586 95126 6085501900 2 50-55 4641 95125 6085502302 2 10-15 2826 95125 6085502301 2 30-35 3245 95126 6085502201 2 25-30 6260 95125 6085503121 2 70-75 4499 95112 6085503122 2 85-90 3449 95112 6085503112 2 70-75 4025 95122 6085503105 2 90-95 2484 95122 6085503117 2 75-80 3120 95122 6085503110 2 80-85 4618 95116 6085501501 2 75-80 4278 95116 6085501402 2 60-65 2947 95116 6085501401 2 75-80 3295 95112 6085501200 2 60-65 4186 95131 6085504318 2 85-90 5265 95133 6085503601 2 85-90 2992 95133 6085504319 2 70-75 6936 95133 6085503709 2 65-70 5088 95116 6085503707 2 50-55 5462 95116 6085503602 2 80-85 4741 95116 6085503710 2 70-75 3599 95116 6085503711 2 60-65 4763 95122 6085503105 2 90-95 2488 95110 6085500300 2 55-60 3140 95112 6085501101 2 55-60 4074 95112 6085501000 2 70-75 4769 95110 6085500800 2 60-65 2600 95116 6085501502 2 70-75 4549 95110 6085503113 2 75-80 4760 95112 6085503112 2 70-75 4025 <strong>Franklin Blvd.</strong> 95822 6067003501 0.5 50-55 2629 95820 6067003600 0.5 65-70 2826 95818 6067002500 0.5 10-15 1587 95820 6067003700 0.5 75-80 4219 95822 6067003501 2 50-55 2629 95818 6067002400 2 30-35 4387 65818 6067002200 2 90-95 4004 95818 6067002300 2 35-40 3156 95818 6067002000 2 85-90 2376 95816 6067001500 2 30-35 4329 95817 6067001800 2 70-75 4686 95817 6067001700 2 55-60 4794 95822 6067003502 2 50-55 2916 95822 6067004100 2 65-70 5015 95823 6067004903 2 70-75 6740 95823 6067004701 2 85-90 3303 95823 6067004702 2 90-95 4945 95824 6067004601 2 75-80 7614 95824 6067003202 2 60-65 5052 95820 6067004401 2 75-80 4122 95820 6067002900 2 55-60 4499 95819 6067001600 2 20-25 5421 <strong>Kentucky Ave.</strong> 95776 6113011206 0.5 60-65 7329 95695 6113010901 0.5 40-45 5311 95776 6113010800 0.5 55-60 3881 95695 6113011001 2 35-40 6464 95776 6113011206 2 60-65 7329 95776 6113010800 2 55-60 3881 95695 6113011002 2 10-15 3093   <strong>Environmental LCA</strong> “ELCA of complete street case studies.xlsx” file contains several tabs with data that were used for LCA for the three case studies. The data in the excel file includes the surface treatments, complete street specifications, data for changes in VMT, as well as data for the materials and construction stages for San Fernando St., Franklin Blvd., and Kentucky Ave. case studies, and guidelines used for the calculations.
description: In order to view the data files, Microsoft Excel is needed. The
 files can also be opened using other spreadsheet softwares that are
 compatible with Microsoft Excel formats.