Re: [Treebase-devel] loading the treetype annotation

[Vladimir G. <vla...@du...>]

On Mar 16, 2010, at 2:48 PM, William Piel wrote:
>>
>>> A artifact of the March migration was that trees did not get their  
>>> proper  "Tree Type" designation (i.e. consensus vs single). I have  
>>> created an easy look-up table containing legacy tree IDs and their  
>>> tree type designation. These designations need to be converted to  
>>> integers before updating based on a matching the legacy ID values.
>>>
>>> http://www.treebase.org/treebase/migration/Mar-10/tree_types.txt
>>
>
>
> Whoops. Can you map the "Simple Tree" to "Single" and the NULL tree  
> to "Single".

I have applied the treetype to the DB, as corrected.

There were 1002 trees with the null treetype, now there are only 33  
(below).

--Vladimir


treebasestage=> -- The trees with the null treetype
treebasestage=> select phylotree_id, tb1_treeid, treetype_id
treebasestage-> from phylotree
treebasestage-> where treetype_id is null;
  phylotree_id | tb1_treeid | treetype_id
--------------+------------+-------------
          2556 | Tree4532   |
          2557 | Tree4533   |
          2727 | Tree4962   |
          2726 | Tree4963   |
          5921 |            |
          5962 |            |
          5961 |            |
          5981 |            |
          6959 |            |
          6964 |            |
          6963 |            |
          6961 |            |
          6972 |            |
          6971 |            |
          6973 |            |
          6962 |            |
          6970 |            |
          6969 |            |
          6968 |            |
          6967 |            |
          6966 |            |
          6965 |            |
          6960 |            |
          6074 |            |
          5941 |            |
          5963 |            |
          6874 |            |
          6521 |            |
          6075 |            |
          6750 |            |
          6176 |            |
          6358 |            |
          6433 |            |
(33 rows)