An extension that adds spatial operations to Oracle databases

learn more… | top users | synonyms

0
votes
0answers
26 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
1answer
40 views

QGIS Oracle-Spatial-GeoRaster-Plugin not working

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 ...
1
vote
0answers
52 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
25 views

SRIDs do not match for the two geometries in oracle spatial

I am trying to resolve where some points from Point Geometry lying outside the Polygon geometry. I want to filter those points which are lying outside the polygon geometry. I am getting error where ...
1
vote
1answer
48 views

How to convert a compound geometry (Oracle) to a geometry made of straight line segments only?

I have an Oracle Spatial table containing compound geometries (i.e. geometries containing both straight lines segments and arcs) that I want to project in another reference system. Using SDO_CS....
1
vote
1answer
34 views

Export Line Feature using ogr2ogr.

I am trying to export a line feature class from an oracle spatial database to a file geodatabase. I can export polygons with no problem, but cannot find the appropriate command '-nlt' for Line ...
3
votes
1answer
84 views

ogr2ogr: encoding issues when importing from Oracle Spatial to PostGIS

I'm trying to import some spatial tables from Oracle Spatial to PostGIS using ogr2ogr, but I can't figure out why the special characters on the attribute tables get messed up while I'm doing it. My ...
0
votes
1answer
62 views

Error in the connection to Oracle Spatial from QGIS

I am not being able to stablish the connection to an Oracle Spatial server in QGIS. Apparently I have the connection configured accordingly with QGIS documentation, but it stills gives me an error: ...
1
vote
1answer
43 views

Edits in Oracle Spatial Layers

I have an Oracle spatial layer that is built on top of a multi table view. When I make a new feature in QGIS, I get an error when I attempt to the save the edit. When I look in the database and ...
1
vote
1answer
143 views

ST_GEOMETRY to SDO_GEOMETRY

Is it possible for QGIS to read ESRI ST_GEOMETRY in an Oracle database? The ESRI geometry type looks like this: SDE.ST_GEOMETRY(260,61,491455.9942,5456922.8891,492388.3189,5457507.9101,NULL,NULL,NULL,...
0
votes
1answer
47 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
0answers
48 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 that "Fail to Execute". my date is stored as "10-AUG-15". when is write date ...
0
votes
0answers
80 views

Read 3D polygon from Oracle SDO_GEOMETRY and convert to triangles

History I have written a c# service that consumes a list of x,y,z points from a csv file. These points form a valid 3D polygon which I am able to verify using SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT()...
0
votes
0answers
34 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
39 views

ORA-13356 How to remove redundant points from 3D Polygon

I've created a sdo_geometry column in an Oracle 11.2 database and I've managed to import a list of co-ordinates from a csv file with a c# service that creates a flat Polygon in 3D and inserts into the ...
1
vote
0answers
21 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
25 views

Add layers dynamically on a web map

What would be an optimal way to add a layer to the web map by using the drag and drop option? Should the layer be saved to the db or their are other ways? This would be a JavaScript based application ...
1
vote
0answers
39 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 ...
3
votes
1answer
46 views

Why this query on Oracle Spatial returns null? (Or how to retrieve WKB)

I am begginer 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) ...
2
votes
0answers
49 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 ...
1
vote
1answer
111 views

How geoserver calculates Native Bounding Box from Oracle Layer?

I need to know, how geoserver calculates Native Bounding Box & Lat/Lon Bounding Box. I am publishing a polygon layer from oracle spatial. In my case: Table Records: 7679477 Native Bounding Box:...
3
votes
2answers
91 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
67 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 +...
0
votes
0answers
107 views

How to bind event to Polygon inside polygon in google maps.?

I am drawing a polygon buffer in google maps api v3 and finding number of polygon objects lying inside it.(on click) I am using oracle spatial database. on each child polygon click i need to do some ...
1
vote
0answers
44 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') = ...
0
votes
2answers
87 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 ...
1
vote
0answers
19 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.
0
votes
0answers
40 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: ...
1
vote
1answer
98 views

Add and edit Oracle Spatial Layer in QGIS

When I connect oracle layer are not enabled me all editing options. I can create and delete but not update. It is an issue of users? permissions or privileges? metadata? All works OK in ...
1
vote
1answer
57 views

ArcMap 10.3.1 Editor Message: “A layer for PROJECT_LINES was not found…”

When editing a feature class stored in Oracle Spatial, I am receiving 3 warning messages upon stopping the edit session: There are 2 more after pressing OK - PROJECT_POINTS and PROJECT_POLYGONS. I ...
0
votes
0answers
48 views

GeoServer ImageMosaicJDBC: Result set after last row

I am using the ImageMosaicJDBC to access raster data from an oracle database using ojdbc7. in my log I get the following error: INFO | jvm 1 | 2015/10/28 18:57:22 | 28 Oct 18:57:22 ERROR [...
0
votes
0answers
43 views

Is it possible to use oracle map viewer editor in map viewer javascript api?

I'm new in oracle spatial mapviewer.I want to create a simple webGIS using oracle map viewer and javascript api with editing tool. I read about editor tools In oralce mapviewer documentation but cant ...
1
vote
0answers
42 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 ...
2
votes
1answer
126 views

Why does pyQGIS QgsVectorLayer().isValid() return FALSE with Oracle views?

This works perfectly fine with an Oracle TABLE but not with a VIEW. Why? uri = QgsDataSourceURI() uri.setConnection(host, port, db, username, pw) uri.setWkbType(QGis.WKBPolygon) uri.setDataSource(...
1
vote
0answers
65 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 ...
3
votes
1answer
599 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 ...
0
votes
0answers
49 views

How to create nodes for oracle network analysis?

I'm new in oracle spatial but i know ArcGIS Network analyst.ArcGIS create nodes(Junctions)for routing automatically and uses the nodes in network analyst. In oracle spatial something is different ...
1
vote
1answer
141 views

Upgrading to ArcGIS 10.3 geodatabase on windows R2 SP2 and Oracle 10g (64 bit) 10.2.0.5?

We have Oracle 10g (64 bit) 10.2.0.5 on Windows Server 2008 Enterprise SP2, and we are planning to migrate our geodatabase from 9.3.1 to 10.3. As per Esri "Oracle database requirements for ArcGIS 10....
0
votes
0answers
64 views

Front-end GUI for a spatial database

I'm an intermediate GIS analyst with a vision that I need help executing. I have a team that is constantly distributing back and forth shapefiles of polygons (between 10 and 50 features in each) ...
0
votes
1answer
232 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
0answers
60 views

pl sql: copy Feature class attributes to another Feature Class

I'm new to oracle spatial, and am Trying to copy data from from Arc FeatureClass to another. I have tried the following, but am getting a 'PLS-306: wrong number or types of arguments in call to '...
1
vote
0answers
78 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 ...
0
votes
1answer
153 views

Layer dimensional doesn't match with geometry dimesnions

We are able to Delete feature from openlayer and it is successfully deleting that from spatial table also. However we are unsuccessful doing add/edit on openlayer and save the same in Spatial table. ...
3
votes
1answer
179 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 ...
1
vote
0answers
101 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. ...
0
votes
1answer
734 views

Updating Oracle Spatial geometry column using SQL?

I am trying to update a table B geom column with the coordinates from table A. Table A having coordinates in two separate columns x and y. Table B to have the coordinates from Table A into Table B's ...
2
votes
1answer
172 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 ...
0
votes
1answer
91 views

MapServer with Oracle 12

Atm. 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 ...
1
vote
0answers
155 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 ...
1
vote
1answer
319 views

How to disable spatial index creation by ArcSDE for Oracle Spatial

Working with arcsde 10.1 and oracle spatial 11g. I set the feature class in load_only_io before loading shape files. I am using geoprocessing tool (append) in arcgis to load shape file to ...