Re: [Wikidata-l] Tables

2014-08-22 Thread 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 filceola...@gmail.com:

 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 filceola...@gmail.com 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 katkov.ju...@gmail.com
 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
 https://www.wikidata.org/wiki/Property:P6 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 kozuc...@gmail.com:

 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 kozuc...@gmail.com:

 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 filceola...@gmail.com:

 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 kozuc...@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 dacu...@gmail.com:

 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 

Re: [Wikidata-l] Tables

2014-08-22 Thread 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 dacu...@gmail.com 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 kozuc...@gmail.com 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 filceola...@gmail.com:

 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 filceola...@gmail.com 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 katkov.ju...@gmail.com
 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
 https://www.wikidata.org/wiki/Property:P6 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 kozuc...@gmail.com:

 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 kozuc...@gmail.com:

 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 filceola...@gmail.com
 :

 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 kozuc...@gmail.com
 wrote:

 Well what I meant was just an ordinary 2-dimensional table (rows
 vs. 

Re: [Wikidata-l] Tables

2014-06-16 Thread 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 filceola...@gmail.com 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 katkov.ju...@gmail.com
 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
 https://www.wikidata.org/wiki/Property:P6 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 kozuc...@gmail.com:

 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 kozuc...@gmail.com:

 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 filceola...@gmail.com:

 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 kozuc...@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 dacu...@gmail.com:

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

Re: [Wikidata-l] Tables

2014-06-15 Thread 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 kozuc...@gmail.com:

 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 filceola...@gmail.com:

 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 kozuc...@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 dacu...@gmail.com:

 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 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 kozuc...@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@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@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

2014-06-15 Thread 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 kozuc...@gmail.com:

 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 kozuc...@gmail.com:

 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 filceola...@gmail.com:

 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 kozuc...@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 dacu...@gmail.com:

 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 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 kozuc...@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@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@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

2014-06-03 Thread 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 filceola...@gmail.com:

 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 kozuc...@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 dacu...@gmail.com:

 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 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 kozuc...@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@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@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

2014-05-30 Thread 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 kozuc...@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 dacu...@gmail.com:

 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
 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 kozuc...@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@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@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

2014-05-28 Thread 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 dacu...@gmail.com:

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

 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 kozuc...@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@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 Valdellihttp://www.linkedin.com/profile/view?id=6724469
  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

2014-05-27 Thread 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


Re: [Wikidata-l] Tables

2014-05-27 Thread 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 kozuc...@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@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@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l


Re: [Wikidata-l] Tables

2014-05-27 Thread 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
 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 kozuc...@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@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 Valdellihttp://www.linkedin.com/profile/view?id=6724469
  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