{"action":"created","issue":{"url":"https://api.github.com/repos/RDCEP/EDE/issues/22","repository_url":"https://api.github.com/repos/RDCEP/EDE","labels_url":"https://api.github.com/repos/RDCEP/EDE/issues/22/labels{/name}","comments_url":"https://api.github.com/repos/RDCEP/EDE/issues/22/comments","events_url":"https://api.github.com/repos/RDCEP/EDE/issues/22/events","html_url":"https://github.com/RDCEP/EDE/issues/22","id":139128369,"number":22,"title":"Aggregation methods, polygon tables","user":{"login":"njmattes","id":2439549,"avatar_url":"https://avatars.githubusercontent.com/u/2439549?v=3","gravatar_id":"","url":"https://api.github.com/users/njmattes","html_url":"https://github.com/njmattes","followers_url":"https://api.github.com/users/njmattes/followers","following_url":"https://api.github.com/users/njmattes/following{/other_user}","gists_url":"https://api.github.com/users/njmattes/gists{/gist_id}","starred_url":"https://api.github.com/users/njmattes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/njmattes/subscriptions","organizations_url":"https://api.github.com/users/njmattes/orgs","repos_url":"https://api.github.com/users/njmattes/repos","events_url":"https://api.github.com/users/njmattes/events{/privacy}","received_events_url":"https://api.github.com/users/njmattes/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"legendOfZelda","id":5909716,"avatar_url":"https://avatars.githubusercontent.com/u/5909716?v=3","gravatar_id":"","url":"https://api.github.com/users/legendOfZelda","html_url":"https://github.com/legendOfZelda","followers_url":"https://api.github.com/users/legendOfZelda/followers","following_url":"https://api.github.com/users/legendOfZelda/following{/other_user}","gists_url":"https://api.github.com/users/legendOfZelda/gists{/gist_id}","starred_url":"https://api.github.com/users/legendOfZelda/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/legendOfZelda/subscriptions","organizations_url":"https://api.github.com/users/legendOfZelda/orgs","repos_url":"https://api.github.com/users/legendOfZelda/repos","events_url":"https://api.github.com/users/legendOfZelda/events{/privacy}","received_events_url":"https://api.github.com/users/legendOfZelda/received_events","type":"User","site_admin":false},"milestone":null,"comments":8,"created_at":"2016-03-07T23:39:00Z","updated_at":"2016-03-30T03:04:34Z","closed_at":null,"body":"@ricardobarroslourenco Once we have a finalized procedure for returning a raster of values, we should finish at least one procedure for aggregating those to polygons. But we don't yet have polygons, I just realized. We need to sort out a way to store these ASAP (this is also mention in issue #9). @legendOfZelda Do you know if plenario has an ingestor for Shapefiles already in place?"},"comment":{"url":"https://api.github.com/repos/RDCEP/EDE/issues/comments/203221747","html_url":"https://github.com/RDCEP/EDE/issues/22#issuecomment-203221747","issue_url":"https://api.github.com/repos/RDCEP/EDE/issues/22","id":203221747,"user":{"login":"legendOfZelda","id":5909716,"avatar_url":"https://avatars.githubusercontent.com/u/5909716?v=3","gravatar_id":"","url":"https://api.github.com/users/legendOfZelda","html_url":"https://github.com/legendOfZelda","followers_url":"https://api.github.com/users/legendOfZelda/followers","following_url":"https://api.github.com/users/legendOfZelda/following{/other_user}","gists_url":"https://api.github.com/users/legendOfZelda/gists{/gist_id}","starred_url":"https://api.github.com/users/legendOfZelda/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/legendOfZelda/subscriptions","organizations_url":"https://api.github.com/users/legendOfZelda/orgs","repos_url":"https://api.github.com/users/legendOfZelda/repos","events_url":"https://api.github.com/users/legendOfZelda/events{/privacy}","received_events_url":"https://api.github.com/users/legendOfZelda/received_events","type":"User","site_admin":false},"created_at":"2016-03-30T03:04:34Z","updated_at":"2016-03-30T03:04:34Z","body":"how about this schema here?\r\n\r\n```\r\nCREATE TABLE regions_meta (\r\n    uid         bigserial primary key,\r\n    name        text,   # e.g. GADM, EEZ\r\n    version     text,   # for e.g. GADM: 1, 2.0, 2.7, 2.8 ;\r\n                        # for e.g. EEZ: 1, 2, 3, ..., 6, 6.1, 7, 8\r\n    attributes  text[]  # for e.g. GADM v2.8:   ID_0, NAME_0, VARNAME_0, TYPE_0, ...\r\n                        # for e.g. EEZ  v8:     ID, OBJECTID_1, EEZ, Country, Sovereign, Remarks, ...\r\n);\r\n\r\nCREATE TABLE regions (\r\n    uid         bigserial primary key,\r\n    geom        geometry,\r\n    meta_data   jsonb,  # key-value pairs with keys = attributes from regions_meta\r\n    meta_id     bigint references regions_meta(uid)\r\n);\r\n```\r\n\r\nto support `GADM`, `EEZ` (Exclusive Economic Zones Boundaries), and others, e.g. the ones mentioned in http://www.gadm.org/links"}}