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