Question: Is there a way to connect the object table to the published images?

NationalGalleryOfArt / opendata

The National Gallery of Art Open Data Program

https://www.nga.gov/open-access-images/open-data.html

Creative Commons Zero v1.0 Universal

358 stars 64 forks source link

Question: Is there a way to connect the object table to the published images? #14

Closed JohnENoonan closed 8 months ago

JohnENoonan commented 8 months ago

Hello everyone, thank you for this awesome resource! I'm trying to find out if there is a way to connect an art object to its published images. Based on the data documentation it seems that the published images tables has no shared keys with any other table. Is it possible to get the URL of the public domain images for a given object?

Thanks!

beaudet commented 8 months ago

Thank you for the feedback John.

Yes, you can join the tables (not indicated on the diagram I'm afraid) like this: published_images.depictstmsobjectid = objects.jobjectid

JohnENoonan commented 8 months ago

Thanks @beaudet! This is great.