Questions tagged [oracle-spatial]
Use for questions about the Spatial or Locator extensions to the Oracle DBMS
352
questions
0
votes
0answers
18 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
35 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 ...
0
votes
0answers
57 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
19 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.
0
votes
1answer
41 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
36 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
77 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
19 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 ...
0
votes
0answers
30 views
Set Valid Time for Oracle Workspace Manager in QGIS
I am trying to utilize the workspace functionality in QGIS. Entering a workspace via the connection parameters is not an issue. The issue is the valid time is always the current system time the edit ...
1
vote
0answers
44 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
50 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
28 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
17 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
7 views
Can't initialize topology in Autodesk Industry Model 2017
Im facing difficulty trying to initiate my Industry model topology, i always get the error of cannot write _tisl with sql loader, i tried to clean the lines but no luck, i dont know what to do im ...
0
votes
0answers
30 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
13 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
41 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 ...
3
votes
0answers
60 views
Testing nodes connectivity
I'm working on a shapefile of Brussels (QGIS 3). This shapefile contains all the streets in Brussels, see below.
With the attribute table, I have an "X" and "Y" position for each line (debut and end),...
1
vote
1answer
87 views
ArcGIS Server Featurelayer: Error on adding features via JavaScript API after switch from Oracle db to PostGIS
We have a webapp which consumes services published on ArcGIS Server. All database relevant operations are done with ESRI ArcGIS abilities.
We now switched from Oracle 11g to PostgreSQL 9.4 with ...
2
votes
0answers
44 views
ArcMap replication tool does not synchronize changes made in versioned view from SQL Developer!
I am trying to replicate a feature class from Oracle to MSSQL Server using one-way replication(parent-child) replication. The replication works when edits are made from ArcMap,since I have to insert ...
0
votes
1answer
46 views
Connecting to *.sde file in database IDE
I have no experience with connecting to ArcSDE databases other than opening user on prod.sde connection files in Catalog, so I have no intuition for entering information about hosts/servers/etc. In ...
2
votes
1answer
85 views
Load layer From Oracle using QgsDataSourceUri in QGIS3 always return Invalid Layer
I'm tring to load spatial layer from Oracle but when i called function QgsVectorLayer(uri.uri(), "LAYER" , 'oracle') it still inValid layer
This is my code
> def LoadFromOracle(tablename):
> ...
0
votes
0answers
131 views
Connecting Oracle Database 11g in ArcMap?
I installed Oracle Database Enterprise Edition 11g(11.2.0.1) in my machine. And I installed ArcMap Desktop 10.3.1 on another machine. Whenever I am trying to create a direct connection of Oracle DB ...
1
vote
1answer
85 views
MapServer with Oracle-Spatial on Linux
On a SUSE System (SLES 15) I try to configure MapServer 7.4. with Oracle-Spatial support.
Important: The Oracle Database is installed on another server.
I wonder if I need also the Oracle ...
0
votes
0answers
51 views
Transfer indexed Oracle geoloc table to PostgreSQL using ogr2ogr
I am copying tables using ogr2ogr from Oracle to PostGIS using
ogr2ogr -f "PostgreSQL" PG:"host=<host> port=5432 user=<user> dbname=<dbname> password=<pwd>" OCI:<USERNAME&...
1
vote
0answers
26 views
Oracle to PostgreSQL migration with ogr2ogr only imports first geoloc column
I transfer Oracle tables to PostGIS using Oracle Wallet and
ogr2ogr -f "PostgreSQL" PG:"host=<host> port=5432 user=<user> dbname=<dbname> password=<pwd>" OCI:<USERNAME>...
1
vote
0answers
119 views
Whole schema migration from Oracle Spatial to PostGIS import using ogr2ogr
I can migrate Oracle SQL table to PostgreSQL using ogr2ogr using:
ogr2ogr -progress -f "PostgreSQL" -nln schema.table -skipfailures -overwrite -lco FID=ID_COLUMN -lco GEOMETRY_NAME=geom PG:"host=...
4
votes
1answer
43 views
Limit users' editing privileges by attribute and role
I have a feature class in an Oracle 12c geodatabase.
The feature class has a type column. The column has a coded domain.
I would like to limit user's ability to edit the features based on the type ...
1
vote
0answers
30 views
Oracle Enterprise GeoDatabase force logging vs nologging [closed]
Our production Enterprise GeoDatabase running on Oracle has been configured at the database level to force logging. ArcSDE DBTUNE defines many tables and indexes by default to be NOLOGGING for ...
0
votes
0answers
66 views
Spatial intersection of features (Oracle Spatial) with a line stored in a local gml file?
Interesting sites are stored as polygon features are stored in an Oracle Spatial read only dB.
I have a local GML file containing a line (EPSG:31370 - corresponding to a trajectory over a couple of ...
0
votes
0answers
22 views
Does the GeoWebCache listen to the table updates and then update tiles?
My GIS Application uses a GeoWebCache backed by Geoserver. On the database side, I use Oracle Spatial.
When data gets modified/ added to the table, Does the GWC keep listening to the table to update ...
1
vote
1answer
146 views
SDO Oracle Table not recognized as Geometry in QGIS
I can connect to the Oracle Database with QGIS but spatial table/layers are not recognized as such.
I have read the following in the QGIS documentation:
Normally, an Oracle Spatial layer is ...
1
vote
0answers
398 views
Converting Multipolygon to Polygon and saving in new table in Oracle Spatial?
I have a data set with mixed SDO_GTYPE 2007 and SDO_GTYPE 2003, however for the task I am working on only SDO_GTYPE 2003 is allowed for practical reasons.
I was able to extract the polygons in a ...
1
vote
1answer
81 views
Is SDO_GEOM.RELATE returning erroneous results?
I believe I am getting some erroneous results when performing SDO_GEOM.RELATE with my spatial query.
Given the following query:
select SDO_GEOM.RELATE(
MDSYS.SDO_GEOMETRY(2003, 4326, NULL,
...
0
votes
1answer
130 views
Using Google Encoded Polyline Algorithm Format with Oracle Database
Google's Encoded Polyline Algorithm Format is implemented in several GI tools. PostGIS e.g. has ST_AsEncodedPolyline and ST_LineFromEncodedPolyline functions.
In contrast, Oracle Database has no ...
0
votes
1answer
534 views
Checking if a geometry is NULL in Oracle Spatial
I'm working on an exercise in Oracle Spatial. I want to check if two geometries overlap. I need to use SDO_GEOM.SDO_INTERSECTION to do so, and that's my main difficulty (I know how to do it with ...
0
votes
1answer
68 views
GeoServer 2.13.3 unable to delete from Oracle 11gR2 over WFS-T
I'm attempting to upgrade GeoServer 2.9.2 to 2.13.3. GeoServer uses the Oracle Data Store plugin (updated to gt-jdbc-oracle-19.3 as part of the upgrade). Oracle is 11gR2.
One of the applications ...
1
vote
1answer
73 views
Lines from Oracle Spatial Layer in QGIS are not completly visible
I connected a spatial layer from the Oracle database which contains lines (OracleDB objectclass typ is polyline) to be visible in QGIS.
An example geometry is as follows:
sdo_geometry(2002,2056,...
0
votes
0answers
115 views
Query Feature Class from Oracle table with no geometry column
Using ArcMap 10.4.1 I am trying to create a query layer from an Oracle table (Oracle info at bottom). The table has no geometry column, but has x and y coordinates as double and I am trying to create ...
1
vote
0answers
192 views
Editing Oracle Spatial view from QGIS?
I try with QGIS to insert new features in a multi-table Oracle Spatial view that is updatable by adding an "instead of" trigger. The view is "key-preserved" and I don't have any problem when I insert ...
2
votes
0answers
55 views
Select events that represent the most recent work on roads
I have a question on Stack Overflow where I ask about Selecting events that represent the most recent work on roads. So far, I have been provided an answer that seems to work, although it is quite ...
0
votes
1answer
217 views
GDAL ogr2ogr OracleSpatial to Shape: Multipolygons with wholes/multiparts are missing
We're holding geodata in an Orcale database (11g) with spatial extension. I want to unload specific polygons and convert them into Shape for further local processing.
The table where I'm unloading ...
3
votes
2answers
565 views
How to change the coordinate transformation function in Oracle?
I'm trying to reproject some data from one CRS to another (SRID:27493 to SRID:3763) using the SDO_CS.TRANSFORM function.
The function works and returns no errors, but the coordinate transformation ...
1
vote
1answer
239 views
Error concatenating lines in Oracle Spatial
The function SDO_AGGR_CONCAT_LINES is returning an error when concatenating lines from a table with simple line geometries (SDO_GTYPE - 2002):
ORA-29400: erro do cartridge de dados
ORA-06502: PL/...
0
votes
0answers
53 views
Table sde.state_lineages extremely slow
I'm running a ArcGIS 9.3 Oracle SDE geodatabase.
Our ArcMap client is extremely slow at displaying versionned feature class.
One table seems to be impacted : sde.state_lineages
A simple SELECT * FROM ...
0
votes
1answer
25 views
Releasing user-schema locks when updating user-schema
Putting together a scripted event where we update user-schema (prod) in one sde instance from a dev user-schema instance. Both sdes are Oracle 12c. Replication is not used and the destination ...
0
votes
2answers
246 views
Oracle - find N neighbors (points) of a point within a radio
I have this table, there it goes a sample output to show that it is a point
select SDO_UTIL.TO_WKTGEOMETRY(geo)
from places
where id=1
_______________________________________________________
POINT ...
1
vote
1answer
110 views
What is mapinfo precision on coordinates
I have some roads on Mapinfo and looks OK, all nodes seem connected at 0.01 m Zoom.
If you try to export it to mid/mif you can see the same coordinates (-63.869036 11.039044)on all 3 lines.
Line -63....
3
votes
0answers
496 views
Oracle connections fail in QGIS 3.0 DB Manager
Oracle connections are working OK in the Browser panel, the Data Source Manager, and the Python console, but any attempt to open a connection in the DB Manager is failing.
The database is a fresh 12.1....
2
votes
1answer
1k views
How to view coordinates instead of geometry object in geometry column in Oracle SQL Developer?
I've once found a setting in Oracle SQL Developer, allowing to display the geometry column as coordinates, instead of the generic geometry object name (e.g. MDSYS.SDO_GEOMETRY).
I cannot find it ...
