Filling Table Columns

bcgov / invasivesbc

Inventory and database repository for the creation, treatment, and report on BC Invasive plants and animals.

Apache License 2.0

13 stars 4 forks source link

Filling Table Columns #147

Closed ZoeSimon closed 3 years ago

ZoeSimon commented 4 years ago

Describe the Task Performing spatial overlays on all record entries of the activity_incoming_data table to populate meta data columns. Related to ticket #873.

[x] ownership
[x] biogeoclimatic_zones
[x] regional_districts
[x] flnro_districts
[x] moti_districts
[x] UTM Zone
[x] IPMA Internal dataset
[x] regional_invasive_species_organization_areas Internal dataset

popkinj commented 4 years ago

Just realized that many of these columns don't exist in the table. Working on a migration to add them all.