media licensing

[dustymc]

Status

Discussed and unanimously approved by AWG, this is now a data cleaning issue. Please assign a legal document license to all Media which you control. Request data or updates below; we are happy to help in any way we can.

Update

2025-02-27: AWG unanimous supports updating anything with a noncompliant licese to "Copyright Restricted". I'll stash 'old' data here and do that whenever the specific update requests slow down.

Acceptable Licenses

       display        |                        uri                         
----------------------+----------------------------------------------------
 Copyright Restricted | https://www.loc.gov/duplicationservices/copyright/
 CC0                  | https://creativecommons.org/publicdomain/zero/1.0
 CC BY                | https://creativecommons.org/licenses/by/3.0
 CC BY-NC-ND          | https://creativecommons.org/licenses/by-nc-nd/3.0
 CC BY-ND             | https://creativecommons.org/licenses/by-nd/3.0
 CC BY-NC             | https://creativecommons.org/licenses/by-nc/3.0
 CC BY-NC-SA          | https://creativecommons.org/licenses/by-nc-sa/3.0
 CC BY-SA             | https://creativecommons.org/licenses/by-sa/3.0

Spreadsheet

A spreadsheet that might help with some decisions is available. It includes raw URLs so can't be made public, let @dustymc or @mkoo know if you'd like access.

• new data at tab temp_funky_license_media_20250224
• Too many records won't load, the "full" data are heavily truncated, please ask if you need something

---

Old Stuff & Details

Coming from

https://github.com/ArctosDB/internal/issues/363
#7348

Should we require media licensing, and if not can we document what a NULL license means?

FWIW I believe that nearly everyone will view unlicensed media as free for the taking, no matter what we might decide or hope for.

The code table is https://arctos.database.museum/info/ctDocumentation.cfm?table=ctmedia_license

(Not entirely related, I have trouble understanding how many of those are 'licenses' - eg https://www.uaf.edu/museum/collections/fineart/collection/image-use-requests/ tells me how to ask for media, but if I'm coming from media I've already found that so ??????)

Current status:

select 
    coalesce(display,'NO LICENSE!!') display,
    count(*) c
from
    media
    left outer join ctmedia_license on media.media_license_id=ctmedia_license.media_license_id
group by display
order by count(*) desc;
            display            |   c    
-------------------------------+--------
 NO LICENSE!!                  | 531679
 CC BY-NC-ND                   | 140005
 CC BY-NC-SA                   | 115528
 CC BY-NC                      | 113257
 CC BY                         |  70309
 Arctos Data Ownership and Use |  53276
 UCM Image Reproduction Policy |  12623
 DMNS                          |   7424
 JSNM Acceptable Use           |   7144
 CC0                           |   5910
 UAMN Fine Arts Image Use      |   4343
 CC BY-SA                      |    592
 Copyright Restricted          |    579
 CC BY-ND                      |      6

[dustymc]

AWG meeting

• require license (unanimous approval) (move FKEY to https://arctos.database.museum/info/ctDocumentation.cfm?table=ctdata_license)
• new issue for 'terms' (use https://arctos.database.museum/info/ctDocumentation.cfm?table=ctcollection_terms, probably needs some additions)
• new issue for 'cite this thusly' (unless we already have one??)

[dustymc]

Summary of record-linked unlicensed media if anyone wants to get started on cleanup:

temp_unlicensed_media_summary.csv.zip

[dustymc]

@Jegelewicz

temp_unlicensed_media_uwbm.csv.zip

[campmlc]

@dustymc can I request the same list of just the image or audio media only for all MSB collections?

[dustymc]

@campmlc here's 'MSB:%'; I'll let you decide how to sort them.

temp_unlicensed_media_msb.csv.zip

[Jegelewicz]

@dustymc what about everything with a license of Arctos Data Ownership and Use, which isn't really a license? Can I get a list of those for all UWBM collections?

[dustymc]

Here's a full all-collection, all-license summary report:

temp_media_license_summary.csv.zip

Arctos Data Ownership and Use, which isn't really a license? Can I get a list of those for all UWBM collections

temp_licensed_media_uwbm_Arctos.csv.zip

(FYI someone seems to have been using pdf for everything, that will break tools.)

[dustymc]

I put together a spreadsheet that might help with some decisions. It includes raw URLs so can't be made public, let me know here if you'd like access.

[dustymc]

Shared spreadsheet link with @Jegelewicz @campmlc - please make sure those data stay confidential. You've probably already fixed some things, and it's very possible that I've not been able to find who 'owns' media that you'll recognized or even misattributed something.

[Jegelewicz]

Yep - I think the data in that sheet is stale.

[dustymc]

Fresh data in tab in spreadsheet, 20250224 summary:

  collection  |   c    
--------------+--------
 ALMNH:Bird   |      1
 ALMNH:EH     |    311
 ALMNH:Ento   |   1198
 ALMNH:ES     |      3
 ALMNH:Geo    |     21
 ALMNH:Inv    |      5
 ALMNH:Mamm   |     83
 ALMNH:Paleo  |     32
 APSU:Herp    |    326
 ASNHC:Bird   |      3
 ASNHC:Mamm   |     20
 BYU:Bird     |   2085
 BYU:Edu      |   1801
 BYU:Herp     |     25
 BYUObs:Herp  |    696
 CHAS:AV      |      1
 CHAS:Egg     |      4
 CHAS:Ento    |      3
 CHAS:Herp    |      1
 CHAS:Inv     |     23
 CHAS:Mamm    |     21
 CHAS:Teach   |      9
 DGR:Mamm     |     18
 DMNS:Bird    |   2729
 DMNS:Egg     |     17
 DMNS:Herp    |     74
 DMNS:Inv     |   2340
 DMNS:Mamm    |   2365
 DMNS:Para    |      7
 HMCM:Herb    |      2
 HSUVM:Mamm   |    390
 HWML:Para    |  30956
 JSNM:Egg     |   1206
 JSNM:Herb    |    994
 JSNM:Paleo   |   4951
 KNWR:Ento    |    556
 KNWR:Herb    |    139
 KNWR:Inv     |      9
 KNWRObs:Herb |      1
 KSB:Mamm     |     50
 KWP:Ento     |      2
 MLZ:Bird     |      1
 MSB:Bird     |    173
 MSB:DGR      |      1
 MSB:Herp     |    103
 MSB:Host     |      7
 MSB:Mamm     |   7306
 MSBObs:Herp  |     11
 MSB:Para     |   3666
 MVZ:Arch     |     10
 MVZ:Bird     |    927
 MVZ:Egg      |     15
 MVZ:Fish     |     18
 MVZ:Herp     |   1731
 MVZ:Mamm     |    693
 MVZObs:Fish  |      2
 NMMNH:Inv    |      8
 NMMNH:Paleo  |     16
 NMU:Mamm     |      1
 NMU:Para     |      6
 OWU:Amph     |      4
 OWU:Bird     |     23
 OWU:ES       |    277
 OWU:Mamm     |      1
 OWU:Rept     |      2
 TCDGM:Paleo  |      8
 TCDGM:Rock   |      1
 UAM:Arc      |   2419
 UAM:Art      |   4363
 UAMb:Herb    |  97902
 UAM:Bird     |    294
 UAM:EH       |    375
 UAM:Ento     |    216
 UAM:ES       |    139
 UAM:Fish     |    558
 UAM:Herb     | 412824
 UAM:Herp     |     20
 UAM:Inv      |     29
 UAM:Mamm     |   3220
 UAMObs:Bird  |    205
 UAMObs:EH    |      6
 UAMObs:Ento  |    282
 UAMObs:Fish  |     22
 UAMObs:Mamm  |    323
 UA:Paleo     |     67
 UCM:Bird     |      9
 UCM:Fish     |      2
 UCM:Herp     |     39
 UCM:Mamm     |    110
 UCM:Obs      |      3
 UMNH:Bird    |     65
 UMNH:Herp    |     56
 UMNH:Mamm    |   1427
 UMNH:Teach   |      1
 UMZM:Bird    |      1
 UMZM:Mamm    |      5
 UNM:Paleo    |    249
 UNR:Mamm     |     12
 UTEP:Arc     |      2
 UTEP:Bird    |      3
 UTEP:Ento    |     11
 UTEP:ES      |    262
 UTEP:Herb    |     17
 UTEP:Herp    |      3
 UTEP:Mamm    |     15
 UTEPObs:Ento |      2
 UTEPObs:Herp |    126
 UWBM:Herp    |      1
 UWBM:Mamm    |      3
 UWYMV:Bird   |    129
 UWYMV:Herp   |     11
 UWYMV:Mamm   |    210
              |   5447

[ewommack]

What is this table showing us? I'm not sure what 11 UWYMV:Herps this is showing... The numbers do not match up with what I understand our collection should have.

[dustymc]

What is this table showing us?

A summary of...

The numbers do not match up with what I understand our collection should have.

They probably won't, this is me struggling to make connections with limited information; ignore it if it's not useful.

[mkoo]

@ewommack this is for an agenda topic for AWG this week-- unlicensed media that collections can opt for help to comply with media requirements to have a license.

[ewommack]

Yes I understand that is what the issue is about. My confusion is the numbers in the table don't match up with what I understand our collections should have for unlicensed media.

I was worried, but I can't use the data to find or fix anything, but it looks like it relates to @dustymc trying to figure out what he can actually get to. I'll ignore it for now.

The numbers do not match up with what I understand our collection should have.

They probably won't, this is me struggling to make connections with limited information; ignore it if it's not useful.

[dustymc]

@ewommack the spreadsheet failed (badly) as importing the whole problem recordset, I pulled out what I think are uwymv into a new tab.

[dustymc]

done