Questions tagged [sdo-geometry]

SDO_GEOMETRY is a vector data type in Oracle Spatial

Filter by
Sorted by
Tagged with
1
vote
0answers
130 views

Checking for overlaps in polygons using Oracle Spatial?

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 ...
2
votes
0answers
130 views

How update location field (geometry) in Oracle Spatial using asp.net web application?

I want to update a geometry column in Oracle Spatial database via Asp.net web application, I couldn't find samples for update query or datatypes that can hold geometry data in asp.net. I use C# for ...
1
vote
1answer
42 views

Is SDO_GEOM.RELATE returning erroneous results?

I believe I am getting some erroneous results when performing SDO_GEOM.RELATE with my spatial query. Given the following query: select SDO_GEOM.RELATE( MDSYS.SDO_GEOMETRY(2003, 4326, NULL, ...
1
vote
1answer
51 views

Lines from Oracle Spatial Layer in QGIS are not completly visible

I connected a spatial layer from the Oracle database which contains lines (OracleDB objectclass typ is polyline) to be visible in QGIS. An example geometry is as follows: sdo_geometry(2002,2056,...
1
vote
0answers
249 views

How can I load layers from oracle with the python editor that comes with Qgis?

I have tried to add a layer from the Oracle database with SDO_GEOMETRY geometry, from the console that comes in QGIS, but it does not load anything, I occupy this because I want to put it in a plugin. ...
1
vote
4answers
1k views

Populating oracle sdo_geometry object using GeoJSON?

I have GeoJson data. I would like to convert this GeoJson data into sdo_geometry object type and insert Oracle spatial database. Which columns represent geojson data in oracle sdo_geometry object. ...
5
votes
4answers
259 views

Join on attributes and write vector or create feature from Oracle SDO with pyqgis

QGIS 2.14 & 2.18 Step 1 : I do an extraction with QgsDataSourceURI() #get geometries uri = QgsDataSourceURI() uri.setConnection("svdbocsva003.test.blavla.lan", "1521", "tata", "toto", "pwd") uri....
0
votes
2answers
1k 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 database entries where the polygons of a multipolygon overlap - within the same geometry? So, a function that ...
1
vote
0answers
78 views

Can OVERLAPBDYDISJOINT or ON ever occur between two polygons?

Oracle uses a series of specific spatial relationships to indicate the how different shapes interact with each other. Two of the relationships it describes are somewhat odd: OVERLAPBDYDISJOINT: ...
2
votes
1answer
282 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
2answers
3k 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
36 views

SDO Geometry Cut Out Overlap

I am looking to find a way using SDO Geometry to overlay two polygons, Polygon A and Polygon B. I consider Polygon A to be my bottom layer. Wherever Polygon B overlaps Polygon A, I want to cut that ...
1
vote
2answers
672 views

SDO_GEOMETRY view in ArcGIS Desktop

I have an sdo_geometry table that I created using ArcGIS Desktop (by converting an esri.st_geometry table to sdo_geometry). I'm using Oracle Spatial's sdo_geometry datatype because it has linear ...
2
votes
1answer
1k views

Create a point in intersection of 2 lines postgis

As an ArcGIS user this is simple but in PostGIS has became a nightmare. But well I guess this is typical in beginners like me. I have 2 layers (multilinestring) called roads and waterways, I'm trying ...
1
vote
2answers
989 views

How to store geolocation in tabular Oracle without using Oracle Spatial or Locator?

I'm working on a project to link existing entities in an Oracle database with their geolocation, but the database is a tabular not spatial. Is there a compatible type that can store the geolocation ...
0
votes
2answers
1k views

Performing a spatial relationship in Oracle SQL with only lat/long.

I currently have a query that pulls a latitude field and a longitude field (separate fields). This is sufficient for one portion of customer product, but for a second table I need to add a second ...
2
votes
0answers
331 views

Oracle Spatial: Error with SDO_UNION

I have a table which contains address-points. With following sql-statement i have created a 100-meter buffer around each address-point: CREATE TABLE BUFFERPOLYGONS AS SELECT a.OBJECTID, SDO_GEOM....
6
votes
1answer
1k 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
1answer
1k 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
1k 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
2k 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
0answers
411 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 ...
6
votes
1answer
538 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 ...