[[ http://info.alvin-portal.org/?languageId=1 | About Alvin ]]
{F29593686,width=700}
Objects list of 1000 connected objects https://w.wiki/4r9
* [[ https://w.wiki/5DU | all ]]
* [[ https://w.wiki/4vG | on a map ]]
* [[ https://w.wiki/6$r | most recently deceased ]] according to WD connected profiles
{F29674885,width=600}
* on a [[ https://w.wiki/6hP | map clustered ]]
{F29927832,width=600}
* Wikidata properties on the same objects as Alvin [[ https://w.wiki/5g4 | swedish ]] [[ https://w.wiki/9CX | english ]]
{F29680950,width=600}
* Alvin connected objects [[ https://w.wiki/5g6 | with most articles in different languages in Wikipedia ]]
* List
* [[ https://w.wiki/4rx | SBL and Alvin ]] in WD > ~~900 1030 1070 1113 1192 1294 ~~1371
* [[ https://w.wiki/5gr | SBL but not Alvin connected persons ]] in WD
* [[ https://w.wiki/7QC | Swedish Academy and Alvin ]]
* [[ https://w.wiki/7QJ | Swedish Academy but not Alvin ]] connected persons in WD
* [[ https://w.wiki/7QE | Royal Swedish Academy of Letters member (Vitterhetsakademin) and Alvin ]]
* [[ https://w.wiki/7QG | Royal Swedish Academy of Letters member (Vitterhetsakademin) but not Alvin ]] connected persons in WD
* [[ https://w.wiki/6vr | Harvard index of Botanists ]] > ~~200~~ 323
* [[ https://w.wiki/Aee | Digital Atlas of the Roman Empire]]
* [[ https://w.wiki/4uw | Spotify and Alvin ]]
* [[ https://w.wiki/7T8 | Instagram and Alvin ]]
* [[ https://w.wiki/4uy | SVT Öppet Arkiv and Alvin ]] see also T225394
* minus [[ https://w.wiki/6yt | Alvin duplicates ]] > 120
* [[ https://w.wiki/4xn | Svenskt Porträttarkiv and Alvin ]] a community driven picture site
* [[ https://w.wiki/4xq | Litteraturbanken and Alvin ]] > ~~300~~ 432
* [[ https://w.wiki/4xs | SKBL and Alvin ]] > ~~160~~ 205
* [[ https://w.wiki/8fR | SKBL but not Alvin ]]
* [[ https://w.wiki/4yC | Nationalmuseet and Alvin ]]
* Paintings in Wikipedia [[ https://w.wiki/5gy | painted by people connected to Alvin ]]
* [[ https://w.wiki/4y8 | NAD "personliga arkiv" and Alvin ]] this activity has been done for Swedish Church parishes [[ https://github.com/salgo60/Svenskaforsamlingar | link GITHUB ]] and will maybe be done for personal archives see {T225859}
* [[ https://w.wiki/AYw | NAD but not Alvin ]]
* [[ https://w.wiki/4xo | GENI and Alvin ]]
* [[ https://w.wiki/5H2 | Projekt Runeberg and Alvin ]]
* [[ https://w.wiki/4yA | Levande Musikarv and Alvin ]]
* [[ https://w.wiki/6yv | Twitter and Alvin objects ]] (mostly cities)
* [[ https://w.wiki/6yx | Instagram locations and Alvin ]]
* [[ https://w.wiki/6yz | OSM relations and Alvin ]]
* [[ https://w.wiki/7Kc | The Watercolour World and Alvin ]]
* [[ https://w.wiki/7GZ | Plant Illustrations artist and Alvin
]]
* [[ https://w.wiki/7Gj | missing Alvin ]]
* [[ https://w.wiki/7RG | Bloodhoundracker and Alvin ]]
* [[ https://w.wiki/7Gq | Ant wiki and Alvin ]]
* [[ https://w.wiki/7SD | Dutch Instrument Makers and Alvin ]]
* [[ https://w.wiki/4zb | Gravstensinventeringen and Alvin ]] community driven initiative need more care in Wikidata see [[ http://minancestry.blogspot.com/2018/05/gravstensinventering.html | blogpost ]]
* {T225294} list [[ https://w.wiki/4$q | SMVK people connected with Alvin in Wikidata ]]
* Federation: [[ https://w.wiki/5di | Motivation in en from Nobelprize.org for connected Alvin Nobel prize winners ]] - see also T200668
* [[ https://w.wiki/5dj | same in sv ]]
* Nobelprize winners [[ https://w.wiki/5dT | not connected to Alvin ]]
* FAIRDATA [[ https://t.co/75xOWHuEvh | video at 8min ]]
* Wikidata supports FAIRDATA i.e. you can write a SPARQL query and get all sources. Free Open Data needs good sources for getting trust.
* The problem I see more and more is the lack of FAIRDATA and electronic sources in data distributed. See example of the Nobel prize.org non sourced data that gives mismatch with Wikidata see {T200668} is unsourced Nobelprize info better than Wikidata.... I dont know see one issue with sources that I hope Wikidata can focus on T222142
* [[ https://w.wiki/4xk | Query finding all "Alvin people" with a ref from the Swedish National Archives ]]
* People in category [[ https://sv.wikipedia.org/wiki/Kategori:Ledamöter_av_Royal_Society | Ledamöter_av_Royal_Society ]] but [[ http://petscan.wmflabs.org/?minlinks=&categories=Ledamöter av Royal Society&source_combination=categories NOT sparql&edits[anons]=both&sparql=Select * {?x wdt:P6821 ?y}
&search_max_results=500&ns[0]=1&edits[bots]=both&language=sv&edits[flagged]=both&interface_language=en&active_tab=tab_other_sources&project=wikipedia&&doit= | not in Alvin ]]
{F29554499,width=800}
{F29554844,width=600}
* Map Locations
* [[ https://w.wiki/4vD | Alvin and Riksarkivet TORA ]] (just a few)
* [[ https://w.wiki/AjA | Map places in Wikidata with Pleiades id, orange is place where also we have connected Alvin ]]
* [[ https://w.wiki/Ajh | Missing ]]
* [[ https://w.wiki/4vE | Alvin locations in WD ]]
* Alvin [[ https://w.wiki/6jJ | locations Gotland ]] compare {T227736}
* [[ https://w.wiki/7Gk | Alvin and the Domesday Book ]] on a [[ https://w.wiki/7Go | map ]]
* [[ https://w.wiki/7HC | Alvin and Vision of Britain ]] on a [[ https://w.wiki/7HE | map ]]
{F29494195,width=600}
* [[ https://w.wiki/4wA | Image gallery of people ]] connected to Alvin that has a picture in Wikidata
* everything is CC0 and can be used
* Timeline created with [[ http://histropedia.com/ | Histropedia ]]
* All [[ http://histropedia.com/showcase/wikidata-viewer.html?q=SELECT ?personItem ?person ?personDescription ?date ?Country_of_citizenship ?Occupation ?Gender ?image ?rank ?Cause_of_death ?Ethnic_group ?Education (CONCAT(?person,' (',?personDescription,')') as ?title) ?Alvin
WHERE {
{
SELECT ?personItem ?date ?countryItem ?occupationItem ?genderItem ?causeOfDeathItem ?ethnicGroupItem ?educatedAtItem ?Alvin
(SAMPLE(?image) as ?image)
(COUNT(?article) as ?rank)
WHERE {
?personItem wdt:P569 ?date .
OPTIONAL {?personItem wdt:P18 ?image }
?personItem wdt:P21 ?genderItem .
OPTIONAL {?personItem wdt:P106 ?occupationItem }
OPTIONAL {?personItem wdt:P27 ?countryItem }
OPTIONAL { ?personItem wdt:P509 ?causeOfDeathItem }
OPTIONAL { ?personItem wdt:P172 ?ethnicGroupItem }
OPTIONAL { ?personItem wdt:P69 ?educatedAtItem }
OPTIONAL { ?article schema:about ?personItem }
?personItem wdt:P6821 ?AlvinID.
BIND (URI(CONCAT("http://www.alvin-portal.org/alvin/view.jsf?pid=", ?AlvinID)) AS ?Alvin)
} GROUP BY ?personItem ?date ?countryItem ?occupationItem ?genderItem ?causeOfDeathItem ?ethnicGroupItem ?educatedAtItem ?Alvin
}
SERVICE wikibase:label {
bd:serviceParam wikibase:language 'sv','en'.
?personItem schema:description ?personDescription .
?personItem rdfs:label ?person .
?countryItem rdfs:label ?Country_of_citizenship .
?occupationItem rdfs:label ?Occupation .
?genderItem rdfs:label ?Gender .
?causeOfDeathItem rdfs:label ?Cause_of_death .
?ethnicGroupItem rdfs:label ?Ethnic_group .
?educatedAtItem rdfs:label ?Education .
}
} ORDER BY DESC(?rank)&md=true&g=personItem&l=Alvin&t=title&s=date&i=image&c=Country_of_citizenship,Gender&f=Occupation,Gender,Education,Cause_of_death,Ethnic_group&v=t| people with filter on nationality and link Alvin ]]
{F29527141,width=600}
{F29527193,width=600}
{F29630122,width=600}
In the picture above we can see the problem with open data and occupations. I did some cleaning who is a "fornforskare " and now we have the picture below
{F29552810,width=600}
The theory is that WIkidata/WIkipedia should be based on authorities BUT
* I added an occupation Fornforskare that should be same as SBL definition of "Fornforskare" link
* In a perfect world we should have an dialogue Wikidata <> SBL and
* understand each others concepts
* have something like SPARQL federation to check that WD is not vandalized compared to SBL see {T200668}
* that occupations in SBL are mapped to something like the [[ https://t.co/iSEhbjCj1q | HISCO code ]] ie. then we can do more advanced data analysations
* graves on [[ https://tinyurl.com/yxn9wgaf | Uppsala Gamla kyrkogård and in WD connected to Alvin ]] > ~~175 200 241~~ 323 [[ https://w.wiki/6$M | list ]]
* [[ https://w.wiki/6$P | people on the cemetery with coordinates but not connected to Alvin ]]
* same for [[ https://w.wiki/9F2 | Adolf Fredriks cemetery ]]
* people connected to [[ https://w.wiki/8S6 | Alvin but no grave coordinates ]]
* maintenance queries see [[ https://minancestry.blogspot.com/2019/08/uppsala-gamla-kyrkogard.html | blog ]]
{F29952142,width=600}
* same for [[ https://tinyurl.com/y2475wnx | Norra Begravningsplatsen Stockholm ]] > ~~200 253~~ 318 graves
* [[ http://graves.wiki/#/map/@59.85617,17.62547,18z | grave pictures missing in Uppsala for people connected to the cemetery ]]
{F30008354,width=600}
[x] [[ https://www.wikidata.org/wiki/Property:P6821 | Property:P6821 ]] created see [[ https://www.wikidata.org/wiki/Wikidata:Property_proposal/Alvin | Wikidata:Property_proposal/Alvin ]]
[x] set up property see query https://w.wiki/4r9
[x] speak with Alvin how to set it up in the best way maybe have a meeting
[] map persons
* see example done with [[ http://minancestry.blogspot.com/2017/05/sbl-wikidata.html | SBL ]] and [[ http://minancestry.blogspot.com/2018/03/svenskt-kvinnobiografiskt-lexikon.html | SKBL ]]
[] map locations we have all Swedish parishes and Swedish church parishes
* Swedish Church parishes
* 3500 Swedish articles, connected to NAD and SCB see [[ https://github.com/salgo60/Svenskaforsamlingar | GITHUB salgo60/Svenskaforsamlingar ]] and [[https://sv.wikipedia.org/wiki/Wikipedia:Projekt_svenska_församlingar | Wikipedia:Projekt_svenska_församlingar ]]
* we have also prepared for integrating with Riksarkivet [[ https://riksarkivet.se/Tora | TORA project ]] WD Property [[ https://www.wikidata.org/wiki/Property_talk:P4820 | Property:P4820 ]]
* Swedish Parishes [[ https://sv.wikipedia.org/wiki/Wikipedia:Projekt_svenska_socknar | Wikipedia:Projekt_svenska_socknar ]]
[] if we can get data from them for matching
[] using [[ http://openrefine.org/ | OpenRefine ]]
[] using [[ https://tools.wmflabs.org/mix-n-match/#/ | MixandMatch ]]
[] see if we can have an update process and/or SPARQL federation compare {T200668}
=== Swedish related properties today in WD
https://www.wikidata.org/wiki/Template:Sweden_properties
{F29463419,width=1200}
* all [[ https://w.wiki/4mD | external properties in WD ]] 3919 2019-06-11
* 4021 2019-07-04
=== Queries
* https://w.wiki/4r9
* Find other properties on the WD objects that has [[ https://www.wikidata.org/wiki/Property:P6821 | Property:P6821 ]] https://w.wiki/536
{F29472348,width=700}
* [[ https://w.wiki/52x | Picture of species were the author(s) of the first scientific description]] is in WD and connected to Alvin - more than ~~10 000~~ 13500
{F29863871,width=900}
* same query but [[ https://w.wiki/8TQ | Wikidata miss a picture of the species ]]
* Same query but group by [[ https://w.wiki/6p5 | authors as a list ]], as [[ https://w.wiki/6p7 | bubble chart ]]
{F29966042,width=500}
* [[ https://tinyurl.com/yxh2bfaz | places named after a person in WD connected to Alvin ]]
{F29602045,width=600}
* [[ https://w.wiki/54W | Locations on the moon given name by "Alvin" people ]]
* people in [[ https://w.wiki/5DV | WD connected Riddarsholmskyrkan and also to Alvin ]], same but [[ https://w.wiki/5DY | people NOT Alvin connected ]]
{F29622174,width=400} and not {F29622176,width=400}