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)

1
vote
1answer
228 views

The create feature task could not be completed. the coordinates or measures are out of bounds

I'm trying to create a layer based on a feature class, in ArcMap (I've created a geodatabase from Arcatalog and linked it to PostgreSQL). The feature class that I've created is registered as ...
0
votes
2answers
44 views

Arcgis Dynamic Mapservice from sqlserver 2008 r2

I publish the mapservices from the sqlserver2008 R2 through ArcSDE using ArcServer 10.1. Its fine i published, now i change the attributes of my existing gdb using ArcSDE. Now the updated information ...
1
vote
1answer
57 views

ArcSDE cannot perform post installation

I have installed the following before I installed ArcSDE 10.2.1: ArcGIS for Desktop 10.2.1(standard) ArcGIS for server Enterprise 10.2.1(standard) MS SQL server 2008 create enterprise geodatabase ...
0
votes
1answer
48 views

ArcGIS Feature Class Extent Changing

I've been having a problem with the extents of feature classes in our SDE here at work. Our database is divided into feature datasets that have various feature classes in them. The problem is as ...
2
votes
2answers
171 views

How to copy selected features from one sde feature class to another with different attributes using Arcpy?

I am new to Arcpy scripting, I need help on copying the features to SDE feature class. My Scenario: We have 2 Geo databases running on Oracle 11g ArcSDE 10.2 . I have been asked to write the python ...
1
vote
1answer
161 views

Copy features between file geodatabase and ArcSde by using ArcObjects

I want to transfer all contents of a table from file geodatabase (*.gdb) to a table in ArcSde. In fact the data is meant to be replaced, so I need also to clear the table in ArcSde. Both tables have ...
0
votes
0answers
48 views

Error post installation ArcSDE for SQL server 2008

I had a problem during post installation of ArcSDE for SQL server 2008, and this is the message : The ArcSDE Repository was unsecessfully completed. would you like to view this error? then ...
0
votes
1answer
263 views

Can't start ArcSDE (esri_sde) service

I am getting an error message when atempting to create a connection in ArcCatalog (I'm working under the 10.0 version). The message is : Failed to Connect to the specified server. No ArcSDE server ...
0
votes
2answers
194 views

Error while creating spatial database connection

I'm using ArcGIS 10.0, and I've already created my database using "ArcSDE for PostgreSQL Post installation" .. My database is successfully created in PostgreSQL and now that I'm trying to create a ...
2
votes
1answer
58 views

Can you run GIS Squirrel next to SDE?

My company has SDE to run our webmapping system. We want our arcbasic license users to be able to edit this data without dropping 30k for 6 users on upgrading to standard. Can we run squirrel next ...
1
vote
1answer
144 views

How to connect to ArcSDE for using the ArcObjects Erase tool in C#?

I want to make use of geoprocessing via .NET ArcObjects, in this case of the "Erase" tool. This is easy once dealing with a local gdb file what I did for feasibility study. The issue occurs when I ...
0
votes
1answer
40 views

Identifying inserts, updates, deletes, and conflicts between a parent and child version in ArcSDE with ArcPy

I'm looking for a way to identify records that have changed between the present and the last time a version was reconciled. It would also be great to be able to identify conflicting records. Ideally ...
0
votes
0answers
38 views

SQL Server 2012 spatial check constraints disabled after migration from 2008

Currently we are using SQL Server 2008 geometry datatyped columns in our databases. These are registered with ESRIs enterprise geodatabase repository, so every spatial table has a check constraint ...
1
vote
1answer
29 views

Using IGeoProcessor2 to update Oracle Spatial

In the below example the input and out are shape files read from folders.Is it possible to read and write Oracle Spatial Geometry tables? I have ArcGIS,ArcSDE and Oracle Spatial 11g. How to set ...
-1
votes
1answer
66 views

After SDE Conversion, cannot open our GP Services to republish them

We have several services that were originally published against a local file-based database (with ArcMap 10.1). We spent the past week converting the data into an SDE database and we are running ...
1
vote
2answers
66 views

Conversion to SDE changes names

I could not find anything on this topic already discussed. We converted our file-based system in ESRI to an SDE instance on Sql Server. We made changes in our code to open using the connection string ...
2
votes
1answer
70 views

Connecting to MSSQL 2008 R2 with QGIS 2.0.1

There have been questions related to this, but some of them seem out of date or no one has asked. I'm trying to connect to SQL Server 2008R2 using a MSSQL connection in QGIS. I'm not exactly sure if ...
0
votes
0answers
73 views

Entity Framework 6 and ST_Geometry column type

I have ArcSDE 9.3 database and I'm trying to use EF6 with it. When I generate the model from database, I get the following message: The data type 'st_geometry' is currently not supported for the ...
1
vote
0answers
57 views

SDE Performance issue with SQL Spatial labelled lines on one server

Here is an issue that has stumped ESRI and SQL Server experts alike. I ask it here just to get more people thinking about it. Exhibit A is this screencast. I have two servers: ROGIS: A dedicated ...
1
vote
1answer
74 views

Replace Polygon geometry in SDE Database using FME

I'm still trying to wrap my head around using FME and encountering another issue. This is my scenario: I have a master SDE database that i am trying to update using the data from a GDB file. I was ...
1
vote
1answer
145 views

Merging Personal Geodatabase (MDB) data into ArcSDE using FME?

Im a novice in FME and I have a MDB file that i want to write/insert to an SDE database using FME. I created a simple translation that generally reads the data from the MDB file and writes it to the ...
3
votes
1answer
82 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 ...
0
votes
0answers
12 views

Where are the settings that control when clustering starts and stops?

We have a SDE set up on a SQL Server and we're using the Silverlight API. Our layer has buildings on it. The flare clustering and large clusters show when the map is opened and the actual buildings ...
1
vote
0answers
204 views

Using arcpy.CopyFeatures_management results in a 000210 using a database connection that does not contain saved credentials

Currently have a problem running CopyFeatures_management in ESRI's ArcGIS 10.1 The following shows two Enterprise Geodatabase connection files. One includes the username and password and the other ...
1
vote
1answer
61 views

ArcSDE register with gdb vs register as versioned

When wanting to update tables within a sde gdb, is there a difference between registering as versioned vs registering with the gdb vs registering with sde? I've read the question below and it hints ...
2
votes
0answers
66 views

Feature service requires registered database error?

I am working on ArcGIS Server 10.2 and SQL Server 2008. when I want to publish the service, I get this error "Feature service requires a registered database" that's error happen when I read (List By ...
0
votes
0answers
47 views

Load Featureclass from ArcMap to a Database (sde) with Arcobjects

I have to develope an extension for ArcMap 10.2 that has to get spatial data from an Oracle Database, edit it and finally upload the changes. I create a scratch featureclass whit the data, I edit the ...
0
votes
0answers
77 views

Prevent self-intersecting loops when exporting polygon layer from ArcSDE to File Geodatabase?

I am using ArcGIS 10.1. The source data is housed in an ArcSDE instance that does not allow self-intersections. When I export this data to a file geodatabase and run check geometry ...
0
votes
0answers
71 views

Using Geometry commands in MS SQL Server 2008

I am looking to find the most effect way to use SDE and ST_Geometry SQL commands. Can anyone tell me how/what commands I might use to perform a spatial query in MS Sql Server 2008, to Select property ...
1
vote
1answer
126 views

Backup several SDE database connections

This question stems from my previous question on how to list databases based on SDE. Now I want to copy them and have it written as a function so I can list out each database connection below it so ...
2
votes
2answers
219 views

ListFeature classes in SDE

I have this code: def backSDE(ActiveSDE): arcpy.env.overwriteOutput = True arcpy.env.workspace = ActiveSDE fcs = arcpy.ListFeatureClasses() print fcs #Databases ActiveSDE = ...
5
votes
1answer
72 views

Automate loading a table into SDE

How can I automatically load a table stored on a network share into SDE when the original table is edited? Environment is ESRI 10.1 ArcSDE on SQL Server. Preference for python or existing GP tools. ...
1
vote
1answer
43 views

QGIS 2.2 crashes when saving digitized data in ArcSDE 10.1

I am using QGIS 2.2 with ArcSDE 10.1 for Oracle 11gR2 I have created a polygon feature class with SDO_geometry, when trying to save the digitized data QGIS crashes. Please help, I want to edit the ...
1
vote
1answer
185 views

Secure credentials for scheduled python script targeting ArcSDE 10.1 on AWS

I have a python script that will be used as a scheduled task. Our dba team is wanting the credentials to be as secure as possible. I would say that using the os security system as far as locking ...
1
vote
1answer
113 views

ArcSDE/SQL Server Permissions

I have an enterprise geodatabase with about 20 users. Each user has a corresponding schema. When in Arc Catalog, if only the owned schema box is checked in SQL Management studio I receive a ...
2
votes
0answers
97 views

Bulk insert into MS SQL Creating ObjectID's

I am running an ETL from a spatial view into publication database. The view has results in duplicate ObjectID's. I started working with the get_ids SP example from ESRI, but that seems to be built ...
1
vote
0answers
42 views

What are some advantages to using ArcSDE in your organization? [closed]

This is somewhat a general topic, but I need some advantages to using ArcSDE in my organization. We actually have SDE for our webmapping software, but we are unable to edit it using ArcGIS basic ...
5
votes
1answer
141 views

How to compare two Geodatabases

I would like to compare the data of two geodatabases, in SDE or a file geodatabase, to detect the changes occured between them , i've tried to compare the Xml workspace document of both databases ...
2
votes
0answers
26 views

Shoehorning hierarchial data into MS SQL ArcGIS SDE

So, I've been tasked with creating a set of tables to store hierarchical data within an SDE. This is in reference to utility data, i.e, a set of valves, control panels, actuators, etc (each ...
0
votes
1answer
119 views

arcpy.ListDatasets() returns emtpy list

I'm having trouble getting the ListDatasets (or any of the list functions) to return anything but an empty list when pointed at our SDE geodatabase, but the same code works for a file geodatabase. I ...
2
votes
0answers
70 views

Cannot Save Edits to File Geodatabase Replica in QGIS 2.2

When trying to edit a File Geodatabase Replica in QGIS 2.2, everything works as expected until the user saves their edits. When pressing save, all edits revert back to their original state with no ...
1
vote
1answer
52 views

Query SDE to display records created for 'X' date/time

I am looking to query our SDE to display feature classes modified beginning from January 1, 2013 to today. I am using Microsoft SQL Server Management Studio, and as it stands searching through dbo ...
1
vote
0answers
136 views

Running python script outside of Arcmap's python console

My codes works fine in Arcmap's python windows. But when I try to run it in a command promt windows, It says that; ERROR 000837: The workspace is not the correct workspace type. But it works fine ...
0
votes
1answer
65 views

registering or unregistering as versioned a future dataset with python

As you know, you can store feature classes in arcsde in two ways. Firts, in the root path: sde_conn_file.sde/FeatureClass Second, in a dataset: sde_conn_file.sde/DataSet/FeatureClass How can I ...
1
vote
1answer
41 views

ArcGIS Server 10.1 GP Service non-functional after ArcSDE restart

every night, the Oracle/ArcSDE server gets restarted. As a result, some, but not all, map and GP services require a restart to be functional afterwards. Can others confirm this experience and share ...
2
votes
1answer
75 views

What's the proper way of deleting versioned data from an SDE geodatabase?

I haven't really read this anywhere. What is the proper way of deleting versioned data from an SDE geodatabase to make sure nothing is left behind in the A & D tables? Do I need to unversion the ...
4
votes
2answers
180 views

How to transfer attributes to thousands of local points from ArcSDE feature class with millions of polygons?

I have a set of points and a huge feature class with topographic information (OS MasterMap for who knows it). I'm talking millions of polygons huge. I want to transfer attributes of the polygons to ...
0
votes
1answer
80 views

How to list all of feature class in SDE?

I am getting a problem: my SDE contains some feature classes, but after using the statement: var namesEnum = workspace.DatasetNames[esriDatasetType.esriDTFeatureClass]; var tempName = ...
4
votes
3answers
107 views

Preparations for a transition to ArcSDE [closed]

So I'm a GIS Intern for a city government, we are preparing to purchase ArcSDE and implement it to our current GIS setup. I'm curious as to what should be done before it is purchased. Our GIS consists ...
0
votes
0answers
29 views

ArcGIS Find task performance over SDE

We are having a problem in our Search feature for our app. We are using arcgis published REST services and SDE database. When we try to do our search manually using the REST url, it takes roughly 9 ...