Re: Oracle Spatial and PostGis - Mailing list pgsql-general

From Martin Gainty
Subject Re: Oracle Spatial and PostGis
Date
Msg-id BLU142-W130525F11CB9725C24AF5CAEA10@phx.gbl
Whole thread Raw
In response to Oracle Spatial and PostGis  (Szymon Guz <mabewlun@gmail.com>)
List pgsql-general
take Oracle Spatial SDO_FILTER Functio
Uses the spatial index to identify either the set of spatial objects that are likely to interact spatially with a given object
Format: SDO_FILTER(geometry1, geometry2, params);
http://download.oracle.com/docs/html/A85337_01/sdo_oper.htm#76214
 
example:
select geom  " +
                               "from geod_counties " +
                               "where sdo_filter (geom, sdo_geometry(2003,8307,null," +
                                                          "sdo_elem_info_array(1,1003,3)," +
                                                          "sdo_ordinate_array (-75,40,-74,41))) = 'TRUE'");

PostGIS equivalent:
SELECT a.geom
FROM geod_counties a 
WHERE ST_Intersects(a.geom, sdo_geometry(2003,8307,null,"sdo_elem_info_array(1,1003,3))
Function name is different
Oracle sdo_filter 3rd param would need to be discarded
 
looks like a hand conversion
Martin Gainty
______________________________________________
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.

Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.




 

Date: Wed, 21 Jul 2010 12:41:28 +0200
Subject: [GENERAL] Oracle Spatial and PostGis
From: mabewlun@gmail.com
To: pgsql-general@postgresql.org

Hi,
when I have an Oracle spatial database, I can easily convert it to PostgreSQL database, using handwritten tool, or just dumping it to a shape file and loading to the PostGis database. Do you know any simple way for (semi)automatical conversion of the spatial queries from Oracle to PostGis? I have many spatial queries in Oracle and I'd like to use them with PostgreSQL. Any ideas where I can find more information?


regards
Szymon Guz


The New Busy is not the old busy. Search, chat and e-mail from your inbox. Get started.

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Insert and Retrieve unsigned char sequences using C
Next
From: Robot Tom
Date:
Subject: Re: transactions within stored procedures