This folder contains my notes from working with the C14_Strucke_merge_2026_02_02.csv document in SEAD Shape Shifter.
That file is not the final, complete version of the Strucke collection of radiocarbon data, but it is close enough to the final form to begin doing serious mapping work with it, in preparation for receipt of the final document. This folder will contains one page for each entity created in the mapping process in Shape Shifter, plus any explications or questions encountered in the process. As of 2026-03-10 these notes will be implemented in the SEAD Shape Shifter project riia-strucke-excelfil-test, which has a datasheet made from an excel version of the above named document, in which the column names were edited to remove non-English characters and capital letters. See below table for the edited column names.
| column name | edited column name | relevant entity | column and/or additional needed entities | comment |
|---|---|---|---|---|
| Socken | socken | Entity location | Entity site_location | This column +column Socken together are needed to describe the official RAÄ number, which is the older form of Sweden’s National Site Number Identifier. (set tbl_property_type = RAÄ nummer for this column) Roger will think about the best way to retain both the RAÄ number and the Lämnings number information in the dataset. This will likely entail using the new table site_properties to define two new site property types, one for each., one for each of these. On its own, this column is also one of the names for the location of the site |
| By_Gård | by_gard | Entity site | site_name | |
| RAÄ-nr | raanr | Entity site_property | This column +column Socken together are needed to describe the official RAÄ number, which is the older form of Sweden’s National Site Number Identifier. (set tbl_property_type = RAÄ nummer for this column) Roger will think about the best way to retain both the RAÄ number and the Lämnings number information in the dataset. This will likely entail using the new table site_properties to define two new site property types, one for each. | |
| Fornlämningstyp | Entity features | Entity feature_types | ||
| Lämningsnummer | This is the new form of Sweden’s National Site Number Identifier. Roger will think about the best way to retain both the RAÄ number and the Lämnings number information in the dataset. This will likely entail using the new table site_properties to define two new site property types, one for each of th | |||
| Uppdragsnummer | uppdragsnummer | tbl_site_properties | (set tbl_property_type = Uppdragsnummer for this column) | |
| LandId | landid | Entity location | Entity site_location | |
| Labnr | Entity geochronology | lab_number | ||
| 14Cålder | Entity geochronology | age | ||
| Stdav | Entity geochronology | error_older, error_younger | ||
| 13C | Entity geochronology | delta_13c | ||
| Modern | Entity geochronology | |||
| Kommentar | Entity geochronology | notes | ||
| Bedömd_relevant | Entity geochronology | This is a field that Sakarias promises to send a definition for with the final dataset | ||
| Sort | Entity record_type? | |||
| Art_1 | tbl_taxa_common_names | Entity record_type? | ||
| Art_2 | tbl_taxa_common_names | Entity record_type? | ||
| Anlnr | tbl_sample_alt_refs?? | feature_name?? | decide if this counts as the name of the feature, or an alternative reference for the sample | |
| Anläggning | Entity features | Entity feature_types | ||
| Författare | Entity biblio | authors and a part of full_reference | ||
| Tryckår | Entity biblio | year and a part of full_reference | ||
| Titel | Entity biblio | title and a part of full_reference | ||
| Tidskrift | Entity biblio | (only a part of full_reference) | ||
| Förlagsort | Entity biblio | (only a part of full_reference) | ||
| Lst-dnr | may not be part of the final data set | |||
| Källa_Excel | may not be part of the final data set |