Questions tagged [oracle-spatial]
Use for questions about the Spatial or Locator extensions to the Oracle DBMS
382
questions
1
vote
0answers
26 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
28 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
50 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
27 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
25 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
0answers
34 views
GeoServer 2.18.1 can't add Data Source to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Target: Adding Data Source to Oracle 10g Enterprise Edition Release 10.2.0.1.0
Problem: When trying to add Data Source - Oracle NG GeoServer show the error message:
Error creating data store, check ...
0
votes
1answer
44 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
1answer
223 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
189 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
19 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
33 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
35 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
77 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.
...
0
votes
0answers
29 views
Inserting/Update a polygon into a field with null geometry in Oracle
How can I copy a previously created polygon that is in a temporary layer, to a field with null geometry in Oracle?
I can view the field in the table, use the "Add Part" tool to create a new ...
1
vote
1answer
73 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 ...
0
votes
0answers
22 views
Assigning features to spatial clusters created by Oracle SDO_SAM.SPATIAL_CLUSTERS
SDO_SAM.SPATIAL_CLUSTERS creates spatial clusters - how to detect which feature was assigned to which cluster? Is the only way to perform an additional spatial join between cluster geometries and ...
3
votes
0answers
60 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
34 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
42 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
26 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
89 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
1answer
39 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
74 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
37 views
Show data labels in Oracle Analytics Maps
Can anyone assist me in adding data labels in OAC (oracle analytics desktop ) Maps.
The image below shows state names ,I have a similar requirement to add names to the city.
I tried below json text ...
0
votes
0answers
51 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
114 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
112 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 not created. Is there ...
2
votes
1answer
190 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
109 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
128 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
272 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
120 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
vote
1answer
41 views
Geodatabase archival storage
We are trying to enable Geodatabase (Oracle 18c) archiving (https://desktop.arcgis.com/en/arcmap/10.6/manage-data/geodatabases/geodatabase-archiving.htm)
Our architecture team recommends we separate ...
3
votes
0answers
441 views
Export a layer from QGIS to Oracle DB
I have a working connection to an Oracle database in QGIS (3.4). I am able to import and edit existing tables into my QGIS project out of the db. Unfortunately it is not possible to export any QGIS ...
0
votes
1answer
242 views
How to resolved ORA-12154: TNS:could not resolve the connect identifier specified..? [closed]
When application try to connect to an Oracle Service via Oracle Networking SQL*Net, it looks up the connect data for the service. When this lookup fails, Oracle client show an error message ORA-12154.
1
vote
1answer
568 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 ...
0
votes
0answers
80 views
Query result showing unsupported data type
When I use this code:
SELECT SDO_GCDR.GEOCODE_AS_GEOMETRY
(
'SPATIAL',
SDO_KEYWORDARRAY
(
'3746 CONNECTICUT AVE NW',
'WASHINGTON, DC 20008'
),
'US'
) geom
...
0
votes
1answer
192 views
Projecting features to Enterprise Geodatabase in Oracle gives ERROR 000210: Cannot create output
I am trying to project features from a geodatabase and write into an enterprise geodatabase connection. I have permissions to create data and the name I am using also works, but I keep getting error:
...
0
votes
0answers
24 views
Oracle WMS GetFeatureInfo issue with points and lines
I am trying to do GetFeatureInfo request on MVDEMO sample data.
When it comes to polygons, it is working fine:
When I do the same type of requests on lines or points, I get an empty response:
As you ...
1
vote
0answers
133 views
Unexpected result from Oracle SDO_AGGR_UNION
I'm getting a result that looks incorrect from the Oracle Spatial SDO_AGGR_UNION function. I'm hoping someone has seen this and can confirm it's a bug or explain why this is expected behavior. ...
1
vote
1answer
145 views
How to find nearest neighbor in Oracle's ST_GEOMETRY?
I am trying to find nearest road segment to a point in Oracle. I can do this with SDO_GEOMETRY type i.e
select
/*+ LEADING(pois) INDEX(route ALL_ROUTES_SPTAIL_INDEX) */
route.*
from DEVICE_STATUS ...
0
votes
1answer
156 views
Does SDO_WITHIN_DISTANCE also return points inside a polygon?
Using Oracle Spatial Database, just wondering if the SDO_WITHIN_DISTANCE returns points inside a polygon, not just within a certain number of metres from the boundary.
I've already checked the ...
1
vote
0answers
113 views
SDO_GEOM.RELATE with EQUAL mask returns false for same WKT
I am trying to compare two geometries from two different tables and find all the different with the specified tolerance.
I'm using WHERE sdo_geom.relate(gs.shape, 'mask=EQUAL',p.shape,0.002) = 'FALSE'...
0
votes
0answers
64 views
Unsupported data type for column geoloc
I can open the layer on QGis but in MapInfo I got that error.
I already have other layers I can open without any problem, is just with one I get this error.
1
vote
0answers
15 views
Is there a list of possible value for SDO_GEOM.VALIDATE_GEOMETRY
When the geometry is valid return 'TRUE' but when is invalid return an error code, You can google each one, but I want to have a system user-friendly where when I found a wrong geometry already said ...
1
vote
1answer
57 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 ...
