Re: [Wikidata-l] Tables

[Joe Filceolaire]

Worse.
It needs the currency datatype which will not be ready till after the other
units.
On 22 Aug 2014 14:59, "David Cuenca"  wrote:

> You have to add the data to each corresponding item, for instance:
> <ŠKODA AUTO a.s> sales <268.5M (CZK)>
>point in time <2013>
> <ŠKODA AUTO a.s> sales <262.6M (CZK)>
>point in time <2012>
>
> The problem is that the information you want to enter requires the unit
> datatype, so I guess you will have to wait.
>
> There are also some experiments to store data as CSV or JSON
> http://graphtest.wmflabs.org/wiki/Data:Json:World-110m
> http://graphtest.wmflabs.org/wiki/Data:Csv:Stocks
>
> And then you can visualize it: http://graphtest.wmflabs.org/wiki/Main_Page
>
> Cheers,
> Micru
>
>
> On Fri, Aug 22, 2014 at 3:19 PM, Jan Kučera  wrote:
>
>> Can someone show me how to make use of wikidata and save following 2D
>> table in a structured day (properties???) so that it can later be retrieved
>> via queries into a list?
>>
>>
>> https://cs.wikipedia.org/wiki/Seznam_nejv%C4%9Bt%C5%A1%C3%ADch_%C4%8Desk%C3%BDch_firem_podle_tr%C5%BEeb
>>
>> Thanks!
>>
>> 2014-06-16 10:35 GMT+02:00 Joe Filceolaire :
>>
>> Oops.
>>>
>>> My mistake. The properties I proposed weren't the ones approved. :(
>>>
>>> The property proposals are at
>>>
>>> https://www.wikidata.org/wiki/Wikidata:Property_proposal/Event#Sports_Leagues
>>>
>>> joe
>>>
>>>
>>> On Sun, Jun 15, 2014 at 9:15 PM, Gerard Meijssen <
>>> gerard.meijs...@gmail.com> wrote:
>>>
 Hoi,
 Do you have a link and an example of a fleshed out use of these
 properties?
 Thanks,
  GerardM


 On 15 June 2014 21:49, Joe Filceolaire  wrote:

> Exactly.
>
> If the data in the table cannot be expressed as a set of statements
> (probably with a qualifier for each column of the table) then why would we
> include it?
>
> See my recently approved proposals for properties needed for recording
> sports league tables (and World Cup groups) as statements - listed in this
> weeks weekly summary.
>
> What advantage would there be for recording these results in a table
> rather than as statements? If the answer is to ensure consistent 
> formatting
> then we need to look at templates and tools for entering and editing data,
> not new datatypes.
>
> Joe
>
>
> On Sun, Jun 15, 2014 at 1:24 PM, Yury Katkov 
> wrote:
>
>> 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
>> " property and populate
>> all these mayors like here:
>> https://www.wikidata.org/wiki/Q656#wb-terms
>>
>> -
>> Yury Katkov
>>
>>
>> On Sun, Jun 15, 2014 at 1:56 PM, Thomas Douillard <
>> thomas.douill...@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  12345New York
>>> Katie 23456Paris
>>>
>>> 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 :
>>>
>>> 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 :

 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 
> :
>
> 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.

Re: [Wikidata-l] Tables

[David Cuenca]

You have to add the data to each corresponding item, for instance:
<ŠKODA AUTO a.s> sales <268.5M (CZK)>
   point in time <2013>
<ŠKODA AUTO a.s> sales <262.6M (CZK)>
   point in time <2012>

The problem is that the information you want to enter requires the unit
datatype, so I guess you will have to wait.

There are also some experiments to store data as CSV or JSON
http://graphtest.wmflabs.org/wiki/Data:Json:World-110m
http://graphtest.wmflabs.org/wiki/Data:Csv:Stocks

And then you can visualize it: http://graphtest.wmflabs.org/wiki/Main_Page

Cheers,
Micru


On Fri, Aug 22, 2014 at 3:19 PM, Jan Kučera  wrote:

> Can someone show me how to make use of wikidata and save following 2D
> table in a structured day (properties???) so that it can later be retrieved
> via queries into a list?
>
>
> https://cs.wikipedia.org/wiki/Seznam_nejv%C4%9Bt%C5%A1%C3%ADch_%C4%8Desk%C3%BDch_firem_podle_tr%C5%BEeb
>
> Thanks!
>
> 2014-06-16 10:35 GMT+02:00 Joe Filceolaire :
>
> Oops.
>>
>> My mistake. The properties I proposed weren't the ones approved. :(
>>
>> The property proposals are at
>>
>> https://www.wikidata.org/wiki/Wikidata:Property_proposal/Event#Sports_Leagues
>>
>> joe
>>
>>
>> On Sun, Jun 15, 2014 at 9:15 PM, Gerard Meijssen <
>> gerard.meijs...@gmail.com> wrote:
>>
>>> Hoi,
>>> Do you have a link and an example of a fleshed out use of these
>>> properties?
>>> Thanks,
>>>  GerardM
>>>
>>>
>>> On 15 June 2014 21:49, Joe Filceolaire  wrote:
>>>
 Exactly.

 If the data in the table cannot be expressed as a set of statements
 (probably with a qualifier for each column of the table) then why would we
 include it?

 See my recently approved proposals for properties needed for recording
 sports league tables (and World Cup groups) as statements - listed in this
 weeks weekly summary.

 What advantage would there be for recording these results in a table
 rather than as statements? If the answer is to ensure consistent formatting
 then we need to look at templates and tools for entering and editing data,
 not new datatypes.

 Joe


 On Sun, Jun 15, 2014 at 1:24 PM, Yury Katkov 
 wrote:

> 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
> " property and populate
> all these mayors like here:
> https://www.wikidata.org/wiki/Q656#wb-terms
>
> -
> Yury Katkov
>
>
> On Sun, Jun 15, 2014 at 1:56 PM, Thomas Douillard <
> thomas.douill...@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  12345New York
>> Katie 23456Paris
>>
>> 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 :
>>
>> 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 :
>>>
>>> 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 :

 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

Re: [Wikidata-l] Tables

[Jan Kučera]

Can someone show me how to make use of wikidata and save following 2D table
in a structured day (properties???) so that it can later be retrieved via
queries into a list?

https://cs.wikipedia.org/wiki/Seznam_nejv%C4%9Bt%C5%A1%C3%ADch_%C4%8Desk%C3%BDch_firem_podle_tr%C5%BEeb

Thanks!

2014-06-16 10:35 GMT+02:00 Joe Filceolaire :

> Oops.
>
> My mistake. The properties I proposed weren't the ones approved. :(
>
> The property proposals are at
>
> https://www.wikidata.org/wiki/Wikidata:Property_proposal/Event#Sports_Leagues
>
> joe
>
>
> On Sun, Jun 15, 2014 at 9:15 PM, Gerard Meijssen <
> gerard.meijs...@gmail.com> wrote:
>
>> Hoi,
>> Do you have a link and an example of a fleshed out use of these
>> properties?
>> Thanks,
>>  GerardM
>>
>>
>> On 15 June 2014 21:49, Joe Filceolaire  wrote:
>>
>>> Exactly.
>>>
>>> If the data in the table cannot be expressed as a set of statements
>>> (probably with a qualifier for each column of the table) then why would we
>>> include it?
>>>
>>> See my recently approved proposals for properties needed for recording
>>> sports league tables (and World Cup groups) as statements - listed in this
>>> weeks weekly summary.
>>>
>>> What advantage would there be for recording these results in a table
>>> rather than as statements? If the answer is to ensure consistent formatting
>>> then we need to look at templates and tools for entering and editing data,
>>> not new datatypes.
>>>
>>> Joe
>>>
>>>
>>> On Sun, Jun 15, 2014 at 1:24 PM, Yury Katkov 
>>> wrote:
>>>
 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
 " property and populate all
 these mayors like here:
 https://www.wikidata.org/wiki/Q656#wb-terms

 -
 Yury Katkov


 On Sun, Jun 15, 2014 at 1:56 PM, Thomas Douillard <
 thomas.douill...@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  12345New York
> Katie 23456Paris
>
> 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 :
>
> 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 :
>>
>> 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 :
>>>
>>> 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 
 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
>
>
>
> 201

Re: [Wikidata-l] Tables

[Joe Filceolaire]

Oops.

My mistake. The properties I proposed weren't the ones approved. :(

The property proposals are at
https://www.wikidata.org/wiki/Wikidata:Property_proposal/Event#Sports_Leagues

joe


On Sun, Jun 15, 2014 at 9:15 PM, Gerard Meijssen 
wrote:

> Hoi,
> Do you have a link and an example of a fleshed out use of these properties?
> Thanks,
> GerardM
>
>
> On 15 June 2014 21:49, Joe Filceolaire  wrote:
>
>> Exactly.
>>
>> If the data in the table cannot be expressed as a set of statements
>> (probably with a qualifier for each column of the table) then why would we
>> include it?
>>
>> See my recently approved proposals for properties needed for recording
>> sports league tables (and World Cup groups) as statements - listed in this
>> weeks weekly summary.
>>
>> What advantage would there be for recording these results in a table
>> rather than as statements? If the answer is to ensure consistent formatting
>> then we need to look at templates and tools for entering and editing data,
>> not new datatypes.
>>
>> Joe
>>
>>
>> On Sun, Jun 15, 2014 at 1:24 PM, Yury Katkov 
>> wrote:
>>
>>> 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
>>> " property and populate all
>>> these mayors like here:
>>> https://www.wikidata.org/wiki/Q656#wb-terms
>>>
>>> -
>>> Yury Katkov
>>>
>>>
>>> On Sun, Jun 15, 2014 at 1:56 PM, Thomas Douillard <
>>> thomas.douill...@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  12345New York
 Katie 23456Paris

 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 :

 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 :
>
> 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 :
>>
>> 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 
>>> 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 :

 Please, leave your comments here too:
>
> https://meta.wikimedia.org/wiki/Requests_for_comment/How_to_deal_with_open_datasets
>
> 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 <
> valde...@gmail.com> wrote:
>
>>>

Re: [Wikidata-l] Tables

[Gerard Meijssen]

Hoi,
Do you have a link and an example of a fleshed out use of these properties?
Thanks,
GerardM


On 15 June 2014 21:49, Joe Filceolaire  wrote:

> Exactly.
>
> If the data in the table cannot be expressed as a set of statements
> (probably with a qualifier for each column of the table) then why would we
> include it?
>
> See my recently approved proposals for properties needed for recording
> sports league tables (and World Cup groups) as statements - listed in this
> weeks weekly summary.
>
> What advantage would there be for recording these results in a table
> rather than as statements? If the answer is to ensure consistent formatting
> then we need to look at templates and tools for entering and editing data,
> not new datatypes.
>
> Joe
>
>
> On Sun, Jun 15, 2014 at 1:24 PM, Yury Katkov 
> wrote:
>
>> 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 "
>> property and populate all these mayors like here:
>> https://www.wikidata.org/wiki/Q656#wb-terms
>>
>> -
>> Yury Katkov
>>
>>
>> On Sun, Jun 15, 2014 at 1:56 PM, Thomas Douillard <
>> thomas.douill...@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  12345New York
>>> Katie 23456Paris
>>>
>>> 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 :
>>>
>>> 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 :

 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 :
>
> 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 
>> 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 :
>>>
>>> Please, leave your comments here too:

 https://meta.wikimedia.org/wiki/Requests_for_comment/How_to_deal_with_open_datasets

 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 <
 valde...@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 conn

Re: [Wikidata-l] Tables

[Joe Filceolaire]

Exactly.

If the data in the table cannot be expressed as a set of statements
(probably with a qualifier for each column of the table) then why would we
include it?

See my recently approved proposals for properties needed for recording
sports league tables (and World Cup groups) as statements - listed in this
weeks weekly summary.

What advantage would there be for recording these results in a table rather
than as statements? If the answer is to ensure consistent formatting then
we need to look at templates and tools for entering and editing data, not
new datatypes.

Joe


On Sun, Jun 15, 2014 at 1:24 PM, Yury Katkov  wrote:

> 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 "
> property and populate all these mayors like here:
> https://www.wikidata.org/wiki/Q656#wb-terms
>
> -
> Yury Katkov
>
>
> On Sun, Jun 15, 2014 at 1:56 PM, Thomas Douillard <
> thomas.douill...@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  12345New York
>> Katie 23456Paris
>>
>> 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 :
>>
>> 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 :
>>>
>>> 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 :

 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 
> 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 :
>>
>> Please, leave your comments here too:
>>>
>>> https://meta.wikimedia.org/wiki/Requests_for_comment/How_to_deal_with_open_datasets
>>>
>>> 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 >> > 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 

Re: [Wikidata-l] Tables

[Yury Katkov]

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 " property and
populate all these mayors like here:
https://www.wikidata.org/wiki/Q656#wb-terms

-
Yury Katkov


On Sun, Jun 15, 2014 at 1:56 PM, Thomas Douillard <
thomas.douill...@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  12345New York
> Katie 23456Paris
>
> 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 :
>
> 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 :
>>
>> 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 :
>>>
>>> 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  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 :
>
> Please, leave your comments here too:
>>
>> https://meta.wikimedia.org/wiki/Requests_for_comment/How_to_deal_with_open_datasets
>>
>> 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 
>> 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 
>>> 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@lists.wikimedia.org
 https://lists.wikimedia.org/mailman/listinfo/wikidata-l


>>>
>>>
>>> --
>>> Ilario Valdelli
>>> Wikimed

Re: [Wikidata-l] Tables

[Thomas Douillard]

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  12345New York
Katie 23456Paris

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 :

> 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 :
>
> 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 :
>>
>> 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  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 :

 Please, leave your comments here too:
>
> https://meta.wikimedia.org/wiki/Requests_for_comment/How_to_deal_with_open_datasets
>
> 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 
> 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 
>> 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@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 
>> Facebook: Ilario Valdelli 
>> Twitter: Ilario Valdelli 
>> Linkedin: Ilario Valdelli
>> 
>>  Tel: +41764821371
>> http://www.wikimedia.ch
>>
>> ___
>> Wikidata-l mailing list
>> Wikidata-l@lists.wikimedia.org
>> https://list

Re: [Wikidata-l] Tables

[Jan Kučera]

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 :

> 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 :
>
> 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  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 :
>>>
>>> Please, leave your comments here too:

 https://meta.wikimedia.org/wiki/Requests_for_comment/How_to_deal_with_open_datasets

 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 
 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 
> 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@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 
> Facebook: Ilario Valdelli 
> Twitter: Ilario Valdelli 
> Linkedin: Ilario Valdelli
> 
>  Tel: +41764821371
> http://www.wikimedia.ch
>
> ___
> Wikidata-l mailing list
> Wikidata-l@lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/wikidata-l
>
>


 --
 Etiamsi omnes, ego non

 ___
 Wikidata-l mailing list
 Wikidata-l@lists.wikimedia.org
 https://lists.wikimedia.org/mailman/listinfo/wikidata-l


>>>
>>> ___
>>> Wikidata-l mailing list
>>> Wikidata-l@lists.wikimedia.org
>>> https://lists.wikimedia.org/mailman/listinfo/wikidata-l
>>>
>>>
>>
>> ___
>> Wikidata-l mailing list
>> Wikidata-l@lists.wikimedia.org
>> https://lists.wikimedia.org/mailman/listinfo/wikidata-l
>>
>>
>
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org

Re: [Wikidata-l] Tables

[Jan Kučera]

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 :

> 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  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 :
>>
>> Please, leave your comments here too:
>>>
>>> https://meta.wikimedia.org/wiki/Requests_for_comment/How_to_deal_with_open_datasets
>>>
>>> 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 
>>> 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  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@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 
 Facebook: Ilario Valdelli 
 Twitter: Ilario Valdelli 
 Linkedin: Ilario Valdelli
 
  Tel: +41764821371
 http://www.wikimedia.ch

 ___
 Wikidata-l mailing list
 Wikidata-l@lists.wikimedia.org
 https://lists.wikimedia.org/mailman/listinfo/wikidata-l


>>>
>>>
>>> --
>>> Etiamsi omnes, ego non
>>>
>>> ___
>>> Wikidata-l mailing list
>>> Wikidata-l@lists.wikimedia.org
>>> https://lists.wikimedia.org/mailman/listinfo/wikidata-l
>>>
>>>
>>
>> ___
>> Wikidata-l mailing list
>> Wikidata-l@lists.wikimedia.org
>> https://lists.wikimedia.org/mailman/listinfo/wikidata-l
>>
>>
>
> ___
> Wikidata-l mailing list
> Wikidata-l@lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/wikidata-l
>
>
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l

Re: [Wikidata-l] Tables

[Joe Filceolaire]

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  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 :
>
> Please, leave your comments here too:
>>
>> https://meta.wikimedia.org/wiki/Requests_for_comment/How_to_deal_with_open_datasets
>>
>> 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 
>> 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  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@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 
>>> Facebook: Ilario Valdelli 
>>> Twitter: Ilario Valdelli 
>>> Linkedin: Ilario Valdelli
>>> 
>>>  Tel: +41764821371
>>> http://www.wikimedia.ch
>>>
>>> ___
>>> Wikidata-l mailing list
>>> Wikidata-l@lists.wikimedia.org
>>> https://lists.wikimedia.org/mailman/listinfo/wikidata-l
>>>
>>>
>>
>>
>> --
>> Etiamsi omnes, ego non
>>
>> ___
>> Wikidata-l mailing list
>> Wikidata-l@lists.wikimedia.org
>> https://lists.wikimedia.org/mailman/listinfo/wikidata-l
>>
>>
>
> ___
> Wikidata-l mailing list
> Wikidata-l@lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/wikidata-l
>
>
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l

Re: [Wikidata-l] Tables

[Jan Kučera]

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 :

> Please, leave your comments here too:
>
> https://meta.wikimedia.org/wiki/Requests_for_comment/How_to_deal_with_open_datasets
>
> 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 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  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@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 
>> Facebook: Ilario Valdelli 
>> Twitter: Ilario Valdelli 
>> Linkedin: Ilario Valdelli
>>  Tel: +41764821371
>> http://www.wikimedia.ch
>>
>> ___
>> Wikidata-l mailing list
>> Wikidata-l@lists.wikimedia.org
>> https://lists.wikimedia.org/mailman/listinfo/wikidata-l
>>
>>
>
>
> --
> Etiamsi omnes, ego non
>
> ___
> Wikidata-l mailing list
> Wikidata-l@lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/wikidata-l
>
>
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l

Re: [Wikidata-l] Tables

[David Cuenca]

Please, leave your comments here too:
https://meta.wikimedia.org/wiki/Requests_for_comment/How_to_deal_with_open_datasets

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  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  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@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 
> Facebook: Ilario Valdelli 
> Twitter: Ilario Valdelli 
> Linkedin: Ilario Valdelli
>  Tel: +41764821371
> http://www.wikimedia.ch
>
> ___
> Wikidata-l mailing list
> Wikidata-l@lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/wikidata-l
>
>


-- 
Etiamsi omnes, ego non
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l

Re: [Wikidata-l] Tables

[Ilario Valdelli]

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  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@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 
Facebook: Ilario Valdelli 
Twitter: Ilario Valdelli 
Linkedin: Ilario Valdelli 
Tel: +41764821371
http://www.wikimedia.ch
___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l

Re: [Wikidata-l] Tables

[Daniel Kinzler]

Am 27.05.2014 13:15, schrieb Jan Kučera:
> Hi there,
> 
> can tables be stored within wikidata database? I mean simple 2D tables like
> excel spreadsheets...

No. The data structure does not lend itself to representing tabular data easily.

I think a separate extension for handling tabular data (probably as CSV) would
be quite nice. It wouldn't be hard to do either. But I'm not sure how that would
tie into wikidata as a project.

-- daniel


-- 
Daniel Kinzler
Senior Software Developer

Wikimedia Deutschland
Gesellschaft zur Förderung Freien Wissens e.V.

___
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l