Questions tagged [oracle-dbms]

Use for questions about Oracle DBMS that are not about its Spatial or Locator extensions

Filter by
Sorted by
Tagged with
2
votes
1answer
59 views

Calculate irregular polygon center-point that falls within the polygon boundary

I have an SDE.ST_GEOMETRY polygon FC in an Oracle 18c/10.7.1 geodatabase. I can calculate the X and Y of the polygon centroids using the SDE.ST_GEOMETRY ST_Centroid function: sde.st_x(sde....
0
votes
2answers
51 views

Creating a view in ArcCatalog - ORA-01722 [closed]

I'm creating a view in ArcCatalog 10.6 on an Oracle DB. Never created a view before but with some Googling, I've managed the SQL below. The view works but only partially. In ArcCatalog, preview shows ...
1
vote
1answer
244 views

How to find closest point on a line from a point in Oracle Spatial?

I want to find the nearest point on a line from a point in Oracle Spatial. I know how to do in SQL Server and PostgreSQL but could not find anything about Oracle. I have used MDSYS.sdo_nn to find the ...
1
vote
2answers
209 views

Converting SDE.ST_GEOMETRY polyline to SDO_GEOMETRY with SQL: Why are there so many nulls?

I have a SDE.ST_GEOMETRY polyline FC in an Oracle 18c/10.7.1 geodatabase. I want to convert the SDE.ST_GEOMETRY shape column to SDO_GEOMETRY using SQL. Reason: So that I can do linear referencing ...
0
votes
0answers
32 views

Getting SQL explain-plan for ArcGIS Map service

My organization has an ArcGIS map service that contains registered views from an Oracle 18c/10.7.1 geodatabse. I'm having some performance issues with the layers/views in the map service. I want to ...
1
vote
1answer
101 views

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
37 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
1answer
81 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
1answer
222 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
58 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
19 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
15 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
45 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
145 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
51 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
1answer
84 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 Toad: SDE.ST_GEOMETRY(1,1,666666.0,4444444.5,666666.0,4444444.5,NULL,NULL,NULL,...
0
votes
0answers
96 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
40 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 translate the data. For example, I translate codes to domain descriptions. I ...
1
vote
2answers
71 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 ...
1
vote
0answers
77 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
83 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: ...
1
vote
0answers
41 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
60 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
78 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
1answer
754 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
83 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 =...
1
vote
2answers
509 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
1answer
146 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
50 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 ...
2
votes
1answer
291 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
102 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
1answer
105 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
247 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
77 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
108 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
126 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 ...
2
votes
0answers
93 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
414 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
100 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 ...
1
vote
1answer
88 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
58 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
641 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
348 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
36 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
690 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
363 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
18 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
498 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
115 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
2 3 4 5
7