900+ datasets are missing an endpoint

18671
Reporter: mdoering
Assignee: jlegind
Type: Bug
Summary: 900+ datasets are missing an endpoint
Priority: Unassessed
Status: InProgress
Created: 2016-07-29 15:07:57.212
Updated: 2016-08-17 09:17:07.014
        
Description: We have over 900 current datasets lacking an endpoint in our registry, mostly scratchpad checklists. Is this ok or should these rather be of type metadata only then?

{noformat}
prod_b_registry=# select type, publishing_organization_key, count(*) from dataset where deleted is null and parent_dataset_key is null and  key not in (select distinct dataset_key from dataset_endpoint) group by type, publishing_organization_key order by 1,2,3;
    type    |     publishing_organization_key      | count
------------+--------------------------------------+-------
 OCCURRENCE | 07e58d67-c090-4703-aada-3b88b10355f7 |     1
 OCCURRENCE | 76905ca0-1e21-11de-9ca0-cd203b273f5d |     2
 OCCURRENCE | 7ff14f90-946d-11dd-a03f-b8a03c50a862 |     2
 CHECKLIST  | 315b3c03-4a0a-424e-83a5-d25aa748e666 |   878
 CHECKLIST  | 7ce8aef0-9e92-11dc-8738-b8a03c50a862 |    22
{noformat}]]>
    

Author: jlegind@gbif.org
Comment: VIncent Smith from Scratchpads has been contacted and they are working on cleaning out the worst offenders. Not all these datasets will have DwC endpoints since some are meta data only.
Created: 2016-08-17 09:17:07.014
Updated: 2016-08-17 09:17:07.014