Skip to main content

Questions tagged [sdo-geometry]

SDO_GEOMETRY is a vector data type in Oracle Spatial

Filter by
Sorted by
Tagged with
0 votes
0 answers
33 views

Edit SDO_GEOMETRY in ArcGIS Pro

I am new to Esri products. I am trying to edit data (SDO_GEOMETRY) in Oracle DB in ArcGIS Pro but without success. Install ArcGIS Pro 3.3 Standard + connect to Oracle DB (.sde file) - db user with ...
GeoLady's user avatar
  • 61
0 votes
0 answers
214 views

Insert SDO_GEOMETRY in cx_oracle with SDO POINT

I am trying to create a SDO_Geometry in Python so I can insert it into Oracle. I want it to be lat long so I just need a sdo_point_type I have gotten as far as this typeObj = prdconn.gettype("...
Janet's user avatar
  • 1
0 votes
1 answer
268 views

Oracle Spatial vs ArcGIS: Wrong results with spatial join

I have some troubles with a spatial join in Oracle db (version 12c): I have a table with points with SHAPE in SDO_GEOMETRY format. Now I want to select these points if they are in a polygon via ...
user28840's user avatar
0 votes
0 answers
480 views

ora2pg SDO_Geometry to st_geometry

I am trying to migrate my database (Oracle) to postgres using ora2pg (v.23.1). Unfortunately the script converts our SDO_Geometry datatype into shape geometry(GEOMETRY,32632) instead of shape ...
Riccardo's user avatar
  • 2,668
0 votes
1 answer
260 views

ST_GEOMETRY feature class: Add a hidden SDO_GEOMETRY column

I have an SDE.ST_GEOMETRY FC in an Oracle 18c EGDB. I want to use Oracle Spatial functions on the data (calculate polyline midpoint, M-values, dynamic segmentation, etc.). Ideally, I'd convert the ...
User1974's user avatar
  • 1,172
0 votes
4 answers
1k views

Convert M-enabled SDE.ST_GEOMETRY to SDO_GEOMETRY using SQL

I have an M-enabled SDE.ST_GEOMETRY polyline FC in an Oracle 18c EGDB. select sde.st_astext(shape) as st_to_wkt from test_st_geom MULTILINESTRING M (( 0.0 5.0 -100000.0, 10.0 10.0 -100000.0, 30.0 0.0 -...
User1974's user avatar
  • 1,172
1 vote
1 answer
463 views

Determine if a SDO_GEOMETRY line has true curves

Oracle 18c I have an SDO_GEOMETRY table that I created via ArcGIS Desktop 10.7.1. The table has a line that appears to have a true curve in it: However, in a related question, @Vince pointed out that ...
User1974's user avatar
  • 1,172
0 votes
2 answers
325 views

Does Oracle's SDO_Geometry spatial type support arcs?

Oracle 18c GDB; ArcGIS 10.7.1 With ESRI native spatial types, such as SDE.ST_GEOMETRY, we can store "CAD" arcs in the geometry of polyline and polygon features. Question: Does Oracle's ...
User1974's user avatar
  • 1,172
1 vote
1 answer
425 views

Difference between SDO_NN and BallTree Sklearn for Nearest Neighbors

I am trying to find nearest n/w nodes from multiple buildings in an area, I have 2 geodataframes/Tables in Oracle DB, buildings have point geometries with ID's and Nodes have point geometries with ...
m2rik's user avatar
  • 111
1 vote
3 answers
368 views

ST_PointN equivalent in SDO_GEOMETRY?

In SDE.ST_GEOMETRY, we have a function called ST_PointN: ST_PointN takes an ST_LineString and an integer index and returns a point that is the nth vertex in the ST_LineString's path. sde.st_pointn (...
User1974's user avatar
  • 1,172
0 votes
1 answer
517 views

Error while importing shapefile into Oracle

I am trying to import shapefile into Oracle db using GeoTools, but when I am trying to create a new schema, it will giving me following error. Aug 01, 2021 8:24:13 PM org.geotools.jdbc.JDBCDataStore ...
gizmogaurav's user avatar
0 votes
0 answers
57 views

Editing featureclass in Oracle SDO_GEOMETRY

I'm building an empty featureclass in Oracle and want to enable editing in arcmap/py with having the featureclass user SDO_GEOMETRY for the shape column. However, I'm running into difficulties on how ...
MoxGoat's user avatar
  • 13
1 vote
2 answers
137 views

Update sister table with vertices as rows (when SHAPE is updated)

I have an Oracle 18c table that has an SDO_GEOEMTRY column. create table a_test_sdo_geom (id number, shape mdsys.sdo_geometry); insert into a_test_sdo_geom (id, shape) values(1, sdo_util....
User1974's user avatar
  • 1,172
2 votes
1 answer
597 views

Select vertices, including multi-part number

I have an Oracle 18c table with an SDO_GEOEMTRY column: create table a_test_sdo_geom (shape mdsys.sdo_geometry); The table has a row that is a multi-part feature. insert into a_test_sdo_geom (shape) ...
User1974's user avatar
  • 1,172
0 votes
1 answer
377 views

I have difference between Oracle sdo_geom.SDO_Distance and Google Maps

SELECT sdo_geom.SDO_Distance ( SDO_Geometry (2001, 4326, SDO_Point_Type ( -34.59593955425856, -58.43453386049867,null), null, null), -- Parque Centenario SDO_Geometry (2001, 4326, SDO_Point_Type ( ...
Jorge Tabaj's user avatar
2 votes
1 answer
376 views

Function-based spatial index: Use sdo_geometry() constructor instead of custom function?

I have an Oracle 18c table that has XY columns, but not a SHAPE column. I've created a query on the table that dynamically generates an sdo_geometry SHAPE column. sdo_geometry(2001, 26917, ...
User1974's user avatar
  • 1,172
3 votes
5 answers
500 views

Materialized view with FAST refresh on remote table: How to include a SHAPE column?

I want to create an Oracle materialized view with the fast refresh option on a remote table (in an enterprise GDB). I can do this successfully without a SHAPE column: create materialized view log on ...
User1974's user avatar
  • 1,172
0 votes
1 answer
150 views

SDO_GEOM materialized view: Why is static field slower than dynamic field?

EGDB: Oracle 18c; ArcGIS 10.7.1 External system: Oracle 12c I have a materialized view in an EGDB that syncs data from an external system (on a schedule via a dblink). The materialized view has an ...
User1974's user avatar
  • 1,172
1 vote
1 answer
1k 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 ...
Doc's user avatar
  • 131
1 vote
0 answers
93 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 ...
User1974's user avatar
  • 1,172
2 votes
0 answers
614 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. ...
conservation_data_mgr's user avatar
1 vote
3 answers
3k views

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

I have a SDE.ST_GEOMETRY column in an Oracle 18c/10.7.1 geodatabase. I want to convert the SDE.ST_GEOMETRY shape column to SDO_GEOMETRY using SQL. Steps: Convert the SDE.ST_GEOMETRY shape column to ...
User1974's user avatar
  • 1,172
1 vote
1 answer
537 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 ...
Ayaz49's user avatar
  • 428
0 votes
1 answer
1k 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 ...
AER's user avatar
  • 241
1 vote
0 answers
689 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'...
Catherine's user avatar
1 vote
1 answer
505 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, ...
js1983's user avatar
  • 321
1 vote
1 answer
116 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,...
Schmjuzi's user avatar
3 votes
4 answers
6k 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. ...
vahitdurmus's user avatar
1 vote
0 answers
143 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: ...
jpmc26's user avatar
  • 1,709
5 votes
4 answers
355 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....
jlSta's user avatar
  • 1,096
0 votes
0 answers
61 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 ...
disflux's user avatar
  • 141
1 vote
2 answers
2k 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 ...
User1974's user avatar
  • 1,172
1 vote
0 answers
381 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. ...
Marisol Prado's user avatar
1 vote
0 answers
198 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 ...
aliadly's user avatar
  • 31
1 vote
2 answers
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 ...
aliadly's user avatar
  • 31
3 votes
1 answer
2k 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 ...
Alicia Rijo's user avatar
1 vote
2 answers
2k 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 ...
Ian Horn's user avatar
  • 160
3 votes
0 answers
619 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....
user68895's user avatar
1 vote
2 answers
5k 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 ...
Mike's user avatar
  • 2,281
0 votes
1 answer
3k 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 ...
bertday's user avatar
  • 1,317
1 vote
1 answer
2k 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,-...
skedge's user avatar
  • 610
1 vote
1 answer
2k 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 ...
Web-GIS entrepreneur's user avatar
2 votes
1 answer
445 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 ...
Vishwa's user avatar
  • 121
1 vote
0 answers
464 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 ...
JsP's user avatar
  • 321
6 votes
3 answers
5k views

Create an SDO_GEOMETRY view from a non-spatial table?

Let's say I have an Oracle database table with latitudes and longitudes. I don't have access to modify the schema of this table, or even create tables. However, I can create views and indexes on those ...
Erik L's user avatar
  • 873
1 vote
0 answers
278 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 ...
SNT's user avatar
  • 3,389
6 votes
1 answer
576 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 ...
Dom's user avatar
  • 894
6 votes
1 answer
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 ...
Jean-Francois Legendre's user avatar
0 votes
2 answers
2k 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 ...
ABX's user avatar
  • 737