Questions tagged [oracle-spatial]
Use for questions about the Spatial or Locator extensions to the Oracle DBMS
448 questions
2
votes
0
answers
38
views
How to test QGS provider connection?
I'm trying to build functionality for connecting to an Oracle database in a plugin. I ask the user to provide credentials, and then I check if they are correct. If the credentials are invalid, I want ...
- 398
1
vote
0
answers
63
views
Adding new authentication configuration and connection to Oracle database with encrypted credentials using PyQGIS
I want to create a new authentication configuration and a new connection to the Oracle database programmatically. I successfully create both of them; however, in the end, the username and password are ...
- 398
0
votes
0
answers
69
views
QGIS crashes while reading point geometry from Oracle
I would like to read point geometry stored in an Oracle database as a point with a rotation value.
I create a table and add a point like this:
CREATE TABLE points_with_rotation (
id integer,
...
- 398
0
votes
0
answers
28
views
Oracle SDO_UTIL.getvertices not returning all decimals for Y but returning full decimals for X
We have a PROD and DEV Oracle database for one of our clients and the return values for this query strangely do not match. Trying figure out why this problem happens in prod.
SELECT t1.x AS longitude,
...
0
votes
0
answers
44
views
Using SDO_LRS.DYNAMIC_SEGMENT doesn't return an exact line of LRS
In a package in Oracle 19, I'm using:
SDO_LRS.DYNAMIC_SEGMENT (GEOM, START, END, 0.01);
to return a geometry object (SDO_GEOMETRY) from an LRS. The start of the LRS looks like:
-8623852.4702 4852017....
- 1
0
votes
0
answers
79
views
Custom locator not working when published to server
I have a custom locator that I built with the Create Locator tool (type: Street Address) in ArcGIS Pro that works perfectly in Pro using the Locate tool — it returns accurate candidates based on input ...
- 345
1
vote
1
answer
80
views
Creating and showing vector layer for Oracle GeometryCollection with PyQGIS
I have a table in my Oracle database with multiple different geometry types (ie, points and lines). Now, I want to show the data in QGIS.
I can create a new vector layer, however, its geometry type is ...
- 1,751
0
votes
0
answers
71
views
GeoJSON file creation from Oracle Spatial Code
Can we create GeoJSON file from below oracle spatial code:
CREATE TABLE buildings_3d (
id NUMBER PRIMARY KEY,
name VARCHAR2(100),
geom MDSYS.SDO_GEOMETRY
);
INSERT INTO user_sdo_geom_metadata (...
- 85
2
votes
0
answers
55
views
Sharing styles throught oracle
I'm connecting to Oracle database with QGIS.
Is there a way to load default styles for layer not from user's schema ?
Even though user can access QGIS.LAYER_STYLES table (schema name - QGIS), QGIS ...
- 21
0
votes
1
answer
41
views
Insert a Point whose longitude is over date line at Oracle
I am using Oracle Spatial
table structure
CREATE TABLE "MINTAKA"."GRID_POINT_BOUNDARY"
(
"BOUNDARY_ID" NUMBER(19,0),
"BOUNDARY_DEF" MDSYS....
- 1
0
votes
0
answers
264
views
Oracle Spatial operator SDO_ANYINTERACT does not work well
DB:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0
I have a table called GRID_POINT_BOUNDARY and one column I am using SDO_GEOMETRY Oracle Spatial type. ...
- 1
1
vote
1
answer
121
views
SDO_UTIL.GETNUMELEM in Oracle Spatial doesn't seem right against MultiPoint types. Is this a defect?
I would imagine that running GETNUMELEM against a MultiPoint would return the number of points in the MultiPoint, but it seems to always return 1. I'm comparing it with ST_NumGeometries in other ...
- 77
1
vote
2
answers
83
views
Does Oracle Spatial have equivalents of ST_IsClosed ST_IsRing ST_IsSimple
I'm trying to find the equivalent in Oracle Spatial of the above OGC functions. I know there's not a direct function I can call, does anyone know of a workaround to get these functions by combining ...
- 77
0
votes
0
answers
54
views
Query Oracle for new data based on properties of visible markers?
I'm very new to R/Shiny/Leaflet.
I have a barebones working example where I can display points on map based on their lat/long in a table I pull from Oracle:
siteData <- conn %>% tbl(in_schema(&...
0
votes
1
answer
272
views
DISJOINT and TOUCH between Polygon and LineString not working as expected in Oracle Spatial
I have the following 4 geometries in an Oracle Spatial table:
A) POLYGON ((-100 40, -100 44, -96 44, -96 40, -100 40))
B) LINESTRING (-99 37, -99 40)
C) POINT (-100 41)
D) POLYGON ((-96 41.5, -95 42, -...
- 77