Hi Nicola,
Development indicate that some of the polygon data in this beta wikidata
dataset to bad the co-oridinates probably being in the wrong order as indicated
when one of these point co-ordinates is checked with the st_ewkt_read [1]
function:
SQL> select st_ewkt_read ('Point(37.766666666667 -122.43333333333)');
*** Error 22023: VD [Virtuoso Server]GEO11: The point coordinates are spherical
degrees and the latitude is out of range -90..90 (near row 1 col 39 of
'Point(37.766666666667 -122.43333333333)')
and should be reported to creators of the dataset ...
[1] http://docs.openlinksw.com/virtuoso/fn_st_ewkt_read.html
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
> On 11 Sep 2015, at 04:55, Hugh Williams <[email protected]> wrote:
>
> Hi Nicola,
>
> Will need to check with development as it depends on there schedules as to
> when this can be looked into …
>
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software, Inc. // http://www.openlinksw.com/
> Weblog -- http://www.openlinksw.com/blogs/
> LinkedIn -- http://www.linkedin.com/company/openlink-software/
> Twitter -- http://twitter.com/OpenLink
> Google+ -- http://plus.google.com/100570109519069333827/
> Facebook -- http://www.facebook.com/OpenLinkSoftware
> Universal Data Access, Integration, and Management Technology Providers
>
>> On 10 Sep 2015, at 12:30, Nicola Vitucci <[email protected]> wrote:
>>
>> Thanks for looking into this, Hugh. Any idea when an update might be
>> available?
>>
>> Nicola
>>
>> Il 10/09/2015 03:47, Hugh Williams ha scritto:
>>> Hi Nicola,
>>>
>>> I have been able to recreate this issue loading the wikidata beta
>>> dataset and have reported to development to look into …
>>>
>>> Best Regards
>>> Hugh Williams
>>> Professional Services
>>> OpenLink Software, Inc. // http://www.openlinksw.com/
>>> Weblog -- http://www.openlinksw.com/blogs/
>>> LinkedIn -- http://www.linkedin.com/company/openlink-software/
>>> Twitter -- http://twitter.com/OpenLink
>>> Google+ -- http://plus.google.com/100570109519069333827/
>>> Facebook -- http://www.facebook.com/OpenLinkSoftware
>>> Universal Data Access, Integration, and Management Technology Providers
>>>
>>>> On 9 Sep 2015, at 13:44, Hugh Williams <[email protected]
>>>> <mailto:[email protected]>> wrote:
>>>>
>>>> Hi Nicola,
>>>>
>>>> Ok, I am downloading the 7+GB file atm and will attempt a load …
>>>>
>>>> Best Regards
>>>> Hugh Williams
>>>> Professional Services
>>>> OpenLink Software, Inc. // http://www.openlinksw.com/
>>>> Weblog -- http://www.openlinksw.com/blogs/
>>>> LinkedIn -- http://www.linkedin.com/company/openlink-software/
>>>> Twitter -- http://twitter.com/OpenLink
>>>> Google+ -- http://plus.google.com/100570109519069333827/
>>>> Facebook -- http://www.facebook.com/OpenLinkSoftware
>>>> Universal Data Access, Integration, and Management Technology Providers
>>>>
>>>>> On 9 Sep 2015, at 13:10, Nicola Vitucci <[email protected]
>>>>> <mailto:[email protected]>> wrote:
>>>>>
>>>>> Hi Hugh,
>>>>>
>>>>> I tried to load it with the standard command:
>>>>>
>>>>> ttlp_mt (file_to_string_output ('/path/to/file'), '', 'graphname')
>>>>>
>>>>> The dataset is a single big Turtle file (not separate files as it used
>>>>> to be), so right now I can't pinpoint the exact part which caused it to
>>>>> fail. I'll try and investigate further as well.
>>>>>
>>>>> Nicola
>>>>>
>>>>> Il 09/09/2015 13:58, Hugh Williams ha scritto:
>>>>>> Hi Nicola,
>>>>>>
>>>>>> Yes, Virtuoso open source does have geo spatial support including
>>>>>> support for GeoSPARQL and OGC types . How are you loading this new
>>>>>> wikidata “beta” dataset and do you know on which dataset or triple this
>>>>>> error is occurring ?
>>>>>>
>>>>>> We have loaded previous wikidata datasets which I would expect contained
>>>>>> geo spatial data , so will have to download and try this new beta to see
>>>>>> if problem can be reproduced locally …
>>>>>>
>>>>>> Best Regards
>>>>>> Hugh Williams
>>>>>> Professional Services
>>>>>> OpenLink Software, Inc. // http://www.openlinksw.com/
>>>>>> Weblog -- http://www.openlinksw.com/blogs/
>>>>>> LinkedIn -- http://www.linkedin.com/company/openlink-software/
>>>>>> Twitter -- http://twitter.com/OpenLink
>>>>>> Google+ -- http://plus.google.com/100570109519069333827/
>>>>>> Facebook -- http://www.facebook.com/OpenLinkSoftware
>>>>>> Universal Data Access, Integration, and Management Technology Providers
>>>>>>
>>>>>>> On 9 Sep 2015, at 11:48, Nicola Vitucci <[email protected]
>>>>>>> <mailto:[email protected]>
>>>>>>> <mailto:[email protected]>> wrote:
>>>>>>>
>>>>>>> Hi all,
>>>>>>>
>>>>>>> I tried to load a recent Wikidata dump [1] on Virtuoso v. 07.20.3214
>>>>>>> (64-bit Linux OS), but I get the following error:
>>>>>>>
>>>>>>> *** Error 42000: [Virtuoso Driver][Virtuoso Server]RDFGE: RDF box
>>>>>>> with a
>>>>>>> geometry RDF type and a non-geometry content
>>>>>>>
>>>>>>> Is GeoSPARQL not fully supported yet? If not, is there any temporary
>>>>>>> workaround?
>>>>>>>
>>>>>>> Thanks,
>>>>>>>
>>>>>>> Nicola
>>>>>>>
>>>>>>> [1]
>>>>>>> https://dumps.wikimedia.org/wikidatawiki/entities/20150907/wikidata-20150907-all-BETA.ttl.gz
>>>>>>>
>>>>>>> ------------------------------------------------------------------------------
>>>>>>> Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
>>>>>>> Get real-time metrics from all of your servers, apps and tools
>>>>>>> in one place.
>>>>>>> SourceForge users - Click here to start your Free Trial of Datadog now!
>>>>>>> http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140
>>>>>>> _______________________________________________
>>>>>>> Virtuoso-users mailing list
>>>>>>> [email protected]
>>>>>>> <mailto:[email protected]>
>>>>>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>>>
>>>> ------------------------------------------------------------------------------
>>>> Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
>>>> Get real-time metrics from all of your servers, apps and tools
>>>> in one place.
>>>> SourceForge users - Click here to start your Free Trial of Datadog now!
>>>> http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140_______________________________________________
>>>> Virtuoso-users mailing list
>>>> [email protected]
>>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>>
>>
>> ------------------------------------------------------------------------------
>> Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
>> Get real-time metrics from all of your servers, apps and tools
>> in one place.
>> SourceForge users - Click here to start your Free Trial of Datadog now!
>> http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140
>> _______________________________________________
>> Virtuoso-users mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users