Questions tagged [oracle-spatial]

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

Filter by
Sorted by
Tagged with
3
votes
1answer
3k views

Can I create an Oracle Spatial View from a non-spatial table?

Let's say I have an Oracle database table with latitudes and longitudes. I don't have access to modify the schema of this table, or even create tables. However, I can create views and indexes on those ...
3
votes
1answer
564 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 ...
3
votes
4answers
1k views

Shapefile import with Oracle + GeoServer produces points instead of vector shapes

I have implemented the example at http://www.gistutor.com/openlayers/22-advanced-openlayers-tutorials/47-openlayers-wfs-t-using-a-geoserver-hosted-postgis-layer.html and got it working properly. Now ...
3
votes
2answers
198 views

Do I need to use ESRI's Create Spatial Type functionality

Does anyone know if I need to use ESRI's Create Spatial Type functionality when creating a field in a non ESRI / non geodatabase Oracle 11g database? I have an older customer database in Oracle. ...
3
votes
1answer
3k views

Update a table with values from coordinates on GEOMETRY in Oracle

I have 2 columns in a table that represent the X and Y coordinates. The values in those columns don't match the actual coordinates and I want to update them with the coordinates values that are ...
3
votes
1answer
2k views

Using primary keys with ArcSDE (Oracle)?

Is it possible, more advisable to assign a primary key to the OBJECTID column in a featureclass in SDE. I am using Oracle and some of my flat tables (junction tables) need to SEE a primary key in the ...
3
votes
2answers
1k views

Does Oracle Spatial calculate geodetic distance?

I've got to migrate a PostGIS database to Oracle Spatial, and am stuck on a problem: In a view, I have a column that amounts to ST_Distance(geography(geom_1), geography(geom_2)), effectively ...
3
votes
1answer
496 views

What is the C# Arcobject I must use in order to set programatically the SQL Query of an LYR file?

I would like to change programatically the SQL Query of a LYR file. I'm developping in C# using ArcObject. Actually I'm able to get an instance of IWorkspaceFactory from an opened layer with this ...
3
votes
3answers
7k views

How to convert geometry coordinates into Google lat/lons?

For storing geospatial data, the geometry field is used in SQL Server or Oracle Spatial. I want to know is there any way where we can convert this geometry field into a set of latitudes and longitudes....
3
votes
2answers
653 views

Seeking common interface for ST_Geometry SDO_Geomtry

I've worked a fair bit with Oracle Spatial and I've had some requests to transition to PostgreSQL Spatial. Is there a common interface for SDO_Geometry and ST_Geometry? I'm working in Java with ...
3
votes
1answer
465 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 ...
3
votes
1answer
4k views

Connecting to Oracle database with ArcGIS for Desktop?

I installed ArcGIS 10.2.2 ,oracle 11g R2 personal edition and it's client.I try to connect to the database using database connection in ArcMap but the error Failed to connect to the specified ...
3
votes
1answer
554 views

How are orphan gsrvr.exe processes created?

I just inherited a server running SDE application server 10.1 against an Oracle 11g database. I'm finding that many connections are not getting properly dropped and stay on as Orphans. Eventually the ...
3
votes
2answers
235 views

Buffer multiple roads to find points within and compare?

What I am trying to do is buffer a main st and a side street and get all of the points that intersect that buffer, however they need to be mutually exclusive. In the example below, my results would ...
3
votes
1answer
642 views

Moving Versioned Data between different geodatabases

Can you please let me know how to migrate feature class which is registered as version and archiving is enabled on it From: Database Environment: ArcSDE 9.3, RHEL 5, Oracle 11.2.0.2 To Database ...
3
votes
1answer
604 views

Load PostGIS or Oracle Spatial Raster Layer using PyQGIS

How do we load Rasters stored in PostgreSQL-PostGIS or Oracle Spatial 11g into QGIS using PyQGIS? I am able to load vector layers from Oracle 11g with below code. What changes are necessary to add ...
3
votes
1answer
536 views

Using st_geometry functions inside query statements in ADO.net?

I have ArcSDE 10 and Oracle 11g installed on my Windows server 2003. And i am trying to query tables having st_geoemtry columns.and i have got the results when i am querying from SQL Developer, and ...
3
votes
1answer
638 views

TO_DATE query on ArcSDE for Oracle dataset failing?

I'm trying to use TO_DATE to query an Oracle SDE dataset. It's not working in the javascript API application so I tried to query the rest end point directly and I get the error: "Unable to perform ...
3
votes
2answers
946 views

Oracle Linestrings and MultiLinestrings

We have a very complicated setup for a project we are doing, and it involves 40+ developers and two oracle databases, one with sde and one only with oracle spatial and it's quite big. We'll here are ...
3
votes
1answer
470 views

How do I get a list of coordinates from a polygon?

I have a table with polygon geometries and need to get a list of polygon vertices. Using select sde.st_astext(geometry_column) from table_name; I can get the WKT representation of the polygon but I'd ...
3
votes
1answer
613 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) ...
3
votes
1answer
231 views

Why is query to retrieve WKB on Oracle Spatial returning null?

I am beginner on GIS, and I have loaded a shapefile to MSSQL, PostGIS and Oracle Spatial (11g) On both MSSQL and PostGIS I could create a query to return me the WKB from the table (geometry field) ...
3
votes
2answers
28k views

Error:The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception

I am developing custom geoprocessing tool (class-library project) on ArcGIS 10.2. This project uses Oracle.DatAccess from ODP.NET 1.0 . This is a simple tool which queries - oracle 10g database and ...
3
votes
3answers
1k views

Fastest way to join points table to polygons tables in ORACLE

I have two tables in 11g oracle db, one with points geometry, one with polygons. Currently I need to enrich the points table daily with the name of the polygon (country) that the point is inside, but ...
3
votes
2answers
1k views

Convert non-spatial Oracle table to spatial Oracle table in a different database

I'm trying to use ogr2ogr to convert data from a non-spatial table (has X & Y values) in an Oracle database (1) to a spatial format in a different Oracle database (2). This will be scheduled to ...
3
votes
1answer
637 views

Resolving ArcSDE for Oracle 11g Layer not found (-20) error?

I am using ArcSDE for Oracle 11g, with Oracle spatial database. I use the sdelayer command ot register my feature class. Surprisingly I get this error of Layer not found(-20) error. The table does ...
3
votes
1answer
956 views

Making calls the PostGIS functions with Java

We have Java stored procedure in Oracle that make calls to functions offered by Oracle Spatial to perform spatial analysis and return results. I am looking to the same in PostGIS, is this possible?
3
votes
2answers
2k views

Cannot spatially select from Oracle view based featurelayer in ArcMap

I'm hoping someone has seen this before and has a solution. I've exhausted all my ideas. I having problems with the selection and identify tool in ArcMap. I have a point feature class, zlevels, ...
3
votes
0answers
60 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),...
3
votes
2answers
550 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 ...
3
votes
0answers
479 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....
3
votes
0answers
517 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. ...
3
votes
0answers
116 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
320 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
164 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
1k views

Changing workspace path of query layer using ArcPy? [closed]

I'm trying to change the workspace path of a query layer using the code below and it always breaks. The layer is connected to a view in an Oracle Spatial 10g database. The database is SDE enabled ...
3
votes
0answers
617 views

Geodatabase Connection to Oracle Active Data Guard Standby

ENVIRONMENT Database Server: Oracle 11.2.0.2.0 Single-Instance Database on Windows Server 2003 R2 Enterprise 64-bit Oracle Active Data Guard for Oracle Database 11g R2 ArcSDE for Oracle 11g 9.3.1 ...
3
votes
0answers
863 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 ...
3
votes
0answers
276 views

Does QGIS Server support QGIS project with Oracle layers? [closed]

QGIS recently got native Oracle support. I was wondering if QGIS Server supports generating WMS and WFS from a QGIS project with Oracle Spatial layers. I just tested this but I did not succeed...
3
votes
0answers
2k views

Error opening feature class from SDE (which can be opened in another application)

We're using ArcGIS 10.1 with ArcSDE 9.3.1 on Oracle 10g. I've got two layers that cannot be opened or modified with ArcCatalog or ArcMap (but they show up in the list. Everything worked just fine ...
2
votes
2answers
2k views

Creating spatial view from materialized view?

I have a materialized view that runs nightly and performs an intersection of point locations and polygons. The materialized view works as designed and returns the desired results. It contains ...
2
votes
3answers
2k views

What are the differences between 81989 and 27700 CRS for the British National Grid?

We are using Oracle Spatial to run point in polygon queries in Great Britain using Ordnance Survey MasterMap and point data. MasterMap is on British National Grid (BNG) and has the Coordinate ...
2
votes
1answer
1k 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 ...
2
votes
2answers
1k views

is it possible to store empty geometries in an Oracle Database?

I'm trying to fix a GeoTools issue but I'm running into problems putting empty geometries into my Oracle database. Basically executing: select SDO_UTIL.FROM_WKTGEOMETRY('POINT EMPTY') from ...
2
votes
1answer
701 views

How to register table with geodatabase with a command line?

Is there a way to register with geodatabase a table stored in an Oracle 11g database, without using ArcMap or Python script? I'd like to do it with a command line like when registering with ArcSDE (...
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
196 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
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) . ...
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
957 views

Transferring data from PostGIS to Oracle Spatial

I would like transfer spatial data from PostGIS to Oracle Spatial. I want to use Python's modules psycopg2 and cx_oracle. Transfer Oracle > PostGIS is OK, but in opposite version I have problem with a ...