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)

2
votes
1answer
364 views

How to edit PostgreSQL geodatabase table using ArcPy?

I'm trying to update a table using a python script and it's not working. The table resides in a postgres geodatabase and is versioned. I have also verified my user permissions (I'm the admin). The ...
2
votes
1answer
159 views

Moving Versioned Data between different geodatabases

Can you please let me know how to migrate feature class which is registered as version and archiving is enabled on it From: Database Environment: ArcSDE 9.3, RHEL 5, Oracle 11.2.0.2 To Database ...
2
votes
1answer
277 views

gdal_translate produces tif with different colors as original

I am using SDE as my raster data source with the ultimate goal to tile this dataset: I am running the following gdal_translate command to generate the initial VRT: gdal_translate -projwin 390605 ...
2
votes
1answer
192 views

How to write an SQL query to select recently edited features with Editor Tracking enabled?

Conditions: ArcGIS for Desktop 10.2 and ArcSDE 10.1 Is there a way to select recently edited features using the automatically populated fields that Editor Tracking uses? The new Editor Tracking ...
2
votes
1answer
109 views

Change SDE Version in ArcGIS JavaScipt API depending on connected user

I am programming for an web editing application with ArcGIS API for JavaScript. I've published a version of ArcSDE with Feature Acces and I need to know how can I change in the web application from ...
2
votes
1answer
434 views

ArcGIS 10.0 get sde information out of .mxd

The overall goal here is to iterate through several directories of .mxd files and document which SQL Server instance of SDE they are pointing to, with the database name and feature class names. All ...
2
votes
2answers
1k views

ArcSDE 10: How to read/write to Oracle with ST_GEOMETRY using Java

I found the following in the deprecation plan of ArcGIS 10.2: ArcGIS 10.2 will be the last major release to support the ArcSDE SDK with the ArcSDE C and Java APIs. Today many other options are ...
2
votes
2answers
502 views

How to Register a Spatial View when ArcSDE is direct connect only?

I have an ArcSDE 10.0 set up with MS SQL 2008 R2 Database, on direct connect. There is no service running, nor installed. I have created a spatial view built on a couple of tables. I have followed ...
2
votes
2answers
436 views

Understanding ArcGIS Server connection types

Being relatively new to ESRI ArcGIS Server I have a question regarding the storage of ESRI SDE Databases - AGS 10.0 Enterprise and ArcSDE 9.3. Firstly the naming of the whole structure gets ...
2
votes
1answer
136 views

Arcpad checkout to an area

I would like to check out data from an SDE database but for performance sake, i prefer to delete all features outside of my survey area. i've tried to copy features in area from sde to a file GDB ...
2
votes
1answer
284 views

Why does Updating Location of ArcSDE Feature using ArcObjects .NET give Error HRESULT E_FAIL has been returned from call to COM component?

I have been able to connect to an Enterprise GeoDatabase, retrieve features from it and update attributes. However I am having problems accessing and then updating the shape property of a feature. ...
2
votes
2answers
308 views

SDE 10.1 Layers Not Loading in ArcGIS Engine Application

I have an ArcGIS application that works great when loading layers from SDE 10.0 but fails when trying to load the layers when they're pointing to a SDE 10.1 server. The only difference is the layer ...
2
votes
1answer
2k views

ArcGIS 10 querying Oracle 10g without SDE

I'm interested to see if anyone has successfully got this setup working, and if so how many sacrifices were required and to which deities. I am hoping to ultimately get ArcGIS Server 10 serving map ...
2
votes
2answers
463 views

ArcSDE: Specifying fields to not allow null values

I have a feature class in SDE that has various fields where the setting AllowNulls is set to FALSE. When creating a feature in ArcMap in this feature class it still allows nulls to be specified in ...
2
votes
1answer
902 views

Creating ArcSDE feature class in MS SQL Server?

Unfortunately I am totally dumb when it comes to programming, and very new to databases (mainly because I studied geography), so : I have a Microsoft SQL Database Server, and a ArcSDE geodatabase. I ...
2
votes
1answer
392 views

validate SDE features within arcObjects (cant use sdeLayer)

I'm trying to sweep through a feature class checking for invalid features (and log the invalid features). Would IValidation.Validate work or does that just check for rules? If not I'm guessing I ...
2
votes
1answer
892 views

Using of esriFieldTypeDate field in Add Features REST service?

I need to use Add Features REST service to add a new record to a table in an ArcSDE geodatabase. One of the field is type of esriFieldTypeDate, but I don't know how to populate this field in JSON ...
2
votes
1answer
239 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.
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 ...
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 ...
2
votes
1answer
460 views

ArcSDE 10 FeatureLayer is read only, FeatureTypes property is null, not sure why

I have a WPF FeatureLayer backed by an ArcSDE 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 problem ...
2
votes
1answer
727 views

How to create SDE GDB without post installation?

Is there any way to create a SDE sqlserver2008 geodatabase without : SDE post-installation execution on the server having sde service running on the server and using : execution of some DDL ...
2
votes
4answers
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
2answers
504 views

Big IRowBuffer problem

I have a small software that connects to a database (SQLServer) reads a few values and transfers them to a SDE Oracle instance (11g). The problem is: I have over half million records that I need to ...
2
votes
1answer
44 views

How can I create custom offline maps for Collector on an ipad without SDE?

ESRI has informed me that you can only create custom offline maps for collector units if you have an SDE set up with your GIS server. They said SDE is the only way to publish maps up to the ...
2
votes
1answer
42 views

Moving geodatabase from SQL Server 2008 R2 Express to SQL Server 2012 Enterprise

I am able to successfully move an ArcSDE geodatabase from one SQL Server 2008 R2 Express to another SQL Server of the same version using the restore backup method. Now I tried to move it the same way ...
2
votes
2answers
41 views

Using a selection tool will select everything

When I use the Selected Features tool and try to drag a box around a few small items it grabs everything. If i use the edit tool it will correctly select only features that are inside/intersect the ...
2
votes
2answers
56 views

connect ArcGIS server with different instances of oracle database

Is it possible for a development team to have personal oracle database instances, for testing purposes, connected with the same GIS server? In other words I want every user to work with his own data, ...
2
votes
1answer
103 views

Python script fails on stand alone but works in ArcMap as a toolbox

I have a fresh install of ArcGIS Server and ArcGIS for Desktop both 10.2, latest patches applied. The data is served in this application from a PostgresSQL enterprise geodatabase. The problem is that ...
2
votes
1answer
105 views

RuntimeError: Field is not editable when using InsertCursor on ArcSDE geodatabase with ArcFM installed?

We are running ArcGIS Desktop 10.1 SP1, and also have ArcFM installed. I have this simple code: workspace = "C:\\my.sde" arcpy.env.workspace = workspace edit = arcpy.da.Editor(arcpy.env.workspace) ...
2
votes
1answer
30 views

How to enable sde Reader in fme2014

I have windows 7 64bit running ArcGIS Desktop 10.0 and fme 2014. On another server I have ArcSDE9.3. I want to create an SDE Reader in FME but am unsure about how to connect. At the moment SDE ...
2
votes
1answer
180 views

How can I import the export file (*.sdx) from ArcSDE9.3 to ArcSDE10.1?

We got some files (*.sdx) from our clients using sdeexport from ArcSDE 9.3. We only have ArcSDE 10.1. We tried to use sdeimport command like this: sdeimport -o create -t NHDFCODE -f ...
2
votes
2answers
124 views

Is there a way to do a python batch script for Analyze and Compress on SDE Databases?

I created and modified python scripts based off of ERSI's example (http://resources.arcgis.com/en/help/main/10.2/index.html#//003n000000v7000000), however, what would be great is to be able to batch ...
2
votes
1answer
240 views

how do you manage columns in an ArcSDE/Oracle feature class?

Our enterprise has a long history with Oracle and ArcSDE. And lots of tension between the Oracle people and GIS people. Oracle folk often don't like the requirement of using expensive 'nonstandard' ...
2
votes
1answer
103 views

Add features to main SDE Table with geotools

Sorry for my english, I hope you can understand ;) I'am using geotools 8.4 version. I try to copy all features from SDE Table(TEST.DBO.MM_SOURCE) to another SDE Table(TEST.DBO.MM_TEST). All features ...
2
votes
3answers
211 views

Display ArcSDE-metadata in Browser

Is there a good tool / technique to display ArcSDE-metadata in a webbrowser? We want to provide user without GIS-knowledge with a user friendly tool to explore our SDE metadata catalog. We are using ...
2
votes
1answer
525 views

Steps to create an interface Editing ArcSDE Layers in a web service online. Similar to ArcGIS Desktop

The initial idea is to make a multiuser web service for editing versions of an ArcSDE geodatabase online (each version for each user. Is it possible to acces through a password and user name?). Can I ...
2
votes
1answer
141 views

Strange ArcSDE error inserting null into state_locks

I'm working with a heavily customized version of ArcMap 9.3.1. It's heavily customized, but it mostly uses class extensions and special validations. Environment: ArcSDE installed in: linux, ...
2
votes
1answer
156 views

Join feature classes from two ArcSDE geodatabases with same schema?

I am working with two ArcSDE geodatabases -- one for test, one for production. They both have the same schema. I recalculated an attribute in the test environment and wanted to push that to ...
2
votes
1answer
396 views

Create dynamically multiple layers in ArcGIS Server 10.1

I am using ArcGIS Server 10.1 and Desktop 10.1 software. I am publishing table from sqlserver to the ArcGIS server, that table (from sqlserver) is updating hourly, and the types are increasing. I ...
2
votes
1answer
194 views

How can I copy archive data from one server to another?

I have an SDE 10.0 server and an SDE 10.1 server and I am trying to migrate the layers from 10.0 to 10.1. (On a side note the 10.0 server is running SQL Server 2005 and the 10.1 server is running SQL ...
2
votes
1answer
149 views

Finding the Default version in a large linage tree

I have a very large versioning linage tree. I am using the arcGIS 10.0 GDBT tool. How can I find the node with the default version?
2
votes
1answer
421 views

Can a spatial View in ArcSDE be viewed in ArcCatalog?

Can a spatial view in ArcSDE created by "sdetable create view" command be viewed as feature class in ArcCatalog, or is it just another plain table? I have a feature class table and an attribute table ...
2
votes
1answer
908 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
1answer
185 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 ...
2
votes
1answer
804 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 ...
2
votes
1answer
274 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 ...
2
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 ...
2
votes
1answer
534 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
1answer
445 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 ...