Community Safety Data projects and timelines

view from the back of a woman holding a small child in her lap looking at a computer screen with a data dashboard displayed
The Community Safety Data (CSD) team's workplan consisting of the 17 projects the team is working on, descriptions of each project and current status. Updated Sept. 12, 2023.

Project names, timeline and descriptions

  1. Consolidated webpage of existing public facing dashboards — Completed June 2023
    This is a consolidated list hosted on of all existing dashboards, maps, or reports from City teams working on community safety.
  2. Information security training for data analysts — Completed May 2023
    Many analysts are committed to cybersecurity and protecting privacy but unfamiliar with specific City Rules or tools to help implement them. Training in a webinar format is provided by BTS’ Senior Information Security Officer. Resources are disseminated to City staff.
  3. Ability to pull down mailing addresses for mailers — Completed May 2023
    The CSD team currently relies on BDS for this service. Streamlining this mailing service helps alleviate work for BDS and improve project timing. Custom instructions and training sessions are provided to CSD staff so that they can do this step themselves. Guidance on how to access additional location-based data assets is also being explored.
  4. CSD Performance Metrics and Data Management — In progress
    CSD is working to reduce the impact of gun violence in Portland. This work involves determining appropriate performance measures to report on impacts of emergency declarations for the July 21st, 2022 Gun Violence Interventions and March 2nd, 2022 Street Services Coordination Center. Additional work includes reporting measure design for CSD programs, consistent data collection methods across teams, data management infrastructure, internal/interactive data sharing and external data sharing to tell the story across projects and how they address gun violence.
  5. Best Practices for Working with Gun Violence Data — Completed August 2023
    A training in collaboration with PPB Strategic Services Division to share methods and best practices for working with gun violence data. This also includes how staff can work with this team for analysis requests. As more teams work in collaborative projects to help reduce gun violence, they may work with PPB’s open data on analyses or require more specific data support to inform decisions.
  6. Shapeup Methods and Analysis Information Sharing — Future
    Documentation and/or communication material development to proactively share Shape-Up platform/model methods limitations, analysis decisions, and data usage. This helps prepare for public records requests and other City staff to effectively understand and use the results.
  7. Gun Violence Cluster Map Brought In-House — Future
    This analysis and map are currently managed by Dr. Jonathan Jay for CSD. This project explores with CSD and PPB potential methods to bring the analysis and map in house. Understanding intended and continued uses of the data will determine next steps.
  8. External Facing Community Safety Data Portal — In progress
    The Community Safety Data Portal is a website containing interactive dashboards and links to community safety datasets in the open data hub.  The first phase of the project is focused on fire, police, 911, and park safety workloads.
  9. External Facing Park Ranger Activity Dashboard — In progress
    This work prepares data and visualizations from internal park rangers’ activity/operations dashboard for public facing environment. This will improve understanding about what Portland Park Rangers do.
  10. Demographic Data Standards — In progress
    Research, analysis, and community engagement to support the adoption of citywide demographic standards. This project is in partnership with the City Data Governance Committee. Community safety teams will receive communication materials and implementation support once standards are adopted. This will increase interoperability of analyses, streamline data collection, and improve transparency about demographic data collection in communities.
  11. Performance Measures for Community Programs that are Variable — In progress
    Community grant programs are often responsive to community needs and different types of partners. Some have found it hard to create measures for qualitative, narrative data and/or consistent data to show impacts across programs. This work creates best practices for reporting measure design for this type of work. Reporting measures must be flexible and able to tell the story of the work, who is doing the work, and describe findings across projects. This work is in partnership with City Budget Office, Civic Life, and the Grants Management Division.
  12. Data Standards about Contractors or Community-Based Organization — Future
    To better understand the impacts and breadth of grant programs, minimum data standards should be used along with best practices on creating reporting measures. This work explores potential minimum data standards around contractors and CBOs.  This may include demographics and whether a partner is receiving funds from the City for the first time.
  13. Maturity of CSD Community Engagement Tracking Tools — Completed August 2023
    Data management support for CSD’s spreadsheet tracking of engagement feedback. This includes improved data formatting including tagging, method documentation, and data analysis support such as providing summary values, figures, and tables for various deliverables. This supports the use of valuable information provided by community members.
  14. Best Practices for Data Management and Analysis Tools — Future
    This work will identify data management and data analysis tools that are useful and best practices for analyst’s use. This may also include guidance on data and file management. Will improve staff efficiencies including onboarding processes for new staff. This work is in partnership with the City Data Governance Committee and the BTS Business Intelligence/Data Visualization project.
  15. Update and design pipeline for PBEM shelter dashboard — Future
    This dashboard was designed for one purpose but is now being used and relied upon by internal and external stakeholders for different reasons. This work may involve an updated design, support to organize and store backend data, and automated data cleaning. This could also involve identifying components that can live in internal versus external dashboards to meet the different needs of stakeholders.
  16. Update City’s GIS infrastructure / PortlandMaps to disseminate internally and externally — In progress
    This project involves the facilitation of more data and maps on the City’s central GIS infrastructure. This may also include guidance documentation of how to access various resources. This will reduce duplication of work and/or staff making similar requests across teams.
  17. City-contracted alternative shelters dashboard — In progress
     A public facing dashboard to report on program outcomes of the Temporary Alternative Shelter Sites (TASS). Future phases of this work will include visualizations and summary data for all types of City contracted alternative shelter sites.