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.

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 and filters. The three tables are described below.

BOREHOLE
BOREHOLENO: Primary unique well ID [String]
ELEVATION: Well elevation [Float]
XUTM: Well easting [Float]
YUTM: Well northing [Float]

LITHSAMP
BOREHOLENO: Primary unique well ID [String]
SAMPLENO: Layer ID [Integer]
TOP: Layer top depth [Float]
BOTTOM: Layer bottom depth [Float]
ROCKSYMBOL: Layer lithology. This string must correspond to the CODE field when loading color symbols using the Symbol List Editor [String]

SCREEN
BOREHOLENO: Primary unique well ID [String]
SCREENNO: Filter ID [Integer]
TOP: Filter top depth [Float]
BOTTOM: Filter bottom depth [Float]

WATLEVEL
BOREHOLENO: Primary unique well ID [String]
INTAKENO: Intake ID [Integer]
TIMEOFMEAS: Time of measurements for waterlevel in well [Date and Time]
WATLEVMSL: Measured waterlevel meter above sealevel [Float]

See also:
Wells Dataset