Minor release: add column gbif_datasetkey to table view_full_occurrence_individual
4.2.6
2022-08-09
2022-10-19
Minor release: add index is_range_model_obs to table view_full_occurrence_individual
4.2.5
2021-12-07
2022-08-09
Minor release: refactor table species_by_political_division, making species+country+state+county a compound alternate candidate key
4.2.4
2021-11-19
2021-12-07
Minor release: add table dataowner to support multiple contributors per datasource or dataset
4.2.2
2021-10-06
2021-11-19
Minor release: Fix malformed morphospecies names in column scrubbed_species_binomial_with_morphospecies (plots only, vfoi and analytical stem)
4.2.1
2021-06-28
2021-10-06
Minor release: Populate missing values in NSR columns is_cultivated_taxon and is_cultivated_in_region
4.2
2021-05-06
2021-06-28
Update major validations & GBIF refresh
4.1.1
2018-12-06
2021-05-06
Minor update: set zero/negative plot areas to NULL
4.1
2018-10-31
2018-12-06
Major changes: (1) Complete refresh of source GBIF (doi: https://doi.org/10.15468/dl.yubndf); (2) New validation Political Division Geovalidation (PDG) added to pipeline as shell/PostgresSQL/PostGIS, previously in R; (3) New validation centroid, flags likely centroids; (4) updated validation flag is_geovalid to include missing coordinates and invalid coordinates (lat or long out of range). Minor changes: (1) New column is_geovalid_issue indicating reason is_geovalid=0; (2) New column continent added to major analytical tables.
4.0.3
2018-07-03
2018-10-31
Minor update to correct issue with FIA plot codes. Prepend state and county to make plot codes unique.
4.0.2
2018-05-25
2018-07-03
Populated missing political division info in table plot_metadata; added continent fields to table country
4.0.1
2018-05-14
2018-05-25
Removed unstandardized traits with <300 species
4.0
2018-05-08
2018-05-14
Major restructuring, new data sources
3.4.5
2017-05-18
2018-05-08
Updated tables observations_union & species to global coverage & added to all databases
3.4.4
2017-05-15
2017-05-18
First release fully synchronized private and public analytical databases
3.4.3
2017-03-03
2017-04-01
New version of traits table (from file: traits_2_25_2017.csv)
3.4.2
2017-02-10
2017-03-03
Updated table datasource with additional citation information
3.4.1
2017-01-04
2017-02-10
First full public-release version. Added table endangered_taxa. Applied all taxon embargoes for CITES, IUCN, US Federal and US State. Applied dataset embargoes for REMIB, Madidi and NVS.
3.4.0
2016-11-22
2017-01-04
Major change: removed Madidi data from public database
