Questions tagged [oracle-spatial]
An extension that adds spatial operations to Oracle databases
1
vote
0answers
92 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
31 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
15 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
45 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
39 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
143 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
45 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
41 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
57 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
110 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
97 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
294 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
117 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
40 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
70 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 ...
2
votes
0answers
341 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
618 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
315 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
131 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
735 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
68 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
340 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
358 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
124 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
890 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
104 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
63 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
512 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 ...
1
vote
0answers
110 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
128 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
33 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
57 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
349 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
194 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
73 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
213 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
152 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
219 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
41 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
93 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
2k 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 ...
3
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 ...
1
vote
2answers
544 views
SDO_GEOMETRY view in ArcGIS Desktop
I have an sdo_geometry table that I created using ArcGIS Desktop (by converting an esri.st_geometry table to sdo_geometry). I'm using Oracle Spatial's sdo_geometry datatype because it has linear ...
1
vote
0answers
213 views
How can I load layers from oracle with the python editor that comes with Qgis?
I have tried to add a layer from the Oracle database with SDO_GEOMETRY geometry, from the console that comes in QGIS, but it does not load anything, I occupy this because I want to put it in a plugin.
...
4
votes
1answer
295 views
How to get image pop ups in QGIS using oracle blob field with image?
I have a point feature in oracle database which has as attribute a blob field that have image inside for every point feature taken in field.
Is there anyway that i can decode and display it on a ...
1
vote
1answer
181 views
MapInfo Styles in Oracle Spatial Database
I have geographic data in an Oracle database. The data was imported by EasyLoader, which is a MapInfo-Tool. I want to publish this data in a Web Map Service. I have tried to use MapServer, but I have ...
3
votes
0answers
116 views
How update location field (geometry) in Oracle Spatial using asp.net web application?
I want to update a geometry column in Oracle Spatial database via Asp.net web application, I couldn't find samples for update query or datatypes that can hold geometry data in asp.net.
I use C# for ...
1
vote
2answers
863 views
How to store geolocation in tabular Oracle without using Oracle Spatial or Locator?
I'm working on a project to link existing entities in an Oracle database with their geolocation, but the database is a tabular not spatial. Is there a compatible type that can store the geolocation ...
