Data & geospatial advocate, content creator & all around map geek
@CARTO
๐๐๐บ
Likes: cheese on beans on toast, sitting, otters.
Views mine. she/her.
I've been on a journey moving from point-and-click GIS tools to working almost entirely in SQL, and it is ๐ฏ but what isn't ๐ฏ is the available guidance for common geo workflows in SQL, so I've written my own!
"How to SQL: a Guide for GIS Users"
#GIS
#SQL
Population density map of Japan ๐ฏ๐ต
Created for day 24 of the
#30daymapchallenge
(final week!!), theme: black & white.
Created in CARTO (interactive version here: ) + labels added in QGIS because apparently that is my graphic design software of choice ๐
SQL is just for managing data, right? Wrong!
Check out my latest blog where I run through 5 tutorials for creating epic data visualizations & maps with SQL - like this dot density map! ๐๐๐
Ever wanted to create an interactive webmap from scratch but not sure where to start? I've written this blog post showing how to easily code and publish your first web map with R, no prior coding skills needed and all tools completely free:
#rstats
Keen to use blending modes in your mapping but don't know where to start? I've written a handy guide on how (easy), why (they look great) and when (often) to use blending modes in different software packages here:
#gischat
#GIS
Hi! I'm putting together a blog post for mapping in R for absolute beginners. What are some things that you struggled with when you started mapping in R? Or what is putting you off giving it a try? DMs open if you'd rather reply that way - thanks in advance! ๐
Day 2 of the
#30daymapchallenge
- Lines!
This map shows journeys to work in England & Wales where more than 10 people make that trip. Thanks to
@ONSgeography
for releasing the data just in time!
Designed in
#QGIS
with
#CARTO
&
#bigquery
doing the heavy lifting ๐ช
A handy guide to house-buying in London: how many flat whites you'll need to skip to save for a deposit across the city.
I'm not crying, you're crying.
#30daymapchallenge
#choropleth
#day26
#qgis
Motorways and A roads of GB, coloured by the starting number of their road number (I have ONLY just learnt that this is a thing! Such a terrible geographer...)
#geoshare
๐
Day 17 of the
#30daymapchallenge
: Flows. The most popular Citi Bike flows in NYC.
Citi Bike have AWESOME geospatial data which you can access here: . This map only shows flows >= 10 in the first month of May this year.
#qgis
#gis
#geospatial
Day 10 of the
#30daymapchallenge
- North America; Walking catchments of Starbucks across Manhattan!
The isolines were calculated in CARTO and then designed up on QGIS.
1/3 of the way there! ๐
#Day30
of the
#30daymapchallenge
can you believe it!?
The final theme is
#meta
so I've 'mapped' the solutions and tools I've used throughout the challenge by day and effort
#RStats
I'm tired ๐
@jayforeman
Here you go! I'm afraid I can't turn the basemap green but hopefully this is distinct enough? Let me know if you want LADs on there too. Here's the interactive if you need a different extent/zoom:
๐๏ธ Building heights of Manhattan [click to expand]
Day 3 of the
#30daymapchallenge
: Polygons!
Created in QGIS with NYC Open Data, full details here ๐
Exploring car ownership in London: more households don't own a car in pink areas, and more do in blue - explore the interactive version here ๐ ๐๐๐
How ANNOYING in QGIS are those hairline gaps between polygons when you have transparent/no stroke? If you pop into symbology > stroke > stroke colour expression and type "
@symbol_color
", the colour will auto-match your fill and the gaps will disappear!
#quickmaphacks
#QGIS
#GIS
job descriptions be like "Must be an expert in SQL, Python, R, Javascript, FME, every ESRI tool ever made, QGIS, a really niche remote sensing programme HR found on chatGPT, and... excel."
You just know which of those you'll be using the most
#gischat
The first dataviz I ever made in R was this joy plot! It's a great starter viz for mappers allergic to coding (like I used to be!) Check out my tutorial on how to create these here: ๐ป
#rstats
#dataviz
Number of pubs per 1,000 residents of London, created for the
#30daymapchallenge
๐ป
Day 13: Choropleth! Loving the opportunity this challenge gives us to undertake important data journalism.
Created in
#QGIS
with data from
@OSMLondon
&
@CARTO
FINE I'll make a map of the 376 UK places containing the word "Bottom."
My personal favourite? "Cringley Bottom"
If your "Bottom" isn't on this map, please consider contributing to
@openstreetmap
๐บ๏ธ
Excited to share that today I join the
@CARTO
crew as a geospatial advocate, here to get you all (more) excited about spatial analysis! Find out more about us here:
Today I'm starting a new
#QGIS
cartography project! I'm planning to create a big canvas of Tokyo for our living room, vaguely-inspired by one of my favourite video games: Persona 5! Will be sharing updates on here to keep me on track, with methodology included on the way ๐ค 1/2
๐ฃ New blog drop! A guide to free GIS data sources, ft. 100% biased and subjective movie-style reviews from me ๐
Currently global & UK sources included, with more to come!
#gischat
#30daymapchallenge
day 1: Points!
Down Under: A dot density map of Oceanians & Antarcticans living in London.
Analysis in
@CARTO
, visualization in
@qgis
, data from
@ONS
First adventure in ggraph - exploring flows along the second best TfL line - the Victoria Line (DLR is
#1
obviously...) - shout out to
@TfL
for the great
#opendata
๐
3D map of all 1.1 million NYC buildings at a 1:1 scale... and it's interactive! Explore here ๐
Day 3 of the
#30daymapchallenge
's theme is 3D. Created with CARTO & coffee ๐
#Geospatial
#dataviz
Are Londoners more likely to experience deprivation if they live on a borough boundary?
Genuinely thought this was going to generate some insightful results but the answer is... not really!
#30DayMapChallenge
#Day23
#Boundaries
#QGIS
One of my favourite quick
#QGIS
hacks - automating the colour of polygon strokes! [๐sound on]
You can also use this technique to set label colours... And pretty much anything!
Day 6 of the
#30daymapchallenge
: A neon map of Tokyo's metro [click to expand]
The great thing about this challenge is getting to create things that I can stick up on my empty walls!
#qgis
#openstreetmap
Day 16 of the
#30daymapchallenge
: Oceania... Shark incidents in Australia in the last 100 years ๐ฆ
Awesome data from the Australian Shark-Incident Database - so interesting how the historic data has been sourced! Full info here >
#QGIS
#GIS
#Geospatial
Penultimate day of the
#30daymapchallenge
! Who else needs a nap!?
#day29
#null
: Where is no one? The areas of the world with less than one person per kmยฒ
Distance to the closest pub along England's
@ThamesPathNT
๐ถ
Created for day 7 of the
#30daymapchallenge
for the theme "Navigation." I think this is the most important navigation exercise of all ๐ ๐ป
Youโve probably seen hexagon grids on maps & maybe even created some of your own... But have you ever stopped to think about why? Catch my blog on why hexagons are the bestagons, ft regular vs irregular grids, gerrymandering, H3 grids and more!
#geospatial
My favourite map I've worked on this week - an example of how you can build Parameters into maps for a really user-centric experience, this example focusing on sites impacted by hurricanes.
โก๏ธCreate a firefly map in QGIS in 50 seconds! All you need is:
๐ A dark base
๐บ๏ธ A point layer
๐ This video! [sound on - if you can bear my voiceover!]
This week on
#quickmaphacks
- ever want your QGIS symbol to be a different size on the map as it is in the legend? Don't faff around with creating different layers - just enter the text below into the size expression box, changing the text highlighted as needed - boom!
#QGIS
If you're looking to upskill in
#cartography
and
#dataviz
this year, read through guide to blending modes!
Ft. descriptions of the major blend types, how to use them in different software packages, and the best uses for the key modes!
Happy blending!
I'm a bit addicted to firefly maps ๐
I love how they so simply convey the density of data like a heatmap, while allowing you to understand individual data points like a standard point map. And they pretty.
My favourite maps from my recent trip to Japan: a thread!
A collection of some of my favourite maps from my recent trip to Japan!
1. 3d visualization of earthquakes showing depth, coloured by plate - showing how plates are sinking over time - in the National Museum of Science
Why are pub quiz geography round questions always like "Name the capital of X" and not "What does LiDAR stand for?" or "Explain MAUP in 200 words or more with real life examples?"
Hey
#gischat
I'm putting together a list of great geospatial and data events for 2023 - which events did you go to last year that you loved? Primarily looking for UK, USA, Canada & hybrid events. Thanks!!
I've been missing the
#30daymapchallenge
so wrote this round-up blog post about my favourite maps I've seen from each day across the challenge, featuring these talented legends ๐๐บ๏ธ (not Chandler and Joey, scroll down...)
Read it here:
Fell down an OSM rabbithole today... discovered the - particularly amazed at the quality of OSM building data in Kibera, SW Nairobi, and then discovered the amazing
@mapkibera
project!
And here they are mapped! ๐
#day3
#polygons
#30daymapchallenge
Day 8 of the
#30daymapchallenge
: Where can you find the Big 5 in Africa?
This is getting tough already! Discarded ideas include: Sales of Toto's "Africa" worldwide and a map of where the rains fall down in Africa. So dibs on those for next year!
I'm tired ๐
#QGIS
#CARTO
Did you know one of the oldest known maps in the world is this engraved Mammoth tusk? It's from est. 25,000 BC and depicts the area around Pavlov, Czechia - how cool is that!? ๐ค
Where is North? Mapping the geographic, magnetic & geomagnetic north, created for day 22 of the
#30daymapchallenge
with the theme "North is not always up."
Fascinating subject to explore! Really recommend the resources at