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:-
Switch from Shapefile - http://switchfromshapefile.org
Shapefiles vs. Geodatabases - https://blogs.library.duke.edu/data/2...
Personal Vs File GDB's - https://nhd.usgs.gov/userGuide/Robohe...
A comparison of geodatabase types - https://desktop.arcgis.com/en/arcmap/...
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
Want to support me? BuyMeACoffee at: https://www.buymeacoffee.com/umaryusuf