Filling activity_incoming_data fields through spatial overlays - Githubissues

bcgov / lucy-web

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

Apache License 2.0

3 stars 6 forks source link

Filling activity_incoming_data fields through spatial overlays #873

Closed popkinj closed 3 years ago

popkinj commented 3 years ago

Performing spatial overlays on all record entries of the activity_incoming_data table to populate meta data columns.

API End points

Proxy Query

[x] Elevation Separate proxy to Federal Government service API

DataBC Query

[x] biogeoclimatic_zones
[x] forest_cover_ownership
[x] regional_districts
[x] flnro_districts
[x] moti_districts
[x] ownership
[x] Well Proximity DataBC Query

Internal Query

[x] IPMA
[x] RISO
[x] UTM Zone
[x] UTM Northing
[x] UTM Easting
[x] Albers X
[x] Albers Y
[ ] Hex ID Lower priority
[ ] Hex sub ID Lower priority

Broken out into ticket 147 under InvasivesBC Repo Filling table columns

Elevation _Separate proxy to Federal Government service API
biogeoclimatic_zones
regional_invasive_species_organization_areas Internal dataset
forest_cover_ownership
regional_districts
flnro_districts
moti_districts
ownership
IPMA Internal dataset
Well proximity
Hex ID
Hex sub ID
UTM Zone
UTM Northing
UTM Easting
Albers X
Albers Y

popkinj commented 3 years ago

Going to do a PR before starting the DataBC attributes.