{"action":"created","issue":{"url":"https://api.github.com/repos/ArctosDB/arctos/issues/1355","repository_url":"https://api.github.com/repos/ArctosDB/arctos","labels_url":"https://api.github.com/repos/ArctosDB/arctos/issues/1355/labels{/name}","comments_url":"https://api.github.com/repos/ArctosDB/arctos/issues/1355/comments","events_url":"https://api.github.com/repos/ArctosDB/arctos/issues/1355/events","html_url":"https://github.com/ArctosDB/arctos/issues/1355","id":281187293,"number":1355,"title":"GGBN DWC data","user":{"login":"dustymc","id":5720791,"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},"labels":[],"state":"closed","locked":false,"assignee":{"login":"dbloom","id":942447,"avatar_url":"https://avatars1.githubusercontent.com/u/942447?v=4","gravatar_id":"","url":"https://api.github.com/users/dbloom","html_url":"https://github.com/dbloom","followers_url":"https://api.github.com/users/dbloom/followers","following_url":"https://api.github.com/users/dbloom/following{/other_user}","gists_url":"https://api.github.com/users/dbloom/gists{/gist_id}","starred_url":"https://api.github.com/users/dbloom/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dbloom/subscriptions","organizations_url":"https://api.github.com/users/dbloom/orgs","repos_url":"https://api.github.com/users/dbloom/repos","events_url":"https://api.github.com/users/dbloom/events{/privacy}","received_events_url":"https://api.github.com/users/dbloom/received_events","type":"User","site_admin":false},"assignees":[{"login":"dbloom","id":942447,"avatar_url":"https://avatars1.githubusercontent.com/u/942447?v=4","gravatar_id":"","url":"https://api.github.com/users/dbloom","html_url":"https://github.com/dbloom","followers_url":"https://api.github.com/users/dbloom/followers","following_url":"https://api.github.com/users/dbloom/following{/other_user}","gists_url":"https://api.github.com/users/dbloom/gists{/gist_id}","starred_url":"https://api.github.com/users/dbloom/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dbloom/subscriptions","organizations_url":"https://api.github.com/users/dbloom/orgs","repos_url":"https://api.github.com/users/dbloom/repos","events_url":"https://api.github.com/users/dbloom/events{/privacy}","received_events_url":"https://api.github.com/users/dbloom/received_events","type":"User","site_admin":false},{"login":"dustymc","id":5720791,"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}],"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,"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,"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":131,"closed_issues":53,"state":"open","created_at":"2015-08-27T22:05:58Z","updated_at":"2018-04-09T20:33:18Z","due_on":null,"closed_at":null},"comments":15,"created_at":"2017-12-11T22:18:44Z","updated_at":"2018-04-09T20:33:18Z","closed_at":"2018-04-09T20:33:18Z","author_association":"CONTRIBUTOR","body":"There's a first attempt at GGBN DWC data, one file for Tissues and one for Permits, both keyed to Occurrences, in the DDL/flat folder\r\n\r\nhttps://github.com/ArctosDB/DDL/blob/master/flat/ggbn_flat_tissue.sql \r\nhttps://github.com/ArctosDB/DDL/blob/master/flat/ggbn_flat_permit.sql \r\n\r\nWhat's missing, what should be added, are there any privacy concerns, etc.?\r\n\r\nThe GGBN Standard is https://terms.tdwg.org/wiki/GGBN_Data_Standard.\r\n\r\nExample data:\r\n```\r\nUAM@ARCTOSTE> select * from digir_query.ggbn_flat_tissue where rownum=1;\r\n\r\nOCCURRENCEID\r\n------------------------------------------------------------------------------------------------------------------------\r\nMATERIALSAMPLETYPE\r\n------------------\r\nPREPARATIONTYPE\r\n------------------------------------------------------------------------------------------------------------------------\r\nPREPARATIO PRE\r\n---------- ---\r\nPREPARATIONSTAFF\r\n------------------------------------------------------------------------------------------------------------------------\r\nhttp://arctos.database.museum/guid/MVZ:Mamm:158848?seid=30778\r\ntissue\r\ntissue extract (frozen)\r\n1999-02-04\r\nunknown\r\n```\r\n```\r\n\r\nUAM@ARCTOSTE> select * from digir_query.ggbn_flat_permit where rownum=1;\r\n\r\nOCCURRENCEID\r\n------------------------------------------------------------------------------------------------------------------------\r\nPERMITTYPE\r\n------------------------------------------------------------------------------------------------------------------------\r\nPERMITSTATUS\t\t\t\t\t\t     PER\r\n------------------------------------------------------------ ---\r\nPERMITTEXT\r\n------------------------------------------------------------------------------------------------------------------------\r\nhttp://arctos.database.museum/guid/UAM:Mamm:99528?seid=662612\r\ncollect\r\nPermit available\r\nPermit Number 06-051 issued to Link E. Olson by Alaska Department of Fish and Game\r\n\r\n\r\n```"},"comment":{"url":"https://api.github.com/repos/ArctosDB/arctos/issues/comments/379884951","html_url":"https://github.com/ArctosDB/arctos/issues/1355#issuecomment-379884951","issue_url":"https://api.github.com/repos/ArctosDB/arctos/issues/1355","id":379884951,"user":{"login":"campmlc","id":14808196,"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-04-09T20:33:18Z","updated_at":"2018-04-09T20:33:18Z","author_association":"NONE","body":"Required to have data published in pipeline by July 15, 2018.  Need trial run at least 5 weeks advance to work out any problems."}}
{"actor":{"display_login":"campmlc"}}