 So the idea here is that we are going to collect data from different online sources and get it into a QGIS So with this button, I can go to the next page and The first step is to download Data from the Africa groundwater atlas country hydrogeology hydrogeology maps and that's on this website So here we have the site and the first step is to download the data for Malawi That we will use in this tutorial. So I click here on on Malawi and then it will ask to fill in a form and When you have filled that in and submitted it will immediately give you a link to download and send it also to you by by email So that's that's what you can do. I already did that. So I'm going to proceed with The next Step. Okay, so we are going to we have downloaded this data. It's a zip file on your hard disk and we extract it and Then we are going to Start QGIS so here I have a brand new installation of QGIS for this session and I have downloaded the files from Malawi they're here. They're these ones and It comes with some meta data, which is important. So always check what comes with it So you have some more information about the data like in this PDF file we can see What the attributes are? So there's attributes about geology and about hydrogeology in the file. So we Need that for our interpretation, but also to assign the right styling. So we're in QGIS here I use here QGIS 3.10 long-term release and It's a fresh blank project and the first thing I always do if you work on a small laptop You just drag your layers panel over the browser panel. So you have the two tabs here. You can easily switch and now I go to the I'm in the browser panel and I'm going to look for the files that we downloaded So for me, they're on the Z drive and I've put them in tutorial one And I'm going to access that folder a lot. So I click right and I add it as a favorite So now I don't need to go down on this whole tree But I simply find the tools here under tutorial one and I can now simply drag The shapefile we recognize that this is a shapefile. Let's see the other files PDF.txt doesn't look like That's GIS layer. This this other one risk comes later in the tutorial. I pre-downloaded it to avoid some risks So simply the first thing that you do is drag this To the map canvas and there it opens and I switch back to the layers panel and Now I'm going to look at the attribute table of this layer. I click right and I go to open attribute table And there we see two columns one with the geology and One with the hydrogeology coded according to what is given in that PDF file with metadata good practice that they apply to to share this So that's nice. So we can now simply apply styling to this And let's make a styling for the geology and the hydrogeology separately Based on this one file and the attributes So I open the layer styling panel using this button You get this panel to the right You can always read which layer you are styling and in this case, it's not a single symbol, but it's categorized for different classes of geology and now I need to choose The column in the attribute table that I want to style and is this one the geology glg and If I click classify it will be classified with random colors and it always adds this last one all other values and That is for the no data. That's in the layer. I'm going to remove that you can often remove it if you don't have no data And it simply adds this legend And you can change the colors by simple double-clicking here on a color and changing the fill color to another One that you that you want for that. Yeah, I'm just keeping it as random colors But you can of course make this more to look like a real geological map according to conventions that you have in your country for geological mapping Now I also want to style the hydrogeology, but to distinguish I'm first going to duplicate the layer And I'm going to rename this one to Geology and I'm going to rename the other one to hydrogeology But it's still showing the geology, of course I'm going to style the second one in the same way So I now have here the hydrogeology make sure that's there categorized and I'm going to use the other attribute table column The fields related to the hydrogeology and I click classify. It will warn me that it will delete what's there already And now I have the classes from the hydrogeology added It's the same shape file, but we use the different fields in the attribute table to style Different properties. I remove here also all other values. So that was the first step And let me save the project. It's Good practice to save it frequently because if QGIS crashes and that can also happen to me, then you can still open the project file In this case, I don't save it to a geopackage But just as a normal QGIS file and I'll save it to the tutorial one Folder that I made so everything is together in one folder note that I don't use spaces and I saved it to my data partition and I'm going to call this simply Malawi a dot QG GZ file That stores the links to these layers and the styling and the zoom level let's go to the next step and There I'm going to add data from a spatial data infrastructure and it's a great thing that Malawi has the Malawi spatial data platform and I'm going to to show you So here it is and There I'm going to look for groundwater data. So this is an SDI a spatial data infrastructure which also runs on the geo note and Simply use this search box and look for ground water To find all the groundwater related data And then press enter and there we find this layer groundwater monitoring wells coordinates and Comes with some information here, but if I click on that then I can see Visualization of the data for load and I can see the metadata and I can check the attributes here. So it comes with these different attributes And if I want to download it, I can click here download as an image or as zipped shape file But here I'm going to do other things See it's still loading. There's an issue with the internet, but that's Not a big problem for us now. So I'm going to QGIS And I'm going to make a connection with this data set so there is this button here and This is to open the data source manager. Here's the data source manager and You will find this button geo note here and there I can make new connections to geo note SDIs I'm going to make a new connection. I click on you and I give the name must up and I'm going to give the URL here and that's the main URL of The geo note. It's this link. You could also copy it from the browser that's safer than than what I do now and Then you're gonna test the connection you don't Normally need to fill in the other things. I'm gonna test the connection They will take a bit it will try to connect to the server here We have a lot of overhead because also zoom is interfering, but it says That the connection was successful and it's a valid geo note instance. So that's good news So this seems to be working and then we click okay And now what we can do is connect To must up here. It will also take a bit and here it will load all the layers that are on this geo note Let me filter now by typing ground water There you see it and it gives you the title of the layer the name how it's stored in the in the database and Here you see web service WMS. Remember, that's a rendered picture and WFS that is the vector data that we can use for further processing and that's of course what we need so I Selected WFS and I click add and it will download these points into QGIS That takes a bit when the layer is loaded we close the dialogue and I can drag the Geo note layer to the top and there we see all the points We click right on the layer we can export these features now as a shapefile To make it available as a local GIS file. Let's call it ground water monitoring wells It was just changed the projection can also change the projection directly to the UTM zone Click okay, and there it is You know we can remove the geo note layer so basically what we did until now was downloading the Malawi hydrogeology map and adding the geo note layer on ground water monitoring wells from must up from the geo note and Converting this then to a local shapefile because you cannot keep it in WFS format for further processing the next step is we are going to use a CSV file from from the Ramsar information service So on this website we have all the Ramsar sites and We can find these Ramsar sites also for Malawi and therefore we use these Explore by filters. Let's first go to Africa and then we choose here Malawi and there it loads and we see that it has two Ramsar sites here And if you then go to exports And you can choose here different formats and what is useful for us in GIS is to save it as a CSV format And you fill in your email address and you will receive the link by email. I've already downloaded it so I'm going to use that link and To show you the file, so it's this file CSV file and If I click right, I can do edit and it will open in notepad And it is good practice to open it first in a text file because then you can already see what is in the Data and we see that it is comma separated If you see these double quotes, it means that these are text fields And what we can also see is that it has latitude and longitude coordinates so we can plot it on a map And it has a lot of other fields So let's open this in in QGIS therefore we use again The data source manager and now I go to delimited text And I use this button this button is important We use this always to browse in the file system also for saving always use that don't type the file name and Here there's this CSV file and I open it it gives me a preview and it already looks quite okay, but let's check what it did so CSV If you want to change the delimiters here, it chooses comma separate values You can go to custom delimiters and you can choose something else here We just use the comma and always check the preview because that gives you an indication on how good it is And here we see the latitude longitude coordinates, so that looks well So the only thing I need to do here is go to geometry definition It has some guessing so it automatically guesses that x is longitude field and y is the latitude field So it's already selected, but we need to add here the geometry and the geometry here can be selected with this button and Because it's latitude longitude and we don't have any other information We use EPS 3 4 3 2 6 and you can type it here in the filter field There it is and I click okay And that's all that we need now so I click add And I click close and we see that the two points have been added here and to our layers list So that is still an important CSV file And for further processing we need to export it to a real GIS layer So I'm going to export this also to a shape file to do that click write Choose export and choose save features as Default it will choose a geo package, but later we will wrap everything into one geo package So I first save it as a shape file use this button again to browse to the folder and It's on Z tutorial 1 and there I'm going to save it as Ramsar sites Malawi and The great thing about this export tool is that we can also change the projection to the one that we will use later in our project And it's not advised to keep it on Latitude longitude, so I'm going to change it to the UTM projection for Malawi And you can look that up, but I have the code here three two is always UTM WGS 84 Seven is for south and then you type the zone number and in this case it's 36 Selected here and you can look here at the preview and you see that it covers the whole country of Malawi So make sure it's selected then click okay, and that will be our output projection stored in the shape file And then leave everything else as default and then I do okay And now the Ramsar sites Malawi layer is added and I can remove The CSV file so good practice is also to keep this layers list clean To not get confused and use the wrong layers in your calculation So do okay now if I hover my mouse over it I see where it stored. It's a shape file and I see the projection in brackets. It's epsg three two seven three six So that's correct So always use that if you get confused what file you're looking at Okay, now we need to style it. So I click on the the layers panel if it was closed it's still open and it already selected here Ramsar sites Malawi and I just want a single symbol for for both of these and I'm going to change it to a SVG marker so click here on symbol marker and There you can change the type of markers and one of those here is SVG marker SVGs are Icons in drawings that you can make yourself or download from the internet and QGIS also comes with these and If you scroll down, then you will find here the different options and Under symbol we'll find here the one that we are going to use and that is this red marker But it's very small now. So we need to increase its size and we change it to 12 And now you see it here on the map These are nice marker symbols with a little shadow So that looks great So we already have some more data now in our project so let's add some more and Now we're going to the Sadaq GIP Portal Sadaq GIP and Let's see where it opened so here it is and Let's also look for groundwater data there. It's probably full of groundwater data, but Let's see what we have there and there's of course many of these layers The ones that we are going to use are The aquifers the transboundary aquifers when I start searching I already see it here in the pop-up and that's actually the one that we need. I'm going to click on that and similar to the other Mustap geo note we can click on the layer name Here they've used better practice because we see no underscores and file name in the title It's a nice human readable title and we can read the metadata nicely filled in look at the attributes There's the names of the aquifers the countries that it covers and You can download it but here of course, we're gonna make a connection. Hopefully in this case it will work so I'm just gonna copy The link from the side of gip and I'm going to make a new connection You could do it in this way as we did but there's another way so I'll show you both ways they're equivalent you can also go to the browser panel and If you go completely down you find here geo node and you see here or our must-up connection is already there But I can also add a new one if I click right I can choose new connection and I'm gonna give it a new name Sadaq Gip I paste the URL I'm going to test the connection. Let's see if this works a little bit better. It seems to be a little bit faster. It was successful okay and Now you can expand these boxes and it will query all the layers that we have on the Sadaq gip that will of course take a little bit So there are two ways to connect to the geo nodes either using this button or going to your browser panel and under geo node at the connection test the same Dialogues and we want the W of s so I expand W of s to get all the W of s layers And here it is the trans boundary aquifers of the world and I'm going to drag it to the map canvas and This time we see it works So these are all the aquifers of the world, but I'm still zoomed into to Malawi. So of course, we're gonna do something with that Let me see what the next step is Yeah, we need to export this also to a local layer. So this is if you cover your mouse over it You can see the projection is ppsg4326 and it is a geo node link a W of s So I'm gonna click write export save features s and I'm going to save it as a S with shapefile In our tutorial one folder and I'm going to save it as Let's see What name in the tutorial aquifer Aquifers shapefile Save and I'm going to change the projection also to the one of the other layer the UTM zone and then Add it to Fuller, okay, it's now converting the whole file. So all the polygons will be now put in the shapefile and there it is And I can remove the other one which is simply now a copy and I can style it. Let's give it a simple outline. So I go to simple fill Simple line and now I have those aquifers as black lines here So data set is getting more complete now. We have all the data. We need to save it into a geo package Including the project styling and the correct projection. So that's what we're going to do now So go to the processing toolbox, you can open it here from the menu processing toolbox. There we see it and There's a nice tool to package all these layers. You've seen it in the presentation Search for package and you find here the package layers tool Make sure that all the things that you want to export are checked there that might be necessary I'm not sure but I'll just check them and I double click on package layers And in the dialogue, I click for input layers on these this button with the three dots And here I'm gonna simply select all these layers. I click select also all the five layers are selected in brackets You see there are different projections. We're going to solve that later Now it will in a geo package. You can store layers with different projections. So it doesn't disturb this process of Storing all your data into one geo package. So I do okay. I Also want to save the styles that we assigned and then save to file geo package and Go to your tutorial folder So always make sure that it ends up in the right place And I'm going to call this one. Let's stick to how we call it in the tutorial Malawi Score GIS score data Note that I use underscores instead of spaces as the good practice for file and folder names save And then I run it And now all the five layers are in a geo package. I close it and The next step is that we are also going to save the project in the geo package Note that it doesn't add the geo package layers here automatically and that these layers here are still the shapefiles So we need to do something about it. So what we're going to do is I can save this project in the QGZ file just to be sure and I can click this button to open a new project So this is a new blank project and I'm going to add now the layers from the geo package that we made. So I go back to our favorites Here and this is our new geo package that we just created and there we see the five layers. I Select them all And I drag them to the map canvas And it zooms to the maximum boundary And in this projection it looks so weird because it also takes the first layer and use that projection So it's automatically changes change. You can find it here in the lower right to the UTM Projection. Now I want to zoom to the boundary of Malawi and I know that this geology and hydrogeology maps are the boundaries of Malawi so I click right and I choose zoom to layer and there we are back in Malawi and Let's drag groundwater monitoring wells on top and The Ramsar sites There it is. Let's put the aquifers below and here we have all our layers from the geo package And now we're going to save even the project in the geo package. So we have one file that we can share with our colleagues So you go to project and do save to geo package and Then we browse to the newly created geo package in the tutorial one folder in my case it's open and We give it an output name Malawi Groundwater project And then I do save you can save multiple projects into one geo package So these are now portable geo packages that you can share with others