Hi Hugh,

Stupid me on forgetting the double braces. How can I change the default srid from 4326 to something else? I just want a 2d Cartesian coordinate system (my data isn't WGS 84). Although it seems I can change the srid with st_setsrid, ttlp will throw the same error as below when I try to load my non-4326 data (even with the extra braces). - Erich

On 05/28/14 5:53 PM, Hugh Williams wrote:
Hi Erich,

You need to have double opening and closing braces around the "POLYGON((...))" geometry type:

Fails:

SQL> ttlp ('@prefix virtrdf: <http://www.openlinksw.com/schemas/virtrdf#> . @prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> . _:wow geo:geometry "POLYGON(1 2, 6 1, 9 3, 3 6, 1 2)"^^virtrdf:Geometry .','','http://www.whatever.com',0 <http://www.whatever.com%27,0>);

*** Error 42000: VD [Virtuoso Server]RDFGE: rdf box with a geometry rdf type and a non geometry content
at line 1 of Top-Level:
ttlp ('@prefix virtrdf: <http://www.openlinksw.com/schemas/virtrdf#> . @prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> . _:wow geo:geometry "POLYGON(1 2, 6 1, 9 3, 3 6, 1 2)"^^virtrdf:Geometry .','','http://www.whatever.com',0 <http://www.whatever.com%27,0>)
SQL>

*Works:*

SQL> ttlp ('@prefix virtrdf: <http://www.openlinksw.com/schemas/virtrdf#> . @prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> . _:wow geo:geometry "POLYGON*((*1 2, 6 1, 9 3, 3 6, 1 2*))*"^^virtrdf:Geometry .','','http://www.whatever.com',0 <http://www.whatever.com%27,0>);

Done. -- 1268 msec.
SQL> sparql select * from <http://www.whatever.com> where {?s ?p ?o};
s                       p                                           o
VARCHAR VARCHAR VARCHAR
_______________________________________________________________________________

nodeID://b10004 http://www.w3.org/2003/01/geo/wgs84_pos#geometry POLYGON((1.000000 2.000000,6.000000 1.000000,9.000000 3.000000,3.000000 6.000000,1.000000 2.000000))

1 Rows. -- 724 msec.
SQL>
SQL>
SQL> status('');
REPORT
VARCHAR
_______________________________________________________________________________

OpenLink Virtuoso  Server
Version 07.10.3209-pthreads for Darwin as of May 22 2014

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 May 2014, at 20:57, Erich Bremer <er...@ebremer.com <mailto:er...@ebremer.com>> wrote:

Hi Hugh,

Awesome! However, I tried adding a single triple as follows and got an error. Am I missing something?

SQL> ttlp ('@prefix virtrdf: <http://www.openlinksw.com/schemas/virtrdf#> . @prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> . _:wow geo:geometry "POLYGON(1 2, 6 1, 9 3, 3 6, 1 2)"^^virtrdf:Geometry .','','http://www.whatever.com',0);

*** Error 42000: [Virtuoso Driver][Virtuoso Server]RDFGE: rdf box with a geometry rdf type and a non geometry content
at line 57 of Top-Level:
ttlp ('@prefix virtrdf: <http://www.openlinksw.com/schemas/virtrdf#> . @prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> . _:wow geo:geometry "POLYGON(1 2, 6 1, 9 3, 3 6, 1 2)"^^virtrdf:Geometry .','','http://www.whatever.com',0)
SQL>

- Erich


On 05/24/14 6:32 PM, Hugh Williams wrote:
Hi Erich,

Virtuoso open source and commercial does now have support for polygon geometry types and others as detailed on the 7.1 release notes at:

http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSNews#2014-02-17%20--%20Virtuoso%20Open-Source%20Edition%207.1.0%20Released

Live examples can also be found at:

http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_11/SPARQL_Tutorials_Part_11.html#(1) <http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_11/SPARQL_Tutorials_Part_11.html#%281%29> http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.html#(30) <http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_10/SPARQL_Tutorials_Part_10.html#%2830%29>

We are currently working on updates to the online docs to details the new types supported ...

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 May 2014, at 18:31, Erich Bremer <er...@ebremer.com> wrote:

Are there any plans to support other geometries like POLYGON besides
POINT in Virtuoso?

As per, "9.34.3. Geometric Objects - Only the 2D point is supported." at
the URL:
http://docs.openlinksw.com/virtuoso/sqlrefgeospatial.html

 - Erich

------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users




------------------------------------------------------------------------------
Time is money. Stop wasting it! Get your web API in 5 minutes.
www.restlet.com/download
http://p.sf.net/sfu/restlet
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to