2018-10-23 - Scenario 1 - TC Mash-Ups
- Diego Cesa de Meira (Unlicensed)
GIS and/or Non-GIS Data Inputs?
Regional airports plays an essential role in Canada’s air transportation. However, some airport struggle to raise enough revenue for operation.
Airport Capital Assistance Program (ACAP) has been funding improvement projects for regional airports since 1995. Only airports which are ACAP eligible are entitled for the funding. Several criteria must be met by the airports in order to be qualified including aerodrome status, passenger statistic and scheduled traffic.
ACAP Access Database is used to record and keep track of projects funded, in progress or new applications. It includes the following attributes:
Airport Name
Project
Estimated cost
Actual Cost
Project funded
Data Processing?
ACAP eligible airports overlay is extracted from the airport database based on the ACAP eligibility criteria. Other relevant information such as runways, operators, owners, type of service etc are inherited from the airport database.
ACAP Projects Listing is generated periodically from the ACAP Database and output to PDF which is linked to the ACAP overlay.
User Stories
User Story 1
As a funding officer, I need to know if the ACAP application is eligible so that I can proceed with the project review.
User Story 2
As a manager, I want to be able to review previously funded projects so that I can decide if it is a need, requirement or urgency.
User Story 3
As a user, I need to know all the ACAP eligible airports at a glance so that I can determine the distribution of funding, the most common projects funded and the cost.
Outputs
ACAP Eligibility Airport will be easily accessed by TC users and managers alike to determine past projects funded, so that smart decisions can be made efficiently in order to assists have not airports to provide a safe air transportation.