SDO_GEOMETRY is a vector data type in Oracle Spatial

learn more… | top users | synonyms

0
votes
0answers
81 views

Read 3D polygon from Oracle SDO_GEOMETRY and convert to triangles

History I have written a c# service that consumes a list of x,y,z points from a csv file. These points form a valid 3D polygon which I am able to verify using SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT()...
0
votes
0answers
89 views

Accessing array of x,y coordinates stored as MDSYS.SDO_GEOMETRY / PUBLIC.SDO_GEOMETRY attribute in Oracle 11g?

I am totally new to GIS. I am working with a table in an Oracle 11g database. In each row of this table there are two attributes of interest: one is of type MDSYS.SDO_GEOMETRY and the other PUBLIC....
0
votes
0answers
39 views

ORA-13356 How to remove redundant points from 3D Polygon

I've created a sdo_geometry column in an Oracle 11.2 database and I've managed to import a list of co-ordinates from a csv file with a c# service that creates a flat Polygon in 3D and inserts into the ...
1
vote
1answer
352 views

Querying Oracle geometry data type

How to query or find the geometry data type a given Oracle Database is using in SQL Developer (i.e. SDO_Geometry, ST_Geometry, etc)? I thought I could just describe a feature class within the ...
0
votes
0answers
64 views

Front-end GUI for a spatial database

I'm an intermediate GIS analyst with a vision that I need help executing. I have a team that is constantly distributing back and forth shapefiles of polygons (between 10 and 50 features in each) ...
0
votes
1answer
240 views

Get WKT from polygon centroid

I have an Oracle Spatial table (in 12c) with a polygon geometry type. I added a text column to the table that I would like to populate with the well-known text of the polygon's centroid. In concept ...
1
vote
1answer
160 views

Insert SDO_GEOMETRY in cx_oracle

I have many polygons to insert. This code is ready to use. geom_str = '"MDSYS"."SDO_GEOMETRY"(2003,NULL,NULL,"MDSYS"."SDO_ELEM_INFO_ARRAY"(1,1003,1),"MDSYS"."SDO_ORDINATE_ARRAY"(-735342,-1010550,-...
0
votes
1answer
306 views

SDO_GEOMETRY uniqueness in Oracle

Is it feasible converting the spatial property (SDO_GEOMETRY) of a table in Oracle as an unique index or spatial constraint for avoiding spatial duplicates? I am working on point tables and I don't ...
1
vote
1answer
149 views

Sdo_Geom.Sdo_Intersection is not considering overlapping vertices

I'm using below package to get the number of intersecting vertices Sdo_Util.Getnumvertices(Sdo_Geom.Sdo_Intersection(B.Geom,R.Geom,.00000000005)) It is returning only 1 when there are actually 15 ...
1
vote
0answers
164 views

ODP.NET invoked member is not supported in a dynamic assembly

I am using ODP.NET to get access to a geometry column in an Oracle database. My code (derived from Oracle's sample) often (but not always) crashes on the last line where the geometry column value is ...
2
votes
0answers
78 views

Check for overlaps in polygons

I want to get a list of all the polygons from table 2 which overlap with one polygon from table 1. Following is the query which I am trying to use which doesnt give any result. Select b.bg_id from ...
4
votes
1answer
381 views

Does ArcSDE require Oracle Spatial rather than Oracle Locator licensing for any functionality when working with SDO_GEOMETRY?

I'm looking for specific information on whether the ESRI suite requires Oracle Spatial for any of the functionality, or if Locator is always sufficient for working with SDO_GEOMETRY objects? Do you ...
6
votes
1answer
639 views

Too many features selected with the ArcMap Select by Polygon tool

Here is my problem: First of all you have to know that I have ArcMap 10.1 SP1. My features are stored in Oracle 11g database in SDO_GEOMETRY format. I have imported a layer of accidents location in ...
0
votes
2answers
846 views

How to find overlapping polygons within a multipolygon (oracle spatial)

I am working with Oracle spatial and have a table with MULTIPOLYGONS. How can I find the db entries where the polygons of a multipolygon overlap - within the same geometry? So, a function that checks ...