Airport visits not included in the Monthly Patterns data

I was looking at the Monthly Patterns - Free Historic Data for airport visits in Pittsburgh. When I query the data, I see the following three places:

The total number of visits to the airport seems missing in the data. Any help would be greatly appreciated!

Hi @mceldir, thank for writing in. I found this blog which might be helpful. Airports have a lot of parent/children polygon, and if they are fully enclosed they don’t include foot traffic. (I don’t know if this is the reason for your specific example, but it’s a guess!)

"Children that are enclosed (enclosed == True) are basically not distinguished from their parents. They do not have their own separate foot traffic data. Sometimes they have their own polygons, but sometimes they’re just a part of the parent polygon, although they may have their own latitude/longitude data.

Children that are not enclosed (enclosed == False) have parents but also act as independent locations. We track visitor data like visits_per_day separately for those locations, and they have their own polygon data in the polygon_wkt column."

Thank you @evan_barry_dewey! This is definitely helpful.

1 Like