search

openego / data_processing

(geo)data processing, database setup, data validation
GNU Affero General Public License v3.0
7 stars 5 forks source link

Lignite generators in Lübeck and near Hamburg? #280

Open jankaeh opened 6 years ago

jankaeh commented 6 years ago

The two generators 35837 and 35858 are the lignite generators with the biggest value for p_nom in Germany (each 1050 MW) and are connected to the 110-kV-bus 25532, which is located in Lübeck (https://www.openstreetmap.org/search?query=53.897547401787%2C%2010.8023580242028#map=15/53.8975/10.8024) I cannot find them in the related lists of BNetzA and OPSD. Might this be a bug? Or am I mistaken?

The generator 35682 is another lignite generator located in the very north of Germany near Hamburg. (https://www.openstreetmap.org/search?query=53.7662776740867%2C%209.98853664959277#map=10/53.8598/9.9035)

I work with v.3.0 Status Quo and clipped the foreign components.

I stumbled over this, because those generators should dispatch a lot in the sense of merit order, but don't if line capacities are regarded in lopf-calculations.

ulfmueller commented 6 years ago

you are right! That was a bug. Please take v0.3.2. There it is fixed.

jankaeh commented 6 years ago

Thanks for your quick reply! Currently I'm not able to download anything from the platform. The only way that worked out for me, now gives an internal server error 500 (https://github.com/openego/oeplatform/issues/305):

data = requests.get(http://oep.iks.cs.ovgu.de//api/v0/schema/grid/tables/ego_pf_hv_generator/rows/?where=version=v0.3.2)

Could you give me a hint, how to change the request so the download will work? And if the download is not possible at the moment, maybe I can adapt the changes you made. Is there a related issue in one of the openego github repositories? I searched at etrago and data_processing but could not find it.

ulfmueller commented 6 years ago

The following feature is very new. If you have an account at the OEP you could use the sql alchemy dialect (see here: https://github.com/openego/ego.io/pull/59 ) and run calculation by getting data from the OEP without downloading. Would that be an option for you? Then, may be we could take this as an concrete use case to write a good how-to (@gnn / @MGlauer ?!)

The changes were made on-the-fly. I think we did not have an issue for that. Sorry about that. @IlkaCu Could you wrap up what you did in order to correctly reassign the coal fired power plants? But I think it is rather difficult to adapt the changes on your data set and in this case I would prefer to not redo this...

jankaeh commented 6 years ago

I just realized by comparing the buses of the generators in v.3.0 and v.3.2 in the dataview of the database, that at least uranium, coal, lignite and gas generators are affected. I manually looked at the top7 and bottom2 generators concerning dispatch-reduction if line-capacities are regarded and all of them are placed somewhere totally different in v.3.2. Or are the bus-ids different too in those versions?

When I decided to work with the data in the oep, I first tried to install the related programs and use the direct connection to the db. I don't know if I'm the only one who struggled with this, but for me as an outsider to your project (and in addition back then being new to linux and python and postgres and everything...) it was a problem I could not solve. So in the end, I downloaded the relevant tables from the platform and used the data for calculations with pypsa. I then used parts of etrago in my python-project.

Right now, I'm trying to finish my Masters Thesis and don't have much time left... Later in July I could give some input from an outsiders point of view for a how-to. I believe some simple introducing words could save some time for other strangers to this project.

In general it's an option for me to work with a direct connection to the database and I do have an account at the OEP. But for now, I'd be thankful to somehow get the generators.csv of Status Quo v.0.3.2 on my system.

ulfmueller commented 6 years ago

I could send you an owncloud link of the generator.csv of the 0.3.2 version, ok? As a quick-and-dirty master thesis service :smirk: . allright? btw: I totally understand that our 'dynamic' development is very hard to understand from the outside! Cool, that you anyhow are able to use much of our stuff! Documentation will become better!

jankaeh commented 6 years ago

That would be great! Thanks. :-)