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