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)

24
votes
8answers
8k views

When Versioning with ArcSDE can posted edits be cancelled or rejected?

I am using ArcGIS 9.3.1 and attempting to work with an SDE geodatabase (with one polygon feature class) that has already been registered as versioned. I'm new to versioning and am still trying to ...
24
votes
5answers
20k views

Is ArcSDE no longer needed at ArcGIS 10.1?

Through my frustration of not finding the post-installation wizard with ArcSDE 10.1 and being unsuccessful with the command line tool to start an SDE service on our SDE databases, I found I was able ...
21
votes
3answers
8k views

What is difference between ArcSDE and spatially enabled databases?

When would you want to use ArcSDE (available as ArcGIS Server Basic license level) versus a spatially enabled database? What are the trade-offs on either side? What are the benefits on either side?...
19
votes
2answers
2k views

Which geodatabase type is most appropriate for both open source and ESRI use?

Main Question: Is there a geodatabase type that seamlessly works with both ESRI and open source products? Details: My company currently passes around geodata in various vector and raster file ...
18
votes
7answers
3k views

How to migrate data from ArcSDE to PostGIS?

Its been suggested that i ask this question again, but perhaps worded differently than how to Bulk load multiple shapefiles into PostGIS. I'm new to postgis and sql but i want to use postgis as a ...
15
votes
3answers
5k views

Quickest way to select ArcSDE polygon by point in ArcGIS Desktop using ArcPy?

I keep thinking that I must be missing something, but there does not seem to be a tool in ArcGIS 10 to select features (in particular polygons) from a layer at a point (X,Y) location via ArcPy. The ...
15
votes
3answers
3k views

ArcObjects: Memory leak in IFeatureClass.Search (only on SDE with direct connect)

UPDATE 6/30/11: ESRI Support say they have reproduced the issue and have opened a bug report (NIM070156). I have determined that there is a memory leak (in unmanaged heap memory) that occurs when a ...
14
votes
1answer
1k views

Connecting ArcSDE to Quantum GIS for dummies?

I really have a need to be able to connect to and edit ArcSDE data in Quantum GIS. This question has been asked before and apparently is possible, but the instructions are just not specific enough ...
13
votes
2answers
449 views

Getting differences between old and new versions of ArcSDE database?

Is there a tool or a process that can reveal changes made to the schema of an ArcSDE database when comparing two versions of the same database hosted on different servers? I have an old database ...
13
votes
1answer
2k views

Why do simple joins on small datasets slow down ArcMap so badly?

ArcGIS 9.3.1, ArcInfo. I have some small file geodatabase and SDE featureclasses (few thousand records each, 50 columns) that I am doing attribute joins on. After the joins, drawing of the map is ...
12
votes
5answers
8k views

ArcSDE connection limit exceeded

We routinely exceed ArcSDE's connection limit, about once a week. Many of the "connections" are nothing but orphaned records in the SDE.PROCESS_INFORMATION table. Is there any way to clean up these ...
12
votes
2answers
1k views

Managing ArcSDE?

After spending a little time Googling for ArcSDE management best practices, I came up empty handed. I have a good understanding of Spatial Databases and their management having implemented several ...
12
votes
4answers
6k views

Is it possible to connect to ArcSDE using QGIS?

Is anyone aware of any plugins, or any other way to connect and view data from an ArcSDE database in QGIS desktop?
12
votes
1answer
690 views

Stop ArcMap from probing missing data sources on launch

When migrating a map from one environment to another (say, from an existing client environment to our development environment) we're often given MXD documents that represent the map. These documents ...
11
votes
7answers
7k views

Register SDE view and Layer

I'm building simple views against an ArcSDE Oracle RAC 10g. My SHAPE columns are of SDO_GEOMETRY datatype. ArcSDE 9.3.1. I have several point tables, with the following outline: ID (Guid) Name (...
11
votes
3answers
495 views

Searching many feature datasets for ArcSDE feature classes using field filters in ArcCatalog?

I have ~30 feature datasets and ~100 feature classes spread throughout the feature datasets. I would like to search for a feature class by name among the feature datasets. Also, I would like to ...
11
votes
2answers
4k views

Efficiently selecting related records using ArcPy?

Below is the code I'm using to replicate the "related tables" button in ArcMap. In ArcMap that button selects features in one feature class or table based on the selection of features in another ...
11
votes
1answer
1k views

Steps for creating an online webmap with editable features using ArcGIS Server/SDE and SQL Server?

EDIT/UPDATE: I'm adding a bounty to this in hopes of obtaining a step-by-step guide to creating an online map with feature editing using the ArcGIS Flex API, SQL Server Express and ArcGIS Server 10.1. ...
11
votes
2answers
1k views

Migration from ArcSDE (SQL Server) to PostGIS (PostgreSQL)

We've got all the geospatial information of our company within an ArcSDE Database (over SQL Server): points (locations of the antennas), lines (elevation, rivers), polygons (protected areas, ...
10
votes
3answers
18k views

Define Workspace for SDE Connection in Python

How do we define SDE Connection for workspace in Python Scripting?
10
votes
4answers
2k views

To what extent is SQL's language accessible via ArcGIS tools?

That question just sounds so redundant... At any rate, I have been asked to explore the uses of SQL in ArcGIS. We use an SDE DB for all server-side storage and DB managing/large-scale editing. However,...
10
votes
1answer
377 views

What is ArcSDE API used for?

To create applications that manipulate ArcObjects there is the VBA and Java runtimes. To create application that process data with ArcToolbox tools, there is ArcPy for Python. Today, I discovered ...
10
votes
3answers
137 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 ...
10
votes
2answers
2k views

What are benefits of using ArcGIS with PostgreSQL over simply ArcSDE?

I understand that in order to benefit from ArcGIS spatial datatypes (ST_GEOMETRY, versioned geodatabases etc.) ArcSDE needs to be installed - and with the 10.1 client it is automatically installed (...
10
votes
5answers
3k views

How to identify “true arcs” in Arcmap?

This is really annoying: the only good way of creating circles in ArcMap is using true arc, (compound curves) but I need to convert those to vertex (densifying) because of a compatibility problem. I ...
10
votes
2answers
896 views

Find duplicate vertices in SQL Server geometry line (ArcSDE)

I have a line in a ZM polyline featureclass that has a invalid geometry. My suspicion is that the line doubles back on itself somewhere, which I've found SQL Server doesn't like. Anyone know of a ...
10
votes
1answer
537 views

Is it possible to maintain primary keys on versioned featureclasses without arcobjects code?

Since it is not a good idea to use ObjectIDs as primary keys in relationships, some other column will need to be used. Is it possible to use DBMS sequences to populate primary key columns in ...
9
votes
1answer
3k views

Using PostgreSQL with QGIS and ArcGIS?

Is it possible to use PostgreSQL with QGIS and ArcGIS? i.e. one database for different clients. Is it anything that I have worry or any problems to use the DBMS from two different software? I know ...
9
votes
3answers
3k views

How to connect QGIS to SDE?

I read your amazing solution in this topic Is it possible to connect to ArcSDE using QuantumGIS?. Unfortunately I'm not so expert in open-source products (we use only Esri suite) and I need to ask you ...
9
votes
1answer
1k views

SQL Server Relationships in ArcSDE?

I am running ArcSDE 10 with SQL Server 2008 R2 Standard Edition. I am new to SDE and SQL Server, but I understand that SQL Server has the ability to create relationships between tables and maintain ...
9
votes
4answers
2k views

ArcGIS 10.2 Query Layer on SQL Server performance

I'm using a Query Layer on SQL Server in ArcMap. The Query Layer executes instantly in in SQL Server but but takes so long to draw in ArcMap that the system appears unresponsive for about 10 minutes ...
9
votes
4answers
4k views

Python script - how to avoid exclusive schema lock error?

I have a script for updating some features on my database every night (just for copying and replacing some features). This features are "read-only". My problem is that I can't avoid that these ...
9
votes
1answer
301 views

Is it possible to replicate an SDE geodatabase including the archive tables?

I have a database in one location which I would like to replicate to another using one-way replication. In testing we haven't been able to replicate the archive tables, which is unfortunate because we ...
9
votes
1answer
1k views

Large Scale Geocoding and Processing in ESRI

Ok, so I guess this kind of a informal query/survey about how big a datasets you are using in your ESRI worlds... I am building and maintaining a statewide dataset, where I have to process down to the ...
8
votes
2answers
9k views

How does one access a featurelayer in SDE via Python?

I am trying to use Arcpy to run the CopyFeatures_management script so that I can copy a featurelayer in SDE. What do I use for the input (and output, for that matter, since I'll be copying the layer ...
8
votes
1answer
300 views

Performing Full Text Search of Esri geodatabase?

How would you go about searching the contents of features, the values in the attribute columns, in an Esri geodatabase? (preference for file-gdb, but SDE would be useful too.) I can envisage workflow ...
8
votes
3answers
1k views

ArcSDE - use native geometry types for later migration away from SDE?

Background: We have a non-spatial reporting web application with a SQL Server backend. We would like to add a spatial component to this application: serve up some basemaps, serve up points and ...
8
votes
2answers
2k views

Is there workaround for very slow ArcSDE 10.1 data display

I'm suffering from very slow viewing data of and ArcSDE database from an Arcgis engine application, the SDE database is in localhost so there's no network issues. but i still don't know the reasons ...
8
votes
3answers
2k views

Permanently replace/update server/service in each ArcSDE Layer in MXD?

Using the mxd.findAndReplaceWorkspacePaths method, if and MXD is updated and the path the the .sde connection file moves again all of the data sources will break again. Is there a method to ...
8
votes
1answer
602 views

How to apply schema changes on Esri geodatabase two-way replica set?

I have an Esri geodatabase two-way replica set. I need to update the schema on both databases in the replica set. Esri describes doing this using ArcGIS schema tools (compare/export/import replica ...
8
votes
0answers
469 views

What qualifications should auditor have to auditing GIS? [closed]

Background summary: Various systems are being audited and GIS is the next to be audited. The initial kick-off for the audit was a meeting between me and a single auditor. Initially, I thought it was ...
7
votes
3answers
7k views

How to delete feature class features faster (ArcPy)

I have written this script that recurses through all feature classes in a given set of feature datasets and deletes all their features. It appears to do the job but it runs pretty slowly. Is there ...
7
votes
2answers
2k views

In a versioned geodatabase, what impact do delta tables and the state tree have on query performance?

We have a versioned arcsde geodatabase (arcgis 9.3.1 on oracle 10g) with a fairly complex data model that includes about 100 featureclasses and non spatial tables, a geometric network and many ...
7
votes
1answer
6k views

Creating a spatial “Many to one” join

I'm trying to create what I call a "many to one" join. I don't know if that would be the correct term or not. I have a table that has unique account numbers for mobile homes (i.e. - M1007970) per ...
7
votes
1answer
301 views

What is the overall architecture of ArcSDE, and how does it fit into the enterprise?

I'm finding many gaps in my understanding of ArcSDE, particularly as it relates to Oracle. I just can't quite wrap my brain around the overall architecture of it, and how it fits into an enterprise. ...
7
votes
1answer
388 views

Error in creating output … table already registered?

I am afraid I am a complete newbie to GIS and ArcGIS and it has fallen on my shoulders to try and resolve a problem with our ArcGIS installation. Assume I know nothing about GIS or the software ...
7
votes
1answer
1k views

Does a high number of SDE_state_lineages slow performance?

In our SDE database, the SDE_state_lineages table has around 200,000 records, the SDE_states has around 900, and our SDE_versions table has around 1,300 records. We've been having performance issues ...
7
votes
3answers
5k views

Is there automated way of releasing all ArcSDE layers locks?

We have an issue where users do not close ArcGIS and layers get locked, and sometimes this affects our nightly updates for some of the layers. I know you can individually remove a lock using the ...
7
votes
2answers
3k views

ArcGIS Server 10 - Feature Editing Services - Best Practices

What are some best practices for editing Multi-versioned sde data through a feature service? What should I be looking into? EDIT: seeing that when publishing a feature service the service is ...
7
votes
2answers
492 views

Very slow connections to ArcSDE with over 20,000 datasets

I have a problem with ArcSDE that I have never come accross before and I was wondering if anyone could shed any light on this problem. Problem ArcSDE 9.3.1: Connnecting to an ArcSDE instance (...