Questions tagged [oracle-spatial]
An extension that adds spatial operations to Oracle databases
225
questions
1
vote
1answer
34 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
38 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
19 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
30 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=...
0
votes
0answers
30 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
20 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
0answers
223 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
41 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
18 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
84 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
52 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
274 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
58 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
47 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
83 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
143 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 ...
0
votes
1answer
145 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
390 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
156 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
47 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
2answers
104 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 ...
3
votes
0answers
395 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
930 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 ...
1
vote
2answers
483 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
155 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
942 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....
0
votes
1answer
71 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
407 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
437 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
156 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.
...
0
votes
0answers
136 views
Saving to database on OpenLayers map changes? [duplicate]
I have put a map on website using OpenLayers. This map is fetched from geoserver by using wms request. and in the same way, it is drawn some shapes such as point, line etc. using open layers library ...
2
votes
1answer
69 views
Geoserver feature type details duplicate Oracle DB users
I have two users in a Oracle DB user_1 and user_2. This issue occurs when I create a two tables by user_1 its show one table as user_1.table_1 and the second table as user_2.table_2. I'm not sure why ...
0
votes
1answer
600 views
Errors in creating spatial index on SDO_GEOMETRY column in Oracle 11g
I am using Oracle 11g (Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production) and I have a table that has column of type SDO_GEOMETRY. I want to create a spatial index on this ...
2
votes
0answers
127 views
How to simplify line geometry and preserving topology in Oracle?
I have some polylines in an Oracle database which are topologically connected and I want to simplify these lines based on a tolerance directly in Oracle. I need something like ...
1
vote
1answer
137 views
sdo_aggr_union is not working
I have a table map_building_data and I create view all_incidents_unions
CREATE OR REPLACE FORCE VIEW ALL_INCIDENTS_UNIONS
(
ORA_GEOMETRY
)
AS
SELECT sdo_aggr_union (MDSYS.sdoaggrtype (ora_geometry,...
-2
votes
1answer
35 views
Can Oracle store contours? [closed]
I have contours generated in ArcGIS and now it is in a file geodatabase. We need to share it with another application in our company that is using Oracle. Can Oracle without SDE store contours?
And ...
0
votes
1answer
59 views
arcpy.da.Editor not saving edits to base Oracle Spatial tables
Can't post code because of Fed policy, so I will ask the question here.
We are working on a series of polygon feature classes that are used to define large activity areas. These polygons are modified ...
3
votes
1answer
394 views
Split lines in segments based on distances in Oracle
I have a data set consisting of 2D linestrings which are stored in an Oracle database in table my_lines with an id and a geometry column (units are in meters).
In a separate table my_intervals with a ...
0
votes
2answers
221 views
QGIS Oracle Spatial Multiline:Only the last line is drawn
When I use QGIS to show Oracle spatial data, only the last line of an Multiline is shown. For instance, in this multiline geometry, only the segment from 20,10,0 to 30,10,0 is shown
insert into rr....
8
votes
1answer
2k views
PostGis vs Oracle Spatial 11g performance
I am having a performance issue updating a table in Oracle Spatial 11G while converting 63,000,000 points to WKT format. I also made a comparison with Postgres. Both Postgres and Oracle run in two ...
1
vote
1answer
76 views
Reproject vector layer in oracle or PosGIS without export!
I have some vector layers in Oracle and PostGIS, point, line and polygon, and i want to reproject those layer in a different projection but i don't want to export the projected layer, i want to do it ...
2
votes
2answers
227 views
Persistence in QGIS under Oracle workspace
I'm using QGIS 2.18.9 to edit my spatial data, my data is saved in Oracle's database.
When I'm editing a spatial layer I can create, edit and delete features without problems, but my database needs ...
1
vote
2answers
171 views
Using Oracle Spatial for dynamic segmentation?
I am new to Oracle Spatial, my main objective is to conduct dynamic segmentation (DynSeg) on a selection of tables. I understand there is a rich Oracle Spatial API that has all kinds of functions and ...
1
vote
0answers
259 views
JOIN on Oracle table and view with PyQGIS
I have a view v and table st with attributes and SDO_GEOMETRY columns in an oracle database.
I want to do an LEFT OUTER JOIN a common value with data filtering on the v.
SELECT ST.OBJECTID, V.ID_WS, ...
0
votes
0answers
47 views
Understanding results of sdo_cs.determine_chain
I run this query:
select sdo_cs.determine_chain(null, null, 3087, 4326) from dual;
This is the result:
MDSYS.TFM_PLAN(MDSYS.SDO_TFM_CHAIN(3087,-1,4152,-2,4326))
How should I interpret the -1 and -...
1
vote
0answers
98 views
How to find closest line of polygon [closed]
I have polygon layers on my ArcGIS Server and Geoserver. I need to find the closest line length of the polygon.
For example p(x1,x1) will get the L2 length and p(x2,y2) will get the L4 length.
Can I ...
1
vote
3answers
3k views
Extracting Coordinates from Oracle Spatial Object Table using FME?
I've searched all available online sources but none appear to have this issue.
I've added an Oracle Spatial Reader, connected to desired table and now want to extract x/y but I get this error when ...
2
votes
1answer
1k views
Line to polygon in Oracle Spatial
I have a table that contains buildings in a line geometry where a line starts and ends at the same point. Is there away to convert lines to polygons in Oracle Spatial?
3
votes
0answers
112 views
How to restrict user to change (move) only one point in QGIS with Oracle Spatial database connected
I'm working with an Oracle Spatial View (Oracle Database 11g Enterprise, 64bit) in QGIS (2.18.0).
There was the bad case that I (and other user) was selecting a lot of points and accidentally moved ...
