Questions tagged [oracle-dbms]
Use for questions about Oracle DBMS that are not about its Spatial or Locator extensions
322
questions
1
vote
1answer
57 views
+50
Use SDE.ST_GEOMETRY functions in a custom function
I have a dummy query where I generate an SDE.ST_GEOMETRY point:
select
shape as srid_test
from
(
select
sde.st_geometry ('point (10.01 50.76)', 4326) as shape
from
...
0
votes
0answers
17 views
Select list of tables and feature classes that have subtypes?
I have tables and feature classes in an Oracle 12c geodatabase (10.7.1).
I would like to generate a list of tables and feature classes that have subtypes defined in them.
Is there a way to do this ...
1
vote
0answers
21 views
How to filter date values using OGR 2.4.0?
I am trying to replicate a working Oracle SQL query into ogr2ogr, but having issues with a date field where clause.
My query is:
select BLOCK_STATUS_DATE, GEOMETRY
from WHSE_FOREST_TENURE....
2
votes
0answers
76 views
Get midpoint of SDE.ST_GEOMETRY polylines?
I have a polyline SDE.ST_GEOMETRY feature class in an Oracle 12c geodatabase (10.7.1).
I want to create a view on the feature class that has X and Y columns that contain the coordinates of the ...
0
votes
0answers
20 views
No Oracle Button in QGIS Data Source Manager on Linux
I'm using QGIS 3.10 on a system with Fedora 30 Linux.
In the Data Source Manager is the button for Oracle-database-connections missing. An installation of the same QGIS-version on a Windows-Machine ...
1
vote
1answer
12 views
Extract subtype codes and descriptions in a view
I have an Oracle 10.7.1 geodatabase that has tables and feature classes with subtypes.
How can I extract the codes and descriptions from the subtypes in a view?
0
votes
1answer
12 views
Converted timezone does not display properly in ArcMap
(Oracle 12c geodatabase)
I have a view that converts a UTC timestamp to Eastern Time using the from_tz function:
create or replace view test_vw as (
select
cast(rownum as number(38,0)) as ...
1
vote
1answer
41 views
SDO_JOIN conversion to PostGIS
I make refactoring from Oracle to PostGIS and I found out that PostGIS doesn't support sdo_join.
How should I correct the statement below?
SELECT e.ID AS EDGE1_ID,
u.NODE_ID AS ...
6
votes
1answer
137 views
ArcPy UpdateCursor auto pausing after every 1000 records
I have an update cursor running that updates a field based on a lookup table (Python dictionary). The cursor completes fine, but seems to pause and hold after each 1000 records - I have a test in it ...
0
votes
0answers
39 views
WHERE clause that's stored in a table: Use it to filter a layer?
I have a workorder management system (WMS).
The WMS has functionality that allows users to save queries.
The queries are saved in a Oracle database table called QUERY (in a CLAUSE column).
An ...
0
votes
0answers
39 views
Selecting the SHAPE column in Toad
I've noticed that SQL clients select the SHAPE column from SDE.ST_GEOMETRY in different ways:
select shape from roads where
Toad: SDE.ST_GEOMETRY(1,1,666666.0,4444444.5,666666.0,4444444.5,NULL,NULL,...
0
votes
0answers
28 views
ST_TRANSFORM SDE Oracle does not convert the geometry
I try to convert a geometry from 31370 to 3857. But it does not work. The coordinates stay in 31370.
DB: Oracle 11
ArcSDE: 10.4.1
The code:
select
sde.st_srid(shape)
,sde.st_x(shape) as ...
0
votes
0answers
31 views
Select domain's last update date
I have tables in an Oracle 18c GDB that I integrate to a work order management system.
I create views on the tables to prepare & translate the data for the integration. For example, I translate ...
1
vote
2answers
29 views
Prevent row deletion in versioned tables using database privileges
I have versioned tables in an Oracle geodatabase (versioned with the option to move edits to base).
I would like to prevent users from deleting rows from the tables when using ArcGIS Desktop.
(With ...
0
votes
0answers
32 views
Connecting QGIS to Oracle?
I am using QGIS 3.8 MacOS.
I know that prior releases of QGIS (2.x releases) did not include drivers to connect to Oracle databases, and one would need to compile QGIS themselves with the proper ...
2
votes
0answers
41 views
GeoServer and Oracle connection
I installed GeoServer on a server, put the Oracle extension in the same version. When I click store and then Oracle NG, I put the data of my connection and when I save, presents the error below:
...
0
votes
0answers
40 views
Is there a way to deploy Oracle Instant Client with an ArcGIS Add-In to access geodatabase objects?
I would like to open a feature class stored in an Oracle Enterprise geodatabase from an ArcGIS 10.4.1 Add-In without installing an Oracle Client on the end-user machine.
Currently, I can use the ...
1
vote
0answers
28 views
Updating spatial table in Oracle database with SQL query in PyQGIS?
I am trying to use the Python Console within QGIS 3.4 to update a spatial table in an Oracle database. The goal is to update all values in the field DTM_ELEV in the Oracle table with values from a ...
2
votes
1answer
49 views
Unable to establish Oracle enterprise connection using ArcMap
When I run the following command
sqlplus user/mysecretpass@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=10.1.250.81)(Port=1521))(CONNECT_DATA=(SID=gisdb)))
I am able to establish connection and result ...
0
votes
1answer
51 views
Convert Oracle data to polygons using R
I have a polygon file, taken from an Oracle database, that looks something like this:
ID FMC_AREA_TYPE_NAME DESCRIPTION
1 162 HARBOUR Esbjerg
2 164 HARBOUR Thyborøn
...
0
votes
0answers
91 views
Why does QGIS try to insert a known CRS into sdo_coord_ref_system?
When using "Import vector layer" in QGIS DB Manager (QGIS 3.6.0) to load a layer to an Oracle database (12.2.0.1.0) I get the following error:
Error 2
Creation of data source "XXXXX"."MY_TABLE" ...
0
votes
1answer
431 views
Connect ArcGIS 10.6 to Oracle 12c Enterprise Edition
I want to connect ArcGIS 10.6 to an Oracle 12c Enterprise Edition. However, I found different informations on the Esri websites on how to do so.
I followed this website (http://desktop.arcgis.com/...
1
vote
0answers
63 views
Insert new features into Oracle DB using PyQGIS
I need to insert new objects into a specific layer that stored in Oracle database.
Firstly I set a new QgsFeature(), then set geometry and attributes. Finally perform addFeatures() action.
nodes_pnt =...
0
votes
1answer
345 views
Database support in GE Smallworld?
What database engine can be used for GE Smallworld?
I have poor information but I read about Smallword proprietary VMDS.
Is it possible to use Oracle or SQL Server?
0
votes
0answers
23 views
What is the underlying algorithm of sdo_sam.spatial_clusters in Oracle?
Oracle has a "sdo_sam.spatial_clusters" function for spatial clustering. What is its underlying algorithm?
Unfortunately the Oracle docs do not mention the algorithm or describe in which way the ...
0
votes
1answer
120 views
Using Google Encoded Polyline Algorithm Format with Oracle Database
Google's Encoded Polyline Algorithm Format is implemented in several GI tools. PostGIS e.g. has ST_AsEncodedPolyline and ST_LineFromEncodedPolyline functions.
In contrast, Oracle Database has no ...
2
votes
1answer
45 views
How to hide certain views from ArcCatalog?
I have users that connect to an enterprise geodatabase via OS authentication. They use a couple of methods:
An .SDE connection in ArcMap
A ODBC connection for MS Office
The users need to be able to ...
1
vote
1answer
183 views
Execute Oracle stored procedure from ArcSDESQLExecute
I'm attempting to execute an Oracle 12c stored procedure using ArcSDESQLExecute:
import arcpy
egdb_conn = arcpy.ArcSDESQLExecute(r"Database Connections\con1.sde")
sql = '''execute update_sle (...
0
votes
1answer
75 views
Insert 1 row that has tens of thousands of geometry data on Oracle
I have a query to insert 6 geometry data like this
DECLARE v_geom sdo_geometry;
BEGIN
v_geom := MDSYS.SDO_GEOMETRY(2003,4326,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(107....
2
votes
0answers
74 views
QGIS 3 imports DATE type colum in Oracle Database as QDate, losing hh:mm:ss
I am at the moment working on a lift for an QGIS 2 plugin to work with QGIS 3.
The plugin specifies a QgsDataSourceUri and uses it in an QgsVectorLayer.
In the specific table, laying in an Oracle ...
1
vote
0answers
178 views
How to Create 'Update Triggers' to Track Field Values Changes When Data is Versioned?
How can I create a trigger to capture when a field is changed from one value to another if my data is versioned? I am not able to run an UPDATE trigger and grab ':new' and ':old' values because with ...
0
votes
1answer
67 views
GeoServer 2.13.3 unable to delete from Oracle 11gR2 over WFS-T
I'm attempting to upgrade GeoServer 2.9.2 to 2.13.3. GeoServer uses the Oracle Data Store plugin (updated to gt-jdbc-oracle-19.3 as part of the upgrade). Oracle is 11gR2.
One of the applications ...
0
votes
2answers
75 views
Clarification on Oracle sdo_gtype
I need some clarification on oracle sdo_gtype 4402. I understand that sdo_gtype is codded as DLTT. D: Dimension L : linear reference T T: TT identifies the geometry type. It's clear to me that first 4 ...
0
votes
0answers
105 views
Query Feature Class from Oracle table with no geometry column
Using ArcMap 10.4.1 I am trying to create a query layer from an Oracle table (Oracle info at bottom). The table has no geometry column, but has x and y coordinates as double and I am trying to create ...
1
vote
0answers
75 views
Versioning with Oracle Workspace Manager in QGIS?
I'm working with a workspace enabled oracle database. Through the database connection properties in QGIS meanwhile it is possible to set the workspace or version. So I can edit my spatial data in a ...
0
votes
2answers
308 views
Oracle DB tables extract with python
I have an Oracle database that I have been extracting the certain geometry tables into QGIS and then creating shapefile files for those tables.
Does anyone have any tips or tricks to automatic the ...
0
votes
1answer
82 views
Update DB Geometry using GDAL
We are working with a geometry DB (Oracle) and use GDAL to download some data and apply changes to it.
Supposing that we were applying the following workflow:
DB -> GeoJSON -> modified_GeoJSON
Is ...
0
votes
1answer
51 views
Detecting failure of Data Access Insert Cursor?
I have data that I have now determined is failing because the underlying Oracle table has a unique constraint that fails. When a duplicate row is inserted there are no exceptions thrown - no way ...
2
votes
0answers
55 views
Select events that represent the most recent work on roads
I have a question on Stack Overflow where I ask about Selecting events that represent the most recent work on roads. So far, I have been provided an answer that seems to work, although it is quite ...
1
vote
0answers
55 views
Editing Spatial View in ArcMap?
Can spatial views be edited via ArcMap and, if it is possible, then how do I do it?
I do have my Enterprise Geodatabase on Oracle.
0
votes
1answer
432 views
GeoServer and Oracle 12c
In GeoServer (2.13.1) I'm trying to connect to Oracle DB 11g and 12c and connecting successfully both. But in 12c I couldn't see my tables and can't add layer.
There isn't any error message or ...
0
votes
2answers
198 views
Oracle - find N neighbors (points) of a point within a radio
I have this table, there it goes a sample output to show that it is a point
select SDO_UTIL.TO_WKTGEOMETRY(geo)
from places
where id=1
_______________________________________________________
POINT ...
2
votes
0answers
33 views
Multiple Layers into Indiviual Shapefiles QGIS
I have extracted about 20 different tables out of an Oracle DB into a project now I want to save each one as a shapefile.
I know how to save an individual layer into a shapefile but is there a way to ...
0
votes
1answer
480 views
What to do about QSqlDatabase: QOCI driver not loaded [closed]
QGIS - 3.0.1
I am trying to connect to the Oracle database. I am not an expert in QGIS, pyqgis at all. I took help of following code to connect to Oracle database. Connecting directly to an Oracle ...
0
votes
1answer
293 views
Oracle equivalent to postgis EPSG 4326 “geometry” type
We have polygons stored in Oracle SRID 8307 (geodetic datatype), but need to perform various operations on this layer in a 2d cartesian/non-geodetic system based on the geographic coordinates.
I.e. ...
1
vote
0answers
16 views
What is Oracle/ArcSDE doing to my simple WKT Conversions?
I have no way to explain the output of the following:
DECLARE
splitGeom sde.ST_Geometry;
stas CLOB;
BEGIN
SELECT sde.st_geomfromtext( 'POLYGON ((468221.1280508253 ...
0
votes
2answers
385 views
query to check srid of features in feature class? [duplicate]
What query should I use to check the SRID of the features in a feature class? The storage type of the feature class in st_geometry?
I tried the following query but no luck :
select top 1 [...
0
votes
1answer
104 views
Using deegree with Oracle DBMS without installing Oracle Spatial?
I'd like to use deegree for its WFS capacities connected to an Oracle 12 database where some geo information are available: stations location (latitude, longitude, altitude) + realtime information (...
1
vote
2answers
158 views
Update Oracle DB table from Postgres/PostGIS DB query
I have an Oracle DB where Geolocation (Longitude, Latitude) data is storing. I want to update another column which is the neighborhood of that geolocation. Currently, I do not have oracle spatial ...
3
votes
3answers
404 views
Dynamically update points with xy coordinates in table
I have an Oracle database table with columns for 'X' and 'Y' coordinates. Now I want to display these points in ArcMap. I can use the 'Display XY data' tool for that.
My table in the database with XY ...
