Questions tagged [sdo-geometry]

SDO_GEOMETRY is a vector data type in Oracle Spatial

Filter by
Sorted by
Tagged with
1
vote
2answers
72 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 (...
0
votes
1answer
61 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 ...
0
votes
0answers
13 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 ...
1
vote
2answers
56 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....
2
votes
2answers
76 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) ...
0
votes
1answer
47 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 ( ...
2
votes
1answer
85 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, ...
3
votes
5answers
197 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 ...
0
votes
1answer
68 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 ...
1
vote
0answers
122 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
71 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
233 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
3answers
1k 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 ...
1
vote
1answer
227 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
318 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
228 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
188 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
96 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
3k 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
113 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
307 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
49 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
1k 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
317 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
156 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
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 ...
1
vote
2answers
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 ...
2
votes
0answers
457 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
297 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
429 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
3answers
4k 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 ...
1
vote
0answers
171 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
562 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
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 ...