Questions tagged [oracle-spatial]
Use for questions about the Spatial or Locator extensions to the Oracle DBMS
430
questions
0
votes
0
answers
26
views
Importing SHP to Oracle -
I'm trying to import a SHP to my Oracle database.
I've installed OSGeo4W (Express Install with all 4 packages).
After running my command
.\ogr2ogr.exe -f "OCI" "OCI:user/pass@192.168.1....
- 101
1
vote
1
answer
36
views
ST_GEOMFROMTEXT generated by ora2pg fails
I have a set of polygons inside a oracle table which represent circles. I am tryining to import these into postgres 12 using ora2pg.
An insert statement is created that translates the polygon to
...
- 2,566
1
vote
0
answers
19
views
ST_BOUNDARY in Oracle Spatial
ST_Boundary is in the Oracle Spatial docs here:
https://docs.oracle.com/en/database/oracle/oracle-database/21/spatl/sql-multimedia-type-support.html#GUID-22FE0E11-C9F0-4E1A-B512-D494E588FFAA
But only ...
- 51
0
votes
0
answers
59
views
Inconsistent results from spatial databases
I'm trying to write something agnostic to whichever database vendor is chosen between MySQL, SQL Server, Oracle, and PostgreSQL. However, I see inconsistent results in functions that return measures. ...
- 51
1
vote
2
answers
49
views
Recover\rebuild the .dbf and .shx of a shapefile [closed]
Do you know if there is any way to recover\rebuild the .dbf and .shx files from the shapefile?
I think my case is a little more nebulous.
My .shp files were extracted from a CSV file... That the data ...
- 11
0
votes
0
answers
31
views
Install GDAL on MacOS with Oracle (OCI driver) Support
I am using MacOS Monterey. I am trying to install GDAL with oracle support. I have installed gdal using brew install gdal command but it doesn't include OCI driver. When I am trying to execute the ...
- 3,043
0
votes
1
answer
43
views
Best and Fastest way to extract Polygon attributes of a Point [closed]
This is a comparative question, I don't know whether it is allowed to ask this type of Question here or not.
Problem: I have a shapefile of almost 1 million polygons with 20-25 attribute fields. I ...
- 3,043
0
votes
1
answer
18
views
How to interpolate a point between two points in Oracle
I have an Oracle database table which stores points of a track of moving objects.
object_id
geometry
timestamp
1
...
1970-01-01T00:01:00
1
...
1970-01-01T00:02:00
1
...
1970-01-01T00:03:00
2
...
...
- 11
0
votes
0
answers
43
views
GDAL OGR OCI driver takes unreasonable long time to load from oracle database
For quite some time I'm trying to get OCI to work with GDAL. I created a docker image with the driver installed and I use the python api to do the work.
When I try to load and print just 20000 records ...
- 117
0
votes
1
answer
15
views
Using GDAL to extract Oracle raster
I'm wondering does anyone have examples for extracting raster data from Oracle OrdImage format and creating a GeoTIFF using GDAL?
I see some info on extracting GeoRasters but not OrdImage.
- 3
0
votes
0
answers
34
views
Configuring mapserv with Oracle on Ubuntu 22.04
I am new for mapserv over Ubuntu 22.04.
I had use ms4w and there are lots of things I don't know how to configure and use.
And the first thing is compiling with Oracle
I had Oracle Client installed ok,...
0
votes
0
answers
93
views
Open OracleSpatial Layer via Ogr2ogr in C#
I want to transport an OracleSpatial Layer to Postgis. From within OSGeo4W-Shell this works very well. But from C#-Console-App the DataSource is null but no error occurs.
Here is what I have tried:
...
- 1,146
1
vote
1
answer
38
views
Extract SDO_GEOMETRY line elements using index position / dot notation
SDO_GEOMETRY; Oracle 18c:
Is there a way to extract elements from an SDO_GEOMETRY line using an index position / dot-notation in a SQL query?
For example, extract the X coordinate of the second vertex ...
- 918
0
votes
0
answers
49
views
failed in the execution of the ODCIINDEXUPDATE routine
I hope you can help me. I have a master user who owns the tables and I have several regular users who have permission to select the table and/or permission to edit, update and delete table data. I was ...
- 11
1
vote
0
answers
20
views
Long time to load QGIS project in QGIS 3.22.4
I have several QGIS projects which have layers coming from oracle database. Those layers are heavy so I choose to make them invisible in the projects so that I can load the project much quicker. If i ...
- 153
1
vote
0
answers
44
views
Error changing geometry in oracle table by qgis
I'm having a problem changing or adding geometry in QGIS. My database is Oracle.
I change my geometry in QGIS and when I go to save it, I get this message:
SQL: ORA-29877: failed in the execution of ...
- 11
0
votes
0
answers
20
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 ...
0
votes
0
answers
31
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 ...
0
votes
0
answers
113
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 ...
- 2,566
0
votes
1
answer
45
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 ...
- 918
0
votes
2
answers
78
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() ...
- 918
0
votes
1
answer
110
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:
...
- 918
0
votes
1
answer
60
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 ...
- 1
0
votes
0
answers
81
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:...
- 1
0
votes
1
answer
63
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 ...
- 918
0
votes
4
answers
272
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 -...
- 918
1
vote
1
answer
153
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],[...
- 31
1
vote
1
answer
143
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 ...
- 918
0
votes
2
answers
100
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 ...
- 918
0
votes
2
answers
83
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,-...
- 115
0
votes
2
answers
79
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 ...
0
votes
0
answers
21
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 ...
- 11
-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.
- 918
1
vote
0
answers
37
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, ...
- 11
1
vote
1
answer
112
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 ...
- 113
0
votes
1
answer
30
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';
...
- 19
0
votes
0
answers
47
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, ...
- 19
1
vote
0
answers
34
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 ...
- 11
0
votes
0
answers
42
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 ...
- 3
0
votes
0
answers
76
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/...
- 153
0
votes
0
answers
51
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 ...
- 1
1
vote
3
answers
143
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 (...
- 918
0
votes
1
answer
72
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 ...
- 179
2
votes
1
answer
216
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,383
1
vote
1
answer
238
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 ...
- 73
0
votes
0
answers
130
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 ...
- 93
0
votes
1
answer
215
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 ...
- 93
0
votes
1
answer
27
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 ...
- 93
1
vote
1
answer
93
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
2
answers
1k
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 ...
- 361