Questions tagged [sdo-geometry]

SDO_GEOMETRY is a vector data type in Oracle Spatial

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

I need to remove Z dimension on spatial column (ST_GEOMETRY) with Esri on Oracle using the PL/SQL packages

I need to remove Z dimension on spatial column (ST_GEOMETRY) with Esri on Oracle using the PL/SQL packages I need to do the following, but using the ESRI PL/SQL packages on Oracle. I have used a ...
1
vote
0answers
55 views

Use a non-GDB SDO_GEOMETRY table in a map service?

I have a table with an SDO_GEOMETRY column (points) in an external system. The external system is an Oracle 12c database; it is not a geodatabase. I want to serve up the SDO_GEOMETRY table to a map ...
1
vote
0answers
83 views

Unexpected result from Oracle SDO_AGGR_UNION

I'm getting a result that looks incorrect from the Oracle Spatial SDO_AGGR_UNION function. I'm hoping someone has seen this and can confirm it's a bug or explain why this is expected behavior. ...
1
vote
2answers
263 views

Converting SDE.ST_GEOMETRY polyline to SDO_GEOMETRY with SQL: Why are there so many nulls?

I have a SDE.ST_GEOMETRY polyline FC in an Oracle 18c/10.7.1 geodatabase. I want to convert the SDE.ST_GEOMETRY shape column to SDO_GEOMETRY using SQL. Reason: So that I can do linear referencing ...
1
vote
1answer
82 views

How to find nearest neighbor in Oracle's ST_GEOMETRY?

I am trying to find nearest road segment to a point in Oracle. I can do this with SDO_GEOMETRY type i.e select /*+ LEADING(pois) INDEX(route ALL_ROUTES_SPTAIL_INDEX) */ route.* from DEVICE_STATUS ...
0
votes
1answer
74 views

Does SDO_WITHIN_DISTANCE also return points inside a polygon?

Using Oracle Spatial Database, just wondering if the SDO_WITHIN_DISTANCE returns points inside a polygon, not just within a certain number of metres from the boundary. I've already checked the ...
1
vote
0answers
49 views

SDO_GEOM.RELATE with EQUAL mask returns false for same WKT

I am trying to compare two geometries from two different tables and find all the different with the specified tolerance. I'm using WHERE sdo_geom.relate(gs.shape, 'mask=EQUAL',p.shape,0.002) = 'FALSE'...
1
vote
1answer
114 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
84 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,...
2
votes
4answers
2k 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. ...
1
vote
0answers
98 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: ...
5
votes
4answers
272 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
0answers
43 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
892 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 ...
1
vote
0answers
277 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
0answers
144 views

Updating location field (geometry) in Oracle Spatial using asp.net web application [closed]

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
2answers
1k views

Storing 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 ...
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 ...
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
391 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....
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
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
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
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 ...
2
votes
1answer
291 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
421 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 ...
1
vote
0answers
145 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 ...
6
votes
1answer
554 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
1k views

Too many features selected with the ArcMap Select by Polygon tool

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 ArcMap. So when I try to select all features included in ...
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 ...