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