';" aria-label="breadcrumb"> Plant Database forum Data architecture proposal for daffodils

Dec 30, 2011 12:21 PM CST

Thread OP

Name: Janice
Cape Cod, MA, USA (Zone 7a)

What fields would you like to see specific to Daffodils?

For starters:

A field for Division. This could be a drop down box of the 13 divisions to choose from.

There are two ways to live your life.
One is as though nothing is a miracle.
The other is as though everything is a miracle
- Albert Einstein.

| @sandnsea2 | Post #195827 (1)

Dec 30, 2011 12:56 PM CST

Name: Janet Super Sleuth
Near Lincoln UK

A list of daff divisions..

http://www.qualitydaffodils.co...

| @JRsbugs | Post #195847 (2)

dave

Dec 30, 2011 1:00 PM CST

Garden.org Admin

Name: Dave Whitinger
Southlake, Texas (Zone 8a)

This is going to be a lot more efficient if one of you could list out all the options that we want for each data field so I can put them directly into the architecture here. If I have to go to web links and pull down information, there's a very good chance something will get missed.

| @dave | Post #195852 (3)

Dec 30, 2011 1:04 PM CST

Thread OP

Name: Janice
Cape Cod, MA, USA (Zone 7a)

I will do that.

There are two ways to live your life.
One is as though nothing is a miracle.
The other is as though everything is a miracle
- Albert Einstein.

| @sandnsea2 | Post #195856 (4)

Dec 30, 2011 1:06 PM CST

Thread OP

Name: Janice
Cape Cod, MA, USA (Zone 7a)

DIVISION 1 - Trumpet

DIVSION 2 - Large - cupped

DIVISION 3 - Small - cupped

DIVISION 4 - Double

DIVISION 5 - Triandrus

DIVISION 6 - Cyclamineus

DIVISION 7 - Jonquilla

DIVISION 8 - Tazetta

DIVISION 9 - Poeticus

DIVISION 10 - Bulboccodium

DIVISION 11 - Split Corona

DIVISION 12 - Other Cultivars

DIVISION 13 - Species

There are two ways to live your life.
One is as though nothing is a miracle.
The other is as though everything is a miracle
- Albert Einstein.

| @sandnsea2 | Post #195857 (5)

Last edited by sandnsea2 Dec 30, 2011 2:47 PM

dave

Dec 30, 2011 1:12 PM CST

Garden.org Admin

Name: Dave Whitinger
Southlake, Texas (Zone 8a)

Do you want them displayed with the word "DIVISION" in all capitals like that?

Also, does the hyphen after 13 belong?

| @dave | Post #195864 (6)

Dec 30, 2011 1:15 PM CST

Thread OP

Name: Janice
Cape Cod, MA, USA (Zone 7a)

Dave, I need to work on the list a little bit more, ok? Be done in a bit.

There are two ways to live your life.
One is as though nothing is a miracle.
The other is as though everything is a miracle
- Albert Einstein.

| @sandnsea2 | Post #195867 (7)

dave

Dec 30, 2011 1:22 PM CST

Garden.org Admin

Name: Dave Whitinger
Southlake, Texas (Zone 8a)

Take your time.

| @dave | Post #195873 (8)

Dec 30, 2011 1:31 PM CST

Name: Janet Super Sleuth
Near Lincoln UK

Division 13 Daffodils Distinguished Solely by Botanical Name

Might be better just as "Species" ?

| @JRsbugs | Post #195878 (9)

Dec 30, 2011 1:46 PM CST

Thread OP

Name: Janice
Cape Cod, MA, USA (Zone 7a)

Done, Janet.

There are two ways to live your life.
One is as though nothing is a miracle.
The other is as though everything is a miracle
- Albert Einstein.

| @sandnsea2 | Post #195881 (10)

Dec 30, 2011 1:49 PM CST

Name: Janet Super Sleuth
Near Lincoln UK

Features to list:

Season:

Very Early
Early
Mid Season
Late
Very Late

These seasons will differ according to lacation so I doubt it's a good idea to list months with flowering periods.

Categories:

Historical Variety
Scented Daffodils
Miniature Daffodils
Intermediate Size
Tall Daffodils

I'm not sure 'tall' fits here as most don't grow that tall. (I added tall as there is a difference, some are listed as tall!)

I'm not sure if colour is necessary either, they are white or yellow perianth with white, yellow, green, orange, red or pink corona. Could color be included somehow in the categories? Some are bicoloured too but the main colour is usually dominant.

White perianth
Yellow perianth
White corona
Yellow corona
Orange corona
Green corona
Red corona
Pink corona

There's doubles with bicoloured centres and singles with a coloured corona rim, may bicoloured can be included if colours are listed.

| @JRsbugs | Post #195884 (11)

Last edited by JRsbugs Dec 30, 2011 2:10 PM

Dec 30, 2011 1:49 PM CST

Thread OP

Name: Janice
Cape Cod, MA, USA (Zone 7a)

Dave, the Divisions in Caps are the way they always appear in Catalogs and books.
As to Div 11with A & B, Janet, what do you think?

There are two ways to live your life.
One is as though nothing is a miracle.
The other is as though everything is a miracle
- Albert Einstein.

| @sandnsea2 | Post #195885 (12)

Dec 30, 2011 1:52 PM CST

Name: Janet Super Sleuth
Near Lincoln UK

I wondered about Div. 11 too Janice, maybe that would make it too complicated, see what Dave thinks.

| @JRsbugs | Post #195887 (13)

Dec 30, 2011 1:56 PM CST

Thread OP

Name: Janice
Cape Cod, MA, USA (Zone 7a)

The nice thing about the Divisions is they have the flowering time and US zone hardiness defined, so alot of the information can be listed with a Databox description at the header page for each Division. That will make alot less data that needs to be entered for each individual Daffodil.

Same thing with the tulips.

There are two ways to live your life.
One is as though nothing is a miracle.
The other is as though everything is a miracle
- Albert Einstein.

| @sandnsea2 | Post #195890 (14)

Dec 30, 2011 1:58 PM CST

Thread OP

Name: Janice
Cape Cod, MA, USA (Zone 7a)

That is what I thought, Janet. I will leave it out. We can always revisit it later.

There are two ways to live your life.
One is as though nothing is a miracle.
The other is as though everything is a miracle
- Albert Einstein.

| @sandnsea2 | Post #195891 (15)

Dec 30, 2011 1:59 PM CST

Name: Janet Super Sleuth
Near Lincoln UK

Agreed! I just added more colours to the list.

| @JRsbugs | Post #195893 (16)

Dec 30, 2011 2:02 PM CST

Name: Janet Super Sleuth
Near Lincoln UK

To make things more simple, the daff site has daffs by colour!

All white

White with Red or Orange

White with Pink

White with Yellow

All yellow

Yellow with Red or Orange

Yellow with White

Yellow with Pink

Orange with Orange or Red

They missed out green!

White or yellow with green?

| @JRsbugs | Post #195896 (17)

Last edited by JRsbugs Dec 30, 2011 4:30 PM

Dec 30, 2011 2:14 PM CST

Thread OP

Name: Janice
Cape Cod, MA, USA (Zone 7a)

For Color:

We could have :

Perianth (with a drop down box of the colors)............................white, yellow ,gold, orange, red, pink, green
Corona ( with a drop down box of the colors) ..........................white, yellow, gold, orange, red, pink, green

other category

any other colors Janet?

There are two ways to live your life.
One is as though nothing is a miracle.
The other is as though everything is a miracle
- Albert Einstein.

| @sandnsea2 | Post #195907 (18)

Last edited by sandnsea2 Dec 30, 2011 2:27 PM

Dec 30, 2011 2:51 PM CST

Thread OP

Name: Janice
Cape Cod, MA, USA (Zone 7a)

Dave can you add the Divisons and Colors now and we'll keep working on the rest?
Thanks!

There are two ways to live your life.
One is as though nothing is a miracle.
The other is as though everything is a miracle
- Albert Einstein.

| @sandnsea2 | Post #195917 (19)

Dec 30, 2011 4:27 PM CST

Name: Janet Super Sleuth
Near Lincoln UK

I don't think there are any daffs with a red, pink, orange or green perianth Janice, most are a shade of yellow or white.

Perhaps best to stick with the simple combinations? There are some with a green corona, I'm not sure how we could add that as a combination. Maybe 'White or yellow with green' would cover it?