LS8_derive_metadata.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "coated-junior",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "serious-offering",
   "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>PANCHROMATIC_LINES</th>\n",
       "      <th>NADIR_OFFNADIR</th>\n",
       "      <th>sunAzimuth</th>\n",
       "      <th>REFLECTIVE_SAMPLES</th>\n",
       "      <th>upperLeftCornerLongitude</th>\n",
       "      <th>cloudCover</th>\n",
       "      <th>MAP_PROJECTION_L1</th>\n",
       "      <th>cartURL</th>\n",
       "      <th>sunElevation</th>\n",
       "      <th>path</th>\n",
       "      <th>...</th>\n",
       "      <th>UTM_ZONE</th>\n",
       "      <th>DATE_L1_GENERATED</th>\n",
       "      <th>GRID_CELL_SIZE_THERMAL</th>\n",
       "      <th>DATUM</th>\n",
       "      <th>COLLECTION_NUMBER</th>\n",
       "      <th>sceneID</th>\n",
       "      <th>RLUT_FILE_NAME</th>\n",
       "      <th>TIRS_SSM_MODEL</th>\n",
       "      <th>ROLL_ANGLE</th>\n",
       "      <th>receivingStation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>16421</td>\n",
       "      <td>NADIR</td>\n",
       "      <td>165.369189</td>\n",
       "      <td>8141</td>\n",
       "      <td>-9.10626</td>\n",
       "      <td>89.12</td>\n",
       "      <td>UTM</td>\n",
       "      <td>https://earthexplorer.usgs.gov/download/extern...</td>\n",
       "      <td>38.464228</td>\n",
       "      <td>210</td>\n",
       "      <td>...</td>\n",
       "      <td>29.0</td>\n",
       "      <td>2021/04/24</td>\n",
       "      <td>30.0</td>\n",
       "      <td>WGS84</td>\n",
       "      <td>1</td>\n",
       "      <td>LC82100172021107LGN00</td>\n",
       "      <td>LC08RLUT_20150303_20431231_01_12.h5</td>\n",
       "      <td>FINAL</td>\n",
       "      <td>-0.001</td>\n",
       "      <td>LGN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>18301</td>\n",
       "      <td>NADIR</td>\n",
       "      <td>-166.955693</td>\n",
       "      <td>9141</td>\n",
       "      <td>66.92023</td>\n",
       "      <td>72.99</td>\n",
       "      <td>UTM</td>\n",
       "      <td>https://earthexplorer.usgs.gov/download/extern...</td>\n",
       "      <td>26.271118</td>\n",
       "      <td>177</td>\n",
       "      <td>...</td>\n",
       "      <td>42.0</td>\n",
       "      <td>2021/04/26</td>\n",
       "      <td>30.0</td>\n",
       "      <td>WGS84</td>\n",
       "      <td>1</td>\n",
       "      <td>LC81770052021116LGN00</td>\n",
       "      <td>LC08RLUT_20150303_20431231_01_12.h5</td>\n",
       "      <td>PRELIMINARY</td>\n",
       "      <td>-0.001</td>\n",
       "      <td>LGN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>15521</td>\n",
       "      <td>NADIR</td>\n",
       "      <td>100.415204</td>\n",
       "      <td>7601</td>\n",
       "      <td>109.66973</td>\n",
       "      <td>4.68</td>\n",
       "      <td>UTM</td>\n",
       "      <td>https://earthexplorer.usgs.gov/download/extern...</td>\n",
       "      <td>65.359843</td>\n",
       "      <td>123</td>\n",
       "      <td>...</td>\n",
       "      <td>49.0</td>\n",
       "      <td>2021/04/24</td>\n",
       "      <td>30.0</td>\n",
       "      <td>WGS84</td>\n",
       "      <td>1</td>\n",
       "      <td>LC81230492021106LGN00</td>\n",
       "      <td>LC08RLUT_20150303_20431231_01_12.h5</td>\n",
       "      <td>FINAL</td>\n",
       "      <td>-0.001</td>\n",
       "      <td>LGN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>15521</td>\n",
       "      <td>NADIR</td>\n",
       "      <td>81.338761</td>\n",
       "      <td>7601</td>\n",
       "      <td>139.00425</td>\n",
       "      <td>15.27</td>\n",
       "      <td>UTM</td>\n",
       "      <td>https://earthexplorer.usgs.gov/download/extern...</td>\n",
       "      <td>64.746171</td>\n",
       "      <td>103</td>\n",
       "      <td>...</td>\n",
       "      <td>54.0</td>\n",
       "      <td>2021/04/20</td>\n",
       "      <td>30.0</td>\n",
       "      <td>WGS84</td>\n",
       "      <td>1</td>\n",
       "      <td>LC81030542021110LGN00</td>\n",
       "      <td>LC08RLUT_20150303_20431231_01_12.h5</td>\n",
       "      <td>PRELIMINARY</td>\n",
       "      <td>-0.001</td>\n",
       "      <td>LGN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16441</td>\n",
       "      <td>NADIR</td>\n",
       "      <td>-42.486171</td>\n",
       "      <td>8151</td>\n",
       "      <td>-15.07552</td>\n",
       "      <td>-1.00</td>\n",
       "      <td>UTM</td>\n",
       "      <td>https://earthexplorer.usgs.gov/download/extern...</td>\n",
       "      <td>-5.475457</td>\n",
       "      <td>65</td>\n",
       "      <td>...</td>\n",
       "      <td>28.0</td>\n",
       "      <td>2021/04/26</td>\n",
       "      <td>30.0</td>\n",
       "      <td>WGS84</td>\n",
       "      <td>1</td>\n",
       "      <td>LC80652292021115LGN00</td>\n",
       "      <td>LC08RLUT_20150303_20431231_01_12.h5</td>\n",
       "      <td>PRELIMINARY</td>\n",
       "      <td>0.000</td>\n",
       "      <td>LGN</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>2019206</th>\n",
       "      <td>14721</td>\n",
       "      <td>NADIR</td>\n",
       "      <td>122.646934</td>\n",
       "      <td>7371</td>\n",
       "      <td>73.42087</td>\n",
       "      <td>1.78</td>\n",
       "      <td>UTM</td>\n",
       "      <td>https://earthexplorer.usgs.gov/download/extern...</td>\n",
       "      <td>60.008115</td>\n",
       "      <td>147</td>\n",
       "      <td>...</td>\n",
       "      <td>43.0</td>\n",
       "      <td>2017/05/05</td>\n",
       "      <td>30.0</td>\n",
       "      <td>WGS84</td>\n",
       "      <td>1</td>\n",
       "      <td>LC81470462013086LGN02</td>\n",
       "      <td>LC08RLUT_20130211_20150302_01_11.h5</td>\n",
       "      <td>ACTUAL</td>\n",
       "      <td>-0.001</td>\n",
       "      <td>LGN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019207</th>\n",
       "      <td>14561</td>\n",
       "      <td>NADIR</td>\n",
       "      <td>107.563683</td>\n",
       "      <td>7301</td>\n",
       "      <td>40.35394</td>\n",
       "      <td>3.12</td>\n",
       "      <td>UTM</td>\n",
       "      <td>https://earthexplorer.usgs.gov/download/extern...</td>\n",
       "      <td>64.234579</td>\n",
       "      <td>168</td>\n",
       "      <td>...</td>\n",
       "      <td>37.0</td>\n",
       "      <td>2017/05/05</td>\n",
       "      <td>30.0</td>\n",
       "      <td>WGS84</td>\n",
       "      <td>1</td>\n",
       "      <td>LC81680492013097LGN02</td>\n",
       "      <td>LC08RLUT_20130211_20150302_01_11.h5</td>\n",
       "      <td>ACTUAL</td>\n",
       "      <td>-0.001</td>\n",
       "      <td>LGN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019208</th>\n",
       "      <td>14581</td>\n",
       "      <td>NADIR</td>\n",
       "      <td>132.615192</td>\n",
       "      <td>7311</td>\n",
       "      <td>-109.92687</td>\n",
       "      <td>24.15</td>\n",
       "      <td>UTM</td>\n",
       "      <td>https://earthexplorer.usgs.gov/download/extern...</td>\n",
       "      <td>55.073707</td>\n",
       "      <td>33</td>\n",
       "      <td>...</td>\n",
       "      <td>12.0</td>\n",
       "      <td>2017/03/10</td>\n",
       "      <td>30.0</td>\n",
       "      <td>WGS84</td>\n",
       "      <td>1</td>\n",
       "      <td>LC80330432013077LGN02</td>\n",
       "      <td>LC08RLUT_20130211_20150302_01_11.h5</td>\n",
       "      <td>ACTUAL</td>\n",
       "      <td>-0.001</td>\n",
       "      <td>LGN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019209</th>\n",
       "      <td>14621</td>\n",
       "      <td>NADIR</td>\n",
       "      <td>54.324400</td>\n",
       "      <td>7391</td>\n",
       "      <td>31.74148</td>\n",
       "      <td>34.17</td>\n",
       "      <td>UTM</td>\n",
       "      <td>https://earthexplorer.usgs.gov/download/extern...</td>\n",
       "      <td>51.859541</td>\n",
       "      <td>169</td>\n",
       "      <td>...</td>\n",
       "      <td>36.0</td>\n",
       "      <td>2017/05/05</td>\n",
       "      <td>30.0</td>\n",
       "      <td>WGS84</td>\n",
       "      <td>1</td>\n",
       "      <td>LC81690732013092LGN02</td>\n",
       "      <td>LC08RLUT_20130211_20150302_01_11.h5</td>\n",
       "      <td>ACTUAL</td>\n",
       "      <td>-0.001</td>\n",
       "      <td>LGN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019210</th>\n",
       "      <td>14521</td>\n",
       "      <td>NADIR</td>\n",
       "      <td>110.384868</td>\n",
       "      <td>7281</td>\n",
       "      <td>29.65372</td>\n",
       "      <td>0.00</td>\n",
       "      <td>UTM</td>\n",
       "      <td>https://earthexplorer.usgs.gov/download/extern...</td>\n",
       "      <td>63.329988</td>\n",
       "      <td>175</td>\n",
       "      <td>...</td>\n",
       "      <td>35.0</td>\n",
       "      <td>2017/05/05</td>\n",
       "      <td>30.0</td>\n",
       "      <td>WGS84</td>\n",
       "      <td>1</td>\n",
       "      <td>LC81750492013093LGN02</td>\n",
       "      <td>LC08RLUT_20130211_20150302_01_11.h5</td>\n",
       "      <td>ACTUAL</td>\n",
       "      <td>-0.001</td>\n",
       "      <td>LGN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2019211 rows × 59 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         PANCHROMATIC_LINES NADIR_OFFNADIR  sunAzimuth  REFLECTIVE_SAMPLES  \\\n",
       "0                     16421          NADIR  165.369189                8141   \n",
       "1                     18301          NADIR -166.955693                9141   \n",
       "2                     15521          NADIR  100.415204                7601   \n",
       "3                     15521          NADIR   81.338761                7601   \n",
       "4                     16441          NADIR  -42.486171                8151   \n",
       "...                     ...            ...         ...                 ...   \n",
       "2019206               14721          NADIR  122.646934                7371   \n",
       "2019207               14561          NADIR  107.563683                7301   \n",
       "2019208               14581          NADIR  132.615192                7311   \n",
       "2019209               14621          NADIR   54.324400                7391   \n",
       "2019210               14521          NADIR  110.384868                7281   \n",
       "\n",
       "         upperLeftCornerLongitude  cloudCover MAP_PROJECTION_L1  \\\n",
       "0                        -9.10626       89.12               UTM   \n",
       "1                        66.92023       72.99               UTM   \n",
       "2                       109.66973        4.68               UTM   \n",
       "3                       139.00425       15.27               UTM   \n",
       "4                       -15.07552       -1.00               UTM   \n",
       "...                           ...         ...               ...   \n",
       "2019206                  73.42087        1.78               UTM   \n",
       "2019207                  40.35394        3.12               UTM   \n",
       "2019208                -109.92687       24.15               UTM   \n",
       "2019209                  31.74148       34.17               UTM   \n",
       "2019210                  29.65372        0.00               UTM   \n",
       "\n",
       "                                                   cartURL  sunElevation  \\\n",
       "0        https://earthexplorer.usgs.gov/download/extern...     38.464228   \n",
       "1        https://earthexplorer.usgs.gov/download/extern...     26.271118   \n",
       "2        https://earthexplorer.usgs.gov/download/extern...     65.359843   \n",
       "3        https://earthexplorer.usgs.gov/download/extern...     64.746171   \n",
       "4        https://earthexplorer.usgs.gov/download/extern...     -5.475457   \n",
       "...                                                    ...           ...   \n",
       "2019206  https://earthexplorer.usgs.gov/download/extern...     60.008115   \n",
       "2019207  https://earthexplorer.usgs.gov/download/extern...     64.234579   \n",
       "2019208  https://earthexplorer.usgs.gov/download/extern...     55.073707   \n",
       "2019209  https://earthexplorer.usgs.gov/download/extern...     51.859541   \n",
       "2019210  https://earthexplorer.usgs.gov/download/extern...     63.329988   \n",
       "\n",
       "         path  ... UTM_ZONE  DATE_L1_GENERATED  GRID_CELL_SIZE_THERMAL  DATUM  \\\n",
       "0         210  ...     29.0         2021/04/24                    30.0  WGS84   \n",
       "1         177  ...     42.0         2021/04/26                    30.0  WGS84   \n",
       "2         123  ...     49.0         2021/04/24                    30.0  WGS84   \n",
       "3         103  ...     54.0         2021/04/20                    30.0  WGS84   \n",
       "4          65  ...     28.0         2021/04/26                    30.0  WGS84   \n",
       "...       ...  ...      ...                ...                     ...    ...   \n",
       "2019206   147  ...     43.0         2017/05/05                    30.0  WGS84   \n",
       "2019207   168  ...     37.0         2017/05/05                    30.0  WGS84   \n",
       "2019208    33  ...     12.0         2017/03/10                    30.0  WGS84   \n",
       "2019209   169  ...     36.0         2017/05/05                    30.0  WGS84   \n",
       "2019210   175  ...     35.0         2017/05/05                    30.0  WGS84   \n",
       "\n",
       "         COLLECTION_NUMBER                sceneID  \\\n",
       "0                        1  LC82100172021107LGN00   \n",
       "1                        1  LC81770052021116LGN00   \n",
       "2                        1  LC81230492021106LGN00   \n",
       "3                        1  LC81030542021110LGN00   \n",
       "4                        1  LC80652292021115LGN00   \n",
       "...                    ...                    ...   \n",
       "2019206                  1  LC81470462013086LGN02   \n",
       "2019207                  1  LC81680492013097LGN02   \n",
       "2019208                  1  LC80330432013077LGN02   \n",
       "2019209                  1  LC81690732013092LGN02   \n",
       "2019210                  1  LC81750492013093LGN02   \n",
       "\n",
       "                              RLUT_FILE_NAME  TIRS_SSM_MODEL ROLL_ANGLE  \\\n",
       "0        LC08RLUT_20150303_20431231_01_12.h5           FINAL     -0.001   \n",
       "1        LC08RLUT_20150303_20431231_01_12.h5     PRELIMINARY     -0.001   \n",
       "2        LC08RLUT_20150303_20431231_01_12.h5           FINAL     -0.001   \n",
       "3        LC08RLUT_20150303_20431231_01_12.h5     PRELIMINARY     -0.001   \n",
       "4        LC08RLUT_20150303_20431231_01_12.h5     PRELIMINARY      0.000   \n",
       "...                                      ...             ...        ...   \n",
       "2019206  LC08RLUT_20130211_20150302_01_11.h5          ACTUAL     -0.001   \n",
       "2019207  LC08RLUT_20130211_20150302_01_11.h5          ACTUAL     -0.001   \n",
       "2019208  LC08RLUT_20130211_20150302_01_11.h5          ACTUAL     -0.001   \n",
       "2019209  LC08RLUT_20130211_20150302_01_11.h5          ACTUAL     -0.001   \n",
       "2019210  LC08RLUT_20130211_20150302_01_11.h5          ACTUAL     -0.001   \n",
       "\n",
       "        receivingStation  \n",
       "0                    LGN  \n",
       "1                    LGN  \n",
       "2                    LGN  \n",
       "3                    LGN  \n",
       "4                    LGN  \n",
       "...                  ...  \n",
       "2019206              LGN  \n",
       "2019207              LGN  \n",
       "2019208              LGN  \n",
       "2019209              LGN  \n",
       "2019210              LGN  \n",
       "\n",
       "[2019211 rows x 59 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filename = '/home/whyj/Downloads/LANDSAT_8_C1.csv'\n",
    "ls_pd = pd.read_csv(filename)\n",
    "ls_pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "northern-stability",
   "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>path</th>\n",
       "      <th>row</th>\n",
       "      <th>dateUpdated</th>\n",
       "      <th>sceneCenterLatitude</th>\n",
       "      <th>sceneCenterLongitude</th>\n",
       "      <th>upperLeftCornerLatitude</th>\n",
       "      <th>upperLeftCornerLongitude</th>\n",
       "      <th>upperRightCornerLatitude</th>\n",
       "      <th>upperRightCornerLongitude</th>\n",
       "      <th>lowerLeftCornerLatitude</th>\n",
       "      <th>lowerLeftCornerLongitude</th>\n",
       "      <th>lowerRightCornerLatitude</th>\n",
       "      <th>lowerRightCornerLongitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>210</td>\n",
       "      <td>17</td>\n",
       "      <td>2021-04-17</td>\n",
       "      <td>61.47758</td>\n",
       "      <td>-7.95417</td>\n",
       "      <td>62.57978</td>\n",
       "      <td>-9.10626</td>\n",
       "      <td>62.00515</td>\n",
       "      <td>-5.61109</td>\n",
       "      <td>60.91112</td>\n",
       "      <td>-10.22054</td>\n",
       "      <td>60.35671</td>\n",
       "      <td>-6.89235</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>177</td>\n",
       "      <td>5</td>\n",
       "      <td>2021-04-26</td>\n",
       "      <td>77.04827</td>\n",
       "      <td>67.44124</td>\n",
       "      <td>78.27005</td>\n",
       "      <td>66.92023</td>\n",
       "      <td>77.10836</td>\n",
       "      <td>72.93033</td>\n",
       "      <td>76.87620</td>\n",
       "      <td>62.03930</td>\n",
       "      <td>75.81836</td>\n",
       "      <td>67.83805</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>123</td>\n",
       "      <td>49</td>\n",
       "      <td>2021-04-16</td>\n",
       "      <td>15.90110</td>\n",
       "      <td>110.34845</td>\n",
       "      <td>16.94572</td>\n",
       "      <td>109.66973</td>\n",
       "      <td>16.58249</td>\n",
       "      <td>111.41380</td>\n",
       "      <td>15.21175</td>\n",
       "      <td>109.28913</td>\n",
       "      <td>14.84632</td>\n",
       "      <td>111.01795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>103</td>\n",
       "      <td>54</td>\n",
       "      <td>2021-04-20</td>\n",
       "      <td>8.67674</td>\n",
       "      <td>139.66503</td>\n",
       "      <td>9.72127</td>\n",
       "      <td>139.00425</td>\n",
       "      <td>9.36183</td>\n",
       "      <td>140.69847</td>\n",
       "      <td>7.98567</td>\n",
       "      <td>138.63429</td>\n",
       "      <td>7.62350</td>\n",
       "      <td>140.32051</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>65</td>\n",
       "      <td>229</td>\n",
       "      <td>2021-04-25</td>\n",
       "      <td>64.22507</td>\n",
       "      <td>-17.59075</td>\n",
       "      <td>63.69161</td>\n",
       "      <td>-15.07552</td>\n",
       "      <td>63.09638</td>\n",
       "      <td>-18.68818</td>\n",
       "      <td>65.34585</td>\n",
       "      <td>-16.39431</td>\n",
       "      <td>64.72394</td>\n",
       "      <td>-20.20717</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019206</th>\n",
       "      <td>147</td>\n",
       "      <td>46</td>\n",
       "      <td>2013-03-27</td>\n",
       "      <td>20.22992</td>\n",
       "      <td>74.10165</td>\n",
       "      <td>21.21733</td>\n",
       "      <td>73.42087</td>\n",
       "      <td>20.85981</td>\n",
       "      <td>75.15874</td>\n",
       "      <td>19.59127</td>\n",
       "      <td>73.05189</td>\n",
       "      <td>19.23194</td>\n",
       "      <td>74.77135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019207</th>\n",
       "      <td>168</td>\n",
       "      <td>49</td>\n",
       "      <td>2013-04-07</td>\n",
       "      <td>15.90114</td>\n",
       "      <td>41.01951</td>\n",
       "      <td>16.88786</td>\n",
       "      <td>40.35394</td>\n",
       "      <td>16.53377</td>\n",
       "      <td>42.04875</td>\n",
       "      <td>15.26091</td>\n",
       "      <td>39.99546</td>\n",
       "      <td>14.90459</td>\n",
       "      <td>41.67652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019208</th>\n",
       "      <td>33</td>\n",
       "      <td>43</td>\n",
       "      <td>2013-03-18</td>\n",
       "      <td>24.55321</td>\n",
       "      <td>-109.22543</td>\n",
       "      <td>25.54136</td>\n",
       "      <td>-109.92687</td>\n",
       "      <td>25.17861</td>\n",
       "      <td>-108.13116</td>\n",
       "      <td>23.91774</td>\n",
       "      <td>-110.31007</td>\n",
       "      <td>23.55370</td>\n",
       "      <td>-108.53799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019209</th>\n",
       "      <td>169</td>\n",
       "      <td>73</td>\n",
       "      <td>2013-04-02</td>\n",
       "      <td>-18.78731</td>\n",
       "      <td>32.41698</td>\n",
       "      <td>-17.79754</td>\n",
       "      <td>31.74148</td>\n",
       "      <td>-18.15630</td>\n",
       "      <td>33.46451</td>\n",
       "      <td>-19.41717</td>\n",
       "      <td>31.36073</td>\n",
       "      <td>-19.78035</td>\n",
       "      <td>33.10079</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019210</th>\n",
       "      <td>175</td>\n",
       "      <td>49</td>\n",
       "      <td>2013-04-03</td>\n",
       "      <td>15.90090</td>\n",
       "      <td>30.31955</td>\n",
       "      <td>16.88783</td>\n",
       "      <td>29.65372</td>\n",
       "      <td>16.53360</td>\n",
       "      <td>31.34925</td>\n",
       "      <td>15.26071</td>\n",
       "      <td>29.29524</td>\n",
       "      <td>14.90426</td>\n",
       "      <td>30.97694</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2019211 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         path  row dateUpdated  sceneCenterLatitude  sceneCenterLongitude  \\\n",
       "0         210   17  2021-04-17             61.47758              -7.95417   \n",
       "1         177    5  2021-04-26             77.04827              67.44124   \n",
       "2         123   49  2021-04-16             15.90110             110.34845   \n",
       "3         103   54  2021-04-20              8.67674             139.66503   \n",
       "4          65  229  2021-04-25             64.22507             -17.59075   \n",
       "...       ...  ...         ...                  ...                   ...   \n",
       "2019206   147   46  2013-03-27             20.22992              74.10165   \n",
       "2019207   168   49  2013-04-07             15.90114              41.01951   \n",
       "2019208    33   43  2013-03-18             24.55321            -109.22543   \n",
       "2019209   169   73  2013-04-02            -18.78731              32.41698   \n",
       "2019210   175   49  2013-04-03             15.90090              30.31955   \n",
       "\n",
       "         upperLeftCornerLatitude  upperLeftCornerLongitude  \\\n",
       "0                       62.57978                  -9.10626   \n",
       "1                       78.27005                  66.92023   \n",
       "2                       16.94572                 109.66973   \n",
       "3                        9.72127                 139.00425   \n",
       "4                       63.69161                 -15.07552   \n",
       "...                          ...                       ...   \n",
       "2019206                 21.21733                  73.42087   \n",
       "2019207                 16.88786                  40.35394   \n",
       "2019208                 25.54136                -109.92687   \n",
       "2019209                -17.79754                  31.74148   \n",
       "2019210                 16.88783                  29.65372   \n",
       "\n",
       "         upperRightCornerLatitude  upperRightCornerLongitude  \\\n",
       "0                        62.00515                   -5.61109   \n",
       "1                        77.10836                   72.93033   \n",
       "2                        16.58249                  111.41380   \n",
       "3                         9.36183                  140.69847   \n",
       "4                        63.09638                  -18.68818   \n",
       "...                           ...                        ...   \n",
       "2019206                  20.85981                   75.15874   \n",
       "2019207                  16.53377                   42.04875   \n",
       "2019208                  25.17861                 -108.13116   \n",
       "2019209                 -18.15630                   33.46451   \n",
       "2019210                  16.53360                   31.34925   \n",
       "\n",
       "         lowerLeftCornerLatitude  lowerLeftCornerLongitude  \\\n",
       "0                       60.91112                 -10.22054   \n",
       "1                       76.87620                  62.03930   \n",
       "2                       15.21175                 109.28913   \n",
       "3                        7.98567                 138.63429   \n",
       "4                       65.34585                 -16.39431   \n",
       "...                          ...                       ...   \n",
       "2019206                 19.59127                  73.05189   \n",
       "2019207                 15.26091                  39.99546   \n",
       "2019208                 23.91774                -110.31007   \n",
       "2019209                -19.41717                  31.36073   \n",
       "2019210                 15.26071                  29.29524   \n",
       "\n",
       "         lowerRightCornerLatitude  lowerRightCornerLongitude  \n",
       "0                        60.35671                   -6.89235  \n",
       "1                        75.81836                   67.83805  \n",
       "2                        14.84632                  111.01795  \n",
       "3                         7.62350                  140.32051  \n",
       "4                        64.72394                  -20.20717  \n",
       "...                           ...                        ...  \n",
       "2019206                  19.23194                   74.77135  \n",
       "2019207                  14.90459                   41.67652  \n",
       "2019208                  23.55370                 -108.53799  \n",
       "2019209                 -19.78035                   33.10079  \n",
       "2019210                  14.90426                   30.97694  \n",
       "\n",
       "[2019211 rows x 13 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "target_columns = ['path', 'row', 'dateUpdated', 'sceneCenterLatitude', 'sceneCenterLongitude', 'upperLeftCornerLatitude', 'upperLeftCornerLongitude', 'upperRightCornerLatitude', 'upperRightCornerLongitude', 'lowerLeftCornerLatitude', 'lowerLeftCornerLongitude', 'lowerRightCornerLatitude', 'lowerRightCornerLongitude']\n",
    "ls_pd_s = ls_pd[target_columns]\n",
    "ls_pd_s"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "radical-liverpool",
   "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>path</th>\n",
       "      <th>row</th>\n",
       "      <th>dateUpdated</th>\n",
       "      <th>sceneCenterLatitude</th>\n",
       "      <th>sceneCenterLongitude</th>\n",
       "      <th>upperLeftCornerLatitude</th>\n",
       "      <th>upperLeftCornerLongitude</th>\n",
       "      <th>upperRightCornerLatitude</th>\n",
       "      <th>upperRightCornerLongitude</th>\n",
       "      <th>lowerLeftCornerLatitude</th>\n",
       "      <th>lowerLeftCornerLongitude</th>\n",
       "      <th>lowerRightCornerLatitude</th>\n",
       "      <th>lowerRightCornerLongitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4766</th>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>2021-04-17</td>\n",
       "      <td>69.60650</td>\n",
       "      <td>-49.43347</td>\n",
       "      <td>70.75794</td>\n",
       "      <td>-50.67113</td>\n",
       "      <td>70.00007</td>\n",
       "      <td>-46.06760</td>\n",
       "      <td>69.15117</td>\n",
       "      <td>-52.67406</td>\n",
       "      <td>68.43804</td>\n",
       "      <td>-48.34157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13038</th>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>2021-04-01</td>\n",
       "      <td>69.60662</td>\n",
       "      <td>-49.41299</td>\n",
       "      <td>70.75811</td>\n",
       "      <td>-50.64991</td>\n",
       "      <td>70.00012</td>\n",
       "      <td>-46.04716</td>\n",
       "      <td>69.15139</td>\n",
       "      <td>-52.65360</td>\n",
       "      <td>68.43817</td>\n",
       "      <td>-48.32179</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28984</th>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>2021-03-16</td>\n",
       "      <td>69.60666</td>\n",
       "      <td>-49.38495</td>\n",
       "      <td>70.75822</td>\n",
       "      <td>-50.62113</td>\n",
       "      <td>70.00002</td>\n",
       "      <td>-46.01907</td>\n",
       "      <td>69.15155</td>\n",
       "      <td>-52.62566</td>\n",
       "      <td>68.43812</td>\n",
       "      <td>-48.29448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42272</th>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>2021-02-28</td>\n",
       "      <td>69.60668</td>\n",
       "      <td>-49.38432</td>\n",
       "      <td>70.75832</td>\n",
       "      <td>-50.62018</td>\n",
       "      <td>69.99973</td>\n",
       "      <td>-46.01807</td>\n",
       "      <td>69.15184</td>\n",
       "      <td>-52.62546</td>\n",
       "      <td>68.43806</td>\n",
       "      <td>-48.29416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127712</th>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>2020-10-23</td>\n",
       "      <td>69.60662</td>\n",
       "      <td>-49.34215</td>\n",
       "      <td>70.75873</td>\n",
       "      <td>-50.57501</td>\n",
       "      <td>69.99847</td>\n",
       "      <td>-45.97459</td>\n",
       "      <td>69.15297</td>\n",
       "      <td>-52.58496</td>\n",
       "      <td>68.43761</td>\n",
       "      <td>-48.25477</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1939476</th>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>2013-09-02</td>\n",
       "      <td>69.60641</td>\n",
       "      <td>-49.37792</td>\n",
       "      <td>70.75841</td>\n",
       "      <td>-50.61303</td>\n",
       "      <td>69.99839</td>\n",
       "      <td>-46.01000</td>\n",
       "      <td>69.15263</td>\n",
       "      <td>-52.62110</td>\n",
       "      <td>68.43749</td>\n",
       "      <td>-48.28849</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1942415</th>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>2013-08-17</td>\n",
       "      <td>69.60639</td>\n",
       "      <td>-49.36155</td>\n",
       "      <td>70.75834</td>\n",
       "      <td>-50.59496</td>\n",
       "      <td>69.99860</td>\n",
       "      <td>-45.99454</td>\n",
       "      <td>69.15236</td>\n",
       "      <td>-52.60378</td>\n",
       "      <td>68.43746</td>\n",
       "      <td>-48.27361</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2003066</th>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>2013-04-27</td>\n",
       "      <td>69.60636</td>\n",
       "      <td>-49.31724</td>\n",
       "      <td>70.70353</td>\n",
       "      <td>-50.62405</td>\n",
       "      <td>69.94496</td>\n",
       "      <td>-46.03324</td>\n",
       "      <td>69.20839</td>\n",
       "      <td>-52.49556</td>\n",
       "      <td>68.49135</td>\n",
       "      <td>-48.15658</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007216</th>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>2013-04-11</td>\n",
       "      <td>69.60648</td>\n",
       "      <td>-49.54340</td>\n",
       "      <td>70.70239</td>\n",
       "      <td>-50.81167</td>\n",
       "      <td>69.95204</td>\n",
       "      <td>-46.28298</td>\n",
       "      <td>69.20261</td>\n",
       "      <td>-52.69745</td>\n",
       "      <td>68.49335</td>\n",
       "      <td>-48.41645</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010249</th>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>2013-04-01</td>\n",
       "      <td>69.60661</td>\n",
       "      <td>-49.42910</td>\n",
       "      <td>70.70076</td>\n",
       "      <td>-50.66154</td>\n",
       "      <td>69.96052</td>\n",
       "      <td>-46.19391</td>\n",
       "      <td>69.19515</td>\n",
       "      <td>-52.55569</td>\n",
       "      <td>68.49592</td>\n",
       "      <td>-48.33506</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>127 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         path  row dateUpdated  sceneCenterLatitude  sceneCenterLongitude  \\\n",
       "4766        9   11  2021-04-17             69.60650             -49.43347   \n",
       "13038       9   11  2021-04-01             69.60662             -49.41299   \n",
       "28984       9   11  2021-03-16             69.60666             -49.38495   \n",
       "42272       9   11  2021-02-28             69.60668             -49.38432   \n",
       "127712      9   11  2020-10-23             69.60662             -49.34215   \n",
       "...       ...  ...         ...                  ...                   ...   \n",
       "1939476     9   11  2013-09-02             69.60641             -49.37792   \n",
       "1942415     9   11  2013-08-17             69.60639             -49.36155   \n",
       "2003066     9   11  2013-04-27             69.60636             -49.31724   \n",
       "2007216     9   11  2013-04-11             69.60648             -49.54340   \n",
       "2010249     9   11  2013-04-01             69.60661             -49.42910   \n",
       "\n",
       "         upperLeftCornerLatitude  upperLeftCornerLongitude  \\\n",
       "4766                    70.75794                 -50.67113   \n",
       "13038                   70.75811                 -50.64991   \n",
       "28984                   70.75822                 -50.62113   \n",
       "42272                   70.75832                 -50.62018   \n",
       "127712                  70.75873                 -50.57501   \n",
       "...                          ...                       ...   \n",
       "1939476                 70.75841                 -50.61303   \n",
       "1942415                 70.75834                 -50.59496   \n",
       "2003066                 70.70353                 -50.62405   \n",
       "2007216                 70.70239                 -50.81167   \n",
       "2010249                 70.70076                 -50.66154   \n",
       "\n",
       "         upperRightCornerLatitude  upperRightCornerLongitude  \\\n",
       "4766                     70.00007                  -46.06760   \n",
       "13038                    70.00012                  -46.04716   \n",
       "28984                    70.00002                  -46.01907   \n",
       "42272                    69.99973                  -46.01807   \n",
       "127712                   69.99847                  -45.97459   \n",
       "...                           ...                        ...   \n",
       "1939476                  69.99839                  -46.01000   \n",
       "1942415                  69.99860                  -45.99454   \n",
       "2003066                  69.94496                  -46.03324   \n",
       "2007216                  69.95204                  -46.28298   \n",
       "2010249                  69.96052                  -46.19391   \n",
       "\n",
       "         lowerLeftCornerLatitude  lowerLeftCornerLongitude  \\\n",
       "4766                    69.15117                 -52.67406   \n",
       "13038                   69.15139                 -52.65360   \n",
       "28984                   69.15155                 -52.62566   \n",
       "42272                   69.15184                 -52.62546   \n",
       "127712                  69.15297                 -52.58496   \n",
       "...                          ...                       ...   \n",
       "1939476                 69.15263                 -52.62110   \n",
       "1942415                 69.15236                 -52.60378   \n",
       "2003066                 69.20839                 -52.49556   \n",
       "2007216                 69.20261                 -52.69745   \n",
       "2010249                 69.19515                 -52.55569   \n",
       "\n",
       "         lowerRightCornerLatitude  lowerRightCornerLongitude  \n",
       "4766                     68.43804                  -48.34157  \n",
       "13038                    68.43817                  -48.32179  \n",
       "28984                    68.43812                  -48.29448  \n",
       "42272                    68.43806                  -48.29416  \n",
       "127712                   68.43761                  -48.25477  \n",
       "...                           ...                        ...  \n",
       "1939476                  68.43749                  -48.28849  \n",
       "1942415                  68.43746                  -48.27361  \n",
       "2003066                  68.49135                  -48.15658  \n",
       "2007216                  68.49335                  -48.41645  \n",
       "2010249                  68.49592                  -48.33506  \n",
       "\n",
       "[127 rows x 13 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ls_pd_911 = ls_pd_s.loc[np.logical_and(ls_pd_s['path'] == 9, ls_pd_s['row'] == 11)]\n",
    "ls_pd_911"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "rough-foster",
   "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>path</th>\n",
       "      <th>row</th>\n",
       "      <th>sceneCenterLatitude</th>\n",
       "      <th>sceneCenterLongitude</th>\n",
       "      <th>upperLeftCornerLatitude</th>\n",
       "      <th>upperLeftCornerLongitude</th>\n",
       "      <th>upperRightCornerLatitude</th>\n",
       "      <th>upperRightCornerLongitude</th>\n",
       "      <th>lowerLeftCornerLatitude</th>\n",
       "      <th>lowerLeftCornerLongitude</th>\n",
       "      <th>lowerRightCornerLatitude</th>\n",
       "      <th>lowerRightCornerLongitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>127.0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>127.000000</td>\n",
       "      <td>127.000000</td>\n",
       "      <td>127.000000</td>\n",
       "      <td>127.000000</td>\n",
       "      <td>127.000000</td>\n",
       "      <td>127.000000</td>\n",
       "      <td>127.000000</td>\n",
       "      <td>127.000000</td>\n",
       "      <td>127.000000</td>\n",
       "      <td>127.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>9.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>69.606482</td>\n",
       "      <td>-49.355231</td>\n",
       "      <td>70.757156</td>\n",
       "      <td>-50.589565</td>\n",
       "      <td>69.997520</td>\n",
       "      <td>-45.990513</td>\n",
       "      <td>69.153716</td>\n",
       "      <td>-52.595528</td>\n",
       "      <td>68.438861</td>\n",
       "      <td>-48.266305</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000133</td>\n",
       "      <td>0.052252</td>\n",
       "      <td>0.008591</td>\n",
       "      <td>0.055921</td>\n",
       "      <td>0.007169</td>\n",
       "      <td>0.059401</td>\n",
       "      <td>0.007662</td>\n",
       "      <td>0.049448</td>\n",
       "      <td>0.008551</td>\n",
       "      <td>0.049549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>9.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>69.606220</td>\n",
       "      <td>-49.543400</td>\n",
       "      <td>70.700760</td>\n",
       "      <td>-50.811670</td>\n",
       "      <td>69.944960</td>\n",
       "      <td>-46.282980</td>\n",
       "      <td>69.150380</td>\n",
       "      <td>-52.722520</td>\n",
       "      <td>68.436840</td>\n",
       "      <td>-48.416450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>9.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>69.606380</td>\n",
       "      <td>-49.396050</td>\n",
       "      <td>70.758075</td>\n",
       "      <td>-50.632645</td>\n",
       "      <td>69.997745</td>\n",
       "      <td>-46.033340</td>\n",
       "      <td>69.151600</td>\n",
       "      <td>-52.633460</td>\n",
       "      <td>68.437275</td>\n",
       "      <td>-48.305295</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>9.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>69.606480</td>\n",
       "      <td>-49.336000</td>\n",
       "      <td>70.758650</td>\n",
       "      <td>-50.568980</td>\n",
       "      <td>69.998160</td>\n",
       "      <td>-45.968770</td>\n",
       "      <td>69.153030</td>\n",
       "      <td>-52.573300</td>\n",
       "      <td>68.437470</td>\n",
       "      <td>-48.248860</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>9.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>69.606615</td>\n",
       "      <td>-49.313180</td>\n",
       "      <td>70.758850</td>\n",
       "      <td>-50.543675</td>\n",
       "      <td>69.999655</td>\n",
       "      <td>-45.944940</td>\n",
       "      <td>69.153375</td>\n",
       "      <td>-52.555955</td>\n",
       "      <td>68.437880</td>\n",
       "      <td>-48.227205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>9.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>69.606680</td>\n",
       "      <td>-49.284800</td>\n",
       "      <td>70.759160</td>\n",
       "      <td>-50.514440</td>\n",
       "      <td>70.000920</td>\n",
       "      <td>-45.916420</td>\n",
       "      <td>69.208390</td>\n",
       "      <td>-52.495560</td>\n",
       "      <td>68.495920</td>\n",
       "      <td>-48.156580</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        path    row  sceneCenterLatitude  sceneCenterLongitude  \\\n",
       "count  127.0  127.0           127.000000            127.000000   \n",
       "mean     9.0   11.0            69.606482            -49.355231   \n",
       "std      0.0    0.0             0.000133              0.052252   \n",
       "min      9.0   11.0            69.606220            -49.543400   \n",
       "25%      9.0   11.0            69.606380            -49.396050   \n",
       "50%      9.0   11.0            69.606480            -49.336000   \n",
       "75%      9.0   11.0            69.606615            -49.313180   \n",
       "max      9.0   11.0            69.606680            -49.284800   \n",
       "\n",
       "       upperLeftCornerLatitude  upperLeftCornerLongitude  \\\n",
       "count               127.000000                127.000000   \n",
       "mean                 70.757156                -50.589565   \n",
       "std                   0.008591                  0.055921   \n",
       "min                  70.700760                -50.811670   \n",
       "25%                  70.758075                -50.632645   \n",
       "50%                  70.758650                -50.568980   \n",
       "75%                  70.758850                -50.543675   \n",
       "max                  70.759160                -50.514440   \n",
       "\n",
       "       upperRightCornerLatitude  upperRightCornerLongitude  \\\n",
       "count                127.000000                 127.000000   \n",
       "mean                  69.997520                 -45.990513   \n",
       "std                    0.007169                   0.059401   \n",
       "min                   69.944960                 -46.282980   \n",
       "25%                   69.997745                 -46.033340   \n",
       "50%                   69.998160                 -45.968770   \n",
       "75%                   69.999655                 -45.944940   \n",
       "max                   70.000920                 -45.916420   \n",
       "\n",
       "       lowerLeftCornerLatitude  lowerLeftCornerLongitude  \\\n",
       "count               127.000000                127.000000   \n",
       "mean                 69.153716                -52.595528   \n",
       "std                   0.007662                  0.049448   \n",
       "min                  69.150380                -52.722520   \n",
       "25%                  69.151600                -52.633460   \n",
       "50%                  69.153030                -52.573300   \n",
       "75%                  69.153375                -52.555955   \n",
       "max                  69.208390                -52.495560   \n",
       "\n",
       "       lowerRightCornerLatitude  lowerRightCornerLongitude  \n",
       "count                127.000000                 127.000000  \n",
       "mean                  68.438861                 -48.266305  \n",
       "std                    0.008551                   0.049549  \n",
       "min                   68.436840                 -48.416450  \n",
       "25%                   68.437275                 -48.305295  \n",
       "50%                   68.437470                 -48.248860  \n",
       "75%                   68.437880                 -48.227205  \n",
       "max                   68.495920                 -48.156580  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ls_pd_911.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "cognitive-architect",
   "metadata": {},
   "outputs": [],
   "source": [
    "output_data = ls_pd_s.loc[0:1].copy()\n",
    "output_data = output_data.drop(['dateUpdated'], axis=1)\n",
    "output_data = output_data.drop([0, 1])\n",
    "\n",
    "\n",
    "for path in range(1, 234):\n",
    "    for row in range(1, 249):\n",
    "        ls_pd_ss = ls_pd_s.loc[np.logical_and(ls_pd_s['path'] == path, ls_pd_s['row'] == row)]\n",
    "        if len(ls_pd_ss.index) != 0:\n",
    "            output_data = output_data.append(ls_pd_ss.describe().loc['mean'])\n",
    "            \n",
    "output_data = output_data.astype({'path': int, 'row': int})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "acting-poster",
   "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>path</th>\n",
       "      <th>row</th>\n",
       "      <th>sceneCenterLatitude</th>\n",
       "      <th>sceneCenterLongitude</th>\n",
       "      <th>upperLeftCornerLatitude</th>\n",
       "      <th>upperLeftCornerLongitude</th>\n",
       "      <th>upperRightCornerLatitude</th>\n",
       "      <th>upperRightCornerLongitude</th>\n",
       "      <th>lowerLeftCornerLatitude</th>\n",
       "      <th>lowerLeftCornerLongitude</th>\n",
       "      <th>lowerRightCornerLatitude</th>\n",
       "      <th>lowerRightCornerLongitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>80.002493</td>\n",
       "      <td>-4.197763</td>\n",
       "      <td>81.205697</td>\n",
       "      <td>-2.730017</td>\n",
       "      <td>79.717460</td>\n",
       "      <td>2.594563</td>\n",
       "      <td>80.144957</td>\n",
       "      <td>-11.291900</td>\n",
       "      <td>78.789287</td>\n",
       "      <td>-5.405237</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>79.111023</td>\n",
       "      <td>-10.561457</td>\n",
       "      <td>80.332344</td>\n",
       "      <td>-9.994770</td>\n",
       "      <td>78.957946</td>\n",
       "      <td>-4.156684</td>\n",
       "      <td>79.130143</td>\n",
       "      <td>-17.075937</td>\n",
       "      <td>77.882976</td>\n",
       "      <td>-11.061501</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>78.118527</td>\n",
       "      <td>-15.970556</td>\n",
       "      <td>79.344246</td>\n",
       "      <td>-16.045440</td>\n",
       "      <td>78.079664</td>\n",
       "      <td>-10.018548</td>\n",
       "      <td>78.034189</td>\n",
       "      <td>-21.909139</td>\n",
       "      <td>76.886141</td>\n",
       "      <td>-15.950291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>77.048224</td>\n",
       "      <td>-20.471403</td>\n",
       "      <td>78.269010</td>\n",
       "      <td>-20.978442</td>\n",
       "      <td>77.105158</td>\n",
       "      <td>-14.988030</td>\n",
       "      <td>76.879455</td>\n",
       "      <td>-25.870470</td>\n",
       "      <td>75.819367</td>\n",
       "      <td>-20.086304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>75.902095</td>\n",
       "      <td>-24.338152</td>\n",
       "      <td>77.113394</td>\n",
       "      <td>-25.133782</td>\n",
       "      <td>76.041404</td>\n",
       "      <td>-19.307509</td>\n",
       "      <td>75.661913</td>\n",
       "      <td>-29.246411</td>\n",
       "      <td>74.680825</td>\n",
       "      <td>-23.697966</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>233</td>\n",
       "      <td>242</td>\n",
       "      <td>80.008794</td>\n",
       "      <td>44.207091</td>\n",
       "      <td>80.154264</td>\n",
       "      <td>51.282248</td>\n",
       "      <td>78.799314</td>\n",
       "      <td>45.389529</td>\n",
       "      <td>81.215211</td>\n",
       "      <td>42.713538</td>\n",
       "      <td>79.726284</td>\n",
       "      <td>37.379350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>233</td>\n",
       "      <td>243</td>\n",
       "      <td>80.760793</td>\n",
       "      <td>36.728885</td>\n",
       "      <td>81.052819</td>\n",
       "      <td>44.273388</td>\n",
       "      <td>79.584925</td>\n",
       "      <td>38.823265</td>\n",
       "      <td>81.923478</td>\n",
       "      <td>34.042857</td>\n",
       "      <td>80.327864</td>\n",
       "      <td>29.693888</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>233</td>\n",
       "      <td>244</td>\n",
       "      <td>81.338812</td>\n",
       "      <td>28.123821</td>\n",
       "      <td>81.798007</td>\n",
       "      <td>35.890003</td>\n",
       "      <td>80.221703</td>\n",
       "      <td>31.325044</td>\n",
       "      <td>82.424145</td>\n",
       "      <td>24.005498</td>\n",
       "      <td>80.744047</td>\n",
       "      <td>21.177876</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>233</td>\n",
       "      <td>245</td>\n",
       "      <td>81.705630</td>\n",
       "      <td>18.551148</td>\n",
       "      <td>82.326232</td>\n",
       "      <td>26.541583</td>\n",
       "      <td>80.663323</td>\n",
       "      <td>23.323882</td>\n",
       "      <td>82.678136</td>\n",
       "      <td>12.476933</td>\n",
       "      <td>80.951763</td>\n",
       "      <td>11.702585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>233</td>\n",
       "      <td>248</td>\n",
       "      <td>81.338539</td>\n",
       "      <td>-11.314870</td>\n",
       "      <td>82.422114</td>\n",
       "      <td>-7.241076</td>\n",
       "      <td>80.742826</td>\n",
       "      <td>-4.410664</td>\n",
       "      <td>81.795931</td>\n",
       "      <td>-19.109458</td>\n",
       "      <td>80.218989</td>\n",
       "      <td>-14.542427</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21903 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      path  row  sceneCenterLatitude  sceneCenterLongitude  \\\n",
       "mean     1    2            80.002493             -4.197763   \n",
       "mean     1    3            79.111023            -10.561457   \n",
       "mean     1    4            78.118527            -15.970556   \n",
       "mean     1    5            77.048224            -20.471403   \n",
       "mean     1    6            75.902095            -24.338152   \n",
       "...    ...  ...                  ...                   ...   \n",
       "mean   233  242            80.008794             44.207091   \n",
       "mean   233  243            80.760793             36.728885   \n",
       "mean   233  244            81.338812             28.123821   \n",
       "mean   233  245            81.705630             18.551148   \n",
       "mean   233  248            81.338539            -11.314870   \n",
       "\n",
       "      upperLeftCornerLatitude  upperLeftCornerLongitude  \\\n",
       "mean                81.205697                 -2.730017   \n",
       "mean                80.332344                 -9.994770   \n",
       "mean                79.344246                -16.045440   \n",
       "mean                78.269010                -20.978442   \n",
       "mean                77.113394                -25.133782   \n",
       "...                       ...                       ...   \n",
       "mean                80.154264                 51.282248   \n",
       "mean                81.052819                 44.273388   \n",
       "mean                81.798007                 35.890003   \n",
       "mean                82.326232                 26.541583   \n",
       "mean                82.422114                 -7.241076   \n",
       "\n",
       "      upperRightCornerLatitude  upperRightCornerLongitude  \\\n",
       "mean                 79.717460                   2.594563   \n",
       "mean                 78.957946                  -4.156684   \n",
       "mean                 78.079664                 -10.018548   \n",
       "mean                 77.105158                 -14.988030   \n",
       "mean                 76.041404                 -19.307509   \n",
       "...                        ...                        ...   \n",
       "mean                 78.799314                  45.389529   \n",
       "mean                 79.584925                  38.823265   \n",
       "mean                 80.221703                  31.325044   \n",
       "mean                 80.663323                  23.323882   \n",
       "mean                 80.742826                  -4.410664   \n",
       "\n",
       "      lowerLeftCornerLatitude  lowerLeftCornerLongitude  \\\n",
       "mean                80.144957                -11.291900   \n",
       "mean                79.130143                -17.075937   \n",
       "mean                78.034189                -21.909139   \n",
       "mean                76.879455                -25.870470   \n",
       "mean                75.661913                -29.246411   \n",
       "...                       ...                       ...   \n",
       "mean                81.215211                 42.713538   \n",
       "mean                81.923478                 34.042857   \n",
       "mean                82.424145                 24.005498   \n",
       "mean                82.678136                 12.476933   \n",
       "mean                81.795931                -19.109458   \n",
       "\n",
       "      lowerRightCornerLatitude  lowerRightCornerLongitude  \n",
       "mean                 78.789287                  -5.405237  \n",
       "mean                 77.882976                 -11.061501  \n",
       "mean                 76.886141                 -15.950291  \n",
       "mean                 75.819367                 -20.086304  \n",
       "mean                 74.680825                 -23.697966  \n",
       "...                        ...                        ...  \n",
       "mean                 79.726284                  37.379350  \n",
       "mean                 80.327864                  29.693888  \n",
       "mean                 80.744047                  21.177876  \n",
       "mean                 80.951763                  11.702585  \n",
       "mean                 80.218989                 -14.542427  \n",
       "\n",
       "[21903 rows x 12 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "output_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "bottom-luther",
   "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>path</th>\n",
       "      <th>row</th>\n",
       "      <th>lat_CTR</th>\n",
       "      <th>lon_CTR</th>\n",
       "      <th>lat_UL</th>\n",
       "      <th>lon_UL</th>\n",
       "      <th>lat_UR</th>\n",
       "      <th>lon_UR</th>\n",
       "      <th>lat_LL</th>\n",
       "      <th>lon_LL</th>\n",
       "      <th>lat_LR</th>\n",
       "      <th>lon_LR</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>80.002493</td>\n",
       "      <td>-4.197763</td>\n",
       "      <td>81.205697</td>\n",
       "      <td>-2.730017</td>\n",
       "      <td>79.717460</td>\n",
       "      <td>2.594563</td>\n",
       "      <td>80.144957</td>\n",
       "      <td>-11.291900</td>\n",
       "      <td>78.789287</td>\n",
       "      <td>-5.405237</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>79.111023</td>\n",
       "      <td>-10.561457</td>\n",
       "      <td>80.332344</td>\n",
       "      <td>-9.994770</td>\n",
       "      <td>78.957946</td>\n",
       "      <td>-4.156684</td>\n",
       "      <td>79.130143</td>\n",
       "      <td>-17.075937</td>\n",
       "      <td>77.882976</td>\n",
       "      <td>-11.061501</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>78.118527</td>\n",
       "      <td>-15.970556</td>\n",
       "      <td>79.344246</td>\n",
       "      <td>-16.045440</td>\n",
       "      <td>78.079664</td>\n",
       "      <td>-10.018548</td>\n",
       "      <td>78.034189</td>\n",
       "      <td>-21.909139</td>\n",
       "      <td>76.886141</td>\n",
       "      <td>-15.950291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>77.048224</td>\n",
       "      <td>-20.471403</td>\n",
       "      <td>78.269010</td>\n",
       "      <td>-20.978442</td>\n",
       "      <td>77.105158</td>\n",
       "      <td>-14.988030</td>\n",
       "      <td>76.879455</td>\n",
       "      <td>-25.870470</td>\n",
       "      <td>75.819367</td>\n",
       "      <td>-20.086304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>75.902095</td>\n",
       "      <td>-24.338152</td>\n",
       "      <td>77.113394</td>\n",
       "      <td>-25.133782</td>\n",
       "      <td>76.041404</td>\n",
       "      <td>-19.307509</td>\n",
       "      <td>75.661913</td>\n",
       "      <td>-29.246411</td>\n",
       "      <td>74.680825</td>\n",
       "      <td>-23.697966</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>233</td>\n",
       "      <td>242</td>\n",
       "      <td>80.008794</td>\n",
       "      <td>44.207091</td>\n",
       "      <td>80.154264</td>\n",
       "      <td>51.282248</td>\n",
       "      <td>78.799314</td>\n",
       "      <td>45.389529</td>\n",
       "      <td>81.215211</td>\n",
       "      <td>42.713538</td>\n",
       "      <td>79.726284</td>\n",
       "      <td>37.379350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>233</td>\n",
       "      <td>243</td>\n",
       "      <td>80.760793</td>\n",
       "      <td>36.728885</td>\n",
       "      <td>81.052819</td>\n",
       "      <td>44.273388</td>\n",
       "      <td>79.584925</td>\n",
       "      <td>38.823265</td>\n",
       "      <td>81.923478</td>\n",
       "      <td>34.042857</td>\n",
       "      <td>80.327864</td>\n",
       "      <td>29.693888</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>233</td>\n",
       "      <td>244</td>\n",
       "      <td>81.338812</td>\n",
       "      <td>28.123821</td>\n",
       "      <td>81.798007</td>\n",
       "      <td>35.890003</td>\n",
       "      <td>80.221703</td>\n",
       "      <td>31.325044</td>\n",
       "      <td>82.424145</td>\n",
       "      <td>24.005498</td>\n",
       "      <td>80.744047</td>\n",
       "      <td>21.177876</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>233</td>\n",
       "      <td>245</td>\n",
       "      <td>81.705630</td>\n",
       "      <td>18.551148</td>\n",
       "      <td>82.326232</td>\n",
       "      <td>26.541583</td>\n",
       "      <td>80.663323</td>\n",
       "      <td>23.323882</td>\n",
       "      <td>82.678136</td>\n",
       "      <td>12.476933</td>\n",
       "      <td>80.951763</td>\n",
       "      <td>11.702585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>233</td>\n",
       "      <td>248</td>\n",
       "      <td>81.338539</td>\n",
       "      <td>-11.314870</td>\n",
       "      <td>82.422114</td>\n",
       "      <td>-7.241076</td>\n",
       "      <td>80.742826</td>\n",
       "      <td>-4.410664</td>\n",
       "      <td>81.795931</td>\n",
       "      <td>-19.109458</td>\n",
       "      <td>80.218989</td>\n",
       "      <td>-14.542427</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21903 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      path  row    lat_CTR    lon_CTR     lat_UL     lon_UL     lat_UR  \\\n",
       "mean     1    2  80.002493  -4.197763  81.205697  -2.730017  79.717460   \n",
       "mean     1    3  79.111023 -10.561457  80.332344  -9.994770  78.957946   \n",
       "mean     1    4  78.118527 -15.970556  79.344246 -16.045440  78.079664   \n",
       "mean     1    5  77.048224 -20.471403  78.269010 -20.978442  77.105158   \n",
       "mean     1    6  75.902095 -24.338152  77.113394 -25.133782  76.041404   \n",
       "...    ...  ...        ...        ...        ...        ...        ...   \n",
       "mean   233  242  80.008794  44.207091  80.154264  51.282248  78.799314   \n",
       "mean   233  243  80.760793  36.728885  81.052819  44.273388  79.584925   \n",
       "mean   233  244  81.338812  28.123821  81.798007  35.890003  80.221703   \n",
       "mean   233  245  81.705630  18.551148  82.326232  26.541583  80.663323   \n",
       "mean   233  248  81.338539 -11.314870  82.422114  -7.241076  80.742826   \n",
       "\n",
       "         lon_UR     lat_LL     lon_LL     lat_LR     lon_LR  \n",
       "mean   2.594563  80.144957 -11.291900  78.789287  -5.405237  \n",
       "mean  -4.156684  79.130143 -17.075937  77.882976 -11.061501  \n",
       "mean -10.018548  78.034189 -21.909139  76.886141 -15.950291  \n",
       "mean -14.988030  76.879455 -25.870470  75.819367 -20.086304  \n",
       "mean -19.307509  75.661913 -29.246411  74.680825 -23.697966  \n",
       "...         ...        ...        ...        ...        ...  \n",
       "mean  45.389529  81.215211  42.713538  79.726284  37.379350  \n",
       "mean  38.823265  81.923478  34.042857  80.327864  29.693888  \n",
       "mean  31.325044  82.424145  24.005498  80.744047  21.177876  \n",
       "mean  23.323882  82.678136  12.476933  80.951763  11.702585  \n",
       "mean  -4.410664  81.795931 -19.109458  80.218989 -14.542427  \n",
       "\n",
       "[21903 rows x 12 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "output_data = output_data.rename(columns={'sceneCenterLatitude': 'lat_CTR',\n",
    "                                          'sceneCenterLongitude': 'lon_CTR',\n",
    "                                          'upperLeftCornerLatitude': 'lat_UL',\n",
    "                                          'upperLeftCornerLongitude': 'lon_UL',\n",
    "                                          'upperRightCornerLatitude': 'lat_UR',\n",
    "                                          'upperRightCornerLongitude': 'lon_UR',\n",
    "                                          'lowerLeftCornerLatitude': 'lat_LL',\n",
    "                                          'lowerLeftCornerLongitude': 'lon_LL',\n",
    "                                          'lowerRightCornerLatitude': 'lat_LR',\n",
    "                                          'lowerRightCornerLongitude': 'lon_LR'})\n",
    "output_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "flush-origin",
   "metadata": {},
   "outputs": [],
   "source": [
    "output_data.to_csv('LANDSAT_8_C1_cornerpoints.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "northern-drinking",
   "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.9.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}