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)

0
votes
0answers
31 views

Query's “Get Unique Values” includes case variants that don't exist in attribute table

I ran a query on an ArcSDE 10.2 Feature Class to find features that do not follow our office's standard of being in uppercase. The "Get Unique Values" seems to return values that do not exist in the ...
1
vote
1answer
83 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
37 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
23 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
31 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 ...
1
vote
2answers
100 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
101 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
35 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
126 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
136 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
51 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
94 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
35 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
24 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
0answers
20 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
54 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
58 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
55 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
53 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
45 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
60 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
121 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
63 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
11 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
113 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
44 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
34 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
38 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
56 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
56 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
86 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
127 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
67 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
37 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
156 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
86 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
73 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
40 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
123 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 ...
1
vote
0answers
22 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
95 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 ...
1
vote
1answer
42 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
116 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
49 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
38 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
63 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
169 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
70 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
96 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
26 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 ...