{"action":"created","issue":{"url":"https://api.github.com/repos/Data4Democracy/internal-displacement/issues/112","repository_url":"https://api.github.com/repos/Data4Democracy/internal-displacement","labels_url":"https://api.github.com/repos/Data4Democracy/internal-displacement/issues/112/labels{/name}","comments_url":"https://api.github.com/repos/Data4Democracy/internal-displacement/issues/112/comments","events_url":"https://api.github.com/repos/Data4Democracy/internal-displacement/issues/112/events","html_url":"https://github.com/Data4Democracy/internal-displacement/issues/112","id":214554282,"number":112,"title":"Modify Location Schema to be able to distinguish between cities and country sub-dvisions","user":{"login":"simonb83","id":1999243,"avatar_url":"https://avatars1.githubusercontent.com/u/1999243?v=3","gravatar_id":"","url":"https://api.github.com/users/simonb83","html_url":"https://github.com/simonb83","followers_url":"https://api.github.com/users/simonb83/followers","following_url":"https://api.github.com/users/simonb83/following{/other_user}","gists_url":"https://api.github.com/users/simonb83/gists{/gist_id}","starred_url":"https://api.github.com/users/simonb83/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/simonb83/subscriptions","organizations_url":"https://api.github.com/users/simonb83/orgs","repos_url":"https://api.github.com/users/simonb83/repos","events_url":"https://api.github.com/users/simonb83/events{/privacy}","received_events_url":"https://api.github.com/users/simonb83/received_events","type":"User","site_admin":false},"labels":[{"id":522793838,"url":"https://api.github.com/repos/Data4Democracy/internal-displacement/labels/beginner-friendly","name":"beginner-friendly","color":"0e8a16","default":false},{"id":542741577,"url":"https://api.github.com/repos/Data4Democracy/internal-displacement/labels/pipeline","name":"pipeline","color":"00d2ff","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2017-03-15T23:16:56Z","updated_at":"2017-03-25T23:23:07Z","closed_at":null,"body":"The extracted location could be either a Country, a country sub-division (i.e. province or state) or a City.\r\n\r\nWe need to modify the schema for `Location` class in `model.py` to ensure that we can capture these different options:\r\n\r\n````\r\nCREATE TABLE location ( id SERIAL PRIMARY KEY,    description TEXT,    city TEXT,  \r\nstate TEXT,  country CHAR(3) REFERENCES country ON DELETE CASCADE, latlong TEXT );\r\n````"},"comment":{"url":"https://api.github.com/repos/Data4Democracy/internal-displacement/issues/comments/289246539","html_url":"https://github.com/Data4Democracy/internal-displacement/issues/112#issuecomment-289246539","issue_url":"https://api.github.com/repos/Data4Democracy/internal-displacement/issues/112","id":289246539,"user":{"login":"frenski","id":188564,"avatar_url":"https://avatars1.githubusercontent.com/u/188564?v=3","gravatar_id":"","url":"https://api.github.com/users/frenski","html_url":"https://github.com/frenski","followers_url":"https://api.github.com/users/frenski/followers","following_url":"https://api.github.com/users/frenski/following{/other_user}","gists_url":"https://api.github.com/users/frenski/gists{/gist_id}","starred_url":"https://api.github.com/users/frenski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/frenski/subscriptions","organizations_url":"https://api.github.com/users/frenski/orgs","repos_url":"https://api.github.com/users/frenski/repos","events_url":"https://api.github.com/users/frenski/events{/privacy}","received_events_url":"https://api.github.com/users/frenski/received_events","type":"User","site_admin":false},"created_at":"2017-03-25T23:23:07Z","updated_at":"2017-03-25T23:23:07Z","body":"Btw, as we are currently changing the schema, why don't we split the latlong field it into two different ones (lat and lon) and keep them as double? It would be both easier and faster for the frontend and better performance-wise in general?"}}
{"actor":{"display_login":"frenski"}}