Questions tagged [oracle-spatial]

Use for questions about the Spatial or Locator extensions to the Oracle DBMS

Filter by
Sorted by
Tagged with
0
votes
2answers
1k views

Adding Oracle Spatial View as Layer in QGIS?

Is it possible to add an Oracle Spatial View on QGIS MAP? My view is registered on MDSYS metadata but, when I connect with Oracle DB, it is disabled on the list. QGIS Desktop 2.2.0 Oracle Database ...
0
votes
1answer
191 views

How to change a schema name within a MXD with ArcObject .NET?

I have a MXD file where all layers point to an Oracle Spatial database. Recently our DBA changed the schema name. So now my MXD file has broken links, each time I open it, all my layers have a ...
0
votes
1answer
613 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 ...
0
votes
2answers
95 views

database using arcgis [closed]

i want to know, can arcgis software do the database such as oracle or ms access?? for example, create own database and form?? and can the database in arcgis read the programmer program such as from ...
0
votes
2answers
1k views

How to find overlapping polygons within a multipolygon (Oracle spatial)

I am working with Oracle spatial and have a table with MULTIPOLYGONS. How can I find the database entries where the polygons of a multipolygon overlap - within the same geometry? So, a function that ...
0
votes
1answer
557 views

GeoTools Oracle spatial plugin samples / documentation

I plan to use GeoTools and I saw that there is an Oracle plugin available, but the documentation is not very detailed. Are there any examples or documentation available to access the functionality of ...
0
votes
0answers
21 views

Unsupported data type for column geoloc

I can open the layer on QGis but in MapInfo I got that error. I already have other layers I can open without any problem, is just with one I get this error.
0
votes
0answers
15 views

Inserting polygon shape to Oracle Spatial using C#

I am trying to insert a polygon shape into an Oracle Spatial database. My polygon is made of more than 1000 vertices. I initially tried creating SDO_GEOMETRY object using MDSYS.SDO_GEOMETRY(2003, ...
0
votes
0answers
58 views

Connecting Oracle Database 11g in ArcMap?

I installed Oracle Database Enterprise Edition 11g(11.2.0.1) in my machine. And I installed ArcMap Desktop 10.3.1 on another machine. Whenever I am trying to create a direct connection of Oracle DB ...
0
votes
0answers
48 views

Transfer indexed Oracle geoloc table to PostgreSQL using ogr2ogr

I am copying tables using ogr2ogr from Oracle to PostGIS using ogr2ogr -f "PostgreSQL" PG:"host=<host> port=5432 user=<user> dbname=<dbname> password=<pwd>" OCI:<USERNAME&...
0
votes
0answers
51 views

Spatial intersection of features (Oracle Spatial) with a line stored in a local gml file?

Interesting sites are stored as polygon features are stored in an Oracle Spatial read only dB. I have a local GML file containing a line (EPSG:31370 - corresponding to a trajectory over a couple of ...
0
votes
0answers
21 views

Does the GeoWebCache listen to the table updates and then update tiles?

My GIS Application uses a GeoWebCache backed by Geoserver. On the database side, I use Oracle Spatial. When data gets modified/ added to the table, Does the GWC keep listening to the table to update ...
0
votes
0answers
22 views

What is the underlying algorithm of sdo_sam.spatial_clusters in Oracle?

Oracle has a "sdo_sam.spatial_clusters" function for spatial clustering. What is its underlying algorithm? Unfortunately the Oracle docs do not mention the algorithm or describe in which way the ...
0
votes
1answer
113 views

Using Google Encoded Polyline Algorithm Format with Oracle Database

Google's Encoded Polyline Algorithm Format is implemented in several GI tools. PostGIS e.g. has ST_AsEncodedPolyline and ST_LineFromEncodedPolyline functions. In contrast, Oracle Database has no ...
0
votes
0answers
84 views

One or more objects failed to paste. Underlying DBMS ORA-00932 : inconsistent datatype

I am migrating all data from a geodatabse oracle to a new oracle schema. I'm trying to copy / paste between the two db connections, but it stops in the middle of the operation by displaying the ...
0
votes
0answers
64 views

Speeding up Oracle Spatial intersection query and indexes

I have about 300 000 records (worksites) in a table (S) with id (id_s), start_date, end_date (and in some cases an authorisation date - AUTH_START). I have a second table containing the id of 500 of ...
0
votes
0answers
102 views

Query Feature Class from Oracle table with no geometry column

Using ArcMap 10.4.1 I am trying to create a query layer from an Oracle table (Oracle info at bottom). The table has no geometry column, but has x and y coordinates as double and I am trying to create ...
0
votes
1answer
183 views

GDAL ogr2ogr OracleSpatial to Shape: Multipolygons with wholes/multiparts are missing

We're holding geodata in an Orcale database (11g) with spatial extension. I want to unload specific polygons and convert them into Shape for further local processing. The table where I'm unloading ...
0
votes
0answers
51 views

Table sde.state_lineages extremely slow

I'm running a ArcGIS 9.3 Oracle SDE geodatabase. Our ArcMap client is extremely slow at displaying versionned feature class. One table seems to be impacted : sde.state_lineages A simple SELECT * FROM ...
0
votes
1answer
25 views

Releasing user-schema locks when updating user-schema

Putting together a scripted event where we update user-schema (prod) in one sde instance from a dev user-schema instance. Both sdes are Oracle 12c. Replication is not used and the destination ...
0
votes
0answers
80 views

Oracle 11g aliases that work in ArcMap 10.4

I am getting this error shown in the picture when I try to export a database view into a GDB table in ArcMap 10.4. I know what is causing the error, its the double quotes I use to create alias names ...
0
votes
1answer
79 views

Oracle Locator Features

I have a road network (in shapefile) which is in a projected system (e.g. EPSG:2100). I also have a number of GPS files in WGS84. I have already stored the data into Oracle 12c (Oracle Database 12c ...
0
votes
0answers
147 views

Saving to database on OpenLayers map changes? [duplicate]

I have put a map on website using OpenLayers. This map is fetched from geoserver by using wms request. and in the same way, it is drawn some shapes such as point, line etc. using open layers library ...
0
votes
0answers
35 views

How to Drop Indexes on a Table in ArcCatalog

I am using an Oracle 11g database . The code below doesnt allow me to drop indexes on a table. import arcpy # Remove indexes and statistics for gis feature class delta tables COND=r'E:/...
0
votes
0answers
52 views

Understanding results of sdo_cs.determine_chain

I run this query: select sdo_cs.determine_chain(null, null, 3087, 4326) from dual; This is the result: MDSYS.TFM_PLAN(MDSYS.SDO_TFM_CHAIN(3087,-1,4152,-2,4326)) How should I interpret the -1 and -...
0
votes
0answers
30 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 ...
0
votes
1answer
73 views

ESRI oracle multi editor schemas

Solution: The limitations of the Esri + Oracle (per 12c) were the cause. 12c Oracle will allow for Multi-Tenant DB, allowing us to have multiple SDE GeoDB as we need. This will meeting the need for ...
0
votes
1answer
893 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
0answers
347 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 ...
0
votes
0answers
116 views

View With SDO_GEOM Function for ArcMap

I have a table of boundaries(polygons) which need to be served up through ArcGIS Server with their centroids(points). I'm using Oracle spatial and thought the most efficient way of doing this was to ...
0
votes
0answers
378 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
0answers
38 views

How to model multiple topology classes in one query with ArcGIS

We have a lot of geographic data with different geometry type in our application, which are persisted in the Oracle 11g database with ST_Geometry supported by Arcgis SDE 10. The features can be ...
0
votes
0answers
109 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
0answers
56 views

How do I synchronize field properties with the database properties?

I have a feature class with a property that is out of sync with the database table. The field property is "Allow NULL values" and it's currently set to "No". Earlier today, before I was aware of this ...
0
votes
0answers
130 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
0answers
947 views

Export to Oracle using QGIS

I have loaded a shapefile into QGIS and I now want to export it into our Oracle Database and add SDO_GEOMETRY. Is it possible to do this directly in QGIS? If not, what opensource options do I have to ...
-1
votes
1answer
142 views

Issues while changing ArcSDE from a Workgroup to Domain Environment

Our organisation was a having a multi-user Geodatabase ( ArcSDE 10.1 gateway on an Oracle 11 g DB) in a Workgroup configuration. The type of Authentication for DB connection was "Database ...
-1
votes
1answer
228 views

Connecting Oracle and ArcGIS for Desktop? [closed]

How can I Connect between Oracle 64 bit 11g and Arcgis 10.1?
-1
votes
1answer
310 views

Creating OVF file for connecting Oracle and QGIS [closed]

I'm trying to create an OGR file that can be opened in QGIS that pulls in vector data from an Oracle Database. I've tried a few combinations of things but can't seem to get anything to work. I've few ...
-2
votes
1answer
35 views

Can Oracle store contours? [closed]

I have contours generated in ArcGIS and now it is in a file geodatabase. We need to share it with another application in our company that is using Oracle. Can Oracle without SDE store contours? And ...
-3
votes
1answer
548 views

Bentley DGN format to Oracle Spatial [closed]

Did anyone ingested the DGN (all versions) to Oracle Spatial?
-4
votes
1answer
80 views

Connecting ArcGIS for Desktop to Oracle without ArcGIS for Server? [duplicate]

Is it possible to connect ArcMap to Oracle without ArcGIS for Server?