Probably the CSV exporters to the wikidata can be
a suitable answer to
this problem. For example we have the table of all mayors in Rome (there
were a lot of them) with their titles and years of begin and end. It
shouldn't be very hard to write a convertor that will create the property
values of "head of government
<https://www.wikidata.org/wiki/Property:P6>" property and populate all
these mayors like here:
-----
Yury Katkov
On Sun, Jun 15, 2014 at 1:56 PM, Thomas Douillard <
thomas.douillard(a)gmail.com> wrote:
Hi yan, simple 2d tables are just really an
implementation of a set of
relations.
For example the tabular datas like an adress book like
Name Phone-Number City
John 12345 New York
Katie 23456 Paris
can totally be implemented in Wikidata with two properties and some
conventions :
* A "Phone number" property
* A "living place" property
and conventions that they plly to persons. Some may also requires
qualifiers.
But giving that it's always possible to implement "tabular datas" (what
are these ?) the Wikidata way, is this a problem that they don't have a
specficic treatment ?
2014-06-15 13:43 GMT+02:00 Jan Kučera <kozuch82(a)gmail.com>om>:
I am really disappointed to see simple 2d tables still are not
> reality... the issue probably is related to the original PHASE #3...
>
>
> 2014-06-03 23:50 GMT+02:00 Jan Kučera <kozuch82(a)gmail.com>om>:
>
> Can tabular data be currently saved as a series of statements within
>> wikidata? If so, how can I create such a series? Am I able to feed such a
>> series into a wikitable on some wiki?
>>
>>
>> 2014-05-30 11:19 GMT+02:00 Joe Filceolaire <filceolaire(a)gmail.com>om>:
>>
>> Simple tables that are in wikipedia:
>>> * league tables with columns for games won, drawn, lost, goals for,
>>> goals against, points, rank and rows for each of the teams in the league.
>>> * election results with columns for votes for each party and seats
>>> won by each party and rows for each region, state etc.
>>> * population numbers with columns for each tab (races, religion
>>> etc.) and rows for each census district.
>>>
>>> In all of these cases I suspect that this information might be more
>>> useful as a series of statements. These could either be broken up with a
>>> statement corresponding to each column on the item for each row or
>>> alternatively with all the information in the table on one item, a
>>> statement for each row and qualifiers to each statement corresponding to
>>> each column.
>>>
>>> What is the advantage to having this as a table instead?
>>>
>>> Joe
>>>
>>>
>>> On Wed, May 28, 2014 at 9:12 PM, Jan Kučera <kozuch82(a)gmail.com>
>>> wrote:
>>>
>>>> Well what I meant was just an ordinary 2-dimensional table (rows
>>>> vs. columns)... Excel was just an example to make it clear.
>>>>
>>>> So I guess simple tables are not any roadmap yet right?
>>>>
>>>> Further step would be an n-dimensional structures... arrays etc.
>>>>
>>>> I wouldnt care about format.... CSV, JSON...
>>>>
>>>> Jan
>>>>
>>>>
>>>>
>>>> 2014-05-27 14:24 GMT+02:00 David Cuenca <dacuetu(a)gmail.com>om>:
>>>>
>>>> Please, leave your comments here too:
>>>>>
>>>>>
https://meta.wikimedia.org/wiki/Requests_for_comment/How_to_deal_with_open_…
>>>>>
>>>>> I've been gathering comments from several people, and in the
next
>>>>> days I will try to summarize these suggestions to be discussed on
irc.
>>>>>
>>>>> Thanks,
>>>>> Micru
>>>>>
>>>>>
>>>>> On Tue, May 27, 2014 at 2:12 PM, Ilario Valdelli <
>>>>> valdelli(a)gmail.com> wrote:
>>>>>
>>>>>> I am not an expert of Wikidata but I work a lot in integration
of
>>>>>> databases with several middlewares or tools.
>>>>>>
>>>>>> I think that the best way is to ask a solution to store and to
>>>>>> download data in a format compatible with datasheets like CSV.
>>>>>>
>>>>>> Excel is considered also a tool to do some basic analysis, but
it
>>>>>> can be connected easily to a data source (if well structured).
>>>>>>
>>>>>> Excel itself is not a good approach to store data, so it's
not a
>>>>>> good solution to keep the data in excel format in a database.
>>>>>>
>>>>>> Doesn't make sense to store a 2D tables in a database in my
>>>>>> opinion because the data have no sense and they are not helpful
to anyone.
>>>>>>
>>>>>> They can be stored like a text file, but I would not imagine the
>>>>>> series of errors that can be generated importing these data
again.
>>>>>>
>>>>>> Regards
>>>>>>
>>>>>>
>>>>>> On Tue, May 27, 2014 at 1:15 PM, Jan Kučera
<kozuch82(a)gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> Hi there,
>>>>>>>
>>>>>>> can tables be stored within wikidata database? I mean simple
2D
>>>>>>> tables like excel spreadsheets...
>>>>>>>
>>>>>>> Jan
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> Wikidata-l mailing list
>>>>>>> Wikidata-l(a)lists.wikimedia.org
>>>>>>>
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Ilario Valdelli
>>>>>> Wikimedia CH
>>>>>> Verein zur Förderung Freien Wissens
>>>>>> Association pour l’avancement des connaissances libre
>>>>>> Associazione per il sostegno alla conoscenza libera
>>>>>> Switzerland - 8008 Zürich
>>>>>> Wikipedia: Ilario
<https://meta.wikimedia.org/wiki/User:Ilario>
>>>>>> Facebook: Ilario Valdelli
<https://www.facebook.com/ivaldelli>
>>>>>> Twitter: Ilario Valdelli
<https://twitter.com/ilariovaldelli>
>>>>>> Linkedin: Ilario Valdelli
>>>>>> <http://www.linkedin.com/profile/view?id=6724469>
>>>>>> Tel: +41764821371
>>>>>>
http://www.wikimedia.ch
>>>>>>
>>>>>> _______________________________________________
>>>>>> Wikidata-l mailing list
>>>>>> Wikidata-l(a)lists.wikimedia.org
>>>>>>
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Etiamsi omnes, ego non
>>>>>
>>>>> _______________________________________________
>>>>> Wikidata-l mailing list
>>>>> Wikidata-l(a)lists.wikimedia.org
>>>>>
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
>>>>>
>>>>>
>>>>
>>>> _______________________________________________
>>>> Wikidata-l mailing list
>>>> Wikidata-l(a)lists.wikimedia.org
>>>>
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
>>>>
>>>>
>>>
>>> _______________________________________________
>>> Wikidata-l mailing list
>>> Wikidata-l(a)lists.wikimedia.org
>>>
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
>>>
>>>
>>
>
> _______________________________________________
> Wikidata-l mailing list
> Wikidata-l(a)lists.wikimedia.org
>
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
>
>
_______________________________________________
Wikidata-l mailing list
Wikidata-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l
_______________________________________________
Wikidata-l mailing list
Wikidata-l(a)lists.wikimedia.org