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.