Questions tagged [sdo-geometry]
SDO_GEOMETRY is a vector data type in Oracle Spatial
22
questions
1
vote
1answer
39 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
44 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
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.
...
1
vote
0answers
68 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
256 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
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
599 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
231 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
2answers
941 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 ...
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
977 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
310 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
995 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
276 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
407 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 ...
2
votes
0answers
123 views
Check for overlaps in polygons
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
536 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
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
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 ...
