Simple tables that are in wikipedia: * league tables with columns for games won, drawn, lost, goals for, goals against, points, rank and rows for each of the teams in the league. * election results with columns for votes for each party and seats won by each party and rows for each region, state etc. * population numbers with columns for each tab (races, religion etc.) and rows for each census district.
In all of these cases I suspect that this information might be more useful as a series of statements. These could either be broken up with a statement corresponding to each column on the item for each row or alternatively with all the information in the table on one item, a statement for each row and qualifiers to each statement corresponding to each column.
What is the advantage to having this as a table instead?
Joe
On Wed, May 28, 2014 at 9:12 PM, Jan Kučera kozuch82@gmail.com wrote:
Well what I meant was just an ordinary 2-dimensional table (rows vs. columns)... Excel was just an example to make it clear.
So I guess simple tables are not any roadmap yet right?
Further step would be an n-dimensional structures... arrays etc.
I wouldnt care about format.... CSV, JSON...
Jan
2014-05-27 14:24 GMT+02:00 David Cuenca dacuetu@gmail.com:
Please, leave your comments here too:
https://meta.wikimedia.org/wiki/Requests_for_comment/How_to_deal_with_open_d...
I've been gathering comments from several people, and in the next days I will try to summarize these suggestions to be discussed on irc.
Thanks, Micru
On Tue, May 27, 2014 at 2:12 PM, Ilario Valdelli valdelli@gmail.com wrote:
I am not an expert of Wikidata but I work a lot in integration of databases with several middlewares or tools.
I think that the best way is to ask a solution to store and to download data in a format compatible with datasheets like CSV.
Excel is considered also a tool to do some basic analysis, but it can be connected easily to a data source (if well structured).
Excel itself is not a good approach to store data, so it's not a good solution to keep the data in excel format in a database.
Doesn't make sense to store a 2D tables in a database in my opinion because the data have no sense and they are not helpful to anyone.
They can be stored like a text file, but I would not imagine the series of errors that can be generated importing these data again.
Regards
On Tue, May 27, 2014 at 1:15 PM, Jan Kučera kozuch82@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