search

NCPN / invasives_rpts

invasive species reporting
0 stars 2 forks source link

Handle species that include multiple extra areas, transect & priority 1 #49

Open blcampbell-NCPN opened 8 years ago

blcampbell-NCPN commented 8 years ago

Target species lists originally were designed to have a species be on a single extra area, transect, or priority 1 -- not more than one. Apparently this is not always the case. A species must accommodate more than one extra area plus transect(s) in reports and lists.

blcampbell-NCPN commented 8 years ago

Target list table (tbl_Target_Species) accommodates all but multiple extra areas. These may be handled best by setting up a 1:: many table where the target species record can match against multiple extra areas. A similar table may be required if multiple transects must also be accommodated for a species. Underlying data for reports will also need to be adjusted as well as formatting so that a species can be identified as transect only, priority 1, and multiple extra areas -- perhaps by using multiple rows & hiding the species headers for duplicate data (i.e. group by species within the park and other groupings.

blcampbell-NCPN commented 8 years ago

Following questions need to be answered for a single target species in one park during the same year. Q: Is a single species targeted on multiple transects? (multiple transect-only designations) Q: Is a single species targeted on multiple extra areas? Q: Is a single species targeted on both transect(s) and extra area(s) simultaneously? Q: Is it acceptable for reports to contain multiple rows for a single species to handle these (i.e. grouping by species where the species has a row for transect only & multiple extra areas?