SWAMP Database Ingestion Issues - Githubissues

Smithsonian / CCN-Data-Library

The Coastal Carbon Network Data Library: An open-source database featuring carbon data from tidal wetlands around the world

https://serc.si.edu/coastalcarbon

4 stars 2 forks source link

SWAMP Database Ingestion Issues #101

Closed HolmquistJ closed 4 months ago

HolmquistJ commented 7 months ago

There are a few issues with the new SWAMP/CIFOR data ingestion catalogued below.

Coordinates seem off

[x] DEM_MF0_3_6_1
[x] BHI_BK1A_1_1
[x] SWAMP_Data_Soil_carbon_Timbulsloko_2019
[x] SWAMP_Data_Soil_carbon_Timika_2011_Indonesia

These are reading in as separate cores when they are separate depth increments of the same cores

[x] BRM10_1_1 and BRM10_1_2
[x] CAS_1_1 and CAS1_2
[x] SWAMP_Data_Soil_carbon_Jardin_Du_Elephant_2014
[x] SWAMP_Data_Soil_carbon_Lac_Simba_2014
[x] SWAMP_Data_Soil_carbon_Lac_Simba_Deux_2014
[x] SWAMP_Data_Soil_carbon_Lac_Sounga_2014
[x] SWAMP_Data_Soil_carbon_Lac_Sounga_Deux_2014
[x] SWAMP_Data_Soil_carbon_MRM8_2014
[x] SWAMP_Data_Soil_carbon_MRT7_2014
[x] SWAMP_Data_Soil_carbon_MRT9_2014
[x] Stopped tracking separation between cores and depth increments after this

Typo in max depth in the original source, max depth is way deeper than makes sense

[x] SWAMP_Data_Soil_carbon_Mounde_2014_Senegal - MOU Mounde 5 1

BD data looks suspicious in original sourse, may be C density

[ ] SWAMP_Data_Soil_carbon_Etna_Bay_West_Papua_2017_Indonesia
[ ] SWAMP_Data_Soil_carbon_Kaimana_City_West_Papua_2017_Indonesia

HolmquistJ commented 7 months ago

Separate depth increments reading in as separate cores is an issue that can probably be solved with a few lines of code.

group_by(study id, site id, core id)
mutate(n_depths = n())
mutate again to create a new core id. If n_depths is less than one, use str_remove to clip off the last underscore and number _1
Use the above table to recode the new core_id from old core id for the other tables.