Data Types and Database Formats - Import and Display in Oasis montaj
Data types and database formats are different and you should be aware of the differences when using the system. Data types refer to the actual numerical (ASCII or binary) representation of your import or export data. Database formats refer to the way in which you want to display your data in a Spreadsheet window. The sections below describe the basic formats for each.
Import and Export Data Types
Oasis montaj provides numerous data types for importing, working with and exporting data. The available data types you can use are:
Data Type |
Meaning |
Byte |
Signed 8-bit integer (-126 to +127, -127 is dummy). |
Ushort |
Unsigned 16-bit integer (0 to +65534, 65535 is dummy). |
Short |
Signed 16-bit integer (-32766 to +32767, -32767 is dummy). |
Long |
Signed 32-bit integer (-2147483646 to +2147483647, -2147483647 is dummy). |
Float |
32-bit floating point number (-1.0E+32 is dummy). |
Double |
64-bit floating point number (-1.0D+32 is dummy). |
String |
Null terminated string. |
Database Formats
Oasis montaj provides different formats for importing data into the database. After they are imported into the database, you can alter the way in which they appear on the screen by editing the Channel format.
When importing data, your XYZ data must be in one of the following import formats:
Import Format |
Meaning |
Normal |
Decimal number (i.e. 4 or -0.00123). |
Exponent |
Exponent number (i.e. 4.0E+00 or -1.23E-3). |
Time |
Time in HH:MM:SS.SS format. |
Time |
Time in HH:MMSSSS format. |
Time |
Time in HHMMSSSS format. |
Date |
Date in YYYY/MM/DD format. |
Date |
Date in DD/MM/YYYY format. |
Date |
Date in MM/DD/YYYY format. |
Date/Time |
ISO 8601. |
Geo |
Geographic map coordinate in DEG.MM.SS.SS format. |
Geo |
Geographic map coordinate in DEG:MM:SS.SS format. |
Geo |
Geographic map coordinate in DEG.MMSSSS format. |
Geo |
Geographic map coordinate in DEGMMmmmm format. |
Geo |
Geographic map coordinate in DEGMM.mmmm format. |
Geo |
Geographic map coordinate in DEG.MM.mmmm format. |
Oasis montaj Display Types
Oasis montaj provides a variety of formats for displaying data in the database window. These are a subset of the import formats. Note that the display format only effects how the data is displayed — it does not change the actual format in which the data is stored.
The available formats you can use are:
Display Format |
Meaning |
Date |
Date in YYYY/MM/DD format. |
Exponent |
Decimal number with exponent and sign (i.e. 4.0E+00 or -1.23E-3). |
Geo |
Geographic map coordinate in DEG.MM.SS.S format. |
Normal |
Decimal number (i.e. 4 or -0.00123). |
Time |
Time in HH:MM:SS.SS format |
Internally, time data is stored as decimal hours, date data is stored as decimal years, and geographic data is stored as decimal degrees.
See Also:
Got a question? Visit the Seequent forums or Seequent support
© 2024 Seequent, The Bentley Subsurface Company
Privacy | Terms of Use