Questions tagged [oracle-spatial]
Use for questions about the Spatial or Locator extensions to the Oracle DBMS
439
questions
1
vote
1
answer
17
views
SDO_UTIL.GETNUMELEM in Oracle Spatial doesn't seem right against MultiPoint types. Is this a defect?
I would imagine that running GETNUMELEM against a MultiPoint would return the number of points in the MultiPoint, but it seems to always return 1. I'm comparing it with ST_NumGeometries in other ...
- 15
0
votes
1
answer
31
views
Does Oracle Spatial have equivalents of ST_IsClosed ST_IsRing ST_IsSimple
I'm trying to find the equivalent in Oracle Spatial of the above OGC functions. I know there's not a direct function I can call, does anyone know of a workaround to get these functions by combining ...
- 15
0
votes
0
answers
27
views
Query Oracle for new data based on properties of visible markers?
I'm very new to R/Shiny/Leaflet.
I have a barebones working example where I can display points on map based on their lat/long in a table I pull from Oracle:
siteData <- conn %>% tbl(in_schema(&...
0
votes
1
answer
38
views
DISJOINT and TOUCH between Polygon and LineString not working as expected in Oracle Spatial
I have the following 4 geometries in an Oracle Spatial table:
A) POLYGON ((-100 40, -100 44, -96 44, -96 40, -100 40))
B) LINESTRING (-99 37, -99 40)
C) POINT (-100 41)
D) POLYGON ((-96 41.5, -95 42, -...
- 15
0
votes
1
answer
44
views
Linear referencing using Oracle Spatial
I wanted to Linear Reference a table in the Oracle database that has RouteID, Measurement From, and To in the fields using Oracle Spatial by referring to another Feature Class (Polyline) like it's ...
- 11
0
votes
1
answer
67
views
GeoMesa Accumulo ingest via Oracle JDBC failed
I tried to ingest data from Oracle 12c into GeoMesa 2.2.1 (with Accumulo 1.9.2, using docker from geodocker).
Java version 1.8, and I use ojdbc8.jar for JDBC driver.
My oracle table CUSTOMERS have 3 ...
- 65
0
votes
0
answers
39
views
GeoServer and Oracle Spatial synonym WFS-T Layer
I have two schemas (A,B) in Oracle (19c) with one table in schema A where I want to write with WFS-T from the GeoServer.
The GeoServer is using the version 2.21.4 and corresponding OCI Driver.
The ...
- 1
0
votes
0
answers
167
views
SDO_GEOMETRY queries
I have tables in my Oracle database: AIRPORTS and POPULATED_PLACES. Both two tables were transformed to SRID 3426 and spatial indexes were created as well as USER_SDO_GEOM_METADATA table.
AIRPORT has ...
- 221
0
votes
2
answers
522
views
WFS layer not showing all data in ArcGIS Pro or not showing at all in QGIS, and inconsistent preview [closed]
I have a layer in GeoServer that is pulled in from Oracle. WMS shows all data as expected. WFS exhibits these problems.
ArcGIS Pro, only a subset of the data is shown
QGIS, the layer is loaded, but ...
0
votes
1
answer
67
views
Oracle Spatial dump Transformation
I have received an Oracle Spatial dump (.dmp) from an external source, but lack access to an Oracle Spatial DB. Is there an open-source way to extract the data? ogr2ogr seems to work with a running db ...
- 155
2
votes
2
answers
442
views
Passing a WKB generated by Geopandas into an Oracle SDO_GEOMETRY constructor
I'm trying to iteratively pass WKBs created by Geopandas into an Oracle SQL query but I'm getting this error:
DatabaseError: ORA-29902: error in executing ODCIIndexStart() routine
ORA-29532: Java call ...
- 75
0
votes
1
answer
168
views
Oracle Spatial vs ArcGIS: Wrong results with spatial join
I have some troubles with a spatial join in Oracle db (version 12c):
I have a table with points with SHAPE in SDO_GEOMETRY format. Now I want to select these points if they are in a polygon via ...
- 49
0
votes
0
answers
267
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/[email protected]....
- 101
1
vote
1
answer
117
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,608
1
vote
0
answers
39
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 ...
- 61
0
votes
0
answers
72
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. ...
- 61
1
vote
2
answers
256
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
156
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,151
-1
votes
1
answer
226
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,151
0
votes
1
answer
112
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
...
...
- 21
0
votes
0
answers
208
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 ...
- 137
0
votes
1
answer
53
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
129
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
227
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,181
1
vote
1
answer
307
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 ...
- 1,114
2
votes
0
answers
41
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 ...
- 163
1
vote
0
answers
101
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
114
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
314
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,608
0
votes
1
answer
131
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 ...
- 1,114
2
votes
2
answers
199
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() ...
- 1,114
1
vote
1
answer
462
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:
...
- 1,114
0
votes
1
answer
265
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
208
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
150
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 ...
- 1,114
0
votes
4
answers
727
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 -...
- 1,114
1
vote
1
answer
488
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
323
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 ...
- 1,114
0
votes
2
answers
218
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 ...
- 1,114
0
votes
2
answers
206
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
150
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 ...
- 11
0
votes
0
answers
40
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
39
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.
- 1,114
1
vote
0
answers
54
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
251
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
47
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
59
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
60
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
189
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
56
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