Geo visualization of 114 oldest secondary schools in Nigeria

The list is given below;-

 Source: 114 Oldest Secondary Schools In Nigeria. Is Your School Among

Let geocode the schools to have there latitude and longitude coordinates. That is what we need for the Geo visualization. There are many ways to do the geocode, including using tools like Google maps API, OpenStreetMap API etc. The updated table should look like the one below;-

Now, you can import the table into any of the GIS software, here I will use QGIS. If you used automated process to obtain the coordinates, there will certainly be outliers in the result. In my case, I found about two outliers results one fell somewhere in republic of Niger while the other was in Central Africa Republic. So, I manually adjusted them accordingly to be in their right locations within Nigeria.

At this point the 'Geo visualization' has been successfully completed. And obviously we could see the concentration of the schools in the South Western part of the country.

The next thing to do is to add more context to the visualization and conduct analysis based on the objective you have in mind. For example, we could use the 'Age' column to create a proportional point symbol map.

We can also add labels from the attribute table, add state boundaries or state capital locations. Statistical plots could also be added as well as other cartographic elements to enrich the visualization.

That is it!