Følgende tabeller viser datakategoriene, presist kalt termer i plantedatabasenes verden, som vi så langt har lagt til grunn, med en kort forklaring.

NB! Dette er et utgangspunkt for en prosess som må ta litt tid å avgjøre. Det er umulig å forutse alle brukstilfeller og behov fra forskjellige brukere, men det er bedre å starte med en ganske grundig liste og tenke litt, enn å bare åpne med noe som “her kan du fylle ut dataene dine”.

Denne prosessen vil berøre de sentrale spørsmålene vi må stille, det være seg som en individuell samler/dyrker, små eller mellomstor virksomhet (SMB) eller en planteorganisasjon som f.eks KVANN (NGO).

• hva er våre mål?
• hvordan jobber vi?
• nøyaktig hva slags data trenger vi?
• hvordan bruker vi dem til å oppfylle våre mål?

Et viktig eksempel for KVANN: kvalitet på frø

KVANNs hovedmål er å bevare varianter innen dyrkede planter gjennom aktiv bruk. Da er det åpenbart nødvendig å sørge for at medlemmene ikke sprer frø av dårlig kvalitet, ellers kan KVANN faktisk bli et effektivt instrument for ødeleggelse snarere enn bevaring. Denne utfordringen krever:

1. Kvalitetsstandarder:
   • Isolasjon (avstand eller andre teknikker)
   • Riktig antall foreldreplanter
   • Variasjonsbeskrivelse (slik at du faktisk vet hvordan sorten ser ut, smaker, butikker osv.)
   • Helsekriterier
2. Utdanningsmetoder
3. Egenkontroll- og rapporteringssystem

Den beste og sannsynligvis eneste måten å håndtere dette på, er å ha disse dataene lett tilgjengelige i en database og utvikle brukergrensesnitt for pedagogiske formål (hovedsakelig selvstudier, men også kurs) og til slutt rapportering. Og vi har et godt grunnlag for dette i

• Arttabell, linje 15 – 19 (om blomstringstid, pollinering av frø modning osv.) Og 23 (plantesykdommer)
• Arttabell, linje 43 – 49 (dataene tilsvarer kvalitetsstandardene ovenfor)
• Varietabell, linje 3 – 33 (alle variasjonsspesifikke data tilgjengelig for sortbeskrivelser. Bør illustreres)

The following tables list the data categories, labels and types, with a short explanation.

NB! This is a starting point for a process that will have to take some time to settle. It is impossible to foresee all use cases and needs of different users, but it is better to start with a quite thorough list and do some thinking, than to just open with something like “here you can fill in your data”.

This process will touch the central questions we must ask, be it as an individual collector/ food security grower, small/medium bussiness (SMB) or non gov. plant organization (NGO).

• what are our goals?
• how do we work?
• exactly what kind of data do we need?
• how do we use them to help fulfill our goals?

One important excample for KVANN: seed quality

KVANNs main goal is to preserve, through active use, “heritage” varieties within cultivated plants. Well, then it is obviously necessary to make sure that members don’t spread among themselves seeds of poor quality, or KVANN could actually become an effective instrument for destruction rather than preservation. This challenge calls for:

1. Quality standards:
   • Isolation (distance or other techniques)
   • Correct number of parent plants
   • Variety description (so you actually know how the variety looks, tastes, stores etc)
   • Health criteria
2. Education methods
3. Controll and report system (by self)

The best and probably only way to handle this, is to have those data easily accessible in a database and develop users interfaces for educational purposes (mainly self study, but also courses) and finally reporting. And we have a good foundation for this in

• Species table, lines 15 – 19 (about flowering time, pollination seed ripening etc) and 23 (plant diseases)
• Species table, lines 43 – 49 (the data corresponding to the quality standards above)
• Variety table, lines 3 – 33 (all the variety specific data available for variety descriptions. Should be illustrated)

/////

Family table

0	Data category	Field label	data type	comment
1	Taxonomy	Kingdom	(hard coded)	default value, since all items is plantae
2	Taxonomy	Clade	text	the list here uses as many clades it needs...
3	Taxonomy	Clade	text	...
4	Taxonomy	Clade	text	...
5	Taxonomy	Clade	text	...
6	Taxonomy	Clade	text	...depending upon how the family is described.
7	Taxonomy	Order	text	derived from accepted taxonomy
8	Taxonomy	Family	text	derived from accepted taxonomy
9	Names	English family name	text	derived from common use
10	Names	Norwegian family name	text	derived from common use
11	Basic characteristics	Number of genera	number	best guess according to various estimates
12	Basic characteristics	Number of species	number	best guess according to various estimates
13	Basic characteristics	Description	text	so far: free text. must develop guidelines
14	Basic characteristics	Common traits	text	so far: free text. must develop guidelines
15	More info		links	to external websites / databases
16	db-status		date	when the item was last updated

Species table

0	Data category	Field label	data type	comment
1	Names	Species	text	botanical name, simplified as much as possible
2	Names	Species correct	text	botanical name, correct scientific (not implemented yet)
3	Names	English name	text	derived from common use
4	Names	English names (alt)	text	derived from common use
5	Names	Norwegian name	text	derived from common use
6	Names	Norwegian names (alt)	text	derived from common use
7	Basic characteristics	Annuity	a / b / p	annual / biennal / perennial
8	Basic characteristics	Decid./evergreen	d / e	decidous / evergreen
9	Basic characteristics	Height	cm	average height of mature plant
10	Basic characteristics	Width	cm	average width of mature plant
11	Basic characteristics	Growth rate	?	soacing / moist / humid (better ideas ?)
12	Basic characteristics	Hardyness	number (1-9)	according to hardiness zone map
13	Basic characteristics	Frost tender	yes / no	if the plant can take some frost at all
14	Basic characteristics	Nitrogen fixer	yes / no	fixes nitrogen from the air (usually with bacteria)
15	Basic characteristics	Flowering time	month	flowering month
16	Basic characteristics	Flower type	text	botanical description (can be structured data ?)
17	Basic characteristics	Self fertile	yes / no	if it is certain
18	Basic characteristics	Pollination	text / dode	insect / wind / other (can be structured data)
19	Basic characteristics	Seed ripens	month	ripening month
20	Basic characteristics	Other properties	text	additional specific info
21	Predators	Larger animals	yes / no	just if it is a problem (could be a text field for nuances )
22	Predators	Insects	text	insect type / species
23	Diseases	Common diseases	text	common names of diseases
24	Cultivation	Seed preparation	codes	cold or warm stratification / scarification / other
25	Cultivation	Sow date indoors	date	date (should be adjusted with geogr and climate data)
26	Cultivation	Sow depth	mm	appr.
27	Cultivation	Germination temperature	degrees c	appr.
28	Cultivation	Moisture	text	soacing / moist / humid (better ideas ?)
29	Cultivation	Precultivation details	text	other specific info
30	Cultivation	Sow date outdoors	date	(should be adjusted with geogr and climate data)
31	Cultivation	Soil type	date	clay / loam / peat / rich organic (better ?)
32	Cultivation	Planting date	month / date	(should be adjusted with geogr and climate data)
33	Cultivation	Row distance	cm	appr.
34	Cultivation	Plant distance	cm	appr.
35	Cultivation	Fertilization	text	( needs and preferred form... not defined )
36	Cultivation	Cultivation method	text	( bed type, tools, when to ... not defined )
37	Cultivation	Maturation sign	text	describing visible / tactile clues
38	Cultivation	Growth termination	month / date	when growth should be stopped for best results
39	Cultivation	Harvest date	date	(should be adjusted with geogr and climate data)
40	Cultivation	Post processing	text	various techniques
41	Use	Crop type	text	define plant part(s) used, main categories
42	Use	Main uses	text	huge topic... should probably be split up more
43	Seed production	Isolation	meters	have data for main crops, must be developed
44	Seed production	Parent plants	amount	have data for main crops, must be developed
45	Seed production	Variety criteria	linked page	must be developed / collected and standardized
46	Seed production	Techniques	text	use of cages, insects, manual manipulation etc
47	Seed production	Screen size	mm	sifting screens
48	Seed production	Seed storage	text	various techniques
49	Seed production	Other details	text	specific details
50	Vegetative propagation	Season	month(s)	when to take cuttings, to graft, take root divisions etc
51	Vegetative propagation	Techniques	text	recommended technique
52	Vegetative propagation	Storage	text	recommended condition
53	Vegetative propagation	Packaging	text	recommended technique
54	Vegetative propagation	Other details	text	specific details
55	More info		links	to external websites / databases
56	db-status		date	when the item was last updated

Variety table

0	Data category	Field label	data type	comment
1	Names	Variety name	text	most common variety name (no translations necessary)
2	Names	Alernative variety name	text	(not implementet yet)
3	Basic characteristics	Growth habit	?	(have not worked with yet)
4	Basic characteristics	Leaf shape	text / id	text or a reference to an illustration by an id (in later version )
5	Basic characteristics	Leaf color	text / id	text or a reference to a color scale by an id (in later version )
6	Basic characteristics	Flower color	text / id	text or a reference to a color scale by an id (in later version )
7	Basic characteristics	Flower amount	text	scarce / medium / plentiful (for example..)
8	Basic characteristics	Seed amount	text	scarce / medium / plentiful (for example..)
9	Basic characteristics	Seed size	number	average
10	Basic characteristics	Maturation	number	days
11	Basic characteristics	Maturation	text	early / medium / late (for example..)
12	Crop part properties	Plant part	text	the plant part mainly used
13	Crop part properties	Skin colour	text / id	text or a reference to a color scale by an id (in later version )
14	Crop part properties	Core colour	text / id	text or a reference to a color scale by an id (in later version )
15	Crop part properties	Shape	text / id	text or a reference to an illustration by an id (in later version )
16	Crop part properties	Size	mm	average
17	Crop part properties	Dry content	%	average
18	Crop part properties	Sugar content	%	average
19	Crop part properties	Crop volume	number	average
20	Crop part properties	Storability	text	short / medium / long (for example..)
21	Crop part properties	Other properties	text	variety details
22	Specific properties	Trait 1	text	extra field for traits only relevant to one or few species
23	Specific properties	Trait 2	text	extra field for traits only relevant to one or few species
24	Specific properties	Trait 3	text	extra field for traits only relevant to one or few species
25	Specific properties	Trait 4	text	extra field for traits only relevant to one or few species
26	Specific properties	Trait 5	text	extra field for traits only relevant to one or few species
27	Specific properties	Trait 6	text	extra field for traits only relevant to one or few species
28	Specific properties	Trait 7	text	extra field for traits only relevant to one or few species
29	Predators			(see species page) probably not variety dependant
30	Disease resistance	Resistant	text	list of diseases. highly variety dependant.
31	Disease resistance	Strong	text	list of diseases. highly variety dependant.
32	Disease resistance	Weak	text	list of diseases. highly variety dependant.
33	Disease resistance	Nonresistant	text	list of diseases. highly variety dependant.
34	Cultivation and use			(see species page) much not variety dependant
35	Cultivation and use	Common uses	text	to a certain degree variety dependant
36	Cultivation and use	Taste reputation	text	good / medium / neutral. highly variety dependant
37	Cultivation and use	Product quality	text	good / medium / bad. highly variety dependant
38	Cultivation and use	Cultivation prevalence	text	how widely grown etc. highly variety dependant.
39	Cultivation and use	Cultivation areas	text	where grown. highly variety dependant
40	History	Year of origin	year	if known, or best guess
41	History	Country of origin	text	if known, or best guess
42	History	Place of origin	text	if known, or best guess
43	History	Parent variety 1	text	if known
44	History	Parent variety 2	text	if known
45	History	Cross name	text	if known
46	History	Breeder	text	if known
47	History	General description	text	if known
48	History	Anecdotal	text	if known
49	Legal status	Owner/ representative	text	if rightsholder exists
50	Legal status	Protected name	text	if rightsholder exists
51	Legal status	Norw. variety list (entry)	date	if rightsholder exists and registred
52	Legal status	Norw. variety list (exit)	date	if rightsholder exists and registred
53	Sources of plant material	NordGen accessions	links	when new grin-based system is established
54	Sources of plant material	NGRS accessions	links	when new grin-based system is established
55	Sources of plant material	Donor	text	if known
56	More info		links	to external websites / databases
57	db-status		date	when the item was last updated