DB- validate field "origin_stat"

[GoogleCodeExporter]

make final_origin_stat with native or non-native.
all native = native
all introduced, naturalized, non-native = non-native

Original issue reported on code.google.com by colin.kh...@gmail.com on 9 Aug 2012 at 4:01

[GoogleCodeExporter]

Original comment by htobon on 10 Aug 2012 at 2:25

• Changed state: Accepted

[GoogleCodeExporter]

Final values- null, native, non_native  (change accepted values to include 
non_native). make changes as per origin_stat_values_ck file

for values related to cult_stat, make changes as per 
data_from_origin_stat_changes_to_cult_stat_issues_ck file

Original comment by colin.kh...@gmail.com on 24 Aug 2012 at 1:02

[GoogleCodeExporter]

final_origin_stat   count(*) *
{null}  2930604
non_native  10243
native  29044

Original comment by alexgcv@gmail.com on 27 Aug 2012 at 4:48

• Changed state: Fixed

[GoogleCodeExporter]

Original comment by colin.kh...@gmail.com on 27 Aug 2012 at 4:54

• Changed state: Verified

[GoogleCodeExporter]

Original comment by colin.kh...@gmail.com on 5 Oct 2012 at 11:21

• Changed state: Accepted

[GoogleCodeExporter]

final_origin_stat from raw_occurrences:

+-------------------+----------+
| final_origin_stat | count(*) |
+-------------------+----------+
| NULL              |  4635962 |
| non_native        |    10671 |
| native            |    32329 |
+-------------------+----------+

final_origin_stat from GBIF_NON_PRIOR

+-------------------+----------+
| final_origin_stat | count(*) |
+-------------------+----------+
| NULL              |  1090000 |
+-------------------+----------+

origin_stat from GBIF_NON_PRIOR

 +-------------+----------+
| origin_stat | count(*) |
+-------------+----------+
| NULL        |  1090000 |
+-------------+----------+

Original comment by alexgcv@gmail.com on 26 Oct 2012 at 8:24

• Changed state: Fixed

[GoogleCodeExporter]

Original comment by colin.kh...@gmail.com on 27 Oct 2012 at 6:08

• Changed state: Verified