P-Days Maps have ended for the season and will begin again on June 1st.
query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
9.3388 |
2017-05-15 00:00:00.0 |
9.3388 |
244 |
2 |
16.5449 |
2017-05-16 00:00:00.0 |
7.2061 |
244 |
3 |
18.5730 |
2017-05-17 00:00:00.0 |
2.0281 |
244 |
4 |
19.9506 |
2017-05-18 00:00:00.0 |
1.3776 |
244 |
5 |
24.3256 |
2017-05-19 00:00:00.0 |
4.3750 |
244 |
6 |
28.5929 |
2017-05-20 00:00:00.0 |
4.2673 |
244 |
7 |
29.7031 |
2017-05-21 00:00:00.0 |
1.1102 |
244 |
8 |
33.0725 |
2017-05-22 00:00:00.0 |
3.3694 |
244 |
9 |
40.1256 |
2017-05-23 00:00:00.0 |
7.0531 |
244 |
10 |
48.1006 |
2017-05-24 00:00:00.0 |
7.9750 |
244 |
11 |
56.1394 |
2017-05-25 00:00:00.0 |
8.0388 |
244 |
12 |
64.1144 |
2017-05-26 00:00:00.0 |
7.9750 |
244 |
13 |
72.3981 |
2017-05-27 00:00:00.0 |
8.2837 |
244 |
14 |
78.3568 |
2017-05-28 00:00:00.0 |
5.9587 |
244 |
15 |
81.3726 |
2017-05-29 00:00:00.0 |
3.0158 |
244 |
16 |
87.5109 |
2017-05-30 00:00:00.0 |
6.1383 |
244 |
17 |
96.7742 |
2017-05-31 00:00:00.0 |
9.2633 |
244 |
18 |
103.9298 |
2017-06-01 00:00:00.0 |
7.1556 |
244 |
19 |
112.5026 |
2017-06-02 00:00:00.0 |
8.5728 |
244 |
20 |
122.0088 |
2017-06-03 00:00:00.0 |
9.5062 |
244 |
21 |
131.9675 |
2017-06-04 00:00:00.0 |
9.9587 |
244 |
22 |
141.9070 |
2017-06-05 00:00:00.0 |
9.9395 |
244 |
23 |
151.6984 |
2017-06-06 00:00:00.0 |
9.7914 |
244 |
24 |
161.6249 |
2017-06-07 00:00:00.0 |
9.9265 |
244 |
25 |
171.6244 |
2017-06-08 00:00:00.0 |
9.9995 |
244 |
26 |
181.5509 |
2017-06-09 00:00:00.0 |
9.9265 |
244 |
27 |
191.5096 |
2017-06-10 00:00:00.0 |
9.9587 |
244 |
28 |
201.5076 |
2017-06-11 00:00:00.0 |
9.9980 |
244 |
29 |
210.9520 |
2017-06-12 00:00:00.0 |
9.4444 |
244 |
30 |
220.1760 |
2017-06-13 00:00:00.0 |
9.2240 |
244 |
31 |
229.8311 |
2017-06-14 00:00:00.0 |
9.6551 |
244 |
32 |
239.0148 |
2017-06-15 00:00:00.0 |
9.1837 |
244 |
33 |
248.4250 |
2017-06-16 00:00:00.0 |
9.4102 |
244 |
34 |
256.7673 |
2017-06-17 00:00:00.0 |
8.3423 |
244 |
35 |
264.3382 |
2017-06-18 00:00:00.0 |
7.5709 |
244 |
36 |
272.8504 |
2017-06-19 00:00:00.0 |
8.5122 |
244 |
37 |
281.7234 |
2017-06-20 00:00:00.0 |
8.8730 |
244 |
38 |
291.0984 |
2017-06-21 00:00:00.0 |
9.3750 |
244 |
39 |
300.1106 |
2017-06-22 00:00:00.0 |
9.0122 |
244 |
40 |
307.8882 |
2017-06-23 00:00:00.0 |
7.7776 |
244 |
41 |
312.3698 |
2017-06-24 00:00:00.0 |
4.4816 |
244 |
42 |
318.3285 |
2017-06-25 00:00:00.0 |
5.9587 |
244 |
43 |
326.8953 |
2017-06-26 00:00:00.0 |
8.5668 |
244 |
44 |
336.7111 |
2017-06-27 00:00:00.0 |
9.8158 |
244 |
45 |
346.2208 |
2017-06-28 00:00:00.0 |
9.5097 |
244 |
46 |
355.6652 |
2017-06-29 00:00:00.0 |
9.4444 |
244 |
47 |
364.6320 |
2017-06-30 00:00:00.0 |
8.9668 |
244 |
48 |
373.4070 |
2017-07-01 00:00:00.0 |
8.7750 |
244 |
49 |
382.3274 |
2017-07-02 00:00:00.0 |
8.9204 |
244 |
50 |
392.3146 |
2017-07-03 00:00:00.0 |
9.9872 |
244 |
51 |
401.2763 |
2017-07-04 00:00:00.0 |
8.9617 |
244 |
52 |
410.7319 |
2017-07-05 00:00:00.0 |
9.4556 |
244 |
53 |
420.4159 |
2017-07-06 00:00:00.0 |
9.6840 |
244 |
54 |
430.2118 |
2017-07-07 00:00:00.0 |
9.7959 |
244 |
55 |
440.1920 |
2017-07-08 00:00:00.0 |
9.9802 |
244 |
56 |
450.0685 |
2017-07-09 00:00:00.0 |
9.8765 |
244 |
57 |
460.0376 |
2017-07-10 00:00:00.0 |
9.9691 |
244 |
58 |
470.0364 |
2017-07-11 00:00:00.0 |
9.9988 |
244 |
59 |
478.9094 |
2017-07-12 00:00:00.0 |
8.8730 |
244 |
60 |
488.0931 |
2017-07-13 00:00:00.0 |
9.1837 |
244 |
61 |
498.0196 |
2017-07-14 00:00:00.0 |
9.9265 |
244 |
62 |
508.0191 |
2017-07-15 00:00:00.0 |
9.9995 |
244 |
63 |
517.9574 |
2017-07-16 00:00:00.0 |
9.9383 |
244 |
64 |
527.7796 |
2017-07-17 00:00:00.0 |
9.8222 |
244 |
65 |
537.5755 |
2017-07-18 00:00:00.0 |
9.7959 |
244 |
66 |
546.7592 |
2017-07-19 00:00:00.0 |
9.1837 |
244 |
67 |
556.6730 |
2017-07-20 00:00:00.0 |
9.9138 |
244 |
68 |
566.6619 |
2017-07-21 00:00:00.0 |
9.9889 |
244 |
69 |
576.4369 |
2017-07-22 00:00:00.0 |
9.7750 |
244 |
70 |
586.3956 |
2017-07-23 00:00:00.0 |
9.9587 |
244 |
71 |
596.3166 |
2017-07-24 00:00:00.0 |
9.9210 |
244 |
72 |
606.2968 |
2017-07-25 00:00:00.0 |
9.9802 |
244 |
73 |
616.2963 |
2017-07-26 00:00:00.0 |
9.9995 |
244 |
74 |
626.2654 |
2017-07-27 00:00:00.0 |
9.9691 |
244 |
75 |
635.8197 |
2017-07-28 00:00:00.0 |
9.5543 |
244 |
76 |
645.3259 |
2017-07-29 00:00:00.0 |
9.5062 |
244 |
77 |
653.8136 |
2017-07-30 00:00:00.0 |
8.4877 |
244 |
78 |
662.0309 |
2017-07-31 00:00:00.0 |
8.2173 |
244 |
79 |
672.0181 |
2017-08-01 00:00:00.0 |
9.9872 |
244 |
80 |
680.3604 |
2017-08-02 00:00:00.0 |
8.3423 |
244 |
81 |
689.5844 |
2017-08-03 00:00:00.0 |
9.2240 |
244 |
82 |
698.9946 |
2017-08-04 00:00:00.0 |
9.4102 |
244 |
83 |
708.3334 |
2017-08-05 00:00:00.0 |
9.3388 |
244 |
84 |
717.6722 |
2017-08-06 00:00:00.0 |
9.3388 |
244 |
85 |
727.4472 |
2017-08-07 00:00:00.0 |
9.7750 |
244 |
86 |
737.2819 |
2017-08-08 00:00:00.0 |
9.8347 |
244 |
87 |
746.5452 |
2017-08-09 00:00:00.0 |
9.2633 |
244 |
88 |
756.2753 |
2017-08-10 00:00:00.0 |
9.7301 |
244 |
89 |
765.7850 |
2017-08-11 00:00:00.0 |
9.5097 |
244 |
90 |
775.5600 |
2017-08-12 00:00:00.0 |
9.7750 |
244 |
91 |
785.4126 |
2017-08-13 00:00:00.0 |
9.8526 |
244 |
92 |
795.2652 |
2017-08-14 00:00:00.0 |
9.8526 |
244 |
93 |
805.0402 |
2017-08-15 00:00:00.0 |
9.7750 |
244 |
94 |
814.7933 |
2017-08-16 00:00:00.0 |
9.7531 |
244 |
95 |
824.4484 |
2017-08-17 00:00:00.0 |
9.6551 |
244 |
96 |
834.3749 |
2017-08-18 00:00:00.0 |
9.9265 |
244 |
97 |
844.3305 |
2017-08-19 00:00:00.0 |
9.9556 |
244 |
98 |
854.2157 |
2017-08-20 00:00:00.0 |
9.8852 |
244 |
99 |
862.4397 |
2017-08-21 00:00:00.0 |
8.2240 |
244 |
100 |
871.2642 |
2017-08-22 00:00:00.0 |
8.8245 |
244 |
101 |
877.4025 |
2017-08-23 00:00:00.0 |
6.1383 |
244 |
102 |
884.9734 |
2017-08-24 00:00:00.0 |
7.5709 |
244 |
103 |
894.4510 |
2017-08-25 00:00:00.0 |
9.4776 |
244 |
104 |
903.7898 |
2017-08-26 00:00:00.0 |
9.3388 |
244 |
105 |
913.5857 |
2017-08-27 00:00:00.0 |
9.7959 |
244 |
106 |
923.5808 |
2017-08-28 00:00:00.0 |
9.9951 |
244 |
107 |
933.2648 |
2017-08-29 00:00:00.0 |
9.6840 |
244 |
108 |
942.4071 |
2017-08-30 00:00:00.0 |
9.1423 |
244 |
109 |
951.9479 |
2017-08-31 00:00:00.0 |
9.5408 |
244 |
110 |
961.5188 |
2017-09-01 00:00:00.0 |
9.5709 |
244 |
111 |
971.1999 |
2017-09-02 00:00:00.0 |
9.6811 |
244 |
112 |
980.8810 |
2017-09-03 00:00:00.0 |
9.6811 |
244 |
113 |
989.6055 |
2017-09-04 00:00:00.0 |
8.7245 |
244 |
114 |
997.0336 |
2017-09-05 00:00:00.0 |
7.4281 |
244 |
115 |
1003.0826 |
2017-09-06 00:00:00.0 |
6.0490 |
244 |
116 |
1012.3459 |
2017-09-07 00:00:00.0 |
9.2633 |
244 |
117 |
1019.8459 |
2017-09-08 00:00:00.0 |
7.5000 |
244 |
118 |
1029.2209 |
2017-09-09 00:00:00.0 |
9.3750 |
244 |
119 |
1039.0715 |
2017-09-10 00:00:00.0 |
9.8506 |
244 |
120 |
1048.9715 |
2017-09-11 00:00:00.0 |
9.9000 |
244 |
121 |
1058.6937 |
2017-09-12 00:00:00.0 |
9.7222 |
244 |
122 |
1068.3218 |
2017-09-13 00:00:00.0 |
9.6281 |
244 |
123 |
1076.2320 |
2017-09-14 00:00:00.0 |
7.9102 |
244 |
124 |
1080.4993 |
2017-09-15 00:00:00.0 |
4.2673 |
244 |
125 |
1082.5274 |
2017-09-16 00:00:00.0 |
2.0281 |
244 |
126 |
1086.1274 |
2017-09-17 00:00:00.0 |
3.6000 |
244 |
127 |
1092.0861 |
2017-09-18 00:00:00.0 |
5.9587 |
244 |
128 |
1101.0529 |
2017-09-19 00:00:00.0 |
8.9668 |
244 |
129 |
1109.8279 |
2017-09-20 00:00:00.0 |
8.7750 |
244 |
130 |
1118.8845 |
2017-09-21 00:00:00.0 |
9.0566 |
244 |
131 |
1125.8595 |
2017-09-22 00:00:00.0 |
6.9750 |
244 |
132 |
1131.4467 |
2017-09-23 00:00:00.0 |
5.5872 |
244 |
133 |
1135.2732 |
2017-09-24 00:00:00.0 |
3.8265 |
244 |
134 |
1138.8732 |
2017-09-25 00:00:00.0 |
3.6000 |
244 |
135 |
1141.1543 |
2017-09-26 00:00:00.0 |
2.2811 |
244 |
136 |
1146.3538 |
2017-09-27 00:00:00.0 |
5.1995 |
244 |
137 |
1152.0354 |
2017-09-28 00:00:00.0 |
5.6816 |
244 |
138 |
1154.1905 |
2017-09-29 00:00:00.0 |
2.1551 |
244 |
139 |
1161.2436 |
2017-09-30 00:00:00.0 |
7.0531 |
244 |
140 |
1169.1538 |
2017-10-01 00:00:00.0 |
7.9102 |
244 |
141 |
1175.9696 |
2017-10-02 00:00:00.0 |
6.8158 |
244 |
142 |
1178.2507 |
2017-10-03 00:00:00.0 |
2.2811 |
244 |
143 |
1180.5318 |
2017-10-04 00:00:00.0 |
2.2811 |
244 |
144 |
1180.5318 |
2017-10-05 00:00:00.0 |
0.0000 |
244 |
145 |
1184.3583 |
2017-10-06 00:00:00.0 |
3.8265 |
244 |
146 |
1190.7583 |
2017-10-07 00:00:00.0 |
6.4000 |
244 |
147 |
1194.3583 |
2017-10-08 00:00:00.0 |
3.6000 |
244 |
148 |
1194.3583 |
2017-10-09 00:00:00.0 |
0.0000 |
244 |
149 |
1195.0598 |
2017-10-10 00:00:00.0 |
0.7015 |
244 |
150 |
1197.0879 |
2017-10-11 00:00:00.0 |
2.0281 |
244 |
151 |
1200.9144 |
2017-10-12 00:00:00.0 |
3.8265 |
244 |
152 |
1200.9144 |
2017-10-13 00:00:00.0 |
0.0000 |
244 |
153 |
1200.9144 |
2017-10-14 00:00:00.0 |
0.0000 |
244 |
154 |
1200.9144 |
2017-10-15 00:00:00.0 |
0.0000 |
244 |
155 |
1202.5552 |
2017-10-16 00:00:00.0 |
1.6408 |
244 |
156 |
1208.5139 |
2017-10-17 00:00:00.0 |
5.9587 |
244 |
157 |
1215.1665 |
2017-10-18 00:00:00.0 |
6.6526 |
244 |
158 |
1218.1823 |
2017-10-19 00:00:00.0 |
3.0158 |
244 |
159 |
1226.3456 |
2017-10-20 00:00:00.0 |
8.1633 |
244 |
160 |
1234.6879 |
2017-10-21 00:00:00.0 |
8.3423 |
244 |
161 |
1239.2751 |
2017-10-22 00:00:00.0 |
4.5872 |
244 |
162 |
1239.2751 |
2017-10-23 00:00:00.0 |
0.0000 |
244 |
163 |
1239.2751 |
2017-10-24 00:00:00.0 |
0.0000 |
244 |
164 |
1240.6527 |
2017-10-25 00:00:00.0 |
1.3776 |
244 |
165 |
1240.6527 |
2017-10-26 00:00:00.0 |
0.0000 |
244 |
166 |
1240.6527 |
2017-10-27 00:00:00.0 |
0.0000 |
244 |
167 |
1240.6527 |
2017-10-28 00:00:00.0 |
0.0000 |
244 |
168 |
1240.6527 |
2017-10-29 00:00:00.0 |
0.0000 |
244 |
169 |
1240.6527 |
2017-10-30 00:00:00.0 |
0.0000 |
244 |
170 |
1240.6527 |
2017-10-31 00:00:00.0 |
0.0000 |
244 |
171 |
1240.6527 |
2017-11-01 00:00:00.0 |
0.0000 |
244 |
172 |
1240.6527 |
2017-11-02 00:00:00.0 |
0.0000 |
244 |
173 |
1240.6527 |
2017-11-03 00:00:00.0 |
0.0000 |
244 |
174 |
1240.6527 |
2017-11-04 00:00:00.0 |
0.0000 |
244 |
175 |
1240.6527 |
2017-11-05 00:00:00.0 |
0.0000 |
244 |
176 |
1240.6527 |
2017-11-06 00:00:00.0 |
0.0000 |
244 |
177 |
1240.6527 |
2017-11-07 00:00:00.0 |
0.0000 |
244 |
178 |
1240.6527 |
2017-11-08 00:00:00.0 |
0.0000 |
244 |
179 |
1240.6527 |
2017-11-09 00:00:00.0 |
0.0000 |
244 |
180 |
1240.6527 |
2017-11-10 00:00:00.0 |
0.0000 |
244 |
181 |
1240.6527 |
2017-11-11 00:00:00.0 |
0.0000 |
244 |
182 |
1240.6527 |
2017-11-12 00:00:00.0 |
0.0000 |
244 |
183 |
1240.6527 |
2017-11-13 00:00:00.0 |
0.0000 |
244 |
184 |
1240.6527 |
2017-11-14 00:00:00.0 |
0.0000 |
244 |
185 |
1240.6527 |
2017-11-15 00:00:00.0 |
0.0000 |
244 |
186 |
1240.6527 |
2017-11-16 00:00:00.0 |
0.0000 |
244 |
187 |
1240.6527 |
2017-11-17 00:00:00.0 |
0.0000 |
244 |
188 |
1240.6527 |
2017-11-18 00:00:00.0 |
0.0000 |
244 |
189 |
1240.6527 |
2017-11-19 00:00:00.0 |
0.0000 |
244 |
190 |
1240.6527 |
2017-11-20 00:00:00.0 |
0.0000 |
244 |
191 |
1240.6527 |
2017-11-21 00:00:00.0 |
0.0000 |
244 |
192 |
1240.6527 |
2017-11-22 00:00:00.0 |
0.0000 |
244 |
193 |
1240.6527 |
2017-11-23 00:00:00.0 |
0.0000 |
244 |
194 |
1240.6527 |
2017-11-24 00:00:00.0 |
0.0000 |
244 |
195 |
1240.6527 |
2017-11-25 00:00:00.0 |
0.0000 |
244 |
196 |
1240.6527 |
2017-11-26 00:00:00.0 |
0.0000 |
244 |
197 |
1240.6527 |
2017-11-27 00:00:00.0 |
0.0000 |
244 |
198 |
1240.6527 |
2017-11-28 00:00:00.0 |
0.0000 |
244 |
199 |
1240.6527 |
2017-11-29 00:00:00.0 |
0.0000 |
244 |
200 |
1240.6527 |
2017-11-30 00:00:00.0 |
0.0000 |
244 |
201 |
1240.6527 |
2017-12-01 00:00:00.0 |
0.0000 |
244 |
202 |
1240.6527 |
2017-12-02 00:00:00.0 |
0.0000 |
244 |
203 |
1240.6527 |
2017-12-03 00:00:00.0 |
0.0000 |
244 |
204 |
1240.6527 |
2017-12-04 00:00:00.0 |
0.0000 |
244 |
205 |
1240.6527 |
2017-12-05 00:00:00.0 |
0.0000 |
244 |
206 |
1240.6527 |
2017-12-06 00:00:00.0 |
0.0000 |
244 |
207 |
1240.6527 |
2017-12-07 00:00:00.0 |
0.0000 |
244 |
208 |
1240.6527 |
2017-12-08 00:00:00.0 |
0.0000 |
244 |
209 |
1240.6527 |
2017-12-09 00:00:00.0 |
0.0000 |
244 |
210 |
1240.6527 |
2017-12-10 00:00:00.0 |
0.0000 |
244 |
211 |
1240.6527 |
2017-12-11 00:00:00.0 |
0.0000 |
244 |
212 |
1240.6527 |
2017-12-12 00:00:00.0 |
0.0000 |
244 |
213 |
1240.6527 |
2017-12-13 00:00:00.0 |
0.0000 |
244 |
214 |
1240.6527 |
2017-12-14 00:00:00.0 |
0.0000 |
244 |
215 |
1240.6527 |
2017-12-15 00:00:00.0 |
0.0000 |
244 |
216 |
1240.6527 |
2017-12-16 00:00:00.0 |
0.0000 |
244 |
217 |
1240.6527 |
2017-12-17 00:00:00.0 |
0.0000 |
244 |
218 |
1240.6527 |
2017-12-18 00:00:00.0 |
0.0000 |
244 |
219 |
1240.6527 |
2017-12-19 00:00:00.0 |
0.0000 |
244 |
220 |
1240.6527 |
2017-12-20 00:00:00.0 |
0.0000 |
244 |
221 |
1240.6527 |
2017-12-21 00:00:00.0 |
0.0000 |
244 |
|
CACHED |
false |
EXECUTIONTIME |
2 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '244') AND ddate < '2020-11-01'
ORDER BY ddate ASC |