14
votes
Accepted
Create Layer from Selected Features tool: How is the list of features stored?
Create Layer From Selected Features DOES NOT create a DYNAMIC layer. The resulting layer is not dynamic at all. It is based on an FIDset.
If you change the source data, the FIDs will change and your ...
- 7,582
13
votes
Create Layer from Selected Features tool: How is the list of features stored?
The best way I've understood how Create Layer from Selected Featuresis this reference that I came across Create a temporary layer to select features
Creating a temporary layer allows you to do things,...
- 12.1k
9
votes
Creating empty feature class in file geodatabase based on schema of ArcSDE feature class?
Just use the CreateFeatureClass tool, passing the original feature class as the template argument. Grab the shape type from the Describe object of the input feature class.
Unlike the other answer, ...
- 4,138
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
- 116
8
votes
Accepted
Set workspace to SDE version using ArcPy?
You can set your .sde database connection to a specific version in ArcCatalog so that any access to the gdb using that connection will use that version.
In the Catalog window, create a new connection ...
- 29.9k
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 ...
- 12.1k
7
votes
Accepted
Using SQL statement with ArcPy?
If you have SQL access, you can use arcpy.ArcSDESQLExecute() to use SQL from arcpy. I use this regularly to query a number of SQL databases, some of them spatial, others non-spatial. I find it ...
- 29.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 ...
- 30k
7
votes
Accepted
ArcGIS sde i5,i6,i7 tables
The iN table presence and function are documented in the fourth paragraph beneath the section heading "Feature classes in a PostgreSQL database using ST_Geometry storage":
Once you have loaded data,...
- 20.2k
7
votes
Accepted
CreateEnterpriseGeodatabase_management fails on PostgreSQL claiming ST_GEOMETRY not present
TL/DR: You cannot use both 10.3.x and 10.5.x geodatabases in the same non-RDS PostgreSQL instance. You do have other options.
First, some background:
PostgreSQL development rules forbid the mixing ...
- 20.2k
6
votes
Improving poor performance of ArcPy update cursor with ArcSDE and Editor?
The nested cursors are slowing you way down. Instead, use a searh cursor to create a dictionary with UIDs as your key and rows as your values. Then use an update cursor to update your second feature ...
- 13.9k
6
votes
Accepted
Retrieving deleted records from feature dataset in enterprise geodatabase?
You have a few possible options and they all depend on your specific environment and set-up.
First, if you have versioning turned on for the feature classes in question and you have not reconciled and ...
- 3,863
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(...
- 1,222
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 ...
- 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 ...
- 1,222
5
votes
Creating geodatabase (and st_geometry) in Oracle Express (XE) for home/personal use?
It is your plan to "add a sde.st_geometry user-defined type" that means you will need ArcGIS Server (of which ArcSDE is a component) licensed.
If that is a mandatory requirement then your most cost ...
- 65.3k
5
votes
Accepted
Retrieving Full Path to Feature Class in ArcMap
Not sure if this is as easy as you like, but you can use these three lines of code in the python window (drag or write feature class name for fc variable).
fc = (Drag feature class here from Table Of ...
- 1,239
5
votes
ArcMap Append (Data Management) Tool is not working correctly
Try exporting the shapefile to a File Geodatabase with Feature Class to Feature Class tool and use the feature class in Append tool. When a geoprocessing tool fail with shapefile input it will ...
- 76.3k
5
votes
Working on databased-stored-geodatabase with a ArcGIS for Desktop standard license?
The two highlighted passages do not contradict each other, they're merely referring to different capabilities.
The first passage explains that Standard or Advanced seats of ArcGIS
Desktop can ...
- 20.2k
5
votes
Accepted
Performance of arcpy.Exists() in SQL Server enterprise gdb environment
One of the interesting quirks of many SQL client APIs is the lack of a "table exists" function. Many implementations of an "exists" are really a low-level "describe", which returns a "does not exist" ...
- 20.2k
5
votes
Accepted
Connecting to *.sde file in database IDE
The ".sde" file is simply a ESRI file format that contains the connection information required to connect to an ESRI enterprise geodatabase.
Using ArcMap or ArcCatalog, you can right-click on the "....
- 8,446
5
votes
Accepted
Is the ObjectId value guaranteed to be unique after features are deleted and re-created in an enterprise geodatabase?
The implementation differs by Enterprise geodatabase platform (RDBMS), but all OBJECTID (aka "registered rowid") type columns defined by ArcGIS will always be 32-bit integer values, fed by a ...
- 20.2k
5
votes
Parsing/converting ISO 8601 datetime fields using pandas
A working sample
import pandas as pd
data = [{'mydate': '2007-02-01T05:00:00.0000000+00:00', 'b': 2, 'c':3},
{'mydate': '2007-02-01T05:00:00.0000000+00:00', 'b': 20, 'c': 30}]
# Creates ...
- 31.1k
4
votes
How to replace/update authorization key for an ArcGIS Enterprise Geodatabase
In 10.3.1 the Enable Enterprise Geodatabase tool does not update the "AUTH_KEY" in SDE_server_config table of your database. See the image below. The suggested workaround from our ESRI rep said that ...
- 51
4
votes
Accepted
Finding SDE permissions on feature class using ArcPy?
I didn't find a pre-built tool to do this, but ended up using the following code which was easy enough to then query the dictionary to pass to arcpy.ChangePrivileges_management()
import arcpy
def ...
- 29.9k
4
votes
Accepted
Adding geodatabase connection from another PC to SQL server 2014?
You need to install the SQL Server Native Client so that your client machine (your PC) can talk to SQL Server.
To connect to a database or geodatabase in SQL Server from ArcGIS for
Desktop, ...
- 29.9k
4
votes
Copy Enterprise Geodatabase to new SQL Server - will it work?
Yes, you can take a backup of an SDE geodatabase and move it to a new server, but it's a bit tricky. We regularly do this for SDE geodatabases with PostgreSQL. The biggest caveat is you cannot rename ...
- 10.7k
4
votes
Accepted
Changing layer's ArcSDE data source user name?
You can re-point your layers to another connection using Set Data Sources in ArcCatalog
In the dialog that opens, select all the layers you need to update, and choose Replace All
In the Replace All ...
- 29.9k
4
votes
Accepted
Get GDAL up and running with ArcSDE enabled
I was able to export all data (vector and raster) from ArcSDE using GDAL. To have ArcSDE support in GDAL it is not necessary to compile GDAL. If you have access to an ArcSDE installation, that's ...
- 5,465
4
votes
Accepted
Finding spatial views with ArcPy?
@Vince pointed out the arcpy.ArcSDESQLExecute command.
Here is a function I put together to return True/False for finding a Spatial View, based on the code sample from http://pro.arcgis.com/en/pro-...
- 23.2k
Only top scored, non community-wiki answers of a minimum length are eligible