FactGrid:PAMCommercialLabels
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.
The PAM archives are preserved at the Centre de recherche bretonne et celtique (CRBC) in Brest (France).
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
Project members : Jean-Baptiste Pressac, Marie-Alice Le Corvec, Liliane Jaouen and Florent Miane.
Données créées dans le cadre de ce projet / Data created by the project
Bonnes pratiques de saisie dans FactGrid
Une fois validées, les données de type étiquette, personne, collectif, sont associées au projet : Saisie de Property:P131 = Item:Q648370.
Temps passé à la vérification :
- 2h le 8 janvier 2023.
Étiquettes
- Les étiquettes doivent être instance de Item:Q453647 et d'une sous-classe de Item:Q516124
- Si le graphisme de l'étiquette est abstrait, saisir aussi Property:P991 = 0 (ex. Item:Q701890)
- Labels :
- Mettre des espaces entre les valeurs et les unités de mesure. Ex. 100 ml et non pas 100ml.
- Pour distinguer des étiquettes dont le texte est similaire mais avec des variantes telles que impression en mode portrait ou en mode paysage, écrire par ex. "11° / Réserve de l'Hôtel / vin de qualité supérieure / Imp. PAM. Brest." (alternative n°1)
Personnes
Prénom inconnu
- Saisir comme label en anglais et en français : le nom de famille préfixé par N.N. (no name). Par ex. Item:Q636312
- Saisir une Property:P17 = Item:Q21406
Genre inconnu
Saisir une Property:P17 = Item:Q160236
SPARQL Queries for CRBC PAM labels collection
As the queries are currently being written, they are reproduced for the time being without a direct link to the Query service.
Labels in the CRBC PAM (Q636348) inventory
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". } }
SELECT ?item ?itemLabel WHERE { ?item wdt:P345 wd:Q636348; wdt:P2 wd:Q636311. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } FILTER NOT EXISTS {?item wdt:P131 wd:Q648370.} }
Typefaces
Wine labels and theirs 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
# 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)
Iconclass elements
Wine labels and their Iconclass elements
The URIs of the RDF resource representing the Iconclass elements could not be directly used in the query as those URIs are not encoded in UTF8 for historical reasons (according to Etienne Posthumus). For instance, the URI of 22C4(BROWN) is
https://iconclass.org/22C4%28BROWN%29
.
# PAM Wine labels and theirs Iconclass elements (ICE) SELECT ?item ?itemLabel (GROUP_CONCAT(DISTINCT ?ICEpreflabel; SEPARATOR = " / ") AS ?ICEpreflabels) (GROUP_CONCAT(DISTINCT ?ICE_IRI; SEPARATOR = " / ") AS ?ICE_IRIs) WHERE { ?item wdt:P345 wd:Q636348. OPTIONAL { ?item wdt:P991 ?ICE_notation. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } BIND(URI(CONCAT("http://iconclass.org/", ?ICE_notation)) AS ?ICE_IRI) SERVICE <https://iconclass.org/sparql> { SELECT * WHERE { ?ICE skos:notation ?ICE_notation; skos:prefLabel ?ICEpreflabel. } } } GROUP BY ?item ?itemLabel
Most used Iconclass elements (ICE)
# Most used Iconclass elements (ICE) SELECT ?ICEpreflabel ?ICE_notation (COUNT(*) AS ?nbr) WHERE { ?item wdt:P345 wd:Q636348. OPTIONAL { ?item wdt:P991 ?ICE_notation. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } SERVICE <https://iconclass.org/sparql> { SELECT * WHERE { ?ICE skos:notation ?ICE_notation; skos:prefLabel ?ICEpreflabel. } } } GROUP BY ?ICEpreflabel ?ICE_notation ORDER BY DESC (?nbr)
Commissioners and their locations
Commissioners and their locations (use map display)
# Commissioners should have many locations SELECT ?item ?itemLabel ?commissioner ?commissionerLabel (SAMPLE(?localization) AS ?localization) (SAMPLE(?localizationLabel) AS ?localizationLabel) (SAMPLE(?coordinates) AS ?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". } } GROUP BY ?item ?itemLabel ?commissioner ?commissionerLabel
Queries in project
- Other printers than PAM