Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| geoscene3d:project_content:dataformats:jupiter_generic_database_format [2020/02/12 20:00] – rebecca130301_gmail.com | geoscene3d:project_content:dataformats:jupiter_generic_database_format [2023/01/06 08:36] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Jupiter Generic Database Format ====== | ====== Jupiter Generic Database Format ====== | ||
| - | The Jupiter Generic Database Format is based on the full [[Jupiter Database Format|]]. All tables and fields not used by GeoScene3D in the full format has been removed to create a simple easy to use generic database format that supports all the features in GeoScene3D. The full Jupiter Database Format is mainly intended for Danish users. | + | The Jupiter Generic Database Format is based on the full [[: |
| An empty database with this format is located in the main GeoScene3D installation directory (Jupiter_Wells_Empty.mdb). | An empty database with this format is located in the main GeoScene3D installation directory (Jupiter_Wells_Empty.mdb). | ||
| - | The database consists of three simple tables containing borehole locations, layers | + | The database consists of four simple tables containing borehole locations, layers, filters |
| - | ** | + | **BOREHOLE ** \\ |
| - | BOREHOLE ** \\ | + | BOREHOLENO: Primary unique well ID [String]\\ |
| - | BOREHOLENO: Primary unique well ID [String] \\ | + | ELEVATION: Well elevation [Float]\\ |
| - | ELEVATION: Well elevation [Float] \\ | + | XUTM: Well easting [Float]\\ |
| - | XUTM: Well easting [Float] \\ | + | |
| YUTM: Well northing [Float] | YUTM: Well northing [Float] | ||
| - | ** | + | **LITHSAMP ** \\ |
| - | LITHSAMP ** \\ | + | BOREHOLENO: Primary unique well ID [String]\\ |
| - | BOREHOLENO: Primary unique well ID [String] \\ | + | SAMPLENO: Layer ID [Integer]\\ |
| - | SAMPLENO: Layer ID [Integer] \\ | + | TOP: Layer top depth [Float]\\ |
| - | TOP: Layer top depth [Float] \\ | + | BOTTOM: Layer bottom depth [Float]\\ |
| - | BOTTOM: Layer bottom depth [Float] \\ | + | ROCKSYMBOL: Layer lithology. This string must correspond to the <font inherit/ |
| - | ROCKSYMBOL: Layer lithology. This string must correspond to the | + | |
| - | <font inherit/ | + | |
| - | field when loading color symbols using the [[Symbol List Editor|]] | + | |
| - | [String] | + | |
| - | ** | + | **SCREEN ** \\ |
| - | SCREEN ** \\ | + | BOREHOLENO: Primary unique well ID [String]\\ |
| - | BOREHOLENO: Primary unique well ID [String] \\ | + | SCREENNO: Filter ID [Integer]\\ |
| - | SCREENNO: Filter ID [Integer] \\ | + | TOP: Filter top depth [Float]\\ |
| - | TOP: Filter top depth [Float] \\ | + | |
| BOTTOM: Filter bottom depth [Float] | BOTTOM: Filter bottom depth [Float] | ||
| - | ** | + | **WATLEVEL ** \\ |
| - | WATLEVEL ** \\ | + | BOREHOLENO: Primary unique well ID [String]\\ |
| - | BOREHOLENO: Primary unique well ID [String] \\ | + | INTAKENO: Intake ID [Integer]\\ |
| - | INTAKENO: Intake ID [Integer] \\ | + | TIMEOFMEAS: Time of measurements for waterlevel in well [Date and Time]\\ |
| - | TIMEOFMEAS: Time of measurements for waterlevel in well [Date and Time] \\ | + | |
| WATLEVMSL: Measured waterlevel meter above sealevel [Float] | WATLEVMSL: Measured waterlevel meter above sealevel [Float] | ||
| - | See also: \\ | + | See also:\\ |
| - | [[Wells Dataset|]] | + | [[: |