search

pravahio / on-it

This repo contains the todo's of the team. Feel free to add yours.
0 stars 0 forks source link

[solar-production-data] Onboard data from dataglen portal #1

Open upperwal opened 4 years ago

upperwal commented 4 years ago

Dataglen is a data visualisation platform for solar power plants. Please refer to pravahio/mesh-solar-production#1 to learn more about the data.

Task: Fetch, clean, convert it into our standard and start publishing it to Pravah. Get access to the API: Ping @upperwal on slack.

Edit: API Endpoints:

  1. Station List: https://dataglen.com/api/v1/solar/plants/
  2. Station Summary: https://dataglen.com/api/v1/solar/plants/iiitd/summary (Replace "iiitd" with any station slug available in the stations list API)
  3. Data points for every inverter: https://dataglen.com/api/v1/solar/plants/dtu/live
  4. Details of each inverter: https://dataglen.com/api/v1/solar/plants/iiitd/live/?device_type=inverter&inverter=IIITD_INV_1_ACADEMIC_BLOCK

Data from the API looks like this. It is a summary of one of the power plants [there are close to 6-7 power plants on this portal].

{
    "plant_name": "IPGCL IIIT Delhi",
    "plant_slug": "iiitd",
    "plant_logo": "http://dataglen.com/static/solarrms/img/transparent_logo/hfe.png",
    "plant_location": "A-29, Pocket D, Okhla Phase II, Okhla Industrial Area",
    "plant_capacity": "180.0 kWp",
    "latitude": 28.67,
    "longitude": 77.18,
    "performance_ratio": 0.6,
    "specific_yield": 2.29,
    "cuf": 0.05,
    "grid_unavailability": "0 %",
    "equipment_unavailability": "0 %",
    "unacknowledged_tickets": 1,
    "open_tickets": 0,
    "closed_tickets": 488,
    "plant_generation_today": "219.54 kWh",
    "plant_total_energy": "326.13 MWh",
    "current_power": 35.525999999999996,
    "irradiation": 0.43,
    "network_up": "Yes",
    "module_temperature": 23.9784946234,
    "ambient_temperature": 225.904203324,
    "windspeed": 0,
    "dc_loss": "0.00 kWh",
    "conversion_loss": "0.00 kWh",
    "ac_loss": "0.00 kWh",
    "status": "disconnected",
    "updated_at": "2019-11-28T08:03:39.436000Z",
    "inverter_details": {
        "numbers": 6,
        "make": "DELTA",
        "model": "RPIM30A_121",
        "capacity": "50.0 kW X 1,20.0 kW X 1,23.04 kW X 1,30.0 kW X 3"
    },
    "panel_details": {
        "numbers": "564",
        "make": "VIKRAM SOLAR",
        "model": "Polycrystalline_Silicon",
        "capacity": "320.0"
    },
    "max_power": 63.36999999999999,
    "gateways_disconnected": 1,
    "gateways_powered_off": 0,
    "gateways_disconnected_list": [
        "IIITD_SPORTS_BLOCK_GATEWAY_SOURCE"
    ],
    "gateways_powered_off_list": [],
    "gateways_disconnected_ticket": "https://dataglen.com/solar/plant/iiitd/ticket_view/983847/"
}

Live Data from the same power station:

{
    "inverters": [
        {
            "capacity": 23.04,
            "name": "IIITD_INV_1_20_KW_HOSTEL_BLOCK",
            "power": 4.987,
            "last_timestamp": "2019-11-28T08:15:00Z",
            "generation": 28.029999999998836,
            "inside_temperature": "0.0 C",
            "disconnected_ajbs": 0,
            "total_yield": "36565.17 kWh",
            "last_three_errors": [],
            "orientation": "SOUTH",
            "connected": "connected",
            "key": "0SJCqlwYzY78h43",
            "last_inverter_status": [
                {
                    "status": "Grid Tie - Operation",
                    "timestamp": "2019-11-28T08:15:00Z"
                }
            ],
            "solar_group": "IIITD_HOSTEL_BLOCK",
            "total_ajbs": 0
        },
        {
            "capacity": 30,
            "name": "IIITD_INV_1_ACADEMIC_BLOCK",
            "power": 7.435,
            "last_timestamp": "2019-11-28T08:15:01Z",
            "generation": 43.890000000006694,
            "inside_temperature": "0.0 C",
            "disconnected_ajbs": 0,
            "total_yield": "58950.23 kWh",
            "last_three_errors": [],
            "orientation": "SOUTH",
            "connected": "connected",
            "key": "xjVvoG3Qwtw5Eqc",
            "last_inverter_status": [
                {
                    "status": "Grid Tie - Operation",
                    "timestamp": "2019-11-28T08:15:01Z"
                }
            ],
            "solar_group": "IIITD_ACADEMIC_BLOCK",
            "total_ajbs": 0
        },
        {
            "capacity": 50,
            "name": "IIITD_INV_1_LECTURER_BLOCK",
            "power": 11.422,
            "last_timestamp": "2019-11-28T08:15:00Z",
            "generation": 63.33999999999651,
            "inside_temperature": "0.0 C",
            "disconnected_ajbs": 0,
            "total_yield": "83094.79 kWh",
            "last_three_errors": [],
            "orientation": "SOUTH",
            "connected": "connected",
            "key": "f5qUJWwBvsJLVfU",
            "last_inverter_status": [
                {
                    "status": "Grid Tie - Operation",
                    "timestamp": "2019-11-28T08:15:00Z"
                }
            ],
            "solar_group": "IITD_LECTURER_BLOCK",
            "total_ajbs": 0
        },
        {
            "capacity": 30,
            "name": "IIITD_INV_2_ACADEMIC_BLOCK",
            "power": 7.312,
            "last_timestamp": "2019-11-28T08:15:02Z",
            "generation": 42.93000000000029,
            "inside_temperature": "0.0 C",
            "disconnected_ajbs": 0,
            "total_yield": "59953.29 kWh",
            "last_three_errors": [],
            "orientation": "SOUTH",
            "connected": "connected",
            "key": "G5cPIzqNyAFMMBc",
            "last_inverter_status": [
                {
                    "status": "Grid Tie - Operation",
                    "timestamp": "2019-11-28T08:15:02Z"
                }
            ],
            "solar_group": "IIITD_ACADEMIC_BLOCK",
            "total_ajbs": 0
        },
        {
            "capacity": 30,
            "name": "IIITD_INV__3__ACADEMIC_BLOCK",
            "power": 7.63,
            "last_timestamp": "2019-11-28T08:15:02Z",
            "generation": 45.61000000000058,
            "inside_temperature": "0.0 C",
            "disconnected_ajbs": 0,
            "total_yield": "62711.32 kWh",
            "last_three_errors": [],
            "orientation": "SOUTH",
            "connected": "connected",
            "key": "BXU1R5mEAMZ7kax",
            "last_inverter_status": [
                {
                    "status": "Grid Tie - Operation",
                    "timestamp": "2019-11-28T08:15:02Z"
                }
            ],
            "solar_group": "IIITD_ACADEMIC_BLOCK",
            "total_ajbs": 0
        },
        {
            "capacity": 19.2,
            "name": "IIITD_Inverter_1",
            "power": 0,
            "last_timestamp": "2019-11-28T06:30:00Z",
            "generation": 17.13000000000102,
            "inside_temperature": "0.0 C",
            "disconnected_ajbs": 0,
            "total_yield": "24874.99 kWh",
            "last_three_errors": [],
            "orientation": "SOUTH",
            "connected": "disconnected",
            "key": "vACzRGjb97QVWxQ",
            "last_inverter_status": [],
            "solar_group": "Sports_Block",
            "total_ajbs": 0
        }
    ],
    "solar_groups": [
        "IIITD_ACADEMIC_BLOCK",
        "IITD_LECTURER_BLOCK",
        "IIITD_HOSTEL_BLOCK",
        "Sports_Block"
    ],
    "total_group_number": 4
}

Data associated with each inverter (group of solar panels)

{
    "dc_sld": [
        {
            "name": "AC Power",
            "value": "7.43 kW"
        },
        {
            "name": "AC Power B-Phase",
            "value": "2.46 kW"
        },
        {
            "name": "AC Power R-Phase",
            "value": "2.47 kW"
        },
        {
            "name": "AC Power Y-Phase",
            "value": "2.5 kW"
        },
        {
            "name": "AC Frequency B-Phase",
            "value": "49.92 Hz"
        },
        {
            "name": "AC Frequency R-Phase",
            "value": "49.92 Hz"
        },
        {
            "name": "AC Frequency Y-Phase",
            "value": "49.92 Hz"
        },
        {
            "name": "AC Voltage B-Phase",
            "value": "244.0 V"
        },
        {
            "name": "AC Voltage R-Phase",
            "value": "245.3 V"
        },
        {
            "name": "AC Voltage Y-Phase",
            "value": "247.3 V"
        },
        {
            "name": "Apparent Power B-Phase",
            "value": "NA"
        },
        {
            "name": "Apparent Power R-Phase",
            "value": "NA"
        },
        {
            "name": "Apparent Power Y-Phase",
            "value": "NA"
        },
        {
            "name": "AC Current B-Phase",
            "value": "10.16 A"
        },
        {
            "name": "AC Current R-Phase",
            "value": "10.12 A"
        },
        {
            "name": "AC Current Y-Phase",
            "value": "10.26 A"
        },
        {
            "name": "Todays Generation",
            "value": "43.9 kWh"
        },
        {
            "name": "DC Power",
            "value": "7.52 kW"
        },
        {
            "name": "Heat Sink Temperature",
            "value": "37.0 C"
        },
        {
            "name": "PV1 DC Current",
            "value": "7.0 A"
        },
        {
            "name": "PV1 DC Power",
            "value": "4.54 kW"
        },
        {
            "name": "PV1 DC Voltage",
            "value": "647.9 V"
        },
        {
            "name": "PV2 DC Current",
            "value": "4.61 A"
        },
        {
            "name": "PV2 DC Power",
            "value": "2.98 kW"
        },
        {
            "name": "PV2 DC Voltage",
            "value": "646.5 V"
        },
        {
            "name": "Inverter Operational Status",
            "value": "2.0 NA"
        },
        {
            "name": "Total Operational Runime",
            "value": "23335.0 H"
        },
        {
            "name": "Total Generation",
            "value": "58950 kWh"
        }
    ],
    "last_timestamp": "2019-11-28T08:15:01Z"
}
upperwal commented 4 years ago

@assamidanov

upperwal commented 4 years ago

@dileepteja3

upperwal commented 4 years ago

Pending for deployment: https://github.com/pravahio/dataglen_scrap/commit/b57eeb5a67dd809224198e63d1ae5a071b11e01f