An extension that adds spatial operations to Oracle databases

learn more… | top users | synonyms

0
votes
0answers
14 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) ...
3
votes
2answers
752 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
1k views

Why is Oracle Spatial Query Layer Not Displaying in ArcMap?

I am having an issue with an Oracle query layer using SDO_Geometry not displaying. I have created a polygon layer/table within oracle, registered the table with the SDO_GEOM_METADATA and created a ...
1
vote
0answers
18 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 ...
0
votes
1answer
274 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 ...
1
vote
1answer
97 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. ...
2
votes
1answer
338 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
1answer
807 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 ...
1
vote
1answer
31 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 ...
1
vote
1answer
31 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
59 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
31 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
24 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
84 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: ...
0
votes
0answers
42 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
20 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 ...
0
votes
1answer
33 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?
2
votes
2answers
98 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 ...
0
votes
0answers
50 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 ...
0
votes
1answer
279 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
0answers
26 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 ...
4
votes
2answers
1k views

In Oracle Spatial, what is the fastest way to determine the percentage of intersection between two shapes?

I have to query polygons that intersect with one another. Our polygons occasionally contain intersections that aren't intended (meaning just a few vertices cross boundaries). I want to filter out ...
5
votes
2answers
783 views
2
votes
2answers
279 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 ...
1
vote
0answers
17 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 ...
2
votes
0answers
45 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
0answers
22 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
26 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
41 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) ...
1
vote
1answer
85 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 ...
0
votes
1answer
203 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 ...
3
votes
2answers
79 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
53 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
79 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
40 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') = ...
2
votes
2answers
543 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 ...
0
votes
2answers
69 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
18 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
39 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: ...
2
votes
2answers
460 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 ...
0
votes
0answers
73 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
56 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
45 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
30 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
39 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
2k 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 ...
5
votes
0answers
324 views

QGIS: How to reverse vertex ordering in polygons

I am working with an Oracle spatial connection in QGIS through which I am accessing and editing a vector layer. I find that when I edit a geometry, the vertex ordering is reversed (to clockwise in the ...
5
votes
0answers
92 views

Is it possible to add an ArcGIS attachment to a row in Oracle using oracle stored procedures?

So far I have been able to attach files to features within a featureclass using the python tools and ArcObjects. Within Oracle I have been able to add features with geometries using the ST_Geometry ...
2
votes
1answer
100 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) ...
1
vote
0answers
58 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 ...