Questions tagged [oracle-spatial]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
7 views

How to get values of multiple cells in geo raster in Oracle SQL

I use SDO_GEORASTER to store raster data in Oracle DB. I have stored the elevation data in georaster table named DEM_RASTER_6. And I want to find the elevation of a cell when the location (latitude ...
user avatar
0 votes
0 answers
15 views

ORACLE Import large spatial data using sqlplus

I have a script that contains several SQL statements. One of its columns has large data. It contains data from a SDO_GEOMETRY type. When a try to run the script from sqlplus, I got this error: Error ...
user avatar
0 votes
0 answers
40 views

ora2pg SDO_Geometry to st_geometry

I am trying to migrate my database (Oracle) to postgres using ora2pg (v.23.1). Unfortunately the script converts our SDO_Geometry datatype into shape geometry(GEOMETRY,32632) instead of shape ...
user avatar
  • 2,494
0 votes
1 answer
30 views

Equivalent to USER_SDO_GEOM_METADATA for SDE.ST_GEOMETRY

Background - SDO_GEOMETRY: If I were to create a function-based spatial index that returns an SDO_GEOMETRY, I would manually insert records into SDO_GEOMETRY's USER_SDO_GEOM_METADATA for these ...
user avatar
  • 756
0 votes
2 answers
45 views

How to request GeoJSON standard be enhanced to support M-values

As far as I can tell, the GeoJSON standard doesn't support the M-dimension of linear referencing lines. For example, Oracle Spatial doesn't support LRS lines when using the SDO_UTIL.TO_GEOJSON() ...
user avatar
  • 756
0 votes
1 answer
16 views

LRS SDO_GEOMETRY to "LINESTRING M" WKT format

I have a query that produces an LRS SDO_GEOMETRY as WKT (Oracle 18c): select SDO_UTIL.TO_WKTGEOMETRY(SDO_LRS.CONVERT_TO_LRS_GEOM(sdo_geometry('LINESTRING(1 2,3 4)'))) from dual Output: ...
user avatar
  • 756
0 votes
1 answer
22 views

Buffering polygons with Oracle Spatial 11 vs. 19

Does anyone have special knowledge about Oracle Spatial? I buffered polygons in Oracle-11 Database by making them slightly smaller (-50cm). The geometries are then delivered via a WFS as GML. With ...
user avatar
  • 1
0 votes
0 answers
35 views

GetFeature request inside WPS request fails to execute

I'm trying to make a WPS request with a GetFeature request inside of it but I'm getting an error. The idea is to get features with a spatial filter and then get a Multipolygon with the "gs:...
user avatar
  • 1
0 votes
0 answers
28 views

ST_GEOMETRY feature class: Add a hidden SDO_GEOMETRY column

I have an SDE.ST_GEOMETRY FC in an Oracle 18c EGDB. I want to use Oracle Spatial functions on the data (calculate polyline midpoint, M-values, dynamic segmentation, etc.). Ideally, I'd convert the ...
user avatar
  • 756
0 votes
4 answers
109 views

Convert M-enabled SDE.ST_GEOMETRY to SDO_GEOMETRY using SQL

I have an M-enabled SDE.ST_GEOMETRY polyline FC in an Oracle 18c EGDB. select sde.st_astext(shape) as st_to_wkt from test_st_geom MULTILINESTRING M (( 0.0 5.0 -100000.0, 10.0 10.0 -100000.0, 30.0 0.0 -...
user avatar
  • 756
1 vote
1 answer
39 views

SDO_UTIL.FROM_GEOJSON return geometry with 0 tolerance (only integers)

When we try to use SDO_UTIL.FROM_GEOJSON command in Oracle Database, the coordinates are integer. For example: SELECT SDO_UTIL.FROM_GEOJSON('{"coordinates": [[[11.779,9.069],[15.83,9.194],[...
user avatar
1 vote
1 answer
85 views

Determine if a SDO_GEOMETRY line has true curves

Oracle 18c I have an SDO_GEOMETRY table that I created via ArcGIS Desktop 10.7.1. The table has a line that appears to have a true curve in it: However, in a related question, @Vince pointed out that ...
user avatar
  • 756
0 votes
2 answers
52 views

Does Oracle's SDO_Geometry spatial type support arcs?

Oracle 18c GDB; ArcGIS 10.7.1 With ESRI native spatial types, such as SDE.ST_GEOMETRY, we can store "CAD" arcs in the geometry of polyline and polygon features. Question: Does Oracle's ...
user avatar
  • 756
0 votes
2 answers
46 views

GeoServer + Oracle not working with 3D points

I have an Oracle database table where the geometry column contains 3D points, for example: {3001,8311,{137.15,-15.55,-24},null,null} {3001,8311,{130.935,-12.166,-9},null,null} {3001,8311,{142.5846667,-...
user avatar
  • 115
0 votes
2 answers
48 views

Writing multiple geometries to Interlis using FME

I have to write Features with more than one geometry to interlis. In the Interlis model there is a class which has an optional second geometry as an attribute. Enabling the (Oracle-) Reader to read ...
user avatar
0 votes
0 answers
14 views

Incorrect offset in element info array

I have a table with these columns circle_id number, circle geometry sdo geometry, latitude varchar2, longitude varchar2. I want to check overlapping between shapes, by giving my lat and long in ...
user avatar
-1 votes
1 answer
33 views

Seeking shareable online Oracle instance (with Oracle Spatial enabled)

Are there any shareable/public online Oracle instances that have Oracle Spatial enabled? Use Case: Mock up a Oracle Spatial SQL problem/solution and easily share it via a public URL.
user avatar
  • 756
1 vote
0 answers
28 views

By entering latitude and longitude how to check at which circle it is nearest to

INSERT INTO circle_ ( circle_geometry, latitude, longitude ) VALUES ( sdo_geometry(2003, -- two-dimensional polygon NULL, NULL, sdo_elem_info_array(1, 1003, 4), -- one circle sdo_ordinate_array(8, ...
user avatar
1 vote
1 answer
70 views

How to use SDO_LRS.OFFSET_GEOM_SEGMENT to offset a line in Oracle Spatial

I am trying to offset a line perpendicularly by a few metres (it follows a road and I'd like to move it to one side of the road). The line is an SDO_GEOMETRY object of SDO_GTYPE = 2002 (LINE/CURVE). I ...
user avatar
  • 113
0 votes
1 answer
27 views

Setting version of ArcMap

I am trying to set the version of SDE by using following code : SET SERVEROUTPUT ON; declare q varchar2(100); ver varchar(10); BEGIN DBMS_OUTPUT.PUT_LINE('HI'); ver := 'PQ_358'; ...
user avatar
0 votes
0 answers
41 views

Versioned view does not reflect the delta changes

I am adding some data using session manager to layer, and saving them. Those changes are visible in delta table in SDE also. But, when I query to count the base table and versioned view result count, ...
user avatar
1 vote
0 answers
26 views

Unable to logon when connecting to Oracle database with QGIS 3.20

After I updated QGIS to 3.20 my old oracle connections doesn't work anymore. I get the message "Unable to logon". Under QGIS 3.16 everything works fine. This is what I have read in the ...
user avatar
  • 11
0 votes
0 answers
33 views

Problem Displaying GeoRasters in QGIS

I have been experimenting with GeoRasters for the last few days. So far I have used FME to import a geotiff into Oracle GeoRaster. It seems to import fine. The GeoRaster table gets created along with ...
user avatar
  • 1
0 votes
0 answers
54 views

Connecting to Oracle Spatial from QGIS on Ubuntu

I have Ubuntu 20.04 and the QGIS from the Ubuntu repo is 3.10.4. The QGIS does not have any Oracle datasource available, despite of https://docs.qgis.org/3.10/en/docs/user_manual/managing_data_source/...
user avatar
  • 153
0 votes
0 answers
48 views

QGIS: duplicate layer entries in layer list

I have the following issue when I connect to my Oracle db with the QGIS layer manager. The views I am using are duplicated like showed by this print screen; I thought it was a primary key issue as I ...
user avatar
1 vote
3 answers
100 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 (...
user avatar
  • 756
0 votes
1 answer
43 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 ...
user avatar
  • 179
1 vote
1 answer
133 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 ...
user avatar
  • 1,363
1 vote
1 answer
154 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 ...
user avatar
  • 43
0 votes
0 answers
89 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 ...
user avatar
0 votes
1 answer
134 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 ...
user avatar
0 votes
1 answer
25 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 ...
user avatar
1 vote
0 answers
52 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 ...
user avatar
3 votes
2 answers
589 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 ...
user avatar
  • 351
0 votes
1 answer
250 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 ...
user avatar
  • 133
0 votes
0 answers
26 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 ...
user avatar
1 vote
0 answers
50 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: ( ( &...
user avatar
0 votes
1 answer
35 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....
user avatar
0 votes
0 answers
24 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. ...
user avatar
2 votes
1 answer
61 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 ...
user avatar
  • 21.2k
4 votes
3 answers
152 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 ...
user avatar
  • 869
1 vote
0 answers
56 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, ...
user avatar
  • 11
1 vote
2 answers
86 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....
user avatar
  • 756
2 votes
1 answer
152 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) ...
user avatar
  • 756
0 votes
0 answers
42 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 ...
user avatar
  • 1,027
0 votes
1 answer
206 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 ...
user avatar
  • 2,494
0 votes
1 answer
89 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 ...
user avatar
  • 756
1 vote
0 answers
24 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 (...
user avatar
-1 votes
1 answer
15 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, ...
user avatar
  • 99
1 vote
2 answers
772 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 ...
user avatar

1
2 3 4 5
9