Questions tagged [sdo-geometry]
SDO_GEOMETRY is a vector data type in Oracle Spatial
40
questions
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 ...
