A commercial relational database management system.

learn more… | top users | synonyms

1
vote
0answers
13 views

Loading and using 600k+ entities (from Oracle DB) in QGIS?

I'm new to QGis and working on some land register's datas. I tried to load an Oracle spatial layer, but with more than 600k rows, it took a very long time to process, when it didn't crash. After the ...
0
votes
1answer
10 views

SDO_GEOM.RELATE DETERMINE says 'EQUAL' but doesn't return TRUE in the where clause

The following query returns 'EQUAL' for the geometry-relation : select a.g3e_fid , b.g3e_fid , SDO_GEOM.RELATE( SDO_CS.MAKE_2D( a.g3e_geometry), 'DETERMINE', SDO_CS.MAKE_2D( b....
0
votes
1answer
23 views

Oracle versioned geodatabase feature class field value update on multiple versions

I have an Oracle enterprise geodatabase with multiple versions. In one field value of one point feature class I need to change all features within all versions. I have more than 50 versions. Is ...
0
votes
0answers
30 views

What is the ogr2ogr syntax for exporting from Oracle to Spatialite?

I want to export data from Oracle to spatialite, 3 tables with geometry and 1 attribute table. Alternatively, I already have this data written out nightly using ogr2ogr, but the output location is a ...
3
votes
1answer
64 views

Get the geometry type of an empty ArcSDE feature class

I'm trying to use raw SQL to get the geometry type (e.g. POINT, LINESTRING, POLYGON) of an Oracle ArcSDE feature class using the ST_Geometry spatial type. If I run SELECT SDE.ST_GeometryType(SHAPE) ...
0
votes
0answers
36 views

Create additional 'fields' in GDB domain system table (GDB_items)?

Is it possible to create additional 'fields' in the geodatabase domain system table (GDB_items) in SDE 10.3/Oracle? It would be handy to store additional information in domains. For example: CODE [...
1
vote
0answers
18 views

What are “DR$XMLDOCIX1” tables in ArcSDE? [closed]

I was wondering if anyone knows what these tables are in SDE? I'm working in an ArcGIS 10.1 environment, Oracle 11gR2 database.
1
vote
0answers
77 views

Career after GIS Analyst [closed]

I am 23 years old. BSC.IT Graduate, and currently working as a GIS Analyst in Mumbai for last 1.5 years. I am planning to do SQL Certification followed by Oracle. Would it be helpful? I am interested ...
0
votes
0answers
132 views

Receiving Error ORA-0094 B Invalid identifier when try to reconcile versioning in ArcSDE for Oracle?

I have one Edit child version and one default parent SDE version. When I try to reconcile from Edit version to SDE default version this error is coming. Error ORA-0094 B Invalid identifier I am ...
0
votes
2answers
35 views

GeoTools getFeatures takes forever

I wrote the following method as an onClick handler. First and second click, I got result from DB. By the third time, the code stopped in the "getFeatures(trgtFilter)" line and didn't return. In debug ...
0
votes
0answers
29 views

Esri ST_Geometry function to make line from points

I'm attempting to write a SQL statement that joins two point feature classes, both in an Oracle ArcSDE geodatabase using ST_Geometry, and selects a line geometry connecting the points of each ...
3
votes
1answer
59 views

Is it possible to display foreign tables (Oracle to PostGIS) in QGIS?

I have used oracle_fdw to create a foreign data wrapper in my PostgreSQL database to connect to my Oracle database and retrieve foreign tables from the Oracle database into my Postgres database. This ...
0
votes
0answers
68 views

Accessing array of x,y coordinates stored as MDSYS.SDO_GEOMETRY / PUBLIC.SDO_GEOMETRY attribute in Oracle 11g?

I am totally new to GIS. I am working with a table in an Oracle 11g database. In each row of this table there are two attributes of interest: one is of type MDSYS.SDO_GEOMETRY and the other PUBLIC....
0
votes
0answers
29 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 ...
2
votes
1answer
42 views

How can I access information about ArcSDE historical markers via arcpy or SQL

I would like to be able to access the list of historical markers that is presented by in the "Change Version" dialog in ArcMap - https://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/...
3
votes
1answer
95 views

Deleting Oracle SDE features classes properly

I have got a few feature classes in an SDE connection. This is the situation: a) They are listed in ArcCatalog (10.1), but the open fails. The message says: 'Error opening feature class, DBMS table ...
3
votes
0answers
41 views

Geokettle Data Input from Oracle Database

i just installed GeoKettle and am trying to do some first steps in this. Can anyone help me with the data input step to an Oracle DB? I tried the OGR Input: But i seem to be unable to find the ...
-4
votes
1answer
72 views

Ora: 01036 illegal variable name/number in ArcObjects [closed]

I want to write a feature to a featureclass and use bellow code.On StopingEditing() return error "Ora: 01036 illegal variable name/number ". What am i missing? IWorkspace ws = SdeUtil....
3
votes
1answer
44 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) ...
0
votes
0answers
19 views

How do I find underlying tables used in connectivity?

First let me start by saying I am pretty much an ESRI neophyte. My experience is more with postgis and postgreSQL. I'm working on a project where we are trying to access the underlying connection ...
0
votes
0answers
23 views

Using FEAT_NUM Instead of FID as a Unique Identifier

In GIS data which entity would be the definitive Global Unique Identifier ? The FID which is a system generated unique number that once deleted will never be generated or a FEAT_NUM which is ...
0
votes
1answer
49 views

Oracle Procedure Call From ArcToolbox Script - Error processing call -

Background: I have an Oracle package with procedures to randomize and reset passwords for our SDE/GIS schemas. These procedures work perfectly via SQL Plus command line commands. My package looks ...
0
votes
1answer
99 views

Create a geoserver SQL view from Oracle SQL using a lat and lng column

I have a table in a Oracle SQL database in which I have a polygon geometry and two more columns of latitude and longitude. What I need is to show the points of lat and lng in a layer in geoserver. I ...
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
40 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: ...
0
votes
2answers
114 views

ArcGIS 10.2 Query layer ID field using double / floating field?

I am using ArcGIS for Desktop 10.2. Am I correct in understanding that ArcGIS will only let you select an integer or text fields as the "key" ID when adding a query layer? Our Oracle enterprise ...
1
vote
0answers
85 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 ...
0
votes
1answer
81 views

Refresh Database Connection in ArcCatalog

I have created a feature class in an Oracle 11g database connection with ArcCatalog 10.2 (without ArcSDE) and I can see the table in the database with Sql Developer without problems. But, if I drop ...
0
votes
1answer
65 views

Arc 10.2.2 crashes when adding query layer?

I'm trying to add a query layer from an Oracle database into a blank 10.2.2. map. I enter the query, validate, finish, and the software thinks for a second and then just winks out. No error message,...
1
vote
1answer
77 views

Postgis/SpatiaLite SQL query to connect MySQL, Access or Oracle database

In SpatiaLite or Postgis, how can one create a SQL query to read a table from a MySql or Oracle database? I don't know **the correct SQL syntax to connect to a table in a MySql or Oracle database **....
1
vote
0answers
19 views

Accessing ORACLE table from QGIS gives TNS-12545 error?

I have to access one ORACLE tab from QGIS but it does not work. From Instantclient_12_1 the connection and parameters are ok, while from QGIS we always get TNS-12545 error. ORACLE_HOME and TNS_ADMIN ...
0
votes
0answers
40 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
54 views

Using ArcPy Insert Cursor with NEXTVAL of Oracle sequence?

I have the need to be able to set a value of a gdb table to the NEXTVAL of an Oracle sequence. I have to be able to do this through an ArcPy function that will also handle setting the ArcPy OBJECTID ...
0
votes
0answers
15 views

UNique ID Field for Oracle versioned GDB

We had a successful trigger through ArcFM, but we have abandoned their datamodel/product. We have a successful trigger when new features are added in a versioned edit session, BUT it does not work for ...
2
votes
0answers
181 views

QGIS DB Manager Import layer/file Oracle not working - Error 8 Loading of the layer failed

QGIS 2.12.0 - DB Manager 0.1.20 - Windows 7 - Oracle 11g 11.2.0.3.0 Import vector layer Shape file as well as a layer (vector) and with every possible combinations of settings, the results are the ...
2
votes
1answer
98 views

Esri ArcSDE 10.3.1 Query Inspire Metadata from Oracle (11g) Enterprise GeoDB via SQL

As the title says - I want to create a query in Oracle SQL which will read all dates from the geoprocessing history which can be found using ArcCatalog to show the "Description"-tab from a feature. (...
2
votes
2answers
110 views

Provide credentials for Oracle database when opening MXD file?

I need to open a MXD file from a Python toolbox (so that I can automatically export it to a PDF). The file contains a connection to an Oracle 11g database, and I need to somehow provide the ...
2
votes
1answer
111 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) uri.setDataSource(...
4
votes
0answers
154 views

Creating materialized view from ArcSDE layer

In the past I've used materialized views in Oracle to replicate non-spatial data from one database to another. I'd like to do the same thing with an ArcSDE feature class, but I'm wondering how that ...
3
votes
1answer
565 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
87 views

How to set a specific ArcSDE version for tabular reporting?

I have created a multiversioned view in Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production. I can access a specific version using a SQL script in SQL Developer. However, using ...
2
votes
2answers
88 views

Is it possible to lock records or attributes indefintely if a field is populated?

I am creating a c# ArcGIS addin where I have a feature class stored in Oracle, when a feature is created some of the fields within the table will be populated. If field X is populated, then certain ...
1
vote
1answer
308 views

Querying Oracle geometry data type

How to query or find the geometry data type a given Oracle Database is using in SQL Developer (i.e. SDO_Geometry, ST_Geometry, etc)? I thought I could just describe a feature class within the ...
1
vote
0answers
30 views

Regarding QGIS Connectivity To Oracle

I installed QGIS long term release today first 64 bit and second 32 bit. My problem is that SQL Developer for Oracle a non QGIS product does connect to Oracle and when I use the same credentials in ...
1
vote
1answer
150 views

Geoserver 2.7 - 'Bounding Box & Lat-Long Data' fetching problem from Oracle Locator database

I have installed Geoserver 2.7 & connected my Oracle (Locator) database with available 'gt-jdbc-oracle-13.2.jar' extension. During layer publishing containing fields like 'Geometry', it failed to ...
0
votes
0answers
30 views

ORACLE Metadata Table used by QGIS?

When connecting to ORACLE Spatial with QGIS, QGIS Needs a metadata table about all available Geomtry columns in the database. If not provided, QGIS scans all tables with geometry columns wich can ...
0
votes
2answers
989 views

Error connecting to SDE 10.3.1 on Oracle 12c from 10.1 client

We are currently planning an server migration. We have our current server on SDE 10.1 on Oracle 11 Currently our editors are on ArcGIS 10.1 with Oracle client 11.2 Our new server is setup and ready ...
0
votes
1answer
203 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
25 views

ArcGIS 10.2 Oracle gdb got minus one from a read call

This is strange. Every certain amount of time (2 to 3 weeks) the gdb presents this problem. I've checked every possible line of code in a web app that consumes the layers stored there but do not see ...
0
votes
0answers
127 views

SQL query on field in Oracle does not return the same values that are seen in ArcMap/ArcCatalog

This is a very bizarre issue and I am at a loss as to why this is happening. A user running queries in SQL Developer brought this to our attention, and when we tried it we ran into the same problem: ...