{"action":"created","comment":{"url":"https://api.github.com/repos/GitHubRGI/swagd/pulls/comments/29939395","id":29939395,"diff_hunk":"@@ -1479,6 +1385,217 @@ public void Requirement55() throws AssertionError, SQLException\n         }\n     }\n \n+    /**\n+     * Reference 2.2.6.1.1 Table 8. TileMatrix Set Table or View Definition para. 1\n+     * <blockquote>\n+     * The gpkg_tile_matrix_set table or updateable view defines the minimum bounding box (<code>min_x, min_y, max_x, max_y</code>)\n+     * and spatial reference system (<code>srs_id</code>) for all content in a tile pyramid user data table.\n+     * </blockquote>\n+     *\n+     * @throws AssertionError throws if the GeoPackage fails to meet the requirement\n+     * @throws SQLException throws if an SQLException occurs\n+     */\n+    @Requirement (reference = \"Reference 2.2.6.1.1 Table 8.\",\n+                  text      = \"The gpkg_tile_matrix_set table or updateable view defines the minimum bounding box (min_x, min_y, max_x, max_y)\"\n+                               +\" and spatial reference system (srs_id) for all content in a tile pyramid user data table. \")\n+    public void reference22611Table8() throws SQLException, AssertionError\n+    {\n+        if(this.hasTileMatrixTable)\n+        {\n+            for(final String pyramidTable: this.allPyramidUserDataTables)\n+            {\n+\n+                String tileRowMaxQuery = String.format(\"SELECT matrix_height as height, \" +\n+                                                              \"zoom_level as zoom, \"      +","path":"GeoPackage/src/com/rgi/geopackage/tiles/TilesVerifier.java","position":648,"original_position":648,"commit_id":"5e2dcb644f71f2d42616e4f6bfa449f1542a18c7","original_commit_id":"5e2dcb644f71f2d42616e4f6bfa449f1542a18c7","user":{"login":"LLambertRGi","id":5478360,"avatar_url":"https://avatars.githubusercontent.com/u/5478360?v=3","gravatar_id":"","url":"https://api.github.com/users/LLambertRGi","html_url":"https://github.com/LLambertRGi","followers_url":"https://api.github.com/users/LLambertRGi/followers","following_url":"https://api.github.com/users/LLambertRGi/following{/other_user}","gists_url":"https://api.github.com/users/LLambertRGi/gists{/gist_id}","starred_url":"https://api.github.com/users/LLambertRGi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/LLambertRGi/subscriptions","organizations_url":"https://api.github.com/users/LLambertRGi/orgs","repos_url":"https://api.github.com/users/LLambertRGi/repos","events_url":"https://api.github.com/users/LLambertRGi/events{/privacy}","received_events_url":"https://api.github.com/users/LLambertRGi/received_events","type":"User","site_admin":false},"body":"Shouldn't this only be for the lowest (numeric) zoom level?","created_at":"2015-05-08T13:33:05Z","updated_at":"2015-05-08T13:33:05Z","html_url":"https://github.com/GitHubRGI/swagd/pull/215#discussion_r29939395","pull_request_url":"https://api.github.com/repos/GitHubRGI/swagd/pulls/215","_links":{"self":{"href":"https://api.github.com/repos/GitHubRGI/swagd/pulls/comments/29939395"},"html":{"href":"https://github.com/GitHubRGI/swagd/pull/215#discussion_r29939395"},"pull_request":{"href":"https://api.github.com/repos/GitHubRGI/swagd/pulls/215"}}},"pull_request":{"url":"https://api.github.com/repos/GitHubRGI/swagd/pulls/215","id":34930587,"html_url":"https://github.com/GitHubRGI/swagd/pull/215","diff_url":"https://github.com/GitHubRGI/swagd/pull/215.diff","patch_url":"https://github.com/GitHubRGI/swagd/pull/215.patch","issue_url":"https://api.github.com/repos/GitHubRGI/swagd/issues/215","number":215,"state":"open","locked":false,"title":"Updating geopackage to ogc spec 1 0 1","user":{"login":"Jal3k5","id":8645492,"avatar_url":"https://avatars.githubusercontent.com/u/8645492?v=3","gravatar_id":"","url":"https://api.github.com/users/Jal3k5","html_url":"https://github.com/Jal3k5","followers_url":"https://api.github.com/users/Jal3k5/followers","following_url":"https://api.github.com/users/Jal3k5/following{/other_user}","gists_url":"https://api.github.com/users/Jal3k5/gists{/gist_id}","starred_url":"https://api.github.com/users/Jal3k5/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Jal3k5/subscriptions","organizations_url":"https://api.github.com/users/Jal3k5/orgs","repos_url":"https://api.github.com/users/Jal3k5/repos","events_url":"https://api.github.com/users/Jal3k5/events{/privacy}","received_events_url":"https://api.github.com/users/Jal3k5/received_events","type":"User","site_admin":false},"body":null,"created_at":"2015-05-07T15:57:25Z","updated_at":"2015-05-08T13:33:05Z","closed_at":null,"merged_at":null,"merge_commit_sha":"701f990b034d67ca18c94602cbb428457126c90c","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/GitHubRGI/swagd/pulls/215/commits","review_comments_url":"https://api.github.com/repos/GitHubRGI/swagd/pulls/215/comments","review_comment_url":"https://api.github.com/repos/GitHubRGI/swagd/pulls/comments{/number}","comments_url":"https://api.github.com/repos/GitHubRGI/swagd/issues/215/comments","statuses_url":"https://api.github.com/repos/GitHubRGI/swagd/statuses/5e2dcb644f71f2d42616e4f6bfa449f1542a18c7","head":{"label":"GitHubRGI:Updating-GeoPackage-to-OGC-spec-1.0.1","ref":"Updating-GeoPackage-to-OGC-spec-1.0.1","sha":"5e2dcb644f71f2d42616e4f6bfa449f1542a18c7","user":{"login":"GitHubRGI","id":532280,"avatar_url":"https://avatars.githubusercontent.com/u/532280?v=3","gravatar_id":"","url":"https://api.github.com/users/GitHubRGI","html_url":"https://github.com/GitHubRGI","followers_url":"https://api.github.com/users/GitHubRGI/followers","following_url":"https://api.github.com/users/GitHubRGI/following{/other_user}","gists_url":"https://api.github.com/users/GitHubRGI/gists{/gist_id}","starred_url":"https://api.github.com/users/GitHubRGI/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GitHubRGI/subscriptions","organizations_url":"https://api.github.com/users/GitHubRGI/orgs","repos_url":"https://api.github.com/users/GitHubRGI/repos","events_url":"https://api.github.com/users/GitHubRGI/events{/privacy}","received_events_url":"https://api.github.com/users/GitHubRGI/received_events","type":"Organization","site_admin":false},"repo":{"id":27885801,"name":"swagd","full_name":"GitHubRGI/swagd","owner":{"login":"GitHubRGI","id":532280,"avatar_url":"https://avatars.githubusercontent.com/u/532280?v=3","gravatar_id":"","url":"https://api.github.com/users/GitHubRGI","html_url":"https://github.com/GitHubRGI","followers_url":"https://api.github.com/users/GitHubRGI/followers","following_url":"https://api.github.com/users/GitHubRGI/following{/other_user}","gists_url":"https://api.github.com/users/GitHubRGI/gists{/gist_id}","starred_url":"https://api.github.com/users/GitHubRGI/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GitHubRGI/subscriptions","organizations_url":"https://api.github.com/users/GitHubRGI/orgs","repos_url":"https://api.github.com/users/GitHubRGI/repos","events_url":"https://api.github.com/users/GitHubRGI/events{/privacy}","received_events_url":"https://api.github.com/users/GitHubRGI/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/GitHubRGI/swagd","description":"A Java-based application for tiling geospatial images into tiles, packaging those tiles, and viewing them on a map.","fork":false,"url":"https://api.github.com/repos/GitHubRGI/swagd","forks_url":"https://api.github.com/repos/GitHubRGI/swagd/forks","keys_url":"https://api.github.com/repos/GitHubRGI/swagd/keys{/key_id}","collaborators_url":"https://api.github.com/repos/GitHubRGI/swagd/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/GitHubRGI/swagd/teams","hooks_url":"https://api.github.com/repos/GitHubRGI/swagd/hooks","issue_events_url":"https://api.github.com/repos/GitHubRGI/swagd/issues/events{/number}","events_url":"https://api.github.com/repos/GitHubRGI/swagd/events","assignees_url":"https://api.github.com/repos/GitHubRGI/swagd/assignees{/user}","branches_url":"https://api.github.com/repos/GitHubRGI/swagd/branches{/branch}","tags_url":"https://api.github.com/repos/GitHubRGI/swagd/tags","blobs_url":"https://api.github.com/repos/GitHubRGI/swagd/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/GitHubRGI/swagd/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/GitHubRGI/swagd/git/refs{/sha}","trees_url":"https://api.github.com/repos/GitHubRGI/swagd/git/trees{/sha}","statuses_url":"https://api.github.com/repos/GitHubRGI/swagd/statuses/{sha}","languages_url":"https://api.github.com/repos/GitHubRGI/swagd/languages","stargazers_url":"https://api.github.com/repos/GitHubRGI/swagd/stargazers","contributors_url":"https://api.github.com/repos/GitHubRGI/swagd/contributors","subscribers_url":"https://api.github.com/repos/GitHubRGI/swagd/subscribers","subscription_url":"https://api.github.com/repos/GitHubRGI/swagd/subscription","commits_url":"https://api.github.com/repos/GitHubRGI/swagd/commits{/sha}","git_commits_url":"https://api.github.com/repos/GitHubRGI/swagd/git/commits{/sha}","comments_url":"https://api.github.com/repos/GitHubRGI/swagd/comments{/number}","issue_comment_url":"https://api.github.com/repos/GitHubRGI/swagd/issues/comments{/number}","contents_url":"https://api.github.com/repos/GitHubRGI/swagd/contents/{+path}","compare_url":"https://api.github.com/repos/GitHubRGI/swagd/compare/{base}...{head}","merges_url":"https://api.github.com/repos/GitHubRGI/swagd/merges","archive_url":"https://api.github.com/repos/GitHubRGI/swagd/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/GitHubRGI/swagd/downloads","issues_url":"https://api.github.com/repos/GitHubRGI/swagd/issues{/number}","pulls_url":"https://api.github.com/repos/GitHubRGI/swagd/pulls{/number}","milestones_url":"https://api.github.com/repos/GitHubRGI/swagd/milestones{/number}","notifications_url":"https://api.github.com/repos/GitHubRGI/swagd/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/GitHubRGI/swagd/labels{/name}","releases_url":"https://api.github.com/repos/GitHubRGI/swagd/releases{/id}","created_at":"2014-12-11T18:37:12Z","updated_at":"2015-05-07T12:35:19Z","pushed_at":"2015-05-08T12:01:56Z","git_url":"git://github.com/GitHubRGI/swagd.git","ssh_url":"git@github.com:GitHubRGI/swagd.git","clone_url":"https://github.com/GitHubRGI/swagd.git","svn_url":"https://github.com/GitHubRGI/swagd","homepage":null,"size":45785,"stargazers_count":1,"watchers_count":1,"language":"Java","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1,"mirror_url":null,"open_issues_count":57,"forks":1,"open_issues":57,"watchers":1,"default_branch":"master"}},"base":{"label":"GitHubRGI:master","ref":"master","sha":"7c39337927b997297ee339e5980242f00b736329","user":{"login":"GitHubRGI","id":532280,"avatar_url":"https://avatars.githubusercontent.com/u/532280?v=3","gravatar_id":"","url":"https://api.github.com/users/GitHubRGI","html_url":"https://github.com/GitHubRGI","followers_url":"https://api.github.com/users/GitHubRGI/followers","following_url":"https://api.github.com/users/GitHubRGI/following{/other_user}","gists_url":"https://api.github.com/users/GitHubRGI/gists{/gist_id}","starred_url":"https://api.github.com/users/GitHubRGI/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GitHubRGI/subscriptions","organizations_url":"https://api.github.com/users/GitHubRGI/orgs","repos_url":"https://api.github.com/users/GitHubRGI/repos","events_url":"https://api.github.com/users/GitHubRGI/events{/privacy}","received_events_url":"https://api.github.com/users/GitHubRGI/received_events","type":"Organization","site_admin":false},"repo":{"id":27885801,"name":"swagd","full_name":"GitHubRGI/swagd","owner":{"login":"GitHubRGI","id":532280,"avatar_url":"https://avatars.githubusercontent.com/u/532280?v=3","gravatar_id":"","url":"https://api.github.com/users/GitHubRGI","html_url":"https://github.com/GitHubRGI","followers_url":"https://api.github.com/users/GitHubRGI/followers","following_url":"https://api.github.com/users/GitHubRGI/following{/other_user}","gists_url":"https://api.github.com/users/GitHubRGI/gists{/gist_id}","starred_url":"https://api.github.com/users/GitHubRGI/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GitHubRGI/subscriptions","organizations_url":"https://api.github.com/users/GitHubRGI/orgs","repos_url":"https://api.github.com/users/GitHubRGI/repos","events_url":"https://api.github.com/users/GitHubRGI/events{/privacy}","received_events_url":"https://api.github.com/users/GitHubRGI/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/GitHubRGI/swagd","description":"A Java-based application for tiling geospatial images into tiles, packaging those tiles, and viewing them on a map.","fork":false,"url":"https://api.github.com/repos/GitHubRGI/swagd","forks_url":"https://api.github.com/repos/GitHubRGI/swagd/forks","keys_url":"https://api.github.com/repos/GitHubRGI/swagd/keys{/key_id}","collaborators_url":"https://api.github.com/repos/GitHubRGI/swagd/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/GitHubRGI/swagd/teams","hooks_url":"https://api.github.com/repos/GitHubRGI/swagd/hooks","issue_events_url":"https://api.github.com/repos/GitHubRGI/swagd/issues/events{/number}","events_url":"https://api.github.com/repos/GitHubRGI/swagd/events","assignees_url":"https://api.github.com/repos/GitHubRGI/swagd/assignees{/user}","branches_url":"https://api.github.com/repos/GitHubRGI/swagd/branches{/branch}","tags_url":"https://api.github.com/repos/GitHubRGI/swagd/tags","blobs_url":"https://api.github.com/repos/GitHubRGI/swagd/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/GitHubRGI/swagd/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/GitHubRGI/swagd/git/refs{/sha}","trees_url":"https://api.github.com/repos/GitHubRGI/swagd/git/trees{/sha}","statuses_url":"https://api.github.com/repos/GitHubRGI/swagd/statuses/{sha}","languages_url":"https://api.github.com/repos/GitHubRGI/swagd/languages","stargazers_url":"https://api.github.com/repos/GitHubRGI/swagd/stargazers","contributors_url":"https://api.github.com/repos/GitHubRGI/swagd/contributors","subscribers_url":"https://api.github.com/repos/GitHubRGI/swagd/subscribers","subscription_url":"https://api.github.com/repos/GitHubRGI/swagd/subscription","commits_url":"https://api.github.com/repos/GitHubRGI/swagd/commits{/sha}","git_commits_url":"https://api.github.com/repos/GitHubRGI/swagd/git/commits{/sha}","comments_url":"https://api.github.com/repos/GitHubRGI/swagd/comments{/number}","issue_comment_url":"https://api.github.com/repos/GitHubRGI/swagd/issues/comments{/number}","contents_url":"https://api.github.com/repos/GitHubRGI/swagd/contents/{+path}","compare_url":"https://api.github.com/repos/GitHubRGI/swagd/compare/{base}...{head}","merges_url":"https://api.github.com/repos/GitHubRGI/swagd/merges","archive_url":"https://api.github.com/repos/GitHubRGI/swagd/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/GitHubRGI/swagd/downloads","issues_url":"https://api.github.com/repos/GitHubRGI/swagd/issues{/number}","pulls_url":"https://api.github.com/repos/GitHubRGI/swagd/pulls{/number}","milestones_url":"https://api.github.com/repos/GitHubRGI/swagd/milestones{/number}","notifications_url":"https://api.github.com/repos/GitHubRGI/swagd/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/GitHubRGI/swagd/labels{/name}","releases_url":"https://api.github.com/repos/GitHubRGI/swagd/releases{/id}","created_at":"2014-12-11T18:37:12Z","updated_at":"2015-05-07T12:35:19Z","pushed_at":"2015-05-08T12:01:56Z","git_url":"git://github.com/GitHubRGI/swagd.git","ssh_url":"git@github.com:GitHubRGI/swagd.git","clone_url":"https://github.com/GitHubRGI/swagd.git","svn_url":"https://github.com/GitHubRGI/swagd","homepage":null,"size":45785,"stargazers_count":1,"watchers_count":1,"language":"Java","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1,"mirror_url":null,"open_issues_count":57,"forks":1,"open_issues":57,"watchers":1,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/GitHubRGI/swagd/pulls/215"},"html":{"href":"https://github.com/GitHubRGI/swagd/pull/215"},"issue":{"href":"https://api.github.com/repos/GitHubRGI/swagd/issues/215"},"comments":{"href":"https://api.github.com/repos/GitHubRGI/swagd/issues/215/comments"},"review_comments":{"href":"https://api.github.com/repos/GitHubRGI/swagd/pulls/215/comments"},"review_comment":{"href":"https://api.github.com/repos/GitHubRGI/swagd/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/GitHubRGI/swagd/pulls/215/commits"},"statuses":{"href":"https://api.github.com/repos/GitHubRGI/swagd/statuses/5e2dcb644f71f2d42616e4f6bfa449f1542a18c7"}}}}