Preparing The Database

Access to either the Intrepid or Oasis Montaj processing systems is required to create databases, import data, and set up the required database fields for GammaSpec. For airborne processing, GammaSpec requires that the following database "fields" (Oasis Montaj "channels") are present in the database.

Table: Required Database Fields

Alias

Alias Control File 

Keyword

Data Type

 (typical)

Description

Survey1

surveyName

int

Survey number

Flight1

flightName

int

Flight number

Line1

lineName

int

Line number. Must be unique in the database

Fiducial

fidName

int

Fiducial number

Line Type1

lineTypeName

int

Line type – 2 for lines, 4 for ties

Easting

eastingName

double

X coordinate (metres or degrees)

Northing

northingName

double

Y coordinate (metres or degrees)

Date1

dateName

int

Date code. Integer value increasing chronologically – eg. yymmdd

Time1

timeName

int

Time code. Integer value increasing chronologically – eg. hhmmss

Spectra Down

spectraDownName

int

Spectra – main detector (counts per sample interval). 256-band field

Spectra Up2

spectraUpName

int

Spectra – upward-looking detector (counts per sample interval) . 256-band field

Cosmic

cosmicName

float

Cosmic window counts (counts per sample interval)

Altimeter

altimeterName

float

Radar or laser altimeter (metres)

Temperature

temperatureName

float

Temperature (degrees C)

Pressure

pressureName

float

Pressure (millibars)

Livetime

livetimeName

float

Livetime (seconds)

Encal Group1

encalGroupName

int

“Group-by” field for energy calibration (default = Line)

Nasvd Group1

nasvdGroupName

int

“Group-by” field for NASVD (default = Flight)  


1  These are treated as Intrepid “group-by” fields – i.e. only one sample is required for each line. If they are present in the database as “indexed” fields (one sample present for each observation point), then only the first sample in each line is used.

2  Optional. Required only if you are using the upward-looking detector method for radon estimation. In this case, either the raw upward-looking spectra, or the raw upward-looking U window data must be present.

Null Values

    • The only fields that may have null values are the Eastings and Northings fields.
    • The Insert Nulls tool (Utilities|Insert Nulls) can be used to interpolate nulls in ancillary data fields (single-band fields only).
    • The Spectra Down and Spectra Up fields may not have null values.

Database Restrictions

There are restrictions on the use of GammaSpec with Intrepid and Oasis Montaj databases as follows:

Intrepid Database

No license is required to run GammaSpec on Intrepid databases. However, you obviously need a license to set up your database. The restrictions on Intrepid databases are as follows:

      • Only the following data types are supported – short, int, float and double. 
      • There must be no duplicate line numbers. Each line number can refer to only one line.
      • The Line Number field must be named one of “LINE”, “line”, “Line”, “linenumber”, or “LineNumber”.
      • The Flight Number field must be named one of “FLIGHT, “Flight” or “flight”.
      • The Fiducial Number field must be named one of “FID”, “fid”, “FIDUCIAL”, “fiducial” or “Fiducial”.

Oasis Montaj Database

No license is required to run GammaSpec on Oasis Montaj databases. However, you obviously need a Oasis Montaj license to set up your database. The restrictions on Oasis Montaj databases are as follows:

      • Only the following data types are supported – short, int, float and double. 
      • There must be no duplicate line numbers. Each line number can refer to only one line. 
      • The Line Number, Flight Number and Fiducial fields must exist as channels in the Oasis Montaj database. Unlike Intrepid, the user can choose names for these channels. The channels can be created using the Database Tools|Channel Tools|Make Line Channel and |Make Fid Channel menu options in Oasis Montaj.
      • The multi-band field (channel) used for storing NASVD eigenvector amplitudes must already exist in the database (you need to create a vector channel beforehand and populate it with zeros using the Channel Math tool). Also, if you need to use the Sum Spectra to 256 Channels tool, or the Save Nasvd-Smoothed Spectra tool, then you need to create the 256-band output vector channels (and populate them with zeros) in Oasis Montaj before running the tool. These restrictions do not apply if you are running GammaSpec on a machine with an Oasis Montaj license.
      • The maximum line length allowed is 2,000 samples. This restriction does not apply if you are running GammaSpec on a machine with an Oasis Montaj license.