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)

3
votes
1answer
888 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
129 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
192 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, red-hat,...
1
vote
1answer
128 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
223 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 production....
4
votes
1answer
861 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
267 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 ...
0
votes
0answers
184 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
165 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 ...
3
votes
1answer
1k 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 them....
6
votes
2answers
459 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
4k 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
2k views

Do I need to install ArcSDE?

I've successfully installed ArcSDE and ArcGIS for Server for 10.1. I'm running SQL Server 2012 on a Windows 2012 Server x64 machine. I'm able to direct connect to the SDE geodatabase and version the ...
2
votes
1answer
2k views

Deleting SQL Server database in order to delete ArcSDE geodatabase?

I'm new to this ArcSDE stuff and would like to know the best way to cleanly delete an SQL Server database in order to delete the ArcSDE geodatabase. Is it as easy as right clicking on the database in ...
1
vote
1answer
371 views

Expecting ArcSDE service in Windows services?

I've been thrown into learning how ArcSDE and ArcGIS Server 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 ...
2
votes
1answer
193 views

Choosing specific ArcSDE version to create replica geodatabase from?

I'm trying to automate the process of exporting a replica geodatabase using the geoprocessing tools and eventually a Python script. I can't figure out how to create the replica from a specific ...
2
votes
1answer
395 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
188 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 ...
2
votes
2answers
1k views

Connecting Desktop to SQL Server 2012 SP1 via ArcGIS Server 10.1 very slow?

We have just built and new ArcGIS/ArcSDE system with SQL Server 2012 SP1. We are experiencing very long periods (up to 2 minutes) just to connect to the database in Desktop. Desktop does connect and ...
1
vote
1answer
698 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
235 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 ...
11
votes
2answers
4k views

Efficiently selecting related records using ArcPy?

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
50 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
171 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
1k 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
580 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
3answers
434 views

Identifying Primary Key field of Layer in ArcGIS Server using ArcGIS API for JavaScript?

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

Calculate Field based on field value in a second table

I have a table in a MSSQL Server Enterprise SDE database. I need to join a table from a MS SQLExpress Workgroup SDE database and then calculate 11 fields in the Enterprise table based on values in ...
1
vote
0answers
233 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
442 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
900 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
2k 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
110 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
119 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 database ...
4
votes
3answers
2k views

ST_Geometry vs SDE Binary: seeking recommendations, experiences

I've got some questions I've collected as we try to come to a decision about whether to use ST_Geometry or SDE native geometry for an Oracle/SDE datastore on a new project. The organization has quite ...
7
votes
0answers
258 views

Why do file geodatabase and SDE readers produce different fme_geometry types?

I have one very simple workbench that I am running against both SDE (9.3) and FGDB (10.0) sources. I noticed two different fme_geometry values for same type of objects. For the first one, i.e SDE 9....
7
votes
1answer
301 views

What is the overall architecture of ArcSDE, and how does it fit into the enterprise?

I'm finding many gaps in my understanding of ArcSDE, particularly as it relates to Oracle. I just can't quite wrap my brain around the overall architecture of it, and how it fits into an enterprise. ...
5
votes
3answers
513 views

Updates to ArcSDE via Oracle trigger

Is it possible and/or feasible for an Oracle trigger to periodically update ArcSDE via a REST geoprocessing service? Does anyone have any experience with such a thing? The reason for this is that I ...
1
vote
1answer
799 views

arcpy JoinField_managment RuntimeError

My script is supposed to pull weekly flu data from a department of health website, parse it for that week, and then push the data up to our ArcSDE server so that it can be displayed on our Web Mapping ...
3
votes
1answer
260 views

Adding ArcGIS Server services or ArcSDE datasets to Tilemill?

Our web design department wants to use mapbox/tilemill to create webmaps for our public websites, but all our data is made available through ArcGIS-server or ArcSDE. Is there some way to use these ...
7
votes
2answers
329 views

ArcSDE : Cascading Subtypes in ArcGIS 10/SQL Server

I'm currently creating an ArcSDE DB on an SQL Server. It is designed to complete species survey, with information from the field. In order to help themselves, they asked me to implement a particular ...
3
votes
3answers
498 views

Creating feature dataset by pgAdmin (PostgreSQL) that can be useD in ArcSDE connection?

How to create feature dataset in PostgreSQL (pgAdmin) that can by use in ArcSDE conection (ArcGIS)?
5
votes
1answer
290 views

Why Can't ArcPy Search the Newly Created Feature

I'm running the following tool in ArcGIS 10. I have an ArcPy Script like this: import arcpy from arcpy import env env.workspace=r"C:/sde/lcimrl.sde" fc="SDE.ATTACHMENTS\SDE.attachment_points" fcRows =...
6
votes
1answer
1k views

How to transfer data and replica information from a file geodatabase to ArcSDE?

I've got an arcgis 10.1 file geodatabase that contains a number of featureclasses and a number of one-way child replicas. Is there any tool that I can use to transfer the data and replica information ...
2
votes
2answers
806 views

Can we use procedures in a Query layer (ArcGIS Desktop 10.1 & Server 10.1)?

I have one basic question that.. Can we use procedures in Query layer (ArcGIS Desktop 10.1)?? Currently I am using query layer for ArcGIS Desktop 10.1 and its working fine . My DBA person told me ...
1
vote
1answer
1k views

Where to execute sdetable command in Windows?

I am trying to fire some Sde Command in Arcgis Desktop 10.1 but I am not aware where to execute the command in windows operating system.Thank you in advance.
2
votes
1answer
1k views

How to auto-create a schema.ini file for a .csv?

I have been given some data in a csv file, which I need to import into my ArcSDE geodatabase. ArcGIS is having problems recognizing the field types, and is not importing some data. It is recognizing ...
4
votes
1answer
244 views

Installing ArcSDE engine plugin for Eclipse?

I'm looking for the following jars for the ArcSDE API: jsde_sdk.jar jpe_sdk.jar concurrent.jar icu4_3_2.jar thanks to this answer I've found that they can be gotten installing the ArcSDE engine ...
6
votes
2answers
2k views

Understanding Geodatabase Archiving and H tables in ArcSDE?

We have ArcSDE 10.0 on MSSQL 2008 with Geodatabase archiving enabled. In the process of updating a topology I deleted the topology, disabled archiving, unregistered as versioned and then recreated ...
5
votes
2answers
2k views

Where can I get jsde_sdk.jar for ArcSDE 10?

I had an environment working with no problems, with Geonetwork harvesting metadata from ArcSDE 9.3. It was done trhu the following libraries, copied from the ArcSDE installation to the Geonerwork lib ...