Site Talk forum: export the entire sempervivum list to excel

Views: 204, Replies: 11 » Jump to the end
Name: Mary Stella
Anchorage, AK (Zone 4b)
Peonies Ponds Dahlias Canning and food preservation Lilies Permaculture
Garden Ideas: Level 2
Image
Oberon46
Apr 25, 2016 10:01 AM CST
@Dave someone suggested this might be a good place to put this request/question. I would like to export the entire sempervivum list to excel to compare with our IrisBG inventory for the Alaska Botanical Garden; to see what we have that you have and to look for new plants that might make it up here. I am part of the rock garden team(volunteer) and sort of a floating volunteer at the garden in general. I spent the last year working on our new inventory software 1) taking lists to the garden to verify live plants, 2) marking ones that were dead, 3) printing and attaching labels to tags to set out in the garden that have our name and accession number on them, 4) taking pictures and GPS coordinates, etc. A great project. Still much to be done but I have now joined the rock garden and wild flower societies here as well as formally on the twice a month rock garden team. I am retired but you would think I could just spend every day out there and I would if my DH wouldn't rebel as our home and yard goes to rack and ruin. Rolling on the floor laughing I was walking through the gardens the other day and saw all the tags and signs I put out and felt pretty good. Oh, we also have made Microsoft Publisher pages with two pictures of a plant, its botanical information, then info on color, ht, nativity, bloom time etc. Mike, the curator, adds the QR code and then prints a larger sign (3x4) for plants so people with smart phones can get info on what a plant looks like in bloom or whatever. Once the sign is out there we can change the information on the publisher page at will and not have to change the sign. Super neat. I have done about 180 of the 200 signs we wanted for spring. We are trying to find software that we can afford to do a mapping of the garden using the gps coordinates and put it on our web site so people can easily find plants of interest to them. We are a very little garden with big dreams. Hurray!
"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: 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
Apr 25, 2016 10:15 AM CST

Garden.org Admin

Oberon46 said:I would like to export the entire sempervivum list to excel


I'm not exactly clear on what you're requesting here.

Are you wanting our Sempervivum Database exported to Excel? Just the names of each plant?
Name: Mary Stella
Anchorage, AK (Zone 4b)
Peonies Ponds Dahlias Canning and food preservation Lilies Permaculture
Garden Ideas: Level 2
Image
Oberon46
Apr 25, 2016 10:25 AM CST
Yes, plus any info that might help me see how they would fare in our climate.
"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: 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
Apr 25, 2016 10:29 AM CST

Garden.org Admin

The database isn't designed to be downloaded and duplicated like that, but you can view the full list of all the names here:

http://garden.org/plants/browse/plants/children/186377/

Hope that helps!
Name: Mary Stella
Anchorage, AK (Zone 4b)
Peonies Ponds Dahlias Canning and food preservation Lilies Permaculture
Garden Ideas: Level 2
Image
Oberon46
Apr 25, 2016 11:02 AM CST
Well, not really but I appreciate your response. It would take me forever to 'view' the plants listed, cross check them to our list and perhaps investigate zones where they grow best. It was just a thought. Sighing! Thank You!
"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: 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
Apr 25, 2016 11:37 AM CST
This might be a silly question, but, Mary, have you tried searching the semp database for plants that grow in your zone? That might pare down the list to a manageable level.
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
Apr 25, 2016 12:36 PM CST

Garden.org Admin

Excellent idea.
Name: Greene
Savannah, GA (Sunset 28) (Zone 8b)
Rabbit Keeper Critters Allowed Celebrating Gardening: 2015 Plant Identifier Garden Ideas: Master Level Garden Sages
Herbs Region: Georgia Region: United States of America Native Plants and Wildflowers Dog Lover Composter
Image
greene
Apr 25, 2016 1:20 PM CST
Pares it down to 3 plants in zone 4b.
Sunset Zone 28, AHS Heat Zone 9, USDA zone 8b~~"Leaf of Faith"
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
Apr 25, 2016 3:16 PM CST
Try zone 4a. Smiling
Confidence is that feeling you have right before you do something really stupid.
Name: Mary Stella
Anchorage, AK (Zone 4b)
Peonies Ponds Dahlias Canning and food preservation Lilies Permaculture
Garden Ideas: Level 2
Image
Oberon46
Apr 25, 2016 5:03 PM CST
Three plants is all?? Oh, it has to be more than that. Our rock garden at the botanical has way more plants than that. And how do I search by zone. I will go look at the search part here. I must have missed that. Probably should have gone to the plant database search THEN looked for semps and qualified it by zone. Great idea. Thanks so much.
"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: 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
Apr 25, 2016 5:28 PM CST
Go to the plant database and on the right side of the page is a list of custom databases. Click on Sempervivums and then click on search by characteristics. The search by zone is a bit of a ways down the page (it's right after Soil ph preferences). If you select zone 4a as the minimum zone, you get 2441 results.
Confidence is that feeling you have right before you do something really stupid.
Name: Mary Stella
Anchorage, AK (Zone 4b)
Peonies Ponds Dahlias Canning and food preservation Lilies Permaculture
Garden Ideas: Level 2
Image
Oberon46
Apr 25, 2016 7:00 PM CST
Great. That's more like it. Thanks so much
"What a person needs in gardening is a cast iron back with a hinge in it" Charles Dudley Warner (spelling edited by Dinu lol)

« Garden.org Homepage
« Back to the top
« Forums List
« Site Talk 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"