{"action":"created","issue":{"url":"https://api.github.com/repos/kev007/2016-FMdIR-Thema1/issues/3","repository_url":"https://api.github.com/repos/kev007/2016-FMdIR-Thema1","labels_url":"https://api.github.com/repos/kev007/2016-FMdIR-Thema1/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/kev007/2016-FMdIR-Thema1/issues/3/comments","events_url":"https://api.github.com/repos/kev007/2016-FMdIR-Thema1/issues/3/events","html_url":"https://github.com/kev007/2016-FMdIR-Thema1/issues/3","id":184818120,"number":3,"title":"Put translations into the database","user":{"login":"kev007","id":3058438,"avatar_url":"https://avatars.githubusercontent.com/u/3058438?v=3","gravatar_id":"","url":"https://api.github.com/users/kev007","html_url":"https://github.com/kev007","followers_url":"https://api.github.com/users/kev007/followers","following_url":"https://api.github.com/users/kev007/following{/other_user}","gists_url":"https://api.github.com/users/kev007/gists{/gist_id}","starred_url":"https://api.github.com/users/kev007/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kev007/subscriptions","organizations_url":"https://api.github.com/users/kev007/orgs","repos_url":"https://api.github.com/users/kev007/repos","events_url":"https://api.github.com/users/kev007/events{/privacy}","received_events_url":"https://api.github.com/users/kev007/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"dobraczka","id":14311131,"avatar_url":"https://avatars.githubusercontent.com/u/14311131?v=3","gravatar_id":"","url":"https://api.github.com/users/dobraczka","html_url":"https://github.com/dobraczka","followers_url":"https://api.github.com/users/dobraczka/followers","following_url":"https://api.github.com/users/dobraczka/following{/other_user}","gists_url":"https://api.github.com/users/dobraczka/gists{/gist_id}","starred_url":"https://api.github.com/users/dobraczka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dobraczka/subscriptions","organizations_url":"https://api.github.com/users/dobraczka/orgs","repos_url":"https://api.github.com/users/dobraczka/repos","events_url":"https://api.github.com/users/dobraczka/events{/privacy}","received_events_url":"https://api.github.com/users/dobraczka/received_events","type":"User","site_admin":false},"assignees":[{"login":"dobraczka","id":14311131,"avatar_url":"https://avatars.githubusercontent.com/u/14311131?v=3","gravatar_id":"","url":"https://api.github.com/users/dobraczka","html_url":"https://github.com/dobraczka","followers_url":"https://api.github.com/users/dobraczka/followers","following_url":"https://api.github.com/users/dobraczka/following{/other_user}","gists_url":"https://api.github.com/users/dobraczka/gists{/gist_id}","starred_url":"https://api.github.com/users/dobraczka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dobraczka/subscriptions","organizations_url":"https://api.github.com/users/dobraczka/orgs","repos_url":"https://api.github.com/users/dobraczka/repos","events_url":"https://api.github.com/users/dobraczka/events{/privacy}","received_events_url":"https://api.github.com/users/dobraczka/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/kev007/2016-FMdIR-Thema1/milestones/1","html_url":"https://github.com/kev007/2016-FMdIR-Thema1/milestones/Database%20filled","labels_url":"https://api.github.com/repos/kev007/2016-FMdIR-Thema1/milestones/1/labels","id":2088847,"number":1,"title":"Database filled","description":"Meeting questions:\r\n- Corpora / Year filter? 2005-2009 / 2007 Corpora\r\n- Open Source / GitHub / GitLab\r\n\r\nFinished:\r\n- Filled Database\r\n- Translations\r\n","creator":{"login":"kev007","id":3058438,"avatar_url":"https://avatars.githubusercontent.com/u/3058438?v=3","gravatar_id":"","url":"https://api.github.com/users/kev007","html_url":"https://github.com/kev007","followers_url":"https://api.github.com/users/kev007/followers","following_url":"https://api.github.com/users/kev007/following{/other_user}","gists_url":"https://api.github.com/users/kev007/gists{/gist_id}","starred_url":"https://api.github.com/users/kev007/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kev007/subscriptions","organizations_url":"https://api.github.com/users/kev007/orgs","repos_url":"https://api.github.com/users/kev007/repos","events_url":"https://api.github.com/users/kev007/events{/privacy}","received_events_url":"https://api.github.com/users/kev007/received_events","type":"User","site_admin":false},"open_issues":2,"closed_issues":1,"state":"open","created_at":"2016-10-24T11:41:36Z","updated_at":"2016-10-25T16:29:47Z","due_on":"2016-11-14T00:00:00Z","closed_at":null},"comments":1,"created_at":"2016-10-24T11:44:25Z","updated_at":"2016-10-31T15:58:15Z","closed_at":null,"body":"- Country (in all languages)\n- Cities (in all languages)\n- ISO Code\n- ID\n"},"comment":{"url":"https://api.github.com/repos/kev007/2016-FMdIR-Thema1/issues/comments/257334435","html_url":"https://github.com/kev007/2016-FMdIR-Thema1/issues/3#issuecomment-257334435","issue_url":"https://api.github.com/repos/kev007/2016-FMdIR-Thema1/issues/3","id":257334435,"user":{"login":"dobraczka","id":14311131,"avatar_url":"https://avatars.githubusercontent.com/u/14311131?v=3","gravatar_id":"","url":"https://api.github.com/users/dobraczka","html_url":"https://github.com/dobraczka","followers_url":"https://api.github.com/users/dobraczka/followers","following_url":"https://api.github.com/users/dobraczka/following{/other_user}","gists_url":"https://api.github.com/users/dobraczka/gists{/gist_id}","starred_url":"https://api.github.com/users/dobraczka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dobraczka/subscriptions","organizations_url":"https://api.github.com/users/dobraczka/orgs","repos_url":"https://api.github.com/users/dobraczka/repos","events_url":"https://api.github.com/users/dobraczka/events{/privacy}","received_events_url":"https://api.github.com/users/dobraczka/received_events","type":"User","site_admin":false},"created_at":"2016-10-31T15:58:15Z","updated_at":"2016-10-31T15:58:15Z","body":"I've come up with a SPARQL query which gives back all cities over a certain population. Each city has a ID derived from dbo:wikiPageID. Also the rdfs:label of the city and the country it's located in is displayed in all languages that are available\r\nThe query is the following:\r\n```\r\nPREFIX dbo: <http://dbpedia.org/ontology/>\r\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\r\n\r\nselect ?id ?nameLabel ?countryLabel\r\nwhere {\r\n?resource rdfs:label ?nameLabel .\r\n?resource dbp:population ?population .\r\n?resource dbo:wikiPageID ?id .\r\n?resource dbo:country ?country .\r\n?country rdfs:label ?countryLabel .\r\n?resource dbo:location ?x\r\nFILTER (?population >= 1000000 )\r\n}\r\n```\r\n\r\nIt could also be possible to make two queries: one to get only the cities in all languages and the other for the countries in all languages, but I think this way it's better, because the cities are already linked with the correct country.\r\n\r\n(The query can be run [here](http://dbpedia.org/sparql))"}}
{"actor":{"display_login":"dobraczka"}}