We changed our privacy policy. Read more.

Questions tagged [oracle-spatial]

Use for questions about the Spatial or Locator extensions to the Oracle DBMS

Filter by
Sorted by
Tagged with
1
vote
2answers
55 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
30 views

QGIS Oracle connection succeeded but never ends?

I created a new connection with the Oracle database, when I Press 'test connection', I have a msg that the connection succeeded, but after that, when I click OK, the connection process never ends, it ...
1
vote
1answer
39 views

Exporting Oracle table with multiple geometry columns to gpkg by using ogr2ogr

I am using ogr2ogr to export a table in Oracle to GPKG. The table in Oracle has two columns (GEOMETRY_2, GEOMETRY_20) with geometry info. I am using the following ogr2ogr command to export the table ...
1
vote
0answers
39 views

Unable to logon when connecting to Oracle database with QGIS

I started using QGIS recently and wanted to connect it with our database set on a standalone server. the database installed is (screenshot below). Windows ODBC and lister are well configured, the ...
0
votes
0answers
43 views

Slow performance during Oracle import using GeoTools

This is sample program which reading and shapefile and import into Oracle database. it also trying to rename the the_geom column to GEOMETRY column . But this is taking time to insert into Oracle. It ...
0
votes
1answer
35 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
1answer
24 views

Error while importing shapefile into Oracle db using geotools

I am trying to import shape file into Oracle database but I am running TNS listener error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor ...
1
vote
0answers
40 views

Connect to Oracle SQL DB using JDBC connection

My IP address changes frequently and hence I use ssh tunnel via bastion host to connect to Oracle SQL DB. I used JDBC to connect to the Oracle SQL and it works successfully. However, I want to connect ...
3
votes
1answer
153 views

Creating an Ubuntu based Docker image with GDAL, including Oracle Spatial OCI driver

Problem For several days I've been trying to build an Ubuntu based GDAL distribution including the OCI driver (Oracle Spatial). The goal is to create a GDAL image including PostgreSQL and Oracle ...
0
votes
1answer
97 views

Using Oracle Views in GeoServer

I'm trying to pin down the requirements or the optimal setup for using an Oracle View in GeoServer 2.16.2. From what I have read in various forums is that for an Oracle View to work right in ...
0
votes
0answers
23 views

Unable to open ArcSDE table

We have an ArcSDE table MISCELLANEOUSLINEARLANDFEATURE. In ArcCatalog it showing as MISCELLANEOUSLINEARLANDFEATURE_ in Oracle table_registry and dba_objects it showing as ...
1
vote
0answers
37 views

QGIS 3.10.12 An error occurred when executing the query, please check the expression syntax

When WMS request http://XXXX?SERVICE=WMS&VERSION=1.1.0&REQUEST=GetMap&FORMAT=image/png&TRANSPARENT=true&LAYERS=l_aj_plt,l_aj_lin&TILED=true&FILTER=l_aj_plt,l_aj_lin: ( ( &...
0
votes
1answer
27 views

Oracle 12c Spatial calculating count of points from fixed point

I need to answer the following question using Oracle Spatial in Oracle 12c. How many people live within x kilometer radius from a hospital? Does anyone know how to do this? Setup is: 2 x tables. table....
0
votes
0answers
19 views

AttributeError: 'NoneType' Connecting GeoRaster

When I open the option to connect georaster and go again to create the connection, the error below appears. Do you know what it can be? Show the mesage: AttributeError: 'NoneType' object has no ...
0
votes
0answers
21 views

I can't open Oracle raster layer in QGIS

I can't open Oracle's raster layer in QGIS. When I load the layer it looks like this: This layer works perfectly in Geomedia (Sisgraph), which is the software we used but we are migrating to QGIS. ...
2
votes
1answer
47 views

View has no records when viewed in ArcCatalog

I have created a database view in an Oracle-backed Enterprise Geodatabase. I can see data in both of them when I view them using SQL Developer. However, when I look at the view in ArcCatalog (version ...
0
votes
0answers
16 views

Import Esri linear referencing system into Oracle Spatial

I am wondering if it's possible to import a linear referencing system (routes with measures) into Oracle Spatial?
4
votes
3answers
118 views

QGIS 3 SQL dialect - is UNION ALL allowed?

I have a very large SQL query consisting of two similar but different blocks, connected by a UNION ALL: select OBJECTID, PROJECT_NAME, BIOGEOCLIMATIC_LBL, SITE_SERIES_MAP_CDE_LBL_CPNT_1, GEOMETRY as ...
1
vote
0answers
37 views

Oracle Spatial - SDO_GEOM.RELATE Inconsistencies

I'm using Oracle 12.2 (12c) and encountering some inconsistent results with the SDO_GEOM.RELATE function. When I run the following code to check if two points are equal on the projected Irish grid, ...
1
vote
2answers
47 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
63 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
0answers
31 views

FME Oracle SDE Invalid column definition

I am using FME on daily basis working with sde feature classes. Sometime I am receiving data with more then hundred columns and when working I receive the following error. The error number from Arc ...
0
votes
1answer
78 views

Unknow error connecting from ArcCatalog to Oracle

Currently I am running ArcMap 10.6.1 and try to connect with an Oracle 19c database. Unfortunately I only see "Unknown Error": Underlying DBMS error[Unknown errorNo extended error.] Yet I ...
0
votes
1answer
64 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
19 views

Updating and merging geometries using a 3rd table as the connector

I'm looking for some help with the following. I have 3 tables in my Oracle Database. Table A: IDnumber Geometry 001 Geom1 002 Geom2 003 Geom3 Table B: IDnumber Fieldnumber (...
0
votes
0answers
30 views

Updating geometries using another table whose records need to merge in SQLDeveloper

I'm looking for some help with the following. I have 3 tables in my Oracle Database. Table A: IDnumber Geometry 001 Geom1 002 Geom2 003 Geom3 Table B: IDnumber Fieldnumber (...
-1
votes
1answer
14 views

Incoherent results on Oracle Spatial Query with SDO_CONTAINS

If I run the following query: select zona , fid , count(*) from geo_bcn_zones z join geo_bcn_illes i on SDO_CONTAINS(z.geometria, i.geometria) = 'TRUE' where zona='z01'and fid = 53 group by zona, ...
1
vote
2answers
505 views

Fix/Repair invalid Geometry

I'm loading a shapefile in an app through a frontend with OpenLayers and trying to save the geometry to an Oracle Database with Hibernate Spatial. The shapefiles that have valid geometry (validated ...
10
votes
2answers
379 views

Rule-based symbology based on current selection in QGIS

I have two oracle layer (point(p1) and polygon(pl1)). I want to build a rule-based symbology which is based on current selection on two cases: Case 1- When I select a point from table p1, I want that ...
0
votes
0answers
21 views

Creating average geometry for lines whose buffers intersect

I am learning SDO. I have started new project with SDO geometry. Here is some problem we have faced. We want a script where the x and y geometries in the intersecting buffers will be updated with the ...
0
votes
0answers
46 views

How to dissolve polygons with common boundary (adjacent) in an Oracle layer through Oracle SQL select command?

I already have an Oracle layer with polygons which I want to dissolve it through a SELECT SQL command and not use any GIS software, just the Oracle SDO commands. I can do it normally through GIS tools ...
2
votes
0answers
42 views

How can two Oracle Spatial shapes be disjointed and interacted at the same time?

This Oracle Spatial query indicates a polygon and a line have interaction but also that they are disjointed. How can that be? --disjointed but interact??? SELECT lines.pavement_key, poly....
0
votes
1answer
129 views

Get ArcGIS Pro to show which feature is causing copy/paste to fail

I have an Enterprise geodatabase feature class in a feature dataset that I need to copy over to a gdb. I've tried right click to copy and paste, the copy tool in ArcGIS Pro, copy management in ArcPy. ...
1
vote
1answer
81 views

SELECT * will not work with table containing geodata

The following will not run... I get ORA-00932 error every time.. $sql = 'SELECT * FROM app.table_1'; however, this will work (specifying a column name, i.e. objectid): $sql = 'SELECT objectid FROM ...
3
votes
0answers
80 views

DB Manager - Oracle DB - Importing vector layer fails prompting "ORA-01741: illegal zero-length identifier" error

When trying to import a vector layer, to an existing Oracle DB connection, using DB Manager core plugin, the operation fails. An error message prompts with "ORA-01741: illegal zero-length ...
1
vote
1answer
47 views

How do I determine which polygon feature with an SDO_geometry doesn't partially overlap a polyline feature with an SDO_geometry?

I have 2 datasets in the Oracle spatial format, built from Smallworld data; One with polygon features One with polyline features. I'm looking to determine which polygon features do not contain (part ...
1
vote
1answer
57 views

Data (type double) mismatch between ArcMap and ArcGIS Server 10.6.1

When I identify a feature which is having a double value as 0.00001 in ArcMap, it is showing what is expected. I have the layer published as a map service using ArcGIS Server. If I search for the same ...
0
votes
1answer
7 views

Oracle Maps filter.In allows me to only remove items from the map

Working from a basic example generated by Oracle MapBuilder. I have a base map and a FOI layer. At the start no filter is applied and the map shows all object types (column OBJECTTYPE) available in ...
0
votes
1answer
33 views

GeoServer + Oracle multi-session

I have: GeoServer Oracle Spatial WMS To communicate with Oracle, GeoServer uses the schema, username and password. Is it possible to use multi-user to communicate with Oracle locator table or switch ...
3
votes
1answer
203 views

Using ogr2ogr to export an Oracle Spatial table with measured geometries (3302) to a shapefile ignores the measure values

I have an Oracle spatial table with measured geometries (SDO_GTYPE=3302) which I want to convert to a shapefile. The command I am using is this: ogr2ogr -f "ESRI Shapefile" "tshapeARCM....
1
vote
2answers
78 views

How to deal with tables that contains a unique constraint

I am not quite sure how to title this post, so please bear with me as I explain what is going on... I am using ArcGIS 10.7.1 with OracleDB as our database back-end. I have a table with approximately ...
1
vote
1answer
128 views

Oracle layer not editable in QGIS as non-owner user

When I open a QGIS (3.10) connection to an Oracle (12c) database using a logon which owns a spatial table, and add the table as a layer, the layer can be edited as normal. If I open the Oracle ...
0
votes
0answers
82 views

Reader character encoding problems in Oracle layers with where parameters in FME Desktop

I am using FME Desktop 2020 and trying to read an Oracle layer with -where- condition but i have problem because it failed with reading of character Ë or Ç. I get this error: ORA-01756: quoted ...
0
votes
0answers
206 views

ArcSDE - AutoIncrementing Object ID in table stored in ORACLE when doing INSERT or UPDATE or DELETE using FME SDE Writer

I have data in an Oracle table (11 million records) and would like to insert 2000 records approximately using the FME ArcSDE Writer to maintain ObjectID put on the Oracle table by ArcSDE via ArcGIS. ...
0
votes
1answer
136 views

Problem with CLOB data type when running ogr2ogr command

Using ogr2ogr, I transferred data from the oracle database to the postgres database. However, the table "table" contains attributes that have a "clob" as a data type, which were ...
2
votes
1answer
330 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
1answer
139 views

Oracle query using 'with' keyword fails in ogr2ogr

I am trying to return a spatial resultant by throwing a fairly long and complex query at some datasets in an Oracle database, and returning a resultant via ogr2ogr. The goal is to return a resultant ...
3
votes
2answers
234 views

Delete duplicate geometries from ORACLE table

I have searched a while now, but there seems to be no answer including an example on how to find and delete duplicate geometries from an Oracle DB table. I am facing a situation where I have a table ...
2
votes
2answers
355 views

Snap a point to a line and get the line ID (Oracle Spatial or SDE.ST_GEOMETRY)

I have an Oracle 18c/10.7.1 geodatabase that has: A sidewalk polyline feature class (existing features) And a sidewalk inspection point feature class (the features are created via ArcGIS Collector/...
0
votes
1answer
182 views

Are spatial queries possible using Python and cx_Oracle?

I am trying to execute a spatial query on an Oracle spatial table via python using the cx_Oracle package. I can make generic queries successfully, but when I try anything involving a geometry or ...

1
2 3 4 5
8