Helen McKenzie Profile Banner
Helen McKenzie Profile
Helen McKenzie

@helenmakesmaps

12,717
Followers
1,272
Following
945
Media
3,604
Statuses

Data & geospatial advocate, content creator & all around map geek @CARTO ๐ŸŒ๐ŸŒ๐Ÿ—บ Likes: cheese on beans on toast, sitting, otters. Views mine. she/her.

London
Joined January 2013
Don't wanna be here? Send us removal request.
Pinned Tweet
@helenmakesmaps
Helen McKenzie
2 years
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
28
133
815
@helenmakesmaps
Helen McKenzie
6 years
Catching the Liam Gallagher Finsbury Park gig from our flat โœŠ
103
1K
6K
@helenmakesmaps
Helen McKenzie
10 months
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 ๐Ÿ˜‚
Tweet media one
21
592
3K
@helenmakesmaps
Helen McKenzie
3 years
Please find attached
Tweet media one
29
303
3K
@helenmakesmaps
Helen McKenzie
3 years
Population along the Nile in Egypt๐Ÿ—บ๏ธ #30daymapchallenge #day11 #3D #blender
Tweet media one
6
143
1K
@helenmakesmaps
Helen McKenzie
4 years
Does working in #GIS make anyone else name_every_file_like_this? Like word documents, powerpoints... everything?
104
69
1K
@helenmakesmaps
Helen McKenzie
4 years
Toponymical maps of GB, looking at the density of common forms in place names, full suite here ๐Ÿ‘‰
Tweet media one
Tweet media two
Tweet media three
Tweet media four
25
186
937
@helenmakesmaps
Helen McKenzie
3 years
World population by 1ยฐ longitude bands ๐ŸŒ #30daymapchallenge #day12 #population #qgis
Tweet media one
9
90
603
@helenmakesmaps
Helen McKenzie
2 years
Mapping global hurricane tracks since 1842, data from @NOAA via @googlecloud public data, visualized in @CARTO
Tweet media one
10
106
579
@helenmakesmaps
Helen McKenzie
2 years
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! ๐Ÿ‘‡๐Ÿ‘‡๐Ÿ‘‡
4
90
563
@helenmakesmaps
Helen McKenzie
3 years
Airbnbs in London, looking at both the raw numbers and comparison with local population. #30daymapchallenge #day4 #hexagons
Tweet media one
9
70
564
@helenmakesmaps
Helen McKenzie
3 years
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
Tweet media one
11
93
541
@helenmakesmaps
Helen McKenzie
3 years
ctrl+f " " is life #dataanalytics #dataviz ๐ŸงŠ
Tweet media one
7
68
442
@helenmakesmaps
Helen McKenzie
2 years
Want to create joy plots like this? I got you ๐Ÿ‘‡๐Ÿ‘‡๐Ÿ‘‡
Tweet media one
7
28
396
@helenmakesmaps
Helen McKenzie
3 years
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
Tweet media one
Tweet media two
Tweet media three
16
57
377
@helenmakesmaps
Helen McKenzie
2 years
Guess what I mapped ๐Ÿ˜†๐Ÿคฆโ€โ™€๏ธ
Tweet media one
88
36
352
@helenmakesmaps
Helen McKenzie
3 years
Tweet media one
4
43
340
@helenmakesmaps
Helen McKenzie
4 months
15 QGIS layers later... ๐Ÿ˜๐Ÿค“
Tweet media one
9
18
346
@helenmakesmaps
Helen McKenzie
2 years
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! ๐Ÿ˜Š
46
36
341
@helenmakesmaps
Helen McKenzie
11 months
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 ๐Ÿ’ช
Tweet media one
1
31
341
@helenmakesmaps
Helen McKenzie
3 years
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
Tweet media one
8
54
331
@helenmakesmaps
Helen McKenzie
1 year
Pretending to be an international businesswoman... Spatial Data Science bootcamps Tokyo, here I come! โœˆ๏ธ
Tweet media one
13
11
321
@helenmakesmaps
Helen McKenzie
4 years
Mapping the closest countries to Antarctica - found this so interesting to make! ๐Ÿค“
Tweet media one
65
67
307
@helenmakesmaps
Helen McKenzie
3 years
Cat Bells โ›ฐ๏ธ #dataviz
Tweet media one
13
12
302
@helenmakesmaps
Helen McKenzie
4 years
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 ๐ŸŒ
Tweet media one
18
64
295
@helenmakesmaps
Helen McKenzie
11 months
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
Tweet media one
1
36
292
@helenmakesmaps
Helen McKenzie
11 months
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! ๐Ÿ˜Š
Tweet media one
4
28
289
@helenmakesmaps
Helen McKenzie
3 years
Density of pasty shops in England ๐Ÿ˜Š #30daymapchallenge #day5 #howisitonlyday5 #openstreetmap
Tweet media one
19
37
277
@helenmakesmaps
Helen McKenzie
3 years
#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 ๐Ÿ˜Š
Tweet media one
14
17
279
@helenmakesmaps
Helen McKenzie
1 year
@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:
Tweet media one
6
1
282
@helenmakesmaps
Helen McKenzie
4 years
Visible sky map of the City of London, created using @EnvAgencyGeomat LiDAR data #30DayMapChallenge #Day13 #Raster #QGIS
Tweet media one
4
32
277
@helenmakesmaps
Helen McKenzie
11 months
๐Ÿ™๏ธ Building heights of Manhattan [click to expand] Day 3 of the #30daymapchallenge : Polygons! Created in QGIS with NYC Open Data, full details here ๐Ÿ‘‰
Tweet media one
2
29
274
@helenmakesmaps
Helen McKenzie
11 months
#Day15 of the #30mapchallenge : The Geography of Central London toilets! The theme for today is #OpenStreetMap and I wanted to map something that is really hard to find in the data world, to highlight why OSM is so important to the #geospatial industry. #QGIS #CARTO #maps
Tweet media one
10
32
273
@helenmakesmaps
Helen McKenzie
3 years
What are the most common English supermarkets in different areas? #30daymapchallenge #day16 #qgis #urbanrural
Tweet media one
7
41
262
@helenmakesmaps
Helen McKenzie
2 years
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 ๐Ÿ‘‰ ๐Ÿš—๐Ÿš—๐Ÿš—
10
62
261
@helenmakesmaps
Helen McKenzie
4 years
20 years of basking shark sightings ๐Ÿฆˆ #30DayMapChallenge #Day1 #Points #QGIS Data from @NBNAtlas
6
46
264
@helenmakesmaps
Helen McKenzie
3 years
Post-graduation movements of students in England & Wales #30daymapchallenge #day2 #lines #qgis
Tweet media one
6
29
260
@helenmakesmaps
Helen McKenzie
3 years
Tweet media one
3
40
251
@helenmakesmaps
Helen McKenzie
3 years
Iceland's population in 3D #dataviz #geoshare #blender ๐Ÿ‡ฎ๐Ÿ‡ธ๐Ÿ—บ๏ธ
Tweet media one
3
36
257
@helenmakesmaps
Helen McKenzie
4 years
Tweet media one
10
29
250
@helenmakesmaps
Helen McKenzie
4 years
Something cheeky for day 3... Drive times to @NandosUK ! ๐Ÿ” #30DayMapChallenge #Day3 #Polygons #Illustrator
Tweet media one
10
30
246
@helenmakesmaps
Helen McKenzie
3 years
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
Tweet media one
Tweet media two
6
23
245
@helenmakesmaps
Helen McKenzie
1 year
#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
15
18
241
@helenmakesmaps
Helen McKenzie
2 years
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
Tweet media one
8
28
234
@helenmakesmaps
Helen McKenzie
11 months
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
Tweet media one
6
21
238
@helenmakesmaps
Helen McKenzie
2 months
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 ๐Ÿ—บ๏ธ
Tweet media one
18
36
236
@helenmakesmaps
Helen McKenzie
3 years
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:
Tweet media one
19
2
227
@helenmakesmaps
Helen McKenzie
3 years
Something a bit experimental for today: average monthly temperature by country, ordered by the latitude of the country's central point #30daymapchallenge #day27 #heatmap #rstats #ggplot #anythingisamapifyoubelievehardenough
Tweet media one
12
34
226
@helenmakesmaps
Helen McKenzie
1 year
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
Tweet media one
Tweet media two
Tweet media three
6
27
209
@helenmakesmaps
Helen McKenzie
1 year
๐Ÿ“ฃ 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
4
51
200
@helenmakesmaps
Helen McKenzie
2 years
When was #openstreetmap last updated in London? #30daymapchallenge #day8
Tweet media one
6
22
199
@helenmakesmaps
Helen McKenzie
2 years
I am NOT playing this year definitely not but what's the harm in one little map? Street trees of San Francisco ๐ŸŒด #30daymapchallenge #day1 #points #carto @CARTO But this is the LAST one definitely
Tweet media one
4
12
195
@helenmakesmaps
Helen McKenzie
11 months
#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
Tweet media one
10
15
199
@helenmakesmaps
Helen McKenzie
4 years
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 ๐Ÿš‡
Tweet media one
12
12
194
@helenmakesmaps
Helen McKenzie
2 years
I knew I could find the crossover #mappymeme
Tweet media one
7
17
193
@helenmakesmaps
Helen McKenzie
10 months
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
Tweet media one
2
29
191
@helenmakesmaps
Helen McKenzie
4 years
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
Tweet media one
15
29
193
@helenmakesmaps
Helen McKenzie
2 years
Per-km traffic accidents on London Streets 2018-21 - explore the interactive version here ๐Ÿ‘‰ #30daymapchallenge #day2 #lines #carto #andabitofcanva #thisisthelastone
Tweet media one
6
17
190
@helenmakesmaps
Helen McKenzie
9 months
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!
3
23
187
@helenmakesmaps
Helen McKenzie
2 years
Who's coming to my @bcsmaps workshop tomorrow? It's all about an intro to using SQL for mapping & spatial analysis, ft. these maps!
Tweet media one
Tweet media two
Tweet media three
Tweet media four
8
20
182
@helenmakesmaps
Helen McKenzie
7 years
Our city is so fortunate to have the most incredible, heroic and selfless emergency services and we couldn't be more grateful #londonbridge
1
47
175
@helenmakesmaps
Helen McKenzie
11 months
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
Tweet media one
7
24
182
@helenmakesmaps
Helen McKenzie
3 years
Boarders and alighters on the London Underground Network #30daymapchallenge #day1 #points #qgis Source: @TfL RODS data
4
28
176
@helenmakesmaps
Helen McKenzie
2 years
X. comes. first.
Tweet media one
13
22
169
@helenmakesmaps
Helen McKenzie
11 months
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
Tweet media one
3
28
167
@helenmakesmaps
Helen McKenzie
3 years
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ยฒ
Tweet media one
4
23
165
@helenmakesmaps
Helen McKenzie
9 months
Can we just change the word to "chloropleth" and be done with it now please?
12
13
165
@helenmakesmaps
Helen McKenzie
3 years
I've been drafting a blog about the pros and cons of mapping with hexagons. The draft is 15 pages. HOW HAVE I WRITTEN 15 PAGES ABOUT HEXAGONS!?
19
1
156
@helenmakesmaps
Helen McKenzie
11 months
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 ๐Ÿ˜ ๐Ÿป
Tweet media one
4
16
152
@helenmakesmaps
Helen McKenzie
2 years
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
Tweet media one
Tweet media two
Tweet media three
9
20
149
@helenmakesmaps
Helen McKenzie
2 months
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.
2
15
147
@helenmakesmaps
Helen McKenzie
6 months
โšก๏ธ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!]
3
15
142
@helenmakesmaps
Helen McKenzie
10 months
Day 26 of the #30daymapchallenge : Minimalism. Comparing the geography of Pret & Greggs. To prepare for this map I ate two sausage bean cheese melts this weekend. #justforfun #QGIS #GIS #maps
Tweet media one
4
11
145
@helenmakesmaps
Helen McKenzie
3 years
#Day28 of the #30daymapchallenge : theme #theearthisnotflat ft Google trends data on interest in the term "flat earth"
Tweet media one
5
14
141
@helenmakesmaps
Helen McKenzie
2 years
Hellvellyn โ›ฐ๏ธ
Tweet media one
3
5
133
@helenmakesmaps
Helen McKenzie
3 years
Elevation along Hadrian's Wall path๐Ÿž๏ธ #30daymapchallenge #day21 #elevation #blender
Tweet media one
1
11
132
@helenmakesmaps
Helen McKenzie
3 years
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
Tweet media one
3
13
132
@helenmakesmaps
Helen McKenzie
4 years
Today's theme in the #30daymapchallenge is Covid so... here's a map about banana bread! ๐ŸŒ๐Ÿž #day25 #covid #qgis #excel
Tweet media one
6
15
129
@helenmakesmaps
Helen McKenzie
4 years
Place name maps of GB, take 2! ๐Ÿ—บ๏ธ Thanks for your requests, there are some below and more on insta, notes on method in thread ๐Ÿ‘‡
Tweet media one
Tweet media two
Tweet media three
Tweet media four
7
32
128
@helenmakesmaps
Helen McKenzie
2 years
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!
1
22
127
@helenmakesmaps
Helen McKenzie
3 years
Paying my geographer's dues at the John Snow, Soho
Tweet media one
Tweet media two
Tweet media three
5
2
127
@helenmakesmaps
Helen McKenzie
3 years
Shapefiles are ok
@MorningBrew
Morning Brew โ˜•๏ธ
3 years
Start an argument in your industry in just 1 sentence.
391
38
412
10
3
126
@helenmakesmaps
Helen McKenzie
3 years
A very scientifically, topographically correct 3d visualisation of the world's best gorge #30daymapchallenge #day15 #mapwithoutacomputer
Tweet media one
5
9
128
@helenmakesmaps
Helen McKenzie
2 years
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.
Tweet media one
2
6
128
@helenmakesmaps
Helen McKenzie
3 years
Morning trips on London's Central line (the middle bit), data @TfL Rods 2017 #30daymapchallenge #Red #day6 #Rstats #definitelyamap
Tweet media one
5
8
125
@helenmakesmaps
Helen McKenzie
10 months
Public transport accessibility levels (PTAL) in London vs Population ๐Ÿš„ ๐ŸšŒ Created for day 29 of the #30daymapchallenge with the theme of "Population." #QGIS #GIS #transport
Tweet media one
5
16
126
@helenmakesmaps
Helen McKenzie
7 months
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
Tweet media one
1
17
127
@helenmakesmaps
Helen McKenzie
3 years
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?"
7
8
123
@helenmakesmaps
Helen McKenzie
3 years
Walking time to @Pret in Central London, based on @OSMLondon data #30daymapchalllenge #day3 #polygons #QGIS
Tweet media one
3
14
123
@helenmakesmaps
Helen McKenzie
2 years
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!!
31
20
123
@helenmakesmaps
Helen McKenzie
3 years
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:
7
19
122
@helenmakesmaps
Helen McKenzie
2 years
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
Tweet media one
4
21
122
@helenmakesmaps
Helen McKenzie
4 years
Which type of Joy plot are you more into - traditional (white lines) or filled (darker blue)? My eyes are tired and I can't decide!
Tweet media one
Tweet media two
24
4
122
@helenmakesmaps
Helen McKenzie
3 years
When is data not data? When it's a picture.
Tweet media one
6
19
118
@helenmakesmaps
Helen McKenzie
11 months
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
Tweet media one
4
17
121
@helenmakesmaps
Helen McKenzie
1 year
One of my favourite maps I ever made of the Mariana Trench in the Pacific Ocean ๐ŸŒŠ Learn how to make ridgeline plots like these here ๐Ÿ‘‰
Tweet media one
1
13
113
@helenmakesmaps
Helen McKenzie
3 years
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!? ๐Ÿค“
Tweet media one
5
11
110
@helenmakesmaps
Helen McKenzie
2 years
"Oh, I thought they weren't important so I just deleted them." #gischat #mappymeme
6
14
111
@helenmakesmaps
Helen McKenzie
10 months
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
Tweet media one
2
18
113
@helenmakesmaps
Helen McKenzie
4 years
Them: You have to put a North arrow and scale bar on every map, those are the rules Me:
4
13
107