Questions tagged [oracle-spatial]

An extension that adds spatial operations to Oracle databases

Filter by
Sorted by
Tagged with
2
votes
2answers
4k views

Querying intersecting areas areas - Oracle Locator or Spatial?

My spatial database is Oracle. We are wondering if we can use basic Oracle Locator or need to get the more expensive, full, Oracle Spatial. My application's requirements include having to be able to ...
2
votes
1answer
166 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
1answer
3k views

How to Add Oracle Spatial Tables to QGIS?

I've been playing qith QGIS Chugiak (2.4.0). I've been attempting to try to add Oracle Spatial tables (point, line and polygon feature classes) to desktop. The same tables I use in ArcGIS. I've ...
2
votes
1answer
477 views

How to use the Oracle Spatial functions inside ms4w MAPFILE DATA string?

How to use Oracle Spatial functions in the DATA queries of MapServer(ms4w 3.0.3)? I am getting the following error while trying to highlight selected features which lie inside a particular boundary : ...
2
votes
1answer
57 views

Can I use a join in Mapviewer

I've got two tables, parcels and permits. I'd like to display permits on a map without having to copy the geometry data from parcels. Is there a way to create a join in Mapviewer? Do I have to ...
2
votes
1answer
2k views

Publishing oracle spatial table in geoserver

I published oracle view in geoserver. using this link. But when I see this in layer preview I get following xml response: <?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE ...
2
votes
1answer
72 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 ...
2
votes
1answer
571 views

Projection Problem on Oracle Spatial

I would like to transform SDO_GEOMETRY from WGS84 projection to my custom projection in Oracle Database. Details for custom projection is as follows: +proj=lcc +lat_1=40.5 +lat_2=37.5 +lat_0=25 +...
2
votes
1answer
953 views

Loading Oracle Spatial Layers in standalone python qgis

I used below script to connect to postgres and load layers successfully.I want to aceive this using Oracle Spatial for both vector and raster loading.How can I achieve that?In other words what is the ...
2
votes
2answers
820 views

Query to find all lines connected to other

I have problem with one spatial (Oracle) query. Simplified overview of the problem is: I have two tables: CREATE TABLE thin_lines ( id NUMBER PRIMARY KEY, geom SDO_GEOMETRY), color VARCHAR2(32)...
2
votes
1answer
2k views

Load data to exists table with ogr2ogr

Could I load spatial data to Oracle when table structure was created before this step? Specifically I have problem with default name of attribute OGR_FID . If my primary key has different name, I can'...
2
votes
3answers
1k views

Calculate Area proportional

I have two tables both of them having polygon geometry. Lets consider Table 1 has bigger polygons which overlap over the smaller polygons in table 2.Now I know how to find how many polygons from table ...
2
votes
1answer
2k views

Checking for overlapping polygons in Oracle Spatial?

I have a table 1 which has a fields like store number and geometry and it just has one record in it. Now I want to check for this store number in table 2 and identify if there are any polygons ...
2
votes
2answers
454 views

Searching Open Source tool to load raster data into Oracle spatial

I'm looking for a tool to load raster data into oracle spatial. I found several commercial products but no open source tool. Is there anything available in the open source world?
2
votes
1answer
38 views

Load layer From Oracle using QgsDataSourceUri in QGIS3 always return Invalid Layer

I'm tring to load spatial layer from Oracle but when i called function QgsVectorLayer(uri.uri(), "LAYER" , 'oracle') it still inValid layer This is my code > def LoadFromOracle(tablename): > ...
2
votes
2answers
238 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 ...
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?
2
votes
1answer
2k 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 ...
2
votes
1answer
286 views

QGIS Oracle-Spatial-GeoRaster-Plugin not working [closed]

I am having trouble with Oracle-Spatial-GeoRaster-Plugin in QGIS (running on Windows 7 Professional N 64bit). The connection to my database on an external Oracle-Server obviously works as it shows the ...
2
votes
1answer
441 views

Converting sqlite (spatialite) data to oracle sdo_geometry (using .NET)

Using .NET, I have a sqlite file that I have to import to oracle. The geometry needs to be converted from sqlite (spatialite) geometry column to a sdo_geometry column in oracle: // Loop through all ...
2
votes
1answer
999 views

openlayers 3 (or oracle) convert 2d to 3d

We have an existing oracle gis which is being reworked. We're not really touching the oracle stored procedures or tables. In the table, the sdo_geometry appears to be a 3D line, with 0 as the z value. ...
2
votes
2answers
1k views

Slow connecting to Oracle Spatial database from QGIS client?

I am having trouble connecting to an Oracle Spatial data with QGIS client. I use QGIS Version 2.2 (Valmiera) to connect to a database schema in Oracle Spatial. I asked our DBA access to our database ...
2
votes
2answers
190 views

connect ArcGIS server with different instances of oracle database

Is it possible for a development team to have personal oracle database instances, for testing purposes, connected with the same GIS server? In other words I want every user to work with his own data, ...
2
votes
2answers
1k views

Finding Polygons which do not touch any other polygon in a single oracle database table

I currently have an oracle table of approximately 100,000 records - all of which are polygons. I want to find all the polygons which do not touch any other polygon within the same table. There are a ...
2
votes
2answers
272 views

How to mention multiple projections in MapServer MAPFILE?

Is there a way to mention multiple projection systems / spatial reference systems in MapServer's (ms4w 3.0.3) MAPFILE? For example for Malaysia - GIS data could lie across three spatial references WGS ...
2
votes
2answers
914 views

SQL Server STRelate equivalent of Oracles SDO_RELATE(…mask=anyinteract)

In Oracle Spatial, we are running checks on a graph. The Check should provide Nodes, which are marked as endnodes (Attribute "EDGEDEGREE" equals 1) but are in fact located somewhere along an edge. We ...
2
votes
1answer
3k views

How to set appropriate spatial index for a feature class in Oracle?

I wanted to ask is there any known method how to set spatial index for my feature class in Oracle. I am working with ESRI 10.1 and I have various feature classes covering the whole area of my country (...
2
votes
1answer
1k views

Best way to get the overlapping segment of two lines

Could anyone help me figure out the best way to get the overlapping line segment of 2 line sdo_geometry objects? my query looks like this: select SDO_GEOM.SDO_INTERSECTION(SHAPE, :SHAPE, 0.5) as ...
2
votes
2answers
1k views

Is ArcMap 10.0 Query Layer passing invalid SQL to Oracle 11gR2?

In two different environments I'm having trouble using ArcMap 10.0 Query Layers to view SDO_GEOMETRY (point) data in Oracle 11.2. This suggests I'm doing something wrong... Points are in Oracle ...
2
votes
0answers
24 views

Testing nodes connectivity

I'm working on a shapefile of Brussels (QGIS 3). This shapefile contains all the streets in Brussels, see below. With the attribute table, I have an "X" and "Y" position for each line (debut and end),...
2
votes
0answers
133 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 ...
2
votes
0answers
130 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
227 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
107 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
119 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
2answers
1k views

Tuning Esri Geodatabase on Oracle Spatial (SDO_Geometry) performance? [closed]

We are storing data in a Geodatabase on Oracle 11g using Oracle Spatial with SDO_Geometry, and then consuming that using ArcGIS server 10.2.1. The performance is very slow, because we are talking ...
2
votes
0answers
69 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
2answers
860 views

How to add map layers from Oracle database VIEWS in MapServer mapfile?

I am using MS4w v 3.0.3 (with Java mapscript) with Oracle Spatial 11g. Can we add layers to MapServer mapfile from oracle database views? If yes, is there any specific way to create views with spatial ...
2
votes
0answers
996 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
272 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?
2
votes
1answer
2k views

How to move an Oracle spatial table to another db?

I have uploaded a polyline data (50 million rows) to oracle spatial 10g as sdo_geometry through arccatalog and arcsde in my TEST database. Now, I need to move this table to QA database, this table ...
2
votes
1answer
180 views

arcsde huge size file upload into Oracle spatial

I have 35million records (tomtom multinet) of file gdb file in my desktop machine. I need to upload this file into Oracle spatial as SDO_geometry file. I already tested the connection with small ...
2
votes
1answer
1k views

Oracle spatial - check polygon vertices counter clockwise

I need to import a huge number of polygons from a third party (as a csv file- array of x,y's). I have to check whether the polygon vertices are in clockwise or counter clockwise, finally i have to ...
2
votes
3answers
1k views

Add Oracle Spatial Vector Layer with QGIS 2.0 on Mac OSx

I installed version 2.0 using the recommended mac installer (http://www.kyngchaos.com/software/qgis), and the installation went fine, but there is no option to add an oracle spatial layer (not in the ...
1
vote
3answers
9k views

Loading shapefile in Oracle Spatial?

I am new to oracle spatial. I want to load shapefile into oracle spatial. I am using oracle 11g. I have already look at the following examples and answers http://docs.oracle.com/cd/E11882_01/appdev....
1
vote
2answers
653 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
2answers
967 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 ...
1
vote
1answer
366 views

How can I load sqlite file into oracle 11g?

I have SQLite file which I have taken it from Sptialite DB. I need to convert this file into SDO. Plz help me
1
vote
1answer
964 views

Error configuring Oracle datastore in GeoServer

I want to configure an Oracle datastore in Geoserver so I copied gt2-oracle-spatial-2.3.1.jar and ojdbc14.jar into GeoServer webapp (in WEB-IF/lib folder); then I restarted and try to create new data ...