{"action":"created","issue":{"url":"https://api.github.com/repos/blahami2/routing-sara/issues/29","repository_url":"https://api.github.com/repos/blahami2/routing-sara","labels_url":"https://api.github.com/repos/blahami2/routing-sara/issues/29/labels{/name}","comments_url":"https://api.github.com/repos/blahami2/routing-sara/issues/29/comments","events_url":"https://api.github.com/repos/blahami2/routing-sara/issues/29/events","html_url":"https://github.com/blahami2/routing-sara/issues/29","id":183949630,"number":29,"title":"Area separation","user":{"login":"blahami2","id":9571904,"avatar_url":"https://avatars.githubusercontent.com/u/9571904?v=3","gravatar_id":"","url":"https://api.github.com/users/blahami2","html_url":"https://github.com/blahami2","followers_url":"https://api.github.com/users/blahami2/followers","following_url":"https://api.github.com/users/blahami2/following{/other_user}","gists_url":"https://api.github.com/users/blahami2/gists{/gist_id}","starred_url":"https://api.github.com/users/blahami2/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/blahami2/subscriptions","organizations_url":"https://api.github.com/users/blahami2/orgs","repos_url":"https://api.github.com/users/blahami2/repos","events_url":"https://api.github.com/users/blahami2/events{/privacy}","received_events_url":"https://api.github.com/users/blahami2/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/blahami2/routing-sara/labels/bug","name":"bug","color":"ee0701"},{"url":"https://api.github.com/repos/blahami2/routing-sara/labels/critical","name":"critical","color":"b60205"},{"url":"https://api.github.com/repos/blahami2/routing-sara/labels/enhancement","name":"enhancement","color":"84b6eb"},{"url":"https://api.github.com/repos/blahami2/routing-sara/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":{"login":"blahami2","id":9571904,"avatar_url":"https://avatars.githubusercontent.com/u/9571904?v=3","gravatar_id":"","url":"https://api.github.com/users/blahami2","html_url":"https://github.com/blahami2","followers_url":"https://api.github.com/users/blahami2/followers","following_url":"https://api.github.com/users/blahami2/following{/other_user}","gists_url":"https://api.github.com/users/blahami2/gists{/gist_id}","starred_url":"https://api.github.com/users/blahami2/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/blahami2/subscriptions","organizations_url":"https://api.github.com/users/blahami2/orgs","repos_url":"https://api.github.com/users/blahami2/repos","events_url":"https://api.github.com/users/blahami2/events{/privacy}","received_events_url":"https://api.github.com/users/blahami2/received_events","type":"User","site_admin":false},"assignees":[{"login":"blahami2","id":9571904,"avatar_url":"https://avatars.githubusercontent.com/u/9571904?v=3","gravatar_id":"","url":"https://api.github.com/users/blahami2","html_url":"https://github.com/blahami2","followers_url":"https://api.github.com/users/blahami2/followers","following_url":"https://api.github.com/users/blahami2/following{/other_user}","gists_url":"https://api.github.com/users/blahami2/gists{/gist_id}","starred_url":"https://api.github.com/users/blahami2/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/blahami2/subscriptions","organizations_url":"https://api.github.com/users/blahami2/orgs","repos_url":"https://api.github.com/users/blahami2/repos","events_url":"https://api.github.com/users/blahami2/events{/privacy}","received_events_url":"https://api.github.com/users/blahami2/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/blahami2/routing-sara/milestones/1","html_url":"https://github.com/blahami2/routing-sara/milestones/Assignment%20deadline","labels_url":"https://api.github.com/repos/blahami2/routing-sara/milestones/1/labels","id":2051361,"number":1,"title":"Assignment deadline","description":"- Working simple version of the SARA algorithm (RAM-based)\r\n- Working partitioning (routing across multiple areas - manually separated and merged)\r\n- [Opt] Working I/O-based version of the SARA algorithm","creator":{"login":"blahami2","id":9571904,"avatar_url":"https://avatars.githubusercontent.com/u/9571904?v=3","gravatar_id":"","url":"https://api.github.com/users/blahami2","html_url":"https://github.com/blahami2","followers_url":"https://api.github.com/users/blahami2/followers","following_url":"https://api.github.com/users/blahami2/following{/other_user}","gists_url":"https://api.github.com/users/blahami2/gists{/gist_id}","starred_url":"https://api.github.com/users/blahami2/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/blahami2/subscriptions","organizations_url":"https://api.github.com/users/blahami2/orgs","repos_url":"https://api.github.com/users/blahami2/repos","events_url":"https://api.github.com/users/blahami2/events{/privacy}","received_events_url":"https://api.github.com/users/blahami2/received_events","type":"User","site_admin":false},"open_issues":5,"closed_issues":2,"state":"open","created_at":"2016-10-06T07:09:33Z","updated_at":"2016-10-20T11:34:14Z","due_on":"2016-11-30T00:00:00Z","closed_at":null},"comments":13,"created_at":"2016-10-19T12:37:02Z","updated_at":"2016-10-21T13:26:01Z","closed_at":null,"body":"# TODO\r\n- [x] find out whether there are turn-restrictions on borders\r\n    - there are no turn-restrictions on level 6 in Czech Republic (does not apply to the whole Europe though)\r\n- [ ] extract multiple (neighboring) areas inside Czech Republic without turn-restrictions on borders"},"comment":{"url":"https://api.github.com/repos/blahami2/routing-sara/issues/comments/255375990","html_url":"https://github.com/blahami2/routing-sara/issues/29#issuecomment-255375990","issue_url":"https://api.github.com/repos/blahami2/routing-sara/issues/29","id":255375990,"user":{"login":"blahami2","id":9571904,"avatar_url":"https://avatars.githubusercontent.com/u/9571904?v=3","gravatar_id":"","url":"https://api.github.com/users/blahami2","html_url":"https://github.com/blahami2","followers_url":"https://api.github.com/users/blahami2/followers","following_url":"https://api.github.com/users/blahami2/following{/other_user}","gists_url":"https://api.github.com/users/blahami2/gists{/gist_id}","starred_url":"https://api.github.com/users/blahami2/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/blahami2/subscriptions","organizations_url":"https://api.github.com/users/blahami2/orgs","repos_url":"https://api.github.com/users/blahami2/repos","events_url":"https://api.github.com/users/blahami2/events{/privacy}","received_events_url":"https://api.github.com/users/blahami2/received_events","type":"User","site_admin":false},"created_at":"2016-10-21T13:26:01Z","updated_at":"2016-10-21T13:26:01Z","body":"# Some random scripts\r\n## Views\r\n```sql\r\ncreate or replace view t_edges_view as\r\nselect e.id, e.data_id, e.source_id, e.target_id, e.is_forward\r\nfrom edges_data_routing d\r\njoin edges_routing e on d.id = e.data_id;\r\n\r\ncreate or replace view t_nodes_view as\r\nselect n.id, n.data_id\r\nfrom nodes_data_routing d\r\njoin nodes_routing n on d.id = n.data_id;\r\n\r\ncreate or replace view t_areas_view as\r\nselect a.id, a.name, a.admin_level, ac.member_type, ac.member_id\r\nfrom areas a\r\njoin area_connectors ac on a.id = ac.area_id;\r\n```\r\n\r\n## Find edges where node areas differ\r\n```sql\r\nselect * \r\nfrom t_edges_view e\r\njoin t_nodes_view s on e.source_id = s.id\r\njoin t_areas_view sa on s.data_id = sa.member_id and sa.member_type = 'N'\r\njoin t_nodes_view t on e.target_id = t.id\r\njoin t_areas_view ta on t.data_id = ta.member_id and ta.member_type = 'N'\r\nwhere sa.id <> ta.id\r\nlimit 50;\r\n```\r\n\r\n## Count edges that should be inside Prague\r\n```sql\r\nselect count(*) \r\nfrom t_edges_view e\r\njoin t_nodes_view s on e.source_id = s.id\r\njoin t_areas_view sa on s.data_id = sa.member_id and sa.member_type = 'N'\r\njoin t_nodes_view t on e.target_id = t.id\r\njoin t_areas_view ta on t.data_id = ta.member_id and ta.member_type = 'N'\r\nwhere sa.name like '%Praha%' and sa.id = ta.id\r\n```"}}
{"actor":{"display_login":"blahami2"}}