pcplantdb@lists.ibiblio.org
Subject: pcplantdb
List archive
- From: Chad Knepp <pyg@galatea.org>
- To: pcplantdb@lists.ibiblio.org
- Subject: [pcplantdb] Vocabulary
- Date: Sun, 5 Dec 2004 19:17:22 -0600
Regarding categorizing all the different bits of data that are
searchable in PIW here is Eden.Vocabulary. The vocabulary is simply a
list of words that are meaningful in terms of searches. They include
things like 'tree', 'shrub', 'vine', 'shade', 'acid soil', etc. This
is a list of all the words Eden currently knows and sort of a
demonstration on how easy it is to add new words to the vocabulary.
My eventual goal is that the search box would understand and return
meaningful results to full English sentences. Vocabulary can/will
eventually include relationships, etc.
"""
Eden.Vocabulary
Two dictionaries with words keys matching sql values. For the
eden.culture and eden.plant_location tables.
"""
Culture = {
'1': "hardyness <=\"1\"",
'2': "hardyness <=\"2\"",
'3': "hardyness <=\"3\"",
'4': "hardyness <=\"4\"",
'5': "hardyness <=\"5\"",
'6': "hardyness <=\"6\"",
'7': "hardyness <=\"7\"",
'8': "hardyness <=\"8\"",
'9': "hardyness <=\"9\"",
'shrub': "habit like \"%shrub%\"",
'tree': "habit like \"%tree%\"",
'annual': "habit like \"%annual%\"",
'biennial': "habit like \"%biennial%\"",
'perennial': "habit like \"%perennial%\"",
'climb': "habit like \"%climber%\"",
'vine': "habit like \"%climber%\"",
'climber': "habit like \"%climber%\"",
'climbing': "habit like \"%climber%\"",
'bamboo': "habit like \"%bamboo%\"",
'fern': "habit like \"%fern%\"",
'bulb': "habit like \"%bulb%\"",
'corm': "habit like \"%corm%\"",
'deciduous': "deciduous_evergreen = \"D\"",
'evergreen': "deciduous_evergreen = \"E\"",
'fast': "growth_rate = \"F\"",
'rapid': "growth_rate = \"F\"",
'quick': "growth_rate = \"F\"",
'quickly': "growth_rate = \"F\"",
'slow': "growth_rate = \"S\"",
'nitrogen': "nitrogen_fixer = \"Y\"",
'fixes': "nitrogen_fixer = \"Y\"",
'fixer': "nitrogen_fixer = \"Y\"",
'scent': "scented = \"Y\"",
'smell': "scented = \"Y\"",
'odor': "scented = \"Y\"",
'wildlife': "supports_wildlife = \"Y\"",
'animal': "supports_wildlife = \"Y\"",
'animals': "supports_wildlife = \"Y\"",
'creature': "supports_wildlife = \"Y\"",
'critter': "supports_wildlife = \"Y\"",
'deer': "supports_wildlife = \"Y\"",
'rabbit': "supports_wildlife = \"Y\"",
'bird': "supports_wildlife = \"Y\"",
'birds': "supports_wildlife = \"Y\"",
'sand': "soil like \"%L%\"",
'sandy': "soil like \"%L%\"",
'loam': "soil like \"%M%\"",
'clay': "soil like \"%H%\"",
'heavy': "soil like \"%H%\"",
'saline': "saline = \"Y\"",
'salt': "saline = \"Y\"",
'salty': "saline = \"Y\"",
'sea': "saline = \"Y\"",
'ocean': "saline = \"Y\"",
'marine': "saline = \"Y\"",
'acid': "ph like \"%A%\"",
'sour': "ph like \"%A%\"",
'acidic': "ph like \"%A%\"",
'neutral': "ph like \"%N%\"",
'alkaline': "ph like \"%B%\"",
'base': "ph like \"%B%\"",
'basic': "ph like \"%B%\"",
'dry': "moisture like \"%D%\"",
'desert': "moisture like \"%D%\"",
'drought': "moisture like \"%D%\"",
'moist': "moisture like \"%W%\"",
'damp': "moisture like \"%W%\"",
'grey': "moisture like \"%W%\"",
'gray': "moisture like \"%W%\"",
'graywater': "moisture like \"%W%\"",
'greywater': "moisture like \"%W%\"",
'wet': "moisture like \"%W%\"",
'bog': "moisture like \"%W%\"",
'pond': "moisture like \"%Wa%\"",
'lake': "moisture like \"%Wa%\"",
'pool': "moisture like \"%Wa%\"",
'aquatic': "moisture like \"%Wa%\"",
'tank': "moisture like \"%Wa%\"",
'sun': "shade like \"%N%\"",
'bright': "shade like \"%N%\"",
'sunny': "shade like \"%N%\"",
'shade': "shade like \"%S%\" or shade like \"%S%\"",
'shaded': "shade like \"%S%\" or shade like \"%S%\"",
'shady': "shade like \"%S%\" or shade like \"%S%\"",
'dark': "shade like \"%F%\"",
'woods': "shade like \"%F%\"",
'wooded': "shade like \"%F%\"",
'wind': "wind = \"W\" or wind = \"M\"",
'windy': "wind = \"W\" or wind = \"M\"",
'breezy': "wind = \"W\" or wind = \"M\"",
'gusty': "wind = \"W\" or wind = \"M\"",
'pollution': "pollution = \"Y\"",
'toxic': "pollution = \"Y\"",
'toxin': "pollution = \"Y\"",
'frost': "frost_tender = \"N\"",
'hardy': "frost_tender = \"N\""}
Locations = {
'wood': "woodland_garden=\"Y\" or deep_shade=\"Y\"",
'woods': "woodland_garden=\"Y\" or deep_shade=\"Y\"",
'woodland': "woodland_garden=\"Y\" or deep_shade=\"Y\"",
'wooded': "woodland_garden=\"Y\" or deep_shade=\"Y\"",
'dark': "woodland_garden=\"Y\" or deep_shade=\"Y\"",
'shade': "woodland_garden=\"Y\" or deep_shade=\"Y\" or
dappled_shade=\"Y\" or shady_edge=\"Y\"",
'shaded': "woodland_garden=\"Y\" or deep_shade=\"Y\" or
dappled_shade=\"Y\" or shady_edge=\"Y\"",
'shady': "woodland_garden=\"Y\" or deep_shade=\"Y\" or
dappled_shade=\"Y\" or shady_edge=\"Y\"",
'canopy': "canopy=\"Y\"",
'tall': "canopy=\"Y\"",
'high': "canopy=\"Y\"",
'secondary': "secondary=\"Y\"",
'sun': "sunny_edge=\"Y\"",
'bright': "sunny_edge=\"Y\"",
'sunny': "sunny_edge=\"Y\"",
'garden': "cultivated_beds=\"Y\"",
'cultivated': "cultivated_beds=\"Y\"",
'farm': "cultivated_beds=\"Y\"",
'farmed': "cultivated_beds=\"Y\"",
'bed': "cultivated_beds=\"Y\"",
'ground': "ground_cover=\"Y\"",
'cover': "ground_cover=\"Y\"",
'lawn': "ground_cover=\"Y\"",
'low': "ground_cover=\"Y\"",
'meadow': "meadow=\"Y\"",
'prairie': "meadow=\"Y\"",
'field': "meadow=\"Y\"",
'hedge': "hedge=\"Y\" or hedgerow=\"Y\"",
'pond': "pond=\"Y\"",
'lake': "pond=\"Y\"",
'aquatic': "pond=\"Y\"",
'water': "pond=\"Y\"",
'bog': "bog_garden=\"Y\"",
'wet': "bog_garden=\"Y\"",
'gray': "bog_garden=\"Y\"",
'graywater': "bog_garden=\"Y\"",
'wall': "walls=\"Y\"",
'trellis': "walls=\"Y\"",
'espalier': "walls=\"Y\""}
-
[pcplantdb] Vocabulary,
Chad Knepp, 12/05/2004
- Re: [pcplantdb] Vocabulary, John Schinnerer, 12/06/2004
- Re: [pcplantdb] Vocabulary, Richard Morris, 12/07/2004
Archive powered by MHonArc 2.6.24.