Lake Wilderness Arboretum Plants

Lake Wilderness Arboretum Plants

 

 

About Arboretum Plant Records

The Lake Wilderness Arboretum is home to over 1000 different plant species. This site has been created by an Arboretum docent to help keep track of those plants – their names and locations as well as other attributes. This data is stored in an online database that is available to the public for viewing and can be updated by authorized individuals. You can search this plant data to learn what’s in the Arboretum's gardens and can view more detailed information for each plant by simply clicking on its built-in link to Google. This site also provides maps of the Arboretum that can be used to interactively list plants in individual garden beds.

Not all plants in the Arboretum have been entered into the plant database. Nevertheless, the plant lists on this site provides a fairly good view of what is growing the Arboretum. The currency and completeness of this site’s plant records is dependent on the availability of volunteers to enter the appropriate data.

This site has been created and is currently being maintained by an Arboretum docent who can be reached at the email shown on the bottom of this page. The software and data on this site is free and available to the public. Email LWAF docents at tours@lakewildernessarboretum.org if you have any specific questions regarding Arboretum plants and check the Arboretum's website for docent-led tours.

An Overview of Website Features

The software that runs this website is called the “Accession Application” or "Accession App" for short. It is a general purpose, web-based system that provides online access to information about Lake Wilderness Arboretum plants. Plant information is entered via online forms and reports. New plant records and be added and existing records can be revised or deleted. The system also provides an import and export capability using a spreadsheet compatible format (comma-separated-values). Security is provided so that the public can view plant records, but only authorized users may update records. At the click of a button plant labels can be generated, plants images can be shown, and standard reports can be created.


Accession Application features include:

  • Online Plant Database
    An online database is provided for capturing information about plants planted in the Arboretum. This database contains many attributes about each plant including:
    • A unique accession number (computer assigned unless manually entered)
    • Location (Garden, GPS, Notes)
    • Geographical locality where plant is native
    • Plant name (both common name and botanical name)
    • Dates (date planted, date entered into the database, last revision date)
    • Comments
    • Supplier
    • Original $cost
    • Many other fields

    The database is easily tailored so that new fields can be added upon request.

  • Lookup Tables
    User controlled "lookup" tables are provided for easy, accurate data entry. Tables are provided for garden names, plant supplier names, plant donor names, and botanical names. These table are used to provide convenient dropdown selections on input forms which insures accuracy and consistency among records.

  • Accurate Botanical Names
    A Genus/Family lookup table is provided enabling automatic assignment of a plant family names. For scientific names, upon entry of a plant's genus the family is automatically assigned. This guarantees that the genus/family relationship in the name is always correct.

  • Pre-Defined Reports
    A set of pre-defined reports is available online or in printed format at the click of a button. Each pre-defined report shows a different subset of the arboretums plants (e. g. all shrubs, all perennials, all conifers, etc.)

  • User-Defined Reports
    The application allows you to create your own report including plant selection and sort criteria as well as report format. This feature allows you to tailor a report specifically for your needs. Different report formats enable you to choose a compressed listing showing only a few important plant attributes or an expanded listing showing more attributes. For example, you can produce a condensed list of all maples, an expanded list of all firs, or a detailed listing of all records that you updated today (handy for checking your data entry). Options available enable an unlimited variety of reports.

  • GoogleTM Search
    At the click of a button, a Google search can be invoked to display plant images and provide links to additional information on the Internet. GoogleTM Search is a trademark of Google Inc.

  • Online Data Entry Forms
    Easy-to-use online forms are provided for adding, revising, or deleting plant records. All fields on the forms take logical defaults if left blank and many of the fields are completed by selecting an item from a dropdown list.

  • Online Help
    Online help includes a user manual and a description of all available reports.

  • Links to interesting plant sites
    Links to other helpful sites are provided so that users can quickly visit sites of common interest.

  • Open Software
    The software that implements the accession application is freely available and is accompanied by a programming maintenance manual that is part of the online help.

Technical Specification

The Lake Wilderness Arboretum Accession Application is currently hosted on Dreamhost. It uses a MySQL database running on MySQL version 5.6. The code is written in PHP. A maintenance manual is provided online providing more detailed information about the application code and its operating environment.



Question/comments regarding this site? - Email: plantsteward@gmail.com
Mailing Address: 28308 185th Ave SE; Kent, WA 98042