{"action":"opened","issue":{"url":"https://api.github.com/repos/openego/dingo/issues/73","repository_url":"https://api.github.com/repos/openego/dingo","labels_url":"https://api.github.com/repos/openego/dingo/issues/73/labels{/name}","comments_url":"https://api.github.com/repos/openego/dingo/issues/73/comments","events_url":"https://api.github.com/repos/openego/dingo/issues/73/events","html_url":"https://github.com/openego/dingo/issues/73","id":188544717,"number":73,"title":"Re-enable export_mv_grid for visualization purposes","user":{"login":"gplssm","id":8255114,"avatar_url":"https://avatars.githubusercontent.com/u/8255114?v=3","gravatar_id":"","url":"https://api.github.com/users/gplssm","html_url":"https://github.com/gplssm","followers_url":"https://api.github.com/users/gplssm/followers","following_url":"https://api.github.com/users/gplssm/following{/other_user}","gists_url":"https://api.github.com/users/gplssm/gists{/gist_id}","starred_url":"https://api.github.com/users/gplssm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gplssm/subscriptions","organizations_url":"https://api.github.com/users/gplssm/orgs","repos_url":"https://api.github.com/users/gplssm/repos","events_url":"https://api.github.com/users/gplssm/events{/privacy}","received_events_url":"https://api.github.com/users/gplssm/received_events","type":"User","site_admin":false},"labels":[{"id":301270058,"url":"https://api.github.com/repos/openego/dingo/labels/bug","name":"bug","color":"fc2929","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/openego/dingo/milestones/8","html_url":"https://github.com/openego/dingo/milestones/MV%20grid%20of%20status%20quo%20is%20ready","labels_url":"https://api.github.com/repos/openego/dingo/milestones/8/labels","id":2003531,"number":8,"title":"MV grid of status quo is ready","description":"Ready in this terms mean\r\n\r\n- A power analysis is undertaken\r\n- Grid reinforcement is undertaken\r\n- The grid is ready to operate in extreme cases with currently connected loads and generators","creator":{"login":"gplssm","id":8255114,"avatar_url":"https://avatars.githubusercontent.com/u/8255114?v=3","gravatar_id":"","url":"https://api.github.com/users/gplssm","html_url":"https://github.com/gplssm","followers_url":"https://api.github.com/users/gplssm/followers","following_url":"https://api.github.com/users/gplssm/following{/other_user}","gists_url":"https://api.github.com/users/gplssm/gists{/gist_id}","starred_url":"https://api.github.com/users/gplssm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gplssm/subscriptions","organizations_url":"https://api.github.com/users/gplssm/orgs","repos_url":"https://api.github.com/users/gplssm/repos","events_url":"https://api.github.com/users/gplssm/events{/privacy}","received_events_url":"https://api.github.com/users/gplssm/received_events","type":"User","site_admin":false},"open_issues":11,"closed_issues":0,"state":"open","created_at":"2016-09-14T08:54:33Z","updated_at":"2016-11-10T15:53:13Z","due_on":"2016-09-20T00:00:00Z","closed_at":null},"comments":0,"created_at":"2016-11-10T15:53:13Z","updated_at":"2016-11-10T15:53:13Z","closed_at":null,"body":"Due to an error not understood, I commented out \"export for visualization\" purposes. See the error\r\n\r\n```\r\nTraceback (most recent call last):\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/engine/base.py\", line 1182, in _execute_context\r\n    context)\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/engine/default.py\", line 462, in do_execute\r\n    cursor.execute(statement, parameters)\r\npsycopg2.DataError: Geometry type (GeometryCollection) does not match column type (MultiPoint)\r\n\r\n\r\nThe above exception was the direct cause of the following exception:\r\n\r\nTraceback (most recent call last):\r\n  File \"/home/guido/rli_local/dingo/test_dingo2.py\", line 47, in <module>\r\n    nd.export_mv_grid(conn, mv_grid_districts)\r\n  File \"/home/guido/rli_local/dingo/dingo/core/__init__.py\", line 762, in export_mv_grid\r\n    session.commit()\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/orm/session.py\", line 874, in commit\r\n    self.transaction.commit()\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/orm/session.py\", line 461, in commit\r\n    self._prepare_impl()\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/orm/session.py\", line 441, in _prepare_impl\r\n    self.session.flush()\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/orm/session.py\", line 2137, in flush\r\n    self._flush(objects)\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/orm/session.py\", line 2257, in _flush\r\n    transaction.rollback(_capture_exception=True)\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/util/langhelpers.py\", line 60, in __exit__\r\n    compat.reraise(exc_type, exc_value, exc_tb)\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/util/compat.py\", line 186, in reraise\r\n    raise value\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/orm/session.py\", line 2221, in _flush\r\n    flush_context.execute()\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/orm/unitofwork.py\", line 389, in execute\r\n    rec.execute(self)\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/orm/unitofwork.py\", line 548, in execute\r\n    uow\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/orm/persistence.py\", line 176, in save_obj\r\n    mapper, table, insert)\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/orm/persistence.py\", line 827, in _emit_insert_statements\r\n    params)\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/engine/base.py\", line 945, in execute\r\n    return meth(self, multiparams, params)\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/sql/elements.py\", line 263, in _execute_on_connection\r\n    return connection._execute_clauseelement(self, multiparams, params)\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/engine/base.py\", line 1053, in _execute_clauseelement\r\n    compiled_sql, distilled_params\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/engine/base.py\", line 1189, in _execute_context\r\n    context)\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/engine/base.py\", line 1393, in _handle_dbapi_exception\r\n    exc_info\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/util/compat.py\", line 202, in raise_from_cause\r\n    reraise(type(exception), exception, tb=exc_tb, cause=cause)\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/util/compat.py\", line 185, in reraise\r\n    raise value.with_traceback(tb)\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/engine/base.py\", line 1182, in _execute_context\r\n    context)\r\n  File \"/home/guido/virtualenvs/dingo/lib/python3.4/site-packages/sqlalchemy/engine/default.py\", line 462, in do_execute\r\n    cursor.execute(statement, parameters)\r\nsqlalchemy.exc.DataError: (psycopg2.DataError) Geometry type (GeometryCollection) does not match column type (MultiPoint)\r\n [SQL: 'INSERT INTO calc_ego_grid.ego_deu_mv_grids_vis (grid_id, geom_mv_station, geom_mv_cable_dists, geom_mv_circuit_breakers, geom_lv_load_area_centres, geom_lv_stations, geom_mv_generators, geom_mv_lines) VALUES (%(grid_id)s, ST_GeomFromWKB(%(ST_GeomFromWKB_1)s, %(ST_GeomFromWKB_2)s), ST_GeomFromWKB(%(ST_GeomFromWKB_3)s, %(ST_GeomFromWKB_4)s), ST_GeomFromWKB(%(ST_GeomFromWKB_5)s, %(ST_GeomFromWKB_6)s), ST_GeomFromWKB(%(ST_GeomFromWKB_7)s, %(ST_GeomFromWKB_8)s), ST_GeomFromWKB(%(ST_GeomFromWKB_9)s, %(ST_GeomFromWKB_10)s), ST_GeomFromWKB(%(ST_GeomFromWKB_11)s, %(ST_GeomFromWKB_12)s), ST_GeomFromWKB(%(ST_GeomFromWKB_13)s, %(ST_GeomFromWKB_14)s))'] [parameters: {'ST_GeomFromWKB_8': '4326', 'ST_GeomFromWKB_1': <memory at 0x7fbdfd0fb9a8>, 'ST_GeomFromWKB_10': '4326', 'ST_GeomFromWKB_12': '4326', 'grid_id': 360, 'ST_GeomFromWKB_2': '4326', 'ST_GeomFromWKB_13': <memory at 0x7fbdfe870f20>, 'ST_GeomFromWKB_3': <memory at 0x7fbdfd0fbcc8>, 'ST_GeomFromWKB_9': <memory at 0x7fbdfd0fbe58>, 'ST_GeomFromWKB_7': <memory at 0x7fbdfd0fbd90>, 'ST_GeomFromWKB_14': '4326', 'ST_GeomFromWKB_5': <memory at 0x7fbdfd0fbc00>, 'ST_GeomFromWKB_4': '4326', 'ST_GeomFromWKB_6': '4326', 'ST_GeomFromWKB_11': <memory at 0x7fbdfd0fb8e0>}]\r\n\r\n```\r\n\r\nOnce, we have a clou why one of the variables has now type `GeometryCollection`, we may solve it and revert 448407a3ef4cfcacb60c5818b611a48d6b08972f\r\n"}}
{"actor":{"display_login":"gplssm"}}