In [1]:
import numpy as np
%matplotlib inline
import matplotlib.pyplot as plt
import pandas as pd
import csv
from math import sin, cos, sqrt, atan2, radians

In [2]:
#read point of interest data
poi_data = pd.read_csv("data/nodub/hotspot_2015.csv", parse_dates=['datetime'], usecols=['latitude','longitude','datetime', 'power'])
poi_data.head()


Out[2]:
datetime latitude longitude power
0 2015-06-27 04:00:00 -13.2 134.0 3.2
1 2015-10-19 04:00:00 -37.9 145.3 3.2
2 2015-10-20 02:00:00 -32.1 115.9 3.4
3 2015-10-20 02:00:00 -31.9 115.9 3.4
4 2015-03-24 02:00:00 -31.9 115.9 3.5

In [3]:
poi_data.sort_values(["datetime", "latitude", "longitude"],axis=0,inplace=True)
poi_data.head()


Out[3]:
datetime latitude longitude power
18255 2015-01-01 01:00:00 -17.2 145.9 10.0
28109 2015-01-01 01:00:00 -15.9 136.6 11.9
38325 2015-01-01 01:00:00 -15.1 144.4 14.2
1704 2015-01-01 02:00:00 -32.1 115.8 6.4
9116 2015-01-01 02:00:00 -32.1 115.9 8.3

In [4]:
print (poi_data.shape)


(82583, 4)

In [5]:
if len(poi_data.columns) < 3  or'datetime' not in poi_data.columns or 'latitude' not in poi_data.columns or 'longitude' not in poi_data.columns:
    
    print ("Wrong format!")

In [6]:
#read the consolidated sesnosrs data 
data_sources = ['ta', 'wd', 'ws', 'rh', 'fsd']#, 'precip']
sensors_data = []
for i,d in  enumerate(data_sources):
    tmp = pd.read_csv("data/nodub/"+d+".csv", parse_dates=['datetime'])
    if len(tmp.columns) < 4 or 'value' not in tmp.columns or 'datetime' not in tmp.columns or 'latitude' not in tmp.columns or 'longitude' not in tmp.columns:
        print ("Wrong format!")
        continue
    print (tmp.shape)
    tmp.sort_values(["datetime", "latitude", "longitude"],axis=0,inplace=True)
    sensors_data.append(tmp)
if len(sensors_data) != len(data_sources):
    print ("Sizes don't match")
sensors_data[0].head()


(29930, 4)
(29930, 4)
(29930, 4)
(29930, 4)
(29930, 4)
Out[6]:
datetime latitude longitude value
0 2015-01-01 -43.1 146.6 12.459337
1 2015-01-01 -42.4 147.4 13.768324
2 2015-01-01 -41.6 147.4 14.542662
3 2015-01-01 -40.9 145.9 13.806694
4 2015-01-01 -40.1 145.1 15.747588

In [ ]:
def isInArea(lt1, lng1, lt2, lng2, radius):
    # approximate radius of earth in km
    R = 6373.0

    lat1 = radians(float(lt1))
    lon1 = radians(float(lng1))
    lat2 = radians(float(lt2))
    lon2 = radians(float(lng2))

    dlon = lon2 - lon1
    dlat = lat2 - lat1

    a = sin(dlat / 2)**2 + cos(lat1) * cos(lat2) * sin(dlon / 2)**2
    c = 2 * atan2(sqrt(a), sqrt(1 - a))

    distance = R * c # in kms
    
    return  distance < radius

In [ ]:
items_completed = 0


interval = 3
radius = 100
csv_file =  open('hotspots_with_average_sensors_data.csv', 'w', 1)
writer = csv.writer(csv_file)
row = ["datetime","latitude","longitude"]


for l in data_sources :
    poi_data[l] = np.zeros([len(poi_data)])
    row.append(l)
    
if not items_completed:
    print (row)
    writer.writerow(row)
else:
    items_completed += 1
    
offset =  pd.DateOffset(interval)

start = 0
for i,d in enumerate(poi_data.datetime):
    
        #i += items_completed
        
        row = [d,round(poi_data.latitude[i],1),round(poi_data.longitude[i],1)]
        for j,l in enumerate(data_sources):
            summary = 0;
            count = 0
            for k,s in enumerate(sensors_data[j].datetime[start:]):
                
                if s > d:
                    break
                if s < d-offset:
                    start = k
                    continue
                    
                if isInArea(poi_data.latitude[i], poi_data.longitude[i], sensors_data[j].latitude[k], sensors_data[j].longitude[k], radius) :
                    #print (str(i+100)+","+str(k)+": "+ str(sensors_data[j].value[k]))
                    summary += float(sensors_data[j].value[k])
                    #print (sensors_data[j].value[k])
                    count += 1
            if count and summary > 0:
                #print ("Sum: " + str(summary) + " Count: " + str(count))
                poi_data.loc[l,i] = (summary/count)
                row.append(summary/count)
            else:
                print (str(i) +". " + str(d) + " (" + str(poi_data.latitude[i])  + "," + str(poi_data.longitude[i]) +  ") - " + l + " is missing." )
                break
        
        if len(row) == (len(data_sources)+3):
            writer.writerow(row)
            
            
            

                    
poi_data.head()
csv_file.close()


['datetime', 'latitude', 'longitude', 'ta', 'wd', 'ws', 'rh', 'fsd']
0. 2015-01-01 01:00:00 (-13.2,134.0) - ta is missing.
14. 2015-01-01 03:00:00 (-31.4,151.1) - ta is missing.
15. 2015-01-01 03:00:00 (-33.9,118.0) - ta is missing.
17. 2015-01-01 03:00:00 (-17.9,135.9) - ta is missing.
18. 2015-01-01 03:00:00 (-33.0,116.9) - ta is missing.
19. 2015-01-01 03:00:00 (-18.8,131.3) - ta is missing.
20. 2015-01-01 03:00:00 (-13.7,134.3) - ta is missing.
23. 2015-01-01 03:00:00 (-14.7,141.6) - ta is missing.
24. 2015-01-01 03:00:00 (-12.5,136.2) - ta is missing.
26. 2015-01-01 03:00:00 (-28.7,151.9) - ta is missing.
34. 2015-01-01 03:00:00 (-15.3,128.2) - ta is missing.
35. 2015-01-01 03:00:00 (-16.1,130.3) - ta is missing.
36. 2015-01-01 05:00:00 (-16.3,125.7) - ta is missing.
37. 2015-01-01 05:00:00 (-23.2,123.2) - ta is missing.
38. 2015-01-01 05:00:00 (-14.5,133.2) - ta is missing.
41. 2015-01-01 14:00:00 (-15.2,131.2) - ta is missing.
48. 2015-01-02 00:00:00 (-16.0,125.7) - ta is missing.
49. 2015-01-02 00:00:00 (-14.3,132.0) - ta is missing.
50. 2015-01-02 01:00:00 (-22.4,123.8) - ta is missing.
51. 2015-01-02 01:00:00 (-14.3,130.1) - ta is missing.
52. 2015-01-02 01:00:00 (-12.2,132.2) - ta is missing.
54. 2015-01-02 01:00:00 (-19.6,130.5) - ta is missing.
58. 2015-01-02 01:00:00 (-18.0,143.0) - ta is missing.
62. 2015-01-02 04:00:00 (-33.1,135.1) - ta is missing.
64. 2015-01-02 04:00:00 (-12.6,132.9) - ta is missing.
65. 2015-01-02 04:00:00 (-14.3,132.8) - ta is missing.
66. 2015-01-02 04:00:00 (-14.4,130.1) - ta is missing.
67. 2015-01-02 04:00:00 (-15.3,141.8) - ta is missing.
68. 2015-01-02 04:00:00 (-16.6,133.3) - ta is missing.
70. 2015-01-02 04:00:00 (-26.0,146.6) - ta is missing.
72. 2015-01-02 06:00:00 (-16.6,143.8) - ta is missing.
75. 2015-01-02 06:00:00 (-17.3,127.7) - ta is missing.
76. 2015-01-02 06:00:00 (-32.1,133.7) - ta is missing.
77. 2015-01-02 06:00:00 (-31.1,116.8) - ta is missing.
79. 2015-01-02 06:00:00 (-34.3,145.9) - ta is missing.
80. 2015-01-02 13:00:00 (-31.6,117.3) - ta is missing.
81. 2015-01-02 13:00:00 (-15.4,131.2) - ta is missing.
82. 2015-01-02 13:00:00 (-16.5,130.4) - ta is missing.
84. 2015-01-02 13:00:00 (-12.3,133.3) - ta is missing.
86. 2015-01-02 13:00:00 (-27.7,152.2) - ta is missing.
88. 2015-01-02 14:00:00 (-11.8,133.1) - ta is missing.
89. 2015-01-02 17:00:00 (-16.7,143.0) - ta is missing.
92. 2015-01-03 00:00:00 (-19.1,135.9) - ta is missing.
93. 2015-01-03 00:00:00 (-22.3,118.4) - ta is missing.
94. 2015-01-03 00:00:00 (-27.7,118.2) - ta is missing.
98. 2015-01-03 00:00:00 (-22.7,145.4) - ta is missing.
101. 2015-01-03 00:00:00 (-15.9,128.2) - ta is missing.
102. 2015-01-03 02:00:00 (-16.2,125.0) - ta is missing.
103. 2015-01-03 02:00:00 (-17.5,126.9) - ta is missing.
104. 2015-01-03 02:00:00 (-15.3,126.3) - ta is missing.
105. 2015-01-03 02:00:00 (-16.3,125.7) - ta is missing.
106. 2015-01-03 02:00:00 (-16.7,125.6) - ta is missing.
107. 2015-01-03 02:00:00 (-12.4,133.4) - ta is missing.
108. 2015-01-03 02:00:00 (-12.2,133.1) - ta is missing.
109. 2015-01-03 02:00:00 (-13.4,134.0) - ta is missing.
110. 2015-01-03 02:00:00 (-15.5,144.3) - ta is missing.
113. 2015-01-03 02:00:00 (-15.6,128.7) - ta is missing.
119. 2015-01-03 02:00:00 (-16.9,134.6) - ta is missing.
120. 2015-01-03 02:00:00 (-14.4,134.1) - ta is missing.
121. 2015-01-03 02:00:00 (-19.3,142.9) - ta is missing.
122. 2015-01-03 02:00:00 (-28.4,137.5) - ta is missing.
125. 2015-01-03 03:00:00 (-14.1,131.4) - ta is missing.
128. 2015-01-03 03:00:00 (-35.1,142.0) - ta is missing.
129. 2015-01-03 03:00:00 (-32.1,117.0) - ta is missing.
130. 2015-01-03 03:00:00 (-15.6,131.4) - ta is missing.
132. 2015-01-03 03:00:00 (-16.0,134.4) - ta is missing.
133. 2015-01-03 03:00:00 (-16.7,125.9) - ta is missing.
134. 2015-01-03 03:00:00 (-13.9,130.1) - ta is missing.
135. 2015-01-03 03:00:00 (-13.7,132.1) - ta is missing.
136. 2015-01-03 03:00:00 (-16.9,128.1) - ta is missing.
137. 2015-01-03 03:00:00 (-14.5,141.9) - ta is missing.
139. 2015-01-03 03:00:00 (-14.3,131.4) - ta is missing.
140. 2015-01-03 03:00:00 (-18.9,136.7) - ta is missing.
141. 2015-01-03 05:00:00 (-15.4,133.5) - ta is missing.
142. 2015-01-03 05:00:00 (-14.9,134.3) - ta is missing.
144. 2015-01-03 05:00:00 (-15.2,125.5) - ta is missing.
145. 2015-01-03 05:00:00 (-15.3,125.4) - ta is missing.
146. 2015-01-03 05:00:00 (-15.6,124.5) - ta is missing.
148. 2015-01-03 05:00:00 (-30.0,151.0) - ta is missing.
157. 2015-01-03 05:00:00 (-37.4,147.0) - ta is missing.
158. 2015-01-03 12:00:00 (-33.0,137.6) - ta is missing.
159. 2015-01-03 12:00:00 (-23.4,150.7) - ta is missing.
161. 2015-01-03 12:00:00 (-16.8,125.8) - ta is missing.
162. 2015-01-03 12:00:00 (-14.4,127.3) - ta is missing.
163. 2015-01-03 12:00:00 (-15.8,135.1) - ta is missing.
165. 2015-01-03 12:00:00 (-14.2,126.7) - ta is missing.
166. 2015-01-03 12:00:00 (-16.3,136.9) - ta is missing.
167. 2015-01-03 12:00:00 (-13.3,131.9) - ta is missing.
168. 2015-01-03 12:00:00 (-14.3,129.8) - ta is missing.
170. 2015-01-03 13:00:00 (-24.2,150.2) - ta is missing.
171. 2015-01-03 13:00:00 (-14.7,141.7) - ta is missing.
173. 2015-01-03 14:00:00 (-26.8,152.3) - ta is missing.
174. 2015-01-03 14:00:00 (-13.4,132.5) - ta is missing.
177. 2015-01-03 14:00:00 (-14.6,125.6) - ta is missing.
178. 2015-01-03 14:00:00 (-14.6,125.6) - ta is missing.
181. 2015-01-03 14:00:00 (-15.5,128.2) - ta is missing.
182. 2015-01-03 14:00:00 (-16.8,129.4) - ta is missing.
183. 2015-01-03 14:00:00 (-17.7,125.0) - ta is missing.
185. 2015-01-03 14:00:00 (-37.3,144.0) - ta is missing.
186. 2015-01-03 14:00:00 (-15.8,131.3) - ta is missing.
188. 2015-01-03 16:00:00 (-15.9,131.1) - ta is missing.
189. 2015-01-03 16:00:00 (-16.5,137.4) - ta is missing.
191. 2015-01-03 23:00:00 (-16.7,126.4) - ta is missing.
192. 2015-01-03 23:00:00 (-14.6,135.0) - ta is missing.
193. 2015-01-03 23:00:00 (-14.2,132.2) - ta is missing.
200. 2015-01-04 01:00:00 (-13.3,133.6) - ta is missing.
201. 2015-01-04 01:00:00 (-16.7,133.2) - ta is missing.
202. 2015-01-04 01:00:00 (-12.5,141.9) - ta is missing.
206. 2015-01-04 01:00:00 (-26.9,152.5) - ta is missing.
209. 2015-01-04 01:00:00 (-15.2,131.0) - ta is missing.
210. 2015-01-04 01:00:00 (-13.5,132.7) - ta is missing.
211. 2015-01-04 01:00:00 (-18.8,142.4) - ta is missing.
214. 2015-01-04 04:00:00 (-13.3,134.4) - ta is missing.
215. 2015-01-04 04:00:00 (-17.4,125.0) - ta is missing.
216. 2015-01-04 04:00:00 (-14.8,132.6) - ta is missing.
217. 2015-01-04 04:00:00 (-15.6,124.5) - ta is missing.
218. 2015-01-04 04:00:00 (-16.6,130.9) - ta is missing.
219. 2015-01-04 04:00:00 (-12.5,136.7) - ta is missing.
221. 2015-01-04 04:00:00 (-29.6,118.7) - ta is missing.
227. 2015-01-04 04:00:00 (-29.4,115.7) - ta is missing.
229. 2015-01-04 05:00:00 (-17.1,124.8) - ta is missing.
232. 2015-01-04 05:00:00 (-16.3,127.8) - ta is missing.
233. 2015-01-04 05:00:00 (-33.4,117.2) - ta is missing.
234. 2015-01-04 05:00:00 (-33.9,118.0) - ta is missing.
235. 2015-01-04 05:00:00 (-34.2,118.0) - ta is missing.
236. 2015-01-04 05:00:00 (-16.3,124.6) - ta is missing.
237. 2015-01-04 05:00:00 (-30.2,115.5) - ta is missing.
239. 2015-01-04 05:00:00 (-14.9,130.6) - ta is missing.
240. 2015-01-04 05:00:00 (-14.8,125.4) - ta is missing.
241. 2015-01-04 05:00:00 (-15.4,126.4) - ta is missing.
242. 2015-01-04 05:00:00 (-14.5,130.2) - ta is missing.
244. 2015-01-04 05:00:00 (-18.7,125.1) - ta is missing.
245. 2015-01-04 05:00:00 (-14.6,134.9) - ta is missing.
248. 2015-01-04 05:00:00 (-13.4,133.4) - ta is missing.
249. 2015-01-04 05:00:00 (-15.7,134.5) - ta is missing.
250. 2015-01-04 05:00:00 (-15.9,135.3) - ta is missing.
253. 2015-01-04 06:00:00 (-12.6,133.2) - ta is missing.
255. 2015-01-04 06:00:00 (-16.9,138.8) - ta is missing.
256. 2015-01-04 06:00:00 (-28.9,147.7) - ta is missing.
258. 2015-01-04 06:00:00 (-16.4,128.6) - ta is missing.
262. 2015-01-04 15:00:00 (-14.4,134.0) - ta is missing.
263. 2015-01-04 15:00:00 (-14.5,134.0) - ta is missing.
264. 2015-01-04 16:00:00 (-14.4,134.0) - ta is missing.
266. 2015-01-04 16:00:00 (-15.7,129.7) - ta is missing.
267. 2015-01-04 16:00:00 (-17.5,142.5) - ta is missing.
268. 2015-01-04 16:00:00 (-14.8,130.8) - ta is missing.
269. 2015-01-04 16:00:00 (-25.8,114.7) - ta is missing.
270. 2015-01-04 16:00:00 (-22.7,121.8) - ta is missing.
272. 2015-01-04 16:00:00 (-16.1,142.0) - ta is missing.
277. 2015-01-05 00:00:00 (-19.2,138.1) - ta is missing.
278. 2015-01-05 00:00:00 (-12.8,132.6) - ta is missing.
280. 2015-01-05 00:00:00 (-33.7,149.0) - ta is missing.
281. 2015-01-05 02:00:00 (-15.6,128.6) - ta is missing.
283. 2015-01-05 02:00:00 (-17.3,135.9) - ta is missing.
287. 2015-01-05 02:00:00 (-18.6,130.9) - ta is missing.
288. 2015-01-05 02:00:00 (-17.0,125.0) - ta is missing.
289. 2015-01-05 02:00:00 (-35.7,145.8) - ta is missing.
290. 2015-01-05 02:00:00 (-16.2,127.3) - ta is missing.
292. 2015-01-05 02:00:00 (-29.1,115.3) - ta is missing.
295. 2015-01-05 02:00:00 (-15.9,129.2) - ta is missing.
296. 2015-01-05 02:00:00 (-15.4,128.6) - ta is missing.
297. 2015-01-05 02:00:00 (-28.9,147.6) - ta is missing.
298. 2015-01-05 02:00:00 (-15.1,128.8) - ta is missing.
299. 2015-01-05 02:00:00 (-14.2,130.7) - ta is missing.
300. 2015-01-05 02:00:00 (-13.0,132.4) - ta is missing.
302. 2015-01-05 02:00:00 (-15.0,130.2) - ta is missing.
303. 2015-01-05 02:00:00 (-14.3,134.6) - ta is missing.
304. 2015-01-05 02:00:00 (-19.7,127.9) - ta is missing.
305. 2015-01-05 02:00:00 (-15.0,144.1) - ta is missing.
308. 2015-01-05 02:00:00 (-14.5,126.1) - ta is missing.
309. 2015-01-05 02:00:00 (-16.9,138.9) - ta is missing.
311. 2015-01-05 02:00:00 (-16.4,125.3) - ta is missing.
312. 2015-01-05 02:00:00 (-12.6,133.7) - ta is missing.
315. 2015-01-05 04:00:00 (-13.8,130.1) - ta is missing.
317. 2015-01-05 04:00:00 (-12.4,134.1) - ta is missing.
318. 2015-01-05 04:00:00 (-12.9,141.7) - ta is missing.
320. 2015-01-05 04:00:00 (-14.8,141.9) - ta is missing.
322. 2015-01-05 04:00:00 (-12.3,136.9) - ta is missing.
323. 2015-01-05 04:00:00 (-12.5,136.6) - ta is missing.
324. 2015-01-05 04:00:00 (-12.4,136.4) - ta is missing.
325. 2015-01-05 04:00:00 (-13.8,130.7) - ta is missing.
326. 2015-01-05 04:00:00 (-13.3,132.6) - ta is missing.
327. 2015-01-05 05:00:00 (-30.0,153.1) - ta is missing.
328. 2015-01-05 05:00:00 (-13.4,132.8) - ta is missing.
329. 2015-01-05 05:00:00 (-17.3,125.0) - ta is missing.
330. 2015-01-05 05:00:00 (-17.3,124.6) - ta is missing.
331. 2015-01-05 05:00:00 (-19.8,135.3) - ta is missing.
332. 2015-01-05 05:00:00 (-17.4,131.0) - ta is missing.
334. 2015-01-05 12:00:00 (-16.2,126.2) - ta is missing.
335. 2015-01-05 12:00:00 (-14.7,132.4) - ta is missing.
337. 2015-01-05 12:00:00 (-30.9,151.7) - ta is missing.
338. 2015-01-05 12:00:00 (-16.6,134.6) - ta is missing.
339. 2015-01-05 12:00:00 (-14.8,143.9) - ta is missing.
341. 2015-01-05 12:00:00 (-16.4,142.6) - ta is missing.
342. 2015-01-05 14:00:00 (-27.6,115.5) - ta is missing.
343. 2015-01-05 14:00:00 (-15.5,127.4) - ta is missing.
344. 2015-01-05 14:00:00 (-15.4,134.3) - ta is missing.
345. 2015-01-05 14:00:00 (-16.6,137.8) - ta is missing.
346. 2015-01-05 14:00:00 (-17.1,125.4) - ta is missing.
347. 2015-01-05 14:00:00 (-17.1,128.6) - ta is missing.
349. 2015-01-05 14:00:00 (-16.0,141.6) - ta is missing.
351. 2015-01-05 14:00:00 (-21.3,128.3) - ta is missing.
358. 2015-01-05 14:00:00 (-17.5,126.1) - ta is missing.
359. 2015-01-05 14:00:00 (-21.7,121.9) - ta is missing.
360. 2015-01-05 14:00:00 (-33.9,118.7) - ta is missing.
361. 2015-01-05 14:00:00 (-31.2,116.9) - ta is missing.
362. 2015-01-05 14:00:00 (-17.4,127.9) - ta is missing.
363. 2015-01-05 15:00:00 (-33.4,117.0) - ta is missing.
365. 2015-01-05 17:00:00 (-36.7,144.1) - ta is missing.
366. 2015-01-05 17:00:00 (-19.2,146.1) - ta is missing.
367. 2015-01-05 17:00:00 (-31.1,116.8) - ta is missing.
368. 2015-01-05 17:00:00 (-15.7,128.0) - ta is missing.
369. 2015-01-05 17:00:00 (-15.8,131.3) - ta is missing.
370. 2015-01-05 17:00:00 (-16.1,134.7) - ta is missing.
371. 2015-01-05 17:00:00 (-33.5,118.1) - ta is missing.
372. 2015-01-05 17:00:00 (-16.9,126.2) - ta is missing.
373. 2015-01-05 23:00:00 (-33.8,119.1) - ta is missing.
374. 2015-01-05 23:00:00 (-15.5,131.3) - ta is missing.
375. 2015-01-05 23:00:00 (-15.5,134.1) - ta is missing.
376. 2015-01-06 01:00:00 (-16.5,126.4) - ta is missing.
377. 2015-01-06 01:00:00 (-16.4,123.0) - ta is missing.
378. 2015-01-06 01:00:00 (-14.1,132.8) - ta is missing.
379. 2015-01-06 01:00:00 (-16.9,127.9) - ta is missing.
380. 2015-01-06 01:00:00 (-16.4,126.2) - ta is missing.
382. 2015-01-06 01:00:00 (-15.1,128.3) - ta is missing.
383. 2015-01-06 01:00:00 (-16.5,127.1) - ta is missing.
384. 2015-01-06 03:00:00 (-15.4,144.5) - ta is missing.
385. 2015-01-06 03:00:00 (-14.9,130.5) - ta is missing.
386. 2015-01-06 03:00:00 (-15.6,135.1) - ta is missing.
389. 2015-01-06 03:00:00 (-13.3,133.2) - ta is missing.
390. 2015-01-06 03:00:00 (-13.6,132.1) - ta is missing.
391. 2015-01-06 03:00:00 (-17.0,124.8) - ta is missing.
393. 2015-01-06 03:00:00 (-14.4,135.5) - ta is missing.
394. 2015-01-06 03:00:00 (-15.0,141.9) - ta is missing.
395. 2015-01-06 03:00:00 (-12.0,132.7) - ta is missing.
396. 2015-01-06 03:00:00 (-16.0,128.4) - ta is missing.
397. 2015-01-06 03:00:00 (-13.7,133.6) - ta is missing.
398. 2015-01-06 03:00:00 (-14.5,127.0) - ta is missing.
399. 2015-01-06 03:00:00 (-18.3,131.4) - ta is missing.
400. 2015-01-06 04:00:00 (-13.7,133.2) - ta is missing.
402. 2015-01-06 04:00:00 (-14.5,135.1) - ta is missing.
403. 2015-01-06 04:00:00 (-13.4,131.1) - ta is missing.
404. 2015-01-06 04:00:00 (-14.5,134.9) - ta is missing.
405. 2015-01-06 04:00:00 (-15.5,128.8) - ta is missing.
408. 2015-01-06 04:00:00 (-14.8,126.4) - ta is missing.
409. 2015-01-06 04:00:00 (-13.9,133.4) - ta is missing.
410. 2015-01-06 04:00:00 (-14.5,132.7) - ta is missing.
411. 2015-01-06 05:00:00 (-14.3,131.4) - ta is missing.
412. 2015-01-06 05:00:00 (-13.6,132.0) - ta is missing.
413. 2015-01-06 05:00:00 (-12.6,136.2) - ta is missing.
414. 2015-01-06 05:00:00 (-19.9,130.6) - ta is missing.
415. 2015-01-06 05:00:00 (-19.3,130.4) - ta is missing.
416. 2015-01-06 05:00:00 (-16.1,128.6) - ta is missing.
417. 2015-01-06 05:00:00 (-13.8,130.1) - ta is missing.
419. 2015-01-06 05:00:00 (-13.8,132.3) - ta is missing.
420. 2015-01-06 05:00:00 (-18.6,142.8) - ta is missing.
422. 2015-01-06 05:00:00 (-16.5,124.2) - ta is missing.
424. 2015-01-06 05:00:00 (-17.0,133.5) - ta is missing.
425. 2015-01-06 05:00:00 (-15.9,133.1) - ta is missing.
427. 2015-01-06 05:00:00 (-14.9,132.7) - ta is missing.
428. 2015-01-06 05:00:00 (-15.6,124.6) - ta is missing.
429. 2015-01-06 05:00:00 (-14.8,132.8) - ta is missing.
432. 2015-01-06 05:00:00 (-18.4,142.7) - ta is missing.
433. 2015-01-06 05:00:00 (-16.9,132.6) - ta is missing.
434. 2015-01-06 05:00:00 (-16.7,137.8) - ta is missing.
435. 2015-01-06 05:00:00 (-18.9,142.5) - ta is missing.
436. 2015-01-06 05:00:00 (-16.7,132.7) - ta is missing.
438. 2015-01-06 05:00:00 (-14.8,125.9) - ta is missing.
439. 2015-01-06 05:00:00 (-15.2,144.2) - ta is missing.
440. 2015-01-06 05:00:00 (-33.3,149.1) - ta is missing.
441. 2015-01-06 05:00:00 (-23.4,116.8) - ta is missing.
442. 2015-01-06 05:00:00 (-19.0,146.1) - ta is missing.
444. 2015-01-06 05:00:00 (-11.9,132.7) - ta is missing.
445. 2015-01-06 05:00:00 (-12.7,142.0) - ta is missing.
446. 2015-01-06 05:00:00 (-32.5,119.4) - ta is missing.
447. 2015-01-06 05:00:00 (-17.3,135.9) - ta is missing.
450. 2015-01-06 05:00:00 (-33.2,117.7) - ta is missing.
451. 2015-01-06 05:00:00 (-15.4,124.8) - ta is missing.
454. 2015-01-06 05:00:00 (-16.5,127.7) - ta is missing.
455. 2015-01-06 05:00:00 (-31.6,117.2) - ta is missing.
456. 2015-01-06 05:00:00 (-15.7,125.9) - ta is missing.
457. 2015-01-06 05:00:00 (-15.1,131.3) - ta is missing.
458. 2015-01-06 05:00:00 (-32.9,117.1) - ta is missing.
459. 2015-01-06 05:00:00 (-31.7,117.2) - ta is missing.
460. 2015-01-06 05:00:00 (-13.6,131.7) - ta is missing.
461. 2015-01-06 13:00:00 (-15.0,128.6) - ta is missing.
462. 2015-01-06 15:00:00 (-15.1,127.4) - ta is missing.
463. 2015-01-06 15:00:00 (-15.6,125.8) - ta is missing.
464. 2015-01-06 16:00:00 (-14.7,131.0) - ta is missing.
466. 2015-01-06 16:00:00 (-17.3,125.5) - ta is missing.
467. 2015-01-06 16:00:00 (-31.7,117.1) - ta is missing.
468. 2015-01-07 00:00:00 (-14.5,132.2) - ta is missing.
469. 2015-01-07 00:00:00 (-14.3,130.6) - ta is missing.
470. 2015-01-07 00:00:00 (-18.4,145.3) - ta is missing.
471. 2015-01-07 00:00:00 (-15.4,126.0) - ta is missing.
472. 2015-01-07 00:00:00 (-16.1,125.6) - ta is missing.
473. 2015-01-07 00:00:00 (-16.4,125.7) - ta is missing.
474. 2015-01-07 00:00:00 (-14.8,135.2) - ta is missing.
475. 2015-01-07 00:00:00 (-16.9,126.0) - ta is missing.
477. 2015-01-07 00:00:00 (-16.9,126.0) - ta is missing.
478. 2015-01-07 02:00:00 (-16.3,125.9) - ta is missing.
479. 2015-01-07 02:00:00 (-16.7,126.7) - ta is missing.
480. 2015-01-07 02:00:00 (-13.4,133.1) - ta is missing.
481. 2015-01-07 02:00:00 (-12.9,133.6) - ta is missing.
482. 2015-01-07 02:00:00 (-14.5,130.4) - ta is missing.
484. 2015-01-07 02:00:00 (-14.9,126.7) - ta is missing.
485. 2015-01-07 02:00:00 (-14.4,129.4) - ta is missing.
486. 2015-01-07 02:00:00 (-14.7,126.2) - ta is missing.
487. 2015-01-07 02:00:00 (-14.5,135.6) - ta is missing.
488. 2015-01-07 02:00:00 (-15.3,125.7) - ta is missing.
490. 2015-01-07 02:00:00 (-14.9,141.7) - ta is missing.
491. 2015-01-07 02:00:00 (-16.5,124.8) - ta is missing.
492. 2015-01-07 02:00:00 (-12.4,132.1) - ta is missing.
496. 2015-01-07 02:00:00 (-13.0,134.0) - ta is missing.
497. 2015-01-07 02:00:00 (-13.7,134.1) - ta is missing.
498. 2015-01-07 02:00:00 (-14.1,126.8) - ta is missing.
503. 2015-01-07 02:00:00 (-12.8,136.4) - ta is missing.
509. 2015-01-07 02:00:00 (-16.7,143.3) - ta is missing.
510. 2015-01-07 03:00:00 (-18.6,142.8) - ta is missing.
511. 2015-01-07 03:00:00 (-16.8,124.7) - ta is missing.
513. 2015-01-07 04:00:00 (-15.8,124.4) - ta is missing.
514. 2015-01-07 04:00:00 (-15.6,124.6) - ta is missing.
515. 2015-01-07 04:00:00 (-16.2,135.1) - ta is missing.
516. 2015-01-07 04:00:00 (-14.2,126.4) - ta is missing.
518. 2015-01-07 04:00:00 (-16.5,142.7) - ta is missing.
519. 2015-01-07 04:00:00 (-15.9,132.8) - ta is missing.
520. 2015-01-07 04:00:00 (-17.7,142.9) - ta is missing.
521. 2015-01-07 04:00:00 (-14.1,133.6) - ta is missing.
523. 2015-01-07 04:00:00 (-16.7,124.9) - ta is missing.
524. 2015-01-07 06:00:00 (-15.9,125.7) - ta is missing.
525. 2015-01-07 06:00:00 (-17.4,131.1) - ta is missing.
526. 2015-01-07 06:00:00 (-24.1,151.4) - ta is missing.
527. 2015-01-07 06:00:00 (-16.6,142.5) - ta is missing.
528. 2015-01-07 06:00:00 (-17.5,130.8) - ta is missing.
529. 2015-01-07 06:00:00 (-19.8,142.6) - ta is missing.
530. 2015-01-07 06:00:00 (-16.1,142.3) - ta is missing.
533. 2015-01-07 12:00:00 (-17.8,125.4) - ta is missing.
535. 2015-01-07 12:00:00 (-33.4,115.7) - ta is missing.
536. 2015-01-07 12:00:00 (-15.4,128.0) - ta is missing.
537. 2015-01-07 12:00:00 (-25.2,148.3) - ta is missing.
541. 2015-01-07 12:00:00 (-12.6,142.0) - ta is missing.
543. 2015-01-07 12:00:00 (-38.0,143.9) - ta is missing.
544. 2015-01-07 12:00:00 (-36.7,144.7) - ta is missing.
547. 2015-01-07 12:00:00 (-32.6,146.7) - ta is missing.
548. 2015-01-07 14:00:00 (-35.8,146.1) - ta is missing.
549. 2015-01-07 14:00:00 (-15.2,125.5) - ta is missing.
550. 2015-01-07 14:00:00 (-26.4,149.4) - ta is missing.
551. 2015-01-07 14:00:00 (-16.1,125.2) - ta is missing.
552. 2015-01-07 14:00:00 (-16.3,125.7) - ta is missing.
553. 2015-01-07 14:00:00 (-16.3,124.7) - ta is missing.
554. 2015-01-07 14:00:00 (-30.8,116.8) - ta is missing.
555. 2015-01-07 14:00:00 (-15.8,127.9) - ta is missing.
557. 2015-01-07 14:00:00 (-32.9,116.7) - ta is missing.
558. 2015-01-07 14:00:00 (-30.9,116.3) - ta is missing.
560. 2015-01-07 15:00:00 (-14.6,127.1) - ta is missing.
562. 2015-01-07 15:00:00 (-15.6,126.4) - ta is missing.
563. 2015-01-07 15:00:00 (-16.5,130.6) - ta is missing.
564. 2015-01-07 15:00:00 (-17.0,136.8) - ta is missing.
565. 2015-01-07 15:00:00 (-15.8,126.9) - ta is missing.
566. 2015-01-07 17:00:00 (-32.4,117.3) - ta is missing.
567. 2015-01-07 17:00:00 (-14.7,133.1) - ta is missing.
568. 2015-01-07 17:00:00 (-16.7,126.0) - ta is missing.
569. 2015-01-07 17:00:00 (-21.3,132.7) - ta is missing.
570. 2015-01-07 17:00:00 (-16.6,125.3) - ta is missing.
571. 2015-01-07 23:00:00 (-16.2,124.9) - ta is missing.
572. 2015-01-07 23:00:00 (-14.8,144.0) - ta is missing.
574. 2015-01-08 01:00:00 (-13.5,133.2) - ta is missing.
576. 2015-01-08 01:00:00 (-14.4,126.2) - ta is missing.
577. 2015-01-08 01:00:00 (-13.1,133.5) - ta is missing.
578. 2015-01-08 02:00:00 (-14.6,134.8) - ta is missing.
579. 2015-01-08 02:00:00 (-13.7,132.3) - ta is missing.
580. 2015-01-08 02:00:00 (-19.3,146.2) - ta is missing.
581. 2015-01-08 02:00:00 (-12.7,132.4) - ta is missing.
582. 2015-01-08 02:00:00 (-17.3,136.8) - ta is missing.
584. 2015-01-08 02:00:00 (-15.5,141.7) - ta is missing.
585. 2015-01-08 02:00:00 (-13.3,132.0) - ta is missing.
586. 2015-01-08 02:00:00 (-12.8,134.1) - ta is missing.
587. 2015-01-08 03:00:00 (-13.5,133.0) - ta is missing.
588. 2015-01-08 03:00:00 (-12.4,134.7) - ta is missing.
589. 2015-01-08 03:00:00 (-14.4,142.4) - ta is missing.
591. 2015-01-08 03:00:00 (-11.9,133.6) - ta is missing.
593. 2015-01-08 03:00:00 (-23.4,145.4) - ta is missing.
594. 2015-01-08 03:00:00 (-13.6,131.9) - ta is missing.
595. 2015-01-08 03:00:00 (-14.0,131.8) - ta is missing.
596. 2015-01-08 03:00:00 (-13.2,141.9) - ta is missing.
597. 2015-01-08 03:00:00 (-13.1,133.5) - ta is missing.
598. 2015-01-08 03:00:00 (-11.6,132.9) - ta is missing.
600. 2015-01-08 03:00:00 (-14.2,135.7) - ta is missing.
602. 2015-01-08 05:00:00 (-12.5,141.8) - ta is missing.
603. 2015-01-08 05:00:00 (-23.7,150.1) - ta is missing.
605. 2015-01-08 05:00:00 (-14.0,129.8) - ta is missing.
606. 2015-01-08 05:00:00 (-17.3,137.2) - ta is missing.
607. 2015-01-08 05:00:00 (-23.9,145.2) - ta is missing.
608. 2015-01-08 05:00:00 (-13.6,132.4) - ta is missing.
609. 2015-01-08 05:00:00 (-13.3,132.5) - ta is missing.
610. 2015-01-08 05:00:00 (-13.3,132.5) - ta is missing.
611. 2015-01-08 05:00:00 (-12.2,134.7) - ta is missing.
613. 2015-01-08 13:00:00 (-19.6,129.1) - ta is missing.
614. 2015-01-08 13:00:00 (-15.0,130.8) - ta is missing.
616. 2015-01-08 13:00:00 (-13.7,132.9) - ta is missing.
618. 2015-01-08 13:00:00 (-15.9,133.0) - ta is missing.
621. 2015-01-08 13:00:00 (-15.3,125.5) - ta is missing.
622. 2015-01-08 14:00:00 (-16.8,129.8) - ta is missing.
623. 2015-01-08 14:00:00 (-16.3,124.5) - ta is missing.
624. 2015-01-08 14:00:00 (-23.5,118.5) - ta is missing.
625. 2015-01-08 14:00:00 (-15.4,125.1) - ta is missing.
627. 2015-01-08 14:00:00 (-17.2,135.2) - ta is missing.
629. 2015-01-08 14:00:00 (-16.2,124.5) - ta is missing.
633. 2015-01-08 14:00:00 (-12.3,136.9) - ta is missing.
634. 2015-01-08 14:00:00 (-16.4,136.9) - ta is missing.
637. 2015-01-09 00:00:00 (-16.7,124.6) - ta is missing.
638. 2015-01-09 00:00:00 (-17.5,124.3) - ta is missing.
640. 2015-01-09 00:00:00 (-29.0,147.5) - ta is missing.
645. 2015-01-09 00:00:00 (-25.2,148.2) - ta is missing.
647. 2015-01-09 00:00:00 (-22.3,118.3) - ta is missing.
650. 2015-01-09 00:00:00 (-23.9,120.4) - ta is missing.
651. 2015-01-09 00:00:00 (-19.6,139.9) - ta is missing.
652. 2015-01-09 00:00:00 (-27.7,124.2) - ta is missing.
659. 2015-01-09 01:00:00 (-37.9,143.8) - ta is missing.
660. 2015-01-09 01:00:00 (-37.7,143.4) - ta is missing.
662. 2015-01-09 01:00:00 (-32.7,134.3) - ta is missing.