main query IF: SELECT * FROM main, coverage, maincoverage, subject, mainsubject
WHERE main.MainID=773
AND coverage.coverageID=maincoverage.coverageID
AND main.MainID=maincoverage.MainID
AND main.MainID=mainsubject.MainID
AND subject.SubjectID=mainsubject.SubjectID
ORDER BY Name, subject_name
Access: Publicly available resource
Description: The PLANTS Database maintained by the USDA provides standardized information about the vascular plants, mosses, liverworts, hornworts, and lichens of the United States and its territories. It includes names, plant symbols, checklists, distributional data, species abstracts, characteristics, images, plant links, references, crop information, and automated tools.
The USDA Plant Variety Protection Office maintains the Certificate Status Database , which provides legal intellectual property rights protection to developers of new varieties of plants which are sexually reproduced (by seed) or tuber-propagated.
Also try:
- UN International Union for the Protection of New Varieties of Plants (UPOV) - contains links to Plant Variety Protection offices.
- CalPhotos - a collection of over 90,000 images of plants, fungi, animals, fossils, people, and landscapes and habitats.
- Poisonous Plants Informational Database - includes plant images, pictures of affected animals and presentations concerning the botany, chemistry, toxicology, diagnosis and prevention of poisoning of animals by plants and other natural flora (fungi, etc.).
Coverage: Various Dates
Subject(s): Biology, Genetics & Life Sciences Publicly Available Resources
Related Databases
Encyclopedia of Plant and Crop Science
Garden, Landscape & Horticulture Index
Related Links
AGRICOLA APIRS Online Database Flora of North America Index to American Botanical Literature
Other Related Links: PlantFacts
Return to Top
|
|