Week 6: FAA Airman Database Part 2

Introduction

This blog post is basically a continuation of the Week 5: FAA Airman Database Part 1 post. The main difference that you will notice is that this post is going to focus more heavily on conducting spatial joins compared to the other post which was more heavily focused on creating attribute based queries. Another key difference is how we have to perform many more reproductions in this lab in order to get our desired result. The reasoning for this is because we want all our data layers and classes to be projected in the same coordinate system otherwise all of our data will be projected in different coordinate systems making lots of geospatial operations difficult or impossible to conduct.

Methods

This lab used the same FAA Airman database that we used last week. We also used the same computer software per usual which is ARC-GIS Pro. Mostly all of the operations that we conducted involved the use of a spatial clip. A spatial clip is like a cookie cutter if you will where you cut out the piece of the map you want. This type of spatial operation helps allow you to focus in on specific areas so that you can get rid of a lot of the potential noise that surrounds the area you are actually interested in.

Key Operations performed:

• Within

• Contain

• Hot spot Analysis

• Fishnet

• Location Based Query

• Clip

Discussion and Deliverables

Figure 1:

This is the Cont_us_state_lambert projection and it differs from the original projection because as you can see we now do not have Hawaii or Puerto Rico being projected onto the map.

Figure 2: This is an example of a query by location. As you can see the state of Indiana is the only state being highlighted.

Figure 3: We can see identified hotspots in the state of Indiana for certain FAA airmen certifications.

Figure 4: Kernel Density Map of Indiana Airmen