Team members


  • Marisa Lemma (primary document author)
  • Michele Claibourn
  • Lee LeBoeuf
  • Jacob Goldstein-Greenwood
  • Chase Dawson
  • Tolu Odukoya
  • Helena Lindsay
  • Khalila Karefa-Kargbo
  • Michael Salgueiro

Data Collection Process

Throughout the summer and fall of 2021, we’ve been creating and refining a replicable data collection process to build a data collection resource for use in our collective work and by anyone in the community. The process is intended to make our work transparent, to provide resources for other to use, and to be highly automated for easier updates.

Beginning with needs and requests for additional information and data from within our coalition, and those articulated by additional community partners, we

  1. Begin researching available sources, seeking to undertand the provenance and genesis of the data (e.g., collected via surveys, captured from satellite imagery, derived from models built around station monitors, etc.), the temporality and spatial granularity (how frequently is it updated, what areas is it available for or could it be aggregated to), and the available variables and measures within the initial sources.
  2. Create code to acquire the data from source, working to remove as many manual steps as possible; to process the data, filtering to our region, checking data quality, deriving additional measures from included variables, aggregating to administrative boundaries for integration with demographic and population data. Output includes replication code and a csv file of the resulting data.
  3. Create code to build a documentation file identifying the source of the data, providing variable definitions, and generating initial visualization of the key metrics. Output includes replication code and a web document providing more details about the data source.

This winter and spring, we will continue to add to the current data collections, clean up and refine our work to date, and begin (4) to integrate the data sources for further analysis and visualization

Newly Available Data Collections

To build on the the population data we’ve collected as part of the broader Equity Atlas Prototype (e.g., demographic, economic, health, and other social data) and Shelter in Place measures (e.g., food, car, broadband access), the table below provides an overview of the data collections, including motivating questions, key measures, and data sources. The table can be filtered for key topics (climate measures, risk factors, community assets and infrastructure, transportation). In the next stage, we’ll begin to merge these measures with previously compiled data to visualize relationships between residents and resources.

Topic icon attribution



Data Examples

Percent Energy Burdened by Census Tract

Household energy burden is calculated as the percent of income spent on energy. A household energy burden of 6% or more is defined a energy burdened. Below we show the percent of households within a census tract estimated to be energy burdened based on the Low-Income Energy Affordability Data, 2018 Update.

Charlottesville

Albemarle County

Census tract 109.03 containing primarily student housing has been omitted

Fluvanna County

Greene County

Louisa County

Nelson County

Commute Patterns

The Origin-Destination Employment Statistics (LODES) pairs the census blocks for where employees live and work, allowing us to estimate outcomes like the average commuting distane of residents in the Charlottesville region and the most common places where non-Charlottesville region residents who work here are coming from.

Commuting Distances within the Charlottesville Region

The map below shows the average commuting distance for people who both live and work in the Charlottesville region by census block group.

Commuting Sources Outside the Charlottesville Regio

Below we show where individuals who work in the Charlottesville region but live outside of it reside. The figure below shows only the number of commuters from localities with more than 1000 Charlottesville region workers.

The highest number of non-region residents are coming from Augusta County.

Surface Temperature: Charlottesville

Using Landsat8 satellite imagery, we extracted the estimated surface temperature for each 100-meter pixel and the aggregated these estimates into census blocks, block groups, and tracts. Below we show the median measured surface temperature with each block on as measured on 08/24/2021 at 11:53am EST.

The Land Surface Temperature (LST) is the radiative skin temperature of ground, not the temperature as experienced by us or as measured by air temperature monitors.

Temperature over Time

Using NOAA’s Climate Divisional Dataset from the National Center For Environmental Information, we visualize changes in temperature in the Charlottesville region localities over time.

Average maximum monthly temperatures

This is the average of the maximum temperature recorded in January, in February, in March, and so on.

Maximum July temperatures