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