What's new in SPAR SPAR logo

Enhancements implemented from March 2005 to May 2006

The Seed Planning and Registry system undergoes regular enhancements and maintenance as new legislation, standards and policies come into effect.  Following is a list of new developments and improvements to existing functions implemented since early 2005:

New Functionality

  • Application for Seedlot Registration - Seed orchard managers and cone collectors can now register seedlots online.  The requirements for seedlot registration in the Chief Forester’s Standards for Seed Use are all included in the online seedlot registration screen.  The screen layout differs for a collection from a natural stand (Class B, B+) and collection from a seed orchard (Class A).
  • Seedlot Registration Parent Tree* Contribution screen - Collections from a seed orchard require entry of the cone and pollen counts for all the parent trees contributing to the seedlot.  The Genetic Worth of the seedlot is calculated from the Breeding Values of the contributing parent trees.  Initially only the G (growth) value could be calculated, but a subsequent release now calculate the R (resistance) and D (density) values.
  • Parent Tree Registration - Parent trees are now entered and registered in SPAR.  There are 5 new screens where data is entered by Research Branch Forests Genetics staff or Tree Improvement Branch staff:  Parent Tree Maintenance, Parent Tree Area of Use, Parent Tree Test and Parent Tree Genetic Quality.  Seed orchard staff can now enter the list of parent trees in their orchard on the Parent Tree Orchard screen.
  • Parent Tree Detail screens - Information on individual Parent Trees can be viewed on 4 new screens: Parent Tree Detail, Parent Tree Orchard, Parent Tree Area of Use and Parent Tree Genetic Quality.
  • Parent Tree Search - Search parameters are entered to list the Parent Trees in the database.
  • Parent Tree data extract in xml format – Intended for SPAR users with MS Access, the extract submission provides Parent Tree data directly from the Oracle database in an xml format.
  • Nursery Grams Adjustment - Nurseries can now lists several seedling requests on one screen and reduce the grams of seed for any requests assigned to their nursery.
  • Provenance data added for Superior Provenance lots – For B+ seedlots, a data attribute was added for Provenance, which takes the place of the Location attribute.  Seedlots can now be listed or reported by Provenance.
  • Seedlot status of EXP (expired) added for when a seedlot balance is zero and all requests are completed. The system no longer determines active or expired status every time a query is made.
  • Latest Sowing Date maintenance – when a nursery makes a new entry in the Latest Sowing Date table, existing seedling requests for the same species / stock type / stock age will be updated with the new sowing date.
  • Seedlot Audit tables - when seedlot or vegetative lot registration, Genetic Worth, Area of Use (seed planning zones, elevation range, latitude/longitude range) data changes, the previous records are now stored in tables.  Click here for more information.

Screen layout changes

  • Seedling Request - Full code descriptions were added to the drop-down fields for Funding Source, Seed Planning Zone A, Seed Planning Zone B and Tenure.  Opening ID was added as an optional field.  The Subject to (FRPA or Code) field was added to enable tracking of seedling requests entered for FSP or FDP blocks.
  • Lot Search - Provenance filter added to the search criteria.
  • Seedlot Detail Screen - Different layout for Class A, B+ and B seedlots, with distinct Source Information and Area of Use sections.

Reports - new and improved

  • Seedlot Detail Report - new Area of Use History section.  Click here for more information.
  • Seedlot Listing Report Submission – The ‘Provenance’ filter is new.
  • Seedlot Extract - Seedlot Peak Value (PV), Provenance and Intended Use Seed Planning Zone columns added.
  • Tested Parent Tree Area of Use report – A new report that lists the ‘Areas of Use’ referred to in the Chief Forester’s Standards for Seed Use.
  • Seed Planning Units report - A new report that lists the SPUs for which Species Plans are developed by the Forest Genetics Council (www.for.gov.bc.ca/hti/speciesplan/)
  • Parent Tree Short Form report – A new report listing parent trees.
  • Parent Tree Detail report - A new report showing detailed data for each parent tree.

* Parent Tree - a genetically unique tree of a known source that is
a)  selected for specific traits, and
b)  bred or cloned for the purpose of producing seeds or vegetative material.