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.JoeOn Sun, Jun 15, 2014 at 1:24 PM, Yury Katkov <katkov.juriy@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" property and populate all these mayors like here:-----
Yury KatkovOn Sun, Jun 15, 2014 at 1:56 PM, Thomas Douillard <thomas.douillard@gmail.com> wrote: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 ?and conventions that they plly to persons. Some may also requires qualifiers.* A "Phone number" propertycan totally be implemented in Wikidata with two properties and some conventions :John 12345 New YorkName Phone-Number CityHi yan, simple 2d tables are just really an implementation of a set of relations.For example the tabular datas like an adress book like
Katie 23456 Paris
* A "living place" property
2014-06-15 13:43 GMT+02:00 Jan Kučera <kozuch82@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 <kozuch82@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 <filceolaire@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?JoeOn 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...Jan2014-05-27 14:24 GMT+02:00 David Cuenca <dacuetu@gmail.com>:Please, leave your comments here too: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,MicruEtiamsi omnes, ego nonOn 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.
Excel is considered also a tool to do some basic analysis, but it can be connected easily to a data source (if well structured).
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 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.
RegardsOn 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
--Linkedin: Ilario ValdelliTwitter: Ilario ValdelliFacebook: Ilario ValdelliIlario ValdelliWikipedia: Ilario
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
_______________________________________________
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
_______________________________________________
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