I need to find the centroid of a polygon in Oracle Spatial that exists inside of the polygon itself. I cannot use the sdo_geom.sdo_centroid method because this returns a point outside of the shape if the shape resembles a horseshoe. I found sdo_geom.sdo_pointonsurface method, but it returns a point that is just on the edge of the pol...
A (spatial) query in Oracle 10g gets different execution plan depending only on a parameter value. And sadly Oracle cannot execute one of the plans at all, giving an error. Changing value (below 282 to 284) or operator (= to <) gives a result. Why are the plans different? Why oracle selects an unexecutable plan? What to do to force Orac...
We have a table containing coordinates, among other things. We used to store these in two number fields (x and y), but we've now replaced this with an SDO_GEOMETRY field. For backwards compatibility, we have created a view (with the same name as the table used to have), where we do: create or replace view meas_pnt as select ..., m.posit...
please help me connect spatials to oracle 10g XE where can i find fun things to do with oracle spatial? ...
Does anyone have a clear document on how to move Orace Spatial data to Postgres (both Community version and Enterprise DB... Thanks ...
I'm working on a C# program that deals with Oracle Spatial geometry. When circle data is stored in a geometry field only three non-collinear points are stored to represent the circle. The problem is that I need to use this data on a Google Maps web page and need the center point and radius of the circle (since my circle drawing function ...
Hello, fellow developers. I'm starting studies in Oracle 11g Spatial Databases and I want to know if is there a query that returns the shortest route (or path) between two points, or between a point and a linestring. I have a map with some linestring (hiking trails) and Polygons (geographic accidents) and I want to find the shortest ro...
I've been struggling to create an Oracle SQL query that will tell me if my SDO table contains curves or arcs. I know that the sdo_elem_info contains the information I need, but I don't know how to use SQL to separate out the etype and interpretation from the sdo_elem_info. So far, all I have is: select tbl.shape.sdo_elem_info from my_t...