FactGrid:PAMCommercialLabels: Difference between revisions
Jump to navigation
Jump to search
No edit summary Tag: Manual revert |
|||
Line 5: | Line 5: | ||
Published introductory research : [https://www.univ-brest.fr/crbc/menu/%C3%89ditions+du+CRBC/Collection+Collectif/Image---Commerce-de-la-fin-du-XIXe-siecle-a-nos-jours Image & Commerce de la fin du XIXe siècle à nos jours, dir. Maryse Cuzon, Philippe Jarnoux, Marie-Michèle Lucas & Florent Miane] | Published introductory research : [https://www.univ-brest.fr/crbc/menu/%C3%89ditions+du+CRBC/Collection+Collectif/Image---Commerce-de-la-fin-du-XIXe-siecle-a-nos-jours Image & Commerce de la fin du XIXe siècle à nos jours, dir. Maryse Cuzon, Philippe Jarnoux, Marie-Michèle Lucas & Florent Miane] | ||
== SPARQL Queries for CRBC PAM | == SPARQL Queries for CRBC PAM labels collection == | ||
=== Wine labels in the CRBC PAM (Q636348) inventory === | === Wine labels in the CRBC PAM (Q636348) inventory === |
Revision as of 15:52, 14 November 2023
The PAM Commercial Labels project aims at studying the visual representations produced according to customers's demands by the Papeteries Armoricaines et Morlaisiennes (PAM). The PAM was an important printing house located in Brest (Finistère, France). Started at the end of the 1920s, it ran for nearly a century and specialized in producing original commercial labels for shopkeepers based mainly in Brittany.
Published introductory research : Image & Commerce de la fin du XIXe siècle à nos jours, dir. Maryse Cuzon, Philippe Jarnoux, Marie-Michèle Lucas & Florent Miane
SPARQL Queries for CRBC PAM labels collection
Wine labels in the CRBC PAM (Q636348) inventory
SELECT ?item ?itemLabel WHERE { ?item wdt:P345 wd:Q636348; wdt:P2 wd:Q636311. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Typefaces
# Wine labels and theirs typefaces SELECT ?item ?itemLabel (GROUP_CONCAT(?policeLabel; SEPARATOR = " / ") AS ?policesLabels) WHERE { ?item wdt:P345 wd:Q636348. OPTIONAL { ?item wdt:P748 ?police. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?police rdfs:label ?policeLabel. ?item rdfs:label ?itemLabel. } } GROUP BY ?item ?itemLabel
# Typefaces and number of wine labels using them # For the labels trick, see https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial#wikibase:Label_and_aggregations SELECT ?typefaceLabel ?typeface (COUNT(?typeface) AS ?nbr) WHERE { ?item wdt:P345 wd:Q636348; wdt:P2 wd:Q636311. OPTIONAL { ?item wdt:P748 ?typeface. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?typeface ?typefaceLabel ORDER BY DESC (?nbr)
Commissioners and their locations
SELECT ?item ?itemLabel ?commissioner ?commissionerLabel ?localization ?localizationLabel ?coordinates WHERE { ?item wdt:P345 wd:Q636348; wdt:P2 wd:Q636311; wdt:P273 ?commissioner. ?commissioner wdt:P47 ?localization. ?localization wdt:P48 ?coordinates . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Queries in project :
- Other printers than PAM