Hi Hugh,
Thanks, so, if I understand you correctly, for the moment, I cannot
import generic 2d Cartesian coordinate data into a spatial index? - Erich
On 05/30/14 11:22 PM, Hugh Williams wrote:
> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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
>>>>>> [email protected]
>>>>>> 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
>> [email protected]
>> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users