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
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
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....
3
votes
4answers
751 views

Shapefile import with Oracle + GeoServer produces points instead of vector shapes

I have implemented the example at http://www.gistutor.com/openlayers/22-advanced-openlayers-tutorials/47-openlayers-wfs-t-using-a-geoserver-hosted-postgis-layer.html and got it working properly. Now ...
0
votes
2answers
583 views

How to plot lat/long stored as text in Oracle DB using report builder/SSRS r2

We use an Oracle 10g database. However we write reports using SSRS or report builder, using the Oracle connection type to the datbase. In oracle we have 2 text fields, one for lat and one for long. ...
3
votes
1answer
284 views

How to clip a Oracle query layer directly in a Python script?

I have a query layer directly running from ORACLE database in a MXD. I want to clip this layer with a layer being created in another MXD in a Python based tool. My question is to do this clip ...
2
votes
2answers
226 views

GeoServer- Reload feature type doesn't work

I have Oracle database and I had created layer in GeoServer. It had worked good, but when I recreated database with different table structure (some columns dropped, some new added), I've got a problem....
2
votes
1answer
180 views

Taking a long time to load tables from oracle to QGIS

My workplace has an oracle database with a very large number of spatial tables. Therefore, it takes a long time to load the oracle connection in QGIS. Does anyone know how this could be speed up?
1
vote
3answers
820 views

Exporting data from Oracle to Esri File Geodatabase grid size error

My specs: ArcInfo 10.1, Oracle 11g I have a line dataset which is sat in Oracle 11g. I can read/query/symbolise this in ArcDesktop without any problems. I now want to export a selection into a file ...
0
votes
1answer
181 views

how to see a base map created by map builder in database?

I am new in oracle, I tried to create a style, then different themes and then a base map. I saved all my work, but I can't see the base map in the database. Did I miss something? The interesting ...
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 ...
3
votes
2answers
758 views

Convert non-spatial Oracle table to spatial Oracle table in a different database

I'm trying to use ogr2ogr to convert data from a non-spatial table (has X & Y values) in an Oracle database (1) to a spatial format in a different Oracle database (2). This will be scheduled to ...
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) ...
3
votes
1answer
1k views

Arcpy does not execute “CopyFeatures_Management” to write a featureclass to an ArcSDE database

I have some problems with my Python script. The script gets an JSON with different information about images. The information includes general information about images and also the gps position of them....
0
votes
0answers
35 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
votes
2answers
495 views

Connecting to Oracle database on a network in python

There is lots of information out there on how to do this, unfortunately, it all looks like Greek to me. I need a connection to a DB so I can add and use tables and featureclasses contained within it....
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 ...
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
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 ...
1
vote
2answers
88 views

Where are Object class extension GUIDs stored in Oracle?

Where are the GUIDs for object class and workspace extensions stored in SDE for Oracle? I've looked through GDB.ITEMS but can't seem to find it. I think SQL Server stores it in an .xml column but I ...
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/...
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 ...
6
votes
2answers
1k views

where is the sequence in Oracle associated with the Objectid field in ArcGIS, and how to manage it?

I am working in ArcGIS 10.1 with tables from Oracle, now under control of SDE, after making use of the option: 'Register with Geodatabase'. All these tables have a column named 'Objectid' with an ...
4
votes
2answers
2k views

Can spatial data in Oracle be imported into SQL server?

Oracle supports spatial data and so does SQL Server. What are the things to consider if we have to migrate spatial data from Oracle to SQL Server? Are there any features in Oracle that are not there ...
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 ...
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....
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 ...
4
votes
2answers
1k views

In Oracle Spatial, what is the fastest way to determine the percentage of intersection between two shapes?

I have to query polygons that intersect with one another. Our polygons occasionally contain intersections that aren't intended (meaning just a few vertices cross boundaries). I want to filter out ...
2
votes
2answers
291 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 VARCHAR2(32)...
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
1answer
147 views

Insert SDO_GEOMETRY in cx_oracle

I have many polygons to insert. This code is ready to use. geom_str = '"MDSYS"."SDO_GEOMETRY"(2003,NULL,NULL,"MDSYS"."SDO_ELEM_INFO_ARRAY"(1,1003,1),"MDSYS"."SDO_ORDINATE_ARRAY"(-735342,-1010550,-...
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 ...
10
votes
5answers
3k views

How to identify “true arcs” in Arcmap?

This is really annoying: the only good way of creating circles in ArcMap is using true arc, (compound curves) but I need to convert those to vertex (densifying) because of a compatibility problem. I ...
4
votes
3answers
2k views

ST_Geometry vs SDE Binary: seeking recommendations, experiences

I've got some questions I've collected as we try to come to a decision about whether to use ST_Geometry or SDE native geometry for an Oracle/SDE datastore on a new project. The organization has quite ...
0
votes
1answer
396 views

How to set encoding when using ogr2ogr to export from oracle db to mapinfo table?

I am trying to automate the export of spatial data from a oracle database to mapinfo .tab files. Using this thread I made my script. However I can't see how to set the encoding right. My data have ...
3
votes
2answers
3k views

How to correctly set up Oracle connection parameters?

Just testing out the new QGIS2 install here and trying to connect it to our huge SDE/Oracle spatial database. Im struggling with the connection parameters. Here is the connection properties to the ...
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 ...
5
votes
2answers
555 views

How do you determine which dbclient connection property to use for an Oracle SQLWorkspace connection?

I have an Oracle11g database that I connect to via a SQL Workspace; however the actual dbclient string value that works differs depending on machine (and I'm guessing oracle client configuration). On ...
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 ...
4
votes
1answer
332 views

Identifying geometry storage type in geodatabase stored in Oracle?

How do I identify what geometry storage type is being used with a specific geodatabase stored in Oracle 9i via ArcSDE 9.3.1?
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 ...
10
votes
3answers
583 views

How to determine storage type (ST_Geom/Oracle) from arcpy/python

We're migrating some feature classes from SDELOB (or some older binary format) to ST_Geometry. As we write our arcpy script to use the ESRI Migrate Storage Tool we'd like to test whether or not ...
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 ...