lu_SGCN table rebuild - Githubissues

PNHP / COA

Pennnsylvania Conservation Opportunity Area Tool development scripts

GNU General Public License v3.0

2 stars 1 forks source link

lu_SGCN table rebuild #21

Closed ChristopherTracey closed 7 years ago

ChristopherTracey commented 7 years ago

There's a number of issues with lu_SGCN table rebuild including the addition of the Environmental variable (#16) and the field length issue detailed in #10.

Additionally, it would be good to standardize the season code, add domains for some values, and other misc tasks.

ChristopherTracey commented 7 years ago

ELCODE, reduced field length from 1073741822 to 10
Common_Name changed to SCOMNAME to match biotics. Reduced field length from 1073741822 to 50
Scientific_Name changed to SNAME to match biotics. Reduced field length from 1073741822 to 50
Responsibility, reduced field length from 1073741822 to 1, changed 'Y' to 'y'. This could use a domain value.
Season changed to SeasonCode, reduced field length from 1073741822 to 1, added SeasonCode domain.
CAT1_glbl_reg, changed to short integer
CAT2_com_sp_com, changed to short integer
CAT3_cons_rare_native, changed to short integer
CAT4_datagaps, changed to short integer
GRANK, no changes
SRANK, no changes
USESA, no changes
SPROT no changes
PBSSTATUS no changes
SENSITIVE_EO, changed to SENSITIVE_SP
AGENCY, no changes
added Environment field, added domain, still need to populate values

ChristopherTracey commented 7 years ago

To add the attributes, I first summarized the environments(first/last) by SNAME in the three SGCN occurrence layers. I then merge the three summaries together. A great little bit of Python code was found at http://gis.stackexchange.com/questions/173103/using-field-calculator-to-compare-two-fields-in-att-table-and-returning-if-equal to compare the two env columns to see if they were equal. One Ophiogompus species and Gomphus septima were tagged both as terrestrial and aquatic--changed them to aquatic. Three bat species (Eptesicus fuscus, Myotis lucifugus, and Perimyotis subflavus) were rightly tagged as both. We'll have to handle this in the join manually.

ChristopherTracey commented 7 years ago

Did an inner join between lu_SGCN and the temp env layers. This provided data for 532 of the 685 SGCN that we have observations for. Fixed the bad joins by season for the three above bats.

ChristopherTracey commented 7 years ago

filled in the missing environments for the rest of the SGCN.

ChristopherTracey commented 7 years ago

renamed 'Taxonomic_Group' to 'TaxaGroup' to match the SGCN_pt/ln/py layers (these need to be updated as well).

ChristopherTracey commented 7 years ago

Everything is more or less complete for this. Still waiting on some other issues such as #12, but I'm not going to keep this open for those issues.

BG will be updating the server copy soon.