Use this tag for questions about the ArcSDE (Spatial Database Engine) component of Esri's ArcGIS for Server that is one way to enable access to spatial data stored in a Relational Database Management Systems (RDBMS).

learn more… | top users | synonyms (1)

1
vote
2answers
90 views

Migrating data from ArcSDE to SQL Server Spatial Database

I am looking for a process or a tool that would allow me to migrate data from an ESRI SDE Database to a SQL Spatial Database. This would include converting the ESRI geometry to SQL geometry types, as ...
1
vote
0answers
19 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.
2
votes
0answers
43 views

Unable to add feature class based on database view in ArcMap

To solve Rendering features based on relationships using ArcGIS for Server?, we created a view in the database that joins the two tables together. That works fine. I see the feature class in ...
1
vote
0answers
41 views

Versioning in ArcGis? [closed]

I create 2 replica by tool CreateReplica_management. This tool return 2 mdb: A.mdb with feature class FC1, FC2. B.mdb with feature class FC1, FC2. First user edit FC1 from A.mdb Second user edit FC2 ...
5
votes
1answer
55 views

Can ArcGis accept SQL field names with spaces?

Im working on an integration project that is providing data from our billing system to ArcGis. Field names can include spaces which are acceptable in SQL Server if enclosed in brackets eg: [Street ...
0
votes
0answers
87 views

Unable to save edits. The requested operation is invalid on a closed state [State_id=3411]. Arcgis 10.4 oracle 11g

Recently updated our system from Arcgis 10.3 to 10.4 (both client and server side). When trying to edit my versioned arcsde oracle database following error appears: Unable to save edits. The ...
1
vote
0answers
13 views

Connect to certain timestamp for child version

In ArcMap you can connect either to a historical marker or to a specified timespan by changing the version within the subtab Historic. I am however not quite sure on which parent-version this new ...
1
vote
2answers
49 views

Changing ArcSDE version of *.mxd in ArcPy?

Is there a way to switch the version a .mxd data source is pointing at without using arcpy.mapping.findAndReplaceWorkspacePaths? I have a script that automates map book production that works very ...
3
votes
1answer
84 views

Get domain descriptions for multiple fields using SQL (ArcSDE 10.3/Oracle back-end)

How can I get domain descriptions for multiple fields using SQL (ArcSDE 10.3/Oracle back-end)? I have successfully used the Oracle SQL in the ESRI document: Resolving domain codes to description ...
0
votes
0answers
16 views

How can I create a definition query to show the next 5 years of data, based on a text field with the year on a joined table in SDE?

I need to show the next 5 years of construction data, but I want it to automatically update what is shown based on a text field called ConYearStartNbr that shows when the construction is set to start ...
5
votes
1answer
52 views

Auto-generated field in ArcSDE for end user

The objective: Create a process where a coworker can open an .MXD, start editing, add a feature to represent a complaint, then add records in a related table to represent an inspection. Along the way, ...
0
votes
0answers
55 views

Export from SDE to Shapefile Bug

I'm exporting data from a large-ish SDE feature class (888,628 features) to a shapefile. I'm using the ArcMap GUI export process (add the SDE feature class as a layer, right click >> Data >> Export ...
0
votes
0answers
138 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 ...
1
vote
0answers
49 views

Feature linked annotations not updating when editing attributes in features?

I am using ArcGIS 9.3. I have a copy of an original SDE database with feature classes, annotations, and relationship classes for those annotations. The copied geodatabase is an exact replica of an ...
0
votes
0answers
12 views

Date Query 10.3 SQL SDE vs FGDC

I have a date field "FIRE_DSCR_DT" that I want to query for a specific month(s). For example,I want to get all of the records where the month = January. This query did not work in SDE, but it did ...
3
votes
1answer
78 views

Transfering features class from ArcSDE to File Geodatabase using ArcPy?

I would like to know if it's possible to use python to transfer features class from SDE into a GDB and then transfer it back to SDE without losing SDE parameters such topology, versionning, ...
1
vote
1answer
17 views

ArcCatelog 9.3 feature classes with annotation relationships allowed in a geometric network

I have a gas utility dataset that we are working on getting converted into a geometric network for easier analysis. The feature classes are part of an ArcSDE and have a ton of relationship classes ...
0
votes
1answer
47 views

Monitor open sde connection

How can I monitor the open ArcSDE database connections without sdemon? I need to see at any time how many sessions are consumed from my app and if they are related to ArcGIS. I use Oracle 10.2.
1
vote
0answers
25 views

Successfully added a Database Server but nothing inside (ArcCatalog)

I'm just a newbie in using ArcGIS. I'm trying to create a Web editing application in ArcGIS Server Manager like this post does here, but after added a Database Server i realize that there is nothing ...
1
vote
0answers
34 views

Adding rasters to mosaic dataset?

I'm working with an ArcSDE geodatabase v 10.0 in SQL Server 2008R2. I added more than a dozen of rasters w/o problem. Server: WIN 2008R2 12GB RAM SPACE: 1TB Created a mosaic dataset (empty) w/o ...
1
vote
1answer
48 views

shapefile to sde and vice versa

I have an ArcMap 10.3.1 basic License and therefore cannot export data to SDE's connections. Is there an open source tool that I can use to export shapefiles to an sde? I have found shp2sde and ...
0
votes
0answers
43 views

Return table names for query layers using arcpy

The dataSource property for layers does not return the name of the tables used in query layers. Instead, it returns something like the following: 'Database Connections\\ConnectionFile.sde\\sde.SDE.%...
0
votes
1answer
43 views

How do I automate a process to reproject and merge all feature classes of three SDE databases with multiple feature datasets included?

I have three different instances of SDE that have the same schema. Each SDE has multiple (5) feature datasets. I need to reproject all feature classe within these datasets to a common coordinate ...
3
votes
2answers
45 views

Getting full path of empty sde feature datasets (Children property from arcpy.Describe object won't work))

My goal is to copy all the feature classes in a file geodatabase into an sde geodatabase, skipping those elements which already exist in the output sde gdb. Both geodatabases have the same feature ...
0
votes
0answers
42 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
70 views

How do I Customize an ArcGIS Map Service to Include Additional Items?

I am using ArcGIS 10.1 and attempting to publish a map service on a remote server running ArcGIS server 10.2. I have created a map service successfully and can view it via the ArcGIS JavaScript API: ...
3
votes
1answer
69 views

Create SDE-file returns warning but creates the file

When I create an SDE-file using arcpy I get the following warning: WARNING 000565: Could not connect to server. This is the appropriate code temp = r'C:\Users\admin\AppData\Local\Temp' host = "...
1
vote
0answers
39 views

ArcSDE In a version geodatabase, snap tool does not work on a database feature class

I am setting up a series of tasks for technicians to complete. To finish the map template they will be working from, I must snap leak points to gas mains using the snap tool. However, after running ...
0
votes
0answers
34 views

Error (-51), Extended Error 102 with Create Database User (Data Management Tools -> Geodatabase Management ->Create Database User)

I'm trying to Create Database User so I can register my sde geodatabase data with ArcGIS Server. I can see in my Server Manager that the user does exist, but does not belong to any of the Windows AD ...
0
votes
0answers
20 views

Compare domain between 2 SDE instances

I have a script that compares domain between 2 file gdb and write the difference to a file gdb. when i change my data source to sde it fails. I think the way tables are referenced in a GDB is ...
3
votes
0answers
51 views

Rename the output file ArcGIS

I am copying a tons of features from a file geodatabase to a database server. First I created an enterprise geodatabase connenction and after a database connection. In the first step I added a ...
0
votes
0answers
56 views

How to replace/update authorization key for an ArcGIS Enterprise Geodatabase

I need to switch the authorization key of an ArcGIS Enterprise Geodatabase (in Postgresql). I am on 10.3 and based on the scarce documentation I have found, ESRI is moving tools that allow such ...
2
votes
0answers
89 views

How to convert the BLOB value for the features geometry of type st_geometry kept in ArcGIS databse on Oracle [closed]

I am using ArcGIS Oracle database and I am trying to access feature geometry points as string. But the problem is that the points are kept as blobs and I cant convert to meaningful string. select ...
0
votes
1answer
32 views

View ArcSDE feature classes of published map service, when outside of corporate domain

I have a notorious problem, which keeps bugging me since days and I can´t find ANY proper answer on the net... In my company we´re using ArcGIS Server 10.1 and publish map services throughout our ...
2
votes
0answers
35 views

Where do field aliases reside in an SDE database?

If I want to get field aliases for an SDE table through pure SQL, what table do I query? My geodatabase was created with ArcGIS 10.1 in an Oracle database.
0
votes
5answers
74 views

PDF Plotting from ArcGIS for Desktop?

I am experiencing a very annoying phenomenon at the moment when trying to plot an A0 PDF Plot and would be interested to hear if anyone has had a similar problem and whether there is a solution or ...
0
votes
0answers
9 views

Altering old AXF before importing back into ArcSDE?

When we exported an AXF, the editable layer had all its fields turned on. When we bring it back in, months later, even if a field wasn't set up for editing outside the office, the values in the field ...
0
votes
0answers
39 views

Dynamically Create a Foreign Key for Relationship Classes

May be a relativity novice question but my research has turned up no direct answer. I have a feature class of land owner parcels that I would like to preserve its schema. I would like to add fields ...
1
vote
1answer
149 views

ArcGIS 10.1 crashes during connection with ArcSDE 10.2 in Oracle 11g database

I have been having this issues of ArcGIS (ArcMap and ArcCatalog) crashing on me every time I try to connect to the databases. I have updated both client and server patches for Oracle as suggested by ...
2
votes
2answers
117 views

Why does FeatureClassToFeatureClass work in ArcMap but not in Python script?

When trying to copy a feature class from an SDE connection file to a scratch GDB, the FeatureClassToFeatureClass_conversion works in the ArcMap Python window, but I can't get it to work in a Python ...
0
votes
0answers
18 views

Snapping a point into a raster grid

Currently I have a raster grid in the SDE. This raster grid represent certain region (For example: Raster grid for one island). On the other hand, I have point features which are plotted within the ...
1
vote
1answer
39 views

Find Delta only records in ArcGIS (SDE)

We have spatial layers in ArcSDE with objectid as unique value, I've taken this data to another platform & migrated data to cloud. Now, after months, back in ArcSDE and want to migrate new data (...
10
votes
3answers
155 views

Querying for underscore character in ArcMap?

For a standard LIKE query against an Oracle-based ArcSDE feature class, the underscore character represents a single character wildcard when used with a string. I'm trying to impose a definition ...
1
vote
0answers
49 views

Arcpy - Why does multi_user_mode have to be False in an edit session on non-versioned dataset?

I'm in the process of implementing Mintx's answer to my question What would cause a geoprocessing service to say "Cannot Open 'FeatureClass' Failed to Execute"? However, I had ...
2
votes
1answer
45 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
109 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 ...
2
votes
1answer
77 views

Repoint feature layers from one SDE to another

I am trying to repoint layer (.lyr) files to a new SDE connection. In a test project folder I have two test layer files. When using lyr.findAndReplaceWorkspacePath() the script runs with no errors, ...
0
votes
1answer
55 views

Undo option to 'move edits to base' ArcSDE

I have an ArcSDE Geodatabase where a number of layers are registered as versioned. Having spent some time troubleshooting an issue I'm having with syncing data on Collector, I have noticed that the ...
1
vote
2answers
93 views

Using Python to select records by date field

I am trying to write a python script to select records created within the past 7 hours (date field - database time) using a where-clause within arcpy. The table is ArcSDE database (Microsoft SQL ...
-2
votes
1answer
44 views

How much RAM do I need per SDE DB [closed]

Estimating RAM required is never a fixed number. However, there are base figures to follow for example for arcgis server services. How much RAM do I need to plan per DB? I'm using SQL Server but ...