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

Creating a multiversioned view with ArcSDE and SQL Server 2008 R2

I am using the administration command sdetable -o create_mv_view to create a multiversioned view on a table in SQL Server 2008 R2. Everything appears to be working correctly with one exception: The ...
3
votes
3answers
898 views

Repair/Check for empty geometry in ArcSDE?

I understand that the standard validation/repair tools are not for use with ArcSDE and that ESRI needs to fix this, but are there work-arounds for at least checking where there might be empty geometry ...
3
votes
2answers
726 views

Importing Feature Class to Oracle SDE Geodatabase Simplifies Features

I recently imported a feature class from a File Geodatabase to an Oracle SDE Geodatabase. The features of the two feature classes now look drastically different despite not having any edits made. ...
3
votes
1answer
2k views

How to get all the FeatureClasses from IWorkspace?

Well i create a Geodatabse in my SQL Server using ArcCatalog then i create 5 new FeatureClass, i want to get all the FeatureClasses in this GDB, this is my function to get all the FeatureClasses from ...
3
votes
5answers
474 views

Installing ArcGIS 10.1 on SQL Server 2008 R2 Cluster [closed]

We're running into some performance issues when accessing large enterprise geodatabases on a SQL Server 2008 R2 cluster. The database itself performs well and returns queries fine but presenting the ...
3
votes
1answer
349 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 ...
3
votes
2answers
470 views

Is it possible to load features into ArcSDE without using ArcObjects?

I have a SDE geodatabase in MS SQL Server, where geometries are stored in MS SQL's native geometry types, rather than the ArcSDE Binary. It seems like it would be relatively easy to create new ...
3
votes
1answer
2k views

Using primary keys with ArcSDE (Oracle)?

Is it possible, more advisable to assign a primary key to the OBJECTID column in a featureclass in SDE. I am using Oracle and some of my flat tables (junction tables) need to SEE a primary key in the ...
3
votes
2answers
3k views

Feature Class To Geodatabase => ERROR 000210: Cannot create output

error messages: Executing: FeatureClassToGeodatabase E:\jags20120321.mdb\ch_cs "Database Connections\Connection to localhost.sde" "Database Connections\Connection to localhost.sde" Start Time: Sat ...
3
votes
1answer
903 views

Schema locking logistics on ArcSDE for SQL Server?

I have a set of feature classes that I want to be able to edit schema or what ever I want to do in the heat of the battle and I don't want to be stiffled by schema locks. I have a interpretable ...
3
votes
2answers
522 views

Has anyone successfully implemented a web service that sits on top of ArcSDE (SQL Server 2008)?

Here's the situation. We have planned point locations that lie within predefined polygonal project areas. Our IT department currently has these polygonal project areas in SQL Server 2008 as geography ...
3
votes
1answer
36 views

What are SRIDs like 30008 in an SDE geodatabase?

When I look at the SDE.ST_GEOMETRY_COLUMNS table of my SDE database I'm seeing mostly recognizable four-digit values, but a number of columns have SRIDs like 300006, 300008, and 300047. I can't find ...
3
votes
1answer
97 views

SQL Spatial select record where intersects another record

I have two tables - 'Tree' (point) and 'ServiceArea' (polygon) in the GIS database. Trying to select all Tree records that intersect a ServiceArea where the value in Tree.ServiceAreaNumber field ...
3
votes
2answers
336 views

How to get size of SDE geodatabase feature class

Is there a way in catalog or arcpy to determine the amount of hard drive space a SDE feature class takes up on disk? In catalog the 'size' column is blank and Esri help states: The size, ...
3
votes
3answers
2k views

How to connect QGIS to an Oracle DB (SDE)?

I want to access an Oracle Database (with SDE) from Qgis 2.4. I have tried many different options from within the window Create a new Oracle Connection but I always get an error message (ORA-12514: ...
3
votes
1answer
3k views

Where is connection file used to connect ArcMap to ArcSDE?

In ArcMap 10.0, how do I find where the connection file is that is being used to connect to ArcSDE 10 on Sql Server 2008? Some non administrative users are hooking up to SDE as the user 'sde' with db ...
3
votes
1answer
125 views

Reconciling vertex modification conflicts in Geodatabase Versioning?

Is it possible to edit the same feature in ArcSDE in two different versions ... and reconcile/post version A's edits to the parent, ... and then reconcile/post version B's edits of same feature, ...
3
votes
1answer
2k views

Creating empty feature class in file geodatabase based on schema of ArcSDE feature class?

I have 150+ feature classes in SDE for which I need to create an empty feature class in a file geodatabase. For these feature classes I need to import the attributes and the name of the feature class ...
3
votes
1answer
1k views

Editing with ArcGIS API for Silveright?

I am using the ArcGIS Silverlight API to edit data in an ArcSDE SQL Server geodatabase. I have been told that any editable feature classes must be registered as versioned in ArcCatalog before they ...
3
votes
2answers
358 views

Transforming coordinate that lies outside a grid transform (e.g. NADCON)?

As I understand it, a datum transform (e.g. urn:ogc:def:coordinateOperation:EPSG::1241) based on a grid interpolation method, e.g. NADCON, is undefined outside of the grid of points. Therefore the ...
3
votes
1answer
51 views

Get the geometry type of an empty ArcSDE feature class

I'm trying to use raw SQL to get the geometry type (e.g. POINT, LINESTRING, POLYGON) of an Oracle ArcSDE feature class using the ST_Geometry spatial type. If I run SELECT SDE.ST_GeometryType(SHAPE) ...
3
votes
1answer
82 views

Deleting Oracle SDE features classes properly

I have got a few feature classes in an SDE connection. This is the situation: a) They are listed in ArcCatalog (10.1), but the open fails. The message says: 'Error opening feature class, DBMS table ...
3
votes
1answer
61 views

Incremental Network Loader failing with ArcSDE Geometric Network

I've been testing the Incremental Network Loader tool for loading new lines into a geometric network from an outside feature class. The tool worked perfectly on a File GeoDatabase copy of our SDE. ...
3
votes
1answer
64 views

Linking file geodatabase and ArcSDE?

My office does a lot of field work where we log points via the Collector app. Those points are then always exported to a geodatabase feature class for further editing and analysis. If edits and ...
3
votes
1answer
173 views

How are orphan gsrvr.exe processes created?

I just inherited a server running SDE application server 10.1 against an Oracle 11g database. I'm finding that many connections are not getting properly dropped and stay on as Orphans. Eventually the ...
3
votes
2answers
131 views

Switch between test and production database in ArcMap?

I have two Oracle 11g databases, one for testing (tst.world) and one for production (prd.world). Except when I am trying out new things, they have exactly the same table structure. In ArcCatalog I ...
3
votes
1answer
296 views

Changes not persisting in ArcGIS server from ArcPy script

I have a ArcPy script (10.2) which connects to an ArcGIS server (10.0) versioned geodatabase, via an .sde connection file in the Database connections directory through direct connect on a Microsoft ...
3
votes
1answer
328 views

How to Unlock feature classes in ArcCatalog that don't show user

In ArcCatalog there are some feature classes that are locked and don't show a user. After restarting SQL server, the feature classes remain locked. Any ideas as to what might be causing this and how I ...
3
votes
1answer
976 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 ...
3
votes
1answer
388 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 ...
3
votes
1answer
2k views

Change ArcSDE data source for mxds in specific folder using ArcPy?

I've searched all the forums and help and have made progess but recently got an error that has thrown me for a loop - also some mxds are not being changed at all! What I'd like my code to do: Iterate ...
3
votes
1answer
394 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
631 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?
3
votes
1answer
109 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 ...
3
votes
3answers
491 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)?
3
votes
1answer
794 views

Duplicate ObjectID in ArcSDE Table

After making a check in from an arcpad AXF file, i notice that there's duplicate ObjectID records. This ArcSDE PostgreSQL table is versioned and edited by Axf checkins and a .net engine application. ...
3
votes
1answer
586 views

Spatial Database Connection String

From MS Access, I'd like to create a link to the attribute table of an SDE feature class in a spatial database. For example, I have the following connection string which works for an OLE DB ...
3
votes
1answer
1k 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 ...
3
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 ...
3
votes
1answer
676 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 ...
3
votes
2answers
351 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 ...
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 ...
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 ...
3
votes
3answers
1k views

Can you set the PostGIS SRID when creating a Feature class through ArcCatalog?

I have ArcSDE installed in a Postgresql database and I am using PostGIS geometry. I'm not a DB minded person so feel free to let me know if my process is not right. I create my feature class in ...
3
votes
3answers
497 views

PostGIS + ArcSDE mixed environment

I'm trying out a mixed environment here at work with PostGIS and ArcSDE together. I'm having some problems creating feature classes with custom SRIDs. I imagined that all that I needed to do was ...
3
votes
1answer
936 views

Unable to Reconcile

I'm quite familiar with the ArcSDE model and a few days ago we have major power issues here. My problem (and this is a BIG one) is that one of the users, made thousands of edits correcting data, and ...
3
votes
1answer
57 views

Error when using arcpy.ArcSDESQLExecute() to connect to SQL Server - ArcGIS 10.4

I am able to connect to a MS SQL Server 2012 geodatabase with the arcpy.ArcSDESQLExecute() when using the .sde connection file pre-created in ArcGIS. I am not able to connect to a MS SQL Server 2012 ...
3
votes
1answer
60 views

Transfering features class from ArcSDE to File Geodatabase using ArcPy?

I would like to know if it's possible to use python to transfer features class from SDE into a GDB and then transfer it back to SDE without losing SDE parameters such topology, versionning, ...
3
votes
1answer
93 views

How do versioned views work with multiple editors?

I understand that in the database environment, by executing version_util.set_current_version('version1') Editor1 is able to write SQL statements against [table_name]_vw views to edit the data at ...