Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

An extension that adds spatial operations to Oracle databases

0
votes
0answers
19 views

QGIS Server Oracle spatial layers as WMTS

I am trying to serve QGIS projects via QGIS server to see if this meets the requirements we've set. One of those requirements being that it should be able to serve projects which contain Oracle ...
1
vote
1answer
24 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
49 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
23 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
26 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
172 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
158 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
70 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
67 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 ...
0
votes
0answers
74 views

Snap Point with Bearing to Nearby Line Matching Heading

How can I snap a set of points which represent tracking data and include a heading, with the nearest line that approximately matches that heading? The tracking data is mostly clustered around ...
1
vote
2answers
258 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
60 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
196 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,...
2
votes
1answer
126 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
69 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
445 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
36 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
39 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
321 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
58 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
81 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
44 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
209 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
122 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....
7
votes
1answer
1k 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
61 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
161 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
82 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
155 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
29 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
74 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
1k 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
770 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
106 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
377 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
152 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
188 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
132 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
92 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
557 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 ...
0
votes
1answer
49 views

Database standards for storing and analysing raster

Vector data stored in a database is covered by OGC's Simple Features and WKT. Databases indeed implement these standards. Some databases such as Oracle, PostGIS extend their support to rasters. Is ...
1
vote
1answer
50 views

How to read oracle not spatial data using pyqgis

I'm working on a QGIS plugin. I'm trying to join a vector layer and a non-spatial table both in Oracle spatial. I add the vector layer to the map, but I can not add the table without geometry so i ...
0
votes
0answers
20 views

ArcGIS export data in Shape from Oracle [duplicate]

I connected my Oracle database to ArcGIS and added one layer to map. This layer has points and polygons. I make a selection in this layer and get 9508 selected features, which I want to export as ...
1
vote
0answers
107 views

Using Mapnik's OGR plugin for Oracle Spatial Database

Mapnik wiki page of OGR plugin says that I can use the plugin for MSSQL server in the following manner: <Layer name="mssql" srs="+proj=latlong +datum=WGS84"> <StyleName>mssql_style<...
3
votes
0answers
200 views

Oracle SDO_GEOM.SDO_MBR Wrong Bounding Box Coordinates

I am using Oracle Spatial to match geo-specific images to the appropriate country they represent. I have a table with a row for each country. Each row consists of a SDO_GEOMETRY column for 3 items: ...
1
vote
1answer
103 views

request postgis to oracle sdo

My request in postgis : create table "schema1"."table1" as select p.field1 ,p.field2, l.field3, l.id from "schema1"."table2" p inner join "schema1"."table3" l on (p."GEOM" && l."GEOM" and ...
1
vote
1answer
1k views

Efficient way to find geometries that intersect a given rectangle

It feels I'm missing something absolutely basic here OR there is something weird in the internals of Oracle's spatial indexing (I sincerely hope it is just me missing something basic or I am about to ...
0
votes
0answers
89 views

Getting error intermittently from QGIS Server with Oracle Spatial?

QGIS Server is on Windows Server 2012 R2 with 16GB of RAM. Oracle (11.2.0.4) is on Windows Server 2008 R2 with 8Gb of RAM. We are getting the following error intermittently in the Apache log file: [...
3
votes
1answer
343 views

Oracle spatial: Point cluster vs MultiPoint?

I'm reading Oracle's documentation and i can't see the difference between Point cluster and MultiPoint element type. The following example code is from the documentation INSERT INTO t1 (i, d, g) ...