great so in the previous lecture I showed you how to convert a CSV file containing longitude and latitude values and other attributes as well and converting this CSV file into a shape file and this was a shape file that we came up with now in this case we were lucky because we had well defined coordinates as you see here longitude and latitude so we have coordinates represented as numbers so we had good semantics but it often happens that we don't have well defined longitude and latitude values as our location information but instead we have addresses this is what I mean so basically uh it's the same data set that I showed you in the previous lecture but instead of the longitude and latitude values we have address city state and Country Now to use this data set in GIS we first need to convert its location information into coordinates and this process of conversion is known as geoc coding there are quite a few Services out there on the internet and you also have uh geocoding apis which you can use in combination with other tools such as uh with a programming language and the good news is that qgis also has its own geocoding tool inside it so where is it well the tool is not included by default in the standard qgis this environment the tool indeed comes as a plugin and you have to first install that plugin but that's very easy you just go to the plugins manage and install plugins and then search for the name of the tool and the name of the tool is mm qgs so that's the tool we're looking at and to install it just go to install plugin and the process should be very quick that's it close and now you can see that the tool has been displayed in the main menu so just go ahead and go to Jo code so qgs uses the the Google and open street map apis to geoc code the addresses to coordinates click there and browse to the file which is here addresses and here now here you have to specify the address field the State field the the web service which you want to use as an API you want to specify City and the country so all the elements that make up the address of a location and qjs is smart enough to actually recognize this uh Fields automatically from the CSV file so they look fine to me and here is where you want to save the shape file I'll go to shapes and just leave the name like that so we are converting the CSV file to a shape file Direct directly in this case and there's yet another field here in the table which we want to specify and that's the not found output list so if there is a row or or more rows which will not be Jo coded for some reason those rows will be saved into a CSV file so that we have things under control and let's say we'll save this here and then click okay and the layer has has been added to the map now you can see here that we actually have two layers there is this layer here which we generated when we converted a CV file into a shape file and we also have this new layer now so this sort of stay on top of each other and if we want we can turn them off and on as you see and you can also drag one under the other just like this so it's a very efficient way of managing your uh spatial layers and that's what I wanted to talk about in this lecture see you later