Skip to content

Canonical Data Dictionary

The tables below describe the packaged valley dataset. Each regional database has its own logical content digest in dataset.logical_digest, also exposed as load_model_data(parameter_set=...).metadata["logical_digest"].

The database uses SQLite foreign-key enforcement. Scientific vectors and matrices are represented as one row per dimensional coordinate, not JSON or pickle values.

Metadata and provenance

Table Rows Purpose
dataset 1 Separate schema, dataset, and importer versions plus logical digest
source_workbook 1 Source filename, SHA-256, and role
source_reference 12 Worksheet/range families and applied transformations
legacy_alias 188 Import-only labels and integer indexes linked to canonical identities

Identities

Table Rows Primary relationship
element 15 Element ID, symbol, English name
nuclide 27 Nuclide to element, half-life in years
material 54 Shared identity for plants, feeds, foods, and animal products
plant 19 Material to category and soil type plus scalar plant parameters
animal 10 Animal identity and scalar husbandry parameters
organ 26 English organ identity
age_group 5 Explicit age in years
soil_type 3 Canonical categorical soil identity
plant_category 5 Canonical plant model category
environment 7 Explicit shielding/activity environment
deposition_target 20 Nineteen plants plus ground

Plant, deposition, and soil data

Table Rows Dimensions/value
scenario 1 Scenario-wide hay/weathering/activity scalars
plant_lai 6,935 plant x zero-based day -> LAI
plant_biomass 1,095 plant x zero-based day -> kg fresh/m2
plant_growth_half_life 228 plant x month -> years
deposition_velocity 300 element x target x chemical form -> m/s
water_film 247 element x target -> mm
soil_plant_transfer 234 element x plant -> factor
element_grass_parameter 13 element-specific fractions and half-life years
translocation_factor 33,969 element x plant x day offset -> factor
soil_mass 3 soil type -> kg/m2
soil_process 117 element x soil type x process -> half-life years
soil_enrichment 13 element -> enrichment factor

Animal and food data

Table Rows Dimensions/value
animal_feed_ration 110 animal x start day x feed -> kg/day
animal_product_transfer 143 element x product -> transfer factor
retention_component 209 element x product x component -> fraction and half-life years
processing_factor 702 element x feed/food ordinal -> final material, raw material, factor
storage_duration 54 domain x material -> days
seasonal_consumption_factor 3 material x period -> day bounds and factor
consumption_rate 165 material x age -> kg/day

Dose and exposure data

Table Rows Dimensions/value
dose_factor 14,040 nuclide x pathway x organ x age -> coefficient (excludes the former spurious Organ header rows)
skin_dose_factor 81 nuclide x radiation -> coefficient
skin_organ_factor 549 nuclide x organ -> Sv s-1 per Bq coefficient, excluding the footnoted skin row and I-129's blank effective dose
skin_organ_source_row 572 all 26 raw organ-table rows x 22 nuclides, including Haut *, original labels and blank cells
nuclide_environment_factor 378 nuclide x pathway x environment -> factor
ground_decay_component 54 nuclide x component -> fraction and half-life years
shielding_factor 14 pathway x environment -> factor
time_activity 7 environment -> activity and reduction fractions
human_inhalation_rate 5 age -> m3/h
resuspension_parameter 3 named coefficient with explicit unit
skin_contamination_parameter 6 named coefficient with explicit unit

Column definitions and constraints are executable in export_excel_data/sqlite_schema.py; this page records the generated dataset dimensions.