{"action":"created","comment":{"url":"https://api.github.com/repos/mapzen/vector-datasource/pulls/comments/40055684","id":40055684,"diff_hunk":"@@ -29,19 +48,27 @@ WHERE\n UNION ALL\n \n SELECT\n-    name,\n-    {{ ne_landuse_cols('park or protected land') }}\n+  name,\n+  operator,\n+  way_area::bigint AS area,\n+  COALESCE(\"boundary\", \"landuse\", \"leisure\", \"natural\", \"highway\", \"aeroway\", \"amenity\", \"tourism\", \"man_made\", \"power\") AS kind,","path":"queries/landuse.jinja2","position":45,"original_position":45,"commit_id":"6caafa2b611573027a032f0388669fbb61f4cae9","original_commit_id":"6caafa2b611573027a032f0388669fbb61f4cae9","user":{"login":"nvkelso","id":853051,"avatar_url":"https://avatars.githubusercontent.com/u/853051?v=3","gravatar_id":"","url":"https://api.github.com/users/nvkelso","html_url":"https://github.com/nvkelso","followers_url":"https://api.github.com/users/nvkelso/followers","following_url":"https://api.github.com/users/nvkelso/following{/other_user}","gists_url":"https://api.github.com/users/nvkelso/gists{/gist_id}","starred_url":"https://api.github.com/users/nvkelso/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nvkelso/subscriptions","organizations_url":"https://api.github.com/users/nvkelso/orgs","repos_url":"https://api.github.com/users/nvkelso/repos","events_url":"https://api.github.com/users/nvkelso/events{/privacy}","received_events_url":"https://api.github.com/users/nvkelso/received_events","type":"User","site_admin":false},"body":"Seems like we should follow `#1` as it has the least impact on other code.","created_at":"2015-09-22T06:21:05Z","updated_at":"2015-09-22T06:21:05Z","html_url":"https://github.com/mapzen/vector-datasource/pull/227#discussion_r40055684","pull_request_url":"https://api.github.com/repos/mapzen/vector-datasource/pulls/227","_links":{"self":{"href":"https://api.github.com/repos/mapzen/vector-datasource/pulls/comments/40055684"},"html":{"href":"https://github.com/mapzen/vector-datasource/pull/227#discussion_r40055684"},"pull_request":{"href":"https://api.github.com/repos/mapzen/vector-datasource/pulls/227"}}},"pull_request":{"url":"https://api.github.com/repos/mapzen/vector-datasource/pulls/227","id":45589109,"html_url":"https://github.com/mapzen/vector-datasource/pull/227","diff_url":"https://github.com/mapzen/vector-datasource/pull/227.diff","patch_url":"https://github.com/mapzen/vector-datasource/pull/227.patch","issue_url":"https://api.github.com/repos/mapzen/vector-datasource/issues/227","number":227,"state":"open","locked":false,"title":"Added OSM-based national park polygons at zooms 4-8.","user":{"login":"zerebubuth","id":271360,"avatar_url":"https://avatars.githubusercontent.com/u/271360?v=3","gravatar_id":"","url":"https://api.github.com/users/zerebubuth","html_url":"https://github.com/zerebubuth","followers_url":"https://api.github.com/users/zerebubuth/followers","following_url":"https://api.github.com/users/zerebubuth/following{/other_user}","gists_url":"https://api.github.com/users/zerebubuth/gists{/gist_id}","starred_url":"https://api.github.com/users/zerebubuth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zerebubuth/subscriptions","organizations_url":"https://api.github.com/users/zerebubuth/orgs","repos_url":"https://api.github.com/users/zerebubuth/repos","events_url":"https://api.github.com/users/zerebubuth/events{/privacy}","received_events_url":"https://api.github.com/users/zerebubuth/received_events","type":"User","site_admin":false},"body":"This adds those polygons, removing the NE ones which were in some of the queries. The new polygons merge in the `boundary` attribute and update the `mz_calculate_is_landuse` function to treat national park polygons as a type of landuse.\r\n\r\nIt also exposes an attribute for the OSM `operator` tag, which can be used to distinguish US National Parks Service areas from those run by the US Forestry Service.\r\n\r\nRefs #149.\r\n\r\nBefore, zooms 4-6:\r\n\r\n![149-before-z4](https://cloud.githubusercontent.com/assets/271360/10002482/4754ddae-609f-11e5-9c4c-5f640ad646a8.png)\r\n\r\n![149-before-z5](https://cloud.githubusercontent.com/assets/271360/10002484/49fdbb34-609f-11e5-8f5a-c0068b2fa83e.png)\r\n\r\n![149-before-z6](https://cloud.githubusercontent.com/assets/271360/10002487/4e2f9fe2-609f-11e5-9570-d52c07f422c7.png)\r\n\r\nAfter:\r\n\r\n![149-after-z4](https://cloud.githubusercontent.com/assets/271360/10002491/547b6980-609f-11e5-8043-dc322c8b4075.png)\r\n\r\n![149-after-z5](https://cloud.githubusercontent.com/assets/271360/10002495/57c690b0-609f-11e5-9978-7202d587b396.png)\r\n\r\n![149-after-z6](https://cloud.githubusercontent.com/assets/271360/10002497/5a7ee000-609f-11e5-81b1-c6c87f535ee7.png)\r\n\r\nWith the following snippet of `scene.yaml`:\r\n\r\n```yaml\r\n    landuse:\r\n        data: { source: osm }\r\n        draw:\r\n            polygons:\r\n                order: 1\r\n                color: '#aaaaa0'\r\n        urban:\r\n          filter: { kind: urban area }\r\n          draw:\r\n            polygons:\r\n              order: 2\r\n              color: '#808080'\r\n\r\n        park or protected land:\r\n          filter: { kind: national_park }\r\n          draw:\r\n            polygons:\r\n              order: 2\r\n              color: '#80aa80'\r\n\r\n          national_forest:\r\n            filter: { operator: [United States Forest Service, US Forest Service, National \\\r\nForest Service] }\r\n            draw: { polygons: { color: '#609060' } }\r\n\r\n          national_park:\r\n            filter: { operator: [United States National Park Service, United States Park Se\\\r\nrvice, US National Park Service, National Park Service] }\r\n            draw: { polygons: { color: '#50a060' } }\r\n```","created_at":"2015-09-21T19:29:19Z","updated_at":"2015-09-22T06:21:05Z","closed_at":null,"merged_at":null,"merge_commit_sha":null,"assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/mapzen/vector-datasource/pulls/227/commits","review_comments_url":"https://api.github.com/repos/mapzen/vector-datasource/pulls/227/comments","review_comment_url":"https://api.github.com/repos/mapzen/vector-datasource/pulls/comments{/number}","comments_url":"https://api.github.com/repos/mapzen/vector-datasource/issues/227/comments","statuses_url":"https://api.github.com/repos/mapzen/vector-datasource/statuses/6caafa2b611573027a032f0388669fbb61f4cae9","head":{"label":"mapzen:149-include-national-parks-earlier","ref":"149-include-national-parks-earlier","sha":"6caafa2b611573027a032f0388669fbb61f4cae9","user":{"login":"mapzen","id":5435747,"avatar_url":"https://avatars.githubusercontent.com/u/5435747?v=3","gravatar_id":"","url":"https://api.github.com/users/mapzen","html_url":"https://github.com/mapzen","followers_url":"https://api.github.com/users/mapzen/followers","following_url":"https://api.github.com/users/mapzen/following{/other_user}","gists_url":"https://api.github.com/users/mapzen/gists{/gist_id}","starred_url":"https://api.github.com/users/mapzen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mapzen/subscriptions","organizations_url":"https://api.github.com/users/mapzen/orgs","repos_url":"https://api.github.com/users/mapzen/repos","events_url":"https://api.github.com/users/mapzen/events{/privacy}","received_events_url":"https://api.github.com/users/mapzen/received_events","type":"Organization","site_admin":false},"repo":{"id":13446739,"name":"vector-datasource","full_name":"mapzen/vector-datasource","owner":{"login":"mapzen","id":5435747,"avatar_url":"https://avatars.githubusercontent.com/u/5435747?v=3","gravatar_id":"","url":"https://api.github.com/users/mapzen","html_url":"https://github.com/mapzen","followers_url":"https://api.github.com/users/mapzen/followers","following_url":"https://api.github.com/users/mapzen/following{/other_user}","gists_url":"https://api.github.com/users/mapzen/gists{/gist_id}","starred_url":"https://api.github.com/users/mapzen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mapzen/subscriptions","organizations_url":"https://api.github.com/users/mapzen/orgs","repos_url":"https://api.github.com/users/mapzen/repos","events_url":"https://api.github.com/users/mapzen/events{/privacy}","received_events_url":"https://api.github.com/users/mapzen/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/mapzen/vector-datasource","description":"Mapzen vector tile service - OpenStreetMap vector tiles in several formats","fork":false,"url":"https://api.github.com/repos/mapzen/vector-datasource","forks_url":"https://api.github.com/repos/mapzen/vector-datasource/forks","keys_url":"https://api.github.com/repos/mapzen/vector-datasource/keys{/key_id}","collaborators_url":"https://api.github.com/repos/mapzen/vector-datasource/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/mapzen/vector-datasource/teams","hooks_url":"https://api.github.com/repos/mapzen/vector-datasource/hooks","issue_events_url":"https://api.github.com/repos/mapzen/vector-datasource/issues/events{/number}","events_url":"https://api.github.com/repos/mapzen/vector-datasource/events","assignees_url":"https://api.github.com/repos/mapzen/vector-datasource/assignees{/user}","branches_url":"https://api.github.com/repos/mapzen/vector-datasource/branches{/branch}","tags_url":"https://api.github.com/repos/mapzen/vector-datasource/tags","blobs_url":"https://api.github.com/repos/mapzen/vector-datasource/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/mapzen/vector-datasource/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/mapzen/vector-datasource/git/refs{/sha}","trees_url":"https://api.github.com/repos/mapzen/vector-datasource/git/trees{/sha}","statuses_url":"https://api.github.com/repos/mapzen/vector-datasource/statuses/{sha}","languages_url":"https://api.github.com/repos/mapzen/vector-datasource/languages","stargazers_url":"https://api.github.com/repos/mapzen/vector-datasource/stargazers","contributors_url":"https://api.github.com/repos/mapzen/vector-datasource/contributors","subscribers_url":"https://api.github.com/repos/mapzen/vector-datasource/subscribers","subscription_url":"https://api.github.com/repos/mapzen/vector-datasource/subscription","commits_url":"https://api.github.com/repos/mapzen/vector-datasource/commits{/sha}","git_commits_url":"https://api.github.com/repos/mapzen/vector-datasource/git/commits{/sha}","comments_url":"https://api.github.com/repos/mapzen/vector-datasource/comments{/number}","issue_comment_url":"https://api.github.com/repos/mapzen/vector-datasource/issues/comments{/number}","contents_url":"https://api.github.com/repos/mapzen/vector-datasource/contents/{+path}","compare_url":"https://api.github.com/repos/mapzen/vector-datasource/compare/{base}...{head}","merges_url":"https://api.github.com/repos/mapzen/vector-datasource/merges","archive_url":"https://api.github.com/repos/mapzen/vector-datasource/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/mapzen/vector-datasource/downloads","issues_url":"https://api.github.com/repos/mapzen/vector-datasource/issues{/number}","pulls_url":"https://api.github.com/repos/mapzen/vector-datasource/pulls{/number}","milestones_url":"https://api.github.com/repos/mapzen/vector-datasource/milestones{/number}","notifications_url":"https://api.github.com/repos/mapzen/vector-datasource/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/mapzen/vector-datasource/labels{/name}","releases_url":"https://api.github.com/repos/mapzen/vector-datasource/releases{/id}","created_at":"2013-10-09T15:54:45Z","updated_at":"2015-09-21T14:38:15Z","pushed_at":"2015-09-21T19:29:20Z","git_url":"git://github.com/mapzen/vector-datasource.git","ssh_url":"git@github.com:mapzen/vector-datasource.git","clone_url":"https://github.com/mapzen/vector-datasource.git","svn_url":"https://github.com/mapzen/vector-datasource","homepage":"http://mapzen.com/vector","size":75278,"stargazers_count":160,"watchers_count":160,"language":"PLpgSQL","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":38,"mirror_url":null,"open_issues_count":47,"forks":38,"open_issues":47,"watchers":160,"default_branch":"master"}},"base":{"label":"mapzen:master","ref":"master","sha":"be6a71a98e7d527fcb1b40ffc14f4c6c259c4084","user":{"login":"mapzen","id":5435747,"avatar_url":"https://avatars.githubusercontent.com/u/5435747?v=3","gravatar_id":"","url":"https://api.github.com/users/mapzen","html_url":"https://github.com/mapzen","followers_url":"https://api.github.com/users/mapzen/followers","following_url":"https://api.github.com/users/mapzen/following{/other_user}","gists_url":"https://api.github.com/users/mapzen/gists{/gist_id}","starred_url":"https://api.github.com/users/mapzen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mapzen/subscriptions","organizations_url":"https://api.github.com/users/mapzen/orgs","repos_url":"https://api.github.com/users/mapzen/repos","events_url":"https://api.github.com/users/mapzen/events{/privacy}","received_events_url":"https://api.github.com/users/mapzen/received_events","type":"Organization","site_admin":false},"repo":{"id":13446739,"name":"vector-datasource","full_name":"mapzen/vector-datasource","owner":{"login":"mapzen","id":5435747,"avatar_url":"https://avatars.githubusercontent.com/u/5435747?v=3","gravatar_id":"","url":"https://api.github.com/users/mapzen","html_url":"https://github.com/mapzen","followers_url":"https://api.github.com/users/mapzen/followers","following_url":"https://api.github.com/users/mapzen/following{/other_user}","gists_url":"https://api.github.com/users/mapzen/gists{/gist_id}","starred_url":"https://api.github.com/users/mapzen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mapzen/subscriptions","organizations_url":"https://api.github.com/users/mapzen/orgs","repos_url":"https://api.github.com/users/mapzen/repos","events_url":"https://api.github.com/users/mapzen/events{/privacy}","received_events_url":"https://api.github.com/users/mapzen/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/mapzen/vector-datasource","description":"Mapzen vector tile service - OpenStreetMap vector tiles in several formats","fork":false,"url":"https://api.github.com/repos/mapzen/vector-datasource","forks_url":"https://api.github.com/repos/mapzen/vector-datasource/forks","keys_url":"https://api.github.com/repos/mapzen/vector-datasource/keys{/key_id}","collaborators_url":"https://api.github.com/repos/mapzen/vector-datasource/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/mapzen/vector-datasource/teams","hooks_url":"https://api.github.com/repos/mapzen/vector-datasource/hooks","issue_events_url":"https://api.github.com/repos/mapzen/vector-datasource/issues/events{/number}","events_url":"https://api.github.com/repos/mapzen/vector-datasource/events","assignees_url":"https://api.github.com/repos/mapzen/vector-datasource/assignees{/user}","branches_url":"https://api.github.com/repos/mapzen/vector-datasource/branches{/branch}","tags_url":"https://api.github.com/repos/mapzen/vector-datasource/tags","blobs_url":"https://api.github.com/repos/mapzen/vector-datasource/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/mapzen/vector-datasource/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/mapzen/vector-datasource/git/refs{/sha}","trees_url":"https://api.github.com/repos/mapzen/vector-datasource/git/trees{/sha}","statuses_url":"https://api.github.com/repos/mapzen/vector-datasource/statuses/{sha}","languages_url":"https://api.github.com/repos/mapzen/vector-datasource/languages","stargazers_url":"https://api.github.com/repos/mapzen/vector-datasource/stargazers","contributors_url":"https://api.github.com/repos/mapzen/vector-datasource/contributors","subscribers_url":"https://api.github.com/repos/mapzen/vector-datasource/subscribers","subscription_url":"https://api.github.com/repos/mapzen/vector-datasource/subscription","commits_url":"https://api.github.com/repos/mapzen/vector-datasource/commits{/sha}","git_commits_url":"https://api.github.com/repos/mapzen/vector-datasource/git/commits{/sha}","comments_url":"https://api.github.com/repos/mapzen/vector-datasource/comments{/number}","issue_comment_url":"https://api.github.com/repos/mapzen/vector-datasource/issues/comments{/number}","contents_url":"https://api.github.com/repos/mapzen/vector-datasource/contents/{+path}","compare_url":"https://api.github.com/repos/mapzen/vector-datasource/compare/{base}...{head}","merges_url":"https://api.github.com/repos/mapzen/vector-datasource/merges","archive_url":"https://api.github.com/repos/mapzen/vector-datasource/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/mapzen/vector-datasource/downloads","issues_url":"https://api.github.com/repos/mapzen/vector-datasource/issues{/number}","pulls_url":"https://api.github.com/repos/mapzen/vector-datasource/pulls{/number}","milestones_url":"https://api.github.com/repos/mapzen/vector-datasource/milestones{/number}","notifications_url":"https://api.github.com/repos/mapzen/vector-datasource/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/mapzen/vector-datasource/labels{/name}","releases_url":"https://api.github.com/repos/mapzen/vector-datasource/releases{/id}","created_at":"2013-10-09T15:54:45Z","updated_at":"2015-09-21T14:38:15Z","pushed_at":"2015-09-21T19:29:20Z","git_url":"git://github.com/mapzen/vector-datasource.git","ssh_url":"git@github.com:mapzen/vector-datasource.git","clone_url":"https://github.com/mapzen/vector-datasource.git","svn_url":"https://github.com/mapzen/vector-datasource","homepage":"http://mapzen.com/vector","size":75278,"stargazers_count":160,"watchers_count":160,"language":"PLpgSQL","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":38,"mirror_url":null,"open_issues_count":47,"forks":38,"open_issues":47,"watchers":160,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/mapzen/vector-datasource/pulls/227"},"html":{"href":"https://github.com/mapzen/vector-datasource/pull/227"},"issue":{"href":"https://api.github.com/repos/mapzen/vector-datasource/issues/227"},"comments":{"href":"https://api.github.com/repos/mapzen/vector-datasource/issues/227/comments"},"review_comments":{"href":"https://api.github.com/repos/mapzen/vector-datasource/pulls/227/comments"},"review_comment":{"href":"https://api.github.com/repos/mapzen/vector-datasource/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/mapzen/vector-datasource/pulls/227/commits"},"statuses":{"href":"https://api.github.com/repos/mapzen/vector-datasource/statuses/6caafa2b611573027a032f0388669fbb61f4cae9"}}}}