Hi Erich,
The st_setsrid() function sets the SRID but does not project the coordinates as
it doesn't have to make the projection. PostGIS works same way, see:
http://postgis.net/docs/ST_SetSRID.html
The purpose of the st_setsrid() function is to set the SRID on a geometry to a
particular integer value, nothing else.
For real transformation of coordinates from one system to another, the
ST_Transform() functions should be used which we are currently finalising the
implementation of ...
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 30 May 2014, at 03:46, Erich Bremer <er...@ebremer.com> wrote:
> 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);
>>
>> *** 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)
>> 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);
>>
>> 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> 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_10/SPARQL_Tutorials_Part_10.html#(30)
>>>>
>>>> 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
------------------------------------------------------------------------------
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
