Data for: Socio-economic and environmental life cycle assessment of complete streets

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

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

Selected Category

Selected Performance Measures

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.

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.

Complete Street

Zip code

Neighborhood ID number

0.5 or 2.0 mile distance

CalEnviroScore percentile (%)

Population

San Fernando St.

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

Franklin Blvd.

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

Kentucky Ave.

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

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.