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
0answers
297 views

Loaded shapefile into SDE without spatial proj creates problem

Via a Python script - various shapefiles were loaded into SDE with no spatial reference set. This causes a strange problem - when you view the featureclass in ArcCatalog (geography view) - it shows ...
4
votes
2answers
2k views

What is the best way to migrate an SDE Database

We have a prod database, with an SDE schema. We want to install a new SDE instance 9.3.1 and link it to a copy of the prod database. ArcSDE 9.3.1 on Linux SLES 4 Now, what is the best way to do ...
2
votes
1answer
251 views

Is there a way to delete definition querys of multiple layers in ArcMap 9.3.1?

I'm searching for a way to freeze/delete definition queries of several layers at once (instead of doing it manually by opening the properties of each layer). I'm working on a SDE 9.3.1 Geodatabase.
7
votes
3answers
4k 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 ...
2
votes
0answers
212 views

ArcObjects .NET 9.3 upgrade to 10 breaks IRasterDataset.Copy(…) code

I have to upgrade an application from ArcObjects 9.3 (C# .NET) to 10. Unfortunately, there seems to be some incompatibility regarding the IRasterDataset.Copy method. The following code worked fine in ...
5
votes
2answers
552 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 ...
3
votes
1answer
531 views

Extract data from QueryLayer to Shapefile

I have a QueryLayer that I need to export as a shape file. This was previously implemented as an ArcSDE feature class which we converted to a QueryLayer (running against SQLServer) in order to have ...
6
votes
3answers
2k 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 ...
3
votes
1answer
514 views

Spatial Database Connection String

From MS Access, I'd like to create a link to the attribute table of an SDE feature class in a spatial database. For example, I have the following connection string which works for an OLE DB ...
4
votes
2answers
1k views

Adding data from a SQL Server Spatial database to ArcMap or ArcEngine application with ArcObjects for better performance

I have an ArcSDE geodatabase stored in MS SQL Server 2008 R2. The datasets in this geodatabase range from 10 record to 7 million records and there is a mixture of tables and spatial datasets (SQL ...
4
votes
2answers
1k views

Where are imported Mosaic Dataset images stored on ArcSDE server?

I am trying to learn more about Mosaic Datasets and specifically how they interact with ArcSDE (SQL Server 2008). I read in How raster data is stored in a geodatabase that "...In the case of the ...
1
vote
1answer
479 views

Copying and renaming files on SDE connection

I have a script that renames and copies files (feature classes) on an SDE connection. This script works just fine if the feature class name does not start with an 'S'. If the feature class name does ...
5
votes
5answers
2k 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 ...
1
vote
1answer
1k views

Add Spatial Database Connection fails?

I created a Database Server (SQL Express 2008.) I created a "New GeoDatabase..." I double-click on "Add Spatial Database Connection." I fill out the dialog and change the transactional version. ...
4
votes
2answers
744 views

How to allow more polyline vertices for a ST_GEOMETRY in Oracle/SDE?

I'm receiving an error writing geometry (in ArcObjects) that has a large number of vertices (around 900). So big, but not ridiculously big. I would expect this to be no problem and I don't recall ...
2
votes
3answers
2k views

Is there a way to see the coded value domain list of possible values from arcmap 9.3.1?

Is there a way to see the possible values of a specific coded value domain in arcmap 9.3.1 (I have no access to the SDE which holds all the data in arcCatalog)?
1
vote
0answers
90 views

Can we do replication and versioning in User schema geodatabases version with sde default version

As both are administrators to their own schemas, is there any possibility to post and reconcile data across schemas?
6
votes
2answers
1k 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 ...
13
votes
2answers
328 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 ...
3
votes
1answer
265 views

SDE Topology dirty areas don't go away

Just looking for an explanation on SDE Topology dirty areas that don't go away. My workflow involves editing a version of SDE data, then once finished I use the Validate Topology in Current Extent ...
2
votes
1answer
337 views

Is there an se_toolkit version for ArcSDE 10?

I have the one for 9.3 downloaded--is there a version for ArcSDE 10? So far my 9.3 version of se_toolkit is working against 10 geodatabases, but I've only tried a couple of the tools(sdeping and ...
7
votes
1answer
764 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 ...
5
votes
1answer
1k 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
919 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 ...
2
votes
1answer
249 views

Query for Selecting only Selected Fc's from a GDB

I need to version n number of fc's which start with sde."ENT-QA". I need to select only those feature classes and run versioning for it. Can anyone help me in writing the query for selecting only fc's ...
8
votes
3answers
11k views

Define Workspace for SDE Connection in Python

How do we define SDE Connection for workspace in Python Scripting?
6
votes
3answers
707 views

How to convert high precision dataset to low precision

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 ...
4
votes
1answer
240 views

Migrating Feature Datasets from ArcSDE to postgis

I am currently planning the migration of a database from ArcSDE/ Arcmap to postgis / Qgis. The data is stored in raster catalogues and feature datasets. Is there an equivalent to feature datasets ...
6
votes
1answer
371 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 ...
4
votes
2answers
433 views

ArcObjects ISQLSyntax with Oracle DB esriSQL_DelimitedIdentifierPrefix issue

New to stack exchange, heading over from the esri forums, it is great! I am trying to produce a query that I can use across all workspaces, naturally using ISQLSyntax. The problem I'm having is that ...
6
votes
1answer
515 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 ...
4
votes
1answer
341 views

DBMS and ArcSDE Architecture for Large (Mostly Non-Spatial) Dataset

I have ~1000 fixed points representing data collection stations with multiple sensors, and a csv that is ~4.5GB of values in the format: id pointid sensor measdatetime measvalue 50345 500 ...
7
votes
2answers
420 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 ...
4
votes
1answer
148 views

Attribute Indexes ArcSDE 9.3.1 for Attribute Joins on GUID field types

I create my joins on primary/foreign keys that are guids...I don't seem to be able to create an index on this field in my target table. After joining to this table it takes 4 minutes to open the ...
0
votes
0answers
614 views

ARCSDE; creating new geodatabase in database servers in arccatalog

I use arcsde 9.3. I want to access a geodatabase on mobile. when I want to create new geodatabase in the list of database servers in arccatalog the error is "error creating geodatabase no arcsde ...
4
votes
1answer
294 views

Geometry storage type in geodatabase Oracle 9i with SDE 9.3.1

How do I identify what geometry storage type is being used with a specific geodatabase? Thanks.
2
votes
1answer
209 views

Connect to ArcSDE geodatabase over LAN?

I am running ArcGIS Server 10, with ArcSDE 10. I have a geodatabase that I would like my colleague to connect to over the LAN at our office. How do I go about doing this? I would prefer a list of ...
17
votes
8answers
6k 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 ...
9
votes
3answers
2k 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 ...
2
votes
2answers
301 views

Short name for SDE featureclass?

Is there an ArcObjects function to get a short name version of an SDE featureclass? For example if my featureclass is: FOOSCHEMA.BARLAYER How do I just get "BARLAYER". Or is it just a simple case ...
3
votes
1answer
1k views

Can ArcPy test for availability of SDE Connection before trying to use it?

In a Python script that I use to publish ArcGIS 10.0 Geoprocessing Services I have some code: arcpy.AddMessage("If process hangs here, check for ArcSDE connections issue by trying to open " + mapFile ...
2
votes
3answers
2k views

Trigger on SQL Server 2008 ArcSDE 10 and ArcGIS Server 10

I need to build a sql server db trigger to update a date field with the current date when a record is inserted or updated, I think. I will be using the date field as a way to recognize ...
0
votes
2answers
515 views

Why would programmatically setting the extent of a map on Page_PreRender be really slow?

We are using the ArcGIS 10 web adf with C# in a web application. We just recently upgraded everything from 9.3 to 10 and moved all the hosted stuff over to a new (more powerful) server. Still on the ...
1
vote
1answer
2k views

Trouble creating ArcSDE Connection File

I'm having trouble creating a ArcSDE Connection File. When I bring up the GP tool to do this, I enter the folder I was save the sde file to, enter an name for the file 'MySDEConnect.sde', enter the ...
0
votes
1answer
179 views

How do I assign a variable to a SQL Server ArcSDE database's feature class?

I'm using ArcGIS Desktop 10 and have no experience using Python with a SQL Server ArcSDE database. When using a shp file or file gdb it is very simple to reference a given feature class by simply ...
7
votes
2answers
2k 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 ...
1
vote
0answers
301 views

T-SQL with SDE and Web Map ArcGIS Server 10 MSSQL 2008

I need to build a system whereby the user of a web map (the standard web map that ArcGIS Server Manager builds) can edit a feature class's attributes. The attribute will be a 'Comments' field. The ...
2
votes
2answers
196 views

How to store large amounts of text in an SDE table

I need to store a lot of text in a field in an SDE registered business table (an ITable, not a featureclass) - let's say 10,000 words roughly. I am using Oracle 10g and ArcSDE 9.1. I am programming ...
1
vote
0answers
330 views

Is it possible to create an updateable spatial view? [closed]

1- I have encountered a problem relating with sde commands for creating sde_ view and also sde_table . I used appropriate codes but an error massage occured during execution. the related codes: ...
2
votes
1answer
455 views

How to cast SDE table to IFeatureClassLoad

How do you cast an SDE table to IFeatureClassLoad using ArcObjects? I'm getting an error with this attempt below which is not the correct method: Dim pSDEFeatWksp As IFeatureWorkspace = ...