Re: [GENERAL] Best way to represent values.

2005-11-23 Thread Dennis Veatch
On Wednesday 23 November 2005 17:15, Brent Wood wrote: > I suggest you look at PostGIS to store 2D & 3D geometric (spatial) data, > it may solve some of your problems > > You can store a vertical line as a well, and segments of that line which > represent the layers you are describing. > > Bren

Re: [GENERAL] Best way to represent values.

2005-11-23 Thread Brent Wood
I suggest you look at PostGIS to store 2D & 3D geometric (spatial) data, it may solve some of your problems You can store a vertical line as a well, and segments of that line which represent the layers you are describing. Brent Wood On Tue, 22 Nov 2005, Dennis Veatch wrote: > On Tuesday

Re: [GENERAL] Best way to represent values.

2005-11-22 Thread Dennis Veatch
On Tuesday 22 November 2005 11:40, Lincoln Yeoh wrote: > At 01:19 PM 11/21/2005 -0500, Dennis Veatch wrote: > >I had thought just adding some fields called topsoil_start/topsoil_end, > >gravel_start/gravel_end, etc. But them I'm left with how to take those > > values and give to total depth for eac

Re: [GENERAL] Best way to represent values.

2005-11-22 Thread Lincoln Yeoh
At 01:19 PM 11/21/2005 -0500, Dennis Veatch wrote: I had thought just adding some fields called topsoil_start/topsoil_end, gravel_start/gravel_end, etc. But them I'm left with how to take those values and give to total depth for each layer and total depth of the well. But I'm not sure that is t

Re: [GENERAL] Best way to represent values.

2005-11-22 Thread Adrian Klaver
The problem is that each well can have a different number of and types of layers. Trying to pre-plan all the combinations could be a big headache. My first thought is the following layout- well_number layer_number bottom_depth layer_type 1 1 10

Re: [GENERAL] Best way to represent values.

2005-11-21 Thread Dennis Veatch
On Monday 21 November 2005 20:04, Michael Glaesemann wrote: > On Nov 22, 2005, at 3:19 , Dennis Veatch wrote: > > I had thought just adding some fields called topsoil_start/ > > topsoil_end, > > gravel_start/gravel_end, etc. But them I'm left with how to take > > those values > > and give to total

Re: [GENERAL] Best way to represent values.

2005-11-21 Thread Michael Glaesemann
On Nov 22, 2005, at 3:19 , Dennis Veatch wrote: I had thought just adding some fields called topsoil_start/ topsoil_end, gravel_start/gravel_end, etc. But them I'm left with how to take those values and give to total depth for each layer and total depth of the well. But I'm not sure that is