Once all the information is collected, I need to enter it into BG-Base, primarily into the "Plants" table of BG-Base. Below are examples of some of the screens I work with when completing data entry:
^Location, number of plants, condition, flowering/fruiting stage and other notes go into this window of the Plants table.
^How complex the BG-Base window can get if I'm making edits across tables and performing queries, and yes, it's running on a Mac : )
BG-Base is a "relational" database, which means that there are many tables tied together so that data from one table can be displayed in fields of another. While this is cool, it sure makes for a lot of work in terms of data entry and making sure the integrity of all the connections between tables are maintained whenever edits are made. A large computer screen is definitely a BIG help.
On a related note, our records labels have finally arrived! Records labels are a great help when it comes to keeping accurate track of the plants in our collections. Each plant or mass of plants is a unique entity with all its information in our database, so it is crucial to accurately maintain this link, which is similar to the link our social security numbers provide from ourselves to information about us. In both cases, if that link gets broken, it's bad news - the former being clearly far more serious a matter. Our records labels include each plant's scientific Latin name, source, and accession number + qualifier - its "social security number." This number allows me to double-check that the plant I'm looking at is the plant on my sheet I want to inventory and also acts as a key to access all the data we have for a given plant. The labels are primarily useful to our Gardens' staff but horticulturists, botanists, serious gardeners and curious guests will all find them useful if they want to know more about a specific plant. Here are a couple pictures of the glimmering labels (563 in total). You can see parts of the stakes the labels are attached to in the second photo; they resemble a key chain ring attached to the top of a 6-inch metal stake.
Rick Hederstrom
Associate Director
Remember, our gardens officially "opened on 3/21/11," just 9 months ago. We're right on target with our first year goals; our visitors are truly finding our tours unique and different, as well as informative and educational and our entire garden and hotel staff are finding the gardens both rewarding and challenging. Our Associate Director's blog, is proving to be entertaining, informative, and quite different from most garden blogs and I, for one, am enjoying it. Hope you are too. Joe Harris, Executive Director, The Botanic Gardens at Kona Kai Resort.
ReplyDeleteHello
ReplyDeleteMy name is marco antonio soto, looking for plants labeled methods, I have found your blog, I can see the great work you are doing with BG-Base, I have been lucky to handle and also to check each plant that reaches our garden as treatments you do, share your idea that it's nice to know the life history of each plant with us.
I hope to keep in touch with you and your botanical garden
Hi Marco, thanks for your comment! I am glad you have found my blog and that this post has been helpful to you; hopefully you will find some of the other posts of interest as well. I wish you the best of luck with your garden - where is your garden located and does it have any particular focus?
Delete