{"action":"created","issue":{"url":"https://api.github.com/repos/opengeospatial/ets-gpkg12/issues/60","repository_url":"https://api.github.com/repos/opengeospatial/ets-gpkg12","labels_url":"https://api.github.com/repos/opengeospatial/ets-gpkg12/issues/60/labels{/name}","comments_url":"https://api.github.com/repos/opengeospatial/ets-gpkg12/issues/60/comments","events_url":"https://api.github.com/repos/opengeospatial/ets-gpkg12/issues/60/events","html_url":"https://github.com/opengeospatial/ets-gpkg12/issues/60","id":325474912,"node_id":"MDU6SXNzdWUzMjU0NzQ5MTI=","number":60,"title":"The spatial issue revisited","user":{"login":"ajanett","id":16159968,"node_id":"MDQ6VXNlcjE2MTU5OTY4","avatar_url":"https://avatars1.githubusercontent.com/u/16159968?v=4","gravatar_id":"","url":"https://api.github.com/users/ajanett","html_url":"https://github.com/ajanett","followers_url":"https://api.github.com/users/ajanett/followers","following_url":"https://api.github.com/users/ajanett/following{/other_user}","gists_url":"https://api.github.com/users/ajanett/gists{/gist_id}","starred_url":"https://api.github.com/users/ajanett/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ajanett/subscriptions","organizations_url":"https://api.github.com/users/ajanett/orgs","repos_url":"https://api.github.com/users/ajanett/repos","events_url":"https://api.github.com/users/ajanett/events{/privacy}","received_events_url":"https://api.github.com/users/ajanett/received_events","type":"User","site_admin":false},"labels":[{"id":529995068,"node_id":"MDU6TGFiZWw1Mjk5OTUwNjg=","url":"https://api.github.com/repos/opengeospatial/ets-gpkg12/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-05-22T21:46:06Z","updated_at":"2018-06-22T14:23:50Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"The GeoPackage Tests that may need to delve into the geometry blob include those for requirements 12-128r14 19, 20, 32, 33, 67, 78 and also NSG Requirement 19B. For the most part, these include evaluation of geometry spatial reference, geometry type, envelope min/max. Requirement 66, then goes even more in-depth into the entire WKB.\r\n\r\nThe issue discussed before:\r\nIs there a need for the spatialite extensions or a subset of these extensions to be available within the ETS GeoPackage?\r\n\r\nMaybe for the WKB decoding (requirement #66), but there are other issues with #66 and I'll post that in a moment. \r\n\r\nIt isn't that complicated to get the spatial reference, envelope, and geometry type from the geometry BLOB and in order to test these with ANY kind of performance, we need to crack open the geometry BLOB once per feature instance and make all tests on it. Therefore, SQL extensions are not going to provide the necessary performance.  The only caveat that I know is that we need to assume the envelope min/max is representative of the feature min/max.\r\n\r\nI've got an implementation of these tests ready to insert into this GeoPackage test tool, but am awaiting a fix on another issue to finalize my testing of these extensions.\r\n"},"comment":{"url":"https://api.github.com/repos/opengeospatial/ets-gpkg12/issues/comments/399459935","html_url":"https://github.com/opengeospatial/ets-gpkg12/issues/60#issuecomment-399459935","issue_url":"https://api.github.com/repos/opengeospatial/ets-gpkg12/issues/60","id":399459935,"node_id":"MDEyOklzc3VlQ29tbWVudDM5OTQ1OTkzNQ==","user":{"login":"jyutzler","id":3401345,"node_id":"MDQ6VXNlcjM0MDEzNDU=","avatar_url":"https://avatars1.githubusercontent.com/u/3401345?v=4","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":"2018-06-22T14:23:49Z","updated_at":"2018-06-22T14:23:49Z","author_association":"CONTRIBUTOR","body":"Are we satisfied with #70 (which includes #62)?"}}
{"actor":{"display_login":"jyutzler"}}