search

humlab-sead / sead_change_control

Sane SEAD change control using Sqitch.
1 stars 0 forks source link

Small update of dendro sample group descriptions #272

Open MattiasSealander opened 7 months ago

MattiasSealander commented 7 months ago

Currently there is data in sample group descriptions that needs to be standardized.

Bostadshus/domstolsbyggnad

Domstolsbyggnad/bostadshus

Need to ask Anton at Lund whether the order of types for individual entries is meaningful, or whether we can standardise them.

MattiasSealander commented 7 months ago

sample_group_description_id 62

johanvonboer commented 7 months ago

Ask Anton if they could normalize the list of terms. And then we will do an update.

MattiasSealander commented 5 months ago

Based on what Anton has described the description values that have a "/" sign indicate a building where use changed over time. There is no meaningful structure in how it is written, e.g. a "domstolsbyggnad" turning into a basic home. So we can standardize these for now.

MattiasSealander commented 5 months ago

In the appended document are two update SQL. The first targets all instances of sample group descriptions that are written as "Domstolsbyggnad/Bostadshus" and standardizes them to "Bostadshus/Domstolsbyggnad". The second one changes those descriptions that are written "Ekonomibyggnad/Bostadshus" to "Bostadshus/Ekonomibyggnad", so that we follow alphabetical order for all multipurpose building. Since the order does not matter.

As only dendro data has these types of descriptions we should not need to limit it to the dendro master dataset before updating.

UPDATE tbl_sample_group_description.txt