subject:"Re\: \[Virtuoso\-users\] SPATIAL JOIN queries in Virtuoso"

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

2016-04-17 Thread Hugh Williams

Hi Maria,

It looks fine, why are you having a problem with it ?

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 15 Apr 2016, at 05:47, Maria Jackson  wrote:
> 
> Dear Hugh,
> 
> Thanks for the information. We used the following query, please verify
> that it is the correct way of querying Virtuoso.
> 
> sparql select ?place ?nplace ?lat1 ?long1 ?lat2 ?long2 WHERE  {graph
> ?g1{?place  ?lat1}
> graph ?g1{?place 
> ?long1}  graph ?g4{?nplace
>  ?lat2} graph
> ?g4{?nplace 
> ?long2}. 
> FILTER(bif:st_intersects(bif:st_point(xsd:decimal(?long1),xsd:decimal(?lat1)),bif:st_point(xsd:decimal(?long2),xsd:decimal(?lat2)),176.7))};
> 
> 
> 
> 
> On Tue, Apr 12, 2016 at 4:53 PM, Hugh Williams  
> wrote:
>> 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'), 
>> '','',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),
>> 
>> at line 1 of Top-Level:
>> DB.DBA.TTLP_MT (file_to_string_output('./spatialTest2.nq'), 
>> '','',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'), 
>> '','',512);
>> 
>> Done. -- 10 msec.
>> SQL> sparql select ?place ?nplace (( bif:st_distance( ?long,?nlong) ) AS 
>> ?distance) WHERE  {graph ?g1{?place 
>>  ?long} graph ?g4{?nplace 
>>  ?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

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

2016-04-14 Thread Maria Jackson

Dear Hugh,

Thanks for the information. We used the following query, please verify
that it is the correct way of querying Virtuoso.

sparql select ?place ?nplace ?lat1 ?long1 ?lat2 ?long2 WHERE  {graph
?g1{?place  ?lat1}
graph ?g1{?place 
?long1}  graph ?g4{?nplace
 ?lat2} graph
?g4{?nplace 
?long2}. 
FILTER(bif:st_intersects(bif:st_point(xsd:decimal(?long1),xsd:decimal(?lat1)),bif:st_point(xsd:decimal(?long2),xsd:decimal(?lat2)),176.7))};




On Tue, Apr 12, 2016 at 4:53 PM, Hugh Williams  wrote:
> 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'), 
> '','',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),
> 
> at line 1 of Top-Level:
> DB.DBA.TTLP_MT (file_to_string_output('./spatialTest2.nq'), 
> '','',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'), 
> '','',512);
>
> Done. -- 10 msec.
> SQL> sparql select ?place ?nplace (( bif:st_distance( ?long,?nlong) ) AS 
> ?distance) WHERE  {graph ?g1{?place 
>  ?long} graph ?g4{?nplace 
>  ?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 --

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

2016-04-12 Thread Hugh Williams

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'), 
'','',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),

at line 1 of Top-Level:
DB.DBA.TTLP_MT (file_to_string_output('./spatialTest2.nq'), 
'','',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'), 
'','',512);

Done. -- 10 msec.
SQL> sparql select ?place ?nplace (( bif:st_distance( ?long,?nlong) ) AS 
?distance) WHERE  {graph ?g1{?place 
 ?long} graph ?g4{?nplace 
 ?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  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):
> "
>  "POINT (77.164230
> 33.187725)"^^ 
> .
> 
>  "POINT (78.748611
> 32.748742)"^^ 
> .
> 
>

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

2016-04-09 Thread 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):
"
 "POINT (77.164230
33.187725)"^^ .

 "POINT (78.748611
32.748742)"^^ .

 "POINT (2.79723
-122.934)"^^ ."

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

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
 ?long} graph ?g4{?nplace
 ?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=/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

2016-02-25 Thread 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=/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

2016-02-24 Thread Hugh Williams

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



smime.p7s
Description: S/MIME cryptographic signature
--
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=/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

2016-02-24 Thread 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=/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=/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=/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=/4140
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net

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

2016-02-24 Thread Kingsley Idehen

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




smime.p7s
Description: S/MIME Cryptographic Signature
--
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=/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

2016-02-24 Thread 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=/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=/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

2016-02-24 Thread 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
 ?long} graph ?g4{?nplace
 ?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=/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

2016-02-24 Thread Hugh Williams

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



smime.p7s
Description: S/MIME cryptographic signature
--
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=/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

2016-02-24 Thread 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'),
>> '','',512);
>>
>> Done. -- 13 msec.
>> SQL> sparql select ?place ?nplace (( bif:st_distance( ?long,?nlong) ) AS
>> ?distance) WHERE  {graph ?g1{?place
>>  ?long} graph ?g4{?nplace
>>  ?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
>>  ?long} graph ?g4{?nplace
>>  ?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):
>> "
>>  "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?
>>
>>

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

2016-02-23 Thread 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'),
> '','',512);
>
> Done. -- 13 msec.
> SQL> sparql select ?place ?nplace (( bif:st_distance( ?long,?nlong) ) AS
> ?distance) WHERE  {graph ?g1{?place
>  ?long} graph ?g4{?nplace
>  ?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
>  ?long} graph ?g4{?nplace
>  ?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):
> "
>  "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

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

2016-02-23 Thread Hugh Williams

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'), 
'','',512);

Done. -- 13 msec.
SQL> sparql select ?place ?nplace (( bif:st_distance( ?long,?nlong) ) AS 
?distance) WHERE  {graph ?g1{?place 
 ?long} graph ?g4{?nplace 
 ?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  ?long} 
graph ?g4{?nplace  ?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):
> "
>  "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=/4140
> ___
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users



smime.p7s
Description: S/MIME cryptographic signature
--
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!

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

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

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

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

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

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

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

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

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

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

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

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

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

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

14 matches

Site Navigation

Mail list logo

Footer information