Wikidata:WikiProject Northern Cemetery Stockholm Q252312
This page is a work in progress, not an article or policy, and may be incomplete and/or unreliable.
Please offer suggestions on the talk page. বাংলা | català | čeština | Deutsch | English | español | فارسی | suomi | français | हिन्दी | magyar | italiano | 日本語 | 한국어 | Lëtzebuergesch | latviešu | македонски | Bahasa Melayu | မြန်မာဘာသာ | norsk bokmål | Nederlands | ਪੰਜਾਬੀ | polski | پنجابی | português | português do Brasil | română | Scots | shqip | slovenščina | српски / srpski | svenska | Türkçe | русский | українська | 中文(简体) | +/− |
The goal of this WikiProject is to document people in Wikipedia/Wikidata that are buried at the Northern Cemetery Stockholm Q252312 and make a visit to the cemetery a more interesting experience.
Status edit
Map buried on Northern Cemetery with coordinates edit
#defaultView:Map
SELECT distinct ?item ?itemLabel ?itemDescription ?graveplot ?coord ?placeofBurial ?imgGrave ?img WHERE {
?item wdt:P119 wd:Q252312 .
?item p:P119 ?placeofBurial .
MINUS { ?item wdt:P1442 ?imgGrave }
OPTIONAL { ?placeofBurial pq:P965 ?graveplot}
OPTIONAL { ?placeofBurial pq:P625 ?coord}
OPTIONAL { ?item pq:P18 ?img}
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv" }
}
List buried on Northern Cemetery with no picture of grave edit
See Wikipedia:sv:Användare:Salgo60/Önskemål_om_bilder/Sverige/Norra_Begravningsplatsen
Resources available edit
Online edit
- SvenskaGravar.se
- gravplatsnummer/ID Property:P965
- start time Property:P580 - lesson lerned better than Property:P585 as most graves will have an end time
- end time Property:P582
- No GPS position
- supports Wikipedia:URI to a grave ex. Alfred Nobel is 45613868
- Hitta graven is a site with most of the graves in a database. It contains
- geografiska koordinater Property:P625
- gravplatsnummer/ID Property:P965
- start time Property:P580
- end time Property:P582
- location Property:P625
- no supports for Wikipedia:URI to a grave
- use this URL to find locations https://etjanst.stockholm.se/Hittagraven/ajax/search?SearchText=K%C3%A5re%20Fr%C3%B6ier&Page=1&Size=500
Romersk-katolska församlingens begravningsplats Q28007201 edit
- Där publiceras alla gravsatta som finns i vårt register med namn och födelse- och dödsdatum' see www.katolskakyrkogarden.se
- see also book Q28030843 page 186 has some people
Mosaiska kyrkogården Norra begravningsplatsen Q28007260 edit
Missing online sources. Q28030843 page 187 has some people
Norra begravningsplatsens minneslund Q28006122 edit
- See SvenskaGravar and Hittagraven
- see also book Q28030843 page 186 has some people
Books edit
- Q28030843 Kungliga och Norra begravningsplatserna - Karl Axel Björnberg ISBN 91 88016-69 2
To Do edit
- Register all people with Wikidata objects and buried on Northern Cemetery.
- Map people on the page Kändisar
- Status: Nearly all linked
- People with category Gravsatta_på_Norra_begravningsplatsen_i_Stockholm
9741474- Status: Unknown see also Wikipedia Bybrunnen
- Map people on the page Kändisar
- Register references to SvenskaGravar.se see also FB about what proberties to use
- Photos of graves
- Önskemål om bilder Norra Begravningsplatsen
- Status: see map
- Önskemål om bilder Norra Begravningsplatsen
- Register references to books
- Kungliga och Norra begravningsplatserna - Karl Axel Björnberg Q28030843 What links here
- Svenskt Biografiskt lexikon Q379406 SBL
- SBL has a property Property:P3217 see Constraints Report
- Create a template for SvenskaGravar
Queries edit
Create a query page for the cemetery. Examples of queries
- All people on the cemetery
- All people on the cemetery display picture/picture gravestone/map and group them on
- Gender
- Time period
- Occupation
- All people on the cemetery with no picture of the graves
- Timeline with the people on the cemetery and some different filter options
- Occupation
- Nationality
- Born in Country
- Time period
- Prime ministers
- Nobel price winners
- All people awarded yyy
- All nobel family xxx
- All royal families
- All people part of party xxx
- Find all objects created by people on the cemetery
- Spatial search and query to see all the gravestones next to my current position
- All people on the cemetery with a Spotify Artist id
Maintenance queries SPARQL edit
Norra Begravningsplatsen is Q252312 it has parts
- Garden of Remembrance - Minneslund Q28006122
- Romersk-katolska församlingens begravningsplats Q28007201
- Mosaiska kyrkogården Norra begravningsplatsen Q28007260
- Norra krematoriet Q31748331
sv Wikipedia has category [Kategori:Gravsatta_på_Norra_begravningsplatsen_i_Stockholm]
All people with graves on Q252312 edit
The following query uses these:
- Items: Norra begravningsplatsen (Q252312) , Mosaic Cemetery, Northern Cemetery (Q28007260) , Catholic cemetery, Northern cemetery (Q28007201) , Garden of Remembrance, Norra Begravningsplatsen (Q28006122) , Q31748331, human (Q5)
- Properties: instance of (P31) , place of burial (P119)
SELECT DISTINCT ?person ?personLabel ?personDescription ?cemeteryLabel WHERE { VALUES ?cemetery { wd:Q252312 # Norra Begravningsplatsen wd:Q28007260 # Mosaiska församlingen wd:Q28007201 # Romersk katolska wd:Q28006122 # Rememberance wd:Q31748331 # Norra krematoriet } ?person wdt:P31 wd:Q5; wdt:P119 ?cemetery; SERVICE wikibase:label { bd:serviceParam wikibase:language "sv","en","de". } }
Number of people with graves on Q252312 and its parts edit
The following query uses these:
- Properties: Dictionary of Swedish National Biography ID (P3217) , occupation (P106)
select ?occupationLabel (count(?subj) as ?nr) { {?subj wdt:P3217 ?SBLID} # Beskrivna i SBL minus {?subj wdt:P106 ?occupation} SERVICE wikibase:label { bd:serviceParam wikibase:language "sv","en","no","da","de","pl"} } Group by ?occupationLabel order by desc(?nr)
Map of graves on Q252312 with no pictures of the grave Property:P1442 edit
The following query uses these:
- Properties: place of burial (P119) , image of grave (P1442) , burial plot reference (P965) , coordinate location (P625) , image (P18)
Features: map (Q24515275)
#defaultView:Map
SELECT distinct ?item ?itemLabel ?itemDescription ?graveplot ?coord ?placeofBurial ?imgGrave ?img WHERE {
?item wdt:P119 wd:Q252312 .
?item p:P119 ?placeofBurial .
MINUS { ?item wdt:P1442 ?imgGrave }
OPTIONAL { ?placeofBurial pq:P965 ?graveplot}
OPTIONAL { ?placeofBurial pq:P625 ?coord}
OPTIONAL { ?item pq:P18 ?img}
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv" }
}
Graves with grave picture
The following query uses these:
- Properties: place of burial (P119) , image of grave (P1442) , burial plot reference (P965) , coordinate location (P625) , image (P18)
Features: map (Q24515275)
#defaultView:Map
SELECT distinct ?item ?itemLabel ?itemDescription ?graveplot ?coord ?placeofBurial ?imgGrave ?img WHERE {
?item wdt:P119 wd:Q252312 .
?item p:P119 ?placeofBurial .
{ ?item wdt:P1442 ?imgGrave }
OPTIONAL { ?placeofBurial pq:P965 ?graveplot}
OPTIONAL { ?placeofBurial pq:P625 ?coord}
OPTIONAL { ?item pq:P18 ?img}
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv" }
}
Graves with missing picture of the person
The following query uses these:
- Properties: place of burial (P119) , image of grave (P1442) , burial plot reference (P965) , coordinate location (P625) , image (P18)
SELECT distinct ?item ?itemLabel ?itemDescription ?graveplot ?coord ?placeofBurial ?imgGrave ?img WHERE { ?item wdt:P119 wd:Q252312 . ?item p:P119 ?placeofBurial . OPTIONAL { ?item wdt:P1442 ?imgGrave } OPTIONAL { ?placeofBurial pq:P965 ?graveplot} OPTIONAL { ?placeofBurial pq:P625 ?coord} MINUS { ?item pq:P18 ?img} SERVICE wikibase:label { bd:serviceParam wikibase:language "sv" } }
Graves with missing coordinates
The following query uses these:
- Properties: place of burial (P119) , image of grave (P1442) , burial plot reference (P965) , coordinate location (P625) , image (P18)
SELECT distinct ?item ?itemLabel ?itemDescription ?graveplot ?coord ?placeofBurial ?imgGrave ?img WHERE { ?item wdt:P119 wd:Q252312 . ?item p:P119 ?placeofBurial . OPTIONAL { ?item wdt:P1442 ?imgGrave } OPTIONAL { ?placeofBurial pq:P965 ?graveplot} MINUS { ?placeofBurial pq:P625 ?coord} OPTIONAL { ?item pq:P18 ?img} SERVICE wikibase:label { bd:serviceParam wikibase:language "sv" } }
References used for Property:119 cemetery Q252312 edit
Check if there is either reference-URL Property:P854 or Stated In Property:P248
The following query uses these:
- Properties: has part(s) (P527) , instance of (P31) , place of burial (P119) , image of grave (P1442) , reference URL (P854) , stated in (P248)
SELECT distinct ?cemeteryLabel ?person ?personLabel ?statement ?refURL ?refStatedIn ?imggrave{ wd:Q252312 wdt:P527 ?cemeteryPart. # Norra Begravningsplatsen has parts ?person wdt:P31 wd:Q5. {?person wdt:P119 ?cemeteryPart} UNION {?person wdt:P119 wd:Q252312} ?person wdt:P119 ?cemetery . ?person p:P119 ?statement . OPTIONAL {?statement prov:wasDerivedFrom ?ref . ?ref pr:P854 ?refURL} OPTIONAL {?statement prov:wasDerivedFrom ?ref . ?ref pr:P248 ?refStatedIn} OPTIONAL {?person wdt:P1442 ?imggrave} SERVICE wikibase:label { bd:serviceParam wikibase:language "sv","en" } }
Missing reference for Property:119 cemetery Q252312 edit
The following query uses these:
- Properties: has part(s) (P527) , instance of (P31) , place of burial (P119) , image of grave (P1442) , reference URL (P854) , stated in (P248)
SELECT distinct ?cemeteryLabel ?person ?personLabel ?statement ?imggrave{ wd:Q252312 wdt:P527 ?cemeteryPart. # Norra Begravningsplatsen has parts ?person wdt:P31 wd:Q5. {?person wdt:P119 ?cemeteryPart} UNION {?person wdt:P119 wd:Q252312} ?person wdt:P119 ?cemetery . ?person p:P119 ?statement . OPTIONAL {?statement prov:wasDerivedFrom ?ref . ?ref pr:P854 ?refUsed} OPTIONAL {?statement prov:wasDerivedFrom ?ref . ?ref pr:P248 ?refUsed} OPTIONAL {?person wdt:P1442 ?imggrave} SERVICE wikibase:label { bd:serviceParam wikibase:language "sv","en" } FILTER (!Bound(?refUsed)) }
Maintenance queries PETSCAN edit
- People with Category Norra Begravningsplatsen on svWiki
- People with Category but not Wikidata cemetery = 5
- People with Wikidata but not Category for cemetery
- People with Wikidata Q252312 but not Category = 45
- People with Wikidata Q28006122 but not Category = 0
- People with Wikidata Q28007201 but not Category = 3
- People with Wikidata Q28007260 but not Category = 0
- Missing source reference in Wikidata = 24
Activities outside Wikidata edit
- Speak with Hitta graven
- to get better URI to graves
- Status update 20170301 looks like using SvenskaGravar.se gives as a Wikipedia:URL to the grave
- the hittagraven Website changed 2016 so old URLs to a grave doesnt work
- Status 20170301 looks we start use SvenskaGravar.se as it supports Wikipedia:URLs to the grave
- HittaGraven has nice maps of the cemetery with all the graves marked and the selected grave marked that would add value
- see if the list famous people with links to Wikipedia could also maybe use Wikidata
- Try see if the app SuperLachaise can be used
- Using Street Map for mapping graves on a map
- View info about the graves on Open Burial Map