RE: Getting Oriented: Political versus Ecological Geography

2004-05-30 Thread David Blomstrom
d has probably been organized by the GIS community, but that's another technology to learn about. > Osvaldo Sommer > > -Original Message- > From: David Blomstrom > [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 29, 2004 9:39 PM > To: [EMAIL PROTECTED] > Subject: RE

RE: Getting Oriented: Political versus Ecological Geography

2004-05-30 Thread Osvaldo Sommer
David Blomstrom [mailto:[EMAIL PROTECTED] Sent: Saturday, May 29, 2004 9:39 PM To: [EMAIL PROTECTED] Subject: RE: Getting Oriented: Political versus Ecological Geography Hm... I think you were an even bigger help than I anticipated! If I understand correctly, I need to fix the tables I

Re: Getting Oriented: Political versus Ecological Geography

2004-05-30 Thread David Blomstrom
--- Peter Brawley <[EMAIL PROTECTED]> wrote: > David, > > If one finds oneself thinking about creating large > numbers of columns for > particular features, the working model is likely not > general enough (eg why > not a child table that permits you to add any number > of features you please > f

RE: Getting Oriented: Political versus Ecological Geography

2004-05-29 Thread David Blomstrom
t; > > This way you can define the characteristics 1 time > and assign to a > country as many or as few as you need. > > You may want to use innob tables to create the > foreing key and to help > them inforce them. > > Hope this is usefull > > Osvaldo

RE: Getting Oriented: Political versus Ecological Geography

2004-05-29 Thread Osvaldo Sommer
the foreing key and to help them inforce them. Hope this is usefull Osvaldo Sommer -Original Message- From: David Blomstrom [mailto:[EMAIL PROTECTED] Sent: Saturday, May 29, 2004 5:57 PM To: [EMAIL PROTECTED] Subject: Re: Getting Oriented: Political versus Ecological Geography --- Peter

Re: Getting Oriented: Political versus Ecological Geography

2004-05-29 Thread David Blomstrom
--- Peter Brawley <[EMAIL PROTECTED]> wrote: > >In the states table, should I list Colorado's > regions > >in three cells... Great Plains | Rocky Mountains | > >Colorado Plateau, or group them in one cell, like > >this: > > >Colorado | state | grasslands, Rocky Mountains, > >Colorado Plateau | co

Re: Getting Oriented: Political versus Ecological Geography

2004-05-29 Thread Peter Brawley
ame table as continents & oceans, or how you would model relationships like adjacent-to, surrounds, entirely-enclosed-by, disjoint, whether you are using openGIS, &c. PB - Original Message - From: David Blomstrom To: [EMAIL PROTECTED] Sent: Friday, May 28, 2004 5:46 PM Subjec

Getting Oriented: Political versus Ecological Geography

2004-05-28 Thread David Blomstrom
I think this is pretty simple, but I'm not thinking very clearly at the moment, and I want to make sure I get it right. I want to create a database with information on the world's nations and smaller jurisdictions (e.g. states and provinces) AND on physiographic and bio/ecological regions. My prim