This project is part of the Open Spatial Lab's 2023 Data Collaboratory. The Collaboratory is a 6-month program where OSL engages with social impact organizations to build a customized tool for data management, analysis, communication, and visualization. Circulate San Diego’s organizational engagement and feedback directly informs this work.
Based at the University of Chicago Data Science Institute, the Open Spatial Lab creates open source data tools and analytics to solve problems using geospatial data science. Read more about OSL at https://datascience.uchicago.edu/research/open-spatial-lab/.
About: Californians for Pesticide Reform (CPR) is a statewide coalition of more than 190 organizations that was founded in 1996 to fundamentally shift the way pesticides are used in California.
Project: OSL worked with CPR to develop a new data tool to track and visualize pesticide use across the state of California at multiple spatial scales, including neighborhoods, school districts and counties. This project leverages publicly available pesticide use data to deliver a tracking tool that remains sustainable and stable online, and transparent to update and maintain by CPR and its coalition partners.
- PUR data
data/pur/
is collected from 2001 to 2021 - Section data
data/sections
is a 2023 vintage of the PUR sections.sections.parquet
combining all county data data/geo/cb_2021_06_tract_500k.zip
contains 2021 census tracts for californiadata/geo/zip-county-crosswalk.xlsx
uses Q3 2023 HUD zip to county crosswalk (https://www.huduser.gov/apps/public/uspscrosswalk/home)data/geo/cb_2020_us_zcta520_500k (1).zip
contains 2020 ZCTA boundaries, which are the most recent see https://www.census.gov/geographies/mapping-files/time-series/geo/cartographic-boundary.2021.html#list-tab-1883739534data/geo/CA-townships-2023.geojson
is 2023 CA townships geometries from CA State Geoportal's Public Land Survey System (PLSS): Township and Range- Community & demographic data
data/community vars/
are from American Community Survey 2021 (5-Year Estimates), accessed via Social Explorer. Variables include: A04001 Hispanic of Latino by Race, A12002 Highest Educational Attainment for Population 25 Years and Over, A14006 Median Household Income, and A17004 Industry by Occupation for Employed Population 16 Years and Over.
scripts/download_pur.py
helps to download and parse PUR data from 2001 to 2021scripts/download_sections.py
helps to download GIS data