search

opennem / opennem-fe

An Open Platform for National Electricity Market Data
https://opennem.org.au
MIT License
62 stars 11 forks source link

Incorrect data in UI and CSV export (solar rooftop, unsure if there's others) #62

Open jufemaiz opened 2 years ago

jufemaiz commented 2 years ago

JSON

{
  "id": "au.nem.nsw1.fuel_tech.solar_rooftop.power",
  "type": "power",
  "fuel_tech": "solar_rooftop",
  "network": "nem",
  "region": "NSW1",
  "data_type": "power",
  "code": "solar_rooftop",
  "units": "MW",
  "history": {
    "start": "2021-11-03T14:30:00+10:00",
    "last": "2021-11-10T13:30:00+10:00",
    "interval": "30m",
    "data": [
      2063,
      1794,
      1418,
      1072,
      793.4,
      539.6,
      291,
      106,
      12,
      0.012,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0.626,
      27.73,
      125.2,
      258,
      385.5,
      530.2,
      689.8,
      810.1,
      858,
      892.7,
      933.3,
      1014,
      1057,
      1130,
      1131,
      1142,
      1119,
      1098,
      1006,
      858.2,
      762.1,
      632.7,
      493.7,
      389.6,
      292.8,
      161.7,
      71.55,
      13.56,
      0.295,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0.318,
      21.42,
      82.03,
      160.1,
      273.8,
      409.3,
      561,
      722.6,
      826.3,
      984.9,
      1113,
      1290,
      1328,
      1418,
      1565,
      1576,
      1607,
      1575,
      1543,
      1438,
      1226,
      966.8,
      756.2,
      607.4,
      412.9,
      230.5,
      101.9,
      19.78,
      0.325,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      1.108,
      55.19,
      216.2,
      485.8,
      806.9,
      1165,
      1455,
      1758,
      2046,
      2283,
      2440,
      2610,
      2697,
      2696,
      2657,
      2643,
      2602,
      2534,
      2380,
      2230,
      1939,
      1637,
      1325,
      936,
      568.1,
      302,
      121.9,
      27.39,
      0.13,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      2.525,
      80.34,
      267.1,
      425,
      504.1,
      657.9,
      867,
      1082,
      1299,
      1425,
      1551,
      1595,
      1526,
      1604,
      1534,
      1345,
      1333,
      1227,
      1139,
      1030,
      954.2,
      704.5,
      520.9,
      369.8,
      275.1,
      168.2,
      80.15,
      18.93,
      0.614,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0.191,
      16.98,
      99.33,
      250.9,
      475.9,
      793.6,
      1043,
      1388,
      1638,
      1850,
      1984,
      2050,
      2197,
      2320,
      2415,
      2482,
      2399,
      2254,
      2101,
      1809,
      1643,
      1631,
      1357,
      1000,
      645.7,
      346.5,
      142.5,
      31.26,
      1.064,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      1.549,
      68.77,
      206.1,
      404.4,
      662.2,
      1005,
      1238,
      1520,
      1812,
      2156,
      2293,
      2358,
      2632,
      2703,
      2697,
      2727,
      2670,
      2617,
      2491,
      2335,
      2126,
      1842,
      1514,
      1127,
      767.8,
      441.4,
      186.6,
      41.42,
      0.782,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      1.399,
      58.76,
      213.7,
      356.9,
      493.1,
      557.4,
      618.5,
      723.4,
      786.5,
      983.2,
      1093,
      1123,
      1012,
      890.4,
      860.3,
      863.3,
      881.6,
      855.3
    ]
  },
  "forecast": {
    "start": "2021-11-10T14:00:00+10:00",
    "last": "2021-11-10T17:00:00+10:00",
    "interval": "30m",
    "data": [
      1187,
      1122,
      1038,
      933.2,
      803.9,
      649.4,
      479.8
    ]
  }
}

CSV

date,Pumps -  MW,Exports -  MW,Imports -  MW,Coal (Black) -  MW,Distillate -  MW,Gas (CCGT) -  MW,Gas (OCGT) -  MW,Hydro -  MW,Wind -  MW,Solar (Utility) -  MW,Solar (Rooftop) -  MW,Temperature - C,Emissions Intensity - kgCO₂e/MWh,Price - AUD/MWh
2021-11-09 14:00,-42.03,0.00,500.10,3596.00,-0.13,396.10,0.00,82.68,502.90,1260.00,2439.00,23.70,NaN,10.15
2021-11-09 14:30,-34.89,0.00,430.85,3731.67,-0.13,402.92,0.00,134.18,549.32,1196.67,2343.58,23.65,NaN,31.88
2021-11-09 15:00,0.00,-103.32,121.30,3987.33,-0.13,400.60,0.00,465.53,525.37,1213.17,2137.17,23.18,NaN,72.43
2021-11-09 15:30,0.00,-22.21,109.04,4328.00,-0.13,398.13,-0.65,590.23,503.15,1160.00,1862.00,22.88,NaN,27.86
2021-11-09 16:00,0.00,0.00,182.52,4769.50,-0.13,349.27,-0.64,432.53,417.25,1265.67,1536.42,22.28,NaN,0.00
2021-11-09 16:30,0.00,0.00,147.57,5412.33,-0.14,338.43,0.00,211.01,323.78,1262.50,1161.57,21.10,NaN,0.00
2021-11-09 17:00,0.00,0.00,171.47,5977.83,-0.14,309.08,0.00,272.23,252.92,1106.97,800.47,20.55,NaN,0.00
2021-11-09 17:30,0.00,0.00,482.73,6477.00,-0.14,391.60,0.00,171.21,156.43,633.32,474.57,20.31,NaN,0.00
2021-11-09 18:00,0.00,0.00,844.48,6638.33,-0.15,395.60,0.00,118.12,89.73,293.80,216.97,20.03,NaN,0.00
2021-11-09 18:30,0.00,0.00,1038.43,6574.50,-0.15,397.60,0.00,180.57,56.39,52.98,62.23,19.73,NaN,0.00
2021-11-09 19:00,0.00,0.00,1039.05,6637.67,-0.15,395.93,0.00,208.03,30.19,2.57,7.49,19.53,NaN,0.00
2021-11-09 19:30,0.00,0.00,1030.98,6630.33,-0.14,395.47,0.00,111.92,46.44,0.10,0.13,19.49,NaN,0.00
2021-11-09 20:00,0.00,0.00,791.63,6565.50,-0.14,359.95,0.00,111.82,204.23,0.05,0.00,19.41,NaN,0.00
2021-11-09 20:30,0.00,0.00,689.02,6473.50,-0.13,264.43,0.00,113.55,300.63,0.07,0.00,19.32,NaN,0.00
2021-11-09 21:00,0.00,0.00,626.37,6411.17,-0.13,190.30,0.00,113.17,306.00,0.07,0.00,19.41,NaN,66.31
2021-11-09 21:30,0.00,0.00,634.98,6278.83,-0.13,189.77,0.00,112.40,373.52,0.07,0.00,19.66,NaN,66.56
2021-11-09 22:00,0.00,0.00,684.63,5987.00,-0.13,190.47,0.00,107.23,438.88,0.07,0.00,19.79,NaN,60.00
2021-11-09 22:30,0.00,0.00,779.80,5985.00,-0.12,119.46,0.00,81.58,472.22,0.06,0.00,19.87,NaN,0.00
2021-11-09 23:00,0.00,0.00,0.00,5827.50,-0.12,0.13,0.00,81.39,606.73,0.06,0.00,19.73,NaN,71.01
2021-11-09 23:30,0.00,0.00,0.00,5789.00,-0.12,0.13,0.00,81.20,705.18,0.06,0.00,19.71,NaN,0.00
2021-11-10 00:00,0.00,0.00,0.00,5648.00,-0.11,0.13,0.00,81.11,739.95,0.06,0.00,19.78,NaN,66.72
2021-11-10 00:30,0.00,0.00,0.00,5504.17,-0.11,0.13,0.00,81.78,680.60,0.06,0.00,19.79,NaN,68.04
2021-11-10 01:00,0.00,0.00,0.00,5247.33,-0.11,0.13,0.00,80.89,700.27,0.05,0.00,19.72,NaN,0.00
2021-11-10 01:30,0.00,0.00,0.00,4816.17,-0.10,0.13,0.00,81.36,689.88,0.00,0.00,19.71,NaN,46.42
2021-11-10 02:00,0.00,0.00,0.00,4628.50,-0.10,0.13,0.00,81.93,685.63,0.03,0.00,19.77,NaN,0.00
2021-11-10 02:30,0.00,0.00,0.00,4531.83,-0.10,0.13,0.00,81.27,699.37,0.07,0.00,19.72,NaN,0.00
2021-11-10 03:00,0.00,0.00,0.00,4430.00,-0.10,0.14,0.00,81.54,711.73,0.07,0.00,19.69,NaN,0.00
2021-11-10 03:30,0.00,0.00,0.00,4458.67,-0.10,0.14,0.00,82.01,690.97,0.07,0.00,19.61,NaN,0.00
2021-11-10 04:00,0.00,0.00,0.00,4550.17,-0.10,0.13,0.00,77.95,675.05,0.07,0.00,19.52,NaN,0.00
2021-11-10 04:30,0.00,0.00,0.00,4637.83,-0.10,0.13,0.00,50.22,714.25,0.06,0.12,19.49,NaN,50.09
2021-11-10 05:00,-42.98,0.00,0.00,4831.83,-0.10,0.13,0.00,50.31,712.83,0.09,5.95,19.42,NaN,0.00
2021-11-10 05:30,-62.78,0.00,0.00,5307.00,-0.10,0.08,0.00,50.11,704.10,9.46,62.11,19.43,NaN,0.00
2021-11-10 06:00,0.00,0.00,0.00,5666.00,-0.10,0.11,0.00,50.13,660.32,59.26,199.81,19.79,NaN,0.00
2021-11-10 06:30,0.00,0.00,0.00,5932.83,-0.10,0.12,0.00,50.25,591.82,113.08,344.38,20.42,NaN,0.00
2021-11-10 07:00,0.00,0.00,0.00,5965.83,-0.10,0.13,0.00,158.14,556.55,198.30,475.76,20.81,NaN,73.05
2021-11-10 07:30,0.00,0.00,0.00,5962.50,-0.10,0.12,0.00,214.55,490.90,300.40,551.78,20.68,NaN,0.00
2021-11-10 08:00,0.00,0.00,0.00,5807.17,-0.10,0.12,0.00,174.91,453.98,422.77,617.06,20.86,NaN,0.00
2021-11-10 08:30,0.00,0.00,0.00,5805.33,-0.10,0.19,0.00,70.63,434.28,584.55,711.17,20.95,NaN,195.60
2021-11-10 09:00,0.00,0.00,0.00,5719.50,-0.10,0.56,0.00,50.23,492.35,661.77,792.38,20.63,NaN,74.37
2021-11-10 09:30,0.00,0.00,0.00,5618.17,-0.10,0.56,0.00,50.39,457.43,924.83,959.57,20.25,NaN,0.00
2021-11-10 10:00,0.00,0.00,0.00,5584.67,-0.10,0.57,0.00,164.56,408.22,916.78,1077.20,20.07,NaN,0.00
2021-11-10 10:30,0.00,0.00,0.00,5506.67,-0.10,0.27,0.00,469.22,485.88,920.38,1108.75,20.39,NaN,0.00
2021-11-10 11:00,0.00,0.00,0.00,5530.67,-0.10,0.12,0.00,833.35,482.50,979.38,1020.37,20.22,NaN,0.00
2021-11-10 11:30,0.00,0.00,0.00,5508.83,-0.10,0.13,0.00,928.75,533.00,986.52,908.16,19.85,NaN,0.00
2021-11-10 12:00,0.00,0.00,0.00,5507.50,-0.10,25.11,0.00,801.67,605.55,989.20,865.57,19.63,NaN,0.00
2021-11-10 12:30,0.00,0.00,0.00,5435.50,-0.10,147.77,0.00,489.52,737.42,1019.53,864.33,19.52,NaN,52.89
2021-11-10 13:00,0.00,0.00,0.00,5263.33,-0.10,190.27,0.00,486.13,641.77,971.92,876.36,19.50,NaN,0.00
2021-11-10 13:30,0.00,0.00,0.00,5210.83,-0.10,189.93,0.00,590.43,551.95,863.18,887.32,NaN,NaN,0.00
2021-11-10 14:00,0.00,0.00,0.00,5222.00,-0.10,190.27,0.00,577.70,527.45,912.05,1126.30,NaN,NaN,76.80