Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

otg_connect_busses_to_lines_1: wrong geometry types #241

Closed
IlkaCu opened this issue May 4, 2021 · 1 comment · Fixed by #245
Closed

otg_connect_busses_to_lines_1: wrong geometry types #241

IlkaCu opened this issue May 4, 2021 · 1 comment · Fixed by #245
Assignees
Labels
🐛 bug Something isn't working

Comments

@IlkaCu
Copy link
Member

IlkaCu commented May 4, 2021

As @ClaraBuettner reported in #238 osmTgmod throws the following error when executing it with the most recent OSM data set and the code from branch fixes/#236-missing-osm_deu_nodes

This is what @ClaraBuettner posted:

It solves the problem described in #236 but I run into errors in osmtgmod:


> [2021-04-29 16:23:34,735] {logging_mixin.py:120} WARNING - 04/29/2021 16:23:34 Executing SQL statement 201:
> CREATE TRIGGER problem_log_trigger
> AFTER DELETE ON power_line_sep
> FOR EACH ROW 
> EXECUTE PROCEDURE otg_power_line_as_branch_problem_tg ('dead_end')
> [2021-04-29 16:23:34,748] {__init__.py:526} INFO - Executing SQL statement 202:
> SELECT otg_connect_busses_to_lines_1 ()
> 
> [2021-04-29 16:23:34,748] {logging_mixin.py:120} WARNING - 04/29/2021 16:23:34 Executing SQL statement 202:
> SELECT otg_connect_busses_to_lines_1 ()
> [2021-04-29 16:29:52,437] {__init__.py:533} ERROR - Exception raised with command 202. Check data and code and restart with 'python ego_otg.py egon-data-clara 202'.
> Traceback (most recent call last):
>   File "/home/buettner/egon-data/git/eGon-data/src/egon/data/processing/osmtgmod/__init__.py", line 530, in osmtgmod
>     cur.execute(command)
> psycopg2.errors.InvalidParameterValue: Geometry type (Point) does not match column type (LineString)
> CONTEXT:  PL/pgSQL function otg_connect_busses_to_lines_1() line 81 at assignment
> 
> [2021-04-29 16:29:52,446] {logging_mixin.py:120} WARNING - 04/29/2021 16:29:52 Exception raised with command 202. Check data and code and restart with 'python ego_otg.py egon-data-clara 202'.
> Traceback (most recent call last):
>   File "/home/buettner/egon-data/git/eGon-data/src/egon/data/processing/osmtgmod/__init__.py", line 530, in osmtgmod
>     cur.execute(command)
> psycopg2.errors.InvalidParameterValue: Geometry type (Point) does not match column type (LineString)
> CONTEXT:  PL/pgSQL function otg_connect_busses_to_lines_1() line 81 at assignment
> [2021-04-29 16:29:57,297] {local_task_job.py:102} INFO - Task exited with return code 1

@IlkaCu IlkaCu added the 🐛 bug Something isn't working label May 4, 2021
@ClaraBuettner
Copy link
Contributor

The problem is caused by a new 110/380kV substation in osm (https://www.openstreetmap.org/way/766922101). This one is not listed in our ehv substations, but the one very close to it (Garenfeld) is a ehv_substation.
This is the result using osm data from 2021:
Garenfeld_osm2021
This is the result using osm data from 2020:
Garenfeld_osm_2020
I'm wondering why the new substation is not part of our ehv substations. @IlkaCu Is there a buffer and the next substation might be too close to identify this as a new substation?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
🐛 bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants