FactGrid:PAMCommercialLabels: Difference between revisions
No edit summary |
|||
Line 7: | Line 7: | ||
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] | ||
== Bonnes pratiques de saisie == | == Bonnes pratiques de saisie dans FactGrid == | ||
=== Personnes === | === Personnes === |
Revision as of 14:28, 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.
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
Bonnes pratiques de saisie dans FactGrid
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.
Wine labels in the CRBC PAM (Q636348) inventory
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
# 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)
Commissioners and their locations
Commissioners and their locations (use map display)
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