Re: [Virtuoso-users] geometry data type in virtuoso

2016-11-11 Thread Kingsley Idehen 
On 11/11/16 12:04 PM, Peter F. Patel-Schneider wrote:
> My experience is different.  I refreshed virtuoso opensource to the version of
> 9 November.  When I tried to load a file with the triple I got an error.
>
>
> idefix /home/virtuoso/var/lib/virtuoso/db> /home/virtuoso/bin/isql  dba 
> dba
> Connected to OpenLink Virtuoso
> Driver: 07.20.3217 OpenLink Virtuoso ODBC Driver
> OpenLink Interactive SQL (Virtuoso), version 0.9849b.
> Type HELP; for help and EXIT; to exit.
> SQL> DELETE FROM DB.DBA.load_list;
>
> Done. -- 4 msec.
> SQL> ld_dir ('/home/local/SoftwareDownloads/wikidata',
> 'wikidata-mars.ttl', 'http://bkr.nuance.com/wikidata');
>
> Done. -- 3 msec.
> SQL> rdf_loader_run();
> 08:53:19 PL LOG: Loader started
> 08:53:19 PL LOG:  File
> /home/local/SoftwareDownloads/wikidata/wikidata-mars.ttl error 42000 RDFGE:
> RDF box with a geometry RDF type and a non-geometry content
> 08:53:19 PL LOG: No more files to load. Loader has finished,
>
> Done. -- 8 msec.
> SQL> idefix /home/virtuoso/var/lib/virtuoso/db>
> /home/virtuoso/bin/virtuoso-t --version
> Virtuoso Open Source Edition (Column Store) (multi threaded)
> Version 7.2.5-dev.3217-pthreads as of Nov  9 2016
> Compiled for Linux (x86_64-unknown-linux-gnu)
> Copyright (C) 1998-2016 OpenLink Software
>
> I think that the URL for geo: in your file is not one that is recognized by
> virtuoso as the namespace for the geospatial datatype.
>
> wikidata-mars.ttl has
> @prefix geo:  .
> which is taken from the wikidata RDF dump.
>
> Your file has
> @prefix geo:   .
>
> peter

Yes, he following isn't being loaded for overzealous reasons:
@prefix wdt:  .
@prefix wd:  .
@prefix wikibase:  .
@prefix geo:  .

wd:Q24227 a wikibase:Item ;
wdt:P625 " 
Point(351.83-14.47)"^^gro:wktLiteral .

It should load, even if Vituoso can't make sense of the geometric
context with regards to SPARQL queries etc..

Kingsley
>
>
>> Peter,
>>
>> I mispoke about SPARQL and GeoSPARQL. My apologies for the confusion.
>>
>> The triple is valid and it loads, as per the simple test I have at:
>>
>> http://kingsley.idehen.net/DAV/home/kidehen/Public/Linked%20Data%20Documents/Nanotations/test.ttl
>> .
>>
>> or:
>>
>>  curl -i
>> http://kingsley.idehen.net/DAV/home/kidehen/Public/Linked%20Data%20Documents/Nanotations/test.ttl
>>
>>
>> Thus, we need to figure out if this is something to do with the version you
>> are workings with (as my versions are typically hot of the press etc..).
>>
>> -- 
>> Regards,
>>
>> Kingsley Idehen
>> Founder & CEO 
>> OpenLink Software   (Home Page: http://www.openlinksw.com)
>>
>> Weblogs (Blogs):
>> Legacy Blog: http://www.openlinksw.com/blog/~kidehen/
>> Blogspot Blog: http://kidehen.blogspot.com
>> Medium Blog: https://medium.com/@kidehen
>>
>> Profile Pages:
>> Pinterest: https://www.pinterest.com/kidehen/
>> Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen
>> Twitter: https://twitter.com/kidehen
>> Google+: https://plus.google.com/+KingsleyIdehen/about
>> LinkedIn: http://www.linkedin.com/in/kidehen
>>
>> Web Identities (WebID):
>> Personal: http://kingsley.idehen.net/dataspace/person/kidehen#this
>> : 
>> http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this
>>
>>
>>
>> --
>> 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
>>
>>
>>
>> ___
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>
>>
>>
>> --
>> 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
>>
>>
>> ___
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users


-- 
Regards,

Kingsley Idehen   
Founder & CEO 
OpenLink Software   (Home Page: http://www.openlinksw.com)

Weblogs (Blogs):
Legacy Blog: http://www.openlinksw.com/blog/~kidehen/
Blogspot Blog: http://kidehen.blogspot.com
Medium Blog: https://medium.com/@kidehen

Profile Pages:
Pinterest: https://www.pinterest.com/kidehen/
Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen
Twitter:

Re: [Virtuoso-users] geometry data type in virtuoso

2016-11-11 Thread Kingsley Idehen 
On 11/10/16 4:19 PM, Peter F. Patel-Schneider wrote:
> I modified rdfbox.c to take out the two (!) checks that object to literals of
> type geo:wktLiteral with coordinate system URIs.  Currently I'm loading a
> wikidata dump into virtuoso and nothing is complaining (so far).
>
> I expect that working with this data will produce query-time errors when
> trying to do geographic operations on these values.  Hopefully these errors
> will produce SPARQL errors that can be handled and not bring down virtuoso.
>
> peter
>
> PS:  I would be nice to be able to turn the errors into warnings, but I
> couldn't figure out how to do that.
>
> PPS:  It also would be nice to have an option that ignores triples with
> problems when loading large RDF documents.  I think that this has been asked
> for in the past as well.


Loading that ignores warnings is something we are looking into.

Kingsley
>
>
> On 11/10/2016 05:29 AM, Jerven Tjalling Bolleman wrote:
>> Dear Kingsley,
>>
>> I imagine that Peter is referring to
>>
>> Req 10
>>All RDFS Literals of type geo:wktLiteral shall consist of an
>> optional URI identifying the coordinate reference system followed by
>> Simple Features Well Known Text (WKT) describing a geometric value.
>> Valid geo:wktLiterals are formed by concatenating a valid,
>> absolute URI as defined in [RFC 2396], one or more spaces (Unicode
>> U+0020 character) as a separator, and a WKT string as defined in
>> Simple Features [ISO 19125-1].
>>
>>  From page vii of the GeoSPARQL standard. However, I can imagine that you 
>> have
>> few customers demanding GeoSPARQL support for Mars at this time ;)
>>
>> So it is just a feature not yet implemented...
>>
>> Regards,
>> Jerven
>>
>> On 2016-11-10 14:06, Kingsley Idehen wrote:
>>> On 11/9/16 10:25 PM, Peter F. Patel-Schneider wrote:
 Through a process of bisection I found the datum that is not handled 
 by
 virtuoso.  It is

 wd:Q24227 a wikibase:Item ;
wdt:P625 " Point(351.83
 -14.47)"^^geo:wktLiteral .

 i.e., a point on Mars.

 Is virtuoso supposed to be able to handle other coordinate systems?  
 If not,
 how can it handle Wikidata and other information sources that have 
 points not
 on the surface of the earth?

 peter
>>> A valid RDF triple (or datum) would take the form:
>>>
>>> wd:Q24227 a wikibase:Item ;
>>> wdt:P625 "Point(351.83-14.47)"^^geo:wktLiteral .
>>>
>>> Thus, you have a problematic triple.
>>>
>>>
>>> Kingsley
>>>
>>>

 On 11/08/2016 07:23 PM, Hugh Williams wrote:
> Hi Peter,
>
> What is the Virtuoso version your are using ( run “virtuoso-t -?”) ?
>
> Against the latest 07.20.3217 build the following point geometry 
> loads
> successfully with the ttlp function:
>
> SQL> ttlp ('@prefix geo:  
> @prefix
> virtrdf:   
> geo:geometry
> "point(1.2 22.4"^^virtrdf:Geometry .', 'xxx', 'graph');
>
> Done. -- 10 msec.
> SQL> sparql select * from  where {?s ?p ?o};
> s
> p
> o
> LONG VARCHAR
> LONG VARCHAR
> LONG VARCHAR
> ___
>
> http://xxx/point
> http://www.w3.org/2003/01/geo/wgs84_pos#geometry
> POINT(1.200476837 22.3961853)
>
> 1 Rows. -- 2 msec.
> SQL>
>
> 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 Nov 2016, at 02:34, Peter F. Patel-Schneider 
>> > > wrote:
>>
>> Hi:
>>
>> I'm trying to get virtuoso to work with geometry data types.
>>
>> I noticed that the version of virtuoso that I am using requires that 
>> the data
>> type names be in ALL CAPS (e.g., POINT).   Has this been fixed in 
>> the current
>> version of virtuoso?
>>
>> peter
>>
>> --
>> 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
>> ___
>> Virtuoso-users mailing list

[Virtuoso-users] REGEX flavor

2016-11-11 Thread Lorenz B. 
Dear Virtuoso team,

I've got a small question which came up during the discussion here [1].
Which kind of REGEX engine/flavor does Virtuoso (7.x) implement? I
couldn't find anything in the documentation but probably I overlooked
the relevant part :D


[1] http://stackoverflow.com/questions/40437602/sparql-regex-flavor/

Kind regards,

Lorenz 



-- 
Lorenz Bühmann
AKSW group, University of Leipzig
Group: http://aksw.org - semantic web research center

--
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___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users