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
0answers
8 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
29 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
32 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
85 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
42 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
55 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
1answer
44 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 ...
0
votes
2answers
136 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 enterprise geodatabase. The plan is to serve up the GDB's feature classes to a feature service and edit the data via ArcGIS Collector (on-premise; not ArcGIS Online): ...
0
votes
0answers
20 views

LRS m dimension data view

I have generated 3D with LRS data using Oracle Spatial and I am trying to view that in QGIS but it does not read that table from the Oracle database. I tried again without 3D generated LRS in Oracle ...
0
votes
1answer
45 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
37 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 ...
1
vote
0answers
131 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
43 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
165 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
50 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
121 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
20 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
34 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
56 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
63 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
49 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
31 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
36 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
43 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
67 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
129 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
81 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
121 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
158 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
103 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
54 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
39 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
166 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
46 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
37 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 ...
1
vote
1answer
191 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
535 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
98 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
137 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
656 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
71 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
83 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
122 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
204 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
253 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 ...
4
votes
2answers
657 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
2 3 4 5
8