API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 15th, 2019
103
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 55.99 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "cells": [
  3. {
  4. "cell_type": "code",
  5. "execution_count": 1,
  6. "metadata": {},
  7. "outputs": [
  8. {
  9. "name": "stdout",
  10. "output_type": "stream",
  11. "text": [
  12. "Populating the interactive namespace from numpy and matplotlib\n"
  13. ]
  14. }
  15. ],
  16. "source": [
  17. "%pylab notebook\n",
  18. "import datacube\n",
  19. "from datetime import datetime, timedelta\n",
  20. "import pandas as pd\n",
  21. "import pyproj\n",
  22. "import csv\n",
  23. "\n",
  24. "dc = datacube.Datacube(app='nbart-fieldsites')"
  25. ]
  26. },
  27. {
  28. "cell_type": "code",
  29. "execution_count": 2,
  30. "metadata": {
  31. "collapsed": true
  32. },
  33. "outputs": [],
  34. "source": [
  35. "fieldsites = pd.read_csv(\n",
  36. " 'jrsrp_20170430.csv',\n",
  37. " usecols=[\n",
  38. " 'obs_key',\n",
  39. " 'obs_time',\n",
  40. " 'longitude',\n",
  41. " 'latitude',\n",
  42. " ])"
  43. ]
  44. },
  45. {
  46. "cell_type": "code",
  47. "execution_count": 24,
  48. "metadata": {},
  49. "outputs": [],
  50. "source": [
  51. "def query_cube(fieldsite_key, fieldsite_time, lon, lat):\n",
  52. " target_day = datetime.strptime(fieldsite_time, '%Y-%m-%d')\n",
  53. " time_before = (target_day - timedelta(days=60)).strftime('%Y-%m-%d')\n",
  54. " time_after = (target_day + timedelta(days=60)).strftime('%Y-%m-%d')\n",
  55. " \n",
  56. " query = {'time': (time_before, time_after)}\n",
  57. " \n",
  58. " wgs_84 = pyproj.Proj(init='epsg:4326')\n",
  59. " aus_albers = pyproj.Proj(init='epsg:3577')\n",
  60. "\n",
  61. " x, y = pyproj.transform(wgs_84, aus_albers, lon, lat)\n",
  62. " \n",
  63. " y_max = y-30\n",
  64. " y_min = y+30\n",
  65. " x_max = x-30\n",
  66. " x_min = x+30\n",
  67. " query['x'] = (x_min, x_max)\n",
  68. " query['y'] = (y_max, y_min)\n",
  69. " query['crs'] = 'EPSG:3577'\n",
  70. " \n",
  71. " query['output_crs'] = 'EPSG:3577'\n",
  72. " query['resolution'] = -25, 25\n",
  73. " \n",
  74. " query['measurements'] = ['blue',\n",
  75. " 'green',\n",
  76. " 'red', \n",
  77. " 'nir',\n",
  78. " 'swir1', \n",
  79. " 'swir2'\n",
  80. " ]\n",
  81. " \n",
  82. " deltas = {}\n",
  83. " products = dc.list_products()\n",
  84. " delta = None\n",
  85. " observation_date = None\n",
  86. " observation_product = None\n",
  87. " for product in products.name: \n",
  88. " #if(product.startswith('ls') and product.endswith('albers') and (product not in ['ls5_ndvi_albers','ls7_ndvi_albers','ls8_ndvi_albers'])):\n",
  89. " if(product in ['ls5_nbart_albers','ls7_nbart_albers','ls8_nbart_albers']): \n",
  90. " datasets = dc.find_datasets(product=product,**query)\n",
  91. " for dataset in datasets:\n",
  92. " if(delta == None):\n",
  93. " delta = (target_day - dataset.center_time)\n",
  94. " observation_date = dataset.center_time\n",
  95. " observation_product = product\n",
  96. " continue\n",
  97. " current_delta = (target_day - dataset.center_time)\n",
  98. " if(abs(current_delta) < abs(delta)):\n",
  99. " delta = current_delta\n",
  100. " observation_date = dataset.center_time\n",
  101. " observation_product = product\n",
  102. " if(observation_date):\n",
  103. " time_before = (observation_date - timedelta(days=1)).strftime('%Y-%m-%d')\n",
  104. " time_after = (observation_date + timedelta(days=1)).strftime('%Y-%m-%d')\n",
  105. " query['time'] = (time_before, time_after)\n",
  106. " data = dc.load(product=observation_product, **query)\n",
  107. "\n",
  108. " point = data.sel(x=x,y=y,time=target_day, method='nearest')\n",
  109. " blue = point.blue.data\n",
  110. " green = point.green.data\n",
  111. " red = point.red.data\n",
  112. " nir = point.nir.data\n",
  113. " swir1 = point.swir1.data\n",
  114. " swir2 = point.swir2.data\n",
  115. "\n",
  116. " return fieldsite_key, fieldsite_time, lon, lat, observation_product, observation_date, delta, blue, green, red, nir, swir1, swir2\n",
  117. " else:\n",
  118. " print('could not find: ' + fieldsite_time)\n",
  119. " return None"
  120. ]
  121. },
  122. {
  123. "cell_type": "code",
  124. "execution_count": 32,
  125. "metadata": {},
  126. "outputs": [
  127. {
  128. "name": "stdout",
  129. "output_type": "stream",
  130. "text": [
  131. "could not find: 2017-02-12\n",
  132. "could not find: 2017-04-05\n"
  133. ]
  134. }
  135. ],
  136. "source": [
  137. "fieldsite_tuples = [tuple(x) for x in fieldsites.values]\n",
  138. "index = 0\n",
  139. "observation_tuples = []\n",
  140. "for fieldsite in fieldsite_tuples: \n",
  141. " result = query_cube(*fieldsite)\n",
  142. " if(result):\n",
  143. " observation_tuples.append(result)\n",
  144. " index = index + 1\n",
  145. " if(index >= 500):\n",
  146. " break"
  147. ]
  148. },
  149. {
  150. "cell_type": "code",
  151. "execution_count": 33,
  152. "metadata": {},
  153. "outputs": [],
  154. "source": [
  155. "df = pd.DataFrame(observation_tuples,\n",
  156. " columns=[\n",
  157. " 'fieldsite_key',\n",
  158. " 'fieldsite_time',\n",
  159. " 'lon',\n",
  160. " 'lat',\n",
  161. " 'observation_product',\n",
  162. " 'observation_date',\n",
  163. " 'time_delta',\n",
  164. " 'blue',\n",
  165. " 'green',\n",
  166. " 'red',\n",
  167. " 'nir',\n",
  168. " 'swir1',\n",
  169. " 'swir2'\n",
  170. " ])"
  171. ]
  172. },
  173. {
  174. "cell_type": "code",
  175. "execution_count": 34,
  176. "metadata": {},
  177. "outputs": [
  178. {
  179. "data": {
  180. "text/html": [
  181. "<div>\n",
  182. "<table border=\"1\" class=\"dataframe\">\n",
  183. " <thead>\n",
  184. " <tr style=\"text-align: right;\">\n",
  185. " <th></th>\n",
  186. " <th>fieldsite_key</th>\n",
  187. " <th>fieldsite_time</th>\n",
  188. " <th>lon</th>\n",
  189. " <th>lat</th>\n",
  190. " <th>observation_product</th>\n",
  191. " <th>observation_date</th>\n",
  192. " <th>time_delta</th>\n",
  193. " <th>blue</th>\n",
  194. " <th>green</th>\n",
  195. " <th>red</th>\n",
  196. " <th>nir</th>\n",
  197. " <th>swir1</th>\n",
  198. " <th>swir2</th>\n",
  199. " </tr>\n",
  200. " </thead>\n",
  201. " <tbody>\n",
  202. " <tr>\n",
  203. " <th>0</th>\n",
  204. " <td>15282706_02742904_20101216_000000</td>\n",
  205. " <td>2010-12-16</td>\n",
  206. " <td>152.827067</td>\n",
  207. " <td>-27.429043</td>\n",
  208. " <td>ls5_nbart_albers</td>\n",
  209. " <td>2010-12-15 23:31:57.500</td>\n",
  210. " <td>0 days 00:28:02.500000</td>\n",
  211. " <td>183</td>\n",
  212. " <td>359</td>\n",
  213. " <td>329</td>\n",
  214. " <td>2276</td>\n",
  215. " <td>1174</td>\n",
  216. " <td>354</td>\n",
  217. " </tr>\n",
  218. " <tr>\n",
  219. " <th>1</th>\n",
  220. " <td>12191981_03088325_20101013_000000</td>\n",
  221. " <td>2010-10-13</td>\n",
  222. " <td>121.919808</td>\n",
  223. " <td>-30.883252</td>\n",
  224. " <td>ls7_nbart_albers</td>\n",
  225. " <td>2010-10-10 01:33:03.500</td>\n",
  226. " <td>2 days 22:26:56.500000</td>\n",
  227. " <td>-999</td>\n",
  228. " <td>-999</td>\n",
  229. " <td>-999</td>\n",
  230. " <td>-999</td>\n",
  231. " <td>-999</td>\n",
  232. " <td>-999</td>\n",
  233. " </tr>\n",
  234. " <tr>\n",
  235. " <th>2</th>\n",
  236. " <td>14432646_02760430_20021030_000000</td>\n",
  237. " <td>2002-10-30</td>\n",
  238. " <td>144.326462</td>\n",
  239. " <td>-27.604300</td>\n",
  240. " <td>ls7_nbart_albers</td>\n",
  241. " <td>2002-10-25 00:06:59.500</td>\n",
  242. " <td>4 days 23:53:00.500000</td>\n",
  243. " <td>519</td>\n",
  244. " <td>905</td>\n",
  245. " <td>1632</td>\n",
  246. " <td>2285</td>\n",
  247. " <td>3454</td>\n",
  248. " <td>2916</td>\n",
  249. " </tr>\n",
  250. " <tr>\n",
  251. " <th>3</th>\n",
  252. " <td>13399362_02377054_20120608_000000</td>\n",
  253. " <td>2012-06-08</td>\n",
  254. " <td>133.993630</td>\n",
  255. " <td>-23.770550</td>\n",
  256. " <td>ls7_nbart_albers</td>\n",
  257. " <td>2012-06-15 00:55:40.500</td>\n",
  258. " <td>-8 days +23:04:19.500000</td>\n",
  259. " <td>755</td>\n",
  260. " <td>954</td>\n",
  261. " <td>1160</td>\n",
  262. " <td>1768</td>\n",
  263. " <td>2462</td>\n",
  264. " <td>1866</td>\n",
  265. " </tr>\n",
  266. " <tr>\n",
  267. " <th>4</th>\n",
  268. " <td>13577022_02114920_20160804_000000</td>\n",
  269. " <td>2016-08-04</td>\n",
  270. " <td>135.770220</td>\n",
  271. " <td>-21.149200</td>\n",
  272. " <td>ls8_nbart_albers</td>\n",
  273. " <td>2016-07-29 00:54:41.500</td>\n",
  274. " <td>5 days 23:05:18.500000</td>\n",
  275. " <td>515</td>\n",
  276. " <td>866</td>\n",
  277. " <td>1159</td>\n",
  278. " <td>2378</td>\n",
  279. " <td>3046</td>\n",
  280. " <td>2326</td>\n",
  281. " </tr>\n",
  282. " <tr>\n",
  283. " <th>5</th>\n",
  284. " <td>12456729_01785321_20120828_000000</td>\n",
  285. " <td>2012-08-28</td>\n",
  286. " <td>124.567289</td>\n",
  287. " <td>-17.853211</td>\n",
  288. " <td>ls7_nbart_albers</td>\n",
  289. " <td>2012-09-04 01:38:16.000</td>\n",
  290. " <td>-8 days +22:21:44</td>\n",
  291. " <td>886</td>\n",
  292. " <td>1167</td>\n",
  293. " <td>1447</td>\n",
  294. " <td>2149</td>\n",
  295. " <td>2717</td>\n",
  296. " <td>2248</td>\n",
  297. " </tr>\n",
  298. " <tr>\n",
  299. " <th>6</th>\n",
  300. " <td>13466259_02126378_20150527_000000</td>\n",
  301. " <td>2015-05-27</td>\n",
  302. " <td>134.662596</td>\n",
  303. " <td>-21.263788</td>\n",
  304. " <td>ls7_nbart_albers</td>\n",
  305. " <td>2015-05-23 01:00:19.000</td>\n",
  306. " <td>3 days 22:59:41</td>\n",
  307. " <td>635</td>\n",
  308. " <td>1187</td>\n",
  309. " <td>2006</td>\n",
  310. " <td>2853</td>\n",
  311. " <td>3790</td>\n",
  312. " <td>2935</td>\n",
  313. " </tr>\n",
  314. " <tr>\n",
  315. " <th>7</th>\n",
  316. " <td>15310119_02595226_20100630_130000</td>\n",
  317. " <td>2010-06-30</td>\n",
  318. " <td>153.101190</td>\n",
  319. " <td>-25.952261</td>\n",
  320. " <td>ls7_nbart_albers</td>\n",
  321. " <td>2010-06-21 23:40:03.500</td>\n",
  322. " <td>8 days 00:19:56.500000</td>\n",
  323. " <td>-999</td>\n",
  324. " <td>-999</td>\n",
  325. " <td>7122</td>\n",
  326. " <td>7422</td>\n",
  327. " <td>3647</td>\n",
  328. " <td>1984</td>\n",
  329. " </tr>\n",
  330. " <tr>\n",
  331. " <th>8</th>\n",
  332. " <td>13747621_01831000_20110922_000000</td>\n",
  333. " <td>2011-09-22</td>\n",
  334. " <td>137.476219</td>\n",
  335. " <td>-18.310003</td>\n",
  336. " <td>ls5_nbart_albers</td>\n",
  337. " <td>2011-09-18 00:42:21.000</td>\n",
  338. " <td>3 days 23:17:39</td>\n",
  339. " <td>524</td>\n",
  340. " <td>901</td>\n",
  341. " <td>1159</td>\n",
  342. " <td>2099</td>\n",
  343. " <td>2670</td>\n",
  344. " <td>1860</td>\n",
  345. " </tr>\n",
  346. " <tr>\n",
  347. " <th>9</th>\n",
  348. " <td>14846057_02824703_20161101_000000</td>\n",
  349. " <td>2016-11-01</td>\n",
  350. " <td>148.460570</td>\n",
  351. " <td>-28.247030</td>\n",
  352. " <td>ls8_nbart_albers</td>\n",
  353. " <td>2016-10-02 00:01:18.000</td>\n",
  354. " <td>29 days 23:58:42</td>\n",
  355. " <td>830</td>\n",
  356. " <td>987</td>\n",
  357. " <td>975</td>\n",
  358. " <td>2327</td>\n",
  359. " <td>1670</td>\n",
  360. " <td>1165</td>\n",
  361. " </tr>\n",
  362. " <tr>\n",
  363. " <th>10</th>\n",
  364. " <td>14653153_01980285_20060421_000000</td>\n",
  365. " <td>2006-04-21</td>\n",
  366. " <td>146.531535</td>\n",
  367. " <td>-19.802851</td>\n",
  368. " <td>ls7_nbart_albers</td>\n",
  369. " <td>2006-04-27 00:07:13.500</td>\n",
  370. " <td>-7 days +23:52:46.500000</td>\n",
  371. " <td>1692</td>\n",
  372. " <td>1873</td>\n",
  373. " <td>1927</td>\n",
  374. " <td>3618</td>\n",
  375. " <td>3074</td>\n",
  376. " <td>2547</td>\n",
  377. " </tr>\n",
  378. " <tr>\n",
  379. " <th>11</th>\n",
  380. " <td>14598394_01949405_19971001_000038</td>\n",
  381. " <td>1997-10-01</td>\n",
  382. " <td>145.983940</td>\n",
  383. " <td>-19.494059</td>\n",
  384. " <td>ls5_nbart_albers</td>\n",
  385. " <td>1997-10-02 23:50:07.000</td>\n",
  386. " <td>-2 days +00:09:53</td>\n",
  387. " <td>944</td>\n",
  388. " <td>1391</td>\n",
  389. " <td>1804</td>\n",
  390. " <td>2785</td>\n",
  391. " <td>4797</td>\n",
  392. " <td>3664</td>\n",
  393. " </tr>\n",
  394. " <tr>\n",
  395. " <th>12</th>\n",
  396. " <td>13622756_02193975_20160824_000000</td>\n",
  397. " <td>2016-08-24</td>\n",
  398. " <td>136.227561</td>\n",
  399. " <td>-21.939750</td>\n",
  400. " <td>ls7_nbart_albers</td>\n",
  401. " <td>2016-08-22 00:57:19.500</td>\n",
  402. " <td>1 days 23:02:40.500000</td>\n",
  403. " <td>364</td>\n",
  404. " <td>607</td>\n",
  405. " <td>982</td>\n",
  406. " <td>1470</td>\n",
  407. " <td>2137</td>\n",
  408. " <td>1597</td>\n",
  409. " </tr>\n",
  410. " <tr>\n",
  411. " <th>13</th>\n",
  412. " <td>14815056_03565651_20110111_000000</td>\n",
  413. " <td>2011-01-11</td>\n",
  414. " <td>148.150571</td>\n",
  415. " <td>-35.656517</td>\n",
  416. " <td>ls5_nbart_albers</td>\n",
  417. " <td>2011-01-14 23:46:48.500</td>\n",
  418. " <td>-4 days +00:13:11.500000</td>\n",
  419. " <td>160</td>\n",
  420. " <td>268</td>\n",
  421. " <td>284</td>\n",
  422. " <td>2044</td>\n",
  423. " <td>891</td>\n",
  424. " <td>301</td>\n",
  425. " </tr>\n",
  426. " <tr>\n",
  427. " <th>14</th>\n",
  428. " <td>11681968_02097839_20110822_000000</td>\n",
  429. " <td>2011-08-22</td>\n",
  430. " <td>116.819682</td>\n",
  431. " <td>-20.978394</td>\n",
  432. " <td>ls7_nbart_albers</td>\n",
  433. " <td>2011-08-20 02:08:25.500</td>\n",
  434. " <td>1 days 21:51:34.500000</td>\n",
  435. " <td>538</td>\n",
  436. " <td>883</td>\n",
  437. " <td>1406</td>\n",
  438. " <td>2173</td>\n",
  439. " <td>3145</td>\n",
  440. " <td>2566</td>\n",
  441. " </tr>\n",
  442. " <tr>\n",
  443. " <th>15</th>\n",
  444. " <td>13440487_01852067_20141003_000000</td>\n",
  445. " <td>2014-10-03</td>\n",
  446. " <td>134.404874</td>\n",
  447. " <td>-18.520673</td>\n",
  448. " <td>ls7_nbart_albers</td>\n",
  449. " <td>2014-10-02 01:04:07.000</td>\n",
  450. " <td>0 days 22:55:53</td>\n",
  451. " <td>949</td>\n",
  452. " <td>1528</td>\n",
  453. " <td>2124</td>\n",
  454. " <td>3004</td>\n",
  455. " <td>3373</td>\n",
  456. " <td>2508</td>\n",
  457. " </tr>\n",
  458. " <tr>\n",
  459. " <th>16</th>\n",
  460. " <td>12966402_01786564_20150618_000000</td>\n",
  461. " <td>2015-06-18</td>\n",
  462. " <td>129.664027</td>\n",
  463. " <td>-17.865643</td>\n",
  464. " <td>ls7_nbart_albers</td>\n",
  465. " <td>2015-06-20 01:23:59.500</td>\n",
  466. " <td>-3 days +22:36:00.500000</td>\n",
  467. " <td>727</td>\n",
  468. " <td>1294</td>\n",
  469. " <td>2191</td>\n",
  470. " <td>3233</td>\n",
  471. " <td>3556</td>\n",
  472. " <td>2272</td>\n",
  473. " </tr>\n",
  474. " <tr>\n",
  475. " <th>17</th>\n",
  476. " <td>13067934_01823514_20150523_000000</td>\n",
  477. " <td>2015-05-23</td>\n",
  478. " <td>130.679340</td>\n",
  479. " <td>-18.235140</td>\n",
  480. " <td>ls8_nbart_albers</td>\n",
  481. " <td>2015-05-20 01:17:39.000</td>\n",
  482. " <td>2 days 22:42:21</td>\n",
  483. " <td>592</td>\n",
  484. " <td>1075</td>\n",
  485. " <td>1659</td>\n",
  486. " <td>2859</td>\n",
  487. " <td>2886</td>\n",
  488. " <td>2320</td>\n",
  489. " </tr>\n",
  490. " <tr>\n",
  491. " <th>18</th>\n",
  492. " <td>13521250_01735842_20130809_000000</td>\n",
  493. " <td>2013-08-09</td>\n",
  494. " <td>135.212502</td>\n",
  495. " <td>-17.358425</td>\n",
  496. " <td>ls7_nbart_albers</td>\n",
  497. " <td>2013-08-05 00:54:55.500</td>\n",
  498. " <td>3 days 23:05:04.500000</td>\n",
  499. " <td>454</td>\n",
  500. " <td>705</td>\n",
  501. " <td>878</td>\n",
  502. " <td>1739</td>\n",
  503. " <td>2577</td>\n",
  504. " <td>1735</td>\n",
  505. " </tr>\n",
  506. " <tr>\n",
  507. " <th>19</th>\n",
  508. " <td>14566707_01950722_20160830_000000</td>\n",
  509. " <td>2016-08-30</td>\n",
  510. " <td>145.667070</td>\n",
  511. " <td>-19.507220</td>\n",
  512. " <td>ls7_nbart_albers</td>\n",
  513. " <td>2016-08-28 00:19:52.500</td>\n",
  514. " <td>1 days 23:40:07.500000</td>\n",
  515. " <td>454</td>\n",
  516. " <td>792</td>\n",
  517. " <td>988</td>\n",
  518. " <td>2485</td>\n",
  519. " <td>3015</td>\n",
  520. " <td>2086</td>\n",
  521. " </tr>\n",
  522. " <tr>\n",
  523. " <th>20</th>\n",
  524. " <td>13483730_02579251_20140909_000000</td>\n",
  525. " <td>2014-09-09</td>\n",
  526. " <td>134.837309</td>\n",
  527. " <td>-25.792517</td>\n",
  528. " <td>ls8_nbart_albers</td>\n",
  529. " <td>2014-09-10 00:56:01.000</td>\n",
  530. " <td>-2 days +23:03:59</td>\n",
  531. " <td>600</td>\n",
  532. " <td>1126</td>\n",
  533. " <td>2507</td>\n",
  534. " <td>3435</td>\n",
  535. " <td>5018</td>\n",
  536. " <td>4349</td>\n",
  537. " </tr>\n",
  538. " <tr>\n",
  539. " <th>21</th>\n",
  540. " <td>15305673_02600155_20151111_043000</td>\n",
  541. " <td>2015-11-11</td>\n",
  542. " <td>153.056730</td>\n",
  543. " <td>-26.001550</td>\n",
  544. " <td>ls8_nbart_albers</td>\n",
  545. " <td>2015-11-11 23:41:49.000</td>\n",
  546. " <td>-1 days +00:18:11</td>\n",
  547. " <td>5025</td>\n",
  548. " <td>4796</td>\n",
  549. " <td>4749</td>\n",
  550. " <td>5222</td>\n",
  551. " <td>2754</td>\n",
  552. " <td>1820</td>\n",
  553. " </tr>\n",
  554. " <tr>\n",
  555. " <th>22</th>\n",
  556. " <td>13866228_03002524_20120426_000000</td>\n",
  557. " <td>2012-04-26</td>\n",
  558. " <td>138.662281</td>\n",
  559. " <td>-30.025238</td>\n",
  560. " <td>ls7_nbart_albers</td>\n",
  561. " <td>2012-05-02 00:33:00.500</td>\n",
  562. " <td>-7 days +23:26:59.500000</td>\n",
  563. " <td>808</td>\n",
  564. " <td>1449</td>\n",
  565. " <td>2294</td>\n",
  566. " <td>3106</td>\n",
  567. " <td>3765</td>\n",
  568. " <td>3110</td>\n",
  569. " </tr>\n",
  570. " <tr>\n",
  571. " <th>23</th>\n",
  572. " <td>14615343_02029290_19970929_000027</td>\n",
  573. " <td>1997-09-29</td>\n",
  574. " <td>146.153432</td>\n",
  575. " <td>-20.292903</td>\n",
  576. " <td>ls5_nbart_albers</td>\n",
  577. " <td>1997-10-02 23:50:07.000</td>\n",
  578. " <td>-4 days +00:09:53</td>\n",
  579. " <td>670</td>\n",
  580. " <td>1179</td>\n",
  581. " <td>1735</td>\n",
  582. " <td>2508</td>\n",
  583. " <td>4652</td>\n",
  584. " <td>3827</td>\n",
  585. " </tr>\n",
  586. " <tr>\n",
  587. " <th>24</th>\n",
  588. " <td>11899442_02800782_20120912_000000</td>\n",
  589. " <td>2012-09-12</td>\n",
  590. " <td>118.994425</td>\n",
  591. " <td>-28.007822</td>\n",
  592. " <td>ls7_nbart_albers</td>\n",
  593. " <td>2012-09-18 01:53:31.500</td>\n",
  594. " <td>-7 days +22:06:28.500000</td>\n",
  595. " <td>1649</td>\n",
  596. " <td>1941</td>\n",
  597. " <td>2590</td>\n",
  598. " <td>3290</td>\n",
  599. " <td>3492</td>\n",
  600. " <td>2587</td>\n",
  601. " </tr>\n",
  602. " <tr>\n",
  603. " <th>25</th>\n",
  604. " <td>14918061_03520130_20140223_234900</td>\n",
  605. " <td>2014-02-23</td>\n",
  606. " <td>149.180610</td>\n",
  607. " <td>-35.201300</td>\n",
  608. " <td>ls8_nbart_albers</td>\n",
  609. " <td>2014-02-23 23:57:13.000</td>\n",
  610. " <td>-1 days +00:02:47</td>\n",
  611. " <td>582</td>\n",
  612. " <td>802</td>\n",
  613. " <td>1044</td>\n",
  614. " <td>1854</td>\n",
  615. " <td>3644</td>\n",
  616. " <td>2551</td>\n",
  617. " </tr>\n",
  618. " <tr>\n",
  619. " <th>26</th>\n",
  620. " <td>13086485_01780029_20120725_000000</td>\n",
  621. " <td>2012-07-25</td>\n",
  622. " <td>130.864855</td>\n",
  623. " <td>-17.800298</td>\n",
  624. " <td>ls7_nbart_albers</td>\n",
  625. " <td>2012-07-22 01:13:03.500</td>\n",
  626. " <td>2 days 22:46:56.500000</td>\n",
  627. " <td>-999</td>\n",
  628. " <td>-999</td>\n",
  629. " <td>-999</td>\n",
  630. " <td>2730</td>\n",
  631. " <td>3297</td>\n",
  632. " <td>2615</td>\n",
  633. " </tr>\n",
  634. " <tr>\n",
  635. " <th>27</th>\n",
  636. " <td>13636614_01776261_20130515_000000</td>\n",
  637. " <td>2013-05-15</td>\n",
  638. " <td>136.366143</td>\n",
  639. " <td>-17.762619</td>\n",
  640. " <td>ls8_nbart_albers</td>\n",
  641. " <td>2013-05-18 00:55:29.000</td>\n",
  642. " <td>-4 days +23:04:31</td>\n",
  643. " <td>5831</td>\n",
  644. " <td>5761</td>\n",
  645. " <td>6013</td>\n",
  646. " <td>6015</td>\n",
  647. " <td>4512</td>\n",
  648. " <td>3500</td>\n",
  649. " </tr>\n",
  650. " <tr>\n",
  651. " <th>28</th>\n",
  652. " <td>13273949_02344746_20160925_000000</td>\n",
  653. " <td>2016-09-25</td>\n",
  654. " <td>132.739495</td>\n",
  655. " <td>-23.447462</td>\n",
  656. " <td>ls8_nbart_albers</td>\n",
  657. " <td>2016-09-29 01:07:40.000</td>\n",
  658. " <td>-5 days +22:52:20</td>\n",
  659. " <td>631</td>\n",
  660. " <td>1129</td>\n",
  661. " <td>1857</td>\n",
  662. " <td>2750</td>\n",
  663. " <td>4051</td>\n",
  664. " <td>3743</td>\n",
  665. " </tr>\n",
  666. " <tr>\n",
  667. " <th>29</th>\n",
  668. " <td>13630686_02710211_20120414_000000</td>\n",
  669. " <td>2012-04-14</td>\n",
  670. " <td>136.306863</td>\n",
  671. " <td>-27.102109</td>\n",
  672. " <td>ls7_nbart_albers</td>\n",
  673. " <td>2012-04-14 00:44:09.000</td>\n",
  674. " <td>-1 days +23:15:51</td>\n",
  675. " <td>1374</td>\n",
  676. " <td>1874</td>\n",
  677. " <td>2110</td>\n",
  678. " <td>4260</td>\n",
  679. " <td>3823</td>\n",
  680. " <td>2791</td>\n",
  681. " </tr>\n",
  682. " <tr>\n",
  683. " <th>...</th>\n",
  684. " <td>...</td>\n",
  685. " <td>...</td>\n",
  686. " <td>...</td>\n",
  687. " <td>...</td>\n",
  688. " <td>...</td>\n",
  689. " <td>...</td>\n",
  690. " <td>...</td>\n",
  691. " <td>...</td>\n",
  692. " <td>...</td>\n",
  693. " <td>...</td>\n",
  694. " <td>...</td>\n",
  695. " <td>...</td>\n",
  696. " <td>...</td>\n",
  697. " </tr>\n",
  698. " <tr>\n",
  699. " <th>468</th>\n",
  700. " <td>14521058_03001795_20121017_000000</td>\n",
  701. " <td>2012-10-17</td>\n",
  702. " <td>145.210583</td>\n",
  703. " <td>-30.017948</td>\n",
  704. " <td>ls7_nbart_albers</td>\n",
  705. " <td>2012-10-13 00:09:30.500</td>\n",
  706. " <td>3 days 23:50:29.500000</td>\n",
  707. " <td>861</td>\n",
  708. " <td>1101</td>\n",
  709. " <td>1375</td>\n",
  710. " <td>2028</td>\n",
  711. " <td>3300</td>\n",
  712. " <td>2369</td>\n",
  713. " </tr>\n",
  714. " <tr>\n",
  715. " <th>469</th>\n",
  716. " <td>13019522_01777534_20150613_000000</td>\n",
  717. " <td>2015-06-13</td>\n",
  718. " <td>130.195220</td>\n",
  719. " <td>-17.775340</td>\n",
  720. " <td>ls8_nbart_albers</td>\n",
  721. " <td>2015-06-12 01:23:39.000</td>\n",
  722. " <td>0 days 22:36:21</td>\n",
  723. " <td>730</td>\n",
  724. " <td>1119</td>\n",
  725. " <td>1616</td>\n",
  726. " <td>2568</td>\n",
  727. " <td>2899</td>\n",
  728. " <td>1971</td>\n",
  729. " </tr>\n",
  730. " <tr>\n",
  731. " <th>470</th>\n",
  732. " <td>13046504_03146915_20121129_000000</td>\n",
  733. " <td>2012-11-29</td>\n",
  734. " <td>130.465039</td>\n",
  735. " <td>-31.469155</td>\n",
  736. " <td>ls7_nbart_albers</td>\n",
  737. " <td>2012-11-29 01:05:49.500</td>\n",
  738. " <td>-1 days +22:54:10.500000</td>\n",
  739. " <td>687</td>\n",
  740. " <td>1047</td>\n",
  741. " <td>1536</td>\n",
  742. " <td>2317</td>\n",
  743. " <td>3454</td>\n",
  744. " <td>2875</td>\n",
  745. " </tr>\n",
  746. " <tr>\n",
  747. " <th>471</th>\n",
  748. " <td>13397399_02446000_20130919_000000</td>\n",
  749. " <td>2013-09-19</td>\n",
  750. " <td>133.974000</td>\n",
  751. " <td>-24.460000</td>\n",
  752. " <td>ls7_nbart_albers</td>\n",
  753. " <td>2013-09-22 00:57:21.500</td>\n",
  754. " <td>-4 days +23:02:38.500000</td>\n",
  755. " <td>692</td>\n",
  756. " <td>1249</td>\n",
  757. " <td>2335</td>\n",
  758. " <td>3147</td>\n",
  759. " <td>4377</td>\n",
  760. " <td>3972</td>\n",
  761. " </tr>\n",
  762. " <tr>\n",
  763. " <th>472</th>\n",
  764. " <td>14428534_02765531_20021029_000000</td>\n",
  765. " <td>2002-10-29</td>\n",
  766. " <td>144.285341</td>\n",
  767. " <td>-27.655315</td>\n",
  768. " <td>ls7_nbart_albers</td>\n",
  769. " <td>2002-10-25 00:06:59.500</td>\n",
  770. " <td>3 days 23:53:00.500000</td>\n",
  771. " <td>585</td>\n",
  772. " <td>1047</td>\n",
  773. " <td>1969</td>\n",
  774. " <td>2590</td>\n",
  775. " <td>4012</td>\n",
  776. " <td>3630</td>\n",
  777. " </tr>\n",
  778. " <tr>\n",
  779. " <th>473</th>\n",
  780. " <td>14581534_02035516_19980219_000055</td>\n",
  781. " <td>1998-02-19</td>\n",
  782. " <td>145.815340</td>\n",
  783. " <td>-20.355162</td>\n",
  784. " <td>ls5_nbart_albers</td>\n",
  785. " <td>1998-02-23 23:53:29.000</td>\n",
  786. " <td>-5 days +00:06:31</td>\n",
  787. " <td>310</td>\n",
  788. " <td>356</td>\n",
  789. " <td>354</td>\n",
  790. " <td>784</td>\n",
  791. " <td>657</td>\n",
  792. " <td>362</td>\n",
  793. " </tr>\n",
  794. " <tr>\n",
  795. " <th>474</th>\n",
  796. " <td>14581534_02035516_19980219_000054</td>\n",
  797. " <td>1998-02-19</td>\n",
  798. " <td>145.815340</td>\n",
  799. " <td>-20.355162</td>\n",
  800. " <td>ls5_nbart_albers</td>\n",
  801. " <td>1998-02-23 23:53:29.000</td>\n",
  802. " <td>-5 days +00:06:31</td>\n",
  803. " <td>310</td>\n",
  804. " <td>356</td>\n",
  805. " <td>354</td>\n",
  806. " <td>784</td>\n",
  807. " <td>657</td>\n",
  808. " <td>362</td>\n",
  809. " </tr>\n",
  810. " <tr>\n",
  811. " <th>475</th>\n",
  812. " <td>12177021_02889261_20121120_000000</td>\n",
  813. " <td>2012-11-20</td>\n",
  814. " <td>121.770210</td>\n",
  815. " <td>-28.892613</td>\n",
  816. " <td>ls7_nbart_albers</td>\n",
  817. " <td>2012-11-23 01:42:06.500</td>\n",
  818. " <td>-4 days +22:17:53.500000</td>\n",
  819. " <td>465</td>\n",
  820. " <td>786</td>\n",
  821. " <td>1342</td>\n",
  822. " <td>1810</td>\n",
  823. " <td>2764</td>\n",
  824. " <td>2310</td>\n",
  825. " </tr>\n",
  826. " <tr>\n",
  827. " <th>476</th>\n",
  828. " <td>13278179_02262331_20120724_000000</td>\n",
  829. " <td>2012-07-24</td>\n",
  830. " <td>132.781788</td>\n",
  831. " <td>-22.623305</td>\n",
  832. " <td>ls7_nbart_albers</td>\n",
  833. " <td>2012-07-08 01:02:07.500</td>\n",
  834. " <td>15 days 22:57:52.500000</td>\n",
  835. " <td>394</td>\n",
  836. " <td>748</td>\n",
  837. " <td>1544</td>\n",
  838. " <td>2126</td>\n",
  839. " <td>3172</td>\n",
  840. " <td>2886</td>\n",
  841. " </tr>\n",
  842. " <tr>\n",
  843. " <th>477</th>\n",
  844. " <td>14957137_02365390_20161111_000000</td>\n",
  845. " <td>2016-11-11</td>\n",
  846. " <td>149.571370</td>\n",
  847. " <td>-23.653900</td>\n",
  848. " <td>ls8_nbart_albers</td>\n",
  849. " <td>2016-10-01 23:59:42.000</td>\n",
  850. " <td>40 days 00:00:18</td>\n",
  851. " <td>296</td>\n",
  852. " <td>452</td>\n",
  853. " <td>484</td>\n",
  854. " <td>2114</td>\n",
  855. " <td>1849</td>\n",
  856. " <td>1043</td>\n",
  857. " </tr>\n",
  858. " <tr>\n",
  859. " <th>478</th>\n",
  860. " <td>13388405_01830455_20131013_000000</td>\n",
  861. " <td>2013-10-13</td>\n",
  862. " <td>133.884059</td>\n",
  863. " <td>-18.304558</td>\n",
  864. " <td>ls7_nbart_albers</td>\n",
  865. " <td>2013-10-15 01:02:14.500</td>\n",
  866. " <td>-3 days +22:57:45.500000</td>\n",
  867. " <td>880</td>\n",
  868. " <td>1356</td>\n",
  869. " <td>1844</td>\n",
  870. " <td>2489</td>\n",
  871. " <td>3194</td>\n",
  872. " <td>2731</td>\n",
  873. " </tr>\n",
  874. " <tr>\n",
  875. " <th>479</th>\n",
  876. " <td>13483787_02416085_20151008_000000</td>\n",
  877. " <td>2015-10-08</td>\n",
  878. " <td>134.837877</td>\n",
  879. " <td>-24.160860</td>\n",
  880. " <td>ls7_nbart_albers</td>\n",
  881. " <td>2015-10-07 00:55:30.500</td>\n",
  882. " <td>0 days 23:04:29.500000</td>\n",
  883. " <td>-999</td>\n",
  884. " <td>-999</td>\n",
  885. " <td>-999</td>\n",
  886. " <td>-999</td>\n",
  887. " <td>-999</td>\n",
  888. " <td>-999</td>\n",
  889. " </tr>\n",
  890. " <tr>\n",
  891. " <th>480</th>\n",
  892. " <td>15101782_03407802_20130509_000000</td>\n",
  893. " <td>2013-05-15</td>\n",
  894. " <td>151.017829</td>\n",
  895. " <td>-34.078020</td>\n",
  896. " <td>ls8_nbart_albers</td>\n",
  897. " <td>2013-05-20 23:51:55.000</td>\n",
  898. " <td>-6 days +00:08:05</td>\n",
  899. " <td>239</td>\n",
  900. " <td>341</td>\n",
  901. " <td>262</td>\n",
  902. " <td>2592</td>\n",
  903. " <td>859</td>\n",
  904. " <td>320</td>\n",
  905. " </tr>\n",
  906. " <tr>\n",
  907. " <th>481</th>\n",
  908. " <td>14621865_02021555_20041028_000000</td>\n",
  909. " <td>2004-10-28</td>\n",
  910. " <td>146.218654</td>\n",
  911. " <td>-20.215553</td>\n",
  912. " <td>ls7_nbart_albers</td>\n",
  913. " <td>2004-10-30 00:06:02.500</td>\n",
  914. " <td>-3 days +23:53:57.500000</td>\n",
  915. " <td>1163</td>\n",
  916. " <td>1409</td>\n",
  917. " <td>1802</td>\n",
  918. " <td>2765</td>\n",
  919. " <td>4023</td>\n",
  920. " <td>2658</td>\n",
  921. " </tr>\n",
  922. " <tr>\n",
  923. " <th>482</th>\n",
  924. " <td>14649962_01977882_20050407_000000</td>\n",
  925. " <td>2005-04-07</td>\n",
  926. " <td>146.499626</td>\n",
  927. " <td>-19.778826</td>\n",
  928. " <td>ls5_nbart_albers</td>\n",
  929. " <td>2005-04-08 23:58:07.000</td>\n",
  930. " <td>-2 days +00:01:53</td>\n",
  931. " <td>3931</td>\n",
  932. " <td>4063</td>\n",
  933. " <td>4176</td>\n",
  934. " <td>4996</td>\n",
  935. " <td>4361</td>\n",
  936. " <td>3253</td>\n",
  937. " </tr>\n",
  938. " <tr>\n",
  939. " <th>483</th>\n",
  940. " <td>13263975_02274420_20160517_000000</td>\n",
  941. " <td>2016-05-17</td>\n",
  942. " <td>132.639750</td>\n",
  943. " <td>-22.744200</td>\n",
  944. " <td>ls7_nbart_albers</td>\n",
  945. " <td>2016-05-16 01:09:50.500</td>\n",
  946. " <td>0 days 22:50:09.500000</td>\n",
  947. " <td>568</td>\n",
  948. " <td>1247</td>\n",
  949. " <td>2073</td>\n",
  950. " <td>2949</td>\n",
  951. " <td>4249</td>\n",
  952. " <td>3800</td>\n",
  953. " </tr>\n",
  954. " <tr>\n",
  955. " <th>484</th>\n",
  956. " <td>13082756_01784948_20120725_000000</td>\n",
  957. " <td>2012-07-25</td>\n",
  958. " <td>130.827564</td>\n",
  959. " <td>-17.849485</td>\n",
  960. " <td>ls7_nbart_albers</td>\n",
  961. " <td>2012-07-22 01:13:03.500</td>\n",
  962. " <td>2 days 22:46:56.500000</td>\n",
  963. " <td>661</td>\n",
  964. " <td>1080</td>\n",
  965. " <td>1629</td>\n",
  966. " <td>2822</td>\n",
  967. " <td>3330</td>\n",
  968. " <td>2138</td>\n",
  969. " </tr>\n",
  970. " <tr>\n",
  971. " <th>485</th>\n",
  972. " <td>13345868_02256697_20150430_000000</td>\n",
  973. " <td>2015-04-30</td>\n",
  974. " <td>133.458690</td>\n",
  975. " <td>-22.566970</td>\n",
  976. " <td>ls8_nbart_albers</td>\n",
  977. " <td>2015-04-29 01:00:31.500</td>\n",
  978. " <td>0 days 22:59:28.500000</td>\n",
  979. " <td>517</td>\n",
  980. " <td>963</td>\n",
  981. " <td>1787</td>\n",
  982. " <td>2973</td>\n",
  983. " <td>3530</td>\n",
  984. " <td>2957</td>\n",
  985. " </tr>\n",
  986. " <tr>\n",
  987. " <th>486</th>\n",
  988. " <td>14581533_02035525_19970923_000008</td>\n",
  989. " <td>1997-09-23</td>\n",
  990. " <td>145.815330</td>\n",
  991. " <td>-20.355252</td>\n",
  992. " <td>ls5_nbart_albers</td>\n",
  993. " <td>1997-09-16 23:49:38.500</td>\n",
  994. " <td>6 days 00:10:21.500000</td>\n",
  995. " <td>654</td>\n",
  996. " <td>924</td>\n",
  997. " <td>1166</td>\n",
  998. " <td>1953</td>\n",
  999. " <td>3343</td>\n",
  1000. " <td>2434</td>\n",
  1001. " </tr>\n",
  1002. " <tr>\n",
  1003. " <th>487</th>\n",
  1004. " <td>12948728_01776213_20150612_000000</td>\n",
  1005. " <td>2015-06-12</td>\n",
  1006. " <td>129.487289</td>\n",
  1007. " <td>-17.762131</td>\n",
  1008. " <td>ls8_nbart_albers</td>\n",
  1009. " <td>2015-06-12 01:23:39.000</td>\n",
  1010. " <td>-1 days +22:36:21</td>\n",
  1011. " <td>589</td>\n",
  1012. " <td>988</td>\n",
  1013. " <td>1444</td>\n",
  1014. " <td>2750</td>\n",
  1015. " <td>2777</td>\n",
  1016. " <td>1695</td>\n",
  1017. " </tr>\n",
  1018. " <tr>\n",
  1019. " <th>488</th>\n",
  1020. " <td>12172062_03086876_20101013_000000</td>\n",
  1021. " <td>2010-10-13</td>\n",
  1022. " <td>121.720622</td>\n",
  1023. " <td>-30.868759</td>\n",
  1024. " <td>ls5_nbart_albers</td>\n",
  1025. " <td>2010-10-09 01:36:32.000</td>\n",
  1026. " <td>3 days 22:23:28</td>\n",
  1027. " <td>416</td>\n",
  1028. " <td>882</td>\n",
  1029. " <td>1556</td>\n",
  1030. " <td>2105</td>\n",
  1031. " <td>3117</td>\n",
  1032. " <td>2827</td>\n",
  1033. " </tr>\n",
  1034. " <tr>\n",
  1035. " <th>489</th>\n",
  1036. " <td>13077696_01316973_20100709_000000</td>\n",
  1037. " <td>2010-07-09</td>\n",
  1038. " <td>130.776969</td>\n",
  1039. " <td>-13.169732</td>\n",
  1040. " <td>ls7_nbart_albers</td>\n",
  1041. " <td>2010-07-08 01:15:23.500</td>\n",
  1042. " <td>0 days 22:44:36.500000</td>\n",
  1043. " <td>439</td>\n",
  1044. " <td>705</td>\n",
  1045. " <td>822</td>\n",
  1046. " <td>2396</td>\n",
  1047. " <td>2224</td>\n",
  1048. " <td>1281</td>\n",
  1049. " </tr>\n",
  1050. " <tr>\n",
  1051. " <th>490</th>\n",
  1052. " <td>14581533_02035525_19970923_000007</td>\n",
  1053. " <td>1997-09-23</td>\n",
  1054. " <td>145.815330</td>\n",
  1055. " <td>-20.355252</td>\n",
  1056. " <td>ls5_nbart_albers</td>\n",
  1057. " <td>1997-09-16 23:49:38.500</td>\n",
  1058. " <td>6 days 00:10:21.500000</td>\n",
  1059. " <td>654</td>\n",
  1060. " <td>924</td>\n",
  1061. " <td>1166</td>\n",
  1062. " <td>1953</td>\n",
  1063. " <td>3343</td>\n",
  1064. " <td>2434</td>\n",
  1065. " </tr>\n",
  1066. " <tr>\n",
  1067. " <th>491</th>\n",
  1068. " <td>13217973_02336796_20160419_000000</td>\n",
  1069. " <td>2016-04-19</td>\n",
  1070. " <td>132.179735</td>\n",
  1071. " <td>-23.367963</td>\n",
  1072. " <td>ls8_nbart_albers</td>\n",
  1073. " <td>2016-04-22 01:06:58.000</td>\n",
  1074. " <td>-4 days +22:53:02</td>\n",
  1075. " <td>750</td>\n",
  1076. " <td>1234</td>\n",
  1077. " <td>1931</td>\n",
  1078. " <td>2864</td>\n",
  1079. " <td>3600</td>\n",
  1080. " <td>3074</td>\n",
  1081. " </tr>\n",
  1082. " <tr>\n",
  1083. " <th>492</th>\n",
  1084. " <td>14301306_03424540_20090515_000000</td>\n",
  1085. " <td>2009-05-15</td>\n",
  1086. " <td>143.013065</td>\n",
  1087. " <td>-34.245408</td>\n",
  1088. " <td>ls7_nbart_albers</td>\n",
  1089. " <td>2009-05-14 00:05:26.500</td>\n",
  1090. " <td>0 days 23:54:33.500000</td>\n",
  1091. " <td>5017</td>\n",
  1092. " <td>5168</td>\n",
  1093. " <td>5303</td>\n",
  1094. " <td>5756</td>\n",
  1095. " <td>3996</td>\n",
  1096. " <td>2531</td>\n",
  1097. " </tr>\n",
  1098. " <tr>\n",
  1099. " <th>493</th>\n",
  1100. " <td>13095656_01606620_20141014_000000</td>\n",
  1101. " <td>2014-10-14</td>\n",
  1102. " <td>130.956569</td>\n",
  1103. " <td>-16.066206</td>\n",
  1104. " <td>ls7_nbart_albers</td>\n",
  1105. " <td>2014-10-16 01:15:47.500</td>\n",
  1106. " <td>-3 days +22:44:12.500000</td>\n",
  1107. " <td>593</td>\n",
  1108. " <td>917</td>\n",
  1109. " <td>1373</td>\n",
  1110. " <td>2706</td>\n",
  1111. " <td>3131</td>\n",
  1112. " <td>2057</td>\n",
  1113. " </tr>\n",
  1114. " <tr>\n",
  1115. " <th>494</th>\n",
  1116. " <td>13232438_02217658_20140401_000000</td>\n",
  1117. " <td>2014-04-01</td>\n",
  1118. " <td>132.324383</td>\n",
  1119. " <td>-22.176587</td>\n",
  1120. " <td>ls8_nbart_albers</td>\n",
  1121. " <td>2014-04-01 01:07:15.500</td>\n",
  1122. " <td>-1 days +22:52:44.500000</td>\n",
  1123. " <td>638</td>\n",
  1124. " <td>1142</td>\n",
  1125. " <td>2069</td>\n",
  1126. " <td>3469</td>\n",
  1127. " <td>4154</td>\n",
  1128. " <td>3357</td>\n",
  1129. " </tr>\n",
  1130. " <tr>\n",
  1131. " <th>495</th>\n",
  1132. " <td>13589073_01900717_20160810_000000</td>\n",
  1133. " <td>2016-08-10</td>\n",
  1134. " <td>135.890730</td>\n",
  1135. " <td>-19.007170</td>\n",
  1136. " <td>ls7_nbart_albers</td>\n",
  1137. " <td>2016-08-13 01:02:41.000</td>\n",
  1138. " <td>-4 days +22:57:19</td>\n",
  1139. " <td>-999</td>\n",
  1140. " <td>-999</td>\n",
  1141. " <td>-999</td>\n",
  1142. " <td>-999</td>\n",
  1143. " <td>3134</td>\n",
  1144. " <td>2269</td>\n",
  1145. " </tr>\n",
  1146. " <tr>\n",
  1147. " <th>496</th>\n",
  1148. " <td>13341858_01736592_20130414_000000</td>\n",
  1149. " <td>2013-04-14</td>\n",
  1150. " <td>133.418590</td>\n",
  1151. " <td>-17.365926</td>\n",
  1152. " <td>ls8_nbart_albers</td>\n",
  1153. " <td>2013-04-14 01:07:39.000</td>\n",
  1154. " <td>-1 days +22:52:21</td>\n",
  1155. " <td>783</td>\n",
  1156. " <td>1043</td>\n",
  1157. " <td>1245</td>\n",
  1158. " <td>2178</td>\n",
  1159. " <td>3211</td>\n",
  1160. " <td>2422</td>\n",
  1161. " </tr>\n",
  1162. " <tr>\n",
  1163. " <th>497</th>\n",
  1164. " <td>13329087_02591711_20130606_000000</td>\n",
  1165. " <td>2013-06-06</td>\n",
  1166. " <td>133.290880</td>\n",
  1167. " <td>-25.917116</td>\n",
  1168. " <td>ls8_nbart_albers</td>\n",
  1169. " <td>2013-05-25 01:04:06.500</td>\n",
  1170. " <td>11 days 22:55:53.500000</td>\n",
  1171. " <td>469</td>\n",
  1172. " <td>892</td>\n",
  1173. " <td>1655</td>\n",
  1174. " <td>2279</td>\n",
  1175. " <td>3266</td>\n",
  1176. " <td>2812</td>\n",
  1177. " </tr>\n",
  1178. " </tbody>\n",
  1179. "</table>\n",
  1180. "<p>498 rows × 13 columns</p>\n",
  1181. "</div>"
  1182. ],
  1183. "text/plain": [
  1184. " fieldsite_key fieldsite_time lon lat \\\n",
  1185. "0 15282706_02742904_20101216_000000 2010-12-16 152.827067 -27.429043 \n",
  1186. "1 12191981_03088325_20101013_000000 2010-10-13 121.919808 -30.883252 \n",
  1187. "2 14432646_02760430_20021030_000000 2002-10-30 144.326462 -27.604300 \n",
  1188. "3 13399362_02377054_20120608_000000 2012-06-08 133.993630 -23.770550 \n",
  1189. "4 13577022_02114920_20160804_000000 2016-08-04 135.770220 -21.149200 \n",
  1190. "5 12456729_01785321_20120828_000000 2012-08-28 124.567289 -17.853211 \n",
  1191. "6 13466259_02126378_20150527_000000 2015-05-27 134.662596 -21.263788 \n",
  1192. "7 15310119_02595226_20100630_130000 2010-06-30 153.101190 -25.952261 \n",
  1193. "8 13747621_01831000_20110922_000000 2011-09-22 137.476219 -18.310003 \n",
  1194. "9 14846057_02824703_20161101_000000 2016-11-01 148.460570 -28.247030 \n",
  1195. "10 14653153_01980285_20060421_000000 2006-04-21 146.531535 -19.802851 \n",
  1196. "11 14598394_01949405_19971001_000038 1997-10-01 145.983940 -19.494059 \n",
  1197. "12 13622756_02193975_20160824_000000 2016-08-24 136.227561 -21.939750 \n",
  1198. "13 14815056_03565651_20110111_000000 2011-01-11 148.150571 -35.656517 \n",
  1199. "14 11681968_02097839_20110822_000000 2011-08-22 116.819682 -20.978394 \n",
  1200. "15 13440487_01852067_20141003_000000 2014-10-03 134.404874 -18.520673 \n",
  1201. "16 12966402_01786564_20150618_000000 2015-06-18 129.664027 -17.865643 \n",
  1202. "17 13067934_01823514_20150523_000000 2015-05-23 130.679340 -18.235140 \n",
  1203. "18 13521250_01735842_20130809_000000 2013-08-09 135.212502 -17.358425 \n",
  1204. "19 14566707_01950722_20160830_000000 2016-08-30 145.667070 -19.507220 \n",
  1205. "20 13483730_02579251_20140909_000000 2014-09-09 134.837309 -25.792517 \n",
  1206. "21 15305673_02600155_20151111_043000 2015-11-11 153.056730 -26.001550 \n",
  1207. "22 13866228_03002524_20120426_000000 2012-04-26 138.662281 -30.025238 \n",
  1208. "23 14615343_02029290_19970929_000027 1997-09-29 146.153432 -20.292903 \n",
  1209. "24 11899442_02800782_20120912_000000 2012-09-12 118.994425 -28.007822 \n",
  1210. "25 14918061_03520130_20140223_234900 2014-02-23 149.180610 -35.201300 \n",
  1211. "26 13086485_01780029_20120725_000000 2012-07-25 130.864855 -17.800298 \n",
  1212. "27 13636614_01776261_20130515_000000 2013-05-15 136.366143 -17.762619 \n",
  1213. "28 13273949_02344746_20160925_000000 2016-09-25 132.739495 -23.447462 \n",
  1214. "29 13630686_02710211_20120414_000000 2012-04-14 136.306863 -27.102109 \n",
  1215. ".. ... ... ... ... \n",
  1216. "468 14521058_03001795_20121017_000000 2012-10-17 145.210583 -30.017948 \n",
  1217. "469 13019522_01777534_20150613_000000 2015-06-13 130.195220 -17.775340 \n",
  1218. "470 13046504_03146915_20121129_000000 2012-11-29 130.465039 -31.469155 \n",
  1219. "471 13397399_02446000_20130919_000000 2013-09-19 133.974000 -24.460000 \n",
  1220. "472 14428534_02765531_20021029_000000 2002-10-29 144.285341 -27.655315 \n",
  1221. "473 14581534_02035516_19980219_000055 1998-02-19 145.815340 -20.355162 \n",
  1222. "474 14581534_02035516_19980219_000054 1998-02-19 145.815340 -20.355162 \n",
  1223. "475 12177021_02889261_20121120_000000 2012-11-20 121.770210 -28.892613 \n",
  1224. "476 13278179_02262331_20120724_000000 2012-07-24 132.781788 -22.623305 \n",
  1225. "477 14957137_02365390_20161111_000000 2016-11-11 149.571370 -23.653900 \n",
  1226. "478 13388405_01830455_20131013_000000 2013-10-13 133.884059 -18.304558 \n",
  1227. "479 13483787_02416085_20151008_000000 2015-10-08 134.837877 -24.160860 \n",
  1228. "480 15101782_03407802_20130509_000000 2013-05-15 151.017829 -34.078020 \n",
  1229. "481 14621865_02021555_20041028_000000 2004-10-28 146.218654 -20.215553 \n",
  1230. "482 14649962_01977882_20050407_000000 2005-04-07 146.499626 -19.778826 \n",
  1231. "483 13263975_02274420_20160517_000000 2016-05-17 132.639750 -22.744200 \n",
  1232. "484 13082756_01784948_20120725_000000 2012-07-25 130.827564 -17.849485 \n",
  1233. "485 13345868_02256697_20150430_000000 2015-04-30 133.458690 -22.566970 \n",
  1234. "486 14581533_02035525_19970923_000008 1997-09-23 145.815330 -20.355252 \n",
  1235. "487 12948728_01776213_20150612_000000 2015-06-12 129.487289 -17.762131 \n",
  1236. "488 12172062_03086876_20101013_000000 2010-10-13 121.720622 -30.868759 \n",
  1237. "489 13077696_01316973_20100709_000000 2010-07-09 130.776969 -13.169732 \n",
  1238. "490 14581533_02035525_19970923_000007 1997-09-23 145.815330 -20.355252 \n",
  1239. "491 13217973_02336796_20160419_000000 2016-04-19 132.179735 -23.367963 \n",
  1240. "492 14301306_03424540_20090515_000000 2009-05-15 143.013065 -34.245408 \n",
  1241. "493 13095656_01606620_20141014_000000 2014-10-14 130.956569 -16.066206 \n",
  1242. "494 13232438_02217658_20140401_000000 2014-04-01 132.324383 -22.176587 \n",
  1243. "495 13589073_01900717_20160810_000000 2016-08-10 135.890730 -19.007170 \n",
  1244. "496 13341858_01736592_20130414_000000 2013-04-14 133.418590 -17.365926 \n",
  1245. "497 13329087_02591711_20130606_000000 2013-06-06 133.290880 -25.917116 \n",
  1246. "\n",
  1247. " observation_product observation_date time_delta \\\n",
  1248. "0 ls5_nbart_albers 2010-12-15 23:31:57.500 0 days 00:28:02.500000 \n",
  1249. "1 ls7_nbart_albers 2010-10-10 01:33:03.500 2 days 22:26:56.500000 \n",
  1250. "2 ls7_nbart_albers 2002-10-25 00:06:59.500 4 days 23:53:00.500000 \n",
  1251. "3 ls7_nbart_albers 2012-06-15 00:55:40.500 -8 days +23:04:19.500000 \n",
  1252. "4 ls8_nbart_albers 2016-07-29 00:54:41.500 5 days 23:05:18.500000 \n",
  1253. "5 ls7_nbart_albers 2012-09-04 01:38:16.000 -8 days +22:21:44 \n",
  1254. "6 ls7_nbart_albers 2015-05-23 01:00:19.000 3 days 22:59:41 \n",
  1255. "7 ls7_nbart_albers 2010-06-21 23:40:03.500 8 days 00:19:56.500000 \n",
  1256. "8 ls5_nbart_albers 2011-09-18 00:42:21.000 3 days 23:17:39 \n",
  1257. "9 ls8_nbart_albers 2016-10-02 00:01:18.000 29 days 23:58:42 \n",
  1258. "10 ls7_nbart_albers 2006-04-27 00:07:13.500 -7 days +23:52:46.500000 \n",
  1259. "11 ls5_nbart_albers 1997-10-02 23:50:07.000 -2 days +00:09:53 \n",
  1260. "12 ls7_nbart_albers 2016-08-22 00:57:19.500 1 days 23:02:40.500000 \n",
  1261. "13 ls5_nbart_albers 2011-01-14 23:46:48.500 -4 days +00:13:11.500000 \n",
  1262. "14 ls7_nbart_albers 2011-08-20 02:08:25.500 1 days 21:51:34.500000 \n",
  1263. "15 ls7_nbart_albers 2014-10-02 01:04:07.000 0 days 22:55:53 \n",
  1264. "16 ls7_nbart_albers 2015-06-20 01:23:59.500 -3 days +22:36:00.500000 \n",
  1265. "17 ls8_nbart_albers 2015-05-20 01:17:39.000 2 days 22:42:21 \n",
  1266. "18 ls7_nbart_albers 2013-08-05 00:54:55.500 3 days 23:05:04.500000 \n",
  1267. "19 ls7_nbart_albers 2016-08-28 00:19:52.500 1 days 23:40:07.500000 \n",
  1268. "20 ls8_nbart_albers 2014-09-10 00:56:01.000 -2 days +23:03:59 \n",
  1269. "21 ls8_nbart_albers 2015-11-11 23:41:49.000 -1 days +00:18:11 \n",
  1270. "22 ls7_nbart_albers 2012-05-02 00:33:00.500 -7 days +23:26:59.500000 \n",
  1271. "23 ls5_nbart_albers 1997-10-02 23:50:07.000 -4 days +00:09:53 \n",
  1272. "24 ls7_nbart_albers 2012-09-18 01:53:31.500 -7 days +22:06:28.500000 \n",
  1273. "25 ls8_nbart_albers 2014-02-23 23:57:13.000 -1 days +00:02:47 \n",
  1274. "26 ls7_nbart_albers 2012-07-22 01:13:03.500 2 days 22:46:56.500000 \n",
  1275. "27 ls8_nbart_albers 2013-05-18 00:55:29.000 -4 days +23:04:31 \n",
  1276. "28 ls8_nbart_albers 2016-09-29 01:07:40.000 -5 days +22:52:20 \n",
  1277. "29 ls7_nbart_albers 2012-04-14 00:44:09.000 -1 days +23:15:51 \n",
  1278. ".. ... ... ... \n",
  1279. "468 ls7_nbart_albers 2012-10-13 00:09:30.500 3 days 23:50:29.500000 \n",
  1280. "469 ls8_nbart_albers 2015-06-12 01:23:39.000 0 days 22:36:21 \n",
  1281. "470 ls7_nbart_albers 2012-11-29 01:05:49.500 -1 days +22:54:10.500000 \n",
  1282. "471 ls7_nbart_albers 2013-09-22 00:57:21.500 -4 days +23:02:38.500000 \n",
  1283. "472 ls7_nbart_albers 2002-10-25 00:06:59.500 3 days 23:53:00.500000 \n",
  1284. "473 ls5_nbart_albers 1998-02-23 23:53:29.000 -5 days +00:06:31 \n",
  1285. "474 ls5_nbart_albers 1998-02-23 23:53:29.000 -5 days +00:06:31 \n",
  1286. "475 ls7_nbart_albers 2012-11-23 01:42:06.500 -4 days +22:17:53.500000 \n",
  1287. "476 ls7_nbart_albers 2012-07-08 01:02:07.500 15 days 22:57:52.500000 \n",
  1288. "477 ls8_nbart_albers 2016-10-01 23:59:42.000 40 days 00:00:18 \n",
  1289. "478 ls7_nbart_albers 2013-10-15 01:02:14.500 -3 days +22:57:45.500000 \n",
  1290. "479 ls7_nbart_albers 2015-10-07 00:55:30.500 0 days 23:04:29.500000 \n",
  1291. "480 ls8_nbart_albers 2013-05-20 23:51:55.000 -6 days +00:08:05 \n",
  1292. "481 ls7_nbart_albers 2004-10-30 00:06:02.500 -3 days +23:53:57.500000 \n",
  1293. "482 ls5_nbart_albers 2005-04-08 23:58:07.000 -2 days +00:01:53 \n",
  1294. "483 ls7_nbart_albers 2016-05-16 01:09:50.500 0 days 22:50:09.500000 \n",
  1295. "484 ls7_nbart_albers 2012-07-22 01:13:03.500 2 days 22:46:56.500000 \n",
  1296. "485 ls8_nbart_albers 2015-04-29 01:00:31.500 0 days 22:59:28.500000 \n",
  1297. "486 ls5_nbart_albers 1997-09-16 23:49:38.500 6 days 00:10:21.500000 \n",
  1298. "487 ls8_nbart_albers 2015-06-12 01:23:39.000 -1 days +22:36:21 \n",
  1299. "488 ls5_nbart_albers 2010-10-09 01:36:32.000 3 days 22:23:28 \n",
  1300. "489 ls7_nbart_albers 2010-07-08 01:15:23.500 0 days 22:44:36.500000 \n",
  1301. "490 ls5_nbart_albers 1997-09-16 23:49:38.500 6 days 00:10:21.500000 \n",
  1302. "491 ls8_nbart_albers 2016-04-22 01:06:58.000 -4 days +22:53:02 \n",
  1303. "492 ls7_nbart_albers 2009-05-14 00:05:26.500 0 days 23:54:33.500000 \n",
  1304. "493 ls7_nbart_albers 2014-10-16 01:15:47.500 -3 days +22:44:12.500000 \n",
  1305. "494 ls8_nbart_albers 2014-04-01 01:07:15.500 -1 days +22:52:44.500000 \n",
  1306. "495 ls7_nbart_albers 2016-08-13 01:02:41.000 -4 days +22:57:19 \n",
  1307. "496 ls8_nbart_albers 2013-04-14 01:07:39.000 -1 days +22:52:21 \n",
  1308. "497 ls8_nbart_albers 2013-05-25 01:04:06.500 11 days 22:55:53.500000 \n",
  1309. "\n",
  1310. " blue green red nir swir1 swir2 \n",
  1311. "0 183 359 329 2276 1174 354 \n",
  1312. "1 -999 -999 -999 -999 -999 -999 \n",
  1313. "2 519 905 1632 2285 3454 2916 \n",
  1314. "3 755 954 1160 1768 2462 1866 \n",
  1315. "4 515 866 1159 2378 3046 2326 \n",
  1316. "5 886 1167 1447 2149 2717 2248 \n",
  1317. "6 635 1187 2006 2853 3790 2935 \n",
  1318. "7 -999 -999 7122 7422 3647 1984 \n",
  1319. "8 524 901 1159 2099 2670 1860 \n",
  1320. "9 830 987 975 2327 1670 1165 \n",
  1321. "10 1692 1873 1927 3618 3074 2547 \n",
  1322. "11 944 1391 1804 2785 4797 3664 \n",
  1323. "12 364 607 982 1470 2137 1597 \n",
  1324. "13 160 268 284 2044 891 301 \n",
  1325. "14 538 883 1406 2173 3145 2566 \n",
  1326. "15 949 1528 2124 3004 3373 2508 \n",
  1327. "16 727 1294 2191 3233 3556 2272 \n",
  1328. "17 592 1075 1659 2859 2886 2320 \n",
  1329. "18 454 705 878 1739 2577 1735 \n",
  1330. "19 454 792 988 2485 3015 2086 \n",
  1331. "20 600 1126 2507 3435 5018 4349 \n",
  1332. "21 5025 4796 4749 5222 2754 1820 \n",
  1333. "22 808 1449 2294 3106 3765 3110 \n",
  1334. "23 670 1179 1735 2508 4652 3827 \n",
  1335. "24 1649 1941 2590 3290 3492 2587 \n",
  1336. "25 582 802 1044 1854 3644 2551 \n",
  1337. "26 -999 -999 -999 2730 3297 2615 \n",
  1338. "27 5831 5761 6013 6015 4512 3500 \n",
  1339. "28 631 1129 1857 2750 4051 3743 \n",
  1340. "29 1374 1874 2110 4260 3823 2791 \n",
  1341. ".. ... ... ... ... ... ... \n",
  1342. "468 861 1101 1375 2028 3300 2369 \n",
  1343. "469 730 1119 1616 2568 2899 1971 \n",
  1344. "470 687 1047 1536 2317 3454 2875 \n",
  1345. "471 692 1249 2335 3147 4377 3972 \n",
  1346. "472 585 1047 1969 2590 4012 3630 \n",
  1347. "473 310 356 354 784 657 362 \n",
  1348. "474 310 356 354 784 657 362 \n",
  1349. "475 465 786 1342 1810 2764 2310 \n",
  1350. "476 394 748 1544 2126 3172 2886 \n",
  1351. "477 296 452 484 2114 1849 1043 \n",
  1352. "478 880 1356 1844 2489 3194 2731 \n",
  1353. "479 -999 -999 -999 -999 -999 -999 \n",
  1354. "480 239 341 262 2592 859 320 \n",
  1355. "481 1163 1409 1802 2765 4023 2658 \n",
  1356. "482 3931 4063 4176 4996 4361 3253 \n",
  1357. "483 568 1247 2073 2949 4249 3800 \n",
  1358. "484 661 1080 1629 2822 3330 2138 \n",
  1359. "485 517 963 1787 2973 3530 2957 \n",
  1360. "486 654 924 1166 1953 3343 2434 \n",
  1361. "487 589 988 1444 2750 2777 1695 \n",
  1362. "488 416 882 1556 2105 3117 2827 \n",
  1363. "489 439 705 822 2396 2224 1281 \n",
  1364. "490 654 924 1166 1953 3343 2434 \n",
  1365. "491 750 1234 1931 2864 3600 3074 \n",
  1366. "492 5017 5168 5303 5756 3996 2531 \n",
  1367. "493 593 917 1373 2706 3131 2057 \n",
  1368. "494 638 1142 2069 3469 4154 3357 \n",
  1369. "495 -999 -999 -999 -999 3134 2269 \n",
  1370. "496 783 1043 1245 2178 3211 2422 \n",
  1371. "497 469 892 1655 2279 3266 2812 \n",
  1372. "\n",
  1373. "[498 rows x 13 columns]"
  1374. ]
  1375. },
  1376. "execution_count": 34,
  1377. "metadata": {},
  1378. "output_type": "execute_result"
  1379. }
  1380. ],
  1381. "source": [
  1382. "df"
  1383. ]
  1384. }
  1385. ],
  1386. "metadata": {
  1387. "kernelspec": {
  1388. "display_name": "Python 3",
  1389. "language": "python",
  1390. "name": "python3"
  1391. },
  1392. "language_info": {
  1393. "codemirror_mode": {
  1394. "name": "ipython",
  1395. "version": 3.0
  1396. },
  1397. "file_extension": ".py",
  1398. "mimetype": "text/x-python",
  1399. "name": "python",
  1400. "nbconvert_exporter": "python",
  1401. "pygments_lexer": "ipython3",
  1402. "version": "3.6.1"
  1403. }
  1404. },
  1405. "nbformat": 4,
  1406. "nbformat_minor": 0
  1407. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!