Peonies forum: Peonies custom database - Request for input

Views: 491, Replies: 18 » Jump to the end
Name: Evan
Pioneer Valley south, MA, USA (Zone 6a)
Charter ATP Member Plant Database Moderator Forum moderator Aroids Irises Celebrating Gardening: 2015
I was one of the first 300 contributors to the plant database! Tropicals Foliage Fan Bulbs Hummingbirder Lover of wildlife (Black bear badge)
Image
eclayne
Apr 16, 2014 10:24 AM CST

Plants Admin

I'd like to ask Dave to set up a custom database for Peonies. This would include all plants in genus Paeonia. An extremely thorough example of a custom database is The Daylilies Database. One feature of a custom database is the ability to add customized data-points which allows a customized search.

ex. Searching Daylilies
The customized data points from AHS link through AHS Awards are specific to the Daylilies database.

Here are some preliminary Smiling custom data point ideas, based on information from the Heartland Peony Society:

Plant Type:
-Herbaceous
-Tree
-Intersectional

Flower Type:
-Single
-Japanese
-Anemone
-Semi-Double
-Double
-Bomb Double

Suggestions please!

_____________________________________________________________________________

EDIT: An updated custom database:

WB = Write-box
CB = Check box(es)

Originator/Registrant: WB

Year of Registration or Introduction: WB

Parentage: (in general database)

Plant Type: CB
-Herbaceous
-Tree
-Itoh (Intersectional) Hybrid

Season of bloom: CB
-Very Early (week 1)
-Early (week 2)
-Early Midseason (week 3)
-Midseason (week 4)
-Late Midseason (week 5)
-Late (week 6)
-Very Late (week 7)

Flower Form: CB
-Single
-Japanese
-Anemone
-Semi-Double
-Bomb
-Full Double
-Novelty

Flower Color: CB
-Red
-Pink
-White
-Coral
-Lavender
-Yellow
-Purple
-Green
-Blend
-Orange

Flower color description: WB

Flower size: WB

Fragrance: CB
-Very
-Yes
-No
-Malodorous

Needs support: CB
-Yes
-No

Distinguishing features: WB
Evan
[Last edited by eclayne - Apr 21, 2014 1:00 PM (+)]
Give a thumbs up | Quote | Post #591286 (1)
Name: Mary Stella
Anchorage, AK (Zone 4b)
Peonies Ponds Dahlias Canning and food preservation Lilies Permaculture
Garden Ideas: Level 2
Image
Oberon46
Apr 16, 2014 10:42 AM CST
Nurseries list the bloom dates of plants by week; For instance, for most of the fernies they are a Week 1. On up to Week 7 I believe. That way you can match the week to your own area. For me a week 1 would be about May 25th. Obviously down south some of you will be past peonies by that time.
"What a person needs in gardening is a cast iron back with a hinge in it" Charles Dudley Warner (spelling edited by Dinu lol)
Name: Liz Best
Elizabeth Colorado (Zone 4b)
Peonies Winter Sowing Dahlias Region: Colorado Plant and/or Seed Trader Enjoys or suffers cold winters
Hummingbirder Cat Lover Lilies Daylilies Dog Lover Celebrating Gardening: 2015
Image
LizinElizabeth
Apr 16, 2014 8:41 PM CST
Maybe hybridizer and year? Lots of peony collectors search for specific hybridizers or for historic plants. Maybe even parents or progeny and whether it's fertile and how. Some growers label peonies that have good stems that don't need to be staked as landscape plants, that might be a good thing that people would want to search on, too. And scent.....good/bad or no noticeable, maybe.
Liz
Name: Mary Stella
Anchorage, AK (Zone 4b)
Peonies Ponds Dahlias Canning and food preservation Lilies Permaculture
Garden Ideas: Level 2
Image
Oberon46
Apr 16, 2014 10:31 PM CST
Color would be nice. Rolling on the floor laughing Rolling on the floor laughing Sorry. Couldn't help it.
"What a person needs in gardening is a cast iron back with a hinge in it" Charles Dudley Warner (spelling edited by Dinu lol)
Name: Caroline Scott
Calgary (Zone 4a)
Charter ATP Member Region: Canadian Bulbs Winter Sowing Enjoys or suffers cold winters Lilies
Peonies Plant Lover: Loves 'em all! Garden Ideas: Master Level
Image
CarolineScott
Apr 17, 2014 4:05 AM CST
This would be a good idea, but members need to contribute.
I like knowing the week of blooms.
Name: Mary Stella
Anchorage, AK (Zone 4b)
Peonies Ponds Dahlias Canning and food preservation Lilies Permaculture
Garden Ideas: Level 2
Image
Oberon46
Apr 17, 2014 6:50 PM CST
How so? I mean I can tell you the dates that mine have historically bloomed, or even broken dormancy and then equate that to a week type cycle. It would probably work for up here but doubt down there.

Or did you mean colors. That is sort of subjective. So could we just submit the colors the national peony judges them buy to keep it more objective. I do that for my dahlias using the ADS data base. As well as their rating for size of bloom, etc.
"What a person needs in gardening is a cast iron back with a hinge in it" Charles Dudley Warner (spelling edited by Dinu lol)
Name: Jerry
Salem, IL
Charter ATP Member
Image
Oldgardenrose
Apr 17, 2014 6:59 PM CST
I do not know how much info is necessary for the casual grower but this is one selected randomly from Hollingsworth which has all the info I need.

http://www.hollingsworthpeonies.com/inc/sdetail/625/2329
Name: Frank Richards
Clinton, Michigan

Garden Ideas: Master Level Celebrating Gardening: 2015 Plant Identifier
Image
frankrichards16
Apr 18, 2014 7:47 AM CST
maybe a link to Carsten Burkhardt's Web Project Paeonia - The Peony Database

http://www.paeo.de/aaa/01678.html

I have a google spreadsheet of all my plants. For all my peonies I have an entry with the link to Burkhardt's database.

For my daylilies, I usually link to ATP, which has a link to the AHS database.

on bloom times I use Early, Early Mid, Mid, Mid Late and Late rather than by week

Actually, early, mid and late work for me:)

flower type, size of flower, bloom time, color, height, width, hybridizer, intro year, distinguishing features



Name: Mary Stella
Anchorage, AK (Zone 4b)
Peonies Ponds Dahlias Canning and food preservation Lilies Permaculture
Garden Ideas: Level 2
Image
Oberon46
Apr 18, 2014 9:04 AM CST
That does about cover it for the slightly more than casual gardener. At least those are the things I track in my database.
"What a person needs in gardening is a cast iron back with a hinge in it" Charles Dudley Warner (spelling edited by Dinu lol)
Name: Evan
Pioneer Valley south, MA, USA (Zone 6a)
Charter ATP Member Plant Database Moderator Forum moderator Aroids Irises Celebrating Gardening: 2015
I was one of the first 300 contributors to the plant database! Tropicals Foliage Fan Bulbs Hummingbirder Lover of wildlife (Black bear badge)
Image
eclayne
Apr 18, 2014 9:31 AM CST

Plants Admin

Heartland has a "Peony Identification Utility" which addresses a few data points, including bloom season (Very Early through Very Late)
http://www.peonies.org/ident.html

Is this how bloom week corresponds?
Very Early - week 1
Early - week 2
Early Midseason - week 3
Midseason - week 4
Late Midseason - week 5
Late - week 6
Very Late - week 7

They also list Flower Color. Do these correspond with how Peonies are judged?
-Red
-Pink
-White
-Coral
-Lavender
-Yellow
-Purple
-Green
-Blend
-Orange

Should there be a write box for "Bloom color description" as well?
Evan
[Last edited by eclayne - Apr 18, 2014 9:55 AM (+)]
Give a thumbs up | Quote | Post #592596 (10)
Name: Evan
Pioneer Valley south, MA, USA (Zone 6a)
Charter ATP Member Plant Database Moderator Forum moderator Aroids Irises Celebrating Gardening: 2015
I was one of the first 300 contributors to the plant database! Tropicals Foliage Fan Bulbs Hummingbirder Lover of wildlife (Black bear badge)
Image
eclayne
Apr 18, 2014 10:45 AM CST

Plants Admin

I've edited my original post to reflect your recommendations. What do you think?
Some of the terms I used are from the American Peony Society Cultivar Registration Form (Pdf or Word document). Listed under Administration.

I notice they list "CULTIVAR GROUP (Type):" instead of "Plant type". Thoughts??
Evan
Name: Evan
Pioneer Valley south, MA, USA (Zone 6a)
Charter ATP Member Plant Database Moderator Forum moderator Aroids Irises Celebrating Gardening: 2015
I was one of the first 300 contributors to the plant database! Tropicals Foliage Fan Bulbs Hummingbirder Lover of wildlife (Black bear badge)
Image
eclayne
Apr 18, 2014 11:10 AM CST

Plants Admin

Distinguishing features:

Should this be a write box?
Evan
Name: Annette
Duluth, Ga (Zone 7a)
Charter ATP Member Birds Tropicals Hummingbirder Bulbs Region: Georgia
Lilies Irises Peonies Clematis Plumerias Roses
Image
Cem9165
Apr 18, 2014 6:44 PM CST
Evan,

Could we also get a CB for "Fragrant"? This is on if the features I look for when researching a plant.

Annette
"Aspire to inspire before you expire"

author unknown
Name: Evan
Pioneer Valley south, MA, USA (Zone 6a)
Charter ATP Member Plant Database Moderator Forum moderator Aroids Irises Celebrating Gardening: 2015
I was one of the first 300 contributors to the plant database! Tropicals Foliage Fan Bulbs Hummingbirder Lover of wildlife (Black bear badge)
Image
eclayne
Apr 19, 2014 9:31 AM CST

Plants Admin

The APS has check boxes for Fragrance: Very, Yes, No, Malodorous.

This is added.
Evan
Name: Caroline Scott
Calgary (Zone 4a)
Charter ATP Member Region: Canadian Bulbs Winter Sowing Enjoys or suffers cold winters Lilies
Peonies Plant Lover: Loves 'em all! Garden Ideas: Master Level
Image
CarolineScott
Apr 19, 2014 9:36 AM CST
The bloom weeks usually compare the time of bloom to Red Charm.
If they bloom before Red Charm---they have a negative bloom week.
If they bloom after Red Charm----they have a positive bloom week.
The week that Red Charm blooms is week zero.
Name: Evan
Pioneer Valley south, MA, USA (Zone 6a)
Charter ATP Member Plant Database Moderator Forum moderator Aroids Irises Celebrating Gardening: 2015
I was one of the first 300 contributors to the plant database! Tropicals Foliage Fan Bulbs Hummingbirder Lover of wildlife (Black bear badge)
Image
eclayne
Apr 19, 2014 9:49 AM CST

Plants Admin

Thumbs up Peony Bloom Sequence Sorted Alphabetically. In days + or -.

Does this change the relation between:
ex. Very Early (week 1), Very Late (week 7)?
Evan
[Last edited by eclayne - Apr 21, 2014 12:58 PM (+)]
Give a thumbs up | Quote | Post #593394 (16)
Name: Annette
Duluth, Ga (Zone 7a)
Charter ATP Member Birds Tropicals Hummingbirder Bulbs Region: Georgia
Lilies Irises Peonies Clematis Plumerias Roses
Image
Cem9165
Apr 19, 2014 12:24 PM CST
Thanks for adding the CB for fragrance.
"Aspire to inspire before you expire"

author unknown
Name: Evan
Pioneer Valley south, MA, USA (Zone 6a)
Charter ATP Member Plant Database Moderator Forum moderator Aroids Irises Celebrating Gardening: 2015
I was one of the first 300 contributors to the plant database! Tropicals Foliage Fan Bulbs Hummingbirder Lover of wildlife (Black bear badge)
Image
eclayne
Apr 19, 2014 12:47 PM CST

Plants Admin

I tip my hat to you.
Evan
Name: Evan
Pioneer Valley south, MA, USA (Zone 6a)
Charter ATP Member Plant Database Moderator Forum moderator Aroids Irises Celebrating Gardening: 2015
I was one of the first 300 contributors to the plant database! Tropicals Foliage Fan Bulbs Hummingbirder Lover of wildlife (Black bear badge)
Image
eclayne
Apr 21, 2014 12:57 PM CST

Plants Admin

I'd like to to wrap this up this week and I have a few questions. Any input, particularly pointing out mistakes, would be very helpful.

@frankrichards16
eclayne said:Distinguishing features:
Should this be a write box?

This is added as a WB.

Is this the correct relationship?
ex. Very Early (week 1), Very Late (week 7)

Do any of the Checkbox datapoints need a box labeled Other with a write box?
ex.
Needs support: CB
-Yes
-No
-Other: WB (This could be added)
Evan
[Last edited by eclayne - Apr 21, 2014 1:03 PM (+)]
Give a thumbs up | Quote | Post #595114 (19)

« Garden.org Homepage
« Back to the top
« Forums List
« Peonies forum
You must first create a username and login before you can reply to this thread.

Today's site banner is by ge1836 and is called "Pacific Blue Ice"