Plant Database forum: Search plants by characteristics

Views: 995, Replies: 18 » Jump to the end
Name: Dave Whitinger
Jacksonville, Texas (Zone 8b)
Charter ATP Member Region: Texas Master Gardener: Texas Permaculture Raises cows I was one of the first 300 contributors to the plant database!
Garden Ideas: Master Level Beekeeper Garden Sages Avid Green Pages Reviewer Celebrating Gardening: 2015 Plant Identifier
Image
dave
Aug 2, 2012 10:13 AM CST

Garden.org Admin

In our database, there are 37 shrubs that have blue flowers, while there are no cacti/succulents with blue flowers! There are 77 trees with pink flowers. Among those, 16 have edible fruit.

How do I know all this? For some time we have had a "search by characteristics" engine for the custom databases like roses and daylilies. Today I am pleased to announce that this search engine has been extended to now allow the entire database to be searched.

You can access it by going to the Plant Database and then click on "Search all plants by characteristics".
[Last edited by dave - Aug 2, 2012 10:31 AM (+)]
Give a thumbs up | Quote | Post #294408 (1)
Name: Juli
(Zone 5b)
Region: United States of America Charter ATP Member Cottage Gardener Daylilies Garden Photography Enjoys or suffers cold winters
Birds Hummingbirder Butterflies Dog Lover Cat Lover Garden Ideas: Master Level
Image
daylily
Aug 2, 2012 12:10 PM CST
Hurray! Hurray! Hurray!

any plans for being able to sort the search?
Name: woofie
NE WA (Zone 5a)
Charter ATP Member Garden Procrastinator Greenhouse Dragonflies Plays in the sandbox I was one of the first 300 contributors to the plant database!
The WITWIT Badge I helped plan and beta test the plant database. Dog Lover Enjoys or suffers cold winters Container Gardener Seed Starter
Image
woofie
Aug 2, 2012 12:24 PM CST
Hilarious! Juli is being greedy! Hilarious!
Confidence is that feeling you have right before you do something really stupid.
Name: Dave Whitinger
Jacksonville, Texas (Zone 8b)
Charter ATP Member Region: Texas Master Gardener: Texas Permaculture Raises cows I was one of the first 300 contributors to the plant database!
Garden Ideas: Master Level Beekeeper Garden Sages Avid Green Pages Reviewer Celebrating Gardening: 2015 Plant Identifier
Image
dave
Aug 2, 2012 12:34 PM CST

Garden.org Admin

daylily said:any plans for being able to sort the search?


Sort it how?
Name: Suzanne/Sue
Sebastopol, CA (Zone 9a)
Sunset Zone 15
Region: California Plant Database Moderator Roses Irises Clematis Garden Photography
Cottage Gardener Keeper of Poultry Hummingbirder Bee Lover Butterflies Birds
Image
Calif_Sue
Aug 2, 2012 1:33 PM CST

Plants Admin

And we need help filling in those details so that they can become part of the search!! Thumbs up
My gardening Blog!
Hand sewn wares and vintage finds in my Etsy store. Summer Song Cottage
Name: Dave Whitinger
Jacksonville, Texas (Zone 8b)
Charter ATP Member Region: Texas Master Gardener: Texas Permaculture Raises cows I was one of the first 300 contributors to the plant database!
Garden Ideas: Master Level Beekeeper Garden Sages Avid Green Pages Reviewer Celebrating Gardening: 2015 Plant Identifier
Image
dave
Aug 2, 2012 1:42 PM CST

Garden.org Admin

dave said:Sort it how?


I've given this some thought and have added a rudimentary sorting system. It grabs all the matching plants and then sorts them by the display name. So it may not be 100% perfect but it's pretty good, I think. Smiling
Name: Juli
(Zone 5b)
Region: United States of America Charter ATP Member Cottage Gardener Daylilies Garden Photography Enjoys or suffers cold winters
Birds Hummingbirder Butterflies Dog Lover Cat Lover Garden Ideas: Master Level
Image
daylily
Aug 2, 2012 5:29 PM CST
dave said:
Sort it how?


maybe I am mixing apples and oranges. I am thinking of general search.

I have done a general search for a name of a plant, and it has brought up lots of plants, and I have to search through them because they are all mixed up. It would be nice to be able to click on the column header and sort by species or alphabetical by cultivar name etc. For example, lets say a daylily I like has the name of a woman, but I don't remember the full name. So I put in the general search "Paula" The results do not seem to be in any order. Daylilies are not together, they are not alphabetical - they seem to me that they are listed any old way.

The other thing I wish in the characteristic search is that it was not limited. For instance if I go to the daylily database, search for Hanson as hybridizer, tet as ploidy - it says the max has been reached. It asks me to narrow my search. However, sometimes you want to know all the names of cultivars a certain person hybridized, not just a partial list. When I go to the AHS database and select the same options, it comes up with 573 daylilies, listed in alphabetical order, and lets me choose which of the 58 pages to display.

Maybe I don't know how to use the database here correctly? Shrug!

Sorry if I am being greedy --- *Blush*



Name: woofie
NE WA (Zone 5a)
Charter ATP Member Garden Procrastinator Greenhouse Dragonflies Plays in the sandbox I was one of the first 300 contributors to the plant database!
The WITWIT Badge I helped plan and beta test the plant database. Dog Lover Enjoys or suffers cold winters Container Gardener Seed Starter
Image
woofie
Aug 2, 2012 6:24 PM CST
Juli, I was just teasing! Hilarious! I think it would be nice to be able to sort search results, too!
Confidence is that feeling you have right before you do something really stupid.
Name: Lynn
Dallas, OR (Zone 8b)
Charter ATP Member Garden Sages I helped plan and beta test the plant database. I helped beta test the Garden Planting Calendar I was one of the first 300 contributors to the plant database! Plant Database Moderator
Forum moderator I helped beta test the first seed swap Celebrating Gardening: 2015 Plant and/or Seed Trader Garden Ideas: Master Level Sempervivums
Image
valleylynn
Aug 4, 2012 6:57 AM CST
I can find the parent plant for sempervivum. It used to be the very first shown when I typed in 'sempervivum'?
Name: Dave Whitinger
Jacksonville, Texas (Zone 8b)
Charter ATP Member Region: Texas Master Gardener: Texas Permaculture Raises cows I was one of the first 300 contributors to the plant database!
Garden Ideas: Master Level Beekeeper Garden Sages Avid Green Pages Reviewer Celebrating Gardening: 2015 Plant Identifier
Image
dave
Aug 4, 2012 7:07 AM CST

Garden.org Admin

Juli, I have it sorting alphabetically now.

As for the rest of your proposed enhancements, they will have to wait until I can dig back in there and do this. It's very complicated to make a search engine that does what you're asking it to do.

Lynn, I searched for sempervivum and was taken directly to the Sempervivum Database front page. To find the parent plant, open any sempervivum entry in the database, scroll to the bottom and click on "See the general plant entry for Hen and Chicks (Sempervivum)".
Name: Lynn
Dallas, OR (Zone 8b)
Charter ATP Member Garden Sages I helped plan and beta test the plant database. I helped beta test the Garden Planting Calendar I was one of the first 300 contributors to the plant database! Plant Database Moderator
Forum moderator I helped beta test the first seed swap Celebrating Gardening: 2015 Plant and/or Seed Trader Garden Ideas: Master Level Sempervivums
Image
valleylynn
Aug 4, 2012 7:15 AM CST
Why isn't it just showing at the top of the list, like it used to? It was so much easier for new people to find.
Name: Dave Whitinger
Jacksonville, Texas (Zone 8b)
Charter ATP Member Region: Texas Master Gardener: Texas Permaculture Raises cows I was one of the first 300 contributors to the plant database!
Garden Ideas: Master Level Beekeeper Garden Sages Avid Green Pages Reviewer Celebrating Gardening: 2015 Plant Identifier
Image
dave
Aug 4, 2012 7:18 AM CST

Garden.org Admin

I'll see about making it more prominent, Lynn.
Name: Dave Whitinger
Jacksonville, Texas (Zone 8b)
Charter ATP Member Region: Texas Master Gardener: Texas Permaculture Raises cows I was one of the first 300 contributors to the plant database!
Garden Ideas: Master Level Beekeeper Garden Sages Avid Green Pages Reviewer Celebrating Gardening: 2015 Plant Identifier
Image
dave
Aug 4, 2012 7:20 AM CST

Garden.org Admin

Lynn, you can now click on "Access the general Sempervivum entry" right at the top of that page.
Name: Lynn
Dallas, OR (Zone 8b)
Charter ATP Member Garden Sages I helped plan and beta test the plant database. I helped beta test the Garden Planting Calendar I was one of the first 300 contributors to the plant database! Plant Database Moderator
Forum moderator I helped beta test the first seed swap Celebrating Gardening: 2015 Plant and/or Seed Trader Garden Ideas: Master Level Sempervivums
Image
valleylynn
Aug 4, 2012 7:24 AM CST
Thank you Dave. Group hug

By the way, the new search capability is awesome and fun. Thumbs up
Name: Dave Whitinger
Jacksonville, Texas (Zone 8b)
Charter ATP Member Region: Texas Master Gardener: Texas Permaculture Raises cows I was one of the first 300 contributors to the plant database!
Garden Ideas: Master Level Beekeeper Garden Sages Avid Green Pages Reviewer Celebrating Gardening: 2015 Plant Identifier
Image
dave
Aug 4, 2012 7:37 AM CST

Garden.org Admin

I tip my hat to you.
Name: Juli
(Zone 5b)
Region: United States of America Charter ATP Member Cottage Gardener Daylilies Garden Photography Enjoys or suffers cold winters
Birds Hummingbirder Butterflies Dog Lover Cat Lover Garden Ideas: Master Level
Image
daylily
Aug 4, 2012 10:15 PM CST
Thank you Dave!

You are the best!

Hurray!
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
Aug 5, 2012 5:51 PM CST

Plants Admin

Dave, When searching using Minimum cold hardiness is it possible to list not only plants in the zone selected but those in a colder zone?

ex.
if zone 5b is selected
then list plants in zone 5b thru zone 2.
Evan
Name: Dave Whitinger
Jacksonville, Texas (Zone 8b)
Charter ATP Member Region: Texas Master Gardener: Texas Permaculture Raises cows I was one of the first 300 contributors to the plant database!
Garden Ideas: Master Level Beekeeper Garden Sages Avid Green Pages Reviewer Celebrating Gardening: 2015 Plant Identifier
Image
dave
Aug 5, 2012 5:57 PM CST

Garden.org Admin

That's a hard one. I really want to be able to do that and it's on my wishlist but it's a very different and difficult thing. The select menu means "pick one". We have no support for "ranges of numbers" in the DB which is why we have hardiness in two pulldowns: minimum and maximum.

To let people search on a range will require a pretty big fundamental change to the system. I want to do it, I'm just not sure when.
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
Aug 5, 2012 10:11 PM CST

Plants Admin

All right, Thanks Dave.
Evan

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

Today's site banner is by dirtdorphins and is called "Lilium 'Pink Perfection'"