I currently work in a law enforcement data science team, with a focus on geospatial analysis. My interests lie in crime analysis, particularly understanding the spatial distribution and concentration of crime, and how these patterns relate to the physical and built environment. More broadly, I’m passionate about leveraging diverse data sources to better understand public safety challenges, inform problem-solving approaches, and evaluate the impact of interventions.

Please note that all content on this site — including blog posts, articles, and opinions — reflects my personal views and not those of any employer, organisation, or affiliation.

Recent Posts

• OSINT: From Raw Text to Strategic Intelligence Assessment with Databricks

  October 12, 2025

  OSINT: From Raw Text to Strategic Intelligence Assessment with Databricks Published 12 October 2025 In law enforcement intelligence, analysts are often required to produce intelligence assessments — drawing from human, technical, or signal sources to inform operational or strategic decisions. While many assessments are case- or criminal organisation-specific, this example...

• Automatically scaling tactical analysis, crime bulletin and Compstat style text summaries

  August 04, 2025

  Automatically scaling tactical analysis, crime bulletin and Compstat style text summaries Published 4 August 2025 This walkthrough details a reproducible pipeline for text summarisation of recent felony offences across New York City using Python, Pandas and SQL. Inspired by Andrew Wheeler’s Data Science for Crime Analysis with Python, an ideal...

• Using Open Data to Explore Boston Crime

  May 07, 2025

  Boston Crime Analysis Mini-Project In this mini-project, I used three tools: PostgreSQL with PostGIS for storing geometry (neighbourhoods, police districts, and census tracts) and data tables (crime incidents, shootings). Python to crawl, load, and incrementally update the crime and shooting datasets from Analyze Boston. Power BI to build a simple...

Recent Maps

• Violence and sexual offences at London transport stations

  January 31, 2024

  We often see misleading headlines about crime in the media — and one recent example inspired a map layer I created and shared here on Felt Several national and regional newspapers reported a “shocking” 75% rise in recorded crime on London’s transport network, particularly the Underground. But the reality is...

• Quick interactive crime maps with folium

  October 20, 2024

  In crime analysis, visualising data through maps is essential for understanding patterns and trends. Traditionally, static maps have been commplace across a range of products used to inform police tasking and resource allocation. However, when you’re servicing an entire city or a larger area, creating numerous static maps for inclusion...

• London Weapon Homicide and Gang Mapping

  April 19, 2025

  This interactive map explores patterns of weapon-enabled homicides and urban street gang locations across London between 2006 and 2024, using openly available data sources. Click here to view the map (Opens in a new tab) About the Layers The map includes seven layers that can be toggled on/off to explore...