Project 3 - Creating and Working with Spatial Database - part 2 of 2

This is the final part on "Creating a Spatial Database" series. Here we will answer some questions by analyzing the filling station spatial database.

Websites mentioned in the video are listed below:-

Analysis to be conducted:-
1. Find filling stations within 5km from the FPN campus
gate? ~ Create a point feature a the gate, then buffer it by 5km
2. What is the average distance between filling stations? ~ Distance matrix
3. How far is the NNPC filling station from the market? ~ Use measure tool
4. How many filling stations are in Tammah? ~ Query by location
5. Find filling stations that make more than ₦200,000 in
daily sales? ~ Query by attribute
6. How may filling stations have more than 10 employees? ~ Query by attribute
7. Filling stations that were in operation before the
year 2000? ~ Query by attribute
8. Filling stations with land size more than 0.02Ha? ~ Query by attribute
9. Filling stations that sell Kerosene in Tammah? ~ Query by multiple attribute