Questions tagged [oracle-spatial]

An extension that adds spatial operations to Oracle databases

Filter by
Sorted by
Tagged with
1
vote
0answers
240 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
150 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
2answers
177 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
261 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
99 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
0answers
245 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
175 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
167 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
370 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
207 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
113 views

Need Help Creating Query Layer From Oracle For Past 365 Days [closed]

I have several Query layers that work fine for generic, long term date ranges such as: This shows all entries that have the previous YEAR in the date field. AND To_char(ds.calendar_date, 'YYYY') = ...
1
vote
0answers
34 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
116 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
243 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
246 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
1answer
167 views

Load Oracle Spatial Raster using PyQGIS

Able to connect to Oracle Spatial 11g and print tables with SDO_GEORASTER attribute both in QGIS python console and standalone application.I get below error when loading rasters from oracle Table. ...
1
vote
1answer
59 views

Spatial and property search [closed]

We have a lot of polygons (some of them contain holes) and there are also a lot of points inside different polygon, these data are processed as ESRI geodatabase format. Now we have to do some spatial ...
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
65 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
127 views

Checking for overlaps in polygons using Oracle Spatial?

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 ...
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
246 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
2answers
2k views

How to improve performance of Oracle Spatial function sdo_aggr_mbr

I experienced bad performance when using the sdo_aggr_mbr function on a data set of more than 1 million rows, I had to terminate the operation after several minutes. The statement was: select ...
0
votes
2answers
505 views

Oracle search against intersect of a region that covers the whole world doesn't find any records

I am new to Oracle Spatial, I am trying to implement a service that will take coordinates from a map, and search our database to find any geometries that intersect with that map view. I works fine for ...
0
votes
1answer
911 views

Tools to export shps from Oracle database

What open source tools could be used to export shapefiles from an Oracle database. I have tried using QGIS but it does crash way too much.
0
votes
1answer
59 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 ...
0
votes
2answers
165 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
1answer
617 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 ...
0
votes
2answers
149 views

how to configuring geomajas wih oracle spatial db?

I have just done intial setup of the geomajas project and trying to config its data source with oracle database. I am following the given example for sqlserver and POSTGIS. My oracle layerroad xml ...
0
votes
2answers
508 views

Oracle Error 00936 in ArcMap

I am using ArcMap 10.2 and have connected to my Oracle database, and can see the tables in Catalog. However, when I try to add a layer I get "Could not add the specified data object to the map. ...
0
votes
1answer
556 views

Oracle spatial index takes no effect

I am using hibernate spatial 4.0 with hibernate core 4.3, and we are using the oracle 11g with spatial extension. This is the entity and dao: @Entity public class Pts{ @Type(type = "org....
0
votes
1answer
304 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
2answers
116 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 ...
0
votes
1answer
59 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 ...
0
votes
2answers
224 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....
0
votes
1answer
57 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 ...
0
votes
1answer
171 views

Do different RDMS use different SRID's to identify the coordinate system of a spatial object?

I'm looking for a reference that lists a standard SRID for a given CRS. Do RDMS's utilize a standardized SRID, such as OGC? Or is it unique to the RDMS?
0
votes
2answers
803 views

Generate in oracle sql developer a point with specific SRID from two variables

I have created quite often (in posgis) points using two variables from the table (LAT,LON) and setting the desired SRID. I am trying to do something similar now with Oracle SQL developer but I keep ...
0
votes
1answer
2k views

Get WKT from polygon centroid

I have an Oracle Spatial table (in 12c) with a polygon geometry type. I added a text column to the table that I would like to populate with the well-known text of the polygon's centroid. In concept ...
0
votes
1answer
330 views

Using WFS-T when layer dimensions don't match with geometry dimensions

We are able to Delete features from OpenLayers and it is successfully deleting them from spatial table. However we are unsuccessful doing add/edit from OpenLayers and saving the features in the ...
0
votes
1answer
346 views

MapServer with Oracle 12

I'm running MapServer on Windows (with the msplugin_oracle.dll plugin) to create some WMS layers from SDO geometry stored in Oracle 11 database. I take the binaries from this very nice site. The ...
0
votes
1answer
1k views

SDO_GEOMETRY uniqueness in Oracle

Is it feasible converting the spatial property (SDO_GEOMETRY) of a table in Oracle as an unique index or spatial constraint for avoiding spatial duplicates? I am working on point tables and I don't ...
0
votes
1answer
433 views

Create feature class with ArcCatalog in Oracle Spatial without ArcSDE error

I need to create a table/feature class with ArcCatalog 10.2 directly to a Oracle Spatial 11.2 database without ArcSDE, Is it possible? I can execute the create new feature class in ArcCatalog, but ...
0
votes
1answer
463 views

Oracle Spatial Returns Different Intersection Results with SRID Defined

I have a set of points and a set of polygons of which I am performing an intersection on to determine which polygon each point lies in. This was performed previously without the projection being ...
0
votes
2answers
141 views

SQL filter to show one layer only if another layer is missing

I have two oracle tables that represent buildings in my town. The first table represent buildings that are surveyed and measured accurately but doesn't cover all the parts of the town while the second ...
0
votes
1answer
60 views

How to identify a point on Oracle mapView?

I developed an application depend on Oracle Map JS api v1, my application have multilayer, when I click on the map view all FOIs attributes should posted on a div; i.e: I need to identify a point like ...
0
votes
1answer
228 views

Integrate static database with spatial database

I have some questions about how to integrate static database with spatial databases. problematic: I have several static data bases on different platforms (Oracle, MySQL, SQL Server) I want to turn ...