search

USGCRP / gcis

Global Change Information System
https://data.globalchange.gov
Other
20 stars 16 forks source link

Rearrange Roles on Contributor Selection #590

Closed lomky closed 6 years ago

lomky commented 6 years ago

Move 'Point of Contact' role next to the role 'Author' (sort order), so that selection of multiple roles is easier. Currently, the most common multiple roles are POC and Author.

lomky commented 6 years ago

@amruelama Here is the current sort_order on role_type. 

gcis=# select * from role_type ORDER BY sort_key ASC;
        identifier        |          label           | sort_key | comment
--------------------------+--------------------------+----------+---------
 convening_lead_author    | Convening Lead Author    |       10 |
 coordinating_lead_author | Coordinating Lead Author |       11 |
 lead_author              | Lead Author              |       20 |
 principal_author         | Principal Author         |       30 |
 primary_author           | Primary Author           |       40 |
 secondary_author         | Secondary Author         |       50 |
 contributing_author      | Contributing Author      |       60 |
 author                   | Author                   |       70 |
 contributing_editor      | Contributing Editor      |       73 |
 executive_editor         | Executive Editor         |       74 |
 editor                   | Editor                   |       75 |
 coordinator              | Coordinator              |       78 |
 data_producer            | Data Producer            |       80 |
 data_archive             | Data Archive             |       90 |
 funding_agency           | Funding Agency           |      100 |
 distributor              | Distributor              |      110 |
 host                     | Host                     |      120 |
 scientist                | Scientist                |      130 |
 analyst                  | Analyst                  |      140 |
 graphic_artist           | Graphic Artist           |      150 |
 point_of_contact         | Point of Contact         |      160 |
 advisor                  | Advisor                  |      170 |
 engineer                 | Engineer                 |      190 |
 manager                  | Manager                  |      200 |
 lead_agency              | Lead Agency              |      300 |
 contributing_agency      | Contributing Agency      |      310 |
 publisher                | Publisher                |      500 |
 contributor              | Contributor              |      999 |
(28 rows)

And here is the order by most often used:

gcis=# select count(*) as num, role_type_identifier from contributor group by role_type_identifier ORDER BY num DESC;
  num  |   role_type_identifier
-------+--------------------------
 15297 | author
  1097 | point_of_contact
   822 | editor
   408 | contributing_author
   378 | publisher
   348 | funding_agency
   312 | lead_author
   244 | distributor
   181 | contributor
   136 | host
   107 | data_archive
   100 | convening_lead_author
    84 | scientist
    75 | advisor
    56 | contributing_agency
    54 | data_producer
    26 | coordinating_lead_author
    25 | primary_author
    14 | analyst
    13 | graphic_artist
    12 | executive_editor
    11 | lead_agency
     7 | coordinator
     5 | principal_author
     2 | engineer
     1 | manager
(26 rows)

How would you like me to update the sort_order?

lomky commented 6 years ago

We just discovered this is editable by the data manager! Yay!

amruelama commented 6 years ago

Rearranged roles by the preferred sort order.