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
4answers
2k views

error in arcsde service

I am getting an error message when atempting to Create a connection in Arc Catalog. The message is : Failed to Connect to database SDE not Running on Server Then I Check the Service esri_sde it has ...
3
votes
1answer
2k views

How do I create a functional spatial index of an ST_Geometry Feature Class in Oracle/SDE?

Copied an SDE feature class (with blob(sdebinary(?) geom) into the same SDE GDB (Oracle 11g/SDE 9.3.1) but with the ST_geometry configuration keyword. I can see that the feature class was created, ...
5
votes
1answer
3k views

ArcObjects: modifying feature field value

I'm developing an ArcMap extension and looking for a way to change feature attributes knowing its feature class and OID (and, presumably, everything else that there is in IFeature). All layers use ...
3
votes
1answer
668 views

Understanding why ArcSDE FeatureLayer is read only and FeatureTypes property is null?

I have a WPF FeatureLayer backed by an ArcSDE 10 feature class that I hope to use for editing. After the layer is done initializing its readOnly property is true, I think that this points to some ...
7
votes
3answers
342 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 ...
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 ...
1
vote
2answers
2k views

How do I use Oracle Locator's mdsys.sdo_geometry with ArcSDE?

I'm using the Oracle Locator MDSYS.SDO_Geometry type to store my spatial information and then accessing it through ArcSDE. I'm confused about how the precision component of the metadata is used and ...
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 ...
3
votes
3answers
252 views

Is there any way to write a snipet of code with function of “SDELayer -o register” command

I try to create a geodatabase using some SQL command and then register some tables of it with SDE. I create an empty geodatabase using sde post installation and then create tables and other database ...
2
votes
1answer
189 views

Database View in Oracle 9i with SDE 9.3.1

If I have a sql statement creating a view against ArcSDE 9.3.1 on Oracle 9i, is the best practice to create the view in ArcCatalog just creating the name (kind of shell of the view) then going in to ...
3
votes
1answer
1k views

How to insert DateTime null using IRowBuffer

I am using IRowBuffer/IFeatureBuffer to insert fields to SQL Server 2008 DB. When inserting a field I am using: public void SetValue(IRowBuffer buffer, string field, object value) { int ...
3
votes
2answers
348 views

How to perform a “vertical integration” using FME?

I am not a GIS person, but I need to understand an aspect of the project I'm working on. We are taking an ArcSDE layer, and importing it into FME. I now need to do some checking of the data. In ...
9
votes
1answer
990 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 ...
2
votes
3answers
714 views

Definition Query to Python script on Oracle 9i and ArcGIS 9.3.1

SUBTYPECD=1 AND SERIESNAME NOT LIKE '%-%' AND OPERATIONALSTATUS IS NULL OR SUBTYPECD=1 AND SERIESNAME NOT LIKE '%-%' AND OPERATIONALSTATUS = 976 The above is my def query in ArcMap against ArcSDE ...
1
vote
2answers
499 views

Access Feature Classes on Multiple Database Schemas with ArcSDE

I am using ArcObjects to access a GeoDatabase that was set up with ArcSDE 10 and SQL Server 2008 R2. In this particular case, I have some tables set up on alternate schemas (this is to replicate a ...
1
vote
2answers
183 views

Associating data in a form with an SDE Layer

I was wondering if there was a way to associate/persist some data about an SDE featureclass when viewing via ArcCatalog. I know you can have metadata - but I don't want to use that, and I'm pretty ...
4
votes
2answers
957 views

Updating ArcMap links to ArcSDE Geodatabase feature classes?

I've seen questions about attemting to repair a .mxd file with broken links. What I would like to do is get ahead of this issue and "fix" it before it becomes a problem. I have my data in an ArcSDE ...
6
votes
1answer
659 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 ...
1
vote
1answer
544 views

How to execute gp.execute ArcSDE tool in C#

So I created an ArcGIS 10 toolbox in ArcSDE and added a tool to it. There are enough examples out there on how to execute a tool.tbx that resides outside SDE or GeoDB. But in C#, how do you use ...
3
votes
2answers
700 views

ArcSDE database connection strings for ArcCatalog

Anyone know where the Database Connection strings are located in Program Files for ArcCatalog? I have all my Database Connection strings fixed and all my scripts use them. My computer went down and ...
1
vote
3answers
1k views

ArcSDE & Oracle & Database Model — Best diagram the system

Having Oracle dbms with ArcSDE and ArgGIS Pipeline Database Model (APDM), I would like to best describe the system with a diagram. In MS SQL each db is autonomous, I think, meaning ArcSDE(using dbo ...
3
votes
3answers
2k views

How to avoid dbo.arcsde LOCK issue while exporting to ArcSDE

I had a spatial db connection open in arcmap. While exporting to SDE with a console app I get an error in the console: Lock request conflicts with an established lock [DBO]. Does this just mean ...
0
votes
1answer
1k views

Safely replacing ArcSDE feature classes using transactions in ArcObjects?

I am using C#, ArcGIS Server 10, MS-SQL Server 2008, and I want to replace an ArcGIS SDE feature class inside of a transaction. After the deletion of the feature class, I have to create a new one with ...
2
votes
1answer
301 views

arcgis10: export eventlayer (from querylayer) to ArcSDE

I am not using arcmap but I am creating a arcgis desktop console app. I am pulling an external SQL table in as a querylayer. This table has lat & long so I created an eventlayer (or ...
1
vote
1answer
181 views

Enable Archiving failing on sde 9.3.1 and MS SQL Server 2008

I am trying to enable archiving and am getting this error: Violation of PRIMARY KEY constraint 'archives_pk'. Cannot insert duplicate key in object 'dbo.SDE_archives'. Is this saying that there is ...
4
votes
4answers
513 views

Record Date and User for an edited feature

The client has a Feature Class in SDE 9.3.1. When a feature in the feature class is edited the client wants to automatically record the date/time and who edited it in the feature class attributes. ...
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 ...
1
vote
3answers
1k views

Is the “sdetable” command available with ArcGIS Workgroup

Is the "sdetable" command available with ArcGIS Workgroup, or only the Enterprise edition? We have ArcGIS Server Workgroup 9.3.1 and want to update some of the feature class tables with data from ...
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 ...
3
votes
1answer
359 views

Publish ArcSDE FeatureService for Versioned Editing

Scenario: I need to Publish a data (from ORACLE ArcSDE) for versioned editing. Each user should be able to connect to his version and edit the data throu web application (Silverlight/JAVA/Flex API). ...
3
votes
2answers
488 views

ArcSDE 9.3.1 -> Performance

We have a number of mapservices in ArcGIS Server 10.0 that reads data from FGDBs. We are now moving that data in to ArcSDE and the plan is to use this data from AGS. Is it better to connect to SDE ...
4
votes
3answers
2k views

Spatial Views in SDE - What causes them to become unregistered from the geodatabase

Spatial views in ArcSDE allow you to join columns from a 'non-spatial' table in the database to a table with a 'geometry column'. They can also allow you to format and choose the attribute columns ...
2
votes
2answers
1k views

Using Flex to display single rasters from raster catalog in ArcSDE/ArcGIS server?

One of the front end develoeprs here is having issues displaying, or working out how to display a single raster held in a raster catalog in ArcSDE using the Flex 2.2 API the Raster Catalog holds ...
1
vote
1answer
162 views

ESRI fc is called database.DBO.fcname and version is called SDE.fcname

ArcSDE 9.3.1 and MS SQL 2008 R2 In ArcCatalog the feature class is called database.DBO.fcname and when I look at the connection properties in ArcCatalog the default is called DBO.Default and the other ...
5
votes
3answers
350 views

After running the Version Changes tool ..Export pre-reconcile/post records from parent

I would like to export those records identified as changes after running the Version Changes tool before running Reconcile and Post tools. Preferably with python or having python call a program to do ...
9
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. ...
3
votes
2answers
717 views

Oracle Linestrings and MultiLinestrings

We have a very complicated setup for a project we are doing, and it involves 40+ developers and two oracle databases, one with sde and one only with oracle spatial and it's quite big. We'll here are ...
4
votes
3answers
2k views

Delete a feature data set in SDE 10 programmatically

Is there a way to delete a feature data set and all of its feature classes programmatically either by using custom code or pre-existing command line tools? There is a tool provided by SDE called ...
3
votes
1answer
1k views

Customize geocoding locator styles in an ArcGIS Server environment

Using ArcGIS Desktop, it is relatively straightforward to customize locator styles by editing the corresponding CLS files. We are struggling to do the same in a server environment. We have created a ...
1
vote
2answers
2k views

How can I insert new records to an ArcSDE feature class from a view in ArcSDE

I am wondering how I can both insert new records from a view to a feature class and update data that may be newer in the view than in the feature class. I have been fumbling around in modelbuilder and ...
3
votes
2answers
1k views

Creating Python script to reconcile/post geodatabase versions?

I’m trying to set up a python script so that I can schedule our rec/post to run on a server. I’ve created a model with the Reconcile Version tool, with the option to Post checked on. I then export ...
2
votes
1answer
752 views

Creating ArcSDE Geodatabase without post installation?

Is there any way to create an ArcSDE SQL Server 2008 geodatabase without : SDE post-installation execution on the server having sde service running on the server and using : execution of some ...
5
votes
1answer
344 views

Address locator not using modified .cls file

I have made a customization to the US Streets locator style for our application. We've changed "SR" to map to "STATE ROAD" instead of "HC" in the us_addr.cls file in the C:\Program Files (x86)\ArcGIS ...
2
votes
1answer
566 views

Filter features with multi-table joins in ESRI Silverlight/REST API

We have a rather involved data warehouse (SDE 9.3.1 / Oracle 11g) that contains a single related point feature class. Our (analytical) application should allow users to construct complex, ad hoc ...
2
votes
3answers
2k views

Table to Table script fails when copying to SDE

Since TBL2SDE no longer exists (we're running a 64-bit server and ArcGIS 10 doesn't include that executable on a 64-bit installation) I've been using the Table to Table script in ArcToolbox to copy ...
2
votes
1answer
485 views

Oracle tracing, bind variables, and ArcSDE

Oracle tracing with TKPROF is the recommended way to troubleshoot data access performance problems with SDE/Oracle. Unfortunately, queries that differ in any way are considered "different" and ...
3
votes
1answer
1k views

Creating Stored Procedure in versioned SDE_SQLServer geodatabase using DDL?

I've almost used SQL server_SDE geodatabases for 3 years in GIS projects and I don't know how can I create a stored procedure in geodatabase.I use ESRI case tool to create a geodatabase in ...
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 ...
1
vote
2answers
256 views

Keeping SDE for data maintenance, but use postgis for display

We build and maintain GIS data in a production environment with SDE on SQL 2008. We also have a need to open up WMS and WFS that will make a complete ESRI solution really expensive. With an ArcGIS ...
1
vote
2answers
2k views

How do I programmatically update/recreate an ArcSDE feature class from external sql data?

I have an ArcSDE feature class that contains project points based on xy data from an external SQL databaes. (Not a geodb). I am looking for the best way to "recreate" the ArcSDE feature class from the ...