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
1answer
1k 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
1answer
448 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 ...
0
votes
1answer
490 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 ...
0
votes
2answers
142 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 ...
0
votes
1answer
65 views

Identifying point on Oracle mapView

I developed an application depend on Oracle Map JS api v1, my application have multilayer, when I click on the map view all FOIs attributes should posted on a div; i.e: I need to identify a point like ...
0
votes
1answer
280 views

QGIS and Oracle Spatial database - rule based system in future version?

I (a geographer not to familiar with IT stuff) want to start a pilot with QGIS at a municipality I work for. We store our data in Oracle databases. When trying to open these databases (QGIS 2.2) using ...
0
votes
1answer
238 views

Integrate static database with spatial database

I have some questions about how to integrate static database with spatial databases. problematic: I have several static data bases on different platforms (Oracle, MySQL, SQL Server) I want to turn ...
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
194 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
616 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
564 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
14 views

LRS m dimension data view

I have generated 3D with LRS data using oracle spatial and trying to view in QGIS but it doesn't read that table from oracle database i did another try is that without 3D generated LRS in oracle ...
0
votes
1answer
37 views

Are spatial queries possible using Python and cx_Oracle?

I am trying to execute a spatial query on an Oracle spatial table via python using the cx_Oracle package. I can make generic queries successfully, but when I try anything involving a geometry or ...
0
votes
0answers
65 views

Export a layer from QGIS to Oracle DB

I have a working connection to an Oracle database in QGIS (3.4). I am able to import and edit existing tables into my QGIS project out of the db. Unfortunately it is not possible to export any QGIS ...
0
votes
0answers
37 views

Query result showing unsupported data type

When I use this code: SELECT SDO_GCDR.GEOCODE_AS_GEOMETRY ( 'SPATIAL', SDO_KEYWORDARRAY ( '3746 CONNECTICUT AVE NW', 'WASHINGTON, DC 20008' ), 'US' ) geom ...
0
votes
0answers
19 views

Oracle WMS GetFeatureInfo issue with points and lines

I am trying to do GetFeatureInfo request on MVDEMO sample data. When it comes to polygons, it is working fine: When I do the same type of requests on lines or points, I get an empty response: As you ...
0
votes
0answers
30 views

Set Valid Time for Oracle Workspace Manager in QGIS

I am trying to utilize the workspace functionality in QGIS. Entering a workspace via the connection parameters is not an issue. The issue is the valid time is always the current system time the edit ...
0
votes
1answer
29 views

Does SDO_WITHIN_DISTANCE also return points inside a polygon?

Using Oracle Spatial Database, just wondering if the SDO_WITHIN_DISTANCE returns points inside a polygon, not just within a certain number of metres from the boundary. I've already checked the ...
0
votes
0answers
7 views

Can't initialize topology in Autodesk Industry Model 2017

Im facing difficulty trying to initiate my Industry model topology, i always get the error of cannot write _tisl with sql loader, i tried to clean the lines but no luck, i dont know what to do im ...
0
votes
0answers
30 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
131 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
51 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
66 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
22 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
1answer
133 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
115 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
220 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
54 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
86 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
81 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
167 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
42 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
62 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
40 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
85 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
982 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
360 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
124 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
385 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
39 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
113 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
131 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
983 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
230 views

Connecting Oracle and ArcGIS for Desktop? [closed]

How can I Connect between Oracle 64 bit 11g and Arcgis 10.1?
-1
votes
1answer
318 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 ...

1 4 5 6 7 8