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!

Landsat Path Row for Nigeria

 The Landsat 8 or Landsat 9 satellite acquires or records images across the earth in 'scenes'. Each scene covers a square of about 185km by 185km (i.e. 115miles by 115miles). A scene is defined by Path and Row, the Path number is always given first, followed by the Row number.

This Path Row helps in defining the Landsat download scene in EarthExplorer. This Path Row can be accessed on the USGS web page in both shapefile or kml formats. The Path Row are described by the World Reference System (WRS) which is a global notation used in cataloging Landsat data. Landsat satellites 1, 2 and 3 followed WRS-1, and Landsat satellites 4,5,7, 8 and 9 follow WRS-2.

There are different Path Row numbers for Landsat satellite image acquired during the nighttime and daytime as seen below;-

Ascending (nighttime) Path Row

Descending (daytime) Path Row

Take note of the Path Row numbers for Nigeria (or your country) and anytime you have a project the requires you to make use of Landsat data, you can easily refer to the Path Row number map to get idea of the scene coverage on your study area.

Thank you for following.