Hi Maria, You should use http://www.openlinksw.com/schemas/virtrdf#Geometry instead of http://www.w3.org/2003/01/geo/wgs84_pos#Geometry as the geometry type in the datasets being loaded then it will work. Note also that -122.934 is not a valid Geometry value which should be -90 to 90 , otherwise you get a message to that effect when trying to load:
SQL> DB.DBA.TTLP_MT (file_to_string_output('./spatialTest2.nq'),
'','<http://localhost:8890/DAV/dbpedia>',512);
*** 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 24 of 'POINT
(2.79723 -122.934)')
in
__xqf_str_parse_to_rdf_box:(BIF),
DB.DBA.TTLP_RL_GS_TRIPLE_L([executable]/ttlpv.sql:418),
rdf_load_turtle:(BIF),
DB.DBA.TTLP_V_GS([executable]/ttlpv.sql:503),
DB.DBA.TTLP_V([executable]/ttlpv.sql:562),
DB.DBA.TTLP_MT([executable]/sparql.sql:14626),
<Top Level>
at line 1 of Top-Level:
DB.DBA.TTLP_MT (file_to_string_output('./spatialTest2.nq'),
'','<http://localhost:8890/DAV/dbpedia>',512)
SQL>
So I changed -122 to -22 then it loaded and could be queried:
SQL> DB.DBA.TTLP_MT (file_to_string_output('./spatialTest2.nq'),
'','<http://localhost:8890/DAV/dbpedia>',512);
Done. -- 10 msec.
SQL> sparql select ?place ?nplace (( bif:st_distance( ?long,?nlong) ) AS
?distance) WHERE {graph ?g1{?place
<http://www.opengis.net/ont/geosparql#asWKT> ?long} graph ?g4{?nplace
<http://www.opengis.net/ont/geosparql#asWKT> ?nlong}};
place
nplace
distance
LONG VARCHAR
LONG VARCHAR
LONG VARCHAR
_______________________________________________________________________________
http://geoknow.eu/uk_natural#natural_2817555
http://geoknow.eu/uk_natural#natural_2371851
10037.6492893785
http://geoknow.eu/uk_natural#natural_2371851
http://geoknow.eu/uk_natural#natural_2371851
0
http://geoknow.eu/uk_natural#natural_2729539
http://geoknow.eu/uk_natural#natural_2371851
155.568494101203
http://geoknow.eu/uk_natural#natural_2817555
http://geoknow.eu/uk_natural#natural_2817555
0
http://geoknow.eu/uk_natural#natural_2371851
http://geoknow.eu/uk_natural#natural_2817555
10037.6492893785
http://geoknow.eu/uk_natural#natural_2729539
http://geoknow.eu/uk_natural#natural_2817555
10146.95393036408
http://geoknow.eu/uk_natural#natural_2817555
http://geoknow.eu/uk_natural#natural_2729539
10146.95393036408
http://geoknow.eu/uk_natural#natural_2371851
http://geoknow.eu/uk_natural#natural_2729539
155.568494101203
http://geoknow.eu/uk_natural#natural_2729539
http://geoknow.eu/uk_natural#natural_2729539
0
9 Rows. -- 8 msec.
SQL>
Finally note we are planning to also support the
http://www.w3.org/2003/01/geo/wgs84_pos#Geometry geometry type for which we
have an internal issue tracker report to implement …
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 Apr 2016, at 15:22, Maria Jackson <[email protected]> wrote:
>
> Dear Hugh,
>
> Thanks for all the information. One of my students tried to load POINT
> data in Virtuoso, but ended up getting the following error, can you
> please suggest as to where are we going wrong:
>
> I loaded the following file in Virtuoso (version 07.20.3213):
> "<http://geoknow.eu/uk_natural#natural_2371851>
> <http://www.opengis.net/ont/geosparql#asWKT> "POINT (77.164230
> 33.187725)"^^<http://www.w3.org/2003/01/geo/wgs84_pos#Geometry>
> <http://a/id_1>.
> <http://geoknow.eu/uk_natural#natural_2729539>
> <http://www.opengis.net/ont/geosparql#asWKT> "POINT (78.748611
> 32.748742)"^^<http://www.w3.org/2003/01/geo/wgs84_pos#Geometry>
> <http://a/id_4>.
> <http://geoknow.eu/uk_natural#natural_2817555>
> <http://www.opengis.net/ont/geosparql#asWKT> "POINT (2.79723
> -122.934)"^^<http://www.w3.org/2003/01/geo/wgs84_pos#Geometry>
> <http://a/id_7>."
>
> using: DB.DBA.TTLP_MT (file_to_string_output
> ('/home/virtuoso/share/virtuoso/vad/spatialTest.nq'), '',
> '<http://localhost:8890/DAV/dbpedia>',512);
>
> After which I ran the following query:
> SQL> sparql select ?place ?nplace (( bif:st_distance( ?long,?nlong) )
> AS ?distance) WHERE {graph ?g1{?place
> <http://www.opengis.net/ont/geosparql#asWKT> ?long} graph ?g4{?nplace
> <http://www.opengis.net/ont/geosparql#asWKT> ?nlong}};
>
> The error which I am getting is:
> *** Error 22032: [Virtuoso Driver][Virtuoso Server]GEO..: Function
> st_distance() expects a geometry as argument 0
> at line 6 of Top-Level:
> sparql select ?place ?nplace (( bif:st_distance( ?long,?nlong) ) AS
> ?distance) WHERE {graph ?g1{?place
> <http://www.opengis.net/ont/geosparql#asWKT> ?long} graph ?g4{?nplace
> <http://www.opengis.net/ont/geosparql#asWKT> ?nlong}}
>
>
>
> On Thu, Feb 25, 2016 at 4:34 PM, Hugh Williams <[email protected]>
> wrote:
>> Hi Maria,
>>
>> Development have confirmed that st_distance only works with points and we
>> are currently working on integration of the GEOS Library plugin
>> (http://trac.osgeo.org/geos/) into Virtuoso which will give distances
>> between other Geometry types, but is work in progress and will probably be
>> part of the next Virtuoso open source release. Thus unfortunately we are not
>> able to provide a solution currently ...
>>
>> 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 25 Feb 2016, at 09:22, Maria Jackson <[email protected]> wrote:
>>
>> Dear Hugh,
>>
>> Thanks a lot for looking into this :)
>>
>> As I have a deadline, therefore I would greatly appreciate if the
>> development team could reply soon :)
>>
>> On Thu, Feb 25, 2016 at 5:44 AM, Hugh Williams <[email protected]>
>> wrote:
>>
>> Hi Maria,
>>
>> We are checking this with development as I have found another occurrence of
>> this error also and do believe the st_distance() function only works with
>> points …
>>
>> There are two other functions, haversine_deg_km() &
>> dist_from_point_to_line_segment() documented at:
>>
>>
>> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtGeoSPARQLEnhancementDocs
>>
>> but they don’t seem to work either …
>>
>> 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
>>
>>
>>
>>
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
_______________________________________________ Virtuoso-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
