Thanks Tom, Petar also pointed this to me
On Sun, Nov 6, 2016 at 11:27 PM, Tom Morris <tfmor...@gmail.com> wrote:
> Perhaps here: https://github.com/dbpedia/dbpedia/tree/master/
> tools/DBpediaAsTables
>
> On Sun, Nov 6, 2016 at 10:24 AM, Dimitris Kontokostas <jimk...@gmail.com>
> wrote:
>
>> Hi Petar,
>>
>> There is some interest to revive this project and cannot recall / find
>> where is the code to generate these dumps.
>> Will you be able to help us re-bootstrap this?
>> We can create a standalone github repo and we will try to find a new
>> maintainer
>>
>> Cheers,
>> Dimtiris
>>
>> On Fri, Dec 13, 2013 at 2:07 AM, Petar Ristoski <
>> petar.risto...@informatik.uni-mannheim.de> wrote:
>>
>>> Hi Pablo,
>>>
>>>
>>>
>>> I set up a web page [1] where all classes from the DBpedia ontology are
>>> available for download as separate .csv and .json files.
>>>
>>>
>>>
>>> Regards,
>>>
>>>
>>>
>>> Petar
>>>
>>>
>>>
>>> [1] http://web.informatik.uni-mannheim.de/DBpediaAsTables/DBpedi
>>> aClasses.htm
>>>
>>>
>>>
>>>
>>>
>>> *From:* Pablo N. Mendes [mailto:pablomen...@gmail.com]
>>> *Sent:* Thursday, December 12, 2013 4:44 PM
>>> *To:* Petar Ristoski
>>> *Cc:* ibu ☉ radempa ䷰; dbpedia-discussion@lists.sourceforge.net
>>>
>>> *Subject:* Re: [Dbpedia-discussion] DBpedia as Tables release
>>>
>>>
>>>
>>>
>>>
>>> Hi Petar,
>>>
>>> Thanks for sharing this! Tried to use it yesterday, but 3GB still takes
>>> quite a long time to download if you're just hacking something together
>>> from a Starbucks. >From the standpoint of practicality, this would be
>>> infinitely more useful if we could download files individually, or at least
>>> in smaller chunks.
>>>
>>>
>>>
>>> Any chance we'll get something like that shared from [1]?
>>>
>>>
>>>
>>> Cheers,
>>>
>>> Pablo
>>>
>>>
>>>
>>> [1] http://wiki.dbpedia.org/DBpediaAsTables
>>>
>>>
>>>
>>> On Thu, Nov 28, 2013 at 5:35 AM, Petar Ristoski <
>>> petar.risto...@informatik.uni-mannheim.de> wrote:
>>>
>>> Hi Ibu,
>>>
>>> Thank you for your feedback.
>>>
>>> To simplify the parsing of the files, from all literals I removed the
>>> following characters: "\" { } | , \n". If there are quotes in the URIs,
>>> they are escaped as '""'. Also, there is no URI that starts with"{" and
>>> ends with "}", so there is no need to escape "{ } |" inside the URIs.
>>>
>>> I apologize for those two incorrectly parsed files. I fixed them couple
>>> of days ago, so please download them again.
>>>
>>> Regards,
>>>
>>> Petar
>>>
>>>
>>> -----Original Message-----
>>> From: ibu ☉ radempa ䷰ [mailto:i...@radempa.de]
>>> Sent: Wednesday, November 27, 2013 10:00 PM
>>> To: dbpedia-discussion@lists.sourceforge.net
>>> Subject: Re: [Dbpedia-discussion] DBpedia as Tables release
>>>
>>> On 11/25/2013 02:18 PM, Petar Ristoski wrote:
>>> > We are happy to announce the first version of the DBpedia as Tables
>>> > tool [1].
>>>
>>> > Any feedback is welcome!
>>>
>>> > [1] http://wiki.dbpedia.org/DBpediaAsTables
>>>
>>> Thanks Petar,
>>>
>>> your CSV files are really helpful.
>>>
>>> For all who want to import data into Postgresql, I've written a python
>>> script which automatically creates the SQL corresponding to the CSV:
>>>
>>> https://gitorious.org/dbpedia_csv2sql/dbpedia_csv2sql
>>>
>>> The column types (ofter arrays) are inferred from your headers and the
>>> data rows; indexes are also created.
>>>
>>> (If people here find this script useful, I could also package it for
>>> pypi and improve documentation a bit.)
>>>
>>> I was assuming that your files are encoded in UTF-8, which worked, but I
>>> didn't find either a '""' or a '\"' inside a field value, so I don't know
>>> how a '"' would be encoded, if there were one. Also for a multi-value field
>>> (e.g. '{1|2|3}') I don't know how '{', '|' and '}' are encoded, if they
>>> appear within one of the values. - Maybe you could add some documentation
>>> on that.
>>>
>>> In your data I found 2 format problems (I don't think my download went
>>> wrong, but anyway, a checksum might be helpful):
>>>
>>> * Film.csv seems to have no headers (it has 20004 lines for me).
>>> * Aircraft.csv: the 2nd last row (
>>> "http://dbpedia.org/resource/Marinens_Flyvebaatfabrikk_M.F.10";
>>> ) has too many columns.
>>>
>>> All other files (except owl#Thing.csv and Agent.csv, which I didn't
>>> check due to size and column number) were ok.
>>>
>>> I also noticed another thing, not concerning your tool, where some
>>> parser maybe could be optimized:
>>> http://dbpedia.org/resource/Americas
>>> has language="American (but see [[#English usage"
>>>
>>> Regards,
>>> ibu
>>>
>>> ------------------------------------------------------------
>>> ------------------
>>> Rapidly troubleshoot problems before they affect your business. Most IT
>>> organizations don't have a clear picture of how application performance
>>> affects their revenue. With AppDynamics, you get 100% visibility into your
>>> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
>>> Pro!
>>> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4
>>> 140/ostg.clktrk
>>> _______________________________________________
>>> Dbpedia-discussion mailing list
>>> Dbpedia-discussion@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
>>>
>>>
>>>
>>> ------------------------------------------------------------
>>> ------------------
>>> Rapidly troubleshoot problems before they affect your business. Most IT
>>> organizations don't have a clear picture of how application performance
>>> affects their revenue. With AppDynamics, you get 100% visibility into
>>> your
>>> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of
>>> AppDynamics Pro!
>>> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4
>>> 140/ostg.clktrk
>>> _______________________________________________
>>> Dbpedia-discussion mailing list
>>> Dbpedia-discussion@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
>>>
>>>
>>>
>>>
>>>
>>> --
>>>
>>>
>>>
>>> Pablo N. Mendes
>>>
>>> http://pablomendes.com
>>>
>>> ------------------------------------------------------------
>>> ------------------
>>> Rapidly troubleshoot problems before they affect your business. Most IT
>>> organizations don't have a clear picture of how application performance
>>> affects their revenue. With AppDynamics, you get 100% visibility into
>>> your
>>> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of
>>> AppDynamics Pro!
>>> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4
>>> 140/ostg.clktrk
>>> _______________________________________________
>>> Dbpedia-discussion mailing list
>>> Dbpedia-discussion@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
>>>
>>>
>>
>>
>> --
>> Kontokostas Dimitris
>>
>> ------------------------------------------------------------
>> ------------------
>> Developer Access Program for Intel Xeon Phi Processors
>> Access to Intel Xeon Phi processor-based developer platforms.
>> With one year of Intel Parallel Studio XE.
>> Training and support from Colfax.
>> Order your platform today. http://sdm.link/xeonphi
>> _______________________________________________
>> DBpedia-discussion mailing list
>> DBpedia-discussion@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
>>
>>
>
--
Kontokostas Dimitris
------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
_______________________________________________
DBpedia-discussion mailing list
DBpedia-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
