Upload af data til databasen

GERDA - GEofysisk Relationel DAtabase
 
Nedenstående demonsterer opbygningen af en LAS fil. Alle de elementer, der er vist her vil blive læst af Gerda, hvis de er der, men kun de med fed skrift markerede elementer er absolut nødvendige. Resten af oplysningerne kan i princippet indtastes ved indberetningen. I kolonnerne til højre er angivet hvilke PCGerda tabeller og felter, oplysningerne lægges ind i, og hvorvidt oplysningerne er krævet.
 
Mnemonic.Unit Data example   Data type PCGerda relation Req? Description
 
~VERSION INFORMATION
 
VERS.2.0   :   Float     LAS version no. It is required that it is version 2.0
WRAP.NO or YES   :   String     Wrap of lines in data section ~A. Allowed type is YES or NO
 
~WELL INFORMATION
 
STRT.M or S   :   Float LOGHEA.MINDEPTH/MAXDEPTH Y The first depth or time value in the ~A-section of the LAS-file. Depth has to be in m and time in s. (Minimum or maximum depth or time of all logs in the dataset).
STOP.M or S   :   Float LOGHEA.MINDEPTH/MAXDEPTH Y The last depth or time value in the ~A-section of the LAS-file. Depth has to be in m and time in s. (Minimum or maximum depth or time of all logs in the dataset).
STEP.M or S   :   Float LOGHEA.DATASTEP Y Sampling interval (depth or time increment) of the log values in the ~A section (LogData table). Depth has to be in m and time in s.
NULL. -999 :   Float LOGHEA.NULLVAL Y The null value in the LAS-file
COMP. dk.aaa / dk.niras :   String DATASET.CLIENT Y Identification of client. E.g., dk.geus.
WELL. B4 :   String LOGHEA.BSYNO N Alternative borehole name. E.g., borehole name used in the planing or locally in the well field.
DATE. 22.11.2004 :   Date DATASET.RECSTARTDA N Date recording started
DEPT.M 75.4 :     LOGHEA.DRILLERSDEPTH N Borehole depth given by the driller.
BS1.MM 450 :   Float LOGPROPERTY.KEY/VALUE N Bitsize diameter (in mm) of the first bit size used counted from the top of the borehole. The bit size value has to be a number (with a dot as decimal operator).
BSx.MM 450 :   Float LOGPROPERTY.KEY/VALUE N Bitsize diameter (in mm) of the x used bit size counted from the top of the borehole. The bit size value has to be a number (with a dot as decimal operator).
DESC. Frost, problemer med induktion :   String LOGHEA.NOTE N Notes general for all logs in the dataset, which can be important in the interpretation of the logs.
DF. MUD :   String LOGHEA.BHFLUID N Flag indicating the type of borehole fluid. Allowed flag are: Water, Mud and Unknown
MUD. Wyoming 600 kg, CMC P1200 soilquick 50 kg :   String LOGHEA.BHFLUIDADDED N List of type and amount of mud added to the boreholefluid.
CAS1. Iron/Stainless Steel :   String LOGPROPERTY.KEY/VALUE N Flag indicating the casing material of the first casing counted from the top of the well. Allowed flags are Other (A),Asbestos cement (Eternit) (E), PEH (H), Iron/Stainless Steel (J), Copper (K), PVC (P), Driven screen (R), Uncased (U), Teflon (T), Porcelain (S), PEH (C), Unspecified porous clay cup (N), Well lining, cement rings (BC), Well lining, rock (BK), Well lining, brick (BM), Well lining, unspecified (BU).
CASx. Iron/Stainless Steel :     LOGPROPERTY.KEY/VALUE N Flag indicating the casing material of casing x counted from the top of the well. Allowed flags are Other (A),Asbestos cement (Eternit) (E), PEH (H), Iron/Stainless Steel (J), Copper (K), PVC (P), Driven screen (R), Uncased (U), Teflon (T), Porcelain (S), PEH (C), Unspecified porous clay cup (N), Well lining, cement rings (BC), Well lining, rock (BK), Well lining, brick (BM), Well lining, unspecified (BU).
CAL1.MM 450 :   Float LOGPROPERTY.KEY/VALUE N Casing diameter (in mm) of the first casing counted from the top of the borehole. The casing diameter value has to be a number (with a dot as decimal operator).
CALx.MM 450 :   Float LOGPROPERTY.KEY/VALUE N Casing diameter (in mm) of casing x counted from the top of the borehole. The casing diameter value has to be a number (with a dot as decimal operator).
CAD1.M 4.5 :   Float LOGPROPERTY.KEY/VALUE N Depth (in m) to the bottom of the first casing counted from the top of the borehole and given from the reference point. The depth value has to be a number (with a dot as decimal operator).
CADx.M 4.5 :   Float LOGPROPERTY.KEY/VALUE N Depth (in m) to the bottom of casing x counted from the top of the borehole and given from the reference point. The depth value has to be a number (with a dot as decimal operator).
STRI. 0 :   Integer LOGHEA.STRINGNO/WELLCONDITION Y String no in a developed well or flag indicating the condition of the borehole. Values > 0 are string no, which should refer to an existing string registered in Jupiter, the value 0 indicates that the logging is done in an open hole, value -1 indicates that the logging is done a temporary casing, and the value -2 indicates that the state of the borehole is unknown.
GVS.M 2.34 :   Float LOGHEA.BHFLUIDDEPTH N Depth (in m) to groundwater table or borehole fluid at the logging period (without pumping).
UWI. 99,999 :   String LOGHEA.BOREHOLENO Y DGU borehole no by which the borehole is registered in the Jupiter-database.
 
~PARAMETER INFORMATION
 
INI. NNN :   String DATASET.RECPERSON N Name or initials of person responsible for the data recording.
COMP. dk. :   String DATASET.CONTRACTOR Y Identification of contractor. E.g. 'dk.geus'.
REF. Ground :   String LOGHEA.DEPTHREF Y Flag for depth reference point. Allowed flags are Ground (ground surface), TopCasing (top of casing), TopString (top of string) TopKellyBushing (top of "bundklemme" on the drilling rig), BoreholeFixPoint (Jupiter borehole fix point), Sea Level (depth = negative height measured realative to mean sea level), ReferencePoint and Other. The choice of ReferencePoint or Other should be accompagnied by a note in ~WELL INFORMATION.DESC
EREF.M 34.5 :   Float LOGHEA.REFPOELEVA ? Elevation (in m) of the depth reference point in ~PARAMETER INFORMATION.REF. Required if depth reference not equals ground.
EMET. Map :   String LOGHEA.REFPOSOURCE Y Flag that states the method used determining the elevation in ~PAMETER INFORMATION.EREF. Allowed flags are Other(A), Echosouncer(E), MapField(F), GPS(G), DigitalTerrainModel(H), MapOffice(K), LevelledElevation(N), DGPS(P).
ESYS.   :   String LOGHEA.HEIGHTSYS Y Flag indicating the height system used for the given elevations. The allowed flags are DVR90 for Dansk Vertikal Reference 1990 and DNN for Dansk Normal Nul.
GDEPT.M   :   Float LOGHEA.PROBEDEPTH N Depth (in m) of probe during acquisition in time mode.
 
~CURVE INFORMATION
 
 
DEPTH.M   : DEPTH   LOGCURVE.LOGNAME/DESCRIPTION N This section is required, and the succession of rows should closely match the succession of data columns in the ~A section. The information are coded as Field.Unit : Comment.
  • The logging companys log name is listed in "Field" and is used in the ~OTHER section to map information on the individual logging curves into terms that can be recognized by GERDA. The text in the this field is mapped into GERDA (LogCurve.LogName).
  • The "Unit" is written as used by the logging company. The "Unit" should express the same as the unit that is required by GERDA in the ~OTHER section (written as required by GERDA).
  • The comment should be at short informative description of the log type. The comment is mapped into LogCurve.Description in GERDA.
GAMM.CPS   : Naturlig Gamma   LOGCURVE.LOGNAME/DESCRIPTION N  
SP.MV   : Selvpotentiale   LOGCURVE.LOGNAME/DESCRIPTION N  
FLO1.CPS   : Flowlog 7 m/min String LOGCURVE.LOGNAME/DESCRIPTION N  
FLO2.CPS   : Flowlog 5 m/min String LOGCURVE.LOGNAME/DESCRIPTION N  
 
~OTHER
 
 
DEPT.MAP DEPTH :   String LOGCURVE.LOGTYPE Y This line is used mapping the log name of the log curve into the GERDA logtype (LogCurve.LogType). There should be a line for each log curve listed in the ~CURVE section. Valid GERDA Logtypes can be seen in the logtype list here.
GAMM.MAP GAMMA :   String LOGCURVE.LOGTYPE Y  
SP.MAP SP :   String LOGCURVE.LOGTYPE Y  
FLO1.MAP FLOW :   String LOGCURVE.LOGTYPE Y  
FLO2.MAP FLOW :   String LOGCURVE.LOGTYPE Y  
 
GAMM.INST dk.... :   String LOGCURVEINSTRUMENT.INSTRUMENT N This line is used mapping the instrument ident of the instrument used acquiring the log curve (LogCurve.Instrument). There should be a line for each log curve listed in the ~CURVE section. The instrument ident must be know by GERDA.
SP.INST dk.... :   String LOGCURVEINSTRUMENT.INSTRUMENT N  
FLO1.INST dk.... :   String LOGCURVEINSTRUMENT.INSTRUMENT N  
FLO2.INST dk.... :   String LOGCURVEINSTRUMENT.INSTRUMENT N  
 
GAMM.VELO 1.5 :   Float LOGCURVE.VELOCITY N This line is used mapping the logging velocity of the log curve into GERDA (LogCurve.Velocity). The logging velocity should be in m/min and written as a number with a dot as decimal operator.
SP.VELO 4 :   Float LOGCURVE.VELOCITY N  
FLO1.VELO 7 :   Float LOGCURVE.VELOCITY N  
FLO2.VELO 5 :   Float LOGCURVE.VELOCITY N  
 
FLO1.DISCH 20 :   Float LOGCURVE.DISCHARGE N This line is used mapping the discharge of a pump running during the acquisition of the log curve in to LogCurve.Discharge. The discharge should be in m3/hr and written as a number with a dot as decimal operator.
FLO2.DISCH 40 :   Float LOGCURVE.DISCHARGE N  
 
GAMM.FILT Non-spike 25 cm :   String LOGCURVE.NOTE N This line is used mapping notes about if and how the log is filtrated and if other processing have been carried out (LogCurve.Note).
 
GAMM.SINT 0.01 :   Float LOGCURVE.SAMPLEINTERVAL N This line is used mapping the sampling interval used at the logging operation into GERDA (LogCurve.SampleInterval). The sampling interval should be in m and written as a number with a dot as decimal operator.
SP.SINT 0.01 :   Float LOGCURVE.SAMPLEINTERVAL N  
FLO1.SINT 0.01 :   Float LOGCURVE.SAMPLEINTERVAL N  
FLO2.SINT 0.01 :   Float LOGCURVE.SAMPLEINTERVAL N  
 
GAMM.LDIR UP :   String LOGCURVE.DIRECTION N This line is used mapping the logging direction and mode of the log curve into GERDA (LogCurve.Direction). The field is related to a code list: Allowed flags are Down, Up and TimeMode.
SP.LDIR UP :   String LOGCURVE.DIRECTION N  
 
DEPT.UNIT m :   String LOGCURVE.UNIT Y This line is used mapping the unit of the log curve into a unit typed so that is can be recognized by GERDA (LogCurve.Unit). There should be a line for each log curve listed in the ~CURVE section. Valid units for GERDA logtypes can be seen in the Logtype list here (link til Logtype liste).
GAMM.UNIT cps :   String LOGCURVE.UNIT Y  
SP.UNIT mV :   String LOGCURVE.UNIT Y  
FLO1.UNIT rpm :   String LOGCURVE.UNIT Y  
FLO2.UNIT rpm :   String LOGCURVE.UNIT Y  
 
FLO1.PUDEP 234.5 :   Float LOGCURVE.PUMPDEPTH N This line is used mapping the depth of pump if pumping is carried out during the logging (LogCurve.PumpDepth). The depth should be in m and written as a number with a dot as decimal operator.
 
FLO1.SOU 212.3 :   Float LOGCURVE.BHFLUIDDEPTHPUMP N This line is used mapping the depth of the groundwater table or borehold fluid if pumping is carried out during the logging operation (LogCurve.BHFluidDepthPump). The depth should be in m and written as a number with a dot as decimal operator.
PRINI. NNN :   String DATASET.PROPERSON N Name or initials of person responsible for the data processing.
PRDA. 10.02.2005 :   Date DATASET.PROENDDA N Date processing of the raw data ended