{"action":"opened","issue":{"url":"https://api.github.com/repos/geometalab/osm2vectortiles/issues/64","labels_url":"https://api.github.com/repos/geometalab/osm2vectortiles/issues/64/labels{/name}","comments_url":"https://api.github.com/repos/geometalab/osm2vectortiles/issues/64/comments","events_url":"https://api.github.com/repos/geometalab/osm2vectortiles/issues/64/events","html_url":"https://github.com/geometalab/osm2vectortiles/issues/64","id":115049608,"number":64,"title":"Improved 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":null,"milestone":{"url":"https://api.github.com/repos/geometalab/osm2vectortiles/milestones/4","html_url":"https://github.com/geometalab/osm2vectortiles/milestones/BETA","labels_url":"https://api.github.com/repos/geometalab/osm2vectortiles/milestones/4/labels","id":1293507,"number":4,"title":"BETA","description":"","creator":{"login":"klokan","id":59284,"avatar_url":"https://avatars.githubusercontent.com/u/59284?v=3","gravatar_id":"","url":"https://api.github.com/users/klokan","html_url":"https://github.com/klokan","followers_url":"https://api.github.com/users/klokan/followers","following_url":"https://api.github.com/users/klokan/following{/other_user}","gists_url":"https://api.github.com/users/klokan/gists{/gist_id}","starred_url":"https://api.github.com/users/klokan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/klokan/subscriptions","organizations_url":"https://api.github.com/users/klokan/orgs","repos_url":"https://api.github.com/users/klokan/repos","events_url":"https://api.github.com/users/klokan/events{/privacy}","received_events_url":"https://api.github.com/users/klokan/received_events","type":"User","site_admin":false},"open_issues":13,"closed_issues":14,"state":"open","created_at":"2015-09-07T10:57:44Z","updated_at":"2015-11-04T13:14:41Z","due_on":"2015-11-08T23:00:00Z","closed_at":null},"comments":0,"created_at":"2015-11-04T13:14:41Z","updated_at":"2015-11-04T13:14:41Z","closed_at":null,"body":"@lukasmartinelli We have right now some generalized tables which are based on a type filters in the imposm mapping. \r\n```sql\r\nwater_lines_gen0:\r\n    source: water_lines\r\n    tolerance: 0.0\r\n    sql_filter: type IN ('river', 'canal')\r\n```\r\nThis is not a very good idea, as we do the filtering per type on other layers in the queries not in the imposm mapping. Let's decide that we use, generalized tables only for real generalizations based on the area of the polygon.\r\nLike this:\r\n```sql\r\n water_polygons_gen1:\r\n    source: water_polygons\r\n    sql_filter: ST_Area(geometry)>50000.000000\r\n    tolerance: 50.0\r\n```"}}