ArcSDE (Spatial Database Engine) is a server-software sub-system (by ESRI) that enables the usage of Relational Database Management Systems (RDMS) for spatial data.
17
votes
3answers
3k views
What is the difference between ESRI's SDE and Geospatial dbs?
When would you want to use ESRI SDE (I think it is called Server but I forget the level - please feel free to edit) versus a spatially enabled database. What are the trade-offs on either side? What ...
15
votes
4answers
5k views
ArcSDE 10.1 no longer needed?
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 ...
13
votes
2answers
197 views
Is there a good way to get a diff between an old and a new version of an SDE database?
Is there a tool or a process that can reveal changes made to the schema of an SDE database when comparing two versions of the same database hosted on different servers?
I have an old database that ...
13
votes
3answers
2k 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 ...
12
votes
7answers
1k views
How to batch synchronize 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 ...
11
votes
7answers
3k views
Versioning with ArcSDE - Is it possible to cancel or reject edits once they've been posted?
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 ...
11
votes
1answer
1k 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 ...
11
votes
2answers
556 views
ArcSDE Best Practices; Your thoughts
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 ...
11
votes
1answer
440 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 ...
10
votes
5answers
4k 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 ...
10
votes
1answer
198 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. ...
9
votes
3answers
1k 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
5answers
3k views
Is it possible to connect to ArcSDE using QuantumGIS?
Is anyone aware of any plugins, or any other way to connect and view data from an ArcSDE database in Quantum GIS desktop?
9
votes
2answers
341 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, ...
9
votes
1answer
319 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
534 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
7answers
3k 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 ...
8
votes
4answers
1k 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. ...
8
votes
2answers
491 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 ...
8
votes
3answers
277 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 ...
7
votes
3answers
294 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 ...
7
votes
2answers
933 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
3answers
1k views
ArcSDE - Is there an automated way of releasing all 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
3answers
287 views
Changing a coded Domain to no codes
If we have coded domains in the geodatabase model, what are any disadvantages to changing the codes to the Description. For example:
Existing Coded Domain:
Code, Description
1, Single Family ...
6
votes
5answers
777 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
1k 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 ...
6
votes
3answers
2k 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
2answers
389 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
2answers
298 views
Find Duplicate Feature Classes in ESRI Geodatabase
I have inherited a SDE 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 that ...
6
votes
1answer
821 views
Postgresql for Qgis and Arcgis - What to do/What not to do
Is it possible to use postgresql with QGIS and ArcGIS? 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 that I ...
6
votes
2answers
353 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
2answers
627 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
5answers
911 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
128 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
1answer
95 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. ...
6
votes
3answers
863 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 ...
6
votes
2answers
875 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 ...
6
votes
2answers
273 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 ...
6
votes
1answer
394 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 ...
6
votes
1answer
308 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
2k views
ArcSDE - where to start?
As I long ago figured out that I need more complex query-asking abilities (other than the standard select provided by arcgis), and as I will someday have to admin a small scale SDE database that will ...
6
votes
2answers
185 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
106 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
3answers
186 views
Help! - ArcSDE is locking our 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
182 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
564 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
1answer
85 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
1answer
63 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 ...
5
votes
3answers
3k views
Define Workspace for SDE Connection in Python
How do we define SDE Connection for workspace in Python Scripting. Its urgent please need your suggestion. Thanks
5
votes
2answers
3k 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 ...
