search

eamena-project / eamena-arches-dev

development repository of the EAMENA Arches-powered database platform
https://eamena.org/home
GNU Affero General Public License v3.0
5 stars 3 forks source link

EAMENA <-> ResourceSpace photographs #56

Open zoometh opened 2 months ago

zoometh commented 2 months ago

Join EAMENA's Information Resources and ResourceSpace Image Server

This topic is relevant for the CoD, EMHE, APAAME projects and any projects that need to add photographs/images in the Information Resources (IR)

zoometh commented 2 months ago

Test

<img data-bind="attr: { src: src, alt: alt }" src="https://apaame.arch.ox.ac.uk/?r=48819&amp;k=784b31b1a2" alt="">

img-name

Audit

Grouped by types of repository (Flickr, AWS S3, etc.), totals of photographs are:

img_url count
0 https://live.staticflickr.com/ 116745
1 https://eamena-uploads-v2.s3.a 2071
2 https://eamena-media.s3.amazon 541
3 https://eamena-media.s3.eu-wes 26
4 /files/b43a7f50-d532-11ec-b91a 2
5 /files/8761035b-11fc-45ce-a4cb 2
6 https://apaame.arch.ox.ac.uk/p 1
7 /files/601bc682-2d7f-44af-9f23 1
8 /files/e102ac38-fbab-4ea8-b113 1

Examples by decreasing number of photograhs for the 4th main repos (✅: displayed; ❌: not displayed)

https://live.staticflickr.com

ir_id information_id catalog_id img_url
0 00012dab-00cf-4cf1-90b5-d09c5cf3c6d6 INFORMATION-0090288 APAAME_20091008_KRH-0062 https://live.staticflickr.com/7559/15976540576_f78c5c5355_o_d.jpg
1 0002dce4-8a0b-4eb4-908f-92ec2eff8fa8 INFORMATION-0101891 APAAME_20100516_RHB-0082 https://live.staticflickr.com/4013/4616248328_0610d38320_o_d.jpg
2 00030cf8-6a42-46d8-9542-ba6c42b06772 INFORMATION-0095691 APAAME_20181017_RHB-0098 https://live.staticflickr.com/1923/45408035381_012a36622f_o_d.jpg
❌ 000348ec-dd61-48bb-97be-6ca6677d5fbe INFORMATION-0110777 APAAME_20101021_KRH-0050 https://live.staticflickr.com/1244/5135603365_88730e84ef_o_d.jpg
❌ 00043464-0e2b-478b-b7fa-f957575bcf1e INFORMATION-0075120 APAAME_20170927_MND-0067 https://live.staticflickr.com/4443/36914020933_9abbd87dbd_o_d.jpg
Known issues

Currently in EAMENA, in the IR, under the menu 'File Upload', paths to images are wrong. For example, with INFORMATION-0052511[^1], we have currently:

img-name
Current Flickr path: `https:/live.staticflickr.com/4118/4928802850_49ed2fdbcb_o_d.jpg` in the [Flickr archive](https://www.flickr.com/photos/apaame/collections)

Should be:

img-name
Correct Flickr path: `https://live.staticflickr.com/4118/4928802850_fbab90b8ca_h.jpg`

The path root is the same, https://live.staticflickr.com/4118/4928802850 the difference is between the last digits:
current 49ed2fdbcb_o_d.jpg
correct fbab90b8ca_h.jpg

Hover on the missing image gives this URL

img-name
Hover value is: `database.eamena.org/live.staticflickr.com/4118/4928802850_49ed2fdbcb_o_d.jpg`

Let's consider the Information Resource - INFORMATION-0052511. It has two photographs linked:

img-name
File Upolad

Images paths are hosted here:

img-name
File Upolad. The UUID of the field 'File Upload' is: `c712066a-8094-11ea-a6a6-02e7594ce0a0`

The current link of Information Resource - INFORMATION-0052511 is:

<img data-bind="attr: { src: src, alt: alt }" src="/static/img/photo_missing.png" alt="">

img-name
Photo missing

The correct link (ie, external link) is:

<img data-bind="attr: { src: src, alt: alt }" src="https://live.staticflickr.com/4118/4928802850_fbab90b8ca_h.jpg%60" alt="">

img-name
Flickr photo from its Direct URL/external link

https://eamena-uploads-v2.s3.amazonaws.com

AWS S3 bucket, ⌐ APAAME

ir_id information_id catalog_id img_url
0 00088a67-db92-4f89-b0fe-782244abab49 INFORMATION-0144482 JORDAN_45B-SQN_JordanValley_Run-10_10848 https://eamena-uploads-v2.s3.amazonaws.com/JORDAN_45B-SQN_JordanValley_Run-10_10848.jpg
1 00408a39-ea66-45e8-bc19-b6dac01fd547 INFORMATION-0133262 EGYPT_113C_MATRUH_A13_2056 https://eamena-uploads-v2.s3.amazonaws.com/EGYPT_113C_MATRUH_A13_2056.jpg
2 00602573-d948-41b7-a7db-ce0a43e81263 INFORMATION-0133953 EGYPT_113C_MATRUH_B11_2557 https://eamena-uploads-v2.s3.amazonaws.com/EGYPT_113C_MATRUH_B11_2557.jpg
❌ 009503a5-44e6-4eb7-b6fe-b5cdc9a3b95e INFORMATION-0133675 EGYPT_113C_MATRUH_B5_2724 https://eamena-uploads-v2.s3.amazonaws.com/EGYPT_113C_MATRUH_B5_2724.jpg
❌ 0096c8be-6ff7-44be-89bc-9dc7019bedf6 INFORMATION-0138546 EAMENA-20191008-PF-0274 https://eamena-uploads-v2.s3.amazonaws.com/files/EAMENA-20191008-PF-0274.jpg

https://eamena-media.s3.amazonaws.com/files/

AWS S3 bucket, ⌐ APAAME

ir_id information_id catalog_id img_url
0 001e8ca1-6db8-494a-b647-10502adb07bb INFORMATION-0049668 A View of Petra https://eamena-media.s3.amazonaws.com/files/Petra_AZ.JPG
1 006f6e49-e224-4b9d-bf75-ed679f32b831 INFORMATION-0049921 MAA39920_019_IMG_4528-scr https://eamena-media.s3.amazonaws.com/files/MAA39920_019_IMG_4528-scr.jpg
2 006f6e49-e224-4b9d-bf75-ed679f32b831 INFORMATION-0049921 Manar al-Athar 39920 https://eamena-media.s3.amazonaws.com/files/MAA39920_019_IMG_4528-scr.jpg
❌ 012d43ed-70a3-48ca-9169-4c16bd228287 INFORMATION-0086786 JW_20182302_Lehun_00025 https://eamena-media.s3.amazonaws.com/files/Lehun25Compressed.JPG
❌ 0268f4ce-b5c6-483c-843a-89df4e554d95 INFORMATION-0050835 PF_20170917_SmarJbail_00037 https://eamena-media.s3.amazonaws.com/files/PF_20170917_SmarJbail_00037.JPG

https://eamena-media.s3.eu-west-2.amazonaws.com/uploadedfiles/

AWS S3 bucket, ⌐ APAAME

ir_id information_id catalog_id img_url
0 024a72cb-575a-404a-b3ab-e8dd028e6513 INFORMATION-0144919 APAAME_20180215_RHB-0323 https://eamena-media.s3.eu-west-2.amazonaws.com/uploadedfiles/50953259052_a00cf75618_o.jpg
1 07b8ecdd-21d3-44d4-b1f1-0f0271e29310 INFORMATION-0104660 APAAME_20100601_DLK-0413 https://eamena-media.s3.eu-west-2.amazonaws.com/uploadedfiles/4907651170_11c6ef62d9_c.jpg
2 0999896c-d5f6-4ed6-9410-06b108e6397f INFORMATION-0144920 APAAME_20180215_RHB-0350 https://eamena-media.s3.eu-west-2.amazonaws.com/uploadedfiles/50729348183_b255e5f50a_o.jpg
❌ 0f7d56e4-df54-419f-b7ba-34f67d65bb14 INFORMATION-0104667 APAAME_20100516_SES-0014 https://eamena-media.s3.eu-west-2.amazonaws.com/uploadedfiles/4615505613_a30287b8d6_o.jpg
❌ 2130fc3d-63f4-465c-8283-acf56c78d1d2 INFORMATION-0144797 Unknown https://eamena-media.s3.eu-west-2.amazonaws.com/uploadedfiles/36671359_1207660499368407_9199987662209941504_o.jpg
zoometh commented 2 months ago

With INFORMATION-0150090 = e17bca9d-77c5-4ec7-9ff7-971d4e1ee0b6

Return the location of its image:

SELECT tiledata -> 'c712066a-8094-11ea-a6a6-02e7594ce0a0' #>> '{0, url}' AS file_upload FROM tiles 
WHERE tiledata -> 'c712066a-8094-11ea-a6a6-02e7594ce0a0' #>> '{0, url}' IS NOT NULL
AND resourceinstanceid::text LIKE 'e17bca9d-77c5-4ec7-9ff7-971d4e1ee0b6'

see: https://github.com/eamena-project/eamena-arches-dev/tree/main/dbs/database.eamena/postgres/queries#apaame-id-of-a-given-ir