Questions tagged [oracle-spatial]
Use for questions about the Spatial or Locator extensions to the Oracle DBMS
342
questions
0
votes
0answers
4 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
22 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
11 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
40 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
56 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
54 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
42 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
29 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
56 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
63 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
61 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
48 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
21 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
76 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=...
3
votes
0answers
39 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
27 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
51 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
21 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
103 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
301 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
46 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
0answers
23 views
What is the underlying algorithm of sdo_sam.spatial_clusters in Oracle?
Oracle has a "sdo_sam.spatial_clusters" function for spatial clustering. What is its underlying algorithm?
Unfortunately the Oracle docs do not mention the algorithm or describe in which way the ...
0
votes
1answer
115 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
0answers
86 views
One or more objects failed to paste. Underlying DBMS ORA-00932 : inconsistent datatype
I am migrating all data from a geodatabse oracle to a new oracle schema. I'm trying to copy / paste between the two db connections, but it stops in the middle of the operation by displaying the ...
0
votes
0answers
64 views
Speeding up Oracle Spatial intersection query and indexes
I have about 300 000 records (worksites) in a table (S) with id (id_s), start_date, end_date (and in some cases an authorisation date - AUTH_START).
I have a second table containing the id of 500 of ...
0
votes
1answer
415 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
66 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
54 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
102 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
170 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
186 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
478 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
207 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
51 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
170 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
97 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
437 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 ...
0
votes
0answers
80 views
Oracle 11g aliases that work in ArcMap 10.4
I am getting this error shown in the picture when I try to export a database view into a GDB table in ArcMap 10.4. I know what is causing the error, its the double quotes I use to create alias names ...
1
vote
2answers
652 views
Spatial index info does not appear in ALL_SDO_INDEX_INFO
I have a table with this definition:
CREATE INDEX "MYSCHEMA"."MYTABLE_SX" ON "MYSCHEMA"."MYTABLE" ("GEOLOC")
INDEXTYPE IS "MDSYS"."SPATIAL_INDEX"
PARALLEL 10 ;
Geoloc It is a spatial column, but I ...
0
votes
2answers
190 views
Using ArcPy to join feature class to Oracle Spatial View?
I am trying to join an Oracle table to a feature class but I keep getting the error "000339 : Input does not have OIDs."
The view has a unique incrementing field already, but I am unsure how to ...
1
vote
2answers
1k views
Oracle SDO_UTIL.GETVERTICES returns more than 1 vertex
I'm using Oracle 12.1.0.2.0 and I am getting extrange results using sdo_util.getvertices.
This query returns 2 "vertex" instead of one (as expected)
SELECT T.x, T.y
FROM TABLE(
SDO_UTIL....
3
votes
0answers
468 views
GeoServer 2.9.2 database connection pooling/thread locking issue
I am mocking GetMap requests. Scenario is that 50 users use only "database layers". Each user "sends" 8 GetMap requests every ~22s for ~300s which sums up to 5200 GetMap requests for vector data. ...
0
votes
1answer
79 views
Oracle Locator Features
I have a road network (in shapefile) which is in a projected system (e.g. EPSG:2100). I also have a number of GPS files in WGS84.
I have already stored the data into Oracle 12c (Oracle Database 12c ...
1
vote
1answer
437 views
Draw polygon from sdo.geometry with OpenLayers
I have some polygons in my oracle database, the column type is sdo.geometry, and I want to draw the polygon using OpenLayers.
The problem is OpenLayers reads WKT type and I can't convert to this type,...
3
votes
1answer
515 views
Directly edit features in non-SDE Oracle feature class?
In ArcMap, is it possible to directly open an edit session on a feature class in an Oracle database connection if that Oracle database is not managed in SDE?
It is of course easy to edit the features ...
2
votes
1answer
177 views
Vector tiles for Oracle Spatial
I'm curious what solutions there may be for generating Mapbox vector tiles from SDO_Geometry data? There doesn't appear to be native support as with PostGIS.
1
vote
4answers
1k views
Populating oracle sdo_geometry object using GeoJSON?
I have GeoJson data. I would like to convert this GeoJson data into sdo_geometry object type and insert Oracle spatial database. Which columns represent geojson data in oracle sdo_geometry object.
...
