Add AD 🇦🇩 exchanges

[Manu1400]

Add link (without realtime value) :

• ES<->AD exchange : 110 kV
• FR<->AD exchange : 225 kV

source :

• "L'électricité consommée en Andorre (de moyenne pour les années 2010 et 2011, 599.000 MW.h) est principalement importée de France et d’Espagne." in https://unfccc.int/sites/default/files/resource/AND_BUR1_Definitiu.pdf
• http://pyrenees-orientales.cci.fr/sites/default/files/Aur%C3%A9lie%20Greck/B2B20180925Deroul_1%20CMiquel_FR.pdf (page 5), or in english : https://unfccc.int/sites/default/files/resource/1_Andorra_FSV_Presentation.pdf

[alixunderplatz]

Hi @Manu1400 technical exchange capacities in Megawatts are required for the interconnectors on the map (not the voltages of the power lines). Without real-time data, it is not necessary to include them in the code for the map, as they won't appear. Could you find any real-time exchange data for Andorra with France and Spain? If not, I'd close the issue.

[gwpicard]

@Manu1400 any updates on real-time exchange data between FR/ES <--> AD? If not as @alixunderplatz we would close this issue because it won't change much in terms of our data just listing the existence of the exchange without data

[silimotion]

I've found that the exchange between Spain and Andorra is published in the REE website:

Would this be useful? It seems ESIOS is also used in the Spain-Morocco connection.

[VIKTORVAV99]

I've found that the exchange between Spain and Andorra is published in the REE website:

Would this be useful? It seems ESIOS is also used in the Spain-Morocco connection.

Nice! Looks like we should be able to build a parser with this info and get the exchange added.

[VIKTORVAV99]

I found a slight problem, the dataset that should contain the aggregated final import export for the Spain -> Andorra exchange is empty...

Here is the Andorra exchange dataset: https://www.esios.ree.es/en/analysis/10210?vis=1&start_date=24-07-2023T00%3A00&end_date=24-07-2023T23%3A55&compare_start_date=23-07-2023T00%3A00&groupby=hour

Here is the Morocco exchange dataset (that we currently use): https://www.esios.ree.es/en/analysis/10209?vis=1&start_date=24-07-2023T00%3A00&end_date=24-07-2023T23%3A55&compare_start_date=23-07-2023T00%3A00&groupby=hour

Now there is a bunch of other Andorra exchange datasets that we could maybe use? (like the day ahead one?)

Day ahead dataset (I think): https://www.esios.ree.es/en/analysis/10131?vis=1&start_date=24-07-2023T00%3A00&end_date=25-07-2023T23%3A55&compare_start_date=23-07-2023T00%3A00&groupby=hour

[silimotion]

I was also investigating the API and found the same problem. The best data that I found was this: https://www.esios.ree.es/en/analysis/10278?vis=1&start_date=24-07-2023T00%3A00&end_date=25-07-2023T23%3A55&compare_start_date=23-07-2023T00%3A00&groupby=hour

It seems to also take into account intra-day market.

By the way, while looking at the data produced by the ESIOS parser for Spain-Morocco (available also in the map), I've seen that it is quite different from the one available at the REE ESIOS webpage. Could you check this out? If this is correct we'll have to fix that before/during these Andorra changes, assuming we reuse this parser.