11 votes
Accepted

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

One way of doing it: Close ArcGIS and ArcCatalog. In SQL Developer (Oracle 11g), the sequence of any Oracle table, if registered with the Geodatabase, will be created by SDE under a name similar to ...
user avatar
9 votes

ArcPy UpdateCursor auto pausing after every 1000 records

By default the auto commit interval is set to 1000. You can change the interval using the following: arcpy.env.autoCommit = 5000
user avatar
8 votes

Identifying true curves/arcs in ArcMap?

I was asked this question today ("How do I identify if a featureclass has curves) and was given some arcpy code suggestions. Modify the following code as you see fit (a flag variable instead of a ...
user avatar
  • 15.4k
8 votes

How are unsaved/temporary edits stored during versioned editing?

In short, unsaved/temporary edits in ArcGIS geodatabase are stored in a table, specifically Delta tables also know as A (add) & D (delete) tables based on the information I'm aware of and ...
user avatar
  • 11.9k
7 votes
Accepted

Restricting values to domain codes (beyond attribute table)?

Business rules vs data integrity rules When you model your database, you specify the business logic in two spaces: a. The data integrity rules. This includes among others having an integer column so ...
user avatar
6 votes

How Oracle is related with GIS (Professional wise)

Oracle DBMS is is capable of storing spatial data either through custom formats (like Esri) or native (Oracle Spatial). This means it is worth learning for GIS Analyst because you will be able to ...
user avatar
6 votes
Accepted

Directly edit features in non-SDE Oracle feature class?

No, it is not possible to directly edit Query Layers (in any database) using the standard graphical editing tools of ArcMap/arcpy (as if they were shapefile, file geodatabase, or enterprise-enabled ...
user avatar
  • 18.9k
5 votes
Accepted

Can't select geometry from Oracle DB using SQL

Just because Oracle supports the creation of custom objects in the database doesn't mean that all clients will be able to read their values. In this case, your PyODBC client doesn't know how to ...
user avatar
  • 18.9k
5 votes
Accepted

Update a table with values from coordinates on GEOMETRY in Oracle

The solution depends on the geometry of your layer. Point Geometries For points you can access the X and Y co-ordinates directly: update TABLE1 s1 set X = s1.GEOMETRY.SDO_POINT.x,y=s1.geometry....
user avatar
  • 986
5 votes
Accepted

Deleting Oracle SDE features classes properly

I have researched that when you add a new SDE feature class through your Oracle connection in ArcCatalog, these are the SDE tables to be affected: -SDE.COLUMN_REGISTRY -SDE.GDB_FIELDINFO -SDE....
user avatar
5 votes
Accepted

List of all fields and their domains for each table using SQL (table name, field name, domain name)

Refer to the XML in the DEFINITION field in SDE.GDB_ITEMS_VW. select i.name as table_name, extractvalue(definition_xml.column_value, 'GPFieldInfoEx/Name') as field_name, extractvalue(...
user avatar
  • 828
5 votes

Does the OBJECTID in an Oracle Geodatabase table have a primary key constraint, by default?

By default, yes, it normally is unless someone overrode that and designed the table differently. Is this an ArcSDE database? There may also be GlobalID fields that act as primary keys across ...
user avatar
  • 336
5 votes

How to trace SQL queries sent by geo Server to Oracle database?

As already suggested by user30184: Go in the global settings and switch the logging level to GEOTOOLS_DEVELOPER_LOGGING, see http://docs.geoserver.org/latest/en/user/configuration/globalsettings.html#...
user avatar
  • 15.7k
4 votes

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

Find the registration ID: SELECT T.REGISTRATION_ID , T.TABLE_NAME FROM SDE.TABLE_REGISTRY T WHERE T.TABLE_NAME LIKE '%YOUR_TABLE%' (let's say the registration ID is 555). Build this ...
user avatar
4 votes

ArcObjects / Oracle12c / EZCONNECT

Not sure why the question got "voted down". Thanks for the constructive input. Anywho, for those that understood the question, or are facing a similar challenge, here is/are the solution/s that was/...
user avatar
4 votes

Monitor Traffic Between ArcGIS Server and Oracle DB

The DBA is probably using Oracle's standard administration tools and console (Enterprise Manager / Grid Control). That console will highlight the high consumers in terms of number of SQL statements ...
user avatar
4 votes
Accepted

is it possible to store empty geometries in an Oracle Database?

This is the question/response I got from oracle's spatial expert in Europe in 2014. q: Does oracle have the concept of an empty geometry? If so can you give me an example? Would this be a valid way ...
user avatar
  • 104
4 votes
Accepted

Does the OBJECTID in an Oracle Geodatabase table have a primary key constraint, by default?

I think the answer is no. The OBJECTID in an Oracle geodatabase table does not have a primary key constraint , by default. When I query an Oracle geodatabase table to return the column that has a ...
user avatar
  • 828
4 votes

Versioned to unversioned: How to undo edits in an edit session on an unregistered table

The best resource I've come across to provide an answer is Esri's Not registered as versioned or unregistering data as versioned There are no ways I'm aware of redoing/undoing edits in unregistered ...
user avatar
  • 11.9k
4 votes
Accepted

How are unsaved/temporary edits stored during versioned editing?

Manually trace what the database does: Create a test table: In SQL Developer,: create table test_table ( field1 varchar2(255) ); In ArcCatalog: Register the table with the Geodatabase ...
user avatar
  • 828
4 votes
Accepted

How to view coordinates instead of geometry object in geometry column in Oracle SQL Developer?

You can double-click one of those objects. That bring up a little pencil icon on the side. Clicking that brings up an "edit" window that shows the object content. That works fine for points. Hard to ...
user avatar
3 votes
Accepted

Incomplete Data - Missing line segments from Oracle data

See this GeoServer ticket and others which are referred in it http://jira.codehaus.org/browse/GEOS-2935. Support for compound curves etc. is a brand new feature in GeoServer and for the first time ...
user avatar
  • 52.5k
3 votes
Accepted

Importing Feature Class to Oracle SDE Geodatabase Simplifies Features

It turns out that it was a problem of tolerance and resolution. When we created the feature datasets in the SDE geodatabase, we were simply accepting the default XY tolerance and XY resolution, which ...
user avatar
  • 243
3 votes

Importing Feature Class to Oracle SDE Geodatabase Simplifies Features

The two most likely causes (that I can think of) are; 1) The SDE Geodatabase configuration keyword includes a PRECISION statement and you likely have converted the feature class form high precision ...
user avatar
  • 1,550
3 votes

Can spatial data in Oracle be imported into SQL server?

Creative solution: let Oracle produce the insert Statement for SQL Server. Example: select 'Insert into cc.yourGeometryTable (ID,OBJECTID,GEOMETRY) values (''' || id || ''',' || OBJECTID ...
user avatar
  • 31
3 votes

finding the definition of missing srid in postgis

Following functions exist in Oracle: SDO_CS.MAP_EPSG_SRID_TO_ORACLE SDO_CS.MAP_ORACLE_SRID_TO_EPSG So SELECT SDO_CS.MAP_ORACLE_SRID_TO_EPSG(xxx) FROM dual; yields: 90112 -> null 327680 -> ...
user avatar
3 votes
Accepted

Updating Web Map Service (WMS) by default when data amended in Oracle source tables?

Normally WMS Servers rendering the content on-the-fly and therefor the resulting map image should be up-to-date. If you're using a Tile-Mapping Server (like MapProxy, GeoWebCache, TileCache, etc) on ...
user avatar
  • 108
3 votes

ORA-28595: Extproc agent : Invalid DLL Path

If you've already compiled the PUBLIC and SDE schema after setting the user library, that error message looks like you do not have the actual EXTPROC_DLLS environment variable on your Oracle server. ...
user avatar
  • 816
3 votes
Accepted

Bulk inserting with Python and cx_Oracle into st_geometry enabled table?

I found another way to bulk insert points into ArcSDE geodatabase. It's based on another way to define points presented by ESRI here, sde.st_geometry (x,y,z,m,srid), which is recommended when ...
user avatar
3 votes

Oracle VectorLayer without geometry - How to get attributes?

The problem is solved! I used the module PyQt4.QtSql. Now I can connect to the database and with SELECT, find my attributes.
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible