Contents Up Previous Next

Affine File Format


Affine Table General Information:

The AFFINE TABLE contains the depth offset values which are used to build a composite depth section using multiple-hole core data.

The AFFINE TABLE depth offsets are determined using the tie/correlation/depth-shift features of the Splice COMPOSITE tool under the PROCESS menu item. The depth offset values are determined when cores are depth-shifted to match core data from adjacent holes.

The AFFINE TABLE should be saved frequently as the compositing progresses. The file is written as simple ASCII text - these data can be downloaded and pasted directly into the Initial Reports volumes.

The Affine table format is as follows:

leg, sub_leg, site, hole, core, coretype, section, ODP depth, meters below seafloor (mbsf), depth offset (x.xx m), Y/N (Y=core has been correlated and depth-shifted), meters composite depth (x.xx mcd).

Some items may be missing. In the XML version that is not an issue. In the text version, we must account for missing items in this order:
OrderNameDescription
If there are 10 or fewer columns SubLeg The name of the SubLeg used. If there are only 10 columns, we assume the sub-leg is missing.
If there are 9 or fewer columns ODP Depth If there are 9 or fewer columns, we assume the ODP depth is missing. It can be inferred from the core number.
If there are 8 or fewer columns Composite Depth If there are 8 or fewer columns, we assume the Composite Depth if missing. It can be inferred ODP depth and the Depth Offset.

Note that we always need the core number and the depth offset.

Here is the same affine table in several formats. Note that in this case, the sub-leg field is missing. NCLIP shows the HTML version, and can both import and export the XML and Text versions.


Text Version


154		926	A	10	H	4	87.27	0.90	0	88.17
154		926	A	16	H	6	148.12	1.18	0	150.19
154		926	B	1	H	1	7.89	1.53	0	9.42
154		926	B	2	H	6	18.94	1.70	0	22.17
154		926	B	3	H	4	28.52	2.33	0	34.07
154		926	B	7	H	3	65.47	1.20	0	72.22
154		926	B	11	H	2	103.17	0.70	0	110.62
154		926	B	15	H	5	148.84	3.15	0	159.44
154		926	C	4	H	1	31.04	0.15	0	31.19
154		926	C	9	H	4	83.82	1.38	0	85.34

HTML Version

Here is an html version of the affine table, as seen in the preview window:
LegSub-LegSiteHole CoreCore TypeSection ODP DepthDepth OffsetmbComposite Depth
154926A 10H4 87.270.90088.17
154926A 16H6 148.121.180150.19
LegSub-LegSiteHole CoreCore TypeSection ODP DepthDepth OffsetmbComposite Depth
154926B 1H1 7.891.5309.42
154926B 2H6 18.941.70022.17
154926B 3H4 28.522.33034.07
154926B 7H3 65.471.20072.22
154926B 11H2 103.170.700110.62
154926B 15H5 148.843.150159.44
LegSub-LegSiteHole CoreCore TypeSection ODP DepthDepth OffsetmbComposite Depth
154926C 4H1 31.040.15031.19
154926C 9H4 83.821.38085.34
_____


XML Version


<AffineTable>
  <NclAffine>
    <AffLine>
      <leg>154</leg>
      <subLeg></subLeg>
      <site>926</site>
      <hole>A</hole>
      <core>10</core>
      <coreType>H</coreType>
      <section>4</section>
      <odpDepth>87.267700</odpDepth>
      <depthOffset>0.900028</depthOffset>
      <correaltion>0</correaltion>
      <compositeDepth>88.167725</compositeDepth>
    </AffLine>
    <AffLine>
      <leg>154</leg>
      <subLeg></subLeg>
      <site>926</site>
      <hole>A</hole>
      <core>16</core>
      <coreType>H</coreType>
      <section>6</section>
      <odpDepth>148.119583</odpDepth>
      <depthOffset>1.175036</depthOffset>
      <correaltion>0</correaltion>
      <compositeDepth>150.194641</compositeDepth>
    </AffLine>
  </NclAffine>
  <NclAffine>
    <AffLine>
      <leg>154</leg>
      <subLeg></subLeg>
      <site>926</site>
      <hole>B</hole>
      <core>1</core>
      <coreType>H</coreType>
      <section>1</section>
      <odpDepth>7.890242</odpDepth>
      <depthOffset>1.525047</depthOffset>
      <correaltion>0</correaltion>
      <compositeDepth>9.415289</compositeDepth>
    </AffLine>
    <AffLine>
      <leg>154</leg>
      <subLeg></subLeg>
      <site>926</site>
      <hole>B</hole>
      <core>2</core>
      <coreType>H</coreType>
      <section>6</section>
      <odpDepth>18.940584</odpDepth>
      <depthOffset>1.700053</depthOffset>
      <correaltion>0</correaltion>
      <compositeDepth>22.165684</compositeDepth>
    </AffLine>
    <AffLine>
      <leg>154</leg>
      <subLeg></subLeg>
      <site>926</site>
      <hole>B</hole>
      <core>3</core>
      <coreType>H</coreType>
      <section>4</section>
      <odpDepth>28.515881</odpDepth>
      <depthOffset>2.325072</depthOffset>
      <correaltion>0</correaltion>
      <compositeDepth>34.066051</compositeDepth>
    </AffLine>
    <AffLine>
      <leg>154</leg>
      <subLeg></subLeg>
      <site>926</site>
      <hole>B</hole>
      <core>7</core>
      <coreType>H</coreType>
      <section>3</section>
      <odpDepth>65.467026</odpDepth>
      <depthOffset>1.200037</depthOffset>
      <correaltion>0</correaltion>
      <compositeDepth>72.217232</compositeDepth>
    </AffLine>
    <AffLine>
      <leg>154</leg>
      <subLeg></subLeg>
      <site>926</site>
      <hole>B</hole>
      <core>11</core>
      <coreType>H</coreType>
      <section>2</section>
      <odpDepth>103.168198</odpDepth>
      <depthOffset>0.700022</depthOffset>
      <correaltion>0</correaltion>
      <compositeDepth>110.618431</compositeDepth>
    </AffLine>
    <AffLine>
      <leg>154</leg>
      <subLeg></subLeg>
      <site>926</site>
      <hole>B</hole>
      <core>15</core>
      <coreType>H</coreType>
      <section>5</section>
      <odpDepth>148.844620</odpDepth>
      <depthOffset>3.150098</depthOffset>
      <correaltion>0</correaltion>
      <compositeDepth>159.444946</compositeDepth>
    </AffLine>
  </NclAffine>
  <NclAffine>
    <AffLine>
      <leg>154</leg>
      <subLeg></subLeg>
      <site>926</site>
      <hole>C</hole>
      <core>4</core>
      <coreType>H</coreType>
      <section>1</section>
      <odpDepth>31.040960</odpDepth>
      <depthOffset>0.150005</depthOffset>
      <correaltion>0</correaltion>
      <compositeDepth>31.190966</compositeDepth>
    </AffLine>
    <AffLine>
      <leg>154</leg>
      <subLeg></subLeg>
      <site>926</site>
      <hole>C</hole>
      <core>9</core>
      <coreType>H</coreType>
      <section>4</section>
      <odpDepth>83.817596</odpDepth>
      <depthOffset>1.375043</depthOffset>
      <correaltion>0</correaltion>
      <compositeDepth>85.342644</compositeDepth>
    </AffLine>
  </NclAffine>
</AffineTable>

updated 4 July, 2006

Send comments to the

author