“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.

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.

Table 1. Social performance measures selected for use in the proposed complete streets LCA framework.

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.

Datasets

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. 

San Fernando St. Complete Street Case Study

• 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.

Social LCA Franklin Blvd. Complete Street Case Study

• 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.

Social LCA Kentucky Ave. Complete Street Case Study

• 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.

CalEnviroScreen Data

Table 2. Summary of percentile rankings for environmental and public health burdens and populations for neighborhoods near complete streets from CalEnviroScore.

Environmental LCA

“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.

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.