FactGrid:PAMCommercialLabels: Difference between revisions
Line 9: | Line 9: | ||
=== Personnes === | === 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 comme label en anglais et en français : le nom de famille préfixé par N.N. (no name). Par ex. [[Item:Q636312]] | ||
# Saisir | # Saisir une [[Property:P17]] = [[Item:Q21406]] | ||
Genre non connu : | |||
Saisir une [[Property:P17]] = [[Item:Q160236]] | |||
== SPARQL Queries for CRBC PAM labels collection == | == SPARQL Queries for CRBC PAM labels collection == |
Revision as of 10:57, 22 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
Bonnes pratiques de saisie
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 non connu :
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.
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