{ "cells": [ { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{'ATF_FILE': 'CTX_Athabasca_Middle_step0.atf',\n", " 'GP_FILE': 'CTX_Athabasca_Middle.gpf',\n", " 'IMAGE_IPF': ['P19_008344_1894_XN_09N203W.ipf',\n", " 'P20_008845_1894_XN_09N203W.ipf',\n", " 'P03_002371_1888_XI_08N204W.ipf',\n", " 'P01_001540_1889_XI_08N204W.ipf',\n", " 'P01_001606_1897_XI_09N203W.ipf',\n", " 'P03_002226_1895_XI_09N203W.ipf'],\n", " 'IMAGE_SUP': ['P19_008344_1894_XN_09N203W.sup',\n", " 'P20_008845_1894_XN_09N203W.sup',\n", " 'P03_002371_1888_XI_08N204W.sup',\n", " 'P01_001540_1889_XI_08N204W.sup',\n", " 'P01_001606_1897_XI_09N203W.sup',\n", " 'P03_002226_1895_XI_09N203W.sup'],\n", " 'PATH': '/home/tthatcher/Desktop/Projects/Plio/plio/plio/examples/SocetSet',\n", " 'PROJECT': 'D:\\\\data\\\\CTX_Athabasca_Middle.prj'}" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import os\n", "import numpy as np\n", "from plio.examples import get_path\n", "\n", "# 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(get_path(atf_file)) as f:\n", " \n", " atf_file = get_path(atf_file);\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", "read_atf('CTX_Athabasca_Middle_step0.atf')" ] }, { "cell_type": "code", "execution_count": 57, "metadata": {}, "outputs": [], "source": [ "import os\n", "import sys\n", "import math\n", "\n", "sys.path.insert(0, os.path.abspath('/home/tthatcher/Desktop/Projects/Plio/plio'))\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\n", "from plio.io.io_gdal import GeoDataset\n" ] }, { "cell_type": "code", "execution_count": 11, "metadata": {}, "outputs": [], "source": [ "def read_ipf(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", " # TODO: Add unicode conversion\n", "\n", " d = [line.split() for line in open(input_data, 'r')]\n", " d = np.hstack(np.array(d[3:]))\n", " d = d.reshape(-1, 12)\n", "\n", " assert int(cnt) == len(d), 'Dataframe length {} does not match point length {}.'.format(int(cnt), len(df))\n", "\n", " return d\n", "\n", "def read_ipfs(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", "\n", " columns = np.genfromtxt(input_data_list[0], skip_header=2, dtype='unicode',\n", " max_rows = 1, delimiter = ',')\n", "\n", " d_total = []\n", "\n", " for input_file in input_data_list:\n", " d = read_ipf(input_file)\n", " for point in d:\n", " d_total.append(point)\n", "\n", " df = pd.DataFrame(d_total, columns=columns)\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" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "['/home/tthatcher/Desktop/Projects/Plio/plio/plio/examples/SocetSet/P20_008845_1894_XN_09N203W.ipf', '/home/tthatcher/Desktop/Projects/Plio/plio/plio/examples/SocetSet/P03_002371_1888_XI_08N204W.ipf', '/home/tthatcher/Desktop/Projects/Plio/plio/plio/examples/SocetSet/P01_001540_1889_XI_08N204W.ipf', '/home/tthatcher/Desktop/Projects/Plio/plio/plio/examples/SocetSet/P01_001606_1897_XI_09N203W.ipf', '/home/tthatcher/Desktop/Projects/Plio/plio/plio/examples/SocetSet/P03_002226_1895_XI_09N203W.ipf']\n" ] } ], "source": [ "gpf_file = get_path('CTX_Athabasca_Middle.gpf');\n", "\n", "ipf_list = [get_path('P20_008845_1894_XN_09N203W.ipf'),\n", " get_path('P03_002371_1888_XI_08N204W.ipf'),\n", " get_path('P01_001540_1889_XI_08N204W.ipf'),\n", " get_path('P01_001606_1897_XI_09N203W.ipf'),\n", " get_path('P03_002226_1895_XI_09N203W.ipf'),]\n", "\n", "# ipf_list = [get_path('P20_008845_1894_XN_09N203W.ipf')]\n", "\n", "print(ipf_list)\n", "gpf_df = read_gpf(gpf_file).set_index('point_id')\n", "ipf_df = read_ipfs(ipf_list).set_index('pt_id')\n", "# ipf_df.to_csv(\"/Users/adampaquette/repos/plio/plio/examples/SocetSet/P20_008845_1894_XN_09N203W.csv\")" ] }, { "cell_type": "code", "execution_count": 41, "metadata": {}, "outputs": [ { "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>sigma0</th>\n", " <th>sigma1</th>\n", " <th>sigma2</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>-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>-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>-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>-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>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>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>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>-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>18_8344_8845_2r</th>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>-1773.864990</td>\n", " <td>354.084259</td>\n", " <td>0.000000</td>\n", " <td>0.000000</td>\n", " <td>-0.002223</td>\n", " <td>-0.000684</td>\n", " <td>0.0</td>\n", " <td>...</td>\n", " <td>0</td>\n", " <td>0.163515</td>\n", " <td>2.725299</td>\n", " <td>-2608.227033</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>1.000000</td>\n", " <td>-22.636068</td>\n", " <td>54.092590</td>\n", " <td>524.603661</td>\n", " </tr>\n", " <tr>\n", " <th>19_8344_8845_2r_mt_z</th>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>-92.482826</td>\n", " <td>723.305237</td>\n", " <td>0.000000</td>\n", " <td>0.000000</td>\n", " <td>-0.214498</td>\n", " <td>0.145192</td>\n", " <td>0.0</td>\n", " <td>...</td>\n", " <td>1</td>\n", " <td>0.166403</td>\n", " <td>2.724323</td>\n", " <td>-2597.460000</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>2.000000</td>\n", " <td>-42.271359</td>\n", " <td>76.834077</td>\n", " <td>-0.138177</td>\n", " </tr>\n", " <tr>\n", " <th>1_8344_8845_4r</th>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>-4058.982422</td>\n", " <td>-2318.010742</td>\n", " <td>0.000000</td>\n", " <td>0.000000</td>\n", " <td>-0.062556</td>\n", " <td>-0.214713</td>\n", " <td>0.0</td>\n", " <td>...</td>\n", " <td>0</td>\n", " <td>0.160037</td>\n", " <td>2.730339</td>\n", " <td>-2539.150747</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>4.000000</td>\n", " <td>49.937532</td>\n", " <td>-24.131687</td>\n", " <td>639.699743</td>\n", " </tr>\n", " <tr>\n", " <th>1_8344_8845_4r</th>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>-6144.898438</td>\n", " <td>677.674805</td>\n", " <td>0.000000</td>\n", " <td>0.000000</td>\n", " <td>-0.069161</td>\n", " <td>0.311984</td>\n", " <td>0.0</td>\n", " <td>...</td>\n", " <td>0</td>\n", " <td>0.160037</td>\n", " <td>2.730339</td>\n", " <td>-2539.150747</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>4.000000</td>\n", " <td>49.937532</td>\n", " <td>-24.131687</td>\n", " <td>639.699743</td>\n", " </tr>\n", " <tr>\n", " <th>1_8344_8845_4r</th>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>-5284.357910</td>\n", " <td>504.304413</td>\n", " <td>0.000000</td>\n", " <td>0.000000</td>\n", " <td>0.002209</td>\n", " <td>0.194239</td>\n", " <td>0.0</td>\n", " <td>...</td>\n", " <td>0</td>\n", " <td>0.160037</td>\n", " <td>2.730339</td>\n", " <td>-2539.150747</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>4.000000</td>\n", " <td>49.937532</td>\n", " <td>-24.131687</td>\n", " <td>639.699743</td>\n", " </tr>\n", " <tr>\n", " <th>20_8344_8845_2r_mt_z</th>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>1434.079712</td>\n", " <td>742.064026</td>\n", " <td>0.000000</td>\n", " <td>0.000000</td>\n", " <td>-0.058132</td>\n", " <td>-0.171782</td>\n", " <td>0.0</td>\n", " <td>...</td>\n", " <td>1</td>\n", " <td>0.169088</td>\n", " <td>2.723969</td>\n", " <td>-2522.470000</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>2.000000</td>\n", " <td>-56.910236</td>\n", " <td>91.282891</td>\n", " <td>0.161681</td>\n", " </tr>\n", " <tr>\n", " <th>21_8344_8845_4r_xyz</th>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>-838.991028</td>\n", " <td>-614.524109</td>\n", " <td>0.000000</td>\n", " <td>0.000000</td>\n", " <td>-0.131313</td>\n", " <td>0.997120</td>\n", " <td>0.0</td>\n", " <td>...</td>\n", " <td>3</td>\n", " <td>0.165360</td>\n", " <td>2.726740</td>\n", " <td>-2209.490000</td>\n", " <td>2.0</td>\n", " <td>2.0</td>\n", " <td>1.000000</td>\n", " <td>-0.780598</td>\n", " <td>-3.284978</td>\n", " <td>-0.443885</td>\n", " </tr>\n", " <tr>\n", " <th>21_8344_8845_4r_xyz</th>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>-2919.093018</td>\n", " <td>2467.773926</td>\n", " <td>0.000000</td>\n", " <td>0.000000</td>\n", " <td>-0.469767</td>\n", " <td>-0.745137</td>\n", " <td>0.0</td>\n", " <td>...</td>\n", " <td>3</td>\n", " <td>0.165360</td>\n", " <td>2.726740</td>\n", " <td>-2209.490000</td>\n", " <td>2.0</td>\n", " <td>2.0</td>\n", " <td>1.000000</td>\n", " <td>-0.780598</td>\n", " <td>-3.284978</td>\n", " <td>-0.443885</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_16</th>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>2</td>\n", " <td>2865.000000</td>\n", " <td>2024.000000</td>\n", " <td>0.000000</td>\n", " <td>0.000000</td>\n", " <td>-0.053859</td>\n", " <td>0.035981</td>\n", " <td>0.0</td>\n", " <td>...</td>\n", " <td>0</td>\n", " <td>0.171351</td>\n", " <td>2.721519</td>\n", " <td>-2499.843797</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.000000</td>\n", " <td>-43.211361</td>\n", " <td>193.404135</td>\n", " <td>-393.931834</td>\n", " </tr>\n", " <tr>\n", " <th>P20_008845_1894_XN_09N203W_16</th>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>8611.724609</td>\n", " <td>-1352.647949</td>\n", " <td>0.015722</td>\n", " <td>0.015722</td>\n", " <td>-0.153906</td>\n", " <td>-0.039881</td>\n", " <td>0.0</td>\n", " <td>...</td>\n", " <td>0</td>\n", " <td>0.171351</td>\n", " <td>2.721519</td>\n", " <td>-2499.843797</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.000000</td>\n", " <td>-43.211361</td>\n", " <td>193.404135</td>\n", " <td>-393.931834</td>\n", " </tr>\n", " <tr>\n", " <th>P20_008845_1894_XN_09N203W_16</th>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>8914.713867</td>\n", " <td>-1261.989868</td>\n", " <td>0.023530</td>\n", " <td>0.023530</td>\n", " <td>0.691574</td>\n", " <td>-0.075730</td>\n", " <td>0.0</td>\n", " <td>...</td>\n", " <td>0</td>\n", " <td>0.171351</td>\n", " <td>2.721519</td>\n", " <td>-2499.843797</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.000000</td>\n", " <td>-43.211361</td>\n", " <td>193.404135</td>\n", " <td>-393.931834</td>\n", " </tr>\n", " <tr>\n", " <th>P20_008845_1894_XN_09N203W_17</th>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>2</td>\n", " <td>3175.000000</td>\n", " <td>1974.000000</td>\n", " <td>0.000000</td>\n", " <td>0.000000</td>\n", " <td>-0.064058</td>\n", " <td>0.044374</td>\n", " <td>0.0</td>\n", " <td>...</td>\n", " <td>0</td>\n", " <td>0.171907</td>\n", " <td>2.721537</td>\n", " <td>-2504.618390</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.000000</td>\n", " <td>-44.880108</td>\n", " <td>199.649337</td>\n", " <td>-441.559606</td>\n", " </tr>\n", " <tr>\n", " <th>P20_008845_1894_XN_09N203W_17</th>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>8921.941406</td>\n", " <td>-1402.745361</td>\n", " <td>0.017650</td>\n", " <td>0.017650</td>\n", " <td>-0.016220</td>\n", " <td>-0.049595</td>\n", " <td>0.0</td>\n", " <td>...</td>\n", " <td>0</td>\n", " <td>0.171907</td>\n", " <td>2.721537</td>\n", " <td>-2504.618390</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.000000</td>\n", " <td>-44.880108</td>\n", " <td>199.649337</td>\n", " <td>-441.559606</td>\n", " </tr>\n", " <tr>\n", " <th>P20_008845_1894_XN_09N203W_17</th>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>9224.031250</td>\n", " <td>-1309.074219</td>\n", " <td>0.030802</td>\n", " <td>0.030802</td>\n", " <td>0.567955</td>\n", " <td>-0.078411</td>\n", " <td>0.0</td>\n", " <td>...</td>\n", " <td>0</td>\n", " <td>0.171907</td>\n", " <td>2.721537</td>\n", " <td>-2504.618390</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.000000</td>\n", " <td>-44.880108</td>\n", " <td>199.649337</td>\n", " <td>-441.559606</td>\n", " </tr>\n", " <tr>\n", " <th>P20_008845_1894_XN_09N203W_18</th>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>2</td>\n", " <td>2872.000000</td>\n", " <td>1565.000000</td>\n", " <td>0.000000</td>\n", " <td>0.000000</td>\n", " <td>0.256228</td>\n", " <td>0.218860</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_18</th>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>8617.777344</td>\n", " <td>-1818.614380</td>\n", " <td>0.114295</td>\n", " <td>0.114295</td>\n", " <td>-0.500861</td>\n", " <td>-0.252638</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_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>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>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>-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>-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>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>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>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>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>809 rows × 22 columns</p>\n", "</div>" ], "text/plain": [ " val fid_val no_obs l. s. \\\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 -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 -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 -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 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 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 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 -3138.269531 442.515503 \n", "18_8344_8845_2r 1 0 0 -1773.864990 354.084259 \n", "19_8344_8845_2r_mt_z 1 0 0 -92.482826 723.305237 \n", "1_8344_8845_4r 1 0 0 -4058.982422 -2318.010742 \n", "1_8344_8845_4r 1 0 0 -6144.898438 677.674805 \n", "1_8344_8845_4r 1 0 0 -5284.357910 504.304413 \n", "20_8344_8845_2r_mt_z 1 0 0 1434.079712 742.064026 \n", "21_8344_8845_4r_xyz 1 0 0 -838.991028 -614.524109 \n", "21_8344_8845_4r_xyz 1 0 0 -2919.093018 2467.773926 \n", "... ... ... ... ... ... \n", "P20_008845_1894_XN_09N203W_16 1 0 2 2865.000000 2024.000000 \n", "P20_008845_1894_XN_09N203W_16 1 0 1 8611.724609 -1352.647949 \n", "P20_008845_1894_XN_09N203W_16 1 0 1 8914.713867 -1261.989868 \n", "P20_008845_1894_XN_09N203W_17 1 0 2 3175.000000 1974.000000 \n", "P20_008845_1894_XN_09N203W_17 1 0 1 8921.941406 -1402.745361 \n", "P20_008845_1894_XN_09N203W_17 1 0 1 9224.031250 -1309.074219 \n", "P20_008845_1894_XN_09N203W_18 1 0 2 2872.000000 1565.000000 \n", "P20_008845_1894_XN_09N203W_18 1 0 1 8617.777344 -1818.614380 \n", "P20_008845_1894_XN_09N203W_18 1 0 1 8918.806641 -1701.755249 \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 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 -3226.000000 167.000000 \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 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 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 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 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.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.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.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.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.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.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.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.023370 -0.248643 0.0 \n", "18_8344_8845_2r 0.000000 0.000000 -0.002223 -0.000684 0.0 \n", "19_8344_8845_2r_mt_z 0.000000 0.000000 -0.214498 0.145192 0.0 \n", "1_8344_8845_4r 0.000000 0.000000 -0.062556 -0.214713 0.0 \n", "1_8344_8845_4r 0.000000 0.000000 -0.069161 0.311984 0.0 \n", "1_8344_8845_4r 0.000000 0.000000 0.002209 0.194239 0.0 \n", "20_8344_8845_2r_mt_z 0.000000 0.000000 -0.058132 -0.171782 0.0 \n", "21_8344_8845_4r_xyz 0.000000 0.000000 -0.131313 0.997120 0.0 \n", "21_8344_8845_4r_xyz 0.000000 0.000000 -0.469767 -0.745137 0.0 \n", "... ... ... ... ... ... \n", "P20_008845_1894_XN_09N203W_16 0.000000 0.000000 -0.053859 0.035981 0.0 \n", "P20_008845_1894_XN_09N203W_16 0.015722 0.015722 -0.153906 -0.039881 0.0 \n", "P20_008845_1894_XN_09N203W_16 0.023530 0.023530 0.691574 -0.075730 0.0 \n", "P20_008845_1894_XN_09N203W_17 0.000000 0.000000 -0.064058 0.044374 0.0 \n", "P20_008845_1894_XN_09N203W_17 0.017650 0.017650 -0.016220 -0.049595 0.0 \n", "P20_008845_1894_XN_09N203W_17 0.030802 0.030802 0.567955 -0.078411 0.0 \n", "P20_008845_1894_XN_09N203W_18 0.000000 0.000000 0.256228 0.218860 0.0 \n", "P20_008845_1894_XN_09N203W_18 0.114295 0.114295 -0.500861 -0.252638 0.0 \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.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.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.000000 0.000000 -0.195774 -0.000066 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.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.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.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.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", "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", "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", "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", "17_8344_8845_2r_mt_z ... 1 0.161092 2.725426 \n", "18_8344_8845_2r ... 0 0.163515 2.725299 \n", "19_8344_8845_2r_mt_z ... 1 0.166403 2.724323 \n", "1_8344_8845_4r ... 0 0.160037 2.730339 \n", "1_8344_8845_4r ... 0 0.160037 2.730339 \n", "1_8344_8845_4r ... 0 0.160037 2.730339 \n", "20_8344_8845_2r_mt_z ... 1 0.169088 2.723969 \n", "21_8344_8845_4r_xyz ... 3 0.165360 2.726740 \n", "21_8344_8845_4r_xyz ... 3 0.165360 2.726740 \n", "... ... ... ... ... \n", "P20_008845_1894_XN_09N203W_16 ... 0 0.171351 2.721519 \n", "P20_008845_1894_XN_09N203W_16 ... 0 0.171351 2.721519 \n", "P20_008845_1894_XN_09N203W_16 ... 0 0.171351 2.721519 \n", "P20_008845_1894_XN_09N203W_17 ... 0 0.171907 2.721537 \n", "P20_008845_1894_XN_09N203W_17 ... 0 0.171907 2.721537 \n", "P20_008845_1894_XN_09N203W_17 ... 0 0.171907 2.721537 \n", "P20_008845_1894_XN_09N203W_18 ... 0 0.171455 2.722281 \n", "P20_008845_1894_XN_09N203W_18 ... 0 0.171455 2.722281 \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_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_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_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_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 sigma0 sigma1 sigma2 \\\n", "10_8344_8845_4r -2523.828227 0.0 0.0 25.000000 \n", "10_8344_8845_4r -2523.828227 0.0 0.0 25.000000 \n", "10_8344_8845_4r -2523.828227 0.0 0.0 25.000000 \n", "11_8344_8845_4r -2445.237027 0.0 0.0 30.000000 \n", "11_8344_8845_4r -2445.237027 0.0 0.0 30.000000 \n", "11_8344_8845_4r -2445.237027 0.0 0.0 30.000000 \n", "12_8344_8845_4r -2606.935163 0.0 0.0 100.000000 \n", "12_8344_8845_4r -2606.935163 0.0 0.0 100.000000 \n", "12_8344_8845_4r -2606.935163 0.0 0.0 100.000000 \n", "13_8344_8845_4r -2551.901554 0.0 0.0 4.536068 \n", "13_8344_8845_4r -2551.901554 0.0 0.0 4.536068 \n", "13_8344_8845_4r -2551.901554 0.0 0.0 4.536068 \n", "14_8344_8845_4r -2505.953426 0.0 0.0 5.000000 \n", "14_8344_8845_4r -2505.953426 0.0 0.0 5.000000 \n", "14_8344_8845_4r -2505.953426 0.0 0.0 5.000000 \n", "15_8344_8845_4r_mt_z -2502.470000 0.0 0.0 5.000000 \n", "15_8344_8845_4r_mt_z -2502.470000 0.0 0.0 5.000000 \n", "15_8344_8845_4r_mt_z -2502.470000 0.0 0.0 5.000000 \n", "16_8344_8845_4r -2558.312931 0.0 0.0 1.707214 \n", "16_8344_8845_4r -2558.312931 0.0 0.0 1.707214 \n", "16_8344_8845_4r -2558.312931 0.0 0.0 1.707214 \n", "17_8344_8845_2r_mt_z -2590.130000 0.0 0.0 2.000000 \n", "18_8344_8845_2r -2608.227033 0.0 0.0 1.000000 \n", "19_8344_8845_2r_mt_z -2597.460000 0.0 0.0 2.000000 \n", "1_8344_8845_4r -2539.150747 0.0 0.0 4.000000 \n", "1_8344_8845_4r -2539.150747 0.0 0.0 4.000000 \n", "1_8344_8845_4r -2539.150747 0.0 0.0 4.000000 \n", "20_8344_8845_2r_mt_z -2522.470000 0.0 0.0 2.000000 \n", "21_8344_8845_4r_xyz -2209.490000 2.0 2.0 1.000000 \n", "21_8344_8845_4r_xyz -2209.490000 2.0 2.0 1.000000 \n", "... ... ... ... ... \n", "P20_008845_1894_XN_09N203W_16 -2499.843797 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_16 -2499.843797 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_16 -2499.843797 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_17 -2504.618390 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_17 -2504.618390 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_17 -2504.618390 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_18 -2514.431453 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_18 -2514.431453 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_18 -2514.431453 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_2 -2535.712262 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_2 -2535.712262 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_2 -2535.712262 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_3 -2525.215515 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_3 -2525.215515 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_3 -2525.215515 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_4 -2562.446851 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_5 -2560.812028 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_5 -2560.812028 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_6 -2605.266130 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_6 -2605.266130 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_6 -2605.266130 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_7 -2619.498291 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_7 -2619.498291 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_7 -2619.498291 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_8 -2608.028730 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_8 -2608.028730 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_8 -2608.028730 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_9 -2586.686862 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_9 -2586.686862 0.0 0.0 0.000000 \n", "P20_008845_1894_XN_09N203W_9 -2586.686862 0.0 0.0 0.000000 \n", "\n", " res0 res1 res2 \n", "10_8344_8845_4r 18.301328 44.206259 416.201741 \n", "10_8344_8845_4r 18.301328 44.206259 416.201741 \n", "10_8344_8845_4r 18.301328 44.206259 416.201741 \n", "11_8344_8845_4r -22.046575 103.403228 173.210013 \n", "11_8344_8845_4r -22.046575 103.403228 173.210013 \n", "11_8344_8845_4r -22.046575 103.403228 173.210013 \n", "12_8344_8845_4r -7.549561 93.170584 180.058858 \n", "12_8344_8845_4r -7.549561 93.170584 180.058858 \n", "12_8344_8845_4r -7.549561 93.170584 180.058858 \n", "13_8344_8845_4r -1.643694 74.244153 319.554535 \n", "13_8344_8845_4r -1.643694 74.244153 319.554535 \n", "13_8344_8845_4r -1.643694 74.244153 319.554535 \n", "14_8344_8845_4r -50.069808 144.316524 -164.540707 \n", "14_8344_8845_4r -50.069808 144.316524 -164.540707 \n", "14_8344_8845_4r -50.069808 144.316524 -164.540707 \n", "15_8344_8845_4r_mt_z -34.817656 145.864550 0.214023 \n", "15_8344_8845_4r_mt_z -34.817656 145.864550 0.214023 \n", "15_8344_8845_4r_mt_z -34.817656 145.864550 0.214023 \n", "16_8344_8845_4r -29.465246 121.908506 19.874949 \n", "16_8344_8845_4r -29.465246 121.908506 19.874949 \n", "16_8344_8845_4r -29.465246 121.908506 19.874949 \n", "17_8344_8845_2r_mt_z -10.779830 38.761214 0.236077 \n", "18_8344_8845_2r -22.636068 54.092590 524.603661 \n", "19_8344_8845_2r_mt_z -42.271359 76.834077 -0.138177 \n", "1_8344_8845_4r 49.937532 -24.131687 639.699743 \n", "1_8344_8845_4r 49.937532 -24.131687 639.699743 \n", "1_8344_8845_4r 49.937532 -24.131687 639.699743 \n", "20_8344_8845_2r_mt_z -56.910236 91.282891 0.161681 \n", "21_8344_8845_4r_xyz -0.780598 -3.284978 -0.443885 \n", "21_8344_8845_4r_xyz -0.780598 -3.284978 -0.443885 \n", "... ... ... ... \n", "P20_008845_1894_XN_09N203W_16 -43.211361 193.404135 -393.931834 \n", "P20_008845_1894_XN_09N203W_16 -43.211361 193.404135 -393.931834 \n", "P20_008845_1894_XN_09N203W_16 -43.211361 193.404135 -393.931834 \n", "P20_008845_1894_XN_09N203W_17 -44.880108 199.649337 -441.559606 \n", "P20_008845_1894_XN_09N203W_17 -44.880108 199.649337 -441.559606 \n", "P20_008845_1894_XN_09N203W_17 -44.880108 199.649337 -441.559606 \n", "P20_008845_1894_XN_09N203W_18 -38.388316 195.050373 -391.289238 \n", "P20_008845_1894_XN_09N203W_18 -38.388316 195.050373 -391.289238 \n", "P20_008845_1894_XN_09N203W_18 -38.388316 195.050373 -391.289238 \n", "P20_008845_1894_XN_09N203W_2 42.067289 -12.658160 627.742625 \n", "P20_008845_1894_XN_09N203W_2 42.067289 -12.658160 627.742625 \n", "P20_008845_1894_XN_09N203W_2 42.067289 -12.658160 627.742625 \n", "P20_008845_1894_XN_09N203W_3 36.033823 -4.170818 616.480181 \n", "P20_008845_1894_XN_09N203W_3 36.033823 -4.170818 616.480181 \n", "P20_008845_1894_XN_09N203W_3 36.033823 -4.170818 616.480181 \n", "P20_008845_1894_XN_09N203W_4 -7.233876 33.324946 574.887719 \n", "P20_008845_1894_XN_09N203W_5 7.498790 33.109007 581.149470 \n", "P20_008845_1894_XN_09N203W_5 7.498790 33.109007 581.149470 \n", "P20_008845_1894_XN_09N203W_6 7.687475 59.859663 375.680663 \n", "P20_008845_1894_XN_09N203W_6 7.687475 59.859663 375.680663 \n", "P20_008845_1894_XN_09N203W_6 7.687475 59.859663 375.680663 \n", "P20_008845_1894_XN_09N203W_7 6.358447 61.278242 375.840988 \n", "P20_008845_1894_XN_09N203W_7 6.358447 61.278242 375.840988 \n", "P20_008845_1894_XN_09N203W_7 6.358447 61.278242 375.840988 \n", "P20_008845_1894_XN_09N203W_8 -0.219662 71.414267 336.409684 \n", "P20_008845_1894_XN_09N203W_8 -0.219662 71.414267 336.409684 \n", "P20_008845_1894_XN_09N203W_8 -0.219662 71.414267 336.409684 \n", "P20_008845_1894_XN_09N203W_9 15.191825 22.094037 544.874936 \n", "P20_008845_1894_XN_09N203W_9 15.191825 22.094037 544.874936 \n", "P20_008845_1894_XN_09N203W_9 15.191825 22.094037 544.874936 \n", "\n", "[809 rows x 22 columns]" ] }, "execution_count": 41, "metadata": {}, "output_type": "execute_result" } ], "source": [ "new_df = ipf_df.merge(gpf_df, left_index=True, right_index=True)\n", "# print(new_df.columns)\n", "new_df.index('')" ] }, { "cell_type": "code", "execution_count": 52, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "P20_008845_1894_XN_09N203W_7\n" ] }, { "ename": "IndexError", "evalue": "only integers, slices (`:`), ellipsis (`...`), numpy.newaxis (`None`) and integer or boolean arrays are valid indices", "output_type": "error", "traceback": [ "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m", "\u001b[0;31mIndexError\u001b[0m Traceback (most recent call last)", "\u001b[0;32m<ipython-input-52-9c95896b4ea2>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m 4\u001b[0m \u001b[0msup_dict\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m{\u001b[0m\u001b[0;34m}\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 5\u001b[0m \u001b[0;32mfor\u001b[0m \u001b[0mfiles\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mfiles_dict\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 6\u001b[0;31m \u001b[0mprint\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mnew_df\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mfiles\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msplit\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'.sup'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m 7\u001b[0m \u001b[0msup_dict\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mfiles\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msplit\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'.sup'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mnew_df\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mfiles\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msplit\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'.sup'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 8\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n", "\u001b[0;32m~/anaconda3/envs/autocnet/lib/python3.6/site-packages/pandas/core/indexes/base.py\u001b[0m in \u001b[0;36m__getitem__\u001b[0;34m(self, key)\u001b[0m\n\u001b[1;32m 1741\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 1742\u001b[0m \u001b[0;32mif\u001b[0m \u001b[0mis_scalar\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1743\u001b[0;31m \u001b[0;32mreturn\u001b[0m \u001b[0mgetitem\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m 1744\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 1745\u001b[0m \u001b[0;32mif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mslice\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n", "\u001b[0;31mIndexError\u001b[0m: only integers, slices (`:`), ellipsis (`...`), numpy.newaxis (`None`) and integer or boolean arrays are valid indices" ] } ], "source": [ "files_dict = read_atf('CTX_Athabasca_Middle_step0.atf')['IMAGE_SUP']\n", "\n", "lines_samples_dict = {}\n", "for key in files_dict:\n", " with open(key) as f:\n", " if f[0:5] == 'LINES':\n", " lines_samples_dict[]\n", " if f[0:7] == 'SAMPLES':\n", " lines_samples_dict\n", "print(new_df.index[800])\n", "sup_dict = {}\n", "for index in new_df['l.']:\n", " if index in files_dict:\n", " new_df['l.'] = \n", "\n", "print(sup_dict)\n", " \n", " atf_file = get_path(atf_file);\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)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "diff = ipf_df.index.difference(pd.unique(gpf_df.index))\n", "\n", "total_similar = 0\n", "for i in gpf_df.index:\n", " for j in pd.unique(ipf_df.index):\n", " if i == j:\n", " total_similar += 1\n", "diff" ] }, { "cell_type": "code", "execution_count": 61, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "GEOGCS[\"unnamed ellipse\",\n", " DATUM[\"unknown\",\n", " SPHEROID[\"Unknown\",1737400,0]],\n", " PRIMEM[\"Greenwich\",0],\n", " UNIT[\"Degree\",0.017453292519943295]]\n", "GEOGCS[\"unnamed ellipse\",\n", " DATUM[\"unknown\",\n", " SPHEROID[\"Unknown\",1737400,0]],\n", " PRIMEM[\"Greenwich\",0],\n", " UNIT[\"Degree\",0.017453292519943295]]\n" ] } ], "source": [ "\n", "# double ToPlanetocentric3(const double lattitude, double eRadius, double pRadius)\n", "# {\n", "\n", "# double mylat = (lattitude-90.0)*DegToRad;\n", "# if(fabs(mylat)<90.0)\n", "# {\n", "# mylat = atan((tan(mylat) * (pRadius/eRadius) * (pRadius/eRadius)) );\n", "# }\n", "# return (mylat*RadToDeg)+90.0;\n", "# }\n", "\n", "\n", "\n", "# double ToPlanetocentric4(const double lattitude, double eRadius, double pRadius)\n", "# {\n", "\n", "# double mylat = (lattitude-90.0)*DegToRad;\n", "# if(fabs(mylat)<90.0)\n", "# {\n", "# double oe = acos(pRadius/eRadius);\n", "# double csqrd = cos(oe)*cos(oe);\n", "# mylat = atan(csqrd*tan(mylat));\n", "# }\n", "# return (mylat*RadToDeg)+90.0;\n", "# }\n", "\n", "\n", "test = GeoDataset('/home/tthatcher/Desktop/Projects/Plio/plio/plio/examples/Apollo15/AS15-M-0295_SML_geo.tif')\n", "\n", "print(test.spatial_reference)\n", "print(test.geospatial_coordinate_system)\n", "def ToPlanetocentric3(lat, eRadius, pRadius):\n", " mylat = math.radians(lat - 90.0)\n", " \n", " if(math.fabs(mylat) < 90.0):\n", " mylat = math.atan(math.tan(mylat) * (pRadius/eRadius) * (pRadius/eRadius))\n", " \n", " return math.degrees(mylat) + 90.0\n", "\n", "def ToPlanetocentric4(lat, eRadius, pRadius):\n", " mylat = math.radians(lat - 90.0)\n", " \n", " if(math.fabs(mylat) < 90.0):\n", " oe = math.acos(pRadius/eRadius)\n", " cos_squared = math.cos(oe)**2\n", " mylat = math.atan(cos_squared*(math.tan(mylat)))\n", " \n", " return math.degrees(mylat) + 90.0" ] }, { "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.4" } }, "nbformat": 4, "nbformat_minor": 2 }