An extension that adds spatial operations to Oracle databases

learn more… | top users | synonyms

0
votes
1answer
19 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
39 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 a opened layer with this code ...
1
vote
0answers
53 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
49 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
20 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
25 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 ...
0
votes
1answer
29 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
40 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 ...
0
votes
1answer
90 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
50 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 ...
0
votes
0answers
30 views

GDAL/OGR C++: How to connect to SQL

Using GDAL 1.11 it is possible to execute SQL commands against a OGRDataSource: But how do I connect the OGRDataSource to a SQL Database? In my case an Oracle XE 11g. I suppose the OCI drivers have to ...
0
votes
2answers
55 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 ...
0
votes
1answer
52 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
1answer
64 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
41 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
71 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
0
votes
1answer
83 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 ...
1
vote
1answer
54 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
2answers
90 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 ...
0
votes
1answer
79 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
37 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
85 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.
1
vote
0answers
32 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 ...
0
votes
0answers
84 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 ...
0
votes
0answers
70 views

ArcMap Query Layer with Oracle On The Fly Geometry

I can successfully create Query layers in ArcMap pulling from Oracle 11g - as long as these query layers are pointed at tables with a spatial index on the geometry column. Things don't go so well ...
0
votes
0answers
19 views

gvNix over Jboss and Oracle

Hi I´m testing this project integrated with Spring Roo. I have read documents about this configuration but I only can run it over Tomcat 7 and Postgis. Has anybody tested it over Jboss (EAP 6) and ...
1
vote
1answer
150 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 ...
1
vote
1answer
166 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 ...
2
votes
1answer
136 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. ...
0
votes
1answer
114 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
0answers
58 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
56 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 ...
3
votes
0answers
34 views

Is it possible to add an ArcGIS attachment to a row in Oracle/SDE 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 ...
1
vote
1answer
35 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
89 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, ...
1
vote
0answers
51 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 contour from point geometry show it on map (using mapserver) to site. Pleas share ...
0
votes
0answers
53 views

Connect mapserver with oracle spatial

I install mapserver using osgeo4w. Now, how can i set connection between mapserver and oracle spatial? sorry for bad english. help me.
0
votes
2answers
75 views

SQL filter to show one layer only if another layer is missing

I have two oracle tables that represent buildings in my town. The first table represent buildings that are surveyed and measured accurately but doesn't cover all the parts of the town while the second ...
2
votes
0answers
38 views

How to efficiently drape vector data over a DTM

I have ~100 million 2d vector topographic features (lines and polygons) in an Oracle 12c database. I have 20 billion xyz points in an Oracle database table as number types - the points cover the same ...
1
vote
1answer
162 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
0answers
143 views

Storing 3D Oracle sdo_geometry objects with a 2D SRID

I'm trying to understand the implications of storing 3-dimensional sdo_geometry values in Oracle when the geometry's SRID is a 2-dimensional system. The database I'm studying uses SRID 4326 (WGS84 ...
2
votes
1answer
217 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 ...
2
votes
2answers
89 views

connect ArcGIS server with different instances of oracle database

Is it possible for a development team to have personal oracle database instances, for testing purposes, connected with the same GIS server? In other words I want every user to work with his own data, ...
0
votes
1answer
109 views

Error configuring Oracle datastore in GeoServer

I want to configure an Oracle datastore in Geoserver so I copied gt2-oracle-spatial-2.3.1.jar and ojdbc14.jar into GeoServer webapp (in WEB-IF/lib folder); then I restarted and try to create new data ...
1
vote
2answers
129 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 ...
3
votes
2answers
91 views

Buffer multiple roads to find points within and compare?

What I am trying to do is buffer a main st and a side street and get all of the points that intersect that buffer, however they need to be mutually exclusive. In the example below, my results would ...
0
votes
0answers
27 views

What is the workflow to add more records from CSV files to a point feature in Oracle Spatial?

We have some GPS data in CSVs to export to existing features in database schema. The CSVs have the same attributes columns, as that of the tables in ORACLE (missing objectIDs, geometry and globalID). ...
0
votes
0answers
21 views

Mapbuilder can't see nvarchar2 to use it in info columns

When I open mapbuilder and create a theme, I want to create ifo columns alias, like block name, block code, but the fields which datatypes are nvarchar2 does not apears in the list to add it to the ...
0
votes
0answers
31 views

Formula to know if LINE intersects with MBR

I have a table with four columns: SRC_X, SRC_Y, DST_X, DST_Y. (SRC_X,SRCY) have position of the start point of a LINE, (DST_X, DST_Y) have position of the end POINT of a LINE. I know there are ...
0
votes
2answers
512 views

How to improve performance of Oracle Spatial function sdo_aggr_mbr

I experienced bad performance when using the sdo_aggr_mbr function on a data set of more than 1 million rows, I had to terminate the operation after several minutes. The statement was: select ...