====== Jupiter Generic Database Format ======

The Jupiter Generic Database Format is based on the full [[:geoscene3d:project_content:dataformats: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 four simple tables containing borehole locations, layers, filters and waterlevel. The four 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 <font inherit/Courier New,Courier,monospace;;inherit;;inherit>CODE</font>  field when loading color symbols using the [[:geoscene3d:application:misc: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:\\
[[:geoscene3d:project_content:datasets:jupiter_wells_dataset|Wells Dataset]]