{"action":"created","issue":{"url":"https://api.github.com/repos/opengeospatial/geopackage/issues/221","repository_url":"https://api.github.com/repos/opengeospatial/geopackage","labels_url":"https://api.github.com/repos/opengeospatial/geopackage/issues/221/labels{/name}","comments_url":"https://api.github.com/repos/opengeospatial/geopackage/issues/221/comments","events_url":"https://api.github.com/repos/opengeospatial/geopackage/issues/221/events","html_url":"https://github.com/opengeospatial/geopackage/issues/221","id":162992956,"number":221,"title":"Make non-spatial tables discoverable","user":{"login":"jyutzler","id":3401345,"avatar_url":"https://avatars.githubusercontent.com/u/3401345?v=3","gravatar_id":"","url":"https://api.github.com/users/jyutzler","html_url":"https://github.com/jyutzler","followers_url":"https://api.github.com/users/jyutzler/followers","following_url":"https://api.github.com/users/jyutzler/following{/other_user}","gists_url":"https://api.github.com/users/jyutzler/gists{/gist_id}","starred_url":"https://api.github.com/users/jyutzler/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jyutzler/subscriptions","organizations_url":"https://api.github.com/users/jyutzler/orgs","repos_url":"https://api.github.com/users/jyutzler/repos","events_url":"https://api.github.com/users/jyutzler/events{/privacy}","received_events_url":"https://api.github.com/users/jyutzler/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-06-29T18:20:39Z","updated_at":"2016-07-05T13:35:41Z","closed_at":null,"body":"Reference: http://ogc.standardstracker.org/show_request.cgi?id=380\r\n\r\nThe request calls for supporting non-spatial tables in a GeoPackage . An Extended GeoPackage includes elements that are outside the GeoPackage Core Specification. This is perfectly appropriate, and in many cases encouraged. There is nothing keeping the GeoPackage producer from adding additional tables (whatever the reason) and calling the output file an Extended GeoPackage.\r\n\r\nThe real issue is discoverability. Some applications do not know how to find these tables inside a GeoPackage. It may be possible for the user to open them manually, but that is unreasonable if there are a large number of tables. A better solution would be to make those tables discoverable. \r\n\r\nA simple extension such as the following would support this. \r\n\r\n|gpkg_extensions column|value|\r\n|-------------|----------------|\r\n|table_name|(actual table name)|\r\n|column_name|NULL|\r\n|extension_name|gpkg_non_spatial|\r\n|definition|TBD|\r\n|scope|read-write|\r\n\r\nIf desired, this extension could also work with the [Schema Extension](http://www.geopackage.org/spec/#extension_schema)."},"comment":{"url":"https://api.github.com/repos/opengeospatial/geopackage/issues/comments/230479747","html_url":"https://github.com/opengeospatial/geopackage/issues/221#issuecomment-230479747","issue_url":"https://api.github.com/repos/opengeospatial/geopackage/issues/221","id":230479747,"user":{"login":"jyutzler","id":3401345,"avatar_url":"https://avatars.githubusercontent.com/u/3401345?v=3","gravatar_id":"","url":"https://api.github.com/users/jyutzler","html_url":"https://github.com/jyutzler","followers_url":"https://api.github.com/users/jyutzler/followers","following_url":"https://api.github.com/users/jyutzler/following{/other_user}","gists_url":"https://api.github.com/users/jyutzler/gists{/gist_id}","starred_url":"https://api.github.com/users/jyutzler/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jyutzler/subscriptions","organizations_url":"https://api.github.com/users/jyutzler/orgs","repos_url":"https://api.github.com/users/jyutzler/repos","events_url":"https://api.github.com/users/jyutzler/events{/privacy}","received_events_url":"https://api.github.com/users/jyutzler/received_events","type":"User","site_admin":false},"created_at":"2016-07-05T13:35:41Z","updated_at":"2016-07-05T13:35:41Z","body":"It turns out this topic was discussed a while ago http://lists.opengeospatial.org/pipermail/geopackage/2014-June/000022.html"}}
{"actor":{"display_login":"jyutzler"}}