{"action":"created","issue":{"url":"https://api.github.com/repos/geometalab/osm2vectortiles/issues/65","labels_url":"https://api.github.com/repos/geometalab/osm2vectortiles/issues/65/labels{/name}","comments_url":"https://api.github.com/repos/geometalab/osm2vectortiles/issues/65/comments","events_url":"https://api.github.com/repos/geometalab/osm2vectortiles/issues/65/events","html_url":"https://github.com/geometalab/osm2vectortiles/pull/65","id":115110370,"number":65,"title":"Feature/improve queries","user":{"login":"manuelroth","id":1810384,"avatar_url":"https://avatars.githubusercontent.com/u/1810384?v=3","gravatar_id":"","url":"https://api.github.com/users/manuelroth","html_url":"https://github.com/manuelroth","followers_url":"https://api.github.com/users/manuelroth/followers","following_url":"https://api.github.com/users/manuelroth/following{/other_user}","gists_url":"https://api.github.com/users/manuelroth/gists{/gist_id}","starred_url":"https://api.github.com/users/manuelroth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/manuelroth/subscriptions","organizations_url":"https://api.github.com/users/manuelroth/orgs","repos_url":"https://api.github.com/users/manuelroth/repos","events_url":"https://api.github.com/users/manuelroth/events{/privacy}","received_events_url":"https://api.github.com/users/manuelroth/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"lukasmartinelli","id":1288339,"avatar_url":"https://avatars.githubusercontent.com/u/1288339?v=3","gravatar_id":"","url":"https://api.github.com/users/lukasmartinelli","html_url":"https://github.com/lukasmartinelli","followers_url":"https://api.github.com/users/lukasmartinelli/followers","following_url":"https://api.github.com/users/lukasmartinelli/following{/other_user}","gists_url":"https://api.github.com/users/lukasmartinelli/gists{/gist_id}","starred_url":"https://api.github.com/users/lukasmartinelli/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lukasmartinelli/subscriptions","organizations_url":"https://api.github.com/users/lukasmartinelli/orgs","repos_url":"https://api.github.com/users/lukasmartinelli/repos","events_url":"https://api.github.com/users/lukasmartinelli/events{/privacy}","received_events_url":"https://api.github.com/users/lukasmartinelli/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2015-11-04T17:53:22Z","updated_at":"2015-11-04T19:03:53Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/geometalab/osm2vectortiles/pulls/65","html_url":"https://github.com/geometalab/osm2vectortiles/pull/65","diff_url":"https://github.com/geometalab/osm2vectortiles/pull/65.diff","patch_url":"https://github.com/geometalab/osm2vectortiles/pull/65.patch"},"body":"- Updated all layer with new imposm mapping and added international names to every label layer\r\n- Moved classification out of layers into sql functions\r\n- Improved mapping of some tables with missing types\r\n- Removed typebased generalizations in imposm mapping\r\n- Removed unused table amenities\r\n- Added new layer marine to source project\r\n- Changed all sql queries to uppercase style"},"comment":{"url":"https://api.github.com/repos/geometalab/osm2vectortiles/issues/comments/153831977","html_url":"https://github.com/geometalab/osm2vectortiles/pull/65#issuecomment-153831977","issue_url":"https://api.github.com/repos/geometalab/osm2vectortiles/issues/65","id":153831977,"user":{"login":"lukasmartinelli","id":1288339,"avatar_url":"https://avatars.githubusercontent.com/u/1288339?v=3","gravatar_id":"","url":"https://api.github.com/users/lukasmartinelli","html_url":"https://github.com/lukasmartinelli","followers_url":"https://api.github.com/users/lukasmartinelli/followers","following_url":"https://api.github.com/users/lukasmartinelli/following{/other_user}","gists_url":"https://api.github.com/users/lukasmartinelli/gists{/gist_id}","starred_url":"https://api.github.com/users/lukasmartinelli/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lukasmartinelli/subscriptions","organizations_url":"https://api.github.com/users/lukasmartinelli/orgs","repos_url":"https://api.github.com/users/lukasmartinelli/repos","events_url":"https://api.github.com/users/lukasmartinelli/events{/privacy}","received_events_url":"https://api.github.com/users/lukasmartinelli/received_events","type":"User","site_admin":false},"created_at":"2015-11-04T19:03:52Z","updated_at":"2015-11-04T19:03:52Z","body":"Improved some additional queries.\r\n\r\n> Not yet, but I added the additional mappings to the classify.yml file in the generate-sql branch. We can merge this tomorrow.\r\n\r\nYep, let's do this later.\r\n\r\n> I really enjoy these graphs. As the source project an mapping get more complex. It is nice to have an \r\noverview over what is mapped to what.\r\n\r\nIt has gotten out of control with all these layers and tables :grinning:  Difficult to fit it all into the head."}}