Skip to content

catalystcalifornia/sdpillars

Repository files navigation

San Diego RIPA Report

  • Link to online report

  • Table of Contents
    1. About The Project
    2. Acknowledgements
    3. Built With
    4. Getting Started
    5. Data Methodology
    6. Contact Us
    7. About Catalyst California
    8. Partners
    9. License

    About The Project

    This report combines data analysis of San Diego Police Department (“SDPD”) patrol activities, video interviews with community members in Southeast San Diego, and public policy research to show how SDPD criminalizes community members in Southeast San Diego through gang profiling. Gang profiling is a practice through which SDPD–and law enforcement agencies throughout California–document people of color as gang members and place their identities in gang databases. The report unpacks how gang profiling in Southeast San Diego inflicts devastating racially biased harms, undermines community safety, and wastes tremendous public dollars. This GitHub repository includes access to our methodology and scripts to analyze the data and test for racial bias in SDPD's gang profiling activity. The repository does not include access to the data tables used for analysis. We pull tables from our private PostgreSQL database. The database is accessible only by our Research & Data Analysis team. The original Racial and Identity Profiling Act (“RIPA”) data used for this project can be accessed via San Diego's Open Data portal. For access to the community stories gathered as a part of this project, please visit the report page.

    (back to top)

    Acknowledgements

    We would like to express our deepest appreciation to Pillars of the Community for their tremendous partnership in this project. Pillars of the Community is an organization that advocates and organizes for people harmed by the criminal legal system in Southeast San Diego. As a part of this project, they collected stories from Southeast San Diego community members who have been impacted by SDPD's practices. Thank you to the Southeast community members who courageously shared their stories and perspectives on how SDPD patrol activities undermine community safety.

    This project was completed with support from the Microsoft Justice Reform Initiative.

    The following individuals contributed to the data analysis and visualizations that show in up in the report:

    The following individuals contributed to the framing and writing of the report:

    (back to top)

    Built With

    R   RStudio   RStudio

    (back to top)

    Getting Started

    To get a local copy up and running follow these simple example steps.

    Prerequisites

    We completed the data cleaning, analysis, and visualization using the following software.

    We used several R packages to analyze data and perform different functions, including the following.

    • data.table
    • dplyr
    • extrafont
    • flextable
    • gt
    • gtExtras
    • highcharter
    • htmltools
    • htmlwidgets
    • knitr
    • leaflet
    • magrittr
    • RPostgreSQL
    • sf
    • showtext
    • stringr
    • sp
    • tidyr
    • tidyverse
    • usethis
    list.of.packages <- c("data.table", "dplyr", "extrafont", "flextable", "gt", "gtExtras", "highcharter", "htmltools", "htmlwidgets", "knitr", "leaflet", "magrittr", "RPostgreSQL", "sf", "showtext", "stringr", "sp", "tidyr", "tidyverse", "usethis")
    new.packages <- list.of.packages[!(list.of.packages %in% installed.packages()[,"Package"])]
    if(length(new.packages)) install.packages(new.packages)
    
    devtools::install_github("r-lib/usethis")
    
    library(data.table)
    library(dplyr)
    library(extrafont)
    library(flextable)
    library(gt)
    library(gtExtras)
    library(highcharter)
    library(htmltools)
    library(htmlwidgets)
    library(knitr)
    library(leaflet)
    library(magrittr)
    library(RPostgreSQL)
    library(sf)
    library(showtext)
    library(stringr)
    library(sp)
    library(tidyr)
    library(tidyverse)
    library(usethis)
    

    (back to top)

    Data Methodology

    This report evaluates SDPD gang profiling by analyzing 2022 data collected and reported by SDPD pursuant to the Racial and Identity Profiling Act (“RIPA”) of 2015. For each stop made by law enforcement, RIPA data includes information that can be analyzed for evidence of profiling—including characteristics about the person stopped (e.g., race, gender, and age), the stop location, the length of the stop, the reason for the stop, and the result of the stop. This report uses RIPA data to evaluate SDPD’s gang profiling activities. Key RIPA indicators include the officer assignment field (under “gang enforcement”), and the stop result field (under “field interview card”). You can access our full methodology here.

    Data Sources

    Police Stop Data

    Population Estimates by Age and Race

    Geographic Data

    Data Limitations

    As with all data, the findings seen in this analysis are dependent on the quality of the data collected. We strongly encourage readers and data analysts to consider the limitations of RIPA data when interpreting findings or using RIPA data. For instance, RIPA data are collected under state regulations for all law enforcement agencies, but this at times limits the applicability of data elements at the local level. For this project, this translated to officer assignment types collected under RIPA poorly correlating with SDPD units that conduct gang profiling. RIPA data are also based on officers’ reports. The information attached to each stop is solely based on officer disclosure and perceptions. For example, officers report what they perceive as the race(s) of the people they stopped, rather than having the people they stopped self-report their race(s). We encourage researchers using RIPA data to ground truth trends seen in the data with community to identify discrepancies between the data collected and everyday community experiences. For a full discussion of limitations, please see our Methodology document

    (back to top)

    Contact Us

    For policy-related inquiries:

    For inquiries about videos collected or advocacy in Southeast San Diego:

    For data-related inquiries:

    (back to top)

    About Catalyst California

    Our Vision

    A world where systems are designed for justice and support equitable access to resources and opportunities for all Californians to thrive.

    Our Mission

    Catalyst California advocates for racial justice by building power and transforming public systems. We partner with communities of color, conduct innovative research, develop policies for actionable change, and shift money and power back into our communities.

    Click here to view Catalyst California's Projects on GitHub

    (back to top)

    Partners

    Pillars of the Community

    (back to top)

    License

    Distributed under the MIT License. See LICENSE.txt for more information.

    (back to top)

    About

    Repo for San Diego Pillars (SD RIPA) project

    Resources

    License

    Stars

    Watchers

    Forks

    Releases

    No releases published

    Packages

    No packages published

    Contributors 4

    •  
    •  
    •  
    •