{"action":"closed","issue":{"url":"https://api.github.com/repos/jyutzler/geopackage-related-tables/issues/31","repository_url":"https://api.github.com/repos/jyutzler/geopackage-related-tables","labels_url":"https://api.github.com/repos/jyutzler/geopackage-related-tables/issues/31/labels{/name}","comments_url":"https://api.github.com/repos/jyutzler/geopackage-related-tables/issues/31/comments","events_url":"https://api.github.com/repos/jyutzler/geopackage-related-tables/issues/31/events","html_url":"https://github.com/jyutzler/geopackage-related-tables/issues/31","id":295687015,"number":31,"title":"Support feature to feature relationships","user":{"login":"bradh","id":174642,"avatar_url":"https://avatars2.githubusercontent.com/u/174642?v=4","gravatar_id":"","url":"https://api.github.com/users/bradh","html_url":"https://github.com/bradh","followers_url":"https://api.github.com/users/bradh/followers","following_url":"https://api.github.com/users/bradh/following{/other_user}","gists_url":"https://api.github.com/users/bradh/gists{/gist_id}","starred_url":"https://api.github.com/users/bradh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bradh/subscriptions","organizations_url":"https://api.github.com/users/bradh/orgs","repos_url":"https://api.github.com/users/bradh/repos","events_url":"https://api.github.com/users/bradh/events{/privacy}","received_events_url":"https://api.github.com/users/bradh/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-02-08T22:23:09Z","updated_at":"2018-02-27T03:35:18Z","closed_at":"2018-02-27T03:35:18Z","author_association":"COLLABORATOR","body":"The related table extension basically defines a mapping between the primary keys of two tables in terms of `base` (the left side of the mapping) and `related` (the right side of the mapping).\r\n\r\nRight now, the left side can be tiles, attributes or features.\r\n\r\nThe right side can be tables of attributes containing media (or \"simple attributes\" if something like #29 or #30 is applied). That constraint is implied by defined values of `relation_name`. Now there is no reason why you can't do any other value, but it won't be particularly interoperable.\r\n\r\nHowever it means that there are things that can't appear on the right side. In particular, I think there is a case for linking spatial X to spatial Y. For example, the FAA publishes airports as point locations (and a bunch of attributes, and runways as polygons (and a bunch of different attributes). See http://ais-faa.opendata.arcgis.com/datasets?keyword=airports . There is enough data to link them, and there is probably a sensible UI that allows you to click on an airport, select a runway, be shown the runway as features on the map, get related obstructions if its VFR, or get the instrument approach plate (in PDF, using a media related table); then click on a table of comms frequencies for the airport (as simple features).  We can do most of that, just not the linkage from airport feature to runway feature (i.e. feature on the right side of the mapping).\r\n\r\nI'm not currently seeing the need for tiles on the right side of the mapping, but that would probably be analogous to whatever we come up with here."}}
{"actor":{"display_login":"jyutzler"}}