An extension that adds spatial operations to Oracle databases

learn more… | top users | synonyms

3
votes
1answer
518 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
45 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
120 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 ...
1
vote
1answer
39 views

Spatial and property search

We have a lot of polygons(some of them contain holes) and there are also a lot of points inside different polygon, these data are processed as ESRI geodatabase format. Now we have to do some spatial ...
2
votes
2answers
478 views

Why is too long connecting to Oracle Spatial database from QGIS client?

I am having trouble connecting to an Oracle Spatial data with QGIS client. I use QGIS Version 2.2 (Valmiera) to connect to a database schema in Oracle Spatial. I asked our DBA access to our database ...
1
vote
1answer
127 views

(ms4w) oracle spatilal problem of drawing compound polygon for Oracle 10g

When i draw a compound polygon SDO_GEOMETRY( 2003, -- two-dimensional polygon NULL, NULL, SDO_ELEM_INFO_ARRAY(1,1005,2, 1,2,1, 5,2,2), -- compound polygon ...
0
votes
0answers
59 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
177 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
50 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
1answer
681 views

Intersecting polygons in Oracle

Have a polygon in table 2 with its id, no and geometry. In table 1 I have polygons with the same fields. The polygon in table in intersects with a few polygons from table 1.What I am trying to do is ...
1
vote
0answers
73 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 ...
3
votes
1answer
153 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 ...
0
votes
0answers
214 views

JGeometry to json

I am working on an application which will query the spatial data in the oracle spatial, and I use mybatis at the moment(I can not use JPA), which means I have to convert the object of ...
2
votes
4answers
1k views

Converting arcs to straight line segments?

I have a large number of geometries, currently stored in Oracle, some of which contain arc segments. I need to convert these geometries into LRS (Linear Referencing System) format so I would like to ...
0
votes
1answer
112 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. ...
1
vote
3answers
788 views

Add Oracle Spatial Vector Layer with QGIS 2.0 on Mac OSx

I installed version 2.0 using the recommended mac installer (http://www.kyngchaos.com/software/qgis), and the installation went fine, but there is no option to add an oracle spatial layer (not in the ...
1
vote
0answers
96 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
592 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
150 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
0answers
31 views

proper location to issue spatial queries

we are working in a new geoserver environment backed by oracle spatial. we have db triggers that need to perform spatial queries to maintain business data when spatial data is updated. there is ...
1
vote
1answer
262 views

Use Hibernate with Oracle and Esri St_geometry type

Can anyone tell me whether I could use Hibernate with esri ST_GEOMETRY type? I have found that Hibernate Spatial does support SDO_Geometry, but nothing for ST_Geometry. I am using oracle 11g and ...
0
votes
1answer
82 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
135 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
357 views

Loading Oracle Spatial Layers in standalone python qgis

I used below script to connect to postgres and load layers successfully.I want to aceive this using Oracle Spatial for both vector and raster loading.How can I achieve that?In other words what is the ...
0
votes
2answers
96 views

how to configuring geomajas wih oracle spatial db?

I have just done intial setup of the geomajas project and trying to config its data source with oracle database. I am following the given example for sqlserver and POSTGIS. My oracle layerroad xml ...
1
vote
1answer
61 views

Unable to read different kind of shape files

I have written the java code to read the shapefile and insert it into the table. But the way I have written code it will accept only a multistring .shp file. It fails for other shapefile geometry ...
3
votes
0answers
488 views

No primary key or unique index found?

I have a store created from oracle database in geoserver. Now after I create layer out of the store. And when I try to access the layer or try to preview the layer, I get the warning message in ...
11
votes
3answers
2k views

Future of spatial databases?

It may be a bit off-topic. I am eager to know the industry specific importance of Spatial Databases. Is Spatial Database a very important part of any GIS system? Or will we use other technologies to ...
0
votes
1answer
113 views

Oracle Error 00936 in ArcMap

I am using ArcMap 10.2 and have connected to my Oracle database, and can see the tables in Catalog. However, when I try to add a layer I get "Could not add the specified data object to the map. ...
0
votes
0answers
50 views

Convert spatial table into non-spatial table in Oracle

I want to convert a spatial table, registered with Geodatabase (SDE), into a non-spatial table using SQL Developer, what would it be the most efficient/elegant way of doing it? Obviously, first I ...
0
votes
1answer
133 views

How can I load sqlite file into oracle 11g?

I have SQLite file which I have taken it from Sptialite DB. I need to convert this file into SDO. Plz help me
1
vote
2answers
411 views

SDE connection and multiple schema

I setup an sde connection for Oracle database, where multiple databases are sitting. All databases have same owner, sharing same password but identical user (e.g., BUI, EICU, FRNSW and LPI). While ...
1
vote
1answer
95 views

Load Oracle Spatial Raster using PyQGIS

Able to connect to Oracle Spatial 11g and print tables with SDO_GEORASTER attribute both in QGIS python console and standalone application.I get below error when loading rasters from oracle Table. ...
0
votes
1answer
171 views

Oracle spatial index takes no effect

I am using hibernate spatial 4.0 with hibernate core 4.3, and we are using the oracle 11g with spatial extension. This is the entity and dao: @Entity public class Pts{ @Type(type = ...
0
votes
0answers
82 views

View Oracle GeoRaster in ArcMap

I have imported SRTM DEM into Oracle 11g using FME.The block size is set to 128X128.I am able to view the data in QGIS,Tatuk and play with it using GDAl command line.Unable to view the same in ArcMap. ...
0
votes
1answer
306 views

Tools to export shps from Oracle database

What open source tools could be used to export shapefiles from an Oracle database. I have tried using QGIS but it does crash way too much.
0
votes
0answers
165 views

How to store ArcGIS JSON feature into Oracle SDO Geometry database?

I'm developing in Java. I retrieve a JSON String from an ArcGIS Online Service Area service. I'd like to store the features returned in the JSON String into an Oracle (SDO Geometry) database. Is ...
1
vote
1answer
621 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 ...
3
votes
1answer
1k views

Need Oracle spatial tutorials

I am working on Oracle spatial 11g and I am referring to Oracle docs as a learning resource. Does anyone know any more Oracle Spatial tutorials ? We want to integrate Oracle Spatial data with ...
0
votes
2answers
321 views

oracle search against intersect of a region that covers the whole world doesnt find any records

I am new to Oracle Spatial, I am trying to implement a service that will take coordinates from a map, and search our database to find any geometries that intersect with that map view. I works fine for ...
1
vote
0answers
144 views

ArcMap vertex problem for Z-value

I have an Oracle Spatial dataset with z-coords. I can edit the dataset in ArcMap however the z-values are always rounded to the nearest integer. Why does ArcMap round the z-values?
2
votes
3answers
627 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 ...
0
votes
1answer
196 views

Oracle Spatial Returns Different Intersection Results with SRID Defined

I have a set of points and a set of polygons of which I am performing an intersection on to determine which polygon each point lies in. This was performed previously without the projection being ...
1
vote
1answer
1k views

How to merge/union non contiguous polygons using Oracle Spatial functions

Is there any way of merging non contiguous polygons using the SDO_AGGR_UNION or a similar dissolve function? When i run the below query in oracle sql developer i managed to convert geometry type from ...
2
votes
0answers
82 views

SQL server in ArcGIS 10.2 Desktop

I am using ArcGIS 10.2, and previously using Oracle spatial as back end. Now the data providers have shifted to SQL providing core data using FTP which is being staged at SQL server. We need to ...
1
vote
1answer
89 views

Best way to store raster data with Java into Oracle spatial

I have a Java application that processes raster data. At the end of the process I plan to store the raster in oracle spatial. What is the best way to do this? I had a look at geotools but I did not ...
0
votes
1answer
433 views

Creating a layer in arcmap by dragging a table from an OracleDB

I am working on a project for a client, they gave us some data from their oracleDB, and when I connect to it in arc map I can just drag and drop the tables from the catalog window into arcmap and they ...
1
vote
1answer
46 views

Raster: how to locate cells having nodata

I am new to oracle spatial. I am using SDO_GEOR package's getNoData prcedure. the results are populated in following format. MDSYS.SDO_RANGE(MDSYS.SDO_RANGE(-32768,null)) My questions are: Is ...
1
vote
1answer
147 views

Connecting Oracle Linux database to AcGIS 10 on windows PC

I am wondering if anyone has tried to connect from ArcGIS 10, to an oracle database stored on a Linux server? I have no problems connecting to oracle from Arc when the data is stored on a windows box, ...