No dsds?

[Natalie Cowan]

Hi,

I'm having trouble finding any data for "dsds" or the depth of soil sampled for any profiles. In the observations table it says there is no data for "dsds" or "bdwsad". Was the category removed or am I looking in the wrong place?
Thank you!

[niels....@gmail.com]

a) In the wosis_snapshot_2013, ‘dsds’ is no longer served as is a computed value.

Calculate with:

SELECT profile_id , max(lower_depth) FROM web_services_new.wosis_latest_layers

GROUP BY profile_id;

b) We are looking at 'BDWSAD', this should be remedied in the coming week. 

[niels....@gmail.com]

Note: for the snapshot_202312, the data necessary for the DSDS computation are stored in file wosis_202312_layers.tsv.

After importing the file into an SQL database, the above query can be adapted.

[niels....@gmail.com]

Answer re b):  There are no BDWSAD data in wosis_latest and snapshot, because the corresponding 'available'  data do not have a public license.