{"action":"created","issue":{"url":"https://api.github.com/repos/enram/bird-migration-flow-visualization/issues/105","labels_url":"https://api.github.com/repos/enram/bird-migration-flow-visualization/issues/105/labels{/name}","comments_url":"https://api.github.com/repos/enram/bird-migration-flow-visualization/issues/105/comments","events_url":"https://api.github.com/repos/enram/bird-migration-flow-visualization/issues/105/events","html_url":"https://github.com/enram/bird-migration-flow-visualization/issues/105","id":86311526,"number":105,"title":"Correct SQL requirements for v/u_speed","user":{"login":"peterdesmet","id":600993,"avatar_url":"https://avatars.githubusercontent.com/u/600993?v=3","gravatar_id":"","url":"https://api.github.com/users/peterdesmet","html_url":"https://github.com/peterdesmet","followers_url":"https://api.github.com/users/peterdesmet/followers","following_url":"https://api.github.com/users/peterdesmet/following{/other_user}","gists_url":"https://api.github.com/users/peterdesmet/gists{/gist_id}","starred_url":"https://api.github.com/users/peterdesmet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/peterdesmet/subscriptions","organizations_url":"https://api.github.com/users/peterdesmet/orgs","repos_url":"https://api.github.com/users/peterdesmet/repos","events_url":"https://api.github.com/users/peterdesmet/events{/privacy}","received_events_url":"https://api.github.com/users/peterdesmet/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/enram/bird-migration-flow-visualization/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"peterdesmet","id":600993,"avatar_url":"https://avatars.githubusercontent.com/u/600993?v=3","gravatar_id":"","url":"https://api.github.com/users/peterdesmet","html_url":"https://github.com/peterdesmet","followers_url":"https://api.github.com/users/peterdesmet/followers","following_url":"https://api.github.com/users/peterdesmet/following{/other_user}","gists_url":"https://api.github.com/users/peterdesmet/gists{/gist_id}","starred_url":"https://api.github.com/users/peterdesmet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/peterdesmet/subscriptions","organizations_url":"https://api.github.com/users/peterdesmet/orgs","repos_url":"https://api.github.com/users/peterdesmet/repos","events_url":"https://api.github.com/users/peterdesmet/events{/privacy}","received_events_url":"https://api.github.com/users/peterdesmet/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/enram/bird-migration-flow-visualization/milestones/21","html_url":"https://github.com/enram/bird-migration-flow-visualization/milestones/Redo%20aggregation%20query","labels_url":"https://api.github.com/repos/enram/bird-migration-flow-visualization/milestones/21/labels","id":1155657,"number":21,"title":"Redo aggregation query","description":"","creator":{"login":"peterdesmet","id":600993,"avatar_url":"https://avatars.githubusercontent.com/u/600993?v=3","gravatar_id":"","url":"https://api.github.com/users/peterdesmet","html_url":"https://github.com/peterdesmet","followers_url":"https://api.github.com/users/peterdesmet/followers","following_url":"https://api.github.com/users/peterdesmet/following{/other_user}","gists_url":"https://api.github.com/users/peterdesmet/gists{/gist_id}","starred_url":"https://api.github.com/users/peterdesmet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/peterdesmet/subscriptions","organizations_url":"https://api.github.com/users/peterdesmet/orgs","repos_url":"https://api.github.com/users/peterdesmet/repos","events_url":"https://api.github.com/users/peterdesmet/events{/privacy}","received_events_url":"https://api.github.com/users/peterdesmet/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":0,"state":"open","created_at":"2015-06-08T19:58:51Z","updated_at":"2015-06-08T20:06:02Z","due_on":"2015-06-08T22:00:00Z","closed_at":null},"comments":1,"created_at":"2015-06-08T20:06:02Z","updated_at":"2015-06-08T20:06:29Z","closed_at":null,"body":"The conditions for v_speed and u_speed are currently:\r\n\r\n```SQL\r\n    CASE\r\n        WHEN avg(b.radial_velocity_std) >= 2 AND avg(b.bird_density) >= 10 THEN round(avg(b.u_speed)::numeric,5)\r\n        ELSE 0\r\n    END AS avg_u_speed,\r\n    CASE\r\n        WHEN avg(b.radial_velocity_std) >= 2 AND avg(b.bird_density) >= 10 THEN round(avg(b.v_speed)::numeric,5)\r\n        ELSE 0\r\n    END AS avg_v_speed,\r\n```\r\n\r\nBut those WHEN requirements should actually be stated per altitude and radar, not on the average.\r\n\r\n* [ ] Have requirements per radar\r\n* [ ] Have requirements per altitude in a specific altitude band\r\n* [ ] Sum speed from the altitudes that met requirements / divided by number of altitudes that met requirements (=> those not contributed are not affecting average)\r\n* [ ] If none of the altitudes meet the requirements: set to zero"},"comment":{"url":"https://api.github.com/repos/enram/bird-migration-flow-visualization/issues/comments/110122467","html_url":"https://github.com/enram/bird-migration-flow-visualization/issues/105#issuecomment-110122467","issue_url":"https://api.github.com/repos/enram/bird-migration-flow-visualization/issues/105","id":110122467,"user":{"login":"peterdesmet","id":600993,"avatar_url":"https://avatars.githubusercontent.com/u/600993?v=3","gravatar_id":"","url":"https://api.github.com/users/peterdesmet","html_url":"https://github.com/peterdesmet","followers_url":"https://api.github.com/users/peterdesmet/followers","following_url":"https://api.github.com/users/peterdesmet/following{/other_user}","gists_url":"https://api.github.com/users/peterdesmet/gists{/gist_id}","starred_url":"https://api.github.com/users/peterdesmet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/peterdesmet/subscriptions","organizations_url":"https://api.github.com/users/peterdesmet/orgs","repos_url":"https://api.github.com/users/peterdesmet/repos","events_url":"https://api.github.com/users/peterdesmet/events{/privacy}","received_events_url":"https://api.github.com/users/peterdesmet/received_events","type":"User","site_admin":false},"created_at":"2015-06-08T20:06:29Z","updated_at":"2015-06-08T20:06:29Z","body":"Should these updates be included in the current visualization?"}}