Re: [Virtuoso-users] Spatial index
Great, thanks a lot !!!
I won't be able to test until february, but will let you know at this
moment if I encounter any other problems.
Bests,
Olivier
2015-01-08 18:29 GMT+01:00 Hugh Williams hwilli...@openlinksw.com:
Hi Oliver,
A fix for this issue is available in the latest VOS git develop/7 branch:
SQL SPARQL SELECT * FROM http://mygraph/ where {?s ?p ?o};
s
p
o
VARCHAR
VARCHAR
VARCHAR
___
0 Rows. -- 4 msec.
SQL SPARQL INSERT INTO GRAPH http://mygraph/ {
http://mygraph/#austrian_lot_source_1
http://www.opengis.net/ont/geosparql#geometry MULTIPOLYGON(((0.0
0.0,1.0 0.0,1.0 1.0,0.0 1.0,0.0 0.0)))^^
http://www.openlinksw.com/schemas/virtrdf#Geometry .};
Done. -- 5 msec.
SQL SPARQL SELECT * FROM http://mygraph/ where {?s ?p ?o};
s
p
o
VARCHAR
VARCHAR
VARCHAR
___
http://mygraph/#austrian_lot_source_1
http://www.opengis.net/ont/geosparql#geometry
MULTIPOLYGON(((0.00 0.00,1.00 0.00,1.00
1.00,0.00 1.00,0.00 0.00)))
1 Rows. -- 0 msec.
SQL SPARQL DELETE FROM GRAPH http://mygraph/ {
http://mygraph/#austrian_lot_source_1
http://www.opengis.net/ont/geosparql#geometry MULTIPOLYGON(((0.0
0.0,1.0 0.0,1.0 1.0,0.0 1.0,0.0 0.0)))^^
http://www.openlinksw.com/schemas/virtrdf#Geometry .};
Done. -- 1 msec.
SQL SPARQL SELECT * FROM http://mygraph/ where {?s ?p ?o};
s
p
o
VARCHAR
VARCHAR
VARCHAR
___
0 Rows. -- 0 msec.
SQL status('');
REPORT
VARCHAR
___
OpenLink Virtuoso Server
Version 07.10.3211-pthreads for Linux as of Jan 8 2015
Started on: 2015-01-08 18:13 GMT+1
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 27 Oct 2014, at 12:33, Hugh Williams hwilli...@openlinksw.com wrote:
Hi Oliver,
I would notify when it is available or you can check the open source RSS
feed [1] for fix notifications . Logging as an issue on the git issue
tracker system [2] is also a good way of keeping track of such issues as it
would the be closed when the fix is pushed ...
An ETA for fix is not available as development first need to schedule to
look into it get then give an assessment of time to fix etc ...
[1]
https://github.com/openlink/virtuoso-opensource/commits/develop%2F7.atom
[2] https://github.com/openlink/virtuoso-opensource/issues/
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 26 Oct 2014, at 21:16, Olivier Dalang olivier.dal...@gmail.com wrote:
Hi,
Great, thanks a lot !!
Is there some way to get notified when the fix is available in develop/7
(github issue or something) ? And do you have by any chance an idea of when
such a fix could be ready ?
Best regards,
Olivier
2014-10-26 21:18 GMT+01:00 Hugh Williams hwilli...@openlinksw.com:
Hi Oliver,
I have been able to recreate this geometry deletion issue in-house
against the latest develop//7 build and reported to development to fix ...
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 22 Oct 2014, at 17:14, Olivier Dalang olivier.dal...@gmail.com
wrote:
Hi again !
I've got another problem : I can't delete my triples !
(note : I'm using Virtuoso Version 7.1.1-dev.3211-pthreads )
This works (creates and then delete the triple) :
INSERT INTO GRAPH http://mygraph/ {
http://mygraph/#myitem http://www.w3.org/2000/01/rdf-schema#label
Blabla .
}
Re: [Virtuoso-users] st_within error with small tolerance
On 2015-01-07 3:55, Hugh Williams wrote:
Hi Frans,
This is a known issue reported with other geospatial queries and to be
looked into by development.
For your query can you please provide query profiles for both queries
ie the one that works and the one that does not, when run from isql
using the “set profile on” command as detailed at:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksAanalyzingSPARQLQuery
OK! I will send the execution plans to you personally.
Regards,
Frans
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 6 Jan 2015, at 12:41, Frans Knibbe | Geodan
frans.kni...@geodan.nl mailto:frans.kni...@geodan.nl wrote:
Hello,
I know support for geographical functions in Virtuoso is a work in
progress, but I want to report the following issue anyway. Perhaps
developers are unaware of the issue, or perhaps there is a fix
available in the current version of Virtuoso (I use 7.10.3211).
I notice that when I try to use st_within
http://docs.openlinksw.com/virtuoso/fn_st_within.html with a search
radius I get the error Virtuoso 42000 Error SQ200: Stack Overflow in
cost model when the radius (/prec/ parameter) gets below a certain
threshold. This query runs well (on SPARQL endpoint
http://lod.geodan.nl/sparql) :
prefix bag:http://lod.geodan.nl/vocab/bag#
select count(*)
fromhttp://lod.geodan.nl/basisreg/bag/pand/
fromhttp://lod.geodan.nl/basisreg/bag/verblijfsobject/
where {
?pandmutatie a bag:Pandmutatie .
?pandmutatie bag:geometrie ?geom .
?pandmutatie bag:pand ?pand .
?verblijfsobjectmutatie a bag:Verblijfsobjectmutatie .
?verblijfsobjectmutatie bag:pand ?pand .
filter (bif:st_within(?geom, bif:st_point (4.91, 52.38), 0.002))
}
But when the radius is changed to 0.001 the query returns the Stack
Overflow in cost model error.
Regards,
Frans
Frans Knibbe
Geodan
President Kennedylaan 1
1079 MB Amsterdam (NL)
T +31 (0)20 - 5711 347
E frans.kni...@geodan.nl
www.geodan.nl http://www.geodan.nl/ | disclaimer
http://www.geodan.nl/disclaimer
--
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
mailto:Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Frans Knibbe
Geodan
President Kennedylaan 1
1079 MB Amsterdam (NL)
T +31 (0)20 - 5711 347
E frans.kni...@geodan.nl
www.geodan.nl http://www.geodan.nl | disclaimer
http://www.geodan.nl/disclaimer
--
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
Re: [Virtuoso-users] Virtuoso query length - http 400 exception
Hi, On 9 Jan 2015, at 14:10, Boris Villazon-Terrazas bvilla...@isoco.com wrote: I'm performing a query against Virtuoso 07.10.3208 , via Jena-ARQ 2.11.2 The query is a bit long, it has 16kb and I'm getting an http 400 exception is there a way to deal with big SPARQL queries in Virtuoso (in this context, i.e., via Jena)? are you sending them as HTTP GET or POST? Jörn -- 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
Re: [Virtuoso-users] st_within error with small tolerance
On 2015-01-09 12:50, Frans Knibbe | Geodan wrote:
On 2015-01-07 3:55, Hugh Williams wrote:
Hi Frans,
This is a known issue reported with other geospatial queries and to
be looked into by development.
One further thing I have just noticed: Queries that ran OK in a previous
build (I can't recall which exactly) get the stack overflow error in
build 7.10.3211.
Maybe this bit of information is helpful...
Regards,
Frans
For your query can you please provide query profiles for both queries
ie the one that works and the one that does not, when run from isql
using the “set profile on” command as detailed at:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksAanalyzingSPARQLQuery
OK! I will send the execution plans to you personally.
Regards,
Frans
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 6 Jan 2015, at 12:41, Frans Knibbe | Geodan
frans.kni...@geodan.nl mailto:frans.kni...@geodan.nl wrote:
Hello,
I know support for geographical functions in Virtuoso is a work in
progress, but I want to report the following issue anyway. Perhaps
developers are unaware of the issue, or perhaps there is a fix
available in the current version of Virtuoso (I use 7.10.3211).
I notice that when I try to use st_within
http://docs.openlinksw.com/virtuoso/fn_st_within.html with a
search radius I get the error Virtuoso 42000 Error SQ200: Stack
Overflow in cost model when the radius (/prec/ parameter) gets
below a certain threshold. This query runs well (on SPARQL endpoint
http://lod.geodan.nl/sparql) :
prefix bag:http://lod.geodan.nl/vocab/bag#
select count(*)
fromhttp://lod.geodan.nl/basisreg/bag/pand/
fromhttp://lod.geodan.nl/basisreg/bag/verblijfsobject/
where {
?pandmutatie a bag:Pandmutatie .
?pandmutatie bag:geometrie ?geom .
?pandmutatie bag:pand ?pand .
?verblijfsobjectmutatie a bag:Verblijfsobjectmutatie .
?verblijfsobjectmutatie bag:pand ?pand .
filter (bif:st_within(?geom, bif:st_point (4.91, 52.38), 0.002))
}
But when the radius is changed to 0.001 the query returns the Stack
Overflow in cost model error.
Regards,
Frans
Frans Knibbe
Geodan
President Kennedylaan 1
1079 MB Amsterdam (NL)
T +31 (0)20 - 5711 347
E frans.kni...@geodan.nl
www.geodan.nl http://www.geodan.nl/ | disclaimer
http://www.geodan.nl/disclaimer
--
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
mailto:Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Frans Knibbe
Geodan
President Kennedylaan 1
1079 MB Amsterdam (NL)
T +31 (0)20 - 5711 347
E frans.kni...@geodan.nl
www.geodan.nl http://www.geodan.nl | disclaimer
http://www.geodan.nl/disclaimer
--
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
Frans Knibbe
Geodan
President Kennedylaan 1
1079 MB Amsterdam (NL)
T +31 (0)20 - 5711 347
E frans.kni...@geodan.nl
www.geodan.nl http://www.geodan.nl | disclaimer
http://www.geodan.nl/disclaimer
--
Dive into the World of Parallel Programming!
