Re: [Virtuoso-users] Virtuoso taking long time

[Maria Jackson]

A gentle reminder. I'll greatly appreciate if you could explain the meaning
of these terms?

On Mon, Aug 1, 2016 at 3:04 PM, Maria Jackson 
wrote:

> Dear Hugh,
>
> Thanks a lot, but the webpage
> <http://docs.openlinksw.com/virtuoso/perfdiag/> does not seem to explain
> what "ro2sq", "inlined" and "artm" mean?
>
> On Thu, Jul 28, 2016 at 6:50 PM, Hugh Williams 
> wrote:
>
>> Hi Maria,
>>
>> The explain output is more for analysis by development, there are limited
>> description of Query Plans at http://docs.openlinksw.com/
>> virtuoso/perfdiag/ , but those params are not documented.  In terms of
>> query execution the Virtuoso profile command can be used for determining if
>> the query time is being spent in compilation rather then execution as
>> detailed at, http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/
>> VirtTipsAndTricksAanalyzingSPARQLQuery . See also http://virtuoso.
>> openlinksw.com/dataspace/doc/dav/wiki/Main/VirtQueryOptDiagnostic ...
>>
>> 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 28 Jul 2016, at 14:14, Maria Jackson 
>> wrote:
>>
>> Sorry for another mail. But just to confirm is the join used by the
>> query plan below some kind of loop join:
>>
>> {
>> RDF_QUAD_POGS 4 rows(s_1_4_t1.S)
>> P =  ##plays  ,  O =  #/Music
>> RDF_QUAD_POGS   0.8 rows(s_1_4_t0.S)
>> inlined  P =  ##type  ,  O =  ##Musician  ,  S = s_1_4_t1.S
>> Distinct (s_1_4_t0.S)
>>
>> After code:
>>  0: X :=  := artm s_1_4_t0.S
>>  4: BReturn 0
>> Subquery Select(X)
>>
>> After code:
>>  0: X := Call __ro2sq (X)
>>  5: BReturn 0
>> Select (X)
>>
>> On Thu, Jul 28, 2016 at 1:38 PM, Maria Jackson
>>  wrote:
>>
>> Dear All,
>>
>> Thank you very much for your response. However, I am not able to
>> understand the meaning of "inlined", "rosq", "artm" in Virtuoso's
>> query plans. For exposition my question contains small example query.
>>
>> Also how can I figure out which join algorithm is used by Virtuoso by
>> looking at the output of explain?
>>
>> On Thu, Jul 28, 2016 at 11:50 AM, Maria Jackson
>>  wrote:
>>
>> I apologize for another mail, but I have a deadline tomorrow so I'll
>> greatly appreciate if you could please help with this a little.
>>
>> On Wed, Jul 27, 2016 at 9:45 PM, Maria Jackson
>>  wrote:
>>
>> I ran the following query on Virtuoso:
>>
>> [code]PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
>> SELECT DISTINCT ?X
>> WHERE
>> {?X rdf:type Musician .
>> ?X rdf:plays <http://Music>}
>> [/code]
>>
>> The output of "explain" of this query is:
>> [code]{
>> RDF_QUAD_POGS 4 rows(s_1_4_t1.S)
>> P =  ##plays  ,  O =  #/Music
>> RDF_QUAD_POGS   0.8 rows(s_1_4_t0.S)
>> inlined  P =  ##type  ,  O =  ##Musician  ,  S = s_1_4_t1.S
>> Distinct (s_1_4_t0.S)
>>
>> After code:
>>  0: X :=  := artm s_1_4_t0.S
>>  4: BReturn 0
>> Subquery Select(X)
>>
>> After code:
>>  0: X := Call __ro2sq (X)
>>  5: BReturn 0
>> Select (X)
>> }
>> [/code]
>>
>> Now I am unable to decipher the output of explain command. What do
>> "ro2sq", "inlined" and "artm" mean? And which join algorithm (like
>> Hash Join, Merge Join, Nested loop join, etc.) is Virtuoso using for
>> this query? I need to understand Virtuoso's explain command in order
>> to understand the reason for Virtuoso taking a long time to execute?
>>
>>
>>
>
--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Virtuoso taking long time

[Maria Jackson]

Dear Hugh,

Thanks a lot, but the webpage
<http://docs.openlinksw.com/virtuoso/perfdiag/> does not seem to explain
what "ro2sq", "inlined" and "artm" mean?

On Thu, Jul 28, 2016 at 6:50 PM, Hugh Williams 
wrote:

> Hi Maria,
>
> The explain output is more for analysis by development, there are limited
> description of Query Plans at
> http://docs.openlinksw.com/virtuoso/perfdiag/ , but those params are not
> documented.  In terms of query execution the Virtuoso profile command
> can be used for determining if the query time is being spent in compilation
> rather then execution as detailed at,
> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksAanalyzingSPARQLQuery
>  .
> See also
> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtQueryOptDiagnostic
>  ...
>
> 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 28 Jul 2016, at 14:14, Maria Jackson 
> wrote:
>
> Sorry for another mail. But just to confirm is the join used by the
> query plan below some kind of loop join:
>
> {
> RDF_QUAD_POGS 4 rows(s_1_4_t1.S)
> P =  ##plays  ,  O =  #/Music
> RDF_QUAD_POGS   0.8 rows(s_1_4_t0.S)
> inlined  P =  ##type  ,  O =  ##Musician  ,  S = s_1_4_t1.S
> Distinct (s_1_4_t0.S)
>
> After code:
>  0: X :=  := artm s_1_4_t0.S
>  4: BReturn 0
> Subquery Select(X)
>
> After code:
>  0: X := Call __ro2sq (X)
>  5: BReturn 0
> Select (X)
>
> On Thu, Jul 28, 2016 at 1:38 PM, Maria Jackson
>  wrote:
>
> Dear All,
>
> Thank you very much for your response. However, I am not able to
> understand the meaning of "inlined", "rosq", "artm" in Virtuoso's
> query plans. For exposition my question contains small example query.
>
> Also how can I figure out which join algorithm is used by Virtuoso by
> looking at the output of explain?
>
> On Thu, Jul 28, 2016 at 11:50 AM, Maria Jackson
>  wrote:
>
> I apologize for another mail, but I have a deadline tomorrow so I'll
> greatly appreciate if you could please help with this a little.
>
> On Wed, Jul 27, 2016 at 9:45 PM, Maria Jackson
>  wrote:
>
> I ran the following query on Virtuoso:
>
> [code]PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
> SELECT DISTINCT ?X
> WHERE
> {?X rdf:type Musician .
> ?X rdf:plays <http://Music>}
> [/code]
>
> The output of "explain" of this query is:
> [code]{
> RDF_QUAD_POGS 4 rows(s_1_4_t1.S)
> P =  ##plays  ,  O =  #/Music
> RDF_QUAD_POGS   0.8 rows(s_1_4_t0.S)
> inlined  P =  ##type  ,  O =  ##Musician  ,  S = s_1_4_t1.S
> Distinct (s_1_4_t0.S)
>
> After code:
>  0: X :=  := artm s_1_4_t0.S
>  4: BReturn 0
> Subquery Select(X)
>
> After code:
>  0: X := Call __ro2sq (X)
>  5: BReturn 0
> Select (X)
> }
> [/code]
>
> Now I am unable to decipher the output of explain command. What do
> "ro2sq", "inlined" and "artm" mean? And which join algorithm (like
> Hash Join, Merge Join, Nested loop join, etc.) is Virtuoso using for
> this query? I need to understand Virtuoso's explain command in order
> to understand the reason for Virtuoso taking a long time to execute?
>
>
>
--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Virtuoso taking long time

[Maria Jackson]

Sorry for another mail. But just to confirm is the join used by the
query plan below some kind of loop join:

{
RDF_QUAD_POGS 4 rows(s_1_4_t1.S)
 P =  ##plays  ,  O =  #/Music
RDF_QUAD_POGS   0.8 rows(s_1_4_t0.S)
 inlined  P =  ##type  ,  O =  ##Musician  ,  S = s_1_4_t1.S
Distinct (s_1_4_t0.S)

After code:
  0: X :=  := artm s_1_4_t0.S
  4: BReturn 0
Subquery Select(X)

After code:
  0: X := Call __ro2sq (X)
  5: BReturn 0
Select (X)

On Thu, Jul 28, 2016 at 1:38 PM, Maria Jackson
 wrote:
> Dear All,
>
> Thank you very much for your response. However, I am not able to
> understand the meaning of "inlined", "rosq", "artm" in Virtuoso's
> query plans. For exposition my question contains small example query.
>
> Also how can I figure out which join algorithm is used by Virtuoso by
> looking at the output of explain?
>
> On Thu, Jul 28, 2016 at 11:50 AM, Maria Jackson
>  wrote:
>> I apologize for another mail, but I have a deadline tomorrow so I'll
>> greatly appreciate if you could please help with this a little.
>>
>> On Wed, Jul 27, 2016 at 9:45 PM, Maria Jackson
>>  wrote:
>>> I ran the following query on Virtuoso:
>>>
>>> [code]PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
>>> SELECT DISTINCT ?X
>>> WHERE
>>> {?X rdf:type Musician .
>>> ?X rdf:plays <http://Music>}
>>> [/code]
>>>
>>> The output of "explain" of this query is:
>>> [code]{
>>> RDF_QUAD_POGS 4 rows(s_1_4_t1.S)
>>>  P =  ##plays  ,  O =  #/Music
>>> RDF_QUAD_POGS   0.8 rows(s_1_4_t0.S)
>>>  inlined  P =  ##type  ,  O =  ##Musician  ,  S = s_1_4_t1.S
>>> Distinct (s_1_4_t0.S)
>>>
>>> After code:
>>>   0: X :=  := artm s_1_4_t0.S
>>>   4: BReturn 0
>>> Subquery Select(X)
>>>
>>> After code:
>>>   0: X := Call __ro2sq (X)
>>>   5: BReturn 0
>>> Select (X)
>>> }
>>> [/code]
>>>
>>> Now I am unable to decipher the output of explain command. What do
>>> "ro2sq", "inlined" and "artm" mean? And which join algorithm (like
>>> Hash Join, Merge Join, Nested loop join, etc.) is Virtuoso using for
>>> this query? I need to understand Virtuoso's explain command in order
>>> to understand the reason for Virtuoso taking a long time to execute?

--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Virtuoso taking long time

[Maria Jackson]

Dear All,

Thank you very much for your response. However, I am not able to
understand the meaning of "inlined", "rosq", "artm" in Virtuoso's
query plans. For exposition my question contains small example query.

Also how can I figure out which join algorithm is used by Virtuoso by
looking at the output of explain?

On Thu, Jul 28, 2016 at 11:50 AM, Maria Jackson
 wrote:
> I apologize for another mail, but I have a deadline tomorrow so I'll
> greatly appreciate if you could please help with this a little.
>
> On Wed, Jul 27, 2016 at 9:45 PM, Maria Jackson
>  wrote:
>> I ran the following query on Virtuoso:
>>
>> [code]PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
>> SELECT DISTINCT ?X
>> WHERE
>> {?X rdf:type Musician .
>> ?X rdf:plays <http://Music>}
>> [/code]
>>
>> The output of "explain" of this query is:
>> [code]{
>> RDF_QUAD_POGS 4 rows(s_1_4_t1.S)
>>  P =  ##plays  ,  O =  #/Music
>> RDF_QUAD_POGS   0.8 rows(s_1_4_t0.S)
>>  inlined  P =  ##type  ,  O =  ##Musician  ,  S = s_1_4_t1.S
>> Distinct (s_1_4_t0.S)
>>
>> After code:
>>   0: X :=  := artm s_1_4_t0.S
>>   4: BReturn 0
>> Subquery Select(X)
>>
>> After code:
>>   0: X := Call __ro2sq (X)
>>   5: BReturn 0
>> Select (X)
>> }
>> [/code]
>>
>> Now I am unable to decipher the output of explain command. What do
>> "ro2sq", "inlined" and "artm" mean? And which join algorithm (like
>> Hash Join, Merge Join, Nested loop join, etc.) is Virtuoso using for
>> this query? I need to understand Virtuoso's explain command in order
>> to understand the reason for Virtuoso taking a long time to execute?

--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Virtuoso taking long time

[Maria Jackson]

I apologize for another mail, but I have a deadline tomorrow so I'll
greatly appreciate if you could please help with this a little.

On Wed, Jul 27, 2016 at 9:45 PM, Maria Jackson
 wrote:
> I ran the following query on Virtuoso:
>
> [code]PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
> SELECT DISTINCT ?X
> WHERE
> {?X rdf:type Musician .
> ?X rdf:plays <http://Music>}
> [/code]
>
> The output of "explain" of this query is:
> [code]{
> RDF_QUAD_POGS 4 rows(s_1_4_t1.S)
>  P =  ##plays  ,  O =  #/Music
> RDF_QUAD_POGS   0.8 rows(s_1_4_t0.S)
>  inlined  P =  ##type  ,  O =  ##Musician  ,  S = s_1_4_t1.S
> Distinct (s_1_4_t0.S)
>
> After code:
>   0: X :=  := artm s_1_4_t0.S
>   4: BReturn 0
> Subquery Select(X)
>
> After code:
>   0: X := Call __ro2sq (X)
>   5: BReturn 0
> Select (X)
> }
> [/code]
>
> Now I am unable to decipher the output of explain command. What do
> "ro2sq", "inlined" and "artm" mean? And which join algorithm (like
> Hash Join, Merge Join, Nested loop join, etc.) is Virtuoso using for
> this query? I need to understand Virtuoso's explain command in order
> to understand the reason for Virtuoso taking a long time to execute?

--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] Virtuoso taking long time

[Maria Jackson]

I ran the following query on Virtuoso:

[code]PREFIX rdf:
SELECT DISTINCT ?X
WHERE
{?X rdf:type Musician .
?X rdf:plays }
[/code]

The output of "explain" of this query is:
[code]{
RDF_QUAD_POGS 4 rows(s_1_4_t1.S)
 P =  ##plays  ,  O =  #/Music
RDF_QUAD_POGS   0.8 rows(s_1_4_t0.S)
 inlined  P =  ##type  ,  O =  ##Musician  ,  S = s_1_4_t1.S
Distinct (s_1_4_t0.S)

After code:
  0: X :=  := artm s_1_4_t0.S
  4: BReturn 0
Subquery Select(X)

After code:
  0: X := Call __ro2sq (X)
  5: BReturn 0
Select (X)
}
[/code]

Now I am unable to decipher the output of explain command. What do
"ro2sq", "inlined" and "artm" mean? And which join algorithm (like
Hash Join, Merge Join, Nested loop join, etc.) is Virtuoso using for
this query? I need to understand Virtuoso's explain command in order
to understand the reason for Virtuoso taking a long time to execute?

--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity planning
reports.http://sdm.link/zohodev2dev
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] SPATIAL JOIN queries in Virtuoso

[Maria Jackson]

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

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

Re: [Virtuoso-users] SPATIAL JOIN queries in Virtuoso

[Maria Jackson]

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

--
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! http://pubads.g.doubleclick.net/
gampad/clk?id=1444514301&iu=/ca-pub-7940484522588532
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] SPATIAL JOIN queries in Virtuoso

[Maria Jackson]

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  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
>
>
>
>> On 24 Feb 2016, at 23:39, Maria Jackson  wrote:
>>
>> Dear Kingsley,
>>
>> Thanks a lot for all the links. I tried running the example queries
>> which you gave, but from the queries it seems function st_distance
>> works only with points. I also found a discussion here:
>> https://groups.google.com/forum/#!topic/linked-geo-data/nxQy719M5EQ
>> regarding the same. I'll greatly appreciate if you could please
>> confirm or refute the same?
>>
>> On Thu, Feb 25, 2016 at 3:35 AM, Kingsley Idehen  
>> wrote:
>>> On 2/24/16 4:05 PM, Maria Jackson wrote:
>>>> Dear Kingsley,
>>>>
>>>> Sure I'll do that :) But I am a bit novice so I dont know how can I
>>>> use my query against your instances of LOD (Dbpedia essentially has
>>>> spatial geometries in the form of points instead of polygons. And my
>>>> current focus is on polygons) :)
>>>>
>>>> The example polygon which I took is from LinkedGeoData dataset (which
>>>> is a part of LOD). Therefore, I am finding it hard to understand as to
>>>> where am I making mistake?
>>>
>>> Some other examples:
>>>
>>> [1]
>>> http://linkeddata.uriburner.com/HtmlPivotViewer/?url=http%3A%2F%2Flinkeddata.uriburner.com%2Fc%2F86SEH%23%24view%24%3D4%26%24selection%24%3D0%26%24mapCentreX%24%3D4.647604837557583%26%24mapCentreY%24%3D7.9541015625%26%24mapZoom%24%3D7
>>> -- Result
>>>
>>> [2]
>>> http://linkeddata.uriburner.com/HtmlPivotViewer/edit.vsp?url=http%3A%2F%2Flinkeddata.uriburner.com%2Fc%2F86SEH%23%24view%24%3D4%26%24selection%24%3D0%26%24mapCentreX%24%3D4.647604837557583%26%24mapCentreY%24%3D7.9541015625%26%24mapZoom%24%3D7
>>> -- Query Source Code
>>>
>>>
>>>>
>>>> On Thu, Feb 25, 2016 at 2:20 AM, Kingsley Idehen  
>>>> wrote:
>>>>> On 2/24/16 3:11 PM, Maria Jackson wrote:
>>>>>> Dear Kingsley,
>>>>>>
>>>>>> I am afraid, I did see
>>>>>> http://kidehen.blogspot.com/2014/02/geospatial-querying-over-linked-open.html.
>>>>>> But I am unable to understand as to why myself and Mr. Hugh are
>>>>>> getting errors with querying spatial data. Can you please help me
>>>>>> understand as to where am I going wrong?
>>>>> Can you try your example using data from our LOD [1] or DBpedia [2]
>>>>> instances? Or a URL against your instance if online.
>>>>>
>>>>> [1] http://dbpedia.org/sparql
>>>>> [2] http://lod.openlinksw.com/sparql
>>>>>
>>>>> Kingsley
>>>>>> On Thu, Feb 25, 2016 at 1:25 AM, Kingsley Idehen 
>>>>>>  wrote:
>>>>>>> On 2/24/16 10:31 AM, Hugh Williams wrote:
>>>>>>>> Hi Maria,
>>>>>>>>
>>>>>>>> The following slide on that tutorial shows how to find place within a 
>>>>>>>> given proximity of each other:
>>>>>>>>
>>>>>>>> 
>>>>>>>> http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.html#(6)
>>>>>>> seeAlso:
>>>>>>>
>>>>>>> [1]
>>>>>>> http://kidehen.blogspot.com/2014/02/geospatial-querying-over-linked-open.html
>>>>>>>
>>>>>>>
>>>>>>> --
>

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] SPATIAL JOIN queries in Virtuoso

[Maria Jackson]

Dear Kingsley,

Thanks a lot for all the links. I tried running the example queries
which you gave, but from the queries it seems function st_distance
works only with points. I also found a discussion here:
https://groups.google.com/forum/#!topic/linked-geo-data/nxQy719M5EQ
regarding the same. I'll greatly appreciate if you could please
confirm or refute the same?

On Thu, Feb 25, 2016 at 3:35 AM, Kingsley Idehen  wrote:
> On 2/24/16 4:05 PM, Maria Jackson wrote:
>> Dear Kingsley,
>>
>> Sure I'll do that :) But I am a bit novice so I dont know how can I
>> use my query against your instances of LOD (Dbpedia essentially has
>> spatial geometries in the form of points instead of polygons. And my
>> current focus is on polygons) :)
>>
>> The example polygon which I took is from LinkedGeoData dataset (which
>> is a part of LOD). Therefore, I am finding it hard to understand as to
>> where am I making mistake?
>
> Some other examples:
>
> [1]
> http://linkeddata.uriburner.com/HtmlPivotViewer/?url=http%3A%2F%2Flinkeddata.uriburner.com%2Fc%2F86SEH%23%24view%24%3D4%26%24selection%24%3D0%26%24mapCentreX%24%3D4.647604837557583%26%24mapCentreY%24%3D7.9541015625%26%24mapZoom%24%3D7
> -- Result
>
> [2]
> http://linkeddata.uriburner.com/HtmlPivotViewer/edit.vsp?url=http%3A%2F%2Flinkeddata.uriburner.com%2Fc%2F86SEH%23%24view%24%3D4%26%24selection%24%3D0%26%24mapCentreX%24%3D4.647604837557583%26%24mapCentreY%24%3D7.9541015625%26%24mapZoom%24%3D7
> -- Query Source Code
>
>
>>
>> On Thu, Feb 25, 2016 at 2:20 AM, Kingsley Idehen  
>> wrote:
>>> On 2/24/16 3:11 PM, Maria Jackson wrote:
>>>> Dear Kingsley,
>>>>
>>>> I am afraid, I did see
>>>> http://kidehen.blogspot.com/2014/02/geospatial-querying-over-linked-open.html.
>>>> But I am unable to understand as to why myself and Mr. Hugh are
>>>> getting errors with querying spatial data. Can you please help me
>>>> understand as to where am I going wrong?
>>> Can you try your example using data from our LOD [1] or DBpedia [2]
>>> instances? Or a URL against your instance if online.
>>>
>>> [1] http://dbpedia.org/sparql
>>> [2] http://lod.openlinksw.com/sparql
>>>
>>> Kingsley
>>>> On Thu, Feb 25, 2016 at 1:25 AM, Kingsley Idehen  
>>>> wrote:
>>>>> On 2/24/16 10:31 AM, Hugh Williams wrote:
>>>>>> Hi Maria,
>>>>>>
>>>>>> The following slide on that tutorial shows how to find place within a 
>>>>>> given proximity of each other:
>>>>>>
>>>>>>   
>>>>>> http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.html#(6)
>>>>> seeAlso:
>>>>>
>>>>> [1]
>>>>> http://kidehen.blogspot.com/2014/02/geospatial-querying-over-linked-open.html
>>>>>
>>>>>
>>>>> --
>>>>> Regards,
>>>>>
>>>>> Kingsley Idehen
>>>>> Founder & CEO
>>>>> OpenLink Software
>>>>> Company Web: http://www.openlinksw.com
>>>>> Personal Weblog 1: http://kidehen.blogspot.com
>>>>> Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen
>>>>> Twitter Profile: https://twitter.com/kidehen
>>>>> Google+ Profile: https://plus.google.com/+KingsleyIdehen/about
>>>>> LinkedIn Profile: http://www.linkedin.com/in/kidehen
>>>>> Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>>>>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>>>>> Monitor end-to-end web transactions and take corrective actions now
>>>>> Troubleshoot faster and improve end-user experience. Signup Now!
>>>>> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
>>>>> ___
>>>>> Virtuoso-users mailing list
>>>>> Virtuoso-users@lists.sourceforge.net
>>>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>>>>
>>>> --
>>>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
&

Re: [Virtuoso-users] SPATIAL JOIN queries in Virtuoso

[Maria Jackson]

Dear Kingsley,

Sure I'll do that :) But I am a bit novice so I dont know how can I
use my query against your instances of LOD (Dbpedia essentially has
spatial geometries in the form of points instead of polygons. And my
current focus is on polygons) :)

The example polygon which I took is from LinkedGeoData dataset (which
is a part of LOD). Therefore, I am finding it hard to understand as to
where am I making mistake?

On Thu, Feb 25, 2016 at 2:20 AM, Kingsley Idehen  wrote:
> On 2/24/16 3:11 PM, Maria Jackson wrote:
>> Dear Kingsley,
>>
>> I am afraid, I did see
>> http://kidehen.blogspot.com/2014/02/geospatial-querying-over-linked-open.html.
>> But I am unable to understand as to why myself and Mr. Hugh are
>> getting errors with querying spatial data. Can you please help me
>> understand as to where am I going wrong?
>
> Can you try your example using data from our LOD [1] or DBpedia [2]
> instances? Or a URL against your instance if online.
>
> [1] http://dbpedia.org/sparql
> [2] http://lod.openlinksw.com/sparql
>
> Kingsley
>>
>> On Thu, Feb 25, 2016 at 1:25 AM, Kingsley Idehen  
>> wrote:
>>> On 2/24/16 10:31 AM, Hugh Williams wrote:
>>>> Hi Maria,
>>>>
>>>> The following slide on that tutorial shows how to find place within a 
>>>> given proximity of each other:
>>>>
>>>>   
>>>> http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.html#(6)
>>>
>>> seeAlso:
>>>
>>> [1]
>>> http://kidehen.blogspot.com/2014/02/geospatial-querying-over-linked-open.html
>>>
>>>
>>> --
>>> Regards,
>>>
>>> Kingsley Idehen
>>> Founder & CEO
>>> OpenLink Software
>>> Company Web: http://www.openlinksw.com
>>> Personal Weblog 1: http://kidehen.blogspot.com
>>> Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen
>>> Twitter Profile: https://twitter.com/kidehen
>>> Google+ Profile: https://plus.google.com/+KingsleyIdehen/about
>>> LinkedIn Profile: http://www.linkedin.com/in/kidehen
>>> Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this
>>>
>>>
>>>
>>> --
>>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>>> Monitor end-to-end web transactions and take corrective actions now
>>> Troubleshoot faster and improve end-user experience. Signup Now!
>>> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
>>> ___
>>> Virtuoso-users mailing list
>>> Virtuoso-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>>
>> --
>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>> Monitor end-to-end web transactions and take corrective actions now
>> Troubleshoot faster and improve end-user experience. Signup Now!
>> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
>> ___
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>
>
>
> --
> Regards,
>
> Kingsley Idehen
> Founder & CEO
> OpenLink Software
> Company Web: http://www.openlinksw.com
> Personal Weblog 1: http://kidehen.blogspot.com
> Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen
> Twitter Profile: https://twitter.com/kidehen
> Google+ Profile: https://plus.google.com/+KingsleyIdehen/about
> LinkedIn Profile: http://www.linkedin.com/in/kidehen
> Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this
>
>
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
> ___
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] SPATIAL JOIN queries in Virtuoso

[Maria Jackson]

Dear Kingsley,

I am afraid, I did see
http://kidehen.blogspot.com/2014/02/geospatial-querying-over-linked-open.html.
But I am unable to understand as to why myself and Mr. Hugh are
getting errors with querying spatial data. Can you please help me
understand as to where am I going wrong?

On Thu, Feb 25, 2016 at 1:25 AM, Kingsley Idehen  wrote:
> On 2/24/16 10:31 AM, Hugh Williams wrote:
>> Hi Maria,
>>
>> The following slide on that tutorial shows how to find place within a given 
>> proximity of each other:
>>
>>   
>> http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.html#(6)
>
>
> seeAlso:
>
> [1]
> http://kidehen.blogspot.com/2014/02/geospatial-querying-over-linked-open.html
>
>
> --
> Regards,
>
> Kingsley Idehen
> Founder & CEO
> OpenLink Software
> Company Web: http://www.openlinksw.com
> Personal Weblog 1: http://kidehen.blogspot.com
> Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen
> Twitter Profile: https://twitter.com/kidehen
> Google+ Profile: https://plus.google.com/+KingsleyIdehen/about
> LinkedIn Profile: http://www.linkedin.com/in/kidehen
> Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this
>
>
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
> ___
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] SPATIAL JOIN queries in Virtuoso

[Maria Jackson]

I am afraid I used bif:st_distance function itself but still I am
getting the following error:

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}};

Am I loading the data incorrectly. If not, can you please help me
understand as to where am I going wrong?

On Wed, Feb 24, 2016 at 9:01 PM, Hugh Williams  wrote:
> Hi Maria,
>
> The following slide on that tutorial shows how to find place within a given 
> proximity of each other:
>
> 
> http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.html#(6)
>
> 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 23 Feb 2016, at 18:33, Maria Jackson  wrote:
>>
>>> Is the above query known to be valid ie has been run elsewhere or is this
>>> just a general spatial join query you are trying to get working ?
>> I got inspired to write the query this way from the tutorial :
>> http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.html#(4)
>>
>> Essentially, my query wants to retrieve cities ?long and ?nlong which
>> are at a distance of 100 k.m. from each other. I am not able to
>> understand as to what should be the syntax for this query (which
>> Virtuoso also supports). Can you please help me with this a bit?
>>
>

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] SPATIAL JOIN queries in Virtuoso

[Maria Jackson]

Dear Hugh,

I have a deadline tomorrow, therefore I'll be thankful if you can help
me with this a bit?

On Wed, Feb 24, 2016 at 12:03 AM, Maria Jackson
 wrote:
>> Is the above query known to be valid ie has been run elsewhere or is this
>> just a general spatial join query you are trying to get working ?
> I got inspired to write the query this way from the tutorial :
> http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.html#(4)
>
> Essentially, my query wants to retrieve cities ?long and ?nlong which
> are at a distance of 100 k.m. from each other. I am not able to
> understand as to what should be the syntax for this query (which
> Virtuoso also supports). Can you please help me with this a bit?
>
> On Tue, Feb 23, 2016 at 10:58 PM, Hugh Williams
>  wrote:
>> Hi Maria,
>>
>> Running against the latest Virtuoso open source release I get a slightly
>> different error running the query against your data:
>>
>> SQL> DB.DBA.TTLP_MT (file_to_string_output('./spatialTest.nq'),
>> '','<http://localhost:8890/DAV/dbpedia>',512);
>>
>> Done. -- 13 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}};
>>
>> *** Error 22023: VD [Virtuoso Server]GEO..: Function st_distance() expects a
>> geometry of type 1 as argument 0, not geometry of type 10242
>> at line 2 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}}
>> SQL> status('');
>> REPORT
>> VARCHAR
>> ___
>>
>> OpenLink Virtuoso  Server
>> Version 07.20.3216-pthreads for Darwin as of Feb 16 2016
>>
>>
>> Is the above query known to be valid ie has been run elsewhere or is this
>> just a general spatial join query you are trying to get working ?
>>
>> 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 23 Feb 2016, at 12:47, Maria Jackson  wrote:
>>
>> 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> "POLYGON ((77.164230
>> 33.187725,77.164188 33.188013,77.164066 33.188336,77.164457
>> 33.188676,77.164685 33.188861,77.165012 33.189296,77.165467
>> 33.188591,77.165490 33.188213,77.165085 33.188057,77.164811
>> 33.187902,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> "POLYGON ((78.748611
>> 32.748742,78.748728 32.748925,78.749925 32.749764,78.750246
>> 32.749882,78.750630 32.749916,78.750850 32.749906,78.751046
>> 32.749875,78.751275 32.749807,78.751502 32.749698,78.751676
>> 32.749548,78.751743 32.749407,78.751792 32.749271,78.75778
>> 32.749124,78.751735 32.749024,78.751651 32.748885,78.751526
>> 32.748773,78.751369 32.748673,78.750919 32.748439,78.750465
>> 32.748209,78.750064 32.748093,78.749692 32.748034,78.749341
>> 32.748049,78.749006 32.748166,78.748721 32.748348,78.748604
>> 32.748523,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> "POLYGON ((2.79723
>> -122.934,2.79897 -122.9314,2.797231
>> -122.9342))"^^<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'), '',

Re: [Virtuoso-users] SPATIAL JOIN queries in Virtuoso

[Maria Jackson]

> Is the above query known to be valid ie has been run elsewhere or is this
> just a general spatial join query you are trying to get working ?
I got inspired to write the query this way from the tutorial :
http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.html#(4)

Essentially, my query wants to retrieve cities ?long and ?nlong which
are at a distance of 100 k.m. from each other. I am not able to
understand as to what should be the syntax for this query (which
Virtuoso also supports). Can you please help me with this a bit?

On Tue, Feb 23, 2016 at 10:58 PM, Hugh Williams
 wrote:
> Hi Maria,
>
> Running against the latest Virtuoso open source release I get a slightly
> different error running the query against your data:
>
> SQL> DB.DBA.TTLP_MT (file_to_string_output('./spatialTest.nq'),
> '','<http://localhost:8890/DAV/dbpedia>',512);
>
> Done. -- 13 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}};
>
> *** Error 22023: VD [Virtuoso Server]GEO..: Function st_distance() expects a
> geometry of type 1 as argument 0, not geometry of type 10242
> at line 2 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}}
> SQL> status('');
> REPORT
> VARCHAR
> ___
>
> OpenLink Virtuoso  Server
> Version 07.20.3216-pthreads for Darwin as of Feb 16 2016
>
>
> Is the above query known to be valid ie has been run elsewhere or is this
> just a general spatial join query you are trying to get working ?
>
> 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 23 Feb 2016, at 12:47, Maria Jackson  wrote:
>
> 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> "POLYGON ((77.164230
> 33.187725,77.164188 33.188013,77.164066 33.188336,77.164457
> 33.188676,77.164685 33.188861,77.165012 33.189296,77.165467
> 33.188591,77.165490 33.188213,77.165085 33.188057,77.164811
> 33.187902,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> "POLYGON ((78.748611
> 32.748742,78.748728 32.748925,78.749925 32.749764,78.750246
> 32.749882,78.750630 32.749916,78.750850 32.749906,78.751046
> 32.749875,78.751275 32.749807,78.751502 32.749698,78.751676
> 32.749548,78.751743 32.749407,78.751792 32.749271,78.75778
> 32.749124,78.751735 32.749024,78.751651 32.748885,78.751526
> 32.748773,78.751369 32.748673,78.750919 32.748439,78.750465
> 32.748209,78.750064 32.748093,78.749692 32.748034,78.749341
> 32.748049,78.749006 32.748166,78.748721 32.748348,78.748604
> 32.748523,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> "POLYGON ((2.79723
> -122.934,2.79897 -122.9314,2.797231
> -122.9342))"^^<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}};
>
> Which gave me the following error:
> *** Error 22032: [Virtuoso Driver][Virtuoso Server]GEO..: Function
> st_distance() expects a geometry a

[Virtuoso-users] SPATIAL JOIN queries in Virtuoso

[Maria Jackson]

I loaded the following file in Virtuoso (version 07.20.3213):
"
 "POLYGON ((77.164230
33.187725,77.164188 33.188013,77.164066 33.188336,77.164457
33.188676,77.164685 33.188861,77.165012 33.189296,77.165467
33.188591,77.165490 33.188213,77.165085 33.188057,77.164811
33.187902,77.164230
33.187725))"^^
.

 "POLYGON ((78.748611
32.748742,78.748728 32.748925,78.749925 32.749764,78.750246
32.749882,78.750630 32.749916,78.750850 32.749906,78.751046
32.749875,78.751275 32.749807,78.751502 32.749698,78.751676
32.749548,78.751743 32.749407,78.751792 32.749271,78.75778
32.749124,78.751735 32.749024,78.751651 32.748885,78.751526
32.748773,78.751369 32.748673,78.750919 32.748439,78.750465
32.748209,78.750064 32.748093,78.749692 32.748034,78.749341
32.748049,78.749006 32.748166,78.748721 32.748348,78.748604
32.748523,78.748611
32.748742))"^^
.

 "POLYGON ((2.79723
-122.934,2.79897 -122.9314,2.797231
-122.9342))"^^
."

using:
DB.DBA.TTLP_MT (file_to_string_output
('/home/virtuoso/share/virtuoso/vad/spatialTest.nq'), '',
'',512);

After which I ran the following query:
SQL> sparql select ?place ?nplace (( bif:st_distance( ?long,?nlong) )
AS ?distance) WHERE  {graph ?g1{?place
 ?long} graph ?g4{?nplace
 ?nlong}};

Which gave me the following error:
*** Error 22032: [Virtuoso Driver][Virtuoso Server]GEO..: Function
st_distance() expects a geometry as argument 0

Can someone please guide me as to where am I going wrong and how I run
spatial join queries in Virtuoso?

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] Query regarding Virtuoso's generated plan

[Maria Jackson]

Dear All,

I ran the following query on Virtuoso:
select ?a?b?c?h?f?fnco ((?f+1001) * (?fnco+1) as ?ero) where{ graph ?g{?a
 ?f} graph ?g1{?a  ?b} graph ?g2{?b  ?c} graph ?g3{?c
 ?h} graph ?g4{?g3  ?fnco}} order by asc(?ero) limit 50

The above query generated the following plan. If possible, can someone
please help me in understanding the generated plan:

Connected to OpenLink Virtuoso
Driver: 07.20.3215 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> SQL> REPORT
VARCHAR
___

{
Subquery 27
{
{ fork
RDF_QUAD   8.7e+04 rows(s_1_3_t1.S, s_1_3_t1.O)
 inlined  P =  #/pred1
RDF_QUAD 1 rows(s_1_1_t0.O)
 inlined  P =  #/pred2  ,  S = s_1_3_t1.S

Precode:
  0: temp := artm s_1_1_t0.O +  1001
  4: BReturn 0
RDF_QUAD   1.8 rows(s_1_5_t2.O, s_1_5_t2.S)
 inlined  P =  #/pred3  ,  S = k_s_1_3_t1.O
RDF_QUAD   1.1 rows(s_1_7_t3.G, s_1_7_t3.S, s_1_7_t3.O)
 inlined  P =  #/pred4  ,  S = cast
RDF_QUAD 1 rows(s_1_9_t4.O)
 inlined  P =  #/pred5  ,  S = s_1_7_t3.G

After code:
  0: temp := artm s_1_9_t4.O +  1
  4: temp := artm temp * temp
  8: BReturn 0
Sort (temp) -> (s_1_3_t1.S, s_1_5_t2.S, s_1_7_t3.S, s_1_7_t3.O, s_1_1_t0.O,
s_1_9_t4.O)

}
top order by read (s_1_3_t1.S, s_1_5_t2.S, s_1_7_t3.S, s_1_7_t3.O,
s_1_1_t0.O, s_1_9_t4.O, temp)

After code:
  0: __ro2sq := Call __ro2sq (s_1_9_t4.O)
  5: __ro2sq := Call __ro2sq (s_1_1_t0.O)
  10: __ro2sq := Call __ro2sq (s_1_7_t3.O)
  15: __id2in := Call __id2in (s_1_7_t3.S)
  20: __id2in := Call __id2in (s_1_5_t2.S)
  25: __id2in := Call __id2in (s_1_3_t1.S)
  30: a :=  := artm __id2in
  34: b :=  := artm __id2in
  38: c :=  := artm __id2in
  42: h :=  := artm __ro2sq
  46: f :=  := artm __ro2sq
  50: fnco :=  := artm __ro2sq
  54: ero :=  := artm temp
  58: BReturn 0
Subquery Select(a, b, c, h, f, fnco, ero)
}

After code:
  0: a := Call __ro2sq (a)
  5: b := Call __ro2sq (b)
  10: c := Call __ro2sq (c)
  15: h := Call __ro2sq (h)
  20: f := Call __ro2sq (f)
  25: fnco := Call __ro2sq (fnco)
  30: ero := Call __ro2sq (ero)
  35: BReturn 0
Select (a, b, c, h, f, fnco, ero)
}

57 Rows. -- 5 msec.
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Querying spatial data in Virtuoso

[Maria Jackson]

Thank you again Mr. Williams.

I am new to spatial data management, can you please give me a list of
general spatial and temporal predicates which triple stores or Virtuoso
support?

On Fri, Nov 6, 2015 at 7:11 AM, Hugh Williams 
wrote:

> Hi Maria,
>
> Those are not jena or dbpedia specific predicates but more general
> predicates using in geo spatial most triples stores would support including
> Virtuoso as indicated in the examples provide previously at:
>
>
> http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.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 5 Nov 2015, at 22:01, Maria Jackson 
> wrote:
>
> Thanks, Mr. Williams.
>
> I found Jena supports dbpedia predicates: <
> http://www.w3.org/2003/01/geo/wgs84_pos#lat> , <
> http://www.w3.org/2003/01/geo/wgs84_pos#long> and <
> http://www.w3.org/2003/01/geo/wgs84_pos#geometry>, which dbpedia
> predicates does Virtuoso 7.2 support by default?
>
> On Wed, Oct 28, 2015 at 11:17 PM, Hugh Williams 
> wrote:
>
>> HI Maria,
>>
>> Try now and the docs server should load pages instantly now …
>>
>> The st_distance function definition is at:
>>
>> http://docs.openlinksw.com/virtuoso/fn_st_distance.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 28 Oct 2015, at 17:23, Maria Jackson 
>> wrote:
>>
>> Dear Mr. Kingsley,
>>
>> Thank you very much for the information but I am not able to open
>> http://docs.openlinksw.com/virtuoso/sqlrefgeospatial.html -- it seems to
>> be taking forever to load.
>>
>> Can you please let me know, the formula of the distance function which
>> you have used in slide 4 in ref. 2 (
>> http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.html#(4))
>> for computing distance:
>> bif:st_distance(?nyl,?ll)
>>
>> On Wed, Oct 28, 2015 at 10:32 PM, Kingsley Idehen > > wrote:
>>
>>> On 10/28/15 12:31 PM, Maria Jackson wrote:
>>>
>>> Dear All,
>>>
>>> Is it possible to process spatial data using Virtuoso. If yes, can you
>>> please give an example query using which I can query spatial range join in
>>> Virtuoso?
>>>
>>>
>>> --
>>>
>>>
>>>
>>> ___
>>> Virtuoso-users mailing 
>>> listVirtuoso-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>>
>>> Maria,
>>>
>>> Examples covered in the following docs:
>>>
>>> [1]
>>> http://kidehen.blogspot.com/2014/02/geospatial-querying-over-linked-open.html
>>> [2]
>>> http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.html
>>> [3] http://docs.openlinksw.com/virtuoso/sqlrefgeospatial.html
>>>
>>>
>>> --
>>> Regards,
>>>
>>> Kingsley Idehen 
>>> Founder & CEO
>>> OpenLink Software
>>> Company Web: http://www.openlinksw.com
>>> Personal Weblog 1: http://kidehen.blogspot.com
>>> Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen
>>> Twitter Profile: https://twitter.com/kidehen
>>> Google+ Profile: https://plus.google.com/+KingsleyIdehen/about
>>> LinkedIn Profile: http://www.linkedin.com/in/kidehen
>>> Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this
>>>
>>>
>>>
>>> ---

Re: [Virtuoso-users] Querying spatial data in Virtuoso

[Maria Jackson]

Thanks, Mr. Williams.

I found Jena supports dbpedia predicates: <
http://www.w3.org/2003/01/geo/wgs84_pos#lat> , <
http://www.w3.org/2003/01/geo/wgs84_pos#long> and <
http://www.w3.org/2003/01/geo/wgs84_pos#geometry>, which dbpedia predicates
does Virtuoso 7.2 support by default?

On Wed, Oct 28, 2015 at 11:17 PM, Hugh Williams 
wrote:

> HI Maria,
>
> Try now and the docs server should load pages instantly now …
>
> The st_distance function definition is at:
>
> http://docs.openlinksw.com/virtuoso/fn_st_distance.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 28 Oct 2015, at 17:23, Maria Jackson 
> wrote:
>
> Dear Mr. Kingsley,
>
> Thank you very much for the information but I am not able to open
> http://docs.openlinksw.com/virtuoso/sqlrefgeospatial.html -- it seems to
> be taking forever to load.
>
> Can you please let me know, the formula of the distance function which you
> have used in slide 4 in ref. 2 (
> http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.html#(4))
> for computing distance:
> bif:st_distance(?nyl,?ll)
>
> On Wed, Oct 28, 2015 at 10:32 PM, Kingsley Idehen 
> wrote:
>
>> On 10/28/15 12:31 PM, Maria Jackson wrote:
>>
>> Dear All,
>>
>> Is it possible to process spatial data using Virtuoso. If yes, can you
>> please give an example query using which I can query spatial range join in
>> Virtuoso?
>>
>>
>> --
>>
>>
>>
>> ___
>> Virtuoso-users mailing 
>> listVirtuoso-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>
>> Maria,
>>
>> Examples covered in the following docs:
>>
>> [1]
>> http://kidehen.blogspot.com/2014/02/geospatial-querying-over-linked-open.html
>> [2]
>> http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.html
>> [3] http://docs.openlinksw.com/virtuoso/sqlrefgeospatial.html
>>
>>
>> --
>> Regards,
>>
>> Kingsley Idehen  
>> Founder & CEO
>> OpenLink Software
>> Company Web: http://www.openlinksw.com
>> Personal Weblog 1: http://kidehen.blogspot.com
>> Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen
>> Twitter Profile: https://twitter.com/kidehen
>> Google+ Profile: https://plus.google.com/+KingsleyIdehen/about
>> LinkedIn Profile: http://www.linkedin.com/in/kidehen
>> Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this
>>
>>
>>
>> --
>>
>> ___
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>
>>
>
> --
> ___
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
>
--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Querying spatial data in Virtuoso

[Maria Jackson]

Dear Mr. Kingsley,

Thank you very much for the information but I am not able to open
http://docs.openlinksw.com/virtuoso/sqlrefgeospatial.html -- it seems to be
taking forever to load.

Can you please let me know, the formula of the distance function which you
have used in slide 4 in ref. 2 (
http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.html#(4))
for computing distance:
bif:st_distance(?nyl,?ll)

On Wed, Oct 28, 2015 at 10:32 PM, Kingsley Idehen 
wrote:

> On 10/28/15 12:31 PM, Maria Jackson wrote:
>
> Dear All,
>
> Is it possible to process spatial data using Virtuoso. If yes, can you
> please give an example query using which I can query spatial range join in
> Virtuoso?
>
>
> --
>
>
>
> ___
> Virtuoso-users mailing 
> listVirtuoso-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
> Maria,
>
> Examples covered in the following docs:
>
> [1]
> http://kidehen.blogspot.com/2014/02/geospatial-querying-over-linked-open.html
> [2]
> http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.html
> [3] http://docs.openlinksw.com/virtuoso/sqlrefgeospatial.html
>
>
> --
> Regards,
>
> Kingsley Idehen   
> Founder & CEO
> OpenLink Software
> Company Web: http://www.openlinksw.com
> Personal Weblog 1: http://kidehen.blogspot.com
> Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen
> Twitter Profile: https://twitter.com/kidehen
> Google+ Profile: https://plus.google.com/+KingsleyIdehen/about
> LinkedIn Profile: http://www.linkedin.com/in/kidehen
> Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this
>
>
>
> --
>
> ___
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] Querying spatial data in Virtuoso

[Maria Jackson]

Dear All,

Is it possible to process spatial data using Virtuoso. If yes, can you
please give an example query using which I can query spatial range join in
Virtuoso?
--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] How to specify power in select cause SPARQL

[Maria Jackson]

select ?a?b?c?r where{ graph ?graph1{?a ?b } graph ?graph21{?a ?c
} graph ?graph2{?a  ?r}} order by asc(?r+(1.1*10^(11)))
limit 1

If I write the above expression to denote: ?r + (1.1 x (pow(10,11))) then
will it be a correct expression in Virtuoso. I am struggling to find how to
express power in Virtuoso?
--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Unable to bulk load nquads in Virtuoso

[Maria Jackson]

m/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 7 Apr 2015, at 23:00, Maria Jackson 
> wrote:
>
> *I am trying to bulk load dbpedia.nq in Virtuoso using the following
> command:*
>
> *$ ./isql  dba dba*
> Connected to OpenLink Virtuoso
> Driver: 07.20.3212 OpenLink Virtuoso ODBC Driver
> OpenLink Interactive SQL (Virtuoso), version 0.9849b.
> Type HELP; for help and EXIT; to exit.
> SQL> DB.DBA.TTLP_MT (file_to_string_output
> ('/home/Virtuoso/virtuosoInstalled/share/virtuoso/vad/Dbpedia.nq'), '', '<
> http://localhost:8890/DAV/dbpedia>',512);
>
> *Whenever I try to bulk load in Virtuoso I get the following error and
> Virtuoso halts. Can someone please help me as to how can I bulk load .nq
> files in Virtuoso:*
>
> *$ ./virtuoso-t -f -c
> /home/Virtuoso/virtuosoInstalled/var/lib/virtuoso/db/virtuoso.ini*
>
> Wed Apr 08 2015
> 01:44:17 { Loading plugin 1: Type `plain', file `wikiv' in
> `/home/Virtuoso/virtuosoInstalled/lib/virtuoso/hosting'
> 01:44:17   FAILED  plugin 1: Unable to locate file }
> 01:44:17 { Loading plugin 2: Type `plain', file `mediawiki' in
> `/home/Virtuoso/virtuosoInstalled/lib/virtuoso/hosting'
> 01:44:17   FAILED  plugin 2: Unable to locate file }
> 01:44:17 { Loading plugin 3: Type `plain', file `creolewiki' in
> `/home/Virtuoso/virtuosoInstalled/lib/virtuoso/hosting'
> 01:44:17   FAILED  plugin 3: Unable to locate file }
> 01:44:17 OpenLink Virtuoso Universal Server
> 01:44:17 Version 07.20.3212-pthreads for Linux as of Apr  8 2015
> 01:44:17 uses parts of OpenSSL, PCRE, Html Tidy
> 01:44:27 Database version 3126
> 01:44:27 SQL Optimizer enabled (max 1000 layouts)
> 01:44:28 Compiler unit is timed at 0.000291 msec
> 01:44:30 Roll forward started
> 01:44:30 Roll forward complete
> 01:44:32 Checkpoint started
> 01:44:32 Checkpoint finished, log reused
> 01:44:32 HTTP/WebDAV server online at 8890
> 01:44:32 Server online at  (pid 28041)
> 02:44:33 Checkpoint started
> 02:44:33 Checkpoint finished, log reused
> 03:05:37 * Monitor: Locks are held for a long time
> 03:05:55 * Monitor: Should read for update because lock escalation from
> shared to exclusive fails frequently (1)
> 03:07:37 * Monitor: Locks are held for a long time
> 03:18:55 * Monitor: Many lock waits
>
> I downloaded Virtuoso from: git clone git://
> github.com/openlink/virtuoso-opensource.git
> Git checkout gives me: $ git checkout -t remotes/origin/develop/7
> fatal: git checkout: branch develop/7 already exists
> The parameters of my virtuoso.ini file are:
> ;
> ;  virtuoso.ini
> ;
> ;  Configuration file for the OpenLink Virtuoso VDBMS Server
> ;
> ;  To learn more about this product, or any other product in our
> ;  portfolio, please check out our web site at:
> ;
> ;  http://virtuoso.openlinksw.com/
> ;
> ;  or contact us at:
> ;
> ;  general.informat...@openlinksw.com
> ;
> ;  If you have any technical questions, please contact our support
> ;  staff at:
> ;
> ;  technical.supp...@openlinksw.com
> ;
>
> ;
> ;  Database setup
> ;
> [Database]
> DatabaseFile =
> /home/Virtuoso/virtuosoInstalled/var/lib/virtuoso/db/virtuoso.db
> ErrorLogFile =
> /home/Virtuoso/virtuosoInstalled/var/lib/virtuoso/db/virtuoso.log
> LockFile =
> /home/Virtuoso/virtuosoInstalled/var/lib/virtuoso/db/virtuoso.lck
> TransactionFile =
> /home/Virtuoso/virtuosoInstalled/var/lib/virtuoso/db/virtuoso.trx
> xa_persistent_file =
> /home/Virtuoso/virtuosoInstalled/var/lib/virtuoso/db/virtuoso.pxa
> ErrorLogLevel = 7
> FileExtend = 200
> MaxCheckpointRemap = 17
> Striping = 0
> TempStorage = TempDatabase
>
>
> [TempDatabase]
> DatabaseFile =
> /home/Virtuoso/virtuosoInstalled/var/lib/virtuoso/db/virtuoso-temp.db
> TransactionFile =
> /home/Virtuoso/virtuosoInstalled/var/lib/virtuoso/db/virtuoso-temp.trx
> MaxCheckpointRemap = 200
> Striping = 0
>
>
> ;
> ;  Server parameters
> ;
> [Parameters]
> ServerPort = 
> LiteMode = 0
> DisableUnixSocket = 1
> DisableTcpSocket = 0
> ;SSLServerPort = 2111
> ;SSLCertificate = cert.pem
> ;SSLPrivateKey = pk.pem
> ;X509ClientVerify = 0
> ;X509ClientVerifyDepth = 0
> ;X509ClientVerifyCAFile = ca.pem
> MaxClientConnections = 10
> CheckpointInterval = 60
> O_DIRECT = 0
> CaseMode = 2
> MaxStaticCursorRows = 5000
> CheckpointAuditTrail = 0
&g

Re: [Virtuoso-users] Unable to bulk load nquads in Virtuoso

[Maria Jackson]

Sorry for another edit I am running Virtuoso on 64GB RAM machine.

On Thu, Apr 9, 2015 at 5:16 PM, Maria Jackson 
wrote:

> Also now I have reduced my memory requirement in virtuoso.ini (and
> restarted Virtuoso again):
> ;; Uncomment next two lines if there is 16 GB system memory free
> NumberOfBuffers  = 136
> MaxDirtyBuffers  = 100
>
>
> I am running Virtuoso on 64GB machine
>
> On Thu, Apr 9, 2015 at 5:10 PM, Maria Jackson  > wrote:
>
>> Additionally after continuously showing "Monitor: The mp_mmap_clocks over
>> 10% of real time", the program stops with the following message:
>>
>> 15:58:04 ./virtuoso-t() [0x922db8]
>> 15:58:04 ./virtuoso-t() [0x922e26]
>> 15:58:04 ./virtuoso-t() [0x911c60]
>> 15:58:04 ./virtuoso-t() [0x922add]
>> 15:58:04 ./virtuoso-t(clrg_destroy+0x171) [0x87e9c1]
>> 15:58:04 ./virtuoso-t(dk_free_tree+0x5c) [0x911f2c]
>> 15:58:04 ./virtuoso-t() [0x614e57]
>> 15:58:04 ./virtuoso-t() [0x614f61]
>> 15:58:04 ./virtuoso-t() [0x61533f]
>> 15:58:04 ./virtuoso-t() [0x618832]
>> 15:58:04 ./virtuoso-t(aq_sql_func+0x272) [0x4593d2]
>> 15:58:04 ./virtuoso-t(aq_thread_func+0x1bf) [0x45b9af]
>> 15:58:04 ./virtuoso-t() [0x92d195]
>> 15:58:04 /lib64/libpthread.so.0() [0x343e8079d1]
>> 15:58:04 /lib64/libc.so.6(clone+0x6d) [0x343e0e88fd]
>> 15:58:04 GPF: Dkbox.c:638 Double free
>> GPF: Dkbox.c:638 Double free
>> Segmentation fault
>>
>>
>> Can someone please suggest as to where am I going wrong?
>>
>
>
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Unable to bulk load nquads in Virtuoso

[Maria Jackson]

Also now I have reduced my memory requirement in virtuoso.ini (and
restarted Virtuoso again):
;; Uncomment next two lines if there is 16 GB system memory free
NumberOfBuffers  = 136
MaxDirtyBuffers  = 100


I am running Virtuoso on 64GB machine

On Thu, Apr 9, 2015 at 5:10 PM, Maria Jackson 
wrote:

> Additionally after continuously showing "Monitor: The mp_mmap_clocks over
> 10% of real time", the program stops with the following message:
>
> 15:58:04 ./virtuoso-t() [0x922db8]
> 15:58:04 ./virtuoso-t() [0x922e26]
> 15:58:04 ./virtuoso-t() [0x911c60]
> 15:58:04 ./virtuoso-t() [0x922add]
> 15:58:04 ./virtuoso-t(clrg_destroy+0x171) [0x87e9c1]
> 15:58:04 ./virtuoso-t(dk_free_tree+0x5c) [0x911f2c]
> 15:58:04 ./virtuoso-t() [0x614e57]
> 15:58:04 ./virtuoso-t() [0x614f61]
> 15:58:04 ./virtuoso-t() [0x61533f]
> 15:58:04 ./virtuoso-t() [0x618832]
> 15:58:04 ./virtuoso-t(aq_sql_func+0x272) [0x4593d2]
> 15:58:04 ./virtuoso-t(aq_thread_func+0x1bf) [0x45b9af]
> 15:58:04 ./virtuoso-t() [0x92d195]
> 15:58:04 /lib64/libpthread.so.0() [0x343e8079d1]
> 15:58:04 /lib64/libc.so.6(clone+0x6d) [0x343e0e88fd]
> 15:58:04 GPF: Dkbox.c:638 Double free
> GPF: Dkbox.c:638 Double free
> Segmentation fault
>
>
> Can someone please suggest as to where am I going wrong?
>
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Unable to bulk load nquads in Virtuoso

[Maria Jackson]

Additionally after continuously showing "Monitor: The mp_mmap_clocks over
10% of real time", the program stops with the following message:

15:58:04 ./virtuoso-t() [0x922db8]
15:58:04 ./virtuoso-t() [0x922e26]
15:58:04 ./virtuoso-t() [0x911c60]
15:58:04 ./virtuoso-t() [0x922add]
15:58:04 ./virtuoso-t(clrg_destroy+0x171) [0x87e9c1]
15:58:04 ./virtuoso-t(dk_free_tree+0x5c) [0x911f2c]
15:58:04 ./virtuoso-t() [0x614e57]
15:58:04 ./virtuoso-t() [0x614f61]
15:58:04 ./virtuoso-t() [0x61533f]
15:58:04 ./virtuoso-t() [0x618832]
15:58:04 ./virtuoso-t(aq_sql_func+0x272) [0x4593d2]
15:58:04 ./virtuoso-t(aq_thread_func+0x1bf) [0x45b9af]
15:58:04 ./virtuoso-t() [0x92d195]
15:58:04 /lib64/libpthread.so.0() [0x343e8079d1]
15:58:04 /lib64/libc.so.6(clone+0x6d) [0x343e0e88fd]
15:58:04 GPF: Dkbox.c:638 Double free
GPF: Dkbox.c:638 Double free
Segmentation fault


Can someone please suggest as to where am I going wrong?
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] Unable to bulk load nquads in Virtuoso

[Maria Jackson]

*I am trying to bulk load dbpedia.nq in Virtuoso using the following
command:*

*$ ./isql  dba dba*
Connected to OpenLink Virtuoso
Driver: 07.20.3212 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> DB.DBA.TTLP_MT (file_to_string_output
('/home/Virtuoso/virtuosoInstalled/share/virtuoso/vad/Dbpedia.nq'), '', '<
http://localhost:8890/DAV/dbpedia>',512);

*Whenever I try to bulk load in Virtuoso I get the following error and
Virtuoso halts. Can someone please help me as to how can I bulk load .nq
files in Virtuoso:*

*$ ./virtuoso-t -f -c
/home/Virtuoso/virtuosoInstalled/var/lib/virtuoso/db/virtuoso.ini*

Wed Apr 08 2015
01:44:17 { Loading plugin 1: Type `plain', file `wikiv' in
`/home/Virtuoso/virtuosoInstalled/lib/virtuoso/hosting'
01:44:17   FAILED  plugin 1: Unable to locate file }
01:44:17 { Loading plugin 2: Type `plain', file `mediawiki' in
`/home/Virtuoso/virtuosoInstalled/lib/virtuoso/hosting'
01:44:17   FAILED  plugin 2: Unable to locate file }
01:44:17 { Loading plugin 3: Type `plain', file `creolewiki' in
`/home/Virtuoso/virtuosoInstalled/lib/virtuoso/hosting'
01:44:17   FAILED  plugin 3: Unable to locate file }
01:44:17 OpenLink Virtuoso Universal Server
01:44:17 Version 07.20.3212-pthreads for Linux as of Apr  8 2015
01:44:17 uses parts of OpenSSL, PCRE, Html Tidy
01:44:27 Database version 3126
01:44:27 SQL Optimizer enabled (max 1000 layouts)
01:44:28 Compiler unit is timed at 0.000291 msec
01:44:30 Roll forward started
01:44:30 Roll forward complete
01:44:32 Checkpoint started
01:44:32 Checkpoint finished, log reused
01:44:32 HTTP/WebDAV server online at 8890
01:44:32 Server online at  (pid 28041)
02:44:33 Checkpoint started
02:44:33 Checkpoint finished, log reused
03:05:37 * Monitor: Locks are held for a long time
03:05:55 * Monitor: Should read for update because lock escalation from
shared to exclusive fails frequently (1)
03:07:37 * Monitor: Locks are held for a long time
03:18:55 * Monitor: Many lock waits

I downloaded Virtuoso from: git clone git://
github.com/openlink/virtuoso-opensource.git
Git checkout gives me: $ git checkout -t remotes/origin/develop/7
fatal: git checkout: branch develop/7 already exists
The parameters of my virtuoso.ini file are:
;
;  virtuoso.ini
;
;  Configuration file for the OpenLink Virtuoso VDBMS Server
;
;  To learn more about this product, or any other product in our
;  portfolio, please check out our web site at:
;
;  http://virtuoso.openlinksw.com/
;
;  or contact us at:
;
;  general.informat...@openlinksw.com
;
;  If you have any technical questions, please contact our support
;  staff at:
;
;  technical.supp...@openlinksw.com
;

;
;  Database setup
;
[Database]
DatabaseFile =
/home/Virtuoso/virtuosoInstalled/var/lib/virtuoso/db/virtuoso.db
ErrorLogFile =
/home/Virtuoso/virtuosoInstalled/var/lib/virtuoso/db/virtuoso.log
LockFile = /home/Virtuoso/virtuosoInstalled/var/lib/virtuoso/db/virtuoso.lck
TransactionFile =
/home/Virtuoso/virtuosoInstalled/var/lib/virtuoso/db/virtuoso.trx
xa_persistent_file =
/home/Virtuoso/virtuosoInstalled/var/lib/virtuoso/db/virtuoso.pxa
ErrorLogLevel = 7
FileExtend = 200
MaxCheckpointRemap = 17
Striping = 0
TempStorage = TempDatabase


[TempDatabase]
DatabaseFile =
/home/Virtuoso/virtuosoInstalled/var/lib/virtuoso/db/virtuoso-temp.db
TransactionFile =
/home/Virtuoso/virtuosoInstalled/var/lib/virtuoso/db/virtuoso-temp.trx
MaxCheckpointRemap = 200
Striping = 0


;
;  Server parameters
;
[Parameters]
ServerPort = 
LiteMode = 0
DisableUnixSocket = 1
DisableTcpSocket = 0
;SSLServerPort = 2111
;SSLCertificate = cert.pem
;SSLPrivateKey = pk.pem
;X509ClientVerify = 0
;X509ClientVerifyDepth = 0
;X509ClientVerifyCAFile = ca.pem
MaxClientConnections = 10
CheckpointInterval = 60
O_DIRECT = 0
CaseMode = 2
MaxStaticCursorRows = 5000
CheckpointAuditTrail = 0
AllowOSCalls = 0
SchedulerInterval = 10
DirsAllowed = ., /home/Virtuoso/virtuosoInstalled/share/virtuoso/vad
ThreadCleanupInterval = 0
ThreadThreshold = 10
ResourcesCleanupInterval = 0
FreeTextBatchSize = 10
SingleCPU = 0
VADInstallDir = /home/Virtuoso/virtuosoInstalled/share/virtuoso/vad/
PrefixResultNames   = 0
RdfFreeTextRulesSize = 100
IndexTreeMaps = 256
MaxMemPoolSize  = 2
PrefixResultNames   = 0
MacSpotlight= 0
IndexTreeMaps   = 64
MaxQueryMem  = 2G ; memory allocated to query processor
VectorSize  = 1000 ; initial parallel query vector (array of query
operations) size
MaxVectorSize  = 100 ; query vector size threshold.
AdjustVectorSize  = 0
ThreadsPerQuery  = 4
AsyncQueueMaxThreads  = 10
;;
;; When running with large data sets, one should configure the Virtuoso
;; process to use between 2/3 to 3/5 of free system memory and to stripe
;; storage on all available disks.
;;
;; Uncomment next two lines if there is 2 GB system memory free
;NumberOfBuffers  = 1700

[Virtuoso-users] Understanding output of explain command

[Maria Jackson]

Dear All,

I ran the following explain SPARQL command. However, I am unable to
understand the output of explain. Can someone please explain me the output?
(I mean it is difficult to understand as to what is meant by RDF_QUAD_POGS
1 rows(s_1_4_t0.S, s_1_4_t0.O) and 0: c1 := Call __ro2sq
(s_1_4_t0.O))

SQL> explain('sparql select ?a?c1?c2 where{?a  ?c1.
?a  ?c2}');
REPORT
VARCHAR
___

{
RDF_QUAD_POGS 1 rows(s_1_4_t0.S, s_1_4_t0.O)
 inlined  P =  #/b1
RDF_QUAD_POGS 1 rows(s_1_4_t1.O)
 inlined  P =  #/b  S = k_s_1_4_t0.S

After code:
  0: c1 := Call __ro2sq (s_1_4_t0.O)
  5: a := Call __id2in (s_1_4_t0.S)
  10: c2 := Call __ro2sq (s_1_4_t1.O)
  15: BReturn 0
Select (a, c1, c2)
}
--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] Find the amount of RAM used by virtuoso during query execution?

[Maria Jackson]

Is it possible to find the amount of main memory used by Virtuoso during
query execution?
--
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=/4140/ostg.clktrk___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] Query regarding virtuoso

[Maria Jackson]

Hi,

I downloaded dbpedia n-quads data from (
http://km.aifb.kit.edu/projects/btc-2012/dbpedia/). I am trying to load BTC
data to Virtuoso using:


 
DB.DBA.TTLP_MT(file_to_string_output('/var/lib/virtuoso-opensource-6.1/db/data-0.nq'),'','graph
iri',512);

I am getting the following error:

*** Error RDFXX: [Virtuoso Driver][Virtuoso Server]Bad datatype code:
DB.DBA.RDF_OBJ_ADD (256, POINT(7.2858 49.0797), 257)
at line 20 of Top-Level:

DB.DBA.TTLP_MT(file_to_string_output('/var/lib/virtuoso-opensource-6.1/db/data-0.nq'),'','graph
iri',512)


I am unable to understand as to what is going wrong. Can someone please
help.
--
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users