Tuesday, August 15, 2017

Reading JSON file into Pandas DataFrame

I wanted to read in a JSON object on a python pandas dataframe for further processing. So, I tried the default pandas read JSON method: read_json('file.json'), but I got just the JSON strings returned in the dataframes's row as seen below. That isn't what I was expecting....

Fortunately for me, pandas has a solution for this in its json_normalize class that “Normalize” semi-structured JSON data into a flat table.

So, I read the JSON file and applied the "json_normalize()" class and boom my semi-structured JSON data was converted into a flat table as seen above.

That was it!

Sunday, August 6, 2017

Convert Projected coordinates (Northings/Eastings) to Geographical (Latitude/Longitude) using Python

Generally, there are two types of coordinate systems used to represent Geospatial data namely:-
1) Geographical Coordinate Systems - Polar coordinates assumes the earth is spheroid/geoid/ellipsoid/curve (Latitude/Longitude). Example: World Geodetic System (WGS) 1984. Geographic coordinate systems are based on a spheroid and utilize angular units (degrees).

2) Projected Coordinate Systems - Rectangular coordinates assumes the earth is flat (Northings/Eastings).Example: Universal Transverse Mercator (UTM) Zone 33. Projected coordinate systems are based on a plane (the spheroid projected onto a 2D surface) and utilize linear units (feet and meters)

Thursday, August 3, 2017

Download Nigeria Geo dataset for States, LGA and Ward levels

Are you looking for a complete and comprehensive Geo dataset of Nigeria? Are you looking for complete map of Nigeria at States, LGA and Ward levels?

If yes, then you have come to the right website. Here you can download complete map of Nigeria at States, LGA and Ward levels in different file formats including image files, PDF, shapefile, CSV, GeJSON etc.

Check out the samples below and download. If you have special request, feel free to contact me and I will convert and provide it for you asap.

Download Maps

Thanks for following...
Website: www.UmarYusuf.com
Tel: +2348039508010

Tuesday, August 1, 2017

Web Mapping - case study of Ahmadu Bello University (ABU) Zaria Main Campus (Samaru, Sabo LGA Kaduna State)

Hello there,

In today's post, I will share how to produce a Campus Web Map using free and open source tools.

I will use ABU Zaria as an example. Let's get started....

You need the vector (shapefile) map of the campus. If you don't have one, you can easily obtain a copy from the ABU GIS unit or you can digitize your copy from available google earth satellite image.

You can use any GIS software for this... here I use a free software called QGIS.

There are several free and open source methods of deploying the shapefile map to the web. Some notable method am going to discuss in few moment include:-
1) Google Map Engine
2) QGIS2Web plugin
3) Open Street Map
4) Python Folium Library

Choose any of the methods above to create your web map (there are many guide and tutorials on the internet or contact me for help).

Happy mapping.