9 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 ...
KHibma's user avatar
  • 16.8k
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
Lorne Dmitruk's user avatar
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 ...
whyzar's user avatar
  • 12.1k
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 ...
Alex Tereshenkov's 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 ...
Vince's user avatar
  • 20.1k
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....
Web-GIS entrepreneur's 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(...
User1974's user avatar
  • 1,132
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 ...
GIS87's user avatar
  • 336
5 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 ...
User1974's user avatar
  • 1,132
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#...
Andrea Aime's user avatar
  • 17.4k
5 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 ...
Albert Godfrind's 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 ...
aileen's user avatar
  • 104
4 votes

Converting double field to integer in database view so ArcMap query layer can use field as unique identifier

You have to create the view using a select statement with a casting case. For instance: SELECT CAST (miles AS INT) Once your view is created, it should appear in the catalog of your database ...
pateto777's user avatar
  • 400
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 ...
whyzar's user avatar
  • 12.1k
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 ...
User1974's user avatar
  • 1,132
4 votes
Accepted

How to find closest point on a line from a point in Oracle Spatial?

What you are asking for is linear referencing. Check out the SDO_LRS package for that. First the SDO_NN operator will give you the nearest line to a given point, then SDO_LRS.PROJECT_PT() against ...
Albert Godfrind's user avatar
3 votes

Performing a spatial relationship in Oracle SQL with only lat/long.

What you need is to use a function-based spatial index, i.e. define a spatial index that constructs a geometry object dynamically. Here is an example on a table called US_CITIES_SX that looks like ...
Albert Godfrind's user avatar
3 votes

Converting double field to integer in database view so ArcMap query layer can use field as unique identifier

Some points to add to the other answers that I learned through trial and error. If the Oracle table doesn't have a unique id field use ROWNUM psudocolumn. (Note: be aware that features might get a ...
matt wilkie's user avatar
  • 28.2k
3 votes
Accepted

What are the options for accessing Oracle geodatabase data using full-blown SQL?

You said your database is Oracle 12c. But what storage type do you use for your data ? Is that the SDE binary type ? Or is it ESRI's ST_GEOMETRY types ? If the former, then there is nothing you can ...
Albert Godfrind's user avatar
3 votes

Accessing information about ArcSDE historical markers via arcpy or SQL?

You should be able to get everything you need from the gdb_items and gdb_itemtypes tables. The following query should get you started on SQL Server. SELECT items.Name AS "Marker Name", ...
travis's user avatar
  • 1,910
3 votes

Identifying true curves/arcs in ArcMap?

Building on @KHibma's answer, the data access cursor has the token SHAPE@JSON which can be used to check for curves without importing the json module. with arcpy.da.SearchCursor ("InputFeatures", ["...
Emil Brundage's user avatar
3 votes
Accepted

Get the geometry type of an empty ArcSDE feature class

The sde.ST_GEOMETRY type itself is typeless (it doesn't care if multiple topology classes exist). However, ArcGIS for Desktop and Server do care, and won't permit multiple topology classes. When ...
Vince's user avatar
  • 20.1k
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 ...
GeoTask's user avatar
  • 31
3 votes

Where are Object class extension GUIDs stored in Oracle?

In Oracle geodatabases, the DEFINITION column is an ArcSDE XML type rather than the native Oracle XML type which stores the information as BLOBs. To enable reading these values, the SDE schema in ...
nicogis's user avatar
  • 586
3 votes
Accepted

Why are 12 hour time values printing as date values with ArcPy?

You could try this. Its post manipulation though not sure how to get the right values to begin with. import arcpy import datetime fldName = 'ORIGDTTIME' fc = 'featureclass' myList = set([(row....
JamesLeversha's user avatar
3 votes

Force Arcmap to respect primary key constraints/triggers

As Mentioned by Vince, your issue is that there are two models which are in conflicts. If you have some kind of constrain, ArcGIS, by default, will not know about it. ArcGIS will assume that this is ...
Devdatta Tengshe's user avatar
3 votes
Accepted

ArcMap: Copying features class to Oracle DB fails: Shape integrity error

I have solved this problem by applying ArcGIS Pro 2.0 that has luckily just been released and by using the Tool "Repair Geometry": https://pro.arcgis.com/en/pro-app/tool-reference/data-management/...
simsi's user avatar
  • 151
3 votes
Accepted

arcpy.da.SearchCursor feature orders mixed up in Oracle enterprise geodatabase?

Oracle decides how to implement the query based on complex series of rules and optimizations. Indexes, order of most recent edits and versioning will all affect how the oracle query optimizer parses ...
Dowlers's user avatar
  • 2,334
3 votes

How is the st_length function stored in an Oracle geodatabase?

length is stored with the shape so there is no call to the extproc
nef001's user avatar
  • 785
3 votes
Accepted

How does Spatial Join work under the hood?

Spatial join works by using the shape field of the feature to determine if the features' geometry coincides. The shape field does not limit the geometry to the vertices or centroids, but rather the ...
atxgis's user avatar
  • 1,239

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