FTA database - identify relevant data

[marcellmueller]

Before we do any data migration we need to take a close look at the RST portion of the FTA database and figure out what data is relevant to the new app and if there is any data we will need to have permissions on or stay private.

Acceptance Criteria:

• Go through the FTA schema and record which data must be moved to the new product
• Record any tables or columns that aren't relevant in the new database
• Record any tables or columns that link to data shared via the BC Geographic Warehouse
  • https://catalogue.data.gov.bc.ca/organization/recreation-sites-and-trails-bc
• Record any tables or columns that link to other tools within FTA (non-RST related but linkages we may need to maintain)
• Record any tables or columns that link to other tools (what are these tools?)
• Document findings: https://apps.nrs.gov.bc.ca/int/confluence/display/BCPRS/RST+Data

*Notes:
Meet with team Orca to go through schemaspy to identify known/not knowns