Managed-grown fresh cut Christmas trees · Data Quality Requirements

Data Quality Requirements

requirement_id	Applies to	Requirement	Evidence
dq_identity	reference and all actual exchanges	Prove managed origin and actual fresh species/height-grade state; verify each final concrete UUID and support before dataset use. An umbrella is not a verified exchange.	Source/cohort records; physical descriptions; confirmation evidence
dq_cohort	production history	Complete actual cultivation years, failed/replacement stocks and deferred harvests; estimated records require named method and uncertainty, not an invented standard lifetime.	Cohort/year/stock ledger with coverage gaps
dq_mass	dispatch and transfers	Exclude package/support tare and rejects; paired actual count/mass when count-based records exist; preserve freshness/moisture changes and material losses.	Calibrated scale and buyer acceptance records
dq_sites	contributing units	Enumerate every source block/site and handling yard; disclose represented output and omitted/uncovered shares. Keep incompatible species/grade/state populations separate.	Site-specific source quantities, weights and representativeness review
dq_graph	optional nodes and returns	Retain actual event path, bypass state, return links and stock cut-off; unknown handling state or destination blocks finalization.	Event-linked transfer/return receipts
dq_ranges	all screens	Replace provisional screens when empirical evidence exists; never use them as fallback amounts, limits, cut-offs or loss factors.	Foreground values and documented outlier investigation
dq_environment	actual natural exchanges	Specify substance and medium, original basis and model evidence; no invented nutrient-loss, biogenic credit, water or evaporation quantities.	Measurement/model protocol and complete carbon/water terms
dq_range_units_evidence	concrete exchanges in variable-unit cards	Establish any quantitative screen only after identifying its concrete exchange, reference property, explicit comparison unit and denominator, applicability, reviewed evidence and derivation. Preserve a unit conversion record that converts value and both bounds consistently; test the same physical quantity identically in equivalent units. Keep unresolved screens explicit and do not use them as amounts or completeness evidence.	linked collection protocols; property/unit and conversion records; compatible evidence and derivation; unresolved-screen register
dq_aggregate_transfers	internal ledger of harvest_to_dispatch	Retain quantities, lot, fresh state and time for harvest→condition or grade, condition→grade, grade→hold or dispatch, hold→dispatch and actual rework. Normal fresh trees retain Mass 93a60a56-a3c8-11da-a746-0800200b9a66, unit group 93a60a57-a4c8-11da-a746-0800200c9a66 and kg. The former 0–20 kg per 1 kg final reference is only a provisional non-enforcing reasoned_estimate investigation prompt, not an amount, yield or acceptance limit. A disaggregated unit-process model must restore full flow cards and verify compatible paired exchanges.	measured transfer/rework/stock records; compatible identity and validation of new disaggregated graph

9. Validation Rules

rule_id	Applies to	Rule	source_ids
valid_reference	tree_dispatch	Reference link identifies the sole actual accepted dispatch product output and 1 kg net fresh mass; all qualifiers and actual support identities are declared and package/reject mass excluded.
valid_cohort	grow; harvest	Check complete cohort/year/failed/replacement and remaining-stock accounting; upstream nursery/material/energy/asset gaps remain disclosed and prevent unsupported zero estimates.
valid_path	all processes	Check actual optional-node bypasses, transfer input/output links, returns and handovers; same fresh product may reuse a compatible verified identity, but living stock/seedlings cannot inherit the cut-tree UUID.
valid_outputs	all outputs	Enumerate accepted grades, downgraded goods, bough goods, off-spec return, field residues and waste with real destination and attribution. Exclude unresolved rejects from reference mass.
valid_attribution	every shared ledger	Reconcile sites, periods, output sets, assets and handling campaigns; check cleaning/changeover events and no repeated full-burden allocation or unsupported substitution credits.
valid_units	all rows	Check actual paired count/mass conversion, one net dispatch denominator, fresh moisture/state and native substance/energy/service units; do not equate per-tree records directly to per-kg values.
valid_bindings	all actual exchanges	Final dataset exchanges require independently verified specific UUIDs/property/unit; unresolved candidate identities and heterogeneous umbrellas cannot be silently accepted or supplied from a screen.
valid_bilingual	all cards	Preserve EN/ZH process/direction/type/row ids, actual meaning, amounts/bases, bindings and Range metadata; regenerate the projection after canonical edits and inspect performed/skipped check coverage.
validate_direct_release_coverage	grow; harvest; condition; grade; hold; dispatch	For every activated node, reconcile its activity list against cp_direct_release_grow; cp_direct_release_harvest; cp_direct_release_condition; cp_direct_release_grade; cp_direct_release_hold; cp_direct_release_dispatch: each relevant event must have quantified concrete elementary exchanges, evidenced upstream-service coverage, or evidenced absence of the activity. Missing/unknown is not zero and blocks data-package completeness. Check each actual substance/medium amount, method/factor units, concrete UUID and existing-card/service coverage for omissions or duplication; empty groups, purchased-electricity upstream emissions or another node's single CO2 card do not replace this node's on-site reconciliation. Shared-asset services must not create duplicate physical release events.

• Reconcile required/conditional activation and upstream coverage against incoming state at each node; purchased completed-state feed must not duplicate growth, harvest or preparation. Equal classification does not replace state and gate matching.

10. Published Dataset Profile

Field	Value
dataset_role	Foreground production dataset for managed-grown fresh cut whole trees
downstream_use	secondary_dataset; background_dataset only within the declared compatible producer-gate scope after concrete exchange resolution and review
allowed_use	Traceable species/height-grade/cohort/site mix and actual fresh grower-dispatch state; measured net-mass normalization with count descriptors retained
excluded_use	Wild trees, replanting/potted trees, artificial/decorated goods, bough-only products, retail/use/end-of-life, generic per-tree claims without measured equivalence, zero-upstream or automatic carbon-credit claims
required_metadata	All reference qualifiers; actual process path; cohort/year and site coverage; original quantities/units; current identity confirmations; allocation/asset/run ledger; tree/package/reject/stock boundaries
required_quality_disclosure	Data gaps and proxies, measurement/model uncertainty, represented species/grade/site/year shares, unexplained balances, method-specific carbon/water terms and replaced or unresolved provisional screens
update_trigger	New species/grade mix, cultivation/harvest/holding technology, dispatch gate, source cohort/site coverage, supplier identity, actual allocation relationship or substantive new evidence

11. Data Sources

Source id	Type	Reference	Used for
unsd-cpc3-christmas	official_guidance	https://unstats.un.org/UNSDWebsite/statcom/session_56/documents/BG-3o-Explanatory_Notes_of_the_Central_Product_Classification_Version3-E.pdf ; 03241	Classification scope; exclusion of trees for replanting, not inventory defaults
osu-christmas-culture	extension_guidance	https://extension.oregonstate.edu/catalog/pnw-684-developing-quality-christmas-trees-pacific-northwest ; PNW684	Managed multi-year cultivation context, species/height-grade distinction, possible bough goods and failed trees; no transferred numerical factors
osu-christmas-harvest	extension_guidance	https://extension.oregonstate.edu/sites/extd8/files/documents/pnw6.pdf ; PNW6	Actual cut/yard/primary preparation/protection/loading activity evidence; historical regional guidance is not a universal process, legal rule or default
fao-agricultural-energy	official_guidance	FAO Energy demand and consumption in African agriculture, Annex C case-study results, https://www.fao.org/4/v9766e/v9766e08.htm	conditional concrete identities and method context; does not establish site use or quantities
fao-package-identities	official_guidance	FAO Packaging for fruits, vegetables and root crops, section 4, https://www.fao.org/4/x5016e/X5016E04.htm	conditional concrete identities and method context; does not establish site use or quantities