An extension that adds spatial operations to Oracle databases

learn more… | top users | synonyms

2
votes
1answer
794 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 ...
0
votes
1answer
23 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 ...
3
votes
2answers
746 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 ...
1
vote
1answer
26 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
45 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 ...
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 ...
0
votes
1answer
26 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: ...
0
votes
1answer
264 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
23 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
322 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. ...
1
vote
1answer
64 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
38 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
14 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
29 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
97 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
40 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
264 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
22 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
777 views
2
votes
2answers
265 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
15 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
44 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
20 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
22 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
38 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
71 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
197 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
75 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
47 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
69 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
37 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
526 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
62 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
38 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
455 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
66 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
43 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
28 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
311 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
91 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
93 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
53 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
479 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
228 views

Automating Mastermap update in Oracle Spatial?

I've been set a challenge which is a bit out of my comfort zone. I'm an esri developer trying to break into the open source world. I've been asked to automate the update of some oracle SDO datasets. ...
0
votes
0answers
43 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 ...