FactGrid:PAMCommercialLabels: Difference between revisions

From FactGrid
Jump to navigation Jump to search
Line 24: Line 24:
=== Wine labels in the CRBC PAM (Q636348) inventory ===
=== Wine labels in the CRBC PAM (Q636348) inventory ===


[https://tinyurl.com/yl6ooqry]
[https://tinyurl.com/yl6ooqry Wine labels in the CRBC PAM (Q636348) inventory]


<pre>
<pre>

Revision as of 14:09, 22 November 2023

1699958919516.jpg

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

  1. Saisir comme label en anglais et en français : le nom de famille préfixé par N.N. (no name). Par ex. Item:Q636312
  2. 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
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 :

  1. Other printers than PAM