Bay Area Data Analytics

Department of City and Regional Planning at UC Berkeley

Community Profile of Census Tract 4403.08

Author: FengChi Juan, Ho Won Kim

Description

Union City is located in the south of Silicon Valley, covering an area of 19 square miles. In terms of the educational environment, it has two community colleges, seven primary schools, two junior high schools, and a high school. In terms of the economic environment, Union City has three large health care providers and a 100-acre shopping center, which has provided many local employment opportunities. In terms of population composition, the largest ethnic group in Union City is Asians, followed by Hispanics and whites, while blacks only account for 5 percent. More specific data is expanded below. The community profile is Tract 4403.8 and it is the main research area of the portfolio. It is located in the city center of Union City, covering an area of 0.71 square miles. The specific data will also be developed later. (In this portfolio, the words area/location is referred to as Tract 4403.8.)

Variables and Finding

This report is based on ACS (American Community Survey) and LEHD (Longitudinal Employer–Household Dynamics) data from 2010 and 2018. The data we are focusing on this portfolio is the population/household structure, racial/ethnic composition, income and poverty levels, and labor force characteristics. Our main goal is to explore the impact of income changes on different ethnic groups.

Covid-19’s Effects on Bike Sharing in San Francisco

Author: Azucena Castro, FengChi Juan, Ho Won Kim

Description

The Bay Area’s bike share pilot program was established in August 2013 as Bay Area Bike Share with only a few bikes and stations in operation. The program was later re-launched as Ford GoBike in 2017 and expanded to multiple cities in the Bay Area with over 2,600 bikes. Recently, in June 2019 the bike share program was rebranded to Bay Wheels. Bay Wheels currently operates in San Francisco, Oakland, Berkeley, and San Jose. As of June 2020, Bay Wheels had over 200 bike stations located throughout San Francisco. Due to the recent coronavirus pandemic, a shelter-in-place order went into effect in San Francisco on March 19th in order to allow social distancing and prevent the spread of the virus. The following report explores the change over time in bike sharing patterns for San Francisco from January 2018 through May 2020. We hope to find changes in bike share usage, travel patterns, and travel locations that occurred after and during the shelter-in-place dates.