Tables

conditions dl_device_type dl_inverter_device_data dl_meter_device_data pg_stat_statements pg_stat_statements_info tbl001EC6050189_1 tbl001EC6050189_2 tbl001EC6050189_3 tbl001EC6050189_32 tbl001EC6050189_33 tbl001EC6050189_6 tbl001EC60506E1_1 tbl001EC60506E1_10 tbl001EC60506E1_3 tbl001EC6050B08_1 tbl001EC6050B08_2 tbl001EC6050B08_51 tbl001EC6050B42_1 tbl001EC6050B42_2 tbl001EC6050B42_3 tbl001EC6050B42_4 tbl001EC6050B42_51 tbl001EC6050B42_52 tbl001EC6050B5D_1 tbl001EC6050B5D_2 tbl001EC6050B5D_3 tbl001EC6050B5D_4 tbl001EC6050B5D_5 tbl001EC6050B5D_51 tbl001EC6050B5D_52 tbl001EC6050B87_1 tbl001EC6050B87_103 tbl001EC6050B87_2 tbl001EC6050B87_3 tbl001EC6050B87_4 tbl001EC6050B87_5 tbl001EC6050B87_51 tbl001EC6050B87_6 tbl001EC6050B87_7 tbl001EC6050BAC_1 tbl001EC6050BAC_10 tbl001EC6050BAC_2 tbl001EC6050BAC_3 tbl001EC6050BAC_4 tbl001EC6050BAC_5 tbl001EC6050BAC_51 tbl001EC6050BAC_52 tbl001EC6050BAC_6 tbl001EC6050BAC_7 tbl001EC6050BAC_8 tbl001EC6050BAC_9 tbl001EC6050C0B_1 tbl001EC6050C0B_3 tbl001EC6050C0B_51 tbl001EC6050D05_103 tbl001EC6050D05_51 tbl001EC6050D05_80 tbl001EC6050D06_2 tbl001EC6050D06_3 tbl001EC6050D06_4 tbl001EC6050D06_51 tbl001EC6050D15_10 tbl001EC6050D15_11 tbl001EC6050D15_12 tbl001EC6050D15_7 tbl001EC6050D15_8 tbl001EC6050D15_9 tbl001EC6050D16_10 tbl001EC6050D16_4 tbl001EC6050D16_5 tbl001EC6050D16_50 tbl001EC6050D16_51 tbl001EC6050D16_52 tbl001EC6050D16_6 tbl001EC6050D16_7 tbl001EC6050D16_8 tbl001EC6050D16_9 tbl001EC6050D17_1 tbl001EC6050D17_2 tbl001EC6050D17_3 tbl001EC6050D17_4 tbl001EC6050D17_5 tbl001EC6050D17_51 tbl001EC6050D17_6 tbl001EC6050D21_103 tbl001EC6050D21_51 tbl001EC6050D21_52 tbl001EC6050D21_80 tbl001EC6050D21_81 tbl001EC6050D30_3 tbl001EC6050D30_51 tbl001EC6050D30_80 tbl001EC6050DA5_1 tbl001EC6050DA5_2 tbl001EC6050DA5_51 tbl001EC6050E0D_1 tbl001EC6050E0D_2 tbl001EC6050E0D_51 tbl001EC6050E4D_2 tbl001EC6050E4D_52 tbl001EC6050E4D_80 tbl001EC6050E4D_81 tbl001EC6050EFC_211 tbl001EC6050EFC_213 tbl001EC6050F3A_1 tbl001EC6050F3A_2 tbl001EC6050F3A_3 tbl001EC6050F3A_4 tbl001EC6050F3A_51 tbl001EC6050F3C_1 tbl001EC6050F3C_10 tbl001EC6050F3C_11 tbl001EC6050F3C_12 tbl001EC6050F3C_13 tbl001EC6050F3C_14 tbl001EC6050F3C_15 tbl001EC6050F3C_16 tbl001EC6050F3C_17 tbl001EC6050F3C_18 tbl001EC6050F3C_19 tbl001EC6050F3C_2 tbl001EC6050F3C_3 tbl001EC6050F3C_33 tbl001EC6050F3C_4 tbl001EC6050F3C_5 tbl001EC6050F3C_54 tbl001EC6050F3C_6 tbl001EC6050F3C_7 tbl001EC6050F3C_8 tbl001EC6050F3C_9 tbl001EC6050F42_1 tbl001EC6050F42_2 tbl001EC6050F42_51 tbl001EC6052F1E_51 tbl001EC6052F1E_9 tbl001EC6053019_53 tbl001EC6053075_5 tbl001EC6053075_51 tbl001EC6053075_52 tbl001EC6053075_53 tbl001EC6053075_54 tbl001EC6053075_6 tbl001EC6053075_60 tbl001EC6053075_7 tbl001EC6053093_51 tbl001EC6053093_52 tbl001EC6053093_53 tbl001EC6053093_54 tbl001EC6053093_55 tbl001EC6053093_9 tbl001EC605309C_51 tbl001EC605309C_52 tbl001EC605309C_53 tbl001EC605309C_54 tbl001EC605309C_55 tbl001EC605309C_9 tbl001EC60530AB_51 tbl001EC60530AB_9 tbl001EC6053109_1 tbl001EC6053109_11 tbl001EC6053109_2 tbl001EC6053109_3 tbl001EC6053109_4 tbl001EC6053109_5 tbl001EC6053109_7 tbl001EC6053113_10 tbl001EC6053113_51 tbl001EC6053113_52 tbl001EC6053113_53 tbl001EC6053113_9 tbl001EC605311A_1 tbl001EC605311A_2 tbl001EC605311A_3 tbl001EC605376F_1 tbl001EC605376F_2 tbl001EC605376F_21 tbl001EC605376F_3 tbl001EC605376F_37 tbl001EC605376F_42 tbl001EC60537AE_1 tbl001EC60537AE_2 tbl001EC60537AE_21 tbl001EC60537AE_41 tbl001EC60537DD_1 tbl001EC60537DD_2 tbl001EC60537DD_21 tbl001EC60537DD_3 tbl001EC60537DD_4 tbl001EC60537DD_41 tbl001EC60537DD_5 tbl001EC60537DD_6 tbl001EC60537E0_1 tbl001EC60537E0_2 tbl001EC60537E0_21 tbl001EC60537E0_3 tbl001EC60537E0_41 tbl001EC6053CD9_1 tbl001EC6053CD9_10 tbl001EC6053CD9_2 tbl001EC6053CD9_4 tbl001EC6053CD9_5 tbl001EC6054E7A_1 tbl001EC6054E88_103 tbl001EC6054E88_11 tbl001EC6054E88_2 tbl001EC6054E88_56 tbl001EC6056300_10 tbl001EC6056300_15 tbl001EC6056300_50 tbl001EC6056300_51 tbl001EC6056300_52 tbl001EC6056300_53 tbl001EC6056300_55 tbl001EC6056D41_51 tbl001EC6056D41_52 tbl001EC6056D41_53 tbl001EC6056D41_54 tbl001EC6056D41_55 tbl001EC6056D41_9 tbl001EC6056D47_10 tbl001EC6056D47_50 tbl001EC6056D47_51 tbl001EC6056D47_52 tbl001EC6056D47_9 tbl001EC6056D48_51 tbl001EC6056D48_52 tbl001EC6056D48_53 tbl001EC6056D48_54 tbl001EC6056D48_55 tbl001EC6056D48_9 tbl001EC6056D49_10 tbl001EC6056D49_51 tbl001EC6056D49_52 tbl001EC6056D49_53 tbl001EC6056D49_9 tbl001EC6056FD2_10 tbl001EC6056FD2_23 tbl001EC6056FD2_26 tbl001EC6056FD2_27 tbl001EC6056FD2_28 tbl001EC6056FD2_51 tbl001EC6056FD2_52 tbl001EC6056FD2_54 tbl001EC6056FD2_55 tbl001EC6056FD2_59 tbl001EC6056FD2_60 tbl001EC6056FD2_61 tbl001EC6056FD2_62 tbl001EC6056FD2_63 tbl001EC6056FD2_64 tbl001EC6056FD2_65 tbl001EC6056FD2_66 tbl001EC6056FD2_67 tbl001EC6056FD2_68 tbl001EC6056FD2_69 tbl001EC6056FD2_9 tbl001EC6057D26_4 tblacquisuite tbldevicelist

tbl001EC6050D30_51

time
timestamp without time zone 		error
integer 		lowrange
bigint 		highrange
bigint 		umtLastMeasTime_1
double precision 		2
double precision 		umtWindSpeed_MPH_3
double precision 		4
double precision 		umtRawWindDir_Degrees_5
double precision 		6
double precision 		umtAdjWindDir_Degrees_7
double precision 		8
double precision 		umtRelHumidity_9
double precision 		10
double precision 		umtRawBaromPress_Inches_Hg_11
double precision 		12
double precision 		umtAdjBaromPress_Inches_Hg_13
double precision 		14
double precision 		umtTrueNorthOffset_Degrees_15
double precision 		16
double precision 		umtLastRain_Date_and_Time_17
double precision 		18
double precision 		umtTemp1_Degrees_F_19
double precision 		20
double precision 		umtWindChill_Degrees_F_21
double precision 		22
double precision 		umtHeatIndex_Degrees_F_23
double precision 		24
double precision 		umtDewPoint_Degrees_F_25
double precision 		26
double precision 		umtDensityAltitude_Feet_27
double precision 		28
double precision 		umtRainToday_Inches_29
double precision 		umtTemp2_Degrees_F_30
double precision 		umtTemp3_Degrees_F_31
double precision 		umtTemp4_Degrees_F_32
double precision 		umtSolarRadiation_W_m_2_33
double precision 		umtSolarRadiation_2_W_m_2_34
double precision 		35
double precision 		36
double precision 		37
double precision 		38
double precision 		39
double precision 		40
double precision 		41
double precision 		42
double precision 		43
double precision 		44
double precision 		45
double precision 		46
double precision 		47
double precision 		48
double precision 		49
double precision 		50
double precision 		51
double precision 		52
double precision
2026-08-18 06:30:00 0 0 0 1787020745 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72.737 80.208 0 1.999 2.135
2026-08-18 06:15:00 0 0 0 1787019845 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72.408 88.448 0 1.599 1.423
2026-08-18 06:00:00 0 0 0 1787018945 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 73.287 83.284 0 1.599 1.068
2026-08-18 05:45:00 0 0 0 1787018045 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 73.506 85.042 0 1.599 1.779
2026-08-18 05:30:00 0 0 0 1787017145 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 73.946 82.735 0 1.999 1.779
2026-08-18 05:15:00 0 0 0 1787016245 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 73.836 89.656 0 1.599 1.779
2026-08-18 05:00:00 0 0 0 1787015345 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 73.177 43.074 0 1.599 1.423
2026-08-18 04:45:08 139
2026-08-18 04:30:34 139
2026-08-18 04:30:22 160
2026-08-18 04:29:45 161
2026-08-18 04:15:08 139
2026-08-18 04:09:22 139
2026-08-18 04:09:10 160
2026-08-18 04:08:34 161
2026-08-18 04:00:08 139
2026-08-18 03:45:09 139
2026-08-18 03:30:33 139
2026-08-18 03:30:21 160
2026-08-18 03:29:45 161
2026-08-18 03:15:09 139
2026-08-18 03:09:21 139
2026-08-18 03:09:09 160
2026-08-18 03:08:33 161
2026-08-18 03:00:08 139
2026-08-18 02:45:08 139
2026-08-18 02:30:32 139
2026-08-18 02:30:20 160
2026-08-18 02:29:45 161
2026-08-18 02:15:08 139
2026-08-18 02:09:21 139
2026-08-18 02:09:09 160
2026-08-18 02:08:33 161
2026-08-18 02:00:09 139
2026-08-18 01:45:08 139
2026-08-18 01:30:33 139
2026-08-18 01:30:21 160
2026-08-18 01:29:45 161
2026-08-18 01:15:09 139
2026-08-18 01:09:22 139
2026-08-18 01:09:10 160
2026-08-18 01:08:33 161
2026-08-18 01:00:09 139
2026-08-18 00:45:09 139
2026-08-18 00:30:34 139
2026-08-18 00:30:22 160
2026-08-18 00:29:45 161
2026-08-18 00:15:08 139
2026-08-18 00:09:22 139
2026-08-18 00:09:10 160
2026-08-18 00:08:34 161
2026-08-18 00:00:08 139
2026-08-17 23:45:08 139
2026-08-17 23:30:00 0 0 0 1786995546 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 80.647 6.709 0 5.997 5.338
2026-08-17 23:15:00 0 0 0 1786994645 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 81.636 10.555 0 7.596 7.117
2026-08-17 23:00:00 0 0 0 1786993745 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 82.295 19.234 0 7.596 8.184
2026-08-17 22:45:00 0 0 0 1786992845 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 82.186 12.642 0 13.593 14.945
2026-08-17 22:30:00 0 0 0 1786991945 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 85.811 11.543 0 23.987 25.264
2026-08-17 22:15:00 0 0 0 1786991045 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 88.667 23.738 0 57.568 59.78
2026-08-17 22:00:00 0 0 0 1786990145 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 91.414 14.07 0 86.353 88.603
2026-08-17 21:45:01 0 0 0 1786989245 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 96.688 12.422 0 98.346 105.683
2026-08-17 21:30:00 0 0 0 1786988345 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 99.544 18.685 0 393.784 402.805
2026-08-17 21:15:00 0 0 0 1786987445 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 97.017 12.862 0 409.775 424.155
2026-08-17 21:00:00 0 0 0 1786986545 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 104.158 11.324 0 457.349 467.211
2026-08-17 20:45:00 0 0 0 1786985645 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 106.795 13.741 0 250.262 257.625
2026-08-17 20:30:00 0 0 0 1786984745 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 119.539 14.949 0 662.036 685.694
2026-08-17 20:15:00 0 0 0 1786983845 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 113.716 4.512 0 692.819 711.314
2026-08-17 20:00:00 0 0 0 1786982945 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 107.234 3.523 0 316.226 309.576
2026-08-17 19:45:00 0 0 0 1786982045 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 127.339 1.875 0 519.714 519.519
2026-08-17 19:30:00 0 0 0 1786981145 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 117.122 5.062 0 790.765 812.015
2026-08-17 19:15:00 0 0 0 1786980245 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 96.688 0.667 0 310.629 312.067
2026-08-17 19:00:00 0 0 0 1786979345 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 97.896 2.095 0 292.639 291.429
2026-08-17 18:45:00 0 0 0 1786978445 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 98.335 13.851 0 247.864 246.949
2026-08-17 18:30:00 0 0 0 1786977545 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 107.454 15.718 0 492.529 499.236
2026-08-17 18:15:00 0 0 0 1786976645 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 108.882 10.884 0 384.589 386.437
2026-08-17 18:00:00 0 0 0 1786975745 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 120.638 6.38 0 414.972 473.616
2026-08-17 17:45:00 0 0 0 1786974845 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 120.088 10.665 0 657.239 697.081
2026-08-17 17:30:00 0 0 0 1786973946 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 109.542 9.676 0 499.326 506.709
2026-08-17 17:15:00 0 0 0 1786973045 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 94.93 2.095 0 362.201 364.731
2026-08-17 17:00:00 0 0 0 1786972145 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 99.983 -4.606 0 414.972 417.75
2026-08-17 16:45:00 0 0 0 1786971245 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 107.784 -2.299 0 467.743 472.193
2026-08-17 16:30:00 0 0 0 1786970345 1786970112 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 105.367 -9.221 0 479.736 491.764
2026-08-17 16:15:00 0 0 0 1786969445 1786904576 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 109.432 -2.299 0 612.064 627.337
2026-08-17 16:00:00 0 0 0 1786968545 1786904576 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 93.831 4.073 0 383.789 386.437
2026-08-17 15:45:00 0 0 0 1786967645 1786904576 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 94.38 1.656 0 357.004 355.479
2026-08-17 15:30:00 0 0 0 1786966745 1786904576 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100.093 5.062 0 362.201 362.24
2026-08-17 15:15:00 0 0 0 1786965845 1786904576 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 91.963 8.797 0 325.821 320.963
2026-08-17 15:00:00 0 0 0 1786964945 1786904576 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 90.755 6.27 0 463.745 462.23
2026-08-17 14:45:00 0 0 0 1786964045 1786904576 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 90.535 14.62 0 414.172 414.548
2026-08-17 14:30:00 0 0 0 1786963145 1786904576 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 84.053 5.721 0 335.815 337.332
2026-08-17 14:15:00 0 0 0 1786962245 1786904576 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 81.087 4.512 0 250.662 250.152
2026-08-17 14:00:00 0 0 0 1786961345 1786904576 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 83.174 5.611 0 155.515 153.009
2026-08-17 13:45:00 0 0 0 1786960445 1786904576 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 91.194 8.577 0 266.653 268.3
2026-08-17 13:30:00 0 0 0 1786959545 1786904576 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 90.096 3.743 0 439.758 449.42
2026-08-17 13:15:00 0 0 0 1786958645 1786904576 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 85.701 -1.97 0 344.611 349.074
2026-08-17 13:00:00 0 0 0 1786957745 1786904576 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 80.538 0.557 0 247.464 250.152
2026-08-17 12:45:00 0 0 0 1786956845 1786904576 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 81.307 -4.277 0 296.637 301.036
2026-08-17 12:30:00 0 0 0 1786955945 1786904576 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 77.132 0.667 0 180.301 182.543
2026-08-17 12:15:00 0 0 0 1786955045 1786904576 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 77.571 -1.75 0 193.494 193.93
2026-08-17 12:00:00 0 0 0 1786954145 1786904576 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 75.374 0.337 0 230.273 226.667