Data Input: Difference between revisions

From FactGrid
Jump to navigation Jump to search
No edit summary
 
(80 intermediate revisions by 2 users not shown)
Line 1: Line 1:
This page is gathering the data-sets for the first FactGrid data import. We aim to also create input forms so that researchers can eventually create new data sets when working over individual documents in an archive.
 
* [[https://www.wikidata.org/wiki/Help:QuickStatements Wikidata zu QuickStatements]
== Help ==
* [[Anleitung]]
* [https://www.wikidata.org/wiki/Help:QuickStatements Wikidata zu QuickStatements]
* [https://www.wikidata.org/wiki/Help:Data_type/de Data type]
* [[Specific FactGrid Manual]]
* [[Specific FactGrid Manual]]
* [http://openrefine.org/ http://openrefine.org/] Former Google refine, tool to transform information for a data input


== To Do ==
== Places ==
=== Subsets klären ===
* [https://database.factgrid.de/query/#SELECT%20%3FOrt%20%3FOrtLabel%20%3FGeokoordinaten%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3FOrt%20wdt%3AP2%20wd%3AQ8.%0A%20%20OPTIONAL%20%7B%20%3FOrt%20wdt%3AP48%20%3FGeokoordinaten.%20%7D%0A%7D FactGrid search: a place and its geo-coordinate]
Q10671-75 sind ineinander verschachtelt und alle Teil von Q2, das muss noch vermerkt werden. P3 Property
 
=== <Documents file> Complete the "included" in section in ===
Complete the included in section, col h [https://docs.google.com/spreadsheets/d/1gd7bx9n-3pRC4VPHcVdHPEf9cFpZbZxr3WM_RBjXLgk/edit#gid=0] - it presently ends with SK17-086
 
=== <Documents file> Reference Qualifiers ===
* create a qualifier for page/ folio or document-number references.  
* join 3a to 3 of the list of documents: [https://docs.google.com/spreadsheets/d/1gd7bx9n-3pRC4VPHcVdHPEf9cFpZbZxr3WM_RBjXLgk/edit#gid=0]
 
=== <Documents file> Correct English statements ===
We have erroneous English translations (partly shifted one line) from Q9152-Q9451 of [https://docs.google.com/spreadsheets/d/1gd7bx9n-3pRC4VPHcVdHPEf9cFpZbZxr3WM_RBjXLgk/edit#gid=0]
 
=== <Documents file> Create Level of Archival Object ===
in order to distinguish between file, document, section of a document, and archival holding


=== <Documents file> Absendeorte - is not done yet ===
We have presently (Oct. 2018) some 840 places in the FactGrid not all of which have a geo-coordinate. We probably made the mistake not to begin with one single massive place input...
SK07-047, Q3962, wird in Wien versandt...


Is there a way to find out where we have not yet done the statement? (yes through the QuzeryService...
== Copy&Paste Script-Fragments with [https://database.factgrid.de/quickstatements/#/batch QuickStatements] and CSV-Input ==


== Google Spreadsheets of the ongoing Data Input ==
=== Create a family name ===
 
qid,Lde,Len,Lfr,Dde,Den,Dfr,P2<br>
 
,"#","#","#","Familienname","family name","nom de familie",Q24499
{| class="wikitable sortable" width="100%"
|+ style="padding-bottom:1em" | Google Spreadsheets and Illuminati Project Data
|-
! Dataset Google Spreadsheet !! Content !! What could be visualised? !! Web Form 
|-
| [https://docs.google.com/spreadsheets/d/1gd7bx9n-3pRC4VPHcVdHPEf9cFpZbZxr3WM_RBjXLgk/edit?usp=sharing Documents] || Mostly ''Schwedenkiste'', Illuminati materials from various archives, documents published in the late 1780s  || Network information. Caution: We are operating with fragmented data - early information published by the Bavarian State in 1787/88 and the ''Schwedenkiste'', the archive of the last operating province. || [[Erfassung von Akten|Describe an archival document]]
|-
| [https://docs.google.com/spreadsheets/d/1AmiTIOP7kTjw61q4YJCCSbNHqS6sRU1ZFQq82RQTn7E/edit?usp=sharing People] || A list of the 1350-something members of the order (plus some others who belong into the wider context) Mainly Research stated in col. AJ: Hermann Schüttler (2016). Members, when and where they entered the Order, titles, occupations, related memberships ||
* The geographical spread of the Order on the Central European map: col. AB to be matched with col. AG
* Already existing Wikidata and GND data sets linked in cols. M and N.
* Age structure of the members col. AC
* Percentage of aristocracy cols. J-L
|| [[Erfassung biographischer Information|Writing a CV]]
|-
| || The order had a complex grade system that created careers within the order, people could also get into different official positions  ||  || [[Erfassung von Mitgliedschaft im Illuminatenorden|Give information about an Illuminati career]]
|-
| [https://docs.google.com/spreadsheets/d/1PkUXuVwbQH9bMJoaGWd3TvkTQqHdY8AbW05FjeyAyY8/edit?usp=sharing Events] || Mostly protocols of gatherings of the "Minerval Churches" under Bode's supervision. (Missing: Hermann Schüttler's information about gatherings of the Minerval Church in Frankfurt/Main) ||  || [[Sitzung, Konferenz|Give information about a session (as type of an event)]]
|-
| [https://docs.google.com/spreadsheets/d/1gZEyHOePPWoQssIzxgtExwBGx61TL1qGbGVspv9_sAQ/edit?usp=sharing Organisations] ||  ||  ||
|-
| [https://docs.google.com/spreadsheets/d/12-bO44oNKUBw61e1kO-lFJEvcedTs63_oTwigr8GJQw/edit?usp=sharing Publications] ||  ||  || 
|}
 
== Places ==
Presently 223, some without Geo-ref, some not real places, some double


SELECT ?Ort ?OrtLabel ?Geokoordinaten WHERE {
=== Create a person ===
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
qid,Lde,Len,Dde,Den,P2,P154<br>
  ?Ort wdt:P2 wd:Q8.
,"#","#","$","$",Q7,Q18
  OPTIONAL { ?Ort wdt:P48 ?Geokoordinaten. }
}


== Strange Items ==
::legt eine Person an, # gegen Label austauschen, $ eine Kurzbiographie etwa: "~1808, Gotha" für eine Person, die laut einem Dokument 1808 in Gotha auftaucht. Q18 identifiziert die Person als Mann. Bei einer Frau Q17 einsetzen.
* Not the author's handwriting (Q11148)
* English (Q11149)
* German (Q11150)
* Latin (Q11151)
* French (Q11152)
* Spanish (Q11153)
* Dutch (Q11154)
* Italian (Q11155)
* Russian (Q11156)
* Danish (Q11157)
<hr>
* Order of the Illuminati (Q10677)
* Order of Illuminati (Q10670)
* Ingolstadt (Q10285) muss raus
* Calendar (Freemasonic) (Q11175)
* Geography (Order of the Illuminati) (Q11174)
* Calendar (Order of the Illuminati) (Q11173)
* not resolved in FactGrid (Q11172)
* document (Q10671)


== Strange Questions ==
== Werkverträge ==
I inserted statements as "SK13-070" as alias statements, but cannot use these statements in searches.
* [[Werkverträge]]

Latest revision as of 10:29, 13 May 2019

Help

Places

We have presently (Oct. 2018) some 840 places in the FactGrid not all of which have a geo-coordinate. We probably made the mistake not to begin with one single massive place input...

Copy&Paste Script-Fragments with QuickStatements and CSV-Input

Create a family name

qid,Lde,Len,Lfr,Dde,Den,Dfr,P2
,"#","#","#","Familienname","family name","nom de familie",Q24499

Create a person

qid,Lde,Len,Dde,Den,P2,P154
,"#","#","$","$",Q7,Q18

legt eine Person an, # gegen Label austauschen, $ eine Kurzbiographie etwa: "~1808, Gotha" für eine Person, die laut einem Dokument 1808 in Gotha auftaucht. Q18 identifiziert die Person als Mann. Bei einer Frau Q17 einsetzen.

Werkverträge

Retrieved from "https://database.factgrid.de/w/index.php?title=Data_Input&oldid=1349610"