Bad data generated by the TREC script

[ChristopherTracey]

Bad data being generated by the TREC scripts. Caught after we made lu_sgcnXpu_all, but before the SWS. Deleted the bird data (mostly single point, and window collisions???), and fixed the ELCODEs.

This highlights the need to do more checking at each SGCN script

> print("The following ELSeason records are found in the lu_sgcnXpu table, but do not have matching records in the lu_sgcn table: ")
[1] "The following ELSeason records are found in the lu_sgcnXpu table, but do not have matching records in the lu_sgcn table: "
> print(sgcn_norecord)
"AMACC01100_y" - in biotics, probably due to a bad luclass code
"AMACC01010_y" - in biotics, probably due to a bad luclass code
"ABNKD06020_y" - bad value in TREC
"ABPBX03120_y" - bad value in TREC 
"ABPBX16010_y" - bad value in TREC
"AAAAE01040_y" - Mudpuppy, new ELCODE
"ABNTA07070_y" - bad value in TREC
"ABPBK01010_y" - bad value in TREC
"ABPBX01060_y" - bad value in TREC
"ABPBXA4020_y" - bad value in TREC
"ABNSB13040_y" - bad value in TREC
"ABNNF19020_y" - bad value in TREC
"ABPBA01010_y" - bad value in TREC
"ABPBJ18100_y" - bad value in TREC
"ABPBX05010_y" - bad value in TREC
"ABPAU01010_y" - bad value in TREC
"AMAFB09020_y" - Northern Flying Sq, new ELCODE
"ABNNM08070_y" - bad value in TREC
"ABPBY06030_y" - bad value in TREC
"ABPBG10020_y" - bad value in TREC
"ABPBX03050_y" - bad value in TREC
"ABPBX03230_y" - bad value in TREC
"ABNME05030_y" - bad value in TREC
"ABNCA03010_y" - bad value in TREC
"AMACC04010_y" - bad value in TREC
"ABNME08020_y" - bad value in TREC 
"ABNKC12020_y" - bad value in TREC
"ABNME13030"   - from USFS layer
"ABPBX03240_y" - in model layer?
"IILEP42011_y" - arctic skipper, new ELCODE

[ChristopherTracey]

[1] "The following ELSeason records are found in the lu_sgcnXpu table, but do not have matching records in the lu_sgcn table: "

print(sgcn_norecord) [1] "AMACC01100_y" "AMACC01010_y" "IILEP42011_y"