Skip to Content.
Sympa Menu

pcplantdb - [pcplantdb] Vocabulary

pcplantdb@lists.ibiblio.org

Subject: pcplantdb

List archive

Chronological Thread  
  • 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\""}





Archive powered by MHonArc 2.6.24.

Top of Page