| messages |
|---|
| IDwt finished successfully! |
The query below returns the output shown in the following table:
SELECT * FROM climate_reconstruct ORDER BY city, indexid;
The output table is the same as the input table to the DWT function (Input). The original values for the temperature, pressure and the dew point are reconstructed.
| city | indexid | temp_f | pressure_mbar | dewpoint_f |
|---|---|---|---|---|
| Asheville | 1 | 34.9000015258789 | 1020.5 | 28.8999996185303 |
| Asheville | 2 | 34.4000015258789 | 1020.20001220703 | 28.7000007629395 |
| Asheville | 3 | 33.9000015258789 | 1020 | 28.3999996185303 |
| Asheville | 4 | 33.4000015258789 | 1020.20001220703 | 28.2999992370606 |
| Asheville | 5 | 33.0999984741211 | 1020.20001220703 | 28 |
| Asheville | 6 | 32.7000007629395 | 1020 | 27.8999996185303 |
| Asheville | 7 | 32.5 | 1020.29998779297 | 27.7000007629395 |
| Asheville | 8 | 32.2999992370606 | 1020.79998779297 | 27.6000003814697 |
| Asheville | 9 | 32.0999984741211 | 1021.29998779297 | 27.3999996185303 |
| Asheville | 10 | 33.7999992370606 | 1021.70001220703 | 28.2000007629395 |
| Asheville | 11 | 36.4000015258789 | 1022.09997558594 | 28.8999996185303 |
| Asheville | 12 | 39.4000015258789 | 1022 | 29.2999992370606 |
| Asheville | 13 | 42.0999984741211 | 1021.09997558594 | 29.2000007629395 |
| Asheville | 14 | 44.2000007629395 | 1020 | 29.1000003814698 |
| Asheville | 15 | 45.5999984741211 | 1019.29998779297 | 28.8999996185303 |
| Asheville | 16 | 46.2000007629395 | 1019 | 28.5 |
| Asheville | 17 | 45.7999992370606 | 1019.20001220703 | 28.5 |
| Asheville | 18 | 44.0999984741211 | 1019.59997558594 | 28.6000003814698 |
| Asheville | 19 | 41.2000007629395 | 1020.09997558594 | 28.5 |
| Asheville | 20 | 39.5999984741211 | 1020.59997558594 | 28.7999992370606 |
| Asheville | 21 | 38.2000007629395 | 1020.90002441406 | 29 |
| Asheville | 22 | 37.2000007629395 | 1021.09997558594 | 29 |
| Asheville | 23 | 36.2999992370606 | 1021 | 29 |
| Asheville | 24 | 35.5 | 1020.90002441406 | 29 |
| Brownsville | 1 | 35.0999984741211 | 1020.5 | 28.8999996185303 |
| Brownsville | 2 | 34.5999984741211 | 1020.20001220703 | 28.7999992370606 |
| Brownsville | 3 | 34.0999984741211 | 1020 | 28.5 |
| Brownsville | 4 | 33.7000007629395 | 1020.09997558594 | 28.3999996185303 |
| Brownsville | 5 | 33.2999992370606 | 1020.20001220703 | 28.2000007629395 |
| ... | ... | ... | ... | ... |