{"action":"created","issue":{"url":"https://api.github.com/repos/ArctosDB/arctos/issues/735","repository_url":"https://api.github.com/repos/ArctosDB/arctos","labels_url":"https://api.github.com/repos/ArctosDB/arctos/issues/735/labels{/name}","comments_url":"https://api.github.com/repos/ArctosDB/arctos/issues/735/comments","events_url":"https://api.github.com/repos/ArctosDB/arctos/issues/735/events","html_url":"https://github.com/ArctosDB/arctos/issues/735","id":102922033,"node_id":"MDU6SXNzdWUxMDI5MjIwMzM=","number":735,"title":"taxonomy relationships","user":{"login":"GoogleCodeExporter","id":9614759,"node_id":"MDQ6VXNlcjk2MTQ3NTk=","avatar_url":"https://avatars0.githubusercontent.com/u/9614759?v=4","gravatar_id":"","url":"https://api.github.com/users/GoogleCodeExporter","html_url":"https://github.com/GoogleCodeExporter","followers_url":"https://api.github.com/users/GoogleCodeExporter/followers","following_url":"https://api.github.com/users/GoogleCodeExporter/following{/other_user}","gists_url":"https://api.github.com/users/GoogleCodeExporter/gists{/gist_id}","starred_url":"https://api.github.com/users/GoogleCodeExporter/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GoogleCodeExporter/subscriptions","organizations_url":"https://api.github.com/users/GoogleCodeExporter/orgs","repos_url":"https://api.github.com/users/GoogleCodeExporter/repos","events_url":"https://api.github.com/users/GoogleCodeExporter/events{/privacy}","received_events_url":"https://api.github.com/users/GoogleCodeExporter/received_events","type":"User","site_admin":false},"labels":[{"id":328823241,"node_id":"MDU6TGFiZWwzMjg4MjMyNDE=","url":"https://api.github.com/repos/ArctosDB/arctos/labels/Function-Taxonomy/Identification","name":"Function-Taxonomy/Identification","color":"fef2c0","default":false},{"id":252228770,"node_id":"MDU6TGFiZWwyNTIyMjg3NzA=","url":"https://api.github.com/repos/ArctosDB/arctos/labels/Priority-High","name":"Priority-High","color":"eb6420","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/ArctosDB/arctos/milestones/3","html_url":"https://github.com/ArctosDB/arctos/milestone/3","labels_url":"https://api.github.com/repos/ArctosDB/arctos/milestones/3/labels","id":1276690,"node_id":"MDk6TWlsZXN0b25lMTI3NjY5MA==","number":3,"title":"Needs Discussion","description":"The path to implementation is unclear and requires discussion by involved parties, the Advisory Committee, and/or the Arctos Group.","creator":{"login":"dustymc","id":5720791,"node_id":"MDQ6VXNlcjU3MjA3OTE=","avatar_url":"https://avatars0.githubusercontent.com/u/5720791?v=4","gravatar_id":"","url":"https://api.github.com/users/dustymc","html_url":"https://github.com/dustymc","followers_url":"https://api.github.com/users/dustymc/followers","following_url":"https://api.github.com/users/dustymc/following{/other_user}","gists_url":"https://api.github.com/users/dustymc/gists{/gist_id}","starred_url":"https://api.github.com/users/dustymc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dustymc/subscriptions","organizations_url":"https://api.github.com/users/dustymc/orgs","repos_url":"https://api.github.com/users/dustymc/repos","events_url":"https://api.github.com/users/dustymc/events{/privacy}","received_events_url":"https://api.github.com/users/dustymc/received_events","type":"User","site_admin":false},"open_issues":194,"closed_issues":85,"state":"open","created_at":"2015-08-27T22:05:58Z","updated_at":"2018-12-05T21:13:43Z","due_on":null,"closed_at":null},"comments":3,"created_at":"2015-08-25T00:41:08Z","updated_at":"2018-12-10T22:07:13Z","closed_at":null,"author_association":"NONE","body":"```\nSearching \"everything taxonomy\" does not perform very well, in part because we \ndo not have reciprocal taxonomy relationships and so must perform an additional \nexpensive join to fully consider relationships.\n\nTo implement reciprocity, \nhttp://arctos.database.museum/info/ctDocumentation.cfm?table=CTTAXON_RELATION \nneeds to have a \"reciprocal_relationship NOT NULL\" column (or some functional \nequivalent) added and populated.\n\nOne potential (probably minor?) complication may be in ICBN vs. ICZN usage - \nWikipedia says \"synonym\" (botany) and \"junior synonym\" (zoology) are the same \nthing, for example.\n\nExample:\n\nhttp://arctos.database.museum/name/Nemata-->synonym \nof-->http://arctos.database.museum/name/Nematoda\nhttp://arctos.database.museum/name/Nematoda--->(no relationships)\n\nwould (automatically, from the revised code table) update to\n\nhttp://arctos.database.museum/name/Nemata-->synonym \nof-->http://arctos.database.museum/name/Nematoda\nhttp://arctos.database.museum/name/Nematoda--->{whatever the reciprocal of \n\"synonym of\" is}--->http://arctos.database.museum/name/Nemata\n\nThis would also solve \nhttps://groups.google.com/d/msg/arctos-ac/DfZe3kxADlY/RN7H3q3JSzEJ (formatting \ntaxonomy relationships).\n\nRef: https://code.google.com/p/arctos/issues/detail?id=734\n```\n\nOriginal issue reported on code.google.com by `dust...@gmail.com` on 13 Jul 2015 at 8:54\n"},"comment":{"url":"https://api.github.com/repos/ArctosDB/arctos/issues/comments/445992625","html_url":"https://github.com/ArctosDB/arctos/issues/735#issuecomment-445992625","issue_url":"https://api.github.com/repos/ArctosDB/arctos/issues/735","id":445992625,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0NTk5MjYyNQ==","user":{"login":"campmlc","id":14808196,"node_id":"MDQ6VXNlcjE0ODA4MTk2","avatar_url":"https://avatars0.githubusercontent.com/u/14808196?v=4","gravatar_id":"","url":"https://api.github.com/users/campmlc","html_url":"https://github.com/campmlc","followers_url":"https://api.github.com/users/campmlc/followers","following_url":"https://api.github.com/users/campmlc/following{/other_user}","gists_url":"https://api.github.com/users/campmlc/gists{/gist_id}","starred_url":"https://api.github.com/users/campmlc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/campmlc/subscriptions","organizations_url":"https://api.github.com/users/campmlc/orgs","repos_url":"https://api.github.com/users/campmlc/repos","events_url":"https://api.github.com/users/campmlc/events{/privacy}","received_events_url":"https://api.github.com/users/campmlc/received_events","type":"User","site_admin":false},"created_at":"2018-12-10T22:07:13Z","updated_at":"2018-12-10T22:07:13Z","author_association":"NONE","body":"Taxon IDs sounds like a promising approach for dealing with the issue of\nlinking a name to an authority, date, and classification.\n\nOn Mon, Dec 10, 2018 at 2:56 PM dustymc <notifications@github.com> wrote:\n\n> assigning a number\n>\n> We do - names have taxon_name_id and classifications have\n> classification_id.\n>\n> same way we do to a locality\n>\n> ...and just like localities, the ID isn't stable - they get replaced\n> rather than updated when it's convenient, etc. Localities have\n> 'locality_name' which IS stable - easy enough to add that to something like\n> classifications, but (like locality_name) that would affect how the data\n> may be managed.\n>\n> —\n> You are receiving this because you are subscribed to this thread.\n> Reply to this email directly, view it on GitHub\n> <https://github.com/ArctosDB/arctos/issues/735#issuecomment-445989310>,\n> or mute the thread\n> <https://github.com/notifications/unsubscribe-auth/AOH0hJ928oIJqebrpwiQ9S3w-cGswTtbks5u3tiDgaJpZM4ICJ2v>\n> .\n>\n"}}
{"actor":{"display_login":"campmlc"}}