Shared_taxonomy is NULL on data_resource

[GoogleCodeExporter]

The portal barfs when shared_taxonomy IS NULL on data_resource.  

Shared_taxonomy indicated that the parent/child relationships in TC can span 
multiple taxonomies.  This should be 0 for everything except where CLB tells us 
(through the datasets table) that the checklist spans multiple datasets 
(catalogue of life only?)

-- an example
mysql> select shared_taxonomy from data_resource where name like 'A Glob%Lich%';
+-----------------+
| shared_taxonomy |
+-----------------+
|            NULL | 
+-----------------+
1 row in set (0.00 sec)

We see that for CoL there are many with null:

mysql> select shared_taxonomy,count(*) from data_resource where 
data_provider_id=2 group by 1;
+-----------------+----------+
| shared_taxonomy | count(*) |
+-----------------+----------+
|            NULL |       98 | 
|               1 |       49 | 
+-----------------+----------+
2 rows in set (0.00 sec)

I will apply a fix in portal_rollover, to allow further investigations, but the 
source needs identified and fixed.  

Original issue reported on code.google.com by timrobertson100 on 6 May 2011 at 9:37

[GoogleCodeExporter]

Yeah we merge the data_providers from the portal with the newly created ones 
from CLB. Those from CLB all get shared_taxonomy = NULL and those from the 
portal retain their original value.

It is easy to set this to 0 by default but I don't think we get the information 
we need to make a choice if it should be 1.

Original comment by lars.fra...@gmail.com on 6 May 2011 at 9:44

• Changed state: Accepted

[GoogleCodeExporter]

Could we extend the distinct_data_resource_uuids view to add a column that is 0 
for all UUIDs coming from checklist and 1 for all those coming from dataset?

Original comment by lars.fra...@gmail.com on 6 May 2011 at 9:52