Posts by
Helen McKenzie

How to get your colleagues & clients excited about geospatial
A guide to getting your colleagues & clients excited about geospatial technology and spatial analysis, with practical tips and advice
22 of the best maps, visualizations & analysis from 2022
A round-up of some of our favorite pieces of analysis, maps and visualizations using CARTO from 2022 in areas including retail, transport, climate & more!
How to calculate spatial hotspots and which tools do you need?
A comparison of the main spatial hotspot tools and which is best for your use case, including a guide on how to use and interpret these.
The Ultimate Guide to OpenStreetMap & BigQuery
A guide to the pros & cons of OpenStreetMap geospatial data, and how to access it via Google BigQuery











Migrating spatial analytics from PostgreSQL to Snowflake
A step-by-step guide to migrating PostgreSQL geospatial workflows to the Snowflake Data Cloud using CARTO.
What we learned: #SDSC22 New York
Miss the Spatial Data Science Conference in NYC? Here’s a quick recap as well as information about how to get involved in future events.











IoT Analytics & Geospatial Data: How It Works
We explore how IoT Analytics use cases are driven by geospatial data for catastrophe modeling, in smart cities & supply chain.
How to create and use Isolines with CARTO
Follow our guide for creating isolines & trade areas, the cloud-native spatial data science platform, as well as how to use these to derive actionable insights.
CARTO’s Ultimate Guide to Spatial Joins & Predicates with SQL
Get started with Spatial SQL with this guide to using spatial relationships.
How to create Google Street View pop-ups with CARTO
CARTO's guide to using Google Street View images in your map pop-ups!
Using Location Intelligence to combat The Great Resignation in Logistics
The Great Resignation means competition for staff is ever increasing. CARTO explores how spatial unemployment patterns can be used to tackle this.
Venue Suitability Analysis for the Eurovision Song Contest with CARTO
How to use Location Intelligence to pick the optimal venue for the UK's Eurovision Song contest with CARTO
Sistema.bio's Story: Optimizing field operations with CARTO
Understand how Sistema.bio is using CARTO to manage and plan their field operations to bring their sustainable biodigester to the world’s smallholders.
COVID, mapped: The analytics behind an epidemic
CARTO teams up with ZOE to analyze & predict the spatial patterns of COVID-19to develop a blueprint for understanding the spatial patterns of an epidemic.












Exploratory Data Analysis: UK retail centres
CARTO shares how you can use Exploratory Data Analysis to better understand your data and frame future analysis with CDRC’s latest dataset - UK Retail Centres
Super Charged Site Selection for Electric Vehicles
CARTO partners with CITD to understand how Location Intelligence can be used to drive stronger return on investment for Electric Vehicle charging stations.











Analyzing Sentiment & Footfall in Post-COVID Berlin
Follow along as Data Appeal uses CARTO’s Location Intelligence platform to evaluate tourism in Berlin post-COVID.
Cost of Living Crisis: Location Intelligence for Energy Efficiency
Improved availability & analytics of residential energy performance data will be a powerful tool to help during this crisis. Learn more & see it in action.
How Yale Climate Connections Uses Spatial Visualization for Community Engagement
See how Yale Climate Connections used CARTO to create a spatial visualization that shares local stories to help explain climate change.
Ghost Kitchens: Predictive Location Intelligence
“CARTO uses Location Intelligence to predict locations of one of the hottest trends in food delivery - ghost kitchens."
Hexagons for Location Intelligence: Why, When & How?
“CARTO explains how using hexagonal grids in your location-based analysis can lead to more efficient analysis and greater insight."
Understanding Retail Store Clusters with Local Outlier Factor Analysis
“See how Local Outlier Factor can be used as a tool for understanding the spatial patterns of retail store locations."











Dark Store Site Selection: How Geospatial Data Can Help
See how market leaders are doing dark store site selection using geospatial data & analytics with CARTO & Snowflake.
Analyzing NYC Caffeine Deprivation through Location Intelligence
“Curious about the number of coffee shops in NYC? Join us as we investigate the spatial patterns of coffee shops across the city."
International Women’s Day: Mapping Financial Inequality by Gender
“For International Women’s Day 2022, CARTO uses location intelligence to analyze financial inequality between gender in different countries. "