List:General Discussion« Previous MessageNext Message »
From:David Blomstrom Date:October 28 2005 7:24pm
Subject:Re: GROUP BY Destroys 2nd Function
View as plain text  
--- SGreen@stripped wrote:

> <<<<Everything snipped>>>>
> 
> David, is it at all intuitive to organize your
> geography into a tree-type 
> structure?  Here is an example:
> 
> Western Hemisphere (hemisphere)
>         C. America (continent)
>                 Guatemala (country)
>         N. America (continent)
>                 Canada (country)
>                         Manitoba (state/province)
>                                 Moose
>                                 Elk

I see what you're saying, but I'm not sure if it's
workable. I'd need a separate row for every state,
province and nation the moose is native to. Ditto for
each of hundreds of species of rodents and bats.

Instead, I'm linking species to ecoregions, then
linking the ecoregions to geographic regions - which
may just be another version of what you're suggesting.

In fact, I have all the animal species organized into
a tree structure, and I already have a separate tree
structure for nations, states, etc. Maybe I can
combine them somehow.

Thanks.


	
		
__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com
Thread
GROUP BY Destroys 2nd FunctionDavid Blomstrom28 Oct
  • Re: GROUP BY Destroys 2nd FunctionJigal van Hemert28 Oct
    • Re: GROUP BY Destroys 2nd FunctionDavid Blomstrom28 Oct
      • Re: GROUP BY Destroys 2nd FunctionSGreen28 Oct
        • Re: GROUP BY Destroys 2nd FunctionDavid Blomstrom28 Oct