FactGrid:Career Statements: Difference between revisions

From FactGrid
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
[[File:Buchhändler.jpg|thumb|right|500px|Kupferstich "Der Buchhändler" aus: ''Abbildung der gemein-nützlichen Haupt-Stände von Christoph Weigel'' (Regensburg, 1698).]]
[[File:Buchhändler.jpg|thumb|right|500px|Kupferstich "Der Buchhändler" aus: ''Abbildung der gemein-nützlichen Haupt-Stände von Christoph Weigel'' (Regensburg, 1698).]]
== First searches ==
 
*  [https://database.factgrid.de/query/embed.html#%23defaultView%3ABubbleChart%0ASELECT%20%3FSectorLabel%20(count(distinct(%3FA))%20as%20%3Fcount)%20WHERE%20%7B%0A%20%20%0A%20%20SELECT%20%3FA%20%3FALabel%20%3FADescription%20%3Ffamily_nameLabel%20%3FEntry%20%3FBnF_ID%20%3FDate_of_birth%20%3FSector%20%3FSectorLabel%20WHERE%20%7B%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22de%22.%20%7D%0A%20%20%20%20%3FA%20wdt%3AP91%20wd%3AQ11161.%0A%20%20%20%20%3FA%20wdt%3AP165%20%3FOccupation.%20%0A%20%20%20%20%3FOccupation%20wdt%3AP626%20%3FSector.%0A%7D%0A%20%20%0A%20%20%7D%20group%20by%20%3FSectorLabel The members of Frankfurt's Unions-Lodge, occupations bubble chart] our make-shift P626 statistical key
== Orientation ==
* [https://database.factgrid.de/query/embed.html#%23defaultView%3ABubbleChart%0ASELECT%20%3FOhdABLabel%20%28count%28distinct%28%3FA%29%29%20as%20%3Fcount%29%20WHERE%20%7B%0A%20%20%0A%20%20SELECT%20%3FA%20%3FALabel%20%3FADescription%20%3Ffamily_nameLabel%20%3FEntry%20%3FBnF_ID%20%3FDate_of_birth%20%3FOhdAB%20%3FOhdABLabel%20WHERE%20%7B%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22de%22.%20%7D%0A%20%20%20%20%3FA%20wdt%3AP91%20wd%3AQ11161.%0A%20%20%20%20%3FA%20wdt%3AP165%20%3FOccupation.%20%0A%20%20%20%20%3FOccupation%20wdt%3AP1007%2a%20%3FOhdAB.%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%3FOhdAB%20wdt%3AP2%20wd%3AQ651501.%20%20%20%20%20%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%7D%0A%20%20%0A%20%20%7D%20group%20by%20%3FOhdABLabel The members of Frankfurt's Unions-Lodge, occupations bubble chart] statistics on the OhdAB-01 level.  
=== Basic ontology: Three granulations of "career statements" ==
::* [https://database.factgrid.de/query/embded.html#%20%20SELECT%20%3FA%20%3FALabel%20%3FADescription%20%3Ffamily_nameLabel%20%3FOccupation%20%3FOccupationLabel%20%3FOhdAB%20%3FOhdABLabel%20WHERE%20%7B%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22de%22.%20%7D%0A%20%20%20%20%3FA%20wdt%3AP91%20wd%3AQ11161.%0A%20%20%20%20%3FA%20wdt%3AP165%20%3FOccupation.%20%0A%20%20%20%20OPTIONAL%20%7B%20%3FOccupation%20wdt%3AP1007%2a%20%3FOhdAB.%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%3FOhdAB%20wdt%3AP2%20wd%3AQ651501.%20%20%20%20%20%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%7D%20%7D%0A%20%20 Table that shows where the OhdAB matching is still extant]
 
FactGrid is presently running with some 8,000 "Career statements"
 
* [https://database.factgrid.de/query/#SELECT%20%3FCareer_statement%20%3FCareer_statementLabel%20%3FCareer_statementAltLabel%20%3FOhdAB_category%20%3FOhdAB_categoryLabel%20%3FOhdAB_ID%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22de%22.%20%7D%0A%20%20%3FCareer_statement%20%28wdt%3AP2%2F%28wdt%3AP3%2a%29%29%20wd%3AQ37073.%0A%20%20OPTIONAL%20%7B%20%3FCareer_statement%20wdt%3AP1007%20%3FOhdAB_category.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FCareer_statement%20wdt%3AP904%20%3FOhdAB_ID.%20%7D%0A%7D FactGrid Career statements]
 
Career statements come in all sorts: "baker", "master baker", "court baker" to very specific statements like "rector/president of the University of Erfurt"
 
We have sorted these under three headings:
 
* [[Item:Q37073]] Career statement (baker, master baker, court baker, university rector, widow, pensioner)
* [[Item:Q37131]] Career statement with historical or geographical specifications
* [[Item:Q257052]] Career statement that captures a sequence of incumbents "rector/president of the University of Erfurt"
 
The three categories are interlaced with (P3) "sub property of" statements, so you can easily ask for all university directors, although several of these have far more specific P2 "instance of statements". Search for '''wdt:P2/wdt:P3*'' on the top level to get the respective full sets.
 
=== Connected to the OhdAB ontology ===
 
All our "career statements" are connected to Katrin Moellers ontology of career statements OhdAB. The OhdAB has some 45,000 items in a distinct hierarchy of differentiations.
 
* https://kurzelinks.de/OhdAB
 
OhdAB items begin with the OhdAB number code and are a sphere of their own (contact Katrin Moeller and her working group on their project page) - yet we are connecting all our career statements into the OhdAB classification so that we can run, for instance, statistics on the OhdAB ontology:
 
*  [https://database.factgrid.de/query/embed.html#%23defaultView%3ABubbleChart%0ASELECT%20%3FSectorLabel%20(count(distinct(%3FA))%20as%20%3Fcount)%20WHERE%20%7B%0A%20%20%0A%20%20SELECT%20%3FA%20%3FALabel%20%3FADescription%20%3Ffamily_nameLabel%20%3FEntry%20%3FBnF_ID%20%3FDate_of_birth%20%3FSector%20%3FSectorLabel%20WHERE%20%7B%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22de%22.%20%7D%0A%20%20%20%20%3FA%20wdt%3AP91%20wd%3AQ11161.%0A%20%20%20%20%3FA%20wdt%3AP165%20%3FOccupation.%20%0A%20%20%20%20%3FOccupation%20wdt%3AP626%20%3FSector.%0A%7D%0A%20%20%0A%20%20%7D%20group%20by%20%3FSectorLabel The members of Frankfurt's Unions-Lodge, occupations bubble chart] the make shift FactGrid system on [[Property:P626]]
* [https://database.factgrid.de/query/embed.html#%23defaultView%3ABubbleChart%0ASELECT%20%3FOhdABLabel%20%28count%28distinct%28%3FA%29%29%20as%20%3Fcount%29%20WHERE%20%7B%0A%20%20%0A%20%20SELECT%20%3FA%20%3FALabel%20%3FADescription%20%3Ffamily_nameLabel%20%3FEntry%20%3FBnF_ID%20%3FDate_of_birth%20%3FOhdAB%20%3FOhdABLabel%20WHERE%20%7B%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22de%22.%20%7D%0A%20%20%20%20%3FA%20wdt%3AP91%20wd%3AQ11161.%0A%20%20%20%20%3FA%20wdt%3AP165%20%3FOccupation.%20%0A%20%20%20%20%3FOccupation%20wdt%3AP1007%2a%20%3FOhdAB.%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%3FOhdAB%20wdt%3AP2%20wd%3AQ651501.%20%20%20%20%20%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%7D%0A%20%20%0A%20%20%7D%20group%20by%20%3FOhdABLabel The members of Frankfurt's Unions-Lodge, occupations bubble chart] the same statistical analysis on the OhdAB-01 level.  
 
The OhdAB matching is not yet finished, but we will get this done in the first weeks of 2024. The OhdAB translation is another project. The German labelling is the source labelling, other language labels are welcome. We offer an English version with a good deal of DeepL translations - this is not yet perfect.
 
== If you create career statements ==
# Use the [https://database.factgrid.de/query/#SELECT%20%3FCareer_statement%20%3FCareer_statementLabel%20%3FCareer_statementAltLabel%20%3FOhdAB_category%20%3FOhdAB_categoryLabel%20%3FOhdAB_ID%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22de%22.%20%7D%0A%20%20%3FCareer_statement%20%28wdt%3AP2%2F%28wdt%3AP3%2a%29%29%20wd%3AQ37073.%0A%20%20OPTIONAL%20%7B%20%3FCareer_statement%20wdt%3AP1007%20%3FOhdAB_category.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FCareer_statement%20wdt%3AP904%20%3FOhdAB_ID.%20%7D%0A%7D career statements we already have] wherever applicable.
# If you need new statements: Create them and connect them to the OhdAB ontology with a [[Property:P1007]] statement.
# If you do not find the proper OhdAB match - contact the OhdAB team to create the perfect match of a pragmatic regular statement and a OhdAB systematic identification.
 
== Why all this fuss about career statements? ==
 


[[Category:Data modelling]]
[[Category:Data modelling]]
[[Category:Career statements]]
[[Category:Career statements]]

Revision as of 13:09, 22 December 2023

Kupferstich "Der Buchhändler" aus: Abbildung der gemein-nützlichen Haupt-Stände von Christoph Weigel (Regensburg, 1698).

Orientation

= Basic ontology: Three granulations of "career statements"

FactGrid is presently running with some 8,000 "Career statements"

Career statements come in all sorts: "baker", "master baker", "court baker" to very specific statements like "rector/president of the University of Erfurt"

We have sorted these under three headings:

  • Item:Q37073 Career statement (baker, master baker, court baker, university rector, widow, pensioner)
  • Item:Q37131 Career statement with historical or geographical specifications
  • Item:Q257052 Career statement that captures a sequence of incumbents "rector/president of the University of Erfurt"

The three categories are interlaced with (P3) "sub property of" statements, so you can easily ask for all university directors, although several of these have far more specific P2 "instance of statements". Search for 'wdt:P2/wdt:P3* on the top level to get the respective full sets.

Connected to the OhdAB ontology

All our "career statements" are connected to Katrin Moellers ontology of career statements OhdAB. The OhdAB has some 45,000 items in a distinct hierarchy of differentiations.

OhdAB items begin with the OhdAB number code and are a sphere of their own (contact Katrin Moeller and her working group on their project page) - yet we are connecting all our career statements into the OhdAB classification so that we can run, for instance, statistics on the OhdAB ontology:

The OhdAB matching is not yet finished, but we will get this done in the first weeks of 2024. The OhdAB translation is another project. The German labelling is the source labelling, other language labels are welcome. We offer an English version with a good deal of DeepL translations - this is not yet perfect.

If you create career statements

  1. Use the career statements we already have wherever applicable.
  2. If you need new statements: Create them and connect them to the OhdAB ontology with a Property:P1007 statement.
  3. If you do not find the proper OhdAB match - contact the OhdAB team to create the perfect match of a pragmatic regular statement and a OhdAB systematic identification.

Why all this fuss about career statements?