Questions tagged [oracle-spatial]

Use for questions about the Spatial or Locator extensions to the Oracle DBMS

Filter by
Sorted by
Tagged with
1
vote
0answers
215 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
262 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
686 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
276 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/SQL:...
0
votes
0answers
56 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
28 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
325 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
118 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
535 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
2answers
2k 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
91 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
902 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
269 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
590 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
83 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
534 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
643 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
238 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.
2
votes
4answers
2k 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
185 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 ...
1
vote
0answers
55 views

How do I make this subquery factoring work with st_geometry predicates?

I have the following SQL: WITH w AS (select shape from schema.feature_class_polygon fcp where fcp.field = 123456) SELECT count(*) FROM schema.feature_class_lines fcl WHERE sde.st_intersects(w.shape,...
2
votes
1answer
80 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 ...
4
votes
2answers
78 views

Keeping Default Version of Geodatabase protected?

I have a multiuser geodatabase with Oracle Enterprise RDBMS. The Version of the geodatabase is 10.4.1 and Oracle 11g. We have over 35 data editors with the flat version tree, each user having their ...
0
votes
0answers
48 views

How to Drop Indexes on a Table in ArcCatalog

I am using an Oracle 11g database . The code below doesnt allow me to drop indexes on a table. import arcpy # Remove indexes and statistics for gis feature class delta tables COND=r'E:/...
1
vote
0answers
115 views

Make Query Layer - field not available as unique identifier when using NVL [duplicate]

I need to create a spatial view with Make Query Layer. My query includes outer joins, so I must combine every table's ID field to create a unique identifier. Since there might not always be a child ...
0
votes
1answer
824 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
143 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
175 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
71 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 ...
2
votes
1answer
40 views

ArcObjects error storing long integer value to Oracle

I am trying to save a long integer value to an Oracle field. I have created a field of long integer type using ArcCatalog in a standalone table. The below code breaks at row.set_Value(idx, val) . ...
3
votes
1answer
539 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
285 views

Only last line of Oracle Spatial Multiline is drawn in QGIS

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
3k 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
91 views

Reproject vector layer in oracle or PostGIS 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
305 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
232 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 ...
2
votes
0answers
302 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
63 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
120 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
118 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
837 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 ...
0
votes
1answer
60 views

Limiting search radius and improving performance of ArcSDE for Oracle?

I have a feature class with around 1 million polygon features. I'm using the following query to return features from the polygon feature class that intersect a specified point location (x, y not a ...
1
vote
0answers
273 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
534 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 ...
5
votes
2answers
898 views

Creating geodatabase (and st_geometry) in Oracle Express (XE) for home/personal use?

I'd like to set up a database environment at home that mimics what I have in the office (Oracle enterprise geodatabase/ESRI's st_geometry). I want to do this for spatial database training purposes in ...

1
2
3 4 5
8