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
229 views

Problems displaying joined attribute data through ArcGIS Server

I have an ArcSDE feature class in an ArcMap MXD which I have 'joined' to a view into an external SQL database table, that is connected via an OLE DB connection. In the MXD the join works perfectly; I ...
0
votes
1answer
228 views

Why can't a user with db_owner role version data?

I've made an enterprise geodatabase and added a user with db_owner permissions. When I add a database connection in ArcCatalog and connect to this geodatabase using the user I created, I'm not able ...
3
votes
1answer
204 views

How can I validate a table name on SDE with Oracle backend?

Second title: "Is arcpy.ValidateTableName broken on Oracle?" I have an Oracle SDE database 9.3.1 (service connection). My arcGIS client tools are version 10.0 SP5). I have some names of feature ...
5
votes
2answers
197 views

How do I retrieve a feature outside of ArcSDE into an IFeature in ArcObjects?

I would like to be able to use Entity Framework with a repository pattern for non-spatial querying of my SDE Sql Server database. I was hoping to reverse code-first engineer the database with the ...
1
vote
1answer
2k views

Error 001359 when publishing map service to ArcGIS server 10.1

I encountered this error when trying to publish a map service to an ArcGIS Server 10.1 (installed on linux). --------------------------- Service Publishing Result --------------------------- ...
1
vote
1answer
266 views

Can one edit an ArcSDE Oracle spatial view?

By 'edit' I mean edit the geometry in the feature class, not any attributes in the joined table. Unversioned. I really had it in my head that you can, as long as the objectid column is included in ...
3
votes
1answer
172 views

Synchronizing Changes From File Geodatabase to SDE Geodatabase

I have an SDE geodatabase that has a one way replication to a file geodatabase, where I will make edits to the feature classes offline somewhere. I know that this scenario doesn't support one-way or ...
3
votes
1answer
241 views

Is it possible to undo and redo outside edit session in ArcObjects?

I would like to know if it is possible to undo and redo changes outside of an edit session? If yes, how can I do it in ArcObjects using .NET? I am working on an ArcSDE 10.1 versioned geodatabase?
8
votes
2answers
885 views

Is there workaround for very slow ArcSDE 10.1 data display

I'm suffering from very slow viewing data of and ArcSDE database from an Arcgis engine application, the SDE database is in localhost so there's no network issues. but i still don't know the reasons ...
1
vote
0answers
169 views

Quering a ArcSDE featureclass attribute table after joining

I am trying to query a ArcSDE Feature Class after joining using Iqueryfilter I have two SDE feature classes. 1) Subdivisions : which has details of subdivision and districts (parent) 2) ...
3
votes
2answers
2k views

ArcGIS Server Error: “Feature service requires a registered database”

I'm attempting to publish a feature service to ArcGIS server. I'm running SQL Server Express and ArcSDE. When I try to publish the service I get the error "00090: Feature service requires a registered ...
6
votes
1answer
170 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 ...
1
vote
1answer
175 views

Database Connections folder is empty when viewed with ArcGIS tool

I'm trying to create an ArcGIS tool which accepts an SDE connection file as an input. I made a new interface with an input parameter and set the type to Database Connections. When I open the tool and ...
10
votes
1answer
503 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. ...
2
votes
0answers
293 views

Can I use an Update cursor with a versioned feature class which has attachments in ArcObjects .NET

I have a problem with my code (C# ArcObjects 10.1). We are trying to update and insert 10 - 15 rows at a time into a feature class hosted in ArcSDE 10.1 on SQL Server 2008 R2. We have a feature class ...
1
vote
1answer
440 views

Using sdemon command of ArcSDE?

I am pretty new to ArcGIS for Server and ArcSDE but cannot find a solution in the Esri Documentation or Forums. I don not know how to use sdemon or even where to start this command line tool.
0
votes
0answers
112 views

ESRI AddFeatures call on rest endpoint with attributes

I can add a line feature via the rest endpoint with my hand crafted call from C#. However, if i add any attributes to the call it will fail and say unable to perform operation. All of the fields in ...
1
vote
1answer
209 views

How to add a column to table with sdelayer command?

I am working with an oracle11g database and I would like to add a new column to a feature class stored in this database. I would like to use the sdelayer command but can any one of you give me a tip ...
2
votes
3answers
180 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
406 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 ...
0
votes
1answer
102 views

Automatically changing field entry in related table when entering it in feature class?

I am working to try and develop a code or process that I can run that will allow me to automatically change an XY field in a related table when I change an associated XY field. Let me explain our ...
2
votes
1answer
118 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, ...
1
vote
1answer
91 views

Filter ArcSDE layers of the TOC into a combobox

I've a list of layers of the current workspace in a combobox, but I want to list only the layers of the ArcSDE Connection, not the others I've in the TOC. How can I filter the name of this layers?
2
votes
1answer
134 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 ...
3
votes
1answer
284 views

Attaching files to features: File server vs SDE attachment

I have some files that I would like to attach to my sde features. Files are small in size ( <40 KB) and have 1:1 relation to features. I wonder which method is superior, specially in terms of ...
0
votes
2answers
117 views

Missing options on database connection in ArcCatalog

I have 2 databases on the same server. I can add connections to them both without a hitch in ArcCatalog (or catalog in ArcMap). The problem is that I seem to be losing some options when right clicking ...
1
vote
0answers
85 views

SDE Connection raise exception

I am supporting a .NET code that is running on ArcGIS Server 10.1, and communicating with ArcSDE Application Server 9.3 There is part of the code that is doing long loop. And when it comes back to ...
5
votes
1answer
146 views

Why are z-values replaced with zero after in_memory use in Python?

My script takes separate 3D feature classes, calculates a field, appends to a target feature class, and then deletes the originals. This is a huge data processing task of over 4700 mass point feature ...
0
votes
0answers
288 views

SDE connection error

In my company we have a number of databases in an MS SQL instance. This morning only 1 database i generating following error when I try to do a direct-connect in ArcCatalog: Failed to connect to ...
3
votes
1answer
587 views

Arcpy does not execute “CopyFeatures_Management” to write a featureclass to an ArcSDE database

I have some problems with my Python script. The script gets an JSON with different information about images. The information includes general information about images and also the gps position of ...
6
votes
2answers
231 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 ...
1
vote
1answer
1k views

How to manage user privilege on layers to Arcgis 10 Desktop?

Problem: I am a Computer Analyst on a town hall. Here we have the sector A and B. Both work in ArcGIS 10 Desktop. The sector A has granted to access/edit everything. The sector A has all the ...
2
votes
2answers
1k views

I need help understanding ArcSDE and Server. How can I access services outside network?

I'm learning about ArcSDE and ArcGIS for Server on my own without any official training. I've successfully installed ArcSDE and Server for 10.1. We are using SQL Server 2012 on a Windows 2012 Server ...
1
vote
1answer
189 views

Why don't I see ArcSDE service in the Windows services?

I've been thrown into learning how ArcSDE and ArcServer work. I'm trying to start a service using the default esri_sde on port 5151. I put it in both the ArcSDE and windows service files. When I go ...
2
votes
1answer
253 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. ...
0
votes
1answer
93 views

Creating “Empty” version of ArcSDE geodatabase?

Is it possible to create an "Empty" version of an ArcSDE geodatabase? I have a large default ArcSDE geodatabase that I would like to create an empty version for a new project. By "Empty" version I ...
1
vote
1answer
466 views

Filtering a Feature Class in using ArcGISDynamicMapServiceLayer

I'm using the following code in Flex to display all the features in a Feature Class defined in the "Data Layer". var dataLayer:ArcGISDynamicMapServiceLayer= map.getLayer("Data Layers") as ...
1
vote
1answer
144 views

“SDE error 6” when publishing GeoServer layer

I have successfully created an ArcSDE datastore in GeoServer 2.2.4. When I try to publish a feature class in the SDE database, the "Compute from data" link returns nothing, and the "Compute from ...
6
votes
2answers
2k views

How can I more efficiently select related records?

Below is the code I'm using to replicate the "related tables" button in ArcMap. In ArcMap that button selects features in one feature class or table based on the selection of features in another ...
2
votes
0answers
40 views

Is it possible to re-point operational layers ArcGIS Mobile projects v.3.0

We have an ArcGIS mobile project with two operational layers for data collection. The layers source from a GIS server on the cloud, running on top of an SDE. The database has a feature dataset, and ...
1
vote
0answers
97 views

Extract an ArcSDE datasets (rasters/shape files) using python?

I would like to write a python script to extract/export a dataset (rasters/shape files) in ArcSDE. I saw this posts to connect to the server: Define Workspace for SDE Connection in Python But how ...
6
votes
2answers
453 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?
0
votes
0answers
348 views

Configuring image popups in a Silverlight application

My Silverlight application contains a points layer which contains paths to a folder of geotagged photos. These points were generated using the GeoTagged Photos to Points tool. I chose not to import ...
1
vote
2answers
139 views

Identifying the Primary Key field of the Layer in ArcGIS Server

I need to get the primary key column of the Particular layer added in the Map. Usually 'FID' be found for a Shapefile Layer Source and OBJECTID found for a SDE source layer. Is there any way to ...
1
vote
0answers
145 views

How to run SDE view commands in Oracle DB?

I would like to create SDE view to compare two tables in my oracle spatial database. I already prepared the view commands. But I dont know where and how to run this? I unable to run this commands in ...
3
votes
2answers
210 views

Running Regular Queries Through ArcSDE

Working on an .net arcobjects app that's connecting to a Geodatabase (Oracle) through ArcSDE. I make a bunch of edits inside a EditSession but the data I am touching have a bunch of foreign Key ...
4
votes
1answer
337 views

Access Metadata from ArcSDE-tables using python

Is it possible to access the metadata of a feature class in a ArcSDE-data, using arcpy / python (on Arcgis 10.0). I suppose I could export the metadata to xml and parse the xml, but is there a more ...
3
votes
0answers
824 views

Error opening feature class from SDE (which can be opened in another application)

We're using ArcGis 10.1 with ArcSDE 9.3.1 on Oracle 10g. I've got 2 layers that cannot be opened or modified with ArcCatalog or ArcMap (but they show up in the list. Everything worked just fine ...
3
votes
1answer
105 views

Are there any publicly available ArcSDE Servers I can use for developing client applications

I have been asked by our client if I can add the ability to connect to instances of ArcSDE servers from our desktop application. I am sure that we can do this a number of different ways, what I was ...
0
votes
1answer
98 views

Open source vs Proprietary [duplicate]

Possible Duplicate: What are the FOSS equivalents to these ArcGIS products? 'm especially interested in Open Source vs Proprietary decisions. Can any of the open source software for ...