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)

4
votes
2answers
488 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
613 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 ...
5
votes
2answers
364 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
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 (...
4
votes
1answer
171 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
700 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
333 views

Identifying geometry storage type in geodatabase stored in Oracle?

How do I identify what geometry storage type is being used with a specific geodatabase stored in Oracle 9i via ArcSDE 9.3.1?
2
votes
1answer
225 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 ...
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 ...
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 ...
2
votes
2answers
314 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
2k 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 ...
4
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 updates/...
0
votes
2answers
600 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
190 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
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 ...
1
vote
0answers
315 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
214 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 ...
2
votes
1answer
573 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 = ...
0
votes
1answer
197 views

How to connect to another server with ArcSDE?

how to connect from my server in our office to another server in another office with internet and access to their geodatabase by use of ArcSDE ? sincerely
1
vote
1answer
1k views

ArcGIS Server 10 and SQL Server 2008 R2 permissions and feature services

I have ArcGIS Server 10 with SP1 and SP2 on windows server 2008 and ArcSDE (from an edn liscense) installed on top of MS SQL Server 2008. When I make a spatial db connection in ArcCatalog (direct ...
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 ...
4
votes
1answer
971 views

Editing ArcSDE table with ArcObjects?

The link below provides a code snippet for editing an ArcSDE table with ArcObjects. Are there any other or newer code examples out there of how to edit an ArcSDE table by using ArcObjects? Edit ...
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 ...
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 ...
2
votes
1answer
1k views

How to solve an “Error found when retrieving conflicts.” error in ArcMap?

I uncovered this error when testing ArcMap 10 SP2 for a customer: This occurs when the conflict is detected--ArcMap is attempting to show the conflicts window but fails. I get this error on all ...
2
votes
2answers
1k views

ArcPy Changing Spatial Database Connection

hi we have conveyed our some servers which has ArcGIS application and SDE on it to another server and its ip has changed. now when i want to open my .mxd file it tries to connect remote SDE with old ...
3
votes
1answer
1k views

ArcSde Oracle Maximum number of grids per feature (8000)

I have a problem with the import of data (lines) to ArcSde Oracle. 2011-07-14 12:10:04| 22.9| 0.0|ERROR |Error while executing stream insert operation for table 'CHEMN'.:SDE_ERROR_CODE(-51) ...
0
votes
1answer
797 views

FME ArcSDE… the scale is very small

I have a problem with ArcSde and FME. I try to import some line features to ArcSDE Oracle. When I start the script in FME, I have some errors: impossible to insert linestring in ArcSde because the ...
1
vote
3answers
574 views

Editing non-nullable fields of ArcSDE layers in ArcMap

I'm using ArcSDE layer in my map project in ArcMap 10. Some of the fields of this layer allow null and some don't. I can't edit the non-nullable ones, neither programmatically (IField.Editable is ...
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
687 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
344 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 ...
4
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
354 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
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 ...
2
votes
3answers
715 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 9.3....
1
vote
2answers
502 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
186 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
964 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
668 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
552 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 gp....