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)

0
votes
1answer
21 views

Create table that is not registered with a SDE Geodatabase

I am doing some testing that requires having a table in a Oracle 11g/SDE 10.3.1 database that is not registered with the geodatabase. For instance, Adding an Incrementing ID Field can only be ...
0
votes
0answers
12 views

Delete feature class attribute from sde database arcpy script [on hold]

I want to write a python standalone script which compares two feature class from SDE geodatabase. For Example, fc1 contains 10 attribute rows and fc2 contains only two rows which match with the fc1 ...
0
votes
0answers
9 views

Custom editor tracking field not in select list

We have a versioned sde database in ArcGIS 10.3.1 and Oracle on the back end. And we have features with editor tracking turned on based on customized editor tracking fields, such as "CREATEDWHO","...
0
votes
0answers
11 views

Loading Data into a Versioned SDE Environment

Our set-up: Database connections: Sde.sde – gdb admin Gis.sde – data owner User1.sde – data user User2.sde – data user User3.sde – data user We have a versioned environment Our current Version ...
2
votes
1answer
55 views

ESRI ArcMap 10.0 Not Compressing

We have ESRI ArcMap 10.0 (build 4400) ArcGIS Desktop 10 Service Pack 5. SQL Database 10.0.4000. We are trying to Compress our Versioned tables but for some reason it's not pulling the changed records ...
0
votes
1answer
64 views

How to update coordinates in a geodatabase with FME?

I have an excel file of points which are resurveyed with updated Coordinates.Now I want to update my existing arcsde geodatabase. How can i update only coordinates in FME?
0
votes
0answers
9 views

Feature layer issue in Portal for Arcgis

Recently I installed Portal for ArcGIS 10.2.1 with web adapter. And after publishing a map service to my ArcGIS server and then adding it as a layer in my Portal's content, I cannot edit this layer ...
0
votes
0answers
35 views

ReplaceDataSource of SDE layers in map documents (mxd) with old feature classes newly organized under feature datasets in the same ArcSDE

I need some help to replace the data source of old SDE layers in the map documents. The replaceDataSource method in the code below is not working properly resulting in a broken link of the target ...
-4
votes
0answers
58 views

Create enterprise geodatabase errors

When I Create Enterprise Geodatabase using toolbox in ArcCatalog it errors below. also I create database in SQL server then I add geodatabase connection to arccatalog but when I enable enterprise ...
0
votes
1answer
42 views

Conflicts in ArcMap editing with multiple users

There are multiple users of ArcMap using their own versions for uploading edits to our Master database. We are not live editing, these edits are reconciled and posted each day, sometimes twice in one ...
-3
votes
1answer
53 views

Code Works in Python Window but not Script

This code successfully completes inside the ArcMap Python window but fails as a script with identical code in a toolbox. The source data is a collection of feature classes directly inside an ...
1
vote
1answer
31 views

Using non-unique names for attribute indexes of file/ArcSDE geodatabases?

I am using ArcGIS 10.2.2 for Desktop. Within a file geodatabase does an attribute index name need to be unique? I thought that it did, but I have not been able to find any documentation to say ...
3
votes
1answer
33 views

SQL for spatial view of line start/end points (Oracle ST_GEOMETRY)

How do I create a spatial view that generates dynamic point geometry of the start point and end point of a line feature class? The environment is Oracle, SDE 10.3.1. I have successfully made a ...
0
votes
1answer
44 views

Automate the un-registering of replica

I'm working on an arcpy script that removes a feature class and then recreates it. The feature class is part of a replica, and I need to recreate the replica as part of the script, however you cannot ...
5
votes
1answer
53 views

Finding SDE permissions on feature class using ArcPy?

I am writing an arcpy script where an SDE feature class is removed then recreated. I need to set permissions on the recreated feature class that match the permissions before it was removed. Is there ...
1
vote
1answer
31 views

I can not add geodatabase connection from another PC to SQL server 2014

I have a problem. I can not solve it. I did everything what I think. I install SQl server 2014 and create Test1 database on My PC. Now I want to add Geodatabase connection in Arccatalog on Another PC. ...
0
votes
0answers
17 views

Date Field Changes When Uploaded to ArcServer then ArcGIS Online

I have a feature class in my SDE, that is archive enabled, and has Object ID's. I also has a field within it (fieldtype=DATE, fieldname=ProjectedDate), that is configured (mm/dd/yyyy). When I ...
0
votes
0answers
6 views

Error found while retrieving conflicts ArcMap 10.3

I have a problem when trying to review Conflicts in ArcMap 10.3 I have found a similar question ,and in the solution there was a link to download ArcSDE service pack , but the link was invalid . ...
1
vote
0answers
43 views

Feature classes not visible to some ArcSDE users? [closed]

Some of my organization's data (several SDE databases) has been migrated to a new server and we have recently upgraded from ArcGIS 10.2 for Server to ArcGIS 10.4 for Server and SQL Server 2005 to SQL ...
0
votes
0answers
17 views

Updating ArcSDE Database using VB.Net?

I have a master feature in a SDE Database. This Master file contains the records of all "inspections" being undertaken. I have a second feature, which contains a "live" dataset of current inspections....
1
vote
0answers
21 views

Slow SDE Feature Class Performance

I've been experiencing slower than usual performance (noticeably slow time to draw as well as query, compared to similar feature classes) with a specific feature class in my organizations enterprise ...
0
votes
0answers
37 views

HRESULT EXCEPTION error - Arcmap Geoprocessing .net

I am writing a script / Add-in for Arcmap and am coming unstuck with an error when I am trying to "delete identical" records in an SDE Geodatabase. Running through the process. I have a SDE ...
0
votes
0answers
25 views

bring back column info in sde descendant version

I have a feature class registered as versioned in sde with editor tracking turned on. In my edit version, I was updating one field for all records but forgot to turn off the editor tracking before ...
0
votes
0answers
25 views

Querying Archive Class with REST API of ArcGIS Server?

I would like to know if there is a way to access the archive class through a Map Service of ArcGIS Server. I have a Map Service with feature class stored in a SDE GeoDatabase with Archiving and ...
0
votes
0answers
12 views

Uploading Photos to SDE

We have several users using Collector for ArcGIS and the majority of them take pictures/videos. Once the database has been downloaded from ArcGIS Online, we’d like to load this data, including the ...
0
votes
0answers
20 views

Selection anchor when selecting features programatically

In an edit session, I am using code to select multiple features from an SDE polygon layer. After the selection is performed, the user can then use the rotate tool to adjust the features to their ...
0
votes
1answer
49 views

Arcpy Slow to Read Datasets from Connection (.sde) File

I'm looking to automate publishing map services to ArcGIS Server, and in doing so I'm creating map documents that have only one layer; each layer is from a SQL Server 2014 database that I am accessing ...
0
votes
0answers
33 views

Updating old attribute values with new ones in enterprise geodatabase?

I want to update values of a field with a new value. For example, the old value is U13-1234 and I want to replace it with a new value of DT1-1453. I have around 500+ records and i want to update ...
2
votes
1answer
60 views

saving survey123 data programmatically using python

I'm recording data using the Survey123 app which logs data into a standard ESRI rest service, stored in my AGOL account. I would like to save this data an SDE dataset. Is it possible to do so using ...
1
vote
0answers
37 views

Why would ArcMap always crash (but not immediately) after Reconcile & Post?

I've been plagued over the past several months by a problem in which ArcMap (10.2.2, Advanced license) on Citrix (Receiver version 3.4) will crash at some point after reconciling and posting my edits ...
0
votes
0answers
20 views

Multiple UTM Zones in a geodatabase [duplicate]

I am currently setting up a geodatabase for the province of Alberta. What would be the best practices for implementing a provincial geodatabase (ArcSDE/SqlServer 2008 R2) that happens to fall within ...
0
votes
1answer
25 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 ...
0
votes
1answer
149 views

How so I solve FDO error: 0? How do I get code that worked in a file geodatabase to work in an SDE version?

I used python add in to make a tool bar in Arcmap that edits features on a map. It works on a file geodatabase, but not on an ArcSDE version one. I've been getting an FDO error: 0. The potential ...
1
vote
2answers
71 views

Why can't I open this workspace?

I used python add in to make a tool bar in Arcmap that edits features on a map. It works on a file geodatabase, but not on an ArcSDE version one. I've been getting an FDO error: 0. The solutions that ...
1
vote
1answer
45 views

Finding correct service for arcpy.createArcSDEconnectionFile_management in ArcPy?

I'm working on a toolbar for modifying an SDE database in acrmaps. My code works in a file geodatabase so I'm trying to use this function to make it work in an ArcSDE. I've gotten every other variable ...
0
votes
0answers
30 views

Is there an Esri ST_Geometry function to remove m-values?

I'd like to use SQL to select the WKT geometry of an ArcSDE feature class of the type POLYGON M. However, I'd also like to suppress the m-values as I read them. PostGIS has a function Force2D that can ...
1
vote
1answer
76 views

enable enterprise geodatabase error

I am trying to enable an enterprise database. I right click > enable and then navigate to our organizations keycode file. I get this error: Attribute Column Not found... (see screenshot) This ...
2
votes
0answers
46 views

Can shp2sde on ArcSDE 9.3 server operate with SDE 10.3 database?

We have 2 servers running ArcSDE 9.3, and one Oracle database at SDE 9.3. Only one of the ArcSDE 9.3 servers is to be upgraded to ArcSDE 10.3, and the Oracle SDE database will be migrated from SDE 9.3 ...
0
votes
1answer
64 views

Python Script to update all feature classes/datasets in gdb with search and update cursor?

I have two geodatabases, one is a production sde database, the other is a backup in a local file geodatabase. The script runs as a task once a month and is very resource intensive. I am using ArcGIS ...
1
vote
2answers
43 views

Iterate feature class by Date created to select recent shapefile

I would like to select only newly created shapefile (today's). Every time new shape file are created from trimble pathfinder office which i need to upload to Arcgis server feature class. Model below ...
1
vote
1answer
34 views

Which Geodatabase version is holding how manyUNPOSTED outstanding Edits?

I have this generic versioned geodatabase question i.e.Which Geodatabase version is holding how many UNPOSTED outstanding Edits ?, which may be crucial to identify the query performance bottleneck in ...
1
vote
0answers
55 views

One way Replica deleted feature not synchronizing when I synchronize

I have created one-way replicas from 50 geodatabases to one geodatabase (Arcsde. With PostgSQL 9.2) After that, I update my feature class in parent geodatabase, but when I synchronize the replica the ...
3
votes
1answer
43 views

What are SRIDs like 30008 in an SDE geodatabase?

When I look at the SDE.ST_GEOMETRY_COLUMNS table of my SDE database I'm seeing mostly recognizable four-digit values, but a number of columns have SRIDs like 300006, 300008, and 300047. I can't find ...
3
votes
1answer
83 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) ...
4
votes
1answer
35 views

Are ESRI spatial views regenerated whenever they are queried?

If a spatial view contains data "joined" from multiple tables, will all the tables be queried whenever a query is executed against the spatial view? We have some spatial views and whenever we run a ...
4
votes
1answer
108 views

Error when using arcpy.ArcSDESQLExecute() to connect to SQL Server - ArcGIS 10.4

I am able to connect to a MS SQL Server 2012 geodatabase with the arcpy.ArcSDESQLExecute() when using the .sde connection file pre-created in ArcGIS. I am not able to connect to a MS SQL Server 2012 ...
1
vote
1answer
53 views

Deleting features with arcpy on ArcGis SDE 10.0 SP5

I am new to ArcGIS and arcpy and am learning largely through trial and error. Anyway, the overall task is to delete, edit and add rows to feature classes. I thought it would be good to start with ...
0
votes
0answers
41 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 [...
3
votes
1answer
44 views

Does the version admin workflow change when all users edit the SDE.DEFAULT version?

An esri blog article (5 Best Practices SDE Maintenance) states, when discussing updating statistics for an ArcSDE, "... in situations where all users are editing just the SDE.DEFAULT version [this is ...
1
vote
2answers
88 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 ...