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)

7
votes
2answers
315 views

ArcSDE : Cascading Subtypes in ArcGIS 10/SQL Server

I'm currently creating an ArcSDE DB on an SQL Server. It is designed to complete species survey, with information from the field. In order to help themselves, they asked me to implement a particular ...
7
votes
1answer
132 views

How to split Relationship Class privileges between different users while maintaining referential integrity?

I am using a relationship class to maintain a one-to-many relationship between material sites (under Engineering's purview) and the material sites' sample status and content (under Materials' ...
7
votes
3answers
871 views

Converting high precision dataset in file geodatabase to low precision using ArcObjects?

A high precision dataset was loaded from a file geodatabase into arcsde 9.3.1. The dataload was achieved by copy/paste in ArcCatalog. A custom tool (arcobjects) that extracts from the dataset to a ...
7
votes
0answers
253 views

Why do file geodatabase and SDE readers produce different fme_geometry types?

I have one very simple workbench that I am running against both SDE (9.3) and FGDB (10.0) sources. I noticed two different fme_geometry values for same type of objects. For the first one, i.e SDE ...
6
votes
5answers
1k views

Troubleshooting ArcObjects performance problems

We have developed a relatively complex geoprocessing routine using a C# / ArcObjects (COM) / ArcGIS Server 9.3.1 / ArcSDE 9.3.1 / Oracle 11g stack. Running the routine on a complete dataset takes ...
6
votes
3answers
3k views

Reconcile Versioned Geodatabase with only DEFAULT version?

Follow up to this: Spatial Database Connection String I am trying to reconcile a versioned geodatabase that has only one version, DEFAULT. I am following the steps from the ESRI documentation: A ...
6
votes
2answers
1k views

ArcSDE Geodatabase MS SQL Server restore of .bak file

If we have ArcSDE 9.3.1 running on MSSQL Server 2008 R2 Enterprise and we do a full backup of a geodatabase. Then I try to restore the .bak file to a MSSQL Server 2008 R2 Express on a machine that ...
6
votes
3answers
3k views

When to store geometries using SQL-server geometry datatypes or ArcSDE?

With the release of SQL Server 2008 Microsoft added geometry data types. So geometries can now in an ESRI enviroment be either be stored using SQL-Server datatypes or ArcSDE datatypes. A colleague ...
6
votes
3answers
2k views

ArcGIS Server won’t release SDE table locks

My ArcGIS Server services are locking tables in SDE. This is a problem if I need to edit or overwrite them. Unfortunately the locks don't go away upon stopping the services. The only solution I have ...
6
votes
1answer
5k views

Connect to Postgresql ArcSDE 10.1

I cannot connect to postgresql 9.0.5 with ArcSDE 10.1, using ArcCatalog 10.1 on Win 7 professional 64 bit. I followed the steps described here, and installed the Pg-Agent from Stack builder. When I ...
6
votes
1answer
2k views

How to check whether a fc is registered as versioned or not using python

How can I check whether or not a feature class is versioned using python? I'm trying to register feature classes using a python script. Before I do this I need to check whether a feature class is ...
6
votes
2answers
1k views

How is the default label field chosen by ArcMap?

I have 2 questions: I know how to manually go to Layer Properties>Labels tab>Label Field and choose my label field. I also know that I could set up my primary label field and save the setting as a ...
6
votes
7answers
6k views

Troubleshoot editing features in feature dataset with ArcMap / ArcSDE Oracle

I am having trouble editing a feature class that is in a feature dataset. We have added just the single feature class as a layer in ArcMap and are using the "Start Editing" function on the Editing ...
6
votes
4answers
5k views

Copying ArcSDE geodatabase to file geodatabase using ArcPy?

I would like to make an exact copy (domains, feature datasets, feature classes, etc.) of an SDE database to a file geodatabase. I have tried several possibilities, including: using the Copy (Data ...
6
votes
2answers
590 views

Find Duplicate Feature Classes in ArcSDE Geodatabase?

I have inherited an ArcSDE instance that has 1000+ feature classes within which are around 100 Feature Datasets. I have found through manual exploration that there are at least some Feature Classes ...
6
votes
5answers
3k views

Can I copy an entire geodatabase with relationship classes and domains and reproject all feature classes from wgs84 to state plane?

I have an SDE geodatabase with several feature classes, tables, relationship classes, and domains. All the feature classes are currently in WGS84 coordinate system. I need an exact copy of the ...
6
votes
2answers
2k views

How are Class Extensions associated with a Feature Class in ArcGIS v10?

In ArcGIS 9.x if a Feature Class is registered with a Class Extension the CLSID of the extension is recorded in a table in the sde schema called sde.GDB_OBJECTCLASSES (EXTCLSID field). However in ...
6
votes
2answers
918 views

Oracle / SDE: ST_GEOMETRY or SDE Compressed Binary

I read data from a SDE database (Oracle) directly. How do I know, which format is used to store the geometry data? Do I have to check the DataType for the geometry column or is this information ...
6
votes
3answers
1k views

Options for ArcGIS Server and ArcSDE Hosting

I know this was partially address here, but it was not specific to ESRI products. I want to find some place to create and host map services with ArcGIS Server and ArcSDE. ESRI cloud options are bit ...
6
votes
5answers
1k views

ArcSDE installation with PostgreSQL (error - 1015)

I am trying to install ArcSDE for Postgresql on CentOS 5.5 in i686 architecture. I have successfully installed and configured Postgresql. I did SDE pre-installation and as ArcSDE user, run the ArcSDE ...
6
votes
2answers
1k views

How do you connect to a SDE instance on EC2?

We are exploring using Amazon EC2 with ArcGIS Server - and none of us has any experience with it. The question "How can we, from within our intranet, connect to the remote SDE instance in the EC2 ...
6
votes
1answer
939 views

Is this possible with ArcGIS using replication?

I work for a telecom company dealing with fiber management. We have a sister company south of us who we share some fiber and fiber equipment with. Both of us will be using ArcSDE databases. We want ...
6
votes
2answers
1k views

How to Export a Personal Geodatabase to ArcSDE

I want to copy/export my personal geodatabase which consists of feature datasets, relationship class etc to an Enterprise geodatabase. What would be the best approach?
6
votes
2answers
1k views

Understanding Geodatabase Archiving and H tables in ArcSDE?

We have ArcSDE 10.0 on MSSQL 2008 with Geodatabase archiving enabled. In the process of updating a topology I deleted the topology, disabled archiving, unregistered as versioned and then recreated ...
6
votes
1answer
1k views

How to transfer data and replica information from a file geodatabase to ArcSDE?

I've got an arcgis 10.1 file geodatabase that contains a number of featureclasses and a number of one-way child replicas. Is there any tool that I can use to transfer the data and replica information ...
6
votes
2answers
1k views

Autonumbering fields in versioned ArcSDE Geodatabase?

I want to have a field with autonumbering in ArcGIS. I have a versioned ArcSDE for SQL Server geodatabase. Thus, using the identity seed attribute in the SQL Server is not an option. Is it not ...
6
votes
1answer
1k views

Installing ArcSDE 10 on SQL Server 2008 R2 Cluster 64bit or 32bit?

I am looking for Tips an Tricks on installing ArcSDE on SQL Server 2008 R2 Cluster. Our IT division would like to have all the databases on their new 2008 cluster. I've only done standard install ...
6
votes
1answer
2k views

Registering SQL Spatial View in ArcSDE and updating Row_ID?

I am having issues registering an inner join SQL view with a spatial column in ArcSDE. Any help would be much appreciated. Here is the background info: ArcSDE 10, SQL Server Enterprise 2008 R2, SQL ...
6
votes
1answer
604 views

Can I update features in an SDE database from python without using an ArcEditor License?

I have a non spatial data set that I would like to keep sync'ed in SDE as a spatial set. So I would like to be able to insert, update, and delete without using one of my two ArcEditor licenses since ...
6
votes
2answers
323 views

Why am I getting duplicate ghost points (features), i.e., one point in the feature class but two points?

When editing some of the attributes in a point feature class in ArcMap 9.3, duplicate labels started showing up. When I click on the point, I discovered that the point has duplicated itself BUT there ...
6
votes
1answer
254 views

How to create ArcSDE Geodatabase in PostgreSQL without ArcGIS Desktop?

I am programming a small application using Arcobjects, and I need to create an ArcSDE geodatabase on PostgreSQL. In ArcSDE at 10.2 there is no Post Installation Wizard. How do I create a Geodatabase ...
6
votes
1answer
444 views

When to use multiple geodatabases?

I'm working on a project involving one database , but the customer's needs have evolved, so he needs to manage multiple projects. I tried to work with adding an id for each project, which gave me more ...
6
votes
2answers
442 views

How to undo ArcGIS “Move Edits to Base” mistake?

I'm trying to help a client who mistakenly checked the "Move Edits to Base" option when versioning a feature class in ArcGIS. They would now like to fix this mistake. However, they don't want to ...
6
votes
2answers
581 views

ArcSDE locking Oracle schemas?

We changed a password on an Oracle schema, but apparently we have some rogue SDE clients - probably old ArcGIS map services on a dev machine somewhere - attempting to connect with the old password. ...
6
votes
1answer
425 views

Changes in synchronized replica not shown in ArcMap or ArcCatalog without refreshing

I am synchronizing a one-way replica in ArcEditor using Python. I tried adding RefreshActiveView and RefreshCatalog to the code, but I still need to refresh the synchronized database to see the ...
6
votes
1answer
466 views

Automated geodatabase replication with offline editors

I would like to design an application that would use an SDE database with simple features and a geometric network. That geodatabase would then be replicated out to any number of personal geodatabases ...
6
votes
1answer
660 views

ArcGIS 10 Linux experience

We have ArcGIS 10 installed on a nice clean Linux box. We have developed scripts to run on the Windows desktop development machines, and modified them to run on Linux. Now, if we run the scripts on ...
6
votes
0answers
288 views

ArcObjects : Out of Server Memory when reconciling a large edit session

One of our users has been periodically experiencing Out of Server Memory errors with ArcSDE 10.0 when trying to reconcile a large edit session. VMware ESX Instance: Windows Server 2008 R2 ...
6
votes
3answers
336 views

How do I retrieve a feature outside of ArcSDE into an IFeature in ArcObjects?

I would like to be able to use Entity Framework with a repository pattern for non-spatial querying of my SDE Sql Server database. I was hoping to reverse code-first engineer the database with the ...
6
votes
1answer
440 views

Creating a VB.net Dataset in Visual Studio 2010 from an SDE Geodatabase

I am building an ArcMap Addin that contains several Windows Forms with controls that need to be bound to a database. I am trying to decide whether or not to use a native SQL Server Database or an SDE ...
5
votes
1answer
327 views

Listing ArcSDE versions using ArcPy?

I have an ArcSDE geodatabase with different versions for each user. How can I list each version using ArcPy?
5
votes
2answers
930 views

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

I am working in ArcGIS 10.1 with tables from Oracle, now under control of SDE, after making use of the option: 'Register with Geodatabase'. All these tables have a column named 'Objectid' with an ...
5
votes
2answers
812 views

What is the maximum number of features a SDE featureclass can hold?

I have a SDE 10.0 Geodatabase based on MS SQL 2008. I'm running a continuous process where about 6400 point features are written to a feature-class every hour. I need it to be a featureclass, since ...
5
votes
2answers
697 views

What does it mean to QI and how is it done?

I'm new to Esri's Arc* interfaces, and trying to figure out how to register an existing table using the ArcObjects API. The following question answers this to some extent: Is there any way to write a ...
5
votes
1answer
666 views

Is there a way to change environment settings of a dataset without creating a new one?

I am trying to change the environment settings of an existing dataset. I found a workaround by first changing the environment settings in the SDE-database and then create a new dataset with now ...
5
votes
2answers
261 views

ArcSDE recently modified geometries

ArcSDE 10 with a MS SQL 2005 backend. I am trying to see the most recently modified geometries using SQL so that I can use it to update another GIS database running PostGIS. Has anyone tried this ...
5
votes
2answers
382 views

Is it possible to force uppercase in a geodatabase string field?

I have certain string fields in my geodatabase tables with which I would like to enforce an all-uppercase rule. These fields are ones that do not lend themselves to domains (such as address fields). ...
5
votes
1answer
874 views

How to determine using Python whether ArcSDE table is registered with geodatabase?

In an effort to improve my Python skills, I am trying to build code to automate the Compress and Analyze commands for our SQL 2008 R2 SDE database (code below). The Compress code works as does the ...
5
votes
2answers
775 views

Why unable to edit ArcSDE from multiple computers on LAN using custom ArcGIS Engine application?

I cannot edit an ArcSDE database from multiple computers on a LAN network using a custom ArcGIS Engine application, I have tried both versioned and non-versioned feature classes, but they cannot be ...
5
votes
2answers
569 views

Why shouldn't data be loaded into an enterprise geodatabase logged in with sde user?

I've read somewhere that it is not good practice to load data into an enterprise geodatabase using the sde user. I was wondering what the reason for this is? Thanks.