{
"cells": [
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [],
"source": [
"import os\n",
"import sys\n",
"from functools import singledispatch\n",
"import warnings\n",
"\n",
"import pandas as pd\n",
"import numpy as np\n",
"\n",
"from plio.examples import get_path\n",
"from plio.io.io_bae import read_gpf"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {},
"outputs": [],
"source": [
"# Reads a .atf file and outputs all of the \n",
"# .ipf, .gpf, .sup, .prj, and path to locate the \n",
"# .apf file (should be the same as all others) \n",
"def read_atf(atf_file):\n",
" with open(atf_file) as f:\n",
"\n",
" files = []\n",
" ipf = []\n",
" sup = []\n",
" files_dict = []\n",
" \n",
" # Grabs every PRJ, GPF, SUP, and IPF image from the ATF file\n",
" for line in f:\n",
" if line[-4:-1] == 'prj' or line[-4:-1] == 'gpf' or line[-4:-1] == 'sup' or line[-4:-1] == 'ipf' or line[-4:-1] == 'atf':\n",
" files.append(line)\n",
" \n",
" files = np.array(files)\n",
" \n",
" # Creates appropriate arrays for certain files in the right format\n",
" for file in files:\n",
" file = file.strip()\n",
" file = file.split(' ')\n",
"\n",
" # Grabs all the IPF files\n",
" if file[1].endswith('.ipf'):\n",
" ipf.append(file[1])\n",
"\n",
" # Grabs all the SUP files\n",
" if file[1].endswith('.sup'):\n",
" sup.append(file[1])\n",
"\n",
" files_dict.append(file)\n",
"\n",
" # Creates a dict out of file lists for GPF, PRJ, IPF, and ATF\n",
" files_dict = (dict(files_dict))\n",
" \n",
" # Sets the value of IMAGE_IPF to all IPF images\n",
" files_dict['IMAGE_IPF'] = ipf\n",
" \n",
" # Sets the value of IMAGE_SUP to all SUP images\n",
" files_dict['IMAGE_SUP'] = sup\n",
" \n",
" # Sets the value of PATH to the path of the ATF file\n",
" files_dict['PATH'] = os.path.dirname(os.path.abspath(atf_file))\n",
" \n",
" return files_dict\n",
" \n",
"@singledispatch\n",
"def read_ipf(arg):\n",
" return str(arg)\n",
"\n",
"@read_ipf.register(str)\n",
"def read_ipf_str(input_data):\n",
" \"\"\"\n",
" Read a socet ipf file into a pandas data frame\n",
"\n",
" Parameters\n",
" ----------\n",
" input_data : str\n",
" path to the an input data file\n",
"\n",
" Returns\n",
" -------\n",
" df : pd.DataFrame\n",
" containing the ipf data with appropriate column names and indices\n",
" \"\"\"\n",
"\n",
" # Check that the number of rows is matching the expected number\n",
" with open(input_data, 'r') as f:\n",
" for i, l in enumerate(f):\n",
" if i == 1:\n",
" cnt = int(l)\n",
" elif i == 2:\n",
" col = l\n",
" break\n",
" \n",
" columns = np.genfromtxt(input_data, skip_header=2, dtype='unicode',\n",
" max_rows = 1, delimiter = ',')\n",
"\n",
" # TODO: Add unicode conversion\n",
" d = [line.split() for line in open(input_data, 'r')]\n",
" d = np.hstack(np.array(d[3:]))\n",
" \n",
" d = d.reshape(-1, 12)\n",
" \n",
" df = pd.DataFrame(d, columns=columns)\n",
" file = os.path.split(os.path.splitext(input_data)[0])[1]\n",
" df['ipf_file'] = pd.Series(np.full((len(df['pt_id'])), file), index = df.index)\n",
"\n",
" assert int(cnt) == len(df), 'Dataframe length {} does not match point length {}.'.format(int(cnt), len(df))\n",
" \n",
" # Soft conversion of numeric types to numerics, allows str in first col for point_id\n",
" df = df.apply(pd.to_numeric, errors='ignore')\n",
"\n",
" return df\n",
"\n",
"@read_ipf.register(list)\n",
"def read_ipf_list(input_data_list):\n",
" \"\"\"\n",
" Read a socet ipf file into a pandas data frame\n",
"\n",
" Parameters\n",
" ----------\n",
" input_data_list : list\n",
" list of paths to the a set of input data files\n",
"\n",
" Returns\n",
" -------\n",
" df : pd.DataFrame\n",
" containing the ipf data with appropriate column names and indices\n",
" \"\"\"\n",
" frames = []\n",
"\n",
" for input_file in input_data_list:\n",
" frames.append(read_ipf(input_file))\n",
"\n",
" df = pd.concat(frames)\n",
"\n",
" return df"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/Users/adampaquette/anaconda/envs/pysat/lib/python3.6/site-packages/ipykernel_launcher.py:12: UserWarning: The following points found in ipf files missing from gpf file: \n",
"\n",
"['P03_002226_1895_XI_09N203W_15', 'P03_002226_1895_XI_09N203W_16', 'P03_002226_1895_XI_09N203W_17', 'P03_002226_1895_XI_09N203W_18', 'P03_002226_1895_XI_09N203W_19', 'P03_002226_1895_XI_09N203W_20', 'P03_002226_1895_XI_09N203W_21', 'P03_002226_1895_XI_09N203W_22', 'P03_002226_1895_XI_09N203W_24', 'P03_002226_1895_XI_09N203W_26', 'P03_002226_1895_XI_09N203W_30', 'P03_002226_1895_XI_09N203W_31', 'P03_002226_1895_XI_09N203W_32', 'P03_002226_1895_XI_09N203W_34', 'P03_002226_1895_XI_09N203W_36', 'P03_002226_1895_XI_09N203W_37', 'P03_002226_1895_XI_09N203W_44', 'P03_002226_1895_XI_09N203W_48', 'P03_002226_1895_XI_09N203W_49', 'P03_002226_1895_XI_09N203W_56', 'P03_002226_1895_XI_09N203W_57', 'P03_002226_1895_XI_09N203W_61', 'P03_002226_1895_XI_09N203W_62', 'P03_002226_1895_XI_09N203W_63', 'P03_002226_1895_XI_09N203W_65', 'P19_008344_1894_XN_09N203W_4', 'P20_008845_1894_XN_09N203W_15']. \n",
"\n",
"Continuing, but these points will be missing from the control network\n",
" if sys.path[0] == '':\n"
]
},
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>val</th>\n",
" <th>fid_val</th>\n",
" <th>no_obs</th>\n",
" <th>l.</th>\n",
" <th>s.</th>\n",
" <th>sig_l</th>\n",
" <th>sig_s</th>\n",
" <th>res_l</th>\n",
" <th>res_s</th>\n",
" <th>fid_x</th>\n",
" <th>...</th>\n",
" <th>known</th>\n",
" <th>lat_Y_North</th>\n",
" <th>long_X_East</th>\n",
" <th>ht</th>\n",
" <th>sig0</th>\n",
" <th>sig1</th>\n",
" <th>sig2</th>\n",
" <th>res0</th>\n",
" <th>res1</th>\n",
" <th>res2</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>10_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>-2919.380615</td>\n",
" <td>1052.729004</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.059914</td>\n",
" <td>0.930311</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.159378</td>\n",
" <td>2.724649</td>\n",
" <td>-2523.828227</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>25.000000</td>\n",
" <td>18.301328</td>\n",
" <td>44.206259</td>\n",
" <td>416.201741</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>-4044.697510</td>\n",
" <td>1008.950928</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.063678</td>\n",
" <td>0.661294</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.159378</td>\n",
" <td>2.724649</td>\n",
" <td>-2523.828227</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>25.000000</td>\n",
" <td>18.301328</td>\n",
" <td>44.206259</td>\n",
" <td>416.201741</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1700.584473</td>\n",
" <td>-2390.001709</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>-0.063695</td>\n",
" <td>-1.055619</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.159378</td>\n",
" <td>2.724649</td>\n",
" <td>-2523.828227</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>25.000000</td>\n",
" <td>18.301328</td>\n",
" <td>44.206259</td>\n",
" <td>416.201741</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2006.141113</td>\n",
" <td>-2234.915283</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.318779</td>\n",
" <td>-0.585138</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.159378</td>\n",
" <td>2.724649</td>\n",
" <td>-2523.828227</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>25.000000</td>\n",
" <td>18.301328</td>\n",
" <td>44.206259</td>\n",
" <td>416.201741</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>370.151917</td>\n",
" <td>2340.653076</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>-0.239226</td>\n",
" <td>-1.113693</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.164905</td>\n",
" <td>2.721815</td>\n",
" <td>-2445.237027</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>30.000000</td>\n",
" <td>-22.046575</td>\n",
" <td>103.403228</td>\n",
" <td>173.210013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>-761.216064</td>\n",
" <td>2303.787109</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>-0.247307</td>\n",
" <td>-0.587299</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.164905</td>\n",
" <td>2.721815</td>\n",
" <td>-2445.237027</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>30.000000</td>\n",
" <td>-22.046575</td>\n",
" <td>103.403228</td>\n",
" <td>173.210013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>4985.437988</td>\n",
" <td>-1070.364990</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.239207</td>\n",
" <td>1.080801</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.164905</td>\n",
" <td>2.721815</td>\n",
" <td>-2445.237027</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>30.000000</td>\n",
" <td>-22.046575</td>\n",
" <td>103.403228</td>\n",
" <td>173.210013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>5293.700195</td>\n",
" <td>-993.390625</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.672877</td>\n",
" <td>0.626316</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.164905</td>\n",
" <td>2.721815</td>\n",
" <td>-2445.237027</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>30.000000</td>\n",
" <td>-22.046575</td>\n",
" <td>103.403228</td>\n",
" <td>173.210013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>236.395218</td>\n",
" <td>984.833252</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.073683</td>\n",
" <td>-0.237114</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.164949</td>\n",
" <td>2.724076</td>\n",
" <td>-2606.935163</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>100.000000</td>\n",
" <td>-7.549561</td>\n",
" <td>93.170584</td>\n",
" <td>180.058858</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>-889.364441</td>\n",
" <td>966.533997</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>-0.251753</td>\n",
" <td>0.008170</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.164949</td>\n",
" <td>2.724076</td>\n",
" <td>-2606.935163</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>100.000000</td>\n",
" <td>-7.549561</td>\n",
" <td>93.170584</td>\n",
" <td>180.058858</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>4856.525391</td>\n",
" <td>-2439.154785</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.133406</td>\n",
" <td>0.068024</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.164949</td>\n",
" <td>2.724076</td>\n",
" <td>-2606.935163</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>100.000000</td>\n",
" <td>-7.549561</td>\n",
" <td>93.170584</td>\n",
" <td>180.058858</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>5158.205566</td>\n",
" <td>-2295.737549</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.487209</td>\n",
" <td>0.036399</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.164949</td>\n",
" <td>2.724076</td>\n",
" <td>-2606.935163</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>100.000000</td>\n",
" <td>-7.549561</td>\n",
" <td>93.170584</td>\n",
" <td>180.058858</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>-1431.023804</td>\n",
" <td>1817.888672</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>-0.056901</td>\n",
" <td>-0.383259</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.161840</td>\n",
" <td>2.723059</td>\n",
" <td>-2551.901554</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4.536068</td>\n",
" <td>-1.643694</td>\n",
" <td>74.244153</td>\n",
" <td>319.554535</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>-2559.871338</td>\n",
" <td>1777.522827</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>-0.131265</td>\n",
" <td>-0.305102</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.161840</td>\n",
" <td>2.723059</td>\n",
" <td>-2551.901554</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4.536068</td>\n",
" <td>-1.643694</td>\n",
" <td>74.244153</td>\n",
" <td>319.554535</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>3186.063232</td>\n",
" <td>-1598.743530</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.019201</td>\n",
" <td>0.485372</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.161840</td>\n",
" <td>2.723059</td>\n",
" <td>-2551.901554</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4.536068</td>\n",
" <td>-1.643694</td>\n",
" <td>74.244153</td>\n",
" <td>319.554535</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>3493.876221</td>\n",
" <td>-1493.029175</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.568393</td>\n",
" <td>0.146750</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.161840</td>\n",
" <td>2.723059</td>\n",
" <td>-2551.901554</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4.536068</td>\n",
" <td>-1.643694</td>\n",
" <td>74.244153</td>\n",
" <td>319.554535</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>3518.268066</td>\n",
" <td>2495.108643</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.268449</td>\n",
" <td>1.000455</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.170415</td>\n",
" <td>2.720880</td>\n",
" <td>-2505.953426</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>5.000000</td>\n",
" <td>-50.069808</td>\n",
" <td>144.316524</td>\n",
" <td>-164.540707</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2385.278320</td>\n",
" <td>2476.032227</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.389532</td>\n",
" <td>-0.299258</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.170415</td>\n",
" <td>2.720880</td>\n",
" <td>-2505.953426</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>5.000000</td>\n",
" <td>-50.069808</td>\n",
" <td>144.316524</td>\n",
" <td>-164.540707</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>8131.361816</td>\n",
" <td>-902.645325</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>-0.469784</td>\n",
" <td>0.023018</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.170415</td>\n",
" <td>2.720880</td>\n",
" <td>-2505.953426</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>5.000000</td>\n",
" <td>-50.069808</td>\n",
" <td>144.316524</td>\n",
" <td>-164.540707</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>8437.115234</td>\n",
" <td>-842.309326</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.289877</td>\n",
" <td>-0.829150</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.170415</td>\n",
" <td>2.720880</td>\n",
" <td>-2505.953426</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>5.000000</td>\n",
" <td>-50.069808</td>\n",
" <td>144.316524</td>\n",
" <td>-164.540707</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15_8344_8845_4r_mt_z</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>3522.998535</td>\n",
" <td>1049.406982</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.466921</td>\n",
" <td>1.168062</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>1</td>\n",
" <td>0.170723</td>\n",
" <td>2.723266</td>\n",
" <td>-2502.470000</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>5.000000</td>\n",
" <td>-34.817656</td>\n",
" <td>145.864550</td>\n",
" <td>0.214023</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15_8344_8845_4r_mt_z</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2395.869385</td>\n",
" <td>1038.165405</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>-0.170850</td>\n",
" <td>0.372485</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>1</td>\n",
" <td>0.170723</td>\n",
" <td>2.723266</td>\n",
" <td>-2502.470000</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>5.000000</td>\n",
" <td>-34.817656</td>\n",
" <td>145.864550</td>\n",
" <td>0.214023</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15_8344_8845_4r_mt_z</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>8142.054688</td>\n",
" <td>-2364.445557</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>-0.072035</td>\n",
" <td>-0.832436</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>1</td>\n",
" <td>0.170723</td>\n",
" <td>2.723266</td>\n",
" <td>-2502.470000</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>5.000000</td>\n",
" <td>-34.817656</td>\n",
" <td>145.864550</td>\n",
" <td>0.214023</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15_8344_8845_4r_mt_z</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>8440.085938</td>\n",
" <td>-2219.049805</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.274030</td>\n",
" <td>-0.850105</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>1</td>\n",
" <td>0.170723</td>\n",
" <td>2.723266</td>\n",
" <td>-2502.470000</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>5.000000</td>\n",
" <td>-34.817656</td>\n",
" <td>145.864550</td>\n",
" <td>0.214023</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>1885.346313</td>\n",
" <td>1807.367065</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>-0.028473</td>\n",
" <td>-0.238015</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.167682</td>\n",
" <td>2.722359</td>\n",
" <td>-2558.312931</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.707214</td>\n",
" <td>-29.465246</td>\n",
" <td>121.908506</td>\n",
" <td>19.874949</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>756.099792</td>\n",
" <td>1785.494751</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.165338</td>\n",
" <td>-0.327408</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.167682</td>\n",
" <td>2.722359</td>\n",
" <td>-2558.312931</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.707214</td>\n",
" <td>-29.465246</td>\n",
" <td>121.908506</td>\n",
" <td>19.874949</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>6502.070313</td>\n",
" <td>-1593.964233</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>-0.007916</td>\n",
" <td>0.463232</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.167682</td>\n",
" <td>2.722359</td>\n",
" <td>-2558.312931</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.707214</td>\n",
" <td>-29.465246</td>\n",
" <td>121.908506</td>\n",
" <td>19.874949</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16_8344_8845_4r</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>6805.896973</td>\n",
" <td>-1493.774048</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.328896</td>\n",
" <td>0.019526</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.167682</td>\n",
" <td>2.722359</td>\n",
" <td>-2558.312931</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.707214</td>\n",
" <td>-29.465246</td>\n",
" <td>121.908506</td>\n",
" <td>19.874949</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17_8344_8845_2r_mt_z</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>-2015.364380</td>\n",
" <td>465.268188</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.010045</td>\n",
" <td>0.244017</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>1</td>\n",
" <td>0.161092</td>\n",
" <td>2.725426</td>\n",
" <td>-2590.130000</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.000000</td>\n",
" <td>-10.779830</td>\n",
" <td>38.761214</td>\n",
" <td>0.236077</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17_8344_8845_2r_mt_z</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>-3138.269531</td>\n",
" <td>442.515503</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>-0.023370</td>\n",
" <td>-0.248643</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>1</td>\n",
" <td>0.161092</td>\n",
" <td>2.725426</td>\n",
" <td>-2590.130000</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.000000</td>\n",
" <td>-10.779830</td>\n",
" <td>38.761214</td>\n",
" <td>0.236077</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_18</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>8918.806641</td>\n",
" <td>-1701.755249</td>\n",
" <td>0.022017</td>\n",
" <td>0.022017</td>\n",
" <td>0.734173</td>\n",
" <td>-0.074947</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.171455</td>\n",
" <td>2.722281</td>\n",
" <td>-2514.431453</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>-38.388316</td>\n",
" <td>195.050373</td>\n",
" <td>-391.289238</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_2</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>-2277.691406</td>\n",
" <td>-2240.823486</td>\n",
" <td>0.144273</td>\n",
" <td>0.144273</td>\n",
" <td>-0.061422</td>\n",
" <td>-0.263554</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.161184</td>\n",
" <td>2.729925</td>\n",
" <td>-2535.712262</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>42.067289</td>\n",
" <td>-12.658160</td>\n",
" <td>627.742625</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_2</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>-3389.000000</td>\n",
" <td>-2155.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>-0.073150</td>\n",
" <td>-0.271173</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.161184</td>\n",
" <td>2.729925</td>\n",
" <td>-2535.712262</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>42.067289</td>\n",
" <td>-12.658160</td>\n",
" <td>627.742625</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_2</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>-5474.326660</td>\n",
" <td>842.207031</td>\n",
" <td>0.275627</td>\n",
" <td>0.275627</td>\n",
" <td>0.164525</td>\n",
" <td>0.349547</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.161184</td>\n",
" <td>2.729925</td>\n",
" <td>-2535.712262</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>42.067289</td>\n",
" <td>-12.658160</td>\n",
" <td>627.742625</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_2</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>-4613.785645</td>\n",
" <td>643.217224</td>\n",
" <td>0.091086</td>\n",
" <td>0.091086</td>\n",
" <td>0.132736</td>\n",
" <td>0.239899</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.161184</td>\n",
" <td>2.729925</td>\n",
" <td>-2535.712262</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>42.067289</td>\n",
" <td>-12.658160</td>\n",
" <td>627.742625</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_3</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>-1801.096436</td>\n",
" <td>-2078.479004</td>\n",
" <td>0.062058</td>\n",
" <td>0.062058</td>\n",
" <td>-0.198696</td>\n",
" <td>-0.105860</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.161992</td>\n",
" <td>2.729563</td>\n",
" <td>-2525.215515</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>36.033823</td>\n",
" <td>-4.170818</td>\n",
" <td>616.480181</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_3</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>-2913.000000</td>\n",
" <td>-2000.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>-0.088180</td>\n",
" <td>-0.049593</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.161992</td>\n",
" <td>2.729563</td>\n",
" <td>-2525.215515</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>36.033823</td>\n",
" <td>-4.170818</td>\n",
" <td>616.480181</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_3</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>-4997.791504</td>\n",
" <td>1000.375854</td>\n",
" <td>0.132941</td>\n",
" <td>0.132941</td>\n",
" <td>0.257260</td>\n",
" <td>0.117777</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.161992</td>\n",
" <td>2.729563</td>\n",
" <td>-2525.215515</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>36.033823</td>\n",
" <td>-4.170818</td>\n",
" <td>616.480181</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_3</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>-4137.536133</td>\n",
" <td>774.480347</td>\n",
" <td>0.185544</td>\n",
" <td>0.185544</td>\n",
" <td>0.199301</td>\n",
" <td>0.065777</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.161992</td>\n",
" <td>2.729563</td>\n",
" <td>-2525.215515</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>36.033823</td>\n",
" <td>-4.170818</td>\n",
" <td>616.480181</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_4</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>-2103.971680</td>\n",
" <td>184.334869</td>\n",
" <td>0.146920</td>\n",
" <td>0.146920</td>\n",
" <td>0.182557</td>\n",
" <td>-0.000683</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.160994</td>\n",
" <td>2.725912</td>\n",
" <td>-2562.446851</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>-7.233876</td>\n",
" <td>33.324946</td>\n",
" <td>574.887719</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_4</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>-3226.000000</td>\n",
" <td>167.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>-0.195774</td>\n",
" <td>-0.000066</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.160994</td>\n",
" <td>2.725912</td>\n",
" <td>-2562.446851</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>-7.233876</td>\n",
" <td>33.324946</td>\n",
" <td>574.887719</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_5</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>-1813.285278</td>\n",
" <td>3.928788</td>\n",
" <td>0.019047</td>\n",
" <td>0.019047</td>\n",
" <td>-0.235171</td>\n",
" <td>-0.174079</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.161544</td>\n",
" <td>2.726149</td>\n",
" <td>-2560.812028</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>7.498790</td>\n",
" <td>33.109007</td>\n",
" <td>581.149470</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_5</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>-2934.000000</td>\n",
" <td>-6.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>-0.049005</td>\n",
" <td>0.437424</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.161544</td>\n",
" <td>2.726149</td>\n",
" <td>-2560.812028</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>7.498790</td>\n",
" <td>33.109007</td>\n",
" <td>581.149470</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_5</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>-4165.228516</td>\n",
" <td>2507.076660</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.447100</td>\n",
" <td>-0.219764</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.161544</td>\n",
" <td>2.726149</td>\n",
" <td>-2560.812028</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>7.498790</td>\n",
" <td>33.109007</td>\n",
" <td>581.149470</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_6</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>-2250.549072</td>\n",
" <td>1572.788086</td>\n",
" <td>0.025015</td>\n",
" <td>0.025015</td>\n",
" <td>-0.146990</td>\n",
" <td>0.192274</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.160447</td>\n",
" <td>2.723639</td>\n",
" <td>-2605.266130</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>7.687475</td>\n",
" <td>59.859663</td>\n",
" <td>375.680663</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_6</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>-3378.000000</td>\n",
" <td>1532.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.026541</td>\n",
" <td>0.063346</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.160447</td>\n",
" <td>2.723639</td>\n",
" <td>-2605.266130</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>7.687475</td>\n",
" <td>59.859663</td>\n",
" <td>375.680663</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_6</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2367.587646</td>\n",
" <td>-1849.272095</td>\n",
" <td>0.025110</td>\n",
" <td>0.025110</td>\n",
" <td>-0.040890</td>\n",
" <td>-0.136247</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.160447</td>\n",
" <td>2.723639</td>\n",
" <td>-2605.266130</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>7.687475</td>\n",
" <td>59.859663</td>\n",
" <td>375.680663</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_6</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2675.137207</td>\n",
" <td>-1730.558105</td>\n",
" <td>0.064276</td>\n",
" <td>0.064276</td>\n",
" <td>0.546035</td>\n",
" <td>-0.185103</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.160447</td>\n",
" <td>2.723639</td>\n",
" <td>-2605.266130</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>7.687475</td>\n",
" <td>59.859663</td>\n",
" <td>375.680663</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_7</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>-2249.931396</td>\n",
" <td>1712.971436</td>\n",
" <td>0.010596</td>\n",
" <td>0.010596</td>\n",
" <td>-0.102909</td>\n",
" <td>0.079389</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.160419</td>\n",
" <td>2.723407</td>\n",
" <td>-2619.498291</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>6.358447</td>\n",
" <td>61.278242</td>\n",
" <td>375.840988</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_7</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>-3378.000000</td>\n",
" <td>1672.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.055623</td>\n",
" <td>0.013456</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.160419</td>\n",
" <td>2.723407</td>\n",
" <td>-2619.498291</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>6.358447</td>\n",
" <td>61.278242</td>\n",
" <td>375.840988</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_7</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2367.507813</td>\n",
" <td>-1706.241821</td>\n",
" <td>0.047435</td>\n",
" <td>0.047435</td>\n",
" <td>-0.157931</td>\n",
" <td>-0.042074</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.160419</td>\n",
" <td>2.723407</td>\n",
" <td>-2619.498291</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>6.358447</td>\n",
" <td>61.278242</td>\n",
" <td>375.840988</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_7</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2675.892578</td>\n",
" <td>-1596.527100</td>\n",
" <td>0.058218</td>\n",
" <td>0.058218</td>\n",
" <td>0.589561</td>\n",
" <td>-0.111421</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.160419</td>\n",
" <td>2.723407</td>\n",
" <td>-2619.498291</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>6.358447</td>\n",
" <td>61.278242</td>\n",
" <td>375.840988</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_8</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>-1664.131104</td>\n",
" <td>1875.622437</td>\n",
" <td>0.017266</td>\n",
" <td>0.017266</td>\n",
" <td>-0.239689</td>\n",
" <td>-0.402891</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.161417</td>\n",
" <td>2.723012</td>\n",
" <td>-2608.028730</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>-0.219662</td>\n",
" <td>71.414267</td>\n",
" <td>336.409684</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_8</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>-2793.000000</td>\n",
" <td>1837.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>-0.117483</td>\n",
" <td>-0.229337</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.161417</td>\n",
" <td>2.723012</td>\n",
" <td>-2608.028730</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>-0.219662</td>\n",
" <td>71.414267</td>\n",
" <td>336.409684</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_8</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>2953.094727</td>\n",
" <td>-1538.956543</td>\n",
" <td>0.023364</td>\n",
" <td>0.023364</td>\n",
" <td>0.177406</td>\n",
" <td>0.403161</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.161417</td>\n",
" <td>2.723012</td>\n",
" <td>-2608.028730</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>-0.219662</td>\n",
" <td>71.414267</td>\n",
" <td>336.409684</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_8</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>3261.290039</td>\n",
" <td>-1439.873169</td>\n",
" <td>0.023538</td>\n",
" <td>0.023538</td>\n",
" <td>0.575510</td>\n",
" <td>0.180705</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.161417</td>\n",
" <td>2.723012</td>\n",
" <td>-2608.028730</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>-0.219662</td>\n",
" <td>71.414267</td>\n",
" <td>336.409684</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_9</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>332.072113</td>\n",
" <td>-2045.152222</td>\n",
" <td>0.232865</td>\n",
" <td>0.232865</td>\n",
" <td>0.095817</td>\n",
" <td>-0.483899</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.165741</td>\n",
" <td>2.729053</td>\n",
" <td>-2586.686862</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>15.191825</td>\n",
" <td>22.094037</td>\n",
" <td>544.874936</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_9</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>-780.000000</td>\n",
" <td>-1953.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.298743</td>\n",
" <td>-0.045963</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.165741</td>\n",
" <td>2.729053</td>\n",
" <td>-2586.686862</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>15.191825</td>\n",
" <td>22.094037</td>\n",
" <td>544.874936</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_9</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>-2866.689453</td>\n",
" <td>1031.006104</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>-0.038437</td>\n",
" <td>0.471309</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.165741</td>\n",
" <td>2.729053</td>\n",
" <td>-2586.686862</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>15.191825</td>\n",
" <td>22.094037</td>\n",
" <td>544.874936</td>\n",
" </tr>\n",
" <tr>\n",
" <th>P20_008845_1894_XN_09N203W_9</th>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>-2002.366211</td>\n",
" <td>824.604126</td>\n",
" <td>0.397616</td>\n",
" <td>0.397616</td>\n",
" <td>-0.141172</td>\n",
" <td>0.105223</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0.165741</td>\n",
" <td>2.729053</td>\n",
" <td>-2586.686862</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>15.191825</td>\n",
" <td>22.094037</td>\n",
" <td>544.874936</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>919 rows × 23 columns</p>\n",
"</div>"
],
"text/plain": [
" val fid_val no_obs l. s. \\\n",
"10_8344_8845_4r 1 0 0 -2919.380615 1052.729004 \n",
"10_8344_8845_4r 1 0 0 -4044.697510 1008.950928 \n",
"10_8344_8845_4r 1 0 0 1700.584473 -2390.001709 \n",
"10_8344_8845_4r 1 0 0 2006.141113 -2234.915283 \n",
"11_8344_8845_4r 1 0 0 370.151917 2340.653076 \n",
"11_8344_8845_4r 1 0 0 -761.216064 2303.787109 \n",
"11_8344_8845_4r 1 0 0 4985.437988 -1070.364990 \n",
"11_8344_8845_4r 1 0 0 5293.700195 -993.390625 \n",
"12_8344_8845_4r 1 0 0 236.395218 984.833252 \n",
"12_8344_8845_4r 1 0 0 -889.364441 966.533997 \n",
"12_8344_8845_4r 1 0 0 4856.525391 -2439.154785 \n",
"12_8344_8845_4r 1 0 0 5158.205566 -2295.737549 \n",
"13_8344_8845_4r 1 0 0 -1431.023804 1817.888672 \n",
"13_8344_8845_4r 1 0 0 -2559.871338 1777.522827 \n",
"13_8344_8845_4r 1 0 0 3186.063232 -1598.743530 \n",
"13_8344_8845_4r 1 0 0 3493.876221 -1493.029175 \n",
"14_8344_8845_4r 1 0 0 3518.268066 2495.108643 \n",
"14_8344_8845_4r 1 0 0 2385.278320 2476.032227 \n",
"14_8344_8845_4r 1 0 0 8131.361816 -902.645325 \n",
"14_8344_8845_4r 1 0 0 8437.115234 -842.309326 \n",
"15_8344_8845_4r_mt_z 1 0 0 3522.998535 1049.406982 \n",
"15_8344_8845_4r_mt_z 1 0 0 2395.869385 1038.165405 \n",
"15_8344_8845_4r_mt_z 1 0 0 8142.054688 -2364.445557 \n",
"15_8344_8845_4r_mt_z 1 0 0 8440.085938 -2219.049805 \n",
"16_8344_8845_4r 1 0 0 1885.346313 1807.367065 \n",
"16_8344_8845_4r 1 0 0 756.099792 1785.494751 \n",
"16_8344_8845_4r 1 0 0 6502.070313 -1593.964233 \n",
"16_8344_8845_4r 1 0 0 6805.896973 -1493.774048 \n",
"17_8344_8845_2r_mt_z 1 0 0 -2015.364380 465.268188 \n",
"17_8344_8845_2r_mt_z 1 0 0 -3138.269531 442.515503 \n",
"... ... ... ... ... ... \n",
"P20_008845_1894_XN_09N203W_18 1 0 1 8918.806641 -1701.755249 \n",
"P20_008845_1894_XN_09N203W_2 1 0 1 -2277.691406 -2240.823486 \n",
"P20_008845_1894_XN_09N203W_2 1 0 0 -3389.000000 -2155.000000 \n",
"P20_008845_1894_XN_09N203W_2 1 0 1 -5474.326660 842.207031 \n",
"P20_008845_1894_XN_09N203W_2 1 0 0 -4613.785645 643.217224 \n",
"P20_008845_1894_XN_09N203W_3 1 0 1 -1801.096436 -2078.479004 \n",
"P20_008845_1894_XN_09N203W_3 1 0 0 -2913.000000 -2000.000000 \n",
"P20_008845_1894_XN_09N203W_3 1 0 1 -4997.791504 1000.375854 \n",
"P20_008845_1894_XN_09N203W_3 1 0 0 -4137.536133 774.480347 \n",
"P20_008845_1894_XN_09N203W_4 1 0 1 -2103.971680 184.334869 \n",
"P20_008845_1894_XN_09N203W_4 1 0 1 -3226.000000 167.000000 \n",
"P20_008845_1894_XN_09N203W_5 1 0 1 -1813.285278 3.928788 \n",
"P20_008845_1894_XN_09N203W_5 1 0 1 -2934.000000 -6.000000 \n",
"P20_008845_1894_XN_09N203W_5 1 0 0 -4165.228516 2507.076660 \n",
"P20_008845_1894_XN_09N203W_6 1 0 1 -2250.549072 1572.788086 \n",
"P20_008845_1894_XN_09N203W_6 1 0 3 -3378.000000 1532.000000 \n",
"P20_008845_1894_XN_09N203W_6 1 0 1 2367.587646 -1849.272095 \n",
"P20_008845_1894_XN_09N203W_6 1 0 1 2675.137207 -1730.558105 \n",
"P20_008845_1894_XN_09N203W_7 1 0 1 -2249.931396 1712.971436 \n",
"P20_008845_1894_XN_09N203W_7 1 0 3 -3378.000000 1672.000000 \n",
"P20_008845_1894_XN_09N203W_7 1 0 1 2367.507813 -1706.241821 \n",
"P20_008845_1894_XN_09N203W_7 1 0 1 2675.892578 -1596.527100 \n",
"P20_008845_1894_XN_09N203W_8 1 0 1 -1664.131104 1875.622437 \n",
"P20_008845_1894_XN_09N203W_8 1 0 3 -2793.000000 1837.000000 \n",
"P20_008845_1894_XN_09N203W_8 1 0 1 2953.094727 -1538.956543 \n",
"P20_008845_1894_XN_09N203W_8 1 0 1 3261.290039 -1439.873169 \n",
"P20_008845_1894_XN_09N203W_9 1 0 1 332.072113 -2045.152222 \n",
"P20_008845_1894_XN_09N203W_9 1 0 0 -780.000000 -1953.000000 \n",
"P20_008845_1894_XN_09N203W_9 1 0 0 -2866.689453 1031.006104 \n",
"P20_008845_1894_XN_09N203W_9 1 0 0 -2002.366211 824.604126 \n",
"\n",
" sig_l sig_s res_l res_s fid_x \\\n",
"10_8344_8845_4r 0.000000 0.000000 0.059914 0.930311 0.0 \n",
"10_8344_8845_4r 0.000000 0.000000 0.063678 0.661294 0.0 \n",
"10_8344_8845_4r 0.000000 0.000000 -0.063695 -1.055619 0.0 \n",
"10_8344_8845_4r 0.000000 0.000000 0.318779 -0.585138 0.0 \n",
"11_8344_8845_4r 0.000000 0.000000 -0.239226 -1.113693 0.0 \n",
"11_8344_8845_4r 0.000000 0.000000 -0.247307 -0.587299 0.0 \n",
"11_8344_8845_4r 0.000000 0.000000 0.239207 1.080801 0.0 \n",
"11_8344_8845_4r 0.000000 0.000000 0.672877 0.626316 0.0 \n",
"12_8344_8845_4r 0.000000 0.000000 0.073683 -0.237114 0.0 \n",
"12_8344_8845_4r 0.000000 0.000000 -0.251753 0.008170 0.0 \n",
"12_8344_8845_4r 0.000000 0.000000 0.133406 0.068024 0.0 \n",
"12_8344_8845_4r 0.000000 0.000000 0.487209 0.036399 0.0 \n",
"13_8344_8845_4r 0.000000 0.000000 -0.056901 -0.383259 0.0 \n",
"13_8344_8845_4r 0.000000 0.000000 -0.131265 -0.305102 0.0 \n",
"13_8344_8845_4r 0.000000 0.000000 0.019201 0.485372 0.0 \n",
"13_8344_8845_4r 0.000000 0.000000 0.568393 0.146750 0.0 \n",
"14_8344_8845_4r 0.000000 0.000000 0.268449 1.000455 0.0 \n",
"14_8344_8845_4r 0.000000 0.000000 0.389532 -0.299258 0.0 \n",
"14_8344_8845_4r 0.000000 0.000000 -0.469784 0.023018 0.0 \n",
"14_8344_8845_4r 0.000000 0.000000 0.289877 -0.829150 0.0 \n",
"15_8344_8845_4r_mt_z 0.000000 0.000000 0.466921 1.168062 0.0 \n",
"15_8344_8845_4r_mt_z 0.000000 0.000000 -0.170850 0.372485 0.0 \n",
"15_8344_8845_4r_mt_z 0.000000 0.000000 -0.072035 -0.832436 0.0 \n",
"15_8344_8845_4r_mt_z 0.000000 0.000000 0.274030 -0.850105 0.0 \n",
"16_8344_8845_4r 0.000000 0.000000 -0.028473 -0.238015 0.0 \n",
"16_8344_8845_4r 0.000000 0.000000 0.165338 -0.327408 0.0 \n",
"16_8344_8845_4r 0.000000 0.000000 -0.007916 0.463232 0.0 \n",
"16_8344_8845_4r 0.000000 0.000000 0.328896 0.019526 0.0 \n",
"17_8344_8845_2r_mt_z 0.000000 0.000000 0.010045 0.244017 0.0 \n",
"17_8344_8845_2r_mt_z 0.000000 0.000000 -0.023370 -0.248643 0.0 \n",
"... ... ... ... ... ... \n",
"P20_008845_1894_XN_09N203W_18 0.022017 0.022017 0.734173 -0.074947 0.0 \n",
"P20_008845_1894_XN_09N203W_2 0.144273 0.144273 -0.061422 -0.263554 0.0 \n",
"P20_008845_1894_XN_09N203W_2 0.000000 0.000000 -0.073150 -0.271173 0.0 \n",
"P20_008845_1894_XN_09N203W_2 0.275627 0.275627 0.164525 0.349547 0.0 \n",
"P20_008845_1894_XN_09N203W_2 0.091086 0.091086 0.132736 0.239899 0.0 \n",
"P20_008845_1894_XN_09N203W_3 0.062058 0.062058 -0.198696 -0.105860 0.0 \n",
"P20_008845_1894_XN_09N203W_3 0.000000 0.000000 -0.088180 -0.049593 0.0 \n",
"P20_008845_1894_XN_09N203W_3 0.132941 0.132941 0.257260 0.117777 0.0 \n",
"P20_008845_1894_XN_09N203W_3 0.185544 0.185544 0.199301 0.065777 0.0 \n",
"P20_008845_1894_XN_09N203W_4 0.146920 0.146920 0.182557 -0.000683 0.0 \n",
"P20_008845_1894_XN_09N203W_4 0.000000 0.000000 -0.195774 -0.000066 0.0 \n",
"P20_008845_1894_XN_09N203W_5 0.019047 0.019047 -0.235171 -0.174079 0.0 \n",
"P20_008845_1894_XN_09N203W_5 0.000000 0.000000 -0.049005 0.437424 0.0 \n",
"P20_008845_1894_XN_09N203W_5 0.000000 0.000000 0.447100 -0.219764 0.0 \n",
"P20_008845_1894_XN_09N203W_6 0.025015 0.025015 -0.146990 0.192274 0.0 \n",
"P20_008845_1894_XN_09N203W_6 0.000000 0.000000 0.026541 0.063346 0.0 \n",
"P20_008845_1894_XN_09N203W_6 0.025110 0.025110 -0.040890 -0.136247 0.0 \n",
"P20_008845_1894_XN_09N203W_6 0.064276 0.064276 0.546035 -0.185103 0.0 \n",
"P20_008845_1894_XN_09N203W_7 0.010596 0.010596 -0.102909 0.079389 0.0 \n",
"P20_008845_1894_XN_09N203W_7 0.000000 0.000000 0.055623 0.013456 0.0 \n",
"P20_008845_1894_XN_09N203W_7 0.047435 0.047435 -0.157931 -0.042074 0.0 \n",
"P20_008845_1894_XN_09N203W_7 0.058218 0.058218 0.589561 -0.111421 0.0 \n",
"P20_008845_1894_XN_09N203W_8 0.017266 0.017266 -0.239689 -0.402891 0.0 \n",
"P20_008845_1894_XN_09N203W_8 0.000000 0.000000 -0.117483 -0.229337 0.0 \n",
"P20_008845_1894_XN_09N203W_8 0.023364 0.023364 0.177406 0.403161 0.0 \n",
"P20_008845_1894_XN_09N203W_8 0.023538 0.023538 0.575510 0.180705 0.0 \n",
"P20_008845_1894_XN_09N203W_9 0.232865 0.232865 0.095817 -0.483899 0.0 \n",
"P20_008845_1894_XN_09N203W_9 0.000000 0.000000 0.298743 -0.045963 0.0 \n",
"P20_008845_1894_XN_09N203W_9 0.000000 0.000000 -0.038437 0.471309 0.0 \n",
"P20_008845_1894_XN_09N203W_9 0.397616 0.397616 -0.141172 0.105223 0.0 \n",
"\n",
" ... known lat_Y_North long_X_East \\\n",
"10_8344_8845_4r ... 0 0.159378 2.724649 \n",
"10_8344_8845_4r ... 0 0.159378 2.724649 \n",
"10_8344_8845_4r ... 0 0.159378 2.724649 \n",
"10_8344_8845_4r ... 0 0.159378 2.724649 \n",
"11_8344_8845_4r ... 0 0.164905 2.721815 \n",
"11_8344_8845_4r ... 0 0.164905 2.721815 \n",
"11_8344_8845_4r ... 0 0.164905 2.721815 \n",
"11_8344_8845_4r ... 0 0.164905 2.721815 \n",
"12_8344_8845_4r ... 0 0.164949 2.724076 \n",
"12_8344_8845_4r ... 0 0.164949 2.724076 \n",
"12_8344_8845_4r ... 0 0.164949 2.724076 \n",
"12_8344_8845_4r ... 0 0.164949 2.724076 \n",
"13_8344_8845_4r ... 0 0.161840 2.723059 \n",
"13_8344_8845_4r ... 0 0.161840 2.723059 \n",
"13_8344_8845_4r ... 0 0.161840 2.723059 \n",
"13_8344_8845_4r ... 0 0.161840 2.723059 \n",
"14_8344_8845_4r ... 0 0.170415 2.720880 \n",
"14_8344_8845_4r ... 0 0.170415 2.720880 \n",
"14_8344_8845_4r ... 0 0.170415 2.720880 \n",
"14_8344_8845_4r ... 0 0.170415 2.720880 \n",
"15_8344_8845_4r_mt_z ... 1 0.170723 2.723266 \n",
"15_8344_8845_4r_mt_z ... 1 0.170723 2.723266 \n",
"15_8344_8845_4r_mt_z ... 1 0.170723 2.723266 \n",
"15_8344_8845_4r_mt_z ... 1 0.170723 2.723266 \n",
"16_8344_8845_4r ... 0 0.167682 2.722359 \n",
"16_8344_8845_4r ... 0 0.167682 2.722359 \n",
"16_8344_8845_4r ... 0 0.167682 2.722359 \n",
"16_8344_8845_4r ... 0 0.167682 2.722359 \n",
"17_8344_8845_2r_mt_z ... 1 0.161092 2.725426 \n",
"17_8344_8845_2r_mt_z ... 1 0.161092 2.725426 \n",
"... ... ... ... ... \n",
"P20_008845_1894_XN_09N203W_18 ... 0 0.171455 2.722281 \n",
"P20_008845_1894_XN_09N203W_2 ... 0 0.161184 2.729925 \n",
"P20_008845_1894_XN_09N203W_2 ... 0 0.161184 2.729925 \n",
"P20_008845_1894_XN_09N203W_2 ... 0 0.161184 2.729925 \n",
"P20_008845_1894_XN_09N203W_2 ... 0 0.161184 2.729925 \n",
"P20_008845_1894_XN_09N203W_3 ... 0 0.161992 2.729563 \n",
"P20_008845_1894_XN_09N203W_3 ... 0 0.161992 2.729563 \n",
"P20_008845_1894_XN_09N203W_3 ... 0 0.161992 2.729563 \n",
"P20_008845_1894_XN_09N203W_3 ... 0 0.161992 2.729563 \n",
"P20_008845_1894_XN_09N203W_4 ... 0 0.160994 2.725912 \n",
"P20_008845_1894_XN_09N203W_4 ... 0 0.160994 2.725912 \n",
"P20_008845_1894_XN_09N203W_5 ... 0 0.161544 2.726149 \n",
"P20_008845_1894_XN_09N203W_5 ... 0 0.161544 2.726149 \n",
"P20_008845_1894_XN_09N203W_5 ... 0 0.161544 2.726149 \n",
"P20_008845_1894_XN_09N203W_6 ... 0 0.160447 2.723639 \n",
"P20_008845_1894_XN_09N203W_6 ... 0 0.160447 2.723639 \n",
"P20_008845_1894_XN_09N203W_6 ... 0 0.160447 2.723639 \n",
"P20_008845_1894_XN_09N203W_6 ... 0 0.160447 2.723639 \n",
"P20_008845_1894_XN_09N203W_7 ... 0 0.160419 2.723407 \n",
"P20_008845_1894_XN_09N203W_7 ... 0 0.160419 2.723407 \n",
"P20_008845_1894_XN_09N203W_7 ... 0 0.160419 2.723407 \n",
"P20_008845_1894_XN_09N203W_7 ... 0 0.160419 2.723407 \n",
"P20_008845_1894_XN_09N203W_8 ... 0 0.161417 2.723012 \n",
"P20_008845_1894_XN_09N203W_8 ... 0 0.161417 2.723012 \n",
"P20_008845_1894_XN_09N203W_8 ... 0 0.161417 2.723012 \n",
"P20_008845_1894_XN_09N203W_8 ... 0 0.161417 2.723012 \n",
"P20_008845_1894_XN_09N203W_9 ... 0 0.165741 2.729053 \n",
"P20_008845_1894_XN_09N203W_9 ... 0 0.165741 2.729053 \n",
"P20_008845_1894_XN_09N203W_9 ... 0 0.165741 2.729053 \n",
"P20_008845_1894_XN_09N203W_9 ... 0 0.165741 2.729053 \n",
"\n",
" ht sig0 sig1 sig2 res0 \\\n",
"10_8344_8845_4r -2523.828227 0.0 0.0 25.000000 18.301328 \n",
"10_8344_8845_4r -2523.828227 0.0 0.0 25.000000 18.301328 \n",
"10_8344_8845_4r -2523.828227 0.0 0.0 25.000000 18.301328 \n",
"10_8344_8845_4r -2523.828227 0.0 0.0 25.000000 18.301328 \n",
"11_8344_8845_4r -2445.237027 0.0 0.0 30.000000 -22.046575 \n",
"11_8344_8845_4r -2445.237027 0.0 0.0 30.000000 -22.046575 \n",
"11_8344_8845_4r -2445.237027 0.0 0.0 30.000000 -22.046575 \n",
"11_8344_8845_4r -2445.237027 0.0 0.0 30.000000 -22.046575 \n",
"12_8344_8845_4r -2606.935163 0.0 0.0 100.000000 -7.549561 \n",
"12_8344_8845_4r -2606.935163 0.0 0.0 100.000000 -7.549561 \n",
"12_8344_8845_4r -2606.935163 0.0 0.0 100.000000 -7.549561 \n",
"12_8344_8845_4r -2606.935163 0.0 0.0 100.000000 -7.549561 \n",
"13_8344_8845_4r -2551.901554 0.0 0.0 4.536068 -1.643694 \n",
"13_8344_8845_4r -2551.901554 0.0 0.0 4.536068 -1.643694 \n",
"13_8344_8845_4r -2551.901554 0.0 0.0 4.536068 -1.643694 \n",
"13_8344_8845_4r -2551.901554 0.0 0.0 4.536068 -1.643694 \n",
"14_8344_8845_4r -2505.953426 0.0 0.0 5.000000 -50.069808 \n",
"14_8344_8845_4r -2505.953426 0.0 0.0 5.000000 -50.069808 \n",
"14_8344_8845_4r -2505.953426 0.0 0.0 5.000000 -50.069808 \n",
"14_8344_8845_4r -2505.953426 0.0 0.0 5.000000 -50.069808 \n",
"15_8344_8845_4r_mt_z -2502.470000 0.0 0.0 5.000000 -34.817656 \n",
"15_8344_8845_4r_mt_z -2502.470000 0.0 0.0 5.000000 -34.817656 \n",
"15_8344_8845_4r_mt_z -2502.470000 0.0 0.0 5.000000 -34.817656 \n",
"15_8344_8845_4r_mt_z -2502.470000 0.0 0.0 5.000000 -34.817656 \n",
"16_8344_8845_4r -2558.312931 0.0 0.0 1.707214 -29.465246 \n",
"16_8344_8845_4r -2558.312931 0.0 0.0 1.707214 -29.465246 \n",
"16_8344_8845_4r -2558.312931 0.0 0.0 1.707214 -29.465246 \n",
"16_8344_8845_4r -2558.312931 0.0 0.0 1.707214 -29.465246 \n",
"17_8344_8845_2r_mt_z -2590.130000 0.0 0.0 2.000000 -10.779830 \n",
"17_8344_8845_2r_mt_z -2590.130000 0.0 0.0 2.000000 -10.779830 \n",
"... ... ... ... ... ... \n",
"P20_008845_1894_XN_09N203W_18 -2514.431453 0.0 0.0 0.000000 -38.388316 \n",
"P20_008845_1894_XN_09N203W_2 -2535.712262 0.0 0.0 0.000000 42.067289 \n",
"P20_008845_1894_XN_09N203W_2 -2535.712262 0.0 0.0 0.000000 42.067289 \n",
"P20_008845_1894_XN_09N203W_2 -2535.712262 0.0 0.0 0.000000 42.067289 \n",
"P20_008845_1894_XN_09N203W_2 -2535.712262 0.0 0.0 0.000000 42.067289 \n",
"P20_008845_1894_XN_09N203W_3 -2525.215515 0.0 0.0 0.000000 36.033823 \n",
"P20_008845_1894_XN_09N203W_3 -2525.215515 0.0 0.0 0.000000 36.033823 \n",
"P20_008845_1894_XN_09N203W_3 -2525.215515 0.0 0.0 0.000000 36.033823 \n",
"P20_008845_1894_XN_09N203W_3 -2525.215515 0.0 0.0 0.000000 36.033823 \n",
"P20_008845_1894_XN_09N203W_4 -2562.446851 0.0 0.0 0.000000 -7.233876 \n",
"P20_008845_1894_XN_09N203W_4 -2562.446851 0.0 0.0 0.000000 -7.233876 \n",
"P20_008845_1894_XN_09N203W_5 -2560.812028 0.0 0.0 0.000000 7.498790 \n",
"P20_008845_1894_XN_09N203W_5 -2560.812028 0.0 0.0 0.000000 7.498790 \n",
"P20_008845_1894_XN_09N203W_5 -2560.812028 0.0 0.0 0.000000 7.498790 \n",
"P20_008845_1894_XN_09N203W_6 -2605.266130 0.0 0.0 0.000000 7.687475 \n",
"P20_008845_1894_XN_09N203W_6 -2605.266130 0.0 0.0 0.000000 7.687475 \n",
"P20_008845_1894_XN_09N203W_6 -2605.266130 0.0 0.0 0.000000 7.687475 \n",
"P20_008845_1894_XN_09N203W_6 -2605.266130 0.0 0.0 0.000000 7.687475 \n",
"P20_008845_1894_XN_09N203W_7 -2619.498291 0.0 0.0 0.000000 6.358447 \n",
"P20_008845_1894_XN_09N203W_7 -2619.498291 0.0 0.0 0.000000 6.358447 \n",
"P20_008845_1894_XN_09N203W_7 -2619.498291 0.0 0.0 0.000000 6.358447 \n",
"P20_008845_1894_XN_09N203W_7 -2619.498291 0.0 0.0 0.000000 6.358447 \n",
"P20_008845_1894_XN_09N203W_8 -2608.028730 0.0 0.0 0.000000 -0.219662 \n",
"P20_008845_1894_XN_09N203W_8 -2608.028730 0.0 0.0 0.000000 -0.219662 \n",
"P20_008845_1894_XN_09N203W_8 -2608.028730 0.0 0.0 0.000000 -0.219662 \n",
"P20_008845_1894_XN_09N203W_8 -2608.028730 0.0 0.0 0.000000 -0.219662 \n",
"P20_008845_1894_XN_09N203W_9 -2586.686862 0.0 0.0 0.000000 15.191825 \n",
"P20_008845_1894_XN_09N203W_9 -2586.686862 0.0 0.0 0.000000 15.191825 \n",
"P20_008845_1894_XN_09N203W_9 -2586.686862 0.0 0.0 0.000000 15.191825 \n",
"P20_008845_1894_XN_09N203W_9 -2586.686862 0.0 0.0 0.000000 15.191825 \n",
"\n",
" res1 res2 \n",
"10_8344_8845_4r 44.206259 416.201741 \n",
"10_8344_8845_4r 44.206259 416.201741 \n",
"10_8344_8845_4r 44.206259 416.201741 \n",
"10_8344_8845_4r 44.206259 416.201741 \n",
"11_8344_8845_4r 103.403228 173.210013 \n",
"11_8344_8845_4r 103.403228 173.210013 \n",
"11_8344_8845_4r 103.403228 173.210013 \n",
"11_8344_8845_4r 103.403228 173.210013 \n",
"12_8344_8845_4r 93.170584 180.058858 \n",
"12_8344_8845_4r 93.170584 180.058858 \n",
"12_8344_8845_4r 93.170584 180.058858 \n",
"12_8344_8845_4r 93.170584 180.058858 \n",
"13_8344_8845_4r 74.244153 319.554535 \n",
"13_8344_8845_4r 74.244153 319.554535 \n",
"13_8344_8845_4r 74.244153 319.554535 \n",
"13_8344_8845_4r 74.244153 319.554535 \n",
"14_8344_8845_4r 144.316524 -164.540707 \n",
"14_8344_8845_4r 144.316524 -164.540707 \n",
"14_8344_8845_4r 144.316524 -164.540707 \n",
"14_8344_8845_4r 144.316524 -164.540707 \n",
"15_8344_8845_4r_mt_z 145.864550 0.214023 \n",
"15_8344_8845_4r_mt_z 145.864550 0.214023 \n",
"15_8344_8845_4r_mt_z 145.864550 0.214023 \n",
"15_8344_8845_4r_mt_z 145.864550 0.214023 \n",
"16_8344_8845_4r 121.908506 19.874949 \n",
"16_8344_8845_4r 121.908506 19.874949 \n",
"16_8344_8845_4r 121.908506 19.874949 \n",
"16_8344_8845_4r 121.908506 19.874949 \n",
"17_8344_8845_2r_mt_z 38.761214 0.236077 \n",
"17_8344_8845_2r_mt_z 38.761214 0.236077 \n",
"... ... ... \n",
"P20_008845_1894_XN_09N203W_18 195.050373 -391.289238 \n",
"P20_008845_1894_XN_09N203W_2 -12.658160 627.742625 \n",
"P20_008845_1894_XN_09N203W_2 -12.658160 627.742625 \n",
"P20_008845_1894_XN_09N203W_2 -12.658160 627.742625 \n",
"P20_008845_1894_XN_09N203W_2 -12.658160 627.742625 \n",
"P20_008845_1894_XN_09N203W_3 -4.170818 616.480181 \n",
"P20_008845_1894_XN_09N203W_3 -4.170818 616.480181 \n",
"P20_008845_1894_XN_09N203W_3 -4.170818 616.480181 \n",
"P20_008845_1894_XN_09N203W_3 -4.170818 616.480181 \n",
"P20_008845_1894_XN_09N203W_4 33.324946 574.887719 \n",
"P20_008845_1894_XN_09N203W_4 33.324946 574.887719 \n",
"P20_008845_1894_XN_09N203W_5 33.109007 581.149470 \n",
"P20_008845_1894_XN_09N203W_5 33.109007 581.149470 \n",
"P20_008845_1894_XN_09N203W_5 33.109007 581.149470 \n",
"P20_008845_1894_XN_09N203W_6 59.859663 375.680663 \n",
"P20_008845_1894_XN_09N203W_6 59.859663 375.680663 \n",
"P20_008845_1894_XN_09N203W_6 59.859663 375.680663 \n",
"P20_008845_1894_XN_09N203W_6 59.859663 375.680663 \n",
"P20_008845_1894_XN_09N203W_7 61.278242 375.840988 \n",
"P20_008845_1894_XN_09N203W_7 61.278242 375.840988 \n",
"P20_008845_1894_XN_09N203W_7 61.278242 375.840988 \n",
"P20_008845_1894_XN_09N203W_7 61.278242 375.840988 \n",
"P20_008845_1894_XN_09N203W_8 71.414267 336.409684 \n",
"P20_008845_1894_XN_09N203W_8 71.414267 336.409684 \n",
"P20_008845_1894_XN_09N203W_8 71.414267 336.409684 \n",
"P20_008845_1894_XN_09N203W_8 71.414267 336.409684 \n",
"P20_008845_1894_XN_09N203W_9 22.094037 544.874936 \n",
"P20_008845_1894_XN_09N203W_9 22.094037 544.874936 \n",
"P20_008845_1894_XN_09N203W_9 22.094037 544.874936 \n",
"P20_008845_1894_XN_09N203W_9 22.094037 544.874936 \n",
"\n",
"[919 rows x 23 columns]"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"atf_dict = read_atf(get_path('CTX_Athabasca_Middle_step0.atf'))\n",
"\n",
"gpf_file = os.path.join(atf_dict['PATH'], atf_dict['GP_FILE']);\n",
"ipf_list = [os.path.join(atf_dict['PATH'], i) for i in atf_dict['IMAGE_IPF']]\n",
"\n",
"gpf_df = read_gpf(gpf_file).set_index('point_id')\n",
"ipf_df = read_ipf(ipf_list).set_index('pt_id')\n",
"\n",
"point_diff = ipf_df.index.difference(gpf_df.index)\n",
"\n",
"if len(point_diff) != 0:\n",
" warnings.warn(\"The following points found in ipf files missing from gpf file: \\n\\n{}. \\\n",
" \\n\\nContinuing, but these points will be missing from the control network\".format(list(point_diff)))\n",
"\n",
"new_df = ipf_df.merge(gpf_df, left_index=True, right_index=True)\n",
"new_df"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.6.3"
}
},
"nbformat": 4,
"nbformat_minor": 2
}