Questions tagged [oracle-spatial]

An extension that adds spatial operations to Oracle databases

Filter by
Sorted by
Tagged with
1
vote
2answers
600 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
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. ...
4
votes
1answer
353 views

How to get image pop ups in QGIS using oracle blob field with image?

I have a point feature in oracle database which has as attribute a blob field that have image inside for every point feature taken in field. Is there anyway that i can decode and display it on a ...
1
vote
1answer
195 views

MapInfo Styles in Oracle Spatial Database

I have geographic data in an Oracle database. The data was imported by EasyLoader, which is a MapInfo-Tool. I want to publish this data in a Web Map Service. I have tried to use MapServer, but I have ...
2
votes
0answers
128 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 ...
1
vote
2answers
943 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 ...
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 ...
1
vote
1answer
71 views

How to read oracle not spatial data using pyqgis

I'm working on a QGIS plugin. I'm trying to join a vector layer and a non-spatial table both in Oracle spatial. I add the vector layer to the map, but I can not add the table without geometry so i ...
0
votes
0answers
25 views

ArcGIS export data in Shape from Oracle [duplicate]

I connected my Oracle database to ArcGIS and added one layer to map. This layer has points and polygons. I make a selection in this layer and get 9508 selected features, which I want to export as ...
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<...
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: ...
1
vote
1answer
133 views

request postgis to oracle sdo

My request in postgis : create table "schema1"."table1" as select p.field1 ,p.field2, l.field3, l.id from "schema1"."table2" p inner join "schema1"."table3" l on (p."GEOM" && l."GEOM" and ...
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 ...
3
votes
1answer
517 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) ...
1
vote
1answer
286 views

QGIS doesn't display compound polygon (from a spatial oracle DB)

When I want to display the elements stored in a spatial oracle DB, the compound elements aren't display. There is no error message. The type of these compound elements is "1005". Are these elements ...
2
votes
0answers
218 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
283 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 ...
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
1answer
250 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
964 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
214 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 ...
5
votes
1answer
743 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
829 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
206 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 ...
2
votes
1answer
3k 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
168 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?
1
vote
0answers
354 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 ...
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 ...
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 ...
3
votes
1answer
216 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) ...
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 ...
1
vote
1answer
584 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
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 ...
2
votes
1answer
560 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 +...
1
vote
0answers
111 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
781 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
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.
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 ...
1
vote
1answer
768 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 AutoCADMap3D ...
1
vote
1answer
68 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 ...
1
vote
0answers
112 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 ...
4
votes
2answers
832 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
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 ...
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 ...
1
vote
1answer
225 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
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 ...
1
vote
0answers
236 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
327 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 ...
3
votes
1answer
475 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 ...