{"action":"created","issue":{"url":"https://api.github.com/repos/ctmil/geostats-eulac/issues/26","labels_url":"https://api.github.com/repos/ctmil/geostats-eulac/issues/26/labels{/name}","comments_url":"https://api.github.com/repos/ctmil/geostats-eulac/issues/26/comments","events_url":"https://api.github.com/repos/ctmil/geostats-eulac/issues/26/events","html_url":"https://github.com/ctmil/geostats-eulac/issues/26","id":103791393,"number":26,"title":"Reparar: Brasil aparece con 387834166 habitantes, debería aparecer 193917083.","user":{"login":"csrocha","id":2170163,"avatar_url":"https://avatars.githubusercontent.com/u/2170163?v=3","gravatar_id":"","url":"https://api.github.com/users/csrocha","html_url":"https://github.com/csrocha","followers_url":"https://api.github.com/users/csrocha/followers","following_url":"https://api.github.com/users/csrocha/following{/other_user}","gists_url":"https://api.github.com/users/csrocha/gists{/gist_id}","starred_url":"https://api.github.com/users/csrocha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/csrocha/subscriptions","organizations_url":"https://api.github.com/users/csrocha/orgs","repos_url":"https://api.github.com/users/csrocha/repos","events_url":"https://api.github.com/users/csrocha/events{/privacy}","received_events_url":"https://api.github.com/users/csrocha/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/ctmil/geostats-eulac/labels/bug","name":"bug","color":"fc2929"}],"state":"closed","locked":false,"assignee":{"login":"csrocha","id":2170163,"avatar_url":"https://avatars.githubusercontent.com/u/2170163?v=3","gravatar_id":"","url":"https://api.github.com/users/csrocha","html_url":"https://github.com/csrocha","followers_url":"https://api.github.com/users/csrocha/followers","following_url":"https://api.github.com/users/csrocha/following{/other_user}","gists_url":"https://api.github.com/users/csrocha/gists{/gist_id}","starred_url":"https://api.github.com/users/csrocha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/csrocha/subscriptions","organizations_url":"https://api.github.com/users/csrocha/orgs","repos_url":"https://api.github.com/users/csrocha/repos","events_url":"https://api.github.com/users/csrocha/events{/privacy}","received_events_url":"https://api.github.com/users/csrocha/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/ctmil/geostats-eulac/milestones/2","html_url":"https://github.com/ctmil/geostats-eulac/milestones/Final%20del%20Proyecto","labels_url":"https://api.github.com/repos/ctmil/geostats-eulac/milestones/2/labels","id":1278262,"number":2,"title":"Final del Proyecto","description":null,"creator":{"login":"csrocha","id":2170163,"avatar_url":"https://avatars.githubusercontent.com/u/2170163?v=3","gravatar_id":"","url":"https://api.github.com/users/csrocha","html_url":"https://github.com/csrocha","followers_url":"https://api.github.com/users/csrocha/followers","following_url":"https://api.github.com/users/csrocha/following{/other_user}","gists_url":"https://api.github.com/users/csrocha/gists{/gist_id}","starred_url":"https://api.github.com/users/csrocha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/csrocha/subscriptions","organizations_url":"https://api.github.com/users/csrocha/orgs","repos_url":"https://api.github.com/users/csrocha/repos","events_url":"https://api.github.com/users/csrocha/events{/privacy}","received_events_url":"https://api.github.com/users/csrocha/received_events","type":"User","site_admin":false},"open_issues":13,"closed_issues":12,"state":"open","created_at":"2015-08-28T20:31:39Z","updated_at":"2015-08-31T21:56:46Z","due_on":null,"closed_at":null},"comments":4,"created_at":"2015-08-28T20:34:11Z","updated_at":"2015-08-31T23:59:10Z","closed_at":"2015-08-31T21:56:46Z","body":""},"comment":{"url":"https://api.github.com/repos/ctmil/geostats-eulac/issues/comments/136530980","html_url":"https://github.com/ctmil/geostats-eulac/issues/26#issuecomment-136530980","issue_url":"https://api.github.com/repos/ctmil/geostats-eulac/issues/26","id":136530980,"user":{"login":"csrocha","id":2170163,"avatar_url":"https://avatars.githubusercontent.com/u/2170163?v=3","gravatar_id":"","url":"https://api.github.com/users/csrocha","html_url":"https://github.com/csrocha","followers_url":"https://api.github.com/users/csrocha/followers","following_url":"https://api.github.com/users/csrocha/following{/other_user}","gists_url":"https://api.github.com/users/csrocha/gists{/gist_id}","starred_url":"https://api.github.com/users/csrocha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/csrocha/subscriptions","organizations_url":"https://api.github.com/users/csrocha/orgs","repos_url":"https://api.github.com/users/csrocha/repos","events_url":"https://api.github.com/users/csrocha/events{/privacy}","received_events_url":"https://api.github.com/users/csrocha/received_events","type":"User","site_admin":false},"created_at":"2015-08-31T23:59:10Z","updated_at":"2015-08-31T23:59:10Z","body":"CREATE TABLE IF NOT EXISTS shape_sample AS\r\nSELECT max(SA.\"pob\") \"pob\",\r\nmax(SA.\"loc10.11\") \"loc10.11\",\r\nmax(SA.\"loc12\") \"loc12\",\r\nmax(SA.\"loc13\") \"loc13\",\r\nmax(SA.\"loc14\") \"loc14\",\r\nmax(SA.\"loc15\") \"loc15\",\r\nmax(SA.\"loc16\") \"loc16\",\r\nmax(SA.\"loc17\") \"loc17\",\r\nmax(SA.\"loc18\") \"loc18\",\r\nmax(SA.\"loc19\") \"loc19\",\r\nmax(SA.\"loc20.21\") \"loc20.21\",\r\nmax(SA.\"loc22\") \"loc22\",\r\nmax(SA.\"loc23\") \"loc23\",\r\nmax(SA.\"loc24\") \"loc24\",\r\nmax(SA.\"loc25\") \"loc25\",\r\nmax(SA.\"loc26\") \"loc26\",\r\nmax(SA.\"loc27\") \"loc27\",\r\nmax(SA.\"loc28.33\") \"loc28.33\",\r\nmax(SA.\"loc29\") \"loc29\",\r\nmax(SA.\"loc30\") \"loc30\",\r\nmax(SA.\"loc31.32\") \"loc31.32\",\r\nmax(SA.\"loc38\") \"loc38\",\r\nmax(SA.\"loc\") \"loc\",\r\nmax(SA.\"ocu10.11\") \"ocu10.11\",\r\nmax(SA.\"ocu12\") \"ocu12\",\r\nmax(SA.\"ocu13\") \"ocu13\",\r\nmax(SA.\"ocu14\") \"ocu14\",\r\nmax(SA.\"ocu15\") \"ocu15\",\r\nmax(SA.\"ocu16\") \"ocu16\",\r\nmax(SA.\"ocu17\") \"ocu17\",\r\nmax(SA.\"ocu18\") \"ocu18\",\r\nmax(SA.\"ocu19\") \"ocu19\",\r\nmax(SA.\"ocu20.21\") \"ocu20.21\",\r\nmax(SA.\"ocu22\") \"ocu22\",\r\nmax(SA.\"ocu23\") \"ocu23\",\r\nmax(SA.\"ocu24\") \"ocu24\",\r\nmax(SA.\"ocu25\") \"ocu25\", \r\nmax(SA.\"ocu26\") \"ocu26\",\r\nmax(SA.\"ocu27\") \"ocu27\",\r\nmax(SA.\"ocu28.33\") \"ocu28.33\",\r\nmax(SA.\"ocu29\") \"ocu29\",\r\nmax(SA.\"ocu30\") \"ocu30\",\r\nmax(SA.\"ocu31.32\") \"ocu31.32\",\r\nmax(SA.\"ocu38\") \"ocu38\",\r\nmax(SA.\"ocu\") \"ocu\",\r\nSH.shp_id,\r\nSH.code,\r\nTE.age,\r\nTE.t\r\nFROM sample SA LEFT JOIN shape SH ON (SA.shp_id = SH.shp_id) LEFT JOIN temporal TE ON (TE.code = SH.code AND TE.age=SA.age)\r\nGROUP BY SH.shp_id, SH.code, TE.age, TE.t;"}}