Import Dynamic Sensor Data (CSV)

Use the Import Dynamic Sensor Data (CSV) option (Geosoft.uxo.gxnet.dll(Geosoft.GX.UXO.UxaImportDynamicData;Run)*) from the AGC Expert User > Dynamic Data Prep and QC menu to import raw dynamic sensor data into a Geosoft database. 

Import (CSV) Dynamic Sensor Data dialog options

Geo/Grid ID

Specify the Geo/Grid ID, or select from existing values in the Target ID channel. The ID can be an alphanumeric value up to 32 characters in length.

Script Parameter:
UXANALYZE.DYN_GEO_ID

Input file(s)

Select the input file(s). Each input file is imported into two databases; sensor data will be saved into a new line in the sensor database and the acquisition parameters as a new record in the parameter database.

The GX supports importing data from CSV formats.

The database group number is extracted from file header.

  • The tool will automatically select the sensor name when a new input file is entered.
  • Script Parameter:UXANALYZE.INPUT_CSV_FILES

    Data type

    Select the data type. The data type will be included in the database name:

    • Survey: data from unknown or blind anomalies
    • Background: data from background
    • Sensor Function (Item): data from the sensor function check with the standard test item.
    • IVS Line (Item): data from the IVS test over the test items.
    • Test Pit: data for other testing purposes.
    • Miscellaneous: other data

    For more information on the data types, see the Data Types help topic.

    Script Parameter:UXANALYZE.DYN_DATA_TYPE

    Sensor/configuration

    Select the sensor used to collect the data. The default values are read from the sensor configuration table; refer to Application Notes below.

    Script Parameter:UXANALYZE.DYN_SENSORNAME

    Sensor ID

    Specify the Sensor ID, or select from existing values in the Sensor ID channel. The ID can be an alphanumeric value that will identify the sensor used to collect the data.

    Script Parameter: UXANALYZE.DYN_SENSOR_ID

    Height above ground

    Specify the height (in meters) of the EM sensors above the ground surface, which has a minimum value of 0 and the following default values:

    • TEM2x2x3: 0.20 m
    • MetalMapper: 0.16 m
    • MetalMapper2x2: 0.26 m

    Script Parameter:UXANALYZE.DYN_SENSORHEIGHT

    Line ID

    Select the line ID from the file header, or from the file name.

    If line ID is to be extracted from the file name, the name it should follow A_B.csv pattern, where A and B are alphanumeric and numeric characters, respectively.

    Script Parameter:UXANALYZE.LINEID_METHOD

    GPS coordinates

    Use the Edit button to select the GPS coordinate system. The System and Unit text boxes will be populated with the selected coordinate system.

    The default value is WGS 84. Unit: degrees.

    Script Parameters:UXANALYZE.DATUM_GPS, PROJECTION_GPS, LOCAL_TRANSFORM_GPS, UNIT_GPS

    Projected survey coordinates

    Use the Edit button to select the projected coordinate system for the survey. The System and Unit text boxes will be populated with the selected coordinate system.

    The default value is NAD83. Unit: metre.

  • The UTM zone will be automatically determined when a new input file is entered.
  • Script Parameters:UXANALYZE.DATUM_PROJECTED, PROJECTION_PROJECTED, LOCAL_TRANSFORM_PROJECTED, UNIT_PROJECTED

    Magnetic declination

    Specify the magnetic declination. The value of the magnetic declination will be added to the heading channel to make it a true heading and is saved in UXA_YAW_True channel.

    There is no default value unless IGRF has been calculated. IGRF will be automatically calculated using the location information from the first file imported.

    Script Parameter:UXANALYZE.DECLINATION

    Database prefix

    Specify the prefix for the names of the sensor and parameter databases. By default, your databases will be saved in your current project folder.

    Script Parameter:UXANALYZE.DYN_IMPORT_DBPREFIX

    Parameter group

    Specify the parameter group name, which can be a new group. This group contains all the acquisition parameters.
    The default parameter group is named, Line.

    Script Parameter:UXANALYZE.DYN_PARAMETERGROUP

    Application Notes

    The advanced EM sensors collect a massive amount of data that can be exported into a text (CSV) file. When imported into Oasis montaj, the data are read and saved into a pair of Geosoft databases. There are two databases, a survey database (_Data) that contains the raw sensor data, and a parameter database (_Parameter) which contains the header information.

    Additional databases are created when picking the anomalous target location (_Target) and when inversion and modelling are performed on the data (_Source); the latter is used to store the modelling and classification results.

    Each input file will be imported as separate groups in the sensor data database (_Data). The header parameters are imported into the parameter database (_Parameter).

    A range of files can be selected to be imported at once, however, only files of the same data type should be selected to be imported at once.

    Dates are assumed to be in the US short date standard of MM/DD/YYYY. The tool is designed to create projected coordinates from the GPS coordinates found in the input files. The GPS coordinates are detected by looking for columns that start with LAT (for latitude) and LON (for longitude). If found, the projected channels are named UXA_Y_Raw and UXA_X_Raw.

    Examples of Dynamic Sensor Data (CSV) Headers

    Lookup Tables

    The lookup table files contain various information about the sensors, such as the survey mode, which can be static or dynamic. You can easily modify the parameters for the existing sensors or add new sensors to the files. The files are located in the "C:\Program Files\Geosoft\Desktop Applications \etc" folder. The "SensorTableAdvanced.xml" lookup table file is used with your sensor dynamic data files.

  • If you want to customize the SensorTableAdvanced.xml file, you should manually copy the file to your "%USERPROFILE%\Documents\Geosoft\Desktop Applications \etc" folder (to not lose yours changes during an update).
  • *The GX tool will search in the "gx" folder. The GX.Net tools, however, are embedded in the Geosoft.uxo.gxnet.dll located in the bin folder. If running this GX interactively, bypassing the menu, first change the folder to point to the bin folder, then supply the GX.Net tool in the specified format.