Questions tagged [oracle-spatial]

An extension that adds spatial operations to Oracle databases

51 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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 ...
3
votes
0answers
282 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: ...
3
votes
0answers
149 views

Geoserver ImageMosaicJDBC problem with interpolation setting

I use the ImageMosaicJDBC plugin to connect to an Oracle raster table. Maybe someone can clarify some things about the interpolation settings. There are multiple location where I can define the ...
3
votes
0answers
813 views

How to compile QGIS with Oracle Spatial support for Linux?

I compiled it on Fedora and Ubuntu, but got error "Cannot get Oracle select dialog from provider." while trying to add Oracle layer. Packages in repositories don`t have oracle spatial support. Can ...
2
votes
0answers
376 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
0answers
124 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 ...
2
votes
0answers
217 views

QGIS Server 2.12.14 Errors with Oracle

We are using QGIS Server to serve Oracle SPatial (11.2.0.4) to a spatial viewer. There is 16Gb of RAM. The number of concurrent users is 100-150. QGIS Server is on Windows Server 2012 R2 with 16GB of ...
2
votes
0answers
106 views

SQL server in ArcGIS 10.2 Desktop

I am using ArcGIS 10.2, and previously using Oracle spatial as back end. Now the data providers have shifted to SQL providing core data using FTP which is being staged at SQL server. We need to ...
2
votes
0answers
116 views

How to efficiently drape vector data over a DTM

I have ~100 million 2d vector topographic features (lines and polygons) in an Oracle 12c database. I have 20 billion xyz points in an Oracle database table as number types - the points cover the same ...
2
votes
0answers
65 views

Multiple Cursors

Below is the sql statement which I have explained below. Declare Cursor c1 is select store_number ,0 as total_area,0 as BG_ID ,0 as store_geom from table1 where CLIENT_ID= 1 and ORG_ID ...
2
votes
0answers
123 views

Check for overlaps in polygons

I want to get a list of all the polygons from table 2 which overlap with one polygon from table 1. Following is the query which I am trying to use which doesnt give any result. Select b.bg_id from ...
2
votes
0answers
976 views

Migrating from PostGIS to Oracle Spatial

We are now using a solution based on PostGIS extension of Postgresql database for various spatial queries. But we are now thinking about data security. This is why we have a plan to migrate existing ...
2
votes
0answers
96 views

Can .Net version of ArcGIS Server expose Oracle spatial data without ArcSDE, or is this limited to Java version?

I'm planning a new deployment of ArcGIS Server and I want to avoid using ArcSDE if possible. My vendor requires that we store our spatial data in Oracle and we prefer to use Microsoft server ...
2
votes
0answers
270 views

ArcMap vertex problem for Z-value

I have an Oracle Spatial dataset with z-coords. I can edit the dataset in ArcMap however the z-values are always rounded to the nearest integer. Why does ArcMap round the z-values?
1
vote
0answers
15 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
26 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=...
1
vote
0answers
203 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
0answers
135 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 ...
1
vote
0answers
119 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
0answers
252 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, ...
1
vote
0answers
231 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. ...
1
vote
0answers
166 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<...
1
vote
0answers
166 views

QGIS 2.14.3 can't attach oracle spatial table

when I try to attach spatial table in QGIS, the application close without errors. The tables which have problem have a UUID column: mslink NUMBER(10,0) NOT NULL, uuid RAW(16) ...
1
vote
0answers
353 views

ArcGIS Server Rest API date issue

I am using "date '2015-8-10'" in ArcGIS Server REST API to retreive records from map services. But it returns the error "Fail to Execute". My date is stored as "10-AUG-15". When it is in the right ...
1
vote
0answers
68 views

Oracle Spatial: Issue with sdo_nn_distance for canada postal codes

Spatial data are available in the table st_country_postal_code with index. Inorder to get the distance between postal codes, we used the below query SELECT sdo_nn_distance (1) distance, z.* FROM ...
1
vote
0answers
202 views

Testing Oracle query produces valid results in QGIS Python Console

I have a query that searches an Oracle database using a where clause to get the geometry of an object and then zooms to the extent of that object. The value for the where clause is retrieved from a ...
1
vote
0answers
33 views

deleting lines with smaller length and overlapping oracle spatial

I need to identifying polylines which are overlapping with each other and deleting them which is smaller in length in Oracle Spatial.
1
vote
0answers
111 views

GeoServer: Use oracle as raster store without spatial extension

Is it possible to store raster data (e.g. GeoTIFFs) in an oracle table and access it from geoserver without using the oracle spatial extension/GeoRaster? I would store the images as blobs, but I don't ...
1
vote
0answers
169 views

Data not showing in QGIS when connecting to Oracle

I have an Oracle XE 11g spatial database that is connected to a web map. All the layers of the web map are stored in the database and they work just fine. I sometime need to edit some of the layers in ...
1
vote
0answers
235 views

Tables not showing within schemas following Table retrieval in QGIS (Oracle Spatial)

When connecting to an Oracle Spatial database, QGIS is not consistently populating the list of tables under each schema. When I try to expand a schema (as I have tried to do with PARKING in the ...
1
vote
0answers
239 views

Migrating ArcSDE data to Oracle Spatial?

We've got all the geospatial information of our company within an ArcSDE Database (over oracle Server): points lines polygons We consume these data with ArcGIS Desktop and with ArcGIS Server. We ...
1
vote
0answers
2k views

How to use the same client for Oracle 8 and Oracle 11g?

I have a legacy system into Oracle 8, and spatial database in Oracle 11g. When I installed the Instant Client for Oracle Spatial access to Oracle 8 did not work. My question is how can I do to be able ...
1
vote
0answers
63 views

Is it possible to connect Maptitude 5 with Oracle Spatial?

I have a version of Maptitude 5, and I need to connect it to Oracle Spatial. I have the client installed on the machine, including the connection to the database using Qgis and gvSIG and this works ...
1
vote
0answers
77 views

How to implement subtype functionality in Oracle Spatial?

I am planning to shift my entire database from arcgis to oracle. I will not be using ArcSDE services also. I need subtitutes for ESRI's functionalities like domain, subtype, relationships in oracle. ...
1
vote
0answers
87 views

Allocate places according to distance

I've asked this over on Stack Overflow but thought that someone may have a GI point of view that may help: As an over-simplified example I have a list of events that have a maximum attendance: ...
1
vote
1answer
242 views

draw isoline from points

Is any spatial utility or methods are available for creating contour or isopleths on Oracle spatial? I want to create contours from point geometry and show it on a map (using mapserver) of the site. ...
0
votes
0answers
34 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&...
0
votes
0answers
21 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 ...
0
votes
0answers
17 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
79 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
49 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
0answers
78 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 ...
0
votes
1answer
129 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 ...
0
votes
0answers
46 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
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 -...
0
votes
0answers
333 views

How can I merge thousands of polygons in Oracle Spatial in faster way?

Previously I was using sdo_aggr_union(sdoaggrtype(geom, 0.005)) to get boundary polygon by merging geometries, which was taking at least 3 minutes in case of 4000 polygons. Even if I use merging of ...
0
votes
0answers
150 views

Error when trying to open Oracle Spatial view in MapInfo 11.5

I have a Oracle Spatial table defined as follow: CREATE TABLE foo ( id NUMBER(9) PRIMARY KEY, sdo SDO_GEOMETRY NOT NULL ); And a view defined like this: CREATE ...
0
votes
0answers
361 views

Adding Oracle Spatial Layer using Python Bindings of QGIS?

I want to load a layer from my Oracle Spatial Database using the Python bindings of QGIS. I have tried loading the layer by creating the uri as shown in some previous posts. I am using the python ...
0
votes
0answers
108 views

Convert spatial table into non-spatial table in Oracle

I want to convert a spatial table, registered with Geodatabase (SDE), into a non-spatial table using SQL Developer, what would it be the most efficient/elegant way of doing it? Obviously, first I ...