Map Academy
Map Academy
  • 272
  • 290 055
Filtering when text has an apostrophe in QGIS
Need to run a filter on your data to find a feature but the name contains an apostrophe and it's all going wrong? Can't figure out how to filter for a place like St John's or Land's End? Then watch this. The solution is simple - just use two apostrophes!
Переглядів: 156

Відео

A quick hack to move Alaska and Hawaii for US maps in QGIS
Переглядів 126Місяць тому
Sometimes when mapping the United States we put Alaska and Hawaii below the lower 48 states, just so we can fit them in one screen/page. It's a compromise but it's also something of a convention. This video shows you how you can do it quickly in QGIS using a geometry generator expression, shown below. CASE WHEN "code" = 'AK' THEN scale(rotate(translate( $geometry,1200000,-5000000),-28),0.5,0.5)...
Where to find your Print Layout in a saved project in QGIS
Переглядів 8554 місяці тому
If you create a Print Layout in your QGIS project and then save your project then the Print Layout is always saved as part of the project. But when you open your QGIS project at a later time the Print Layout will not normally open as well. That's just how it works, but don't worry - all you need to do to view the Print Layout again is go to the Project menu and then Layout and you'll see any Pr...
Draw effects: features vs entire layer in QGIS
Переглядів 7065 місяців тому
Draw effects in QGIS are amazing because you can style a layer in some really nice ways. But if you have a layer comprised of multiple features (e.g. polygons) it is easy to get it wrong so that's what I discuss in this video. Have a look anyway because it's very useful for things like drop shadows. See my intro and intermediate QGIS courses for more: www.udemy.com/user/alasdair-rae-2/
Map Great Britain's railway stations in QGIS
Переглядів 7465 місяців тому
In this video I show you how you can quickly and easily map all railway stations in Great Britain, using data from the Office of Rail and Road. This covers Great Britain rather than the UK so it does not include stations in Northern Ireland. I also show you a few other things that should be useful, like how you can style the layer, as well as export to any format you like - e.g. Shapefile, GeoP...
Add up data from small areas to big areas in QGIS
Переглядів 4295 місяців тому
Let's say you have a layer with lots of areas (like US counties) and for each area you have a number (in this case let's imagine it was vote count for different parties). How can you aggregate this up to the state level and create a state layer that adds up the numbers from each individual county and creates a total for each state? Well in QGIS you can do this using the Aggregate tool - take a ...
How to dissolve features in QGIS
Переглядів 4395 місяців тому
If you have lots of small features (e.g. counties) and they each belong to a larger group (e.g. states) then you can use the dissolve tool in QGIS to combine them into bigger shapes. This works for any kind of vector geometry, so it could be polygons - as in this video - or it could be points or lines. In this video I show you how to use the dissolve tool to create a states layer from a countie...
An extended look at label placement in QGIS
Переглядів 7955 місяців тому
Making good maps is 99% good label placement, am I right? Okay, I am exaggerating but labelling is super-important when making maps but depending upon the layout of what we're mapping it can be tricky or really tricky! So that's why I've put this longer video together, it's for anyone who wants to know a bit more about how to manually position labels in QGIS. I hope you find it useful. See my i...
Convert any geo file format with QGIS
Переглядів 4835 місяців тому
The world of GIS can be baffling and frustrating. It's true. And geo file formats are part of this. Love Shapefiles? Hate Shapefiles? Never used geojson but want it in shp instead? Sick and tired of all the open source nerds giving you GeoPackages? Or just looking for a tool to quickly convert from one file format to another? QGIS is really great when it comes to GIS file formats. It gobbles th...
Make label size the same in Print Layout in QGIS
Переглядів 1,5 тис.6 місяців тому
Sometimes when you make a map in the map canvas in QGIS you get everything looking just as you want it, and then in the Print Layout your labels are either too big or too small when you want to save your final map. This can be frustrating and there are many ways to deal with it but a quick fix is to use Map Units or Meters at Scale in the size options for labels. Take a look at this video to se...
Some tips for attribute tables in QGIS
Переглядів 5136 місяців тому
Want to reorganise your columns in an QGIS attribute table because you're tired of scrolling left or right? No problem. Want to change the width of a column? Let's to it. Or maybe your table just looks weird and not like a table at all (i.e. in Form View) and don't know how to undo it? Well take a look at this short table tips video for more. Data dataportal.orr.gov.uk/statistics/usage/estimate...
Fix that OGR error when saving to gpkg in QGIS
Переглядів 1,2 тис.6 місяців тому
Sometime when you try to export a new layer to the GeoPackage format in QGIS you'll get a very annoying and possibly alarming-looking error message with loads of lines saying the same thing. Usually it will start something like this: Export to vector file failed. Error: Feature write errors: Feature creation error (OGR error: failed to execute insert : UNIQUE constraint failed: etc etc....) The...
How to enlarge and/or move areas in QGIS
Переглядів 5796 місяців тому
Sometimes when you make a map it can be hard to read the data in small areas - like in the example of Greater London in this video. In such cases it's great to be able to enlarge and move your smaller areas to a place where people can see and read the data more clearly. You can do this really quickly in QGIS using the geometry generator symbology and an expression like the one below. Note that ...
When you join data but can't map it in QGIS
Переглядів 5636 місяців тому
Have you ever tried to join some numeric data to a shapefile (or other type of geo file) in QGIS and then tried to map it but it didn't work? Well, you're not alone. In fact, this kind of thing can happen to anyone in any GIS software so it's good to know some ways to get around it if it happens to you. In this video I show you what happens - and what I do - when I join data to a shapefile but ...
Explore, filter and check data in QGIS
Переглядів 1837 місяців тому
When you're working with any kind of data it's a good idea to get a sense of it before you dive in and do any meaningful analysis. Why? Because we want to be sure it makes sense, that we can spot any errors and, really, just give ourselves confidence that things look right. So in this video we explore the NBA data, continuing on from the previous videos in the playlist, and we filter it and do ...
Format date and export to SQLite in QGIS
Переглядів 2877 місяців тому
Format date and export to SQLite in QGIS
Load NBA shot data into QGIS
Переглядів 1817 місяців тому
Load NBA shot data into QGIS
Get NBA court data into QGIS
Переглядів 2417 місяців тому
Get NBA court data into QGIS
Delete holes in a vector layer in QGIS
Переглядів 5147 місяців тому
Delete holes in a vector layer in QGIS
How I make these videos: behind the scenes
Переглядів 2067 місяців тому
How I make these videos: behind the scenes
Replace text, concatenate, create columns in QGIS
Переглядів 1,1 тис.7 місяців тому
Replace text, concatenate, create columns in QGIS
Make a country locator map - all steps included - in QGIS
Переглядів 1 тис.7 місяців тому
Make a country locator map - all steps included - in QGIS
Get json data into QGIS
Переглядів 3 тис.7 місяців тому
Get json data into QGIS
How to replace any text in a table in QGIS
Переглядів 1,3 тис.7 місяців тому
How to replace any text in a table in QGIS
Fix those dark hillshades in QGIS
Переглядів 5687 місяців тому
Fix those dark hillshades in QGIS
Apply a tilt-shift (focus) effect in Aerialod (Win v0.0.2)
Переглядів 3448 місяців тому
Apply a tilt-shift (focus) effect in Aerialod (Win v0.0.2)
Population density and voting in Aerialod (Win v0.0.2)
Переглядів 6658 місяців тому
Population density and voting in Aerialod (Win v0.0.2)
Welcome to Map Academy!
Переглядів 1,3 тис.8 місяців тому
Welcome to Map Academy!
How to change settings values in Aerialod (Win v0.0.2)
Переглядів 3168 місяців тому
How to change settings values in Aerialod (Win v0.0.2)
A city scene in Aerialod (Win v0.0.2)
Переглядів 6758 місяців тому
A city scene in Aerialod (Win v0.0.2)