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
0answers
12 views

ERROR 999999: Error executing function - Failed to execute (CopyRaster)

ERROR 999999: Error executing function Unexpected operation No spatial reference exists This is a fragment from my log report: ERROR 999999: Error executing function. Database user ...
2
votes
1answer
189 views

How to create an SQL Persisted Computed Column which values are derived from spatial column

Our GDB is using the SQL native GEOMETRY data storage type (SQL 2012 Standard) and the spatial reference for this uses a unit of square feet. I want to create a (persisted) computed column which will ...
1
vote
0answers
8 views

Import XML workspace file - why am I losing my z and m parameters?

I am attempting to import an XML Workspace document (database schema) from a file geodatabase into an SDE geodatabase sitting on top of Postgres. The steps I am taking are: In ArcCatalog - ...
1
vote
0answers
18 views

How to re-register a one way replica geodatabase

Long story short. Arcmap crashed during one of my regular synchronizations of a replica geodatabase created through one-way replication checkout. Upon reloading it seems to have unregistered the ...
0
votes
1answer
28 views

Using pymssql to create a table using python ArcMap 10.3

I am using ArcMap 10.3 have a my data in a geodatabase (MS SQL Server Express) and I am trying to write a python script that does a bunch of spatial and non-spatial data manipulation. I need to dump ...
12
votes
1answer
591 views

Stop ArcMap from probing missing data sources on launch

When migrating a map from one environment to another (say, from an existing client environment to our development environment) we're often given MXD documents that represent the map. These documents ...
13
votes
1answer
2k views

Why do simple joins on small datasets slow down ArcMap so badly?

ArcGIS 9.3.1, ArcInfo. I have some small file geodatabase and SDE featureclasses (few thousand records each, 50 columns) that I am doing attribute joins on. After the joins, drawing of the map is ...
5
votes
3answers
2k views

How to copy an SDE geodatabase to a file geodatabase using Python?

I would like to make an exact copy (domains, feature datasets, feature classes, etc.) of an SDE database to a file geodatabase. I have tried several possibilities, including: using the Copy (Data ...
1
vote
1answer
24 views

Remove/Hide SHAPE.STArea() & SHAP.STLength() fields

Is there a way to hide SHAPE.STArea() & SHAP.STLength() fields in feature classes in an SDE GDB? I'm working with a client who says that these fields were not in any feature class in the GDB and ...
0
votes
0answers
29 views

inherted .net extension not connecting to arcSDE in ArcMap10.2.2

I have a custom .net extension tool that is supposed to connect to a file geodatabase or SDE (SQL Server). The SDE connection fails to recognize it as valid. The file geodatabase connection works just ...
-1
votes
0answers
22 views

Import dataset from ArcSDE to local folder using ArcObjects?

Am new for ArcObjects. I need to copy the listed Data set from ArcSDE server to local Encrypted folder.
1
vote
1answer
60 views

ArcGIS Terminology and Data Types

What is the difference between a "Feature Class" and an "SDE Feature Class"? Or a "Table" and an "SDE Table"? When browsing data in ArcCatalog, hosted on the same enterprise gdb, I see these data ...
2
votes
1answer
140 views

Create Auto-Incremented Field within SDE Feature Class (SQL Server)

Has anyone implemented a way of creating an auto-incremented integer field within an ArcSDE (SQL Server 2008 R2) feature class / table and if so, would be willing to give a little guidance on how to ...
2
votes
0answers
27 views

Different SRID problem

Hi here is my problem, I have two geodatabases and i import a number(large) of tables from one to another by using arccatolog(ArcGIS 10.2). However the tables and indexes created on them are imported ...
0
votes
0answers
19 views

How to model multiple topology classes in one query with ArcGIS

We have a lot of geographic data with different geometry type in our application, which are persisted in the Oracle 11g database with ST_Geometry supported by Arcgis SDE 10. The features can be ...
1
vote
0answers
47 views

Spatial query by ESRI ST_Geometry take too long

I am using ESRI ST_Geometry in my application, and I found that the spatial query is rather slow: The following sql is used for query pois inside a certain bounding_box: select * from ( select ...
0
votes
0answers
62 views

Need to connect ArcSDE dataset using QGIS Desktop and Oracle database

I am working in GIS domain using ESRI technology. I want to use QGIS desktop to access ArcSDE dataset from a local machine. I have already installed Oracle Client 10g and QGIS Desktop 2.8.1 through ...
0
votes
2answers
429 views

Cannot register a Feature dataset

I am having an issue trying to register a dataset, and being able to edit a featureclass within it. I am new to SDE so please bear with my explanation. I read online you cannot register a feature ...
0
votes
2answers
34 views

Privileges for Oracle users created using the ArcGIS Create Database User tool

I've created an enterprise geodatabase on Oracle. I can connect to it from ArcCatalog and from SQL Developer using the SDE user. I've created a new user named GFPTest using the Create Database User ...
0
votes
1answer
341 views

Not able to register spatial view with sde

I am using 10.2 ArcGIS and SOL Server 2008 R2. I have created a cross database spatial view in sql server using following syntax: USE [pipelines] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON ...
12
votes
5answers
5k views

Is it possible to connect to ArcSDE using QuantumGIS?

Is anyone aware of any plugins, or any other way to connect and view data from an ArcSDE database in Quantum GIS desktop?
1
vote
0answers
21 views

How to recover from deleting the symbolid of a arcgis annotation feature class?

I have arcgis 10.1 (arcinfo license) and I am using a versionned database (arcsde) with SQL Server. I have accidentally deleted the symbolid of one of my annotation feature classes. All annotations ...
3
votes
1answer
329 views

ArcSDE - How to edit mosaic dataset

I have a mosaic dataset (Raster) in an SDE database. As expected, when I click start editing, ArcMap says that I have to do "Register as Versioned" before, but I can't have a mosaic dataset in a ...
1
vote
1answer
39 views

How to change data source of table using arcobjects

Cross post from: https://geonet.esri.com/thread/125010 Does anyone know how to change the data source of a table using arcobjects? I know it can be done with arcpy, but I'm using C#. I've managed to ...
1
vote
1answer
39 views

ArcSdeSqlExecute ArcSDE Error -65

I am trying to Select certain fields, resulting from a join using ArcSDESQLExecute but encounter the following error when I try to include the Shape field: AttributeError: ...
1
vote
0answers
27 views

ArcSDESQLExecute to query and update from multiple SDE Databases

I am trying to use ArcSDESQLExecute to return the results of a join and then write the return query into a Feature Class located in a different database. Using Microsoft SQL Server and Arc10.2.2 Is ...
1
vote
1answer
137 views

Copying representation symbology from one ArcSDE version to another?

We are having problems with our representations when copying from an ArcGIS 9.3 database to a 10.0. Representation symbologies with dash patterns (dots, dotted lines etc.) are reset to default ...
6
votes
2answers
895 views

How is the default label field chosen by ArcMap?

I have 2 questions: I know how to manually go to Layer Properties>Labels tab>Label Field and choose my label field. I also know that I could set up my primary label field and save the setting as a ...
1
vote
1answer
25 views
2
votes
1answer
55 views

Database connection times - PostGreSQL vs Oracle (ArcSDE)

I have 2 SDE instances. Both have the same amount of data (2000 datasets both raster and vector). One is PostGreSQL 9.2 with ArcSDE 10.2.1 One is Oracle 11g with ArcSDE 10.2.1 So basically the ...
1
vote
1answer
271 views

ArcGIS 10.1 SDE database schema other than SDE or DBO

Just wondering if it's possible to apply a schema other than SDE or DBO to SDE feature or raster tables stored in an enterprise database on MS SQL Server 2008 R2. I have got a new customise schema ...
8
votes
4answers
1k views

ArcGIS 10.2 Query Layer on SQL Server performance

I'm using a Query Layer on SQL Server in ArcMap. The Query Layer executes instantly in in SQL Server but but takes so long to draw in ArcMap that the system appears unresponsive for about 10 minutes ...
1
vote
0answers
27 views

Using FME, Is there a way to transfer Metadata from an SDE FeatureClass to a Shapefile (shp.xml)

Is there a way to transfer, using FME, the metadata from an SDE featureclass to a shapefile?
3
votes
1answer
235 views

Using Python to connect to Multiple SDE Database Connections

I am writing a script that accesses multiple sde Database connections. I have set the script to include accessing the environment workspace: import arcpy arcpy.GetParameterAsText(0) ...
1
vote
3answers
882 views

ArcGIS Copy Features tool extremely slow when exporting to ArcSDE?

I have about 10 points in a file gdb that I am attempting to copy over to an sde feature set. In arcpy and in model builder it takes about a minute to execute. Do you know of any tips to speed this ...
1
vote
3answers
223 views

Arcsde - FME - import data

I have a problem with the import of data with FME 2012 and ArcSDE 10. After import, my data are not visibles in ArcMap or ArcCatalog. My layers are registered in ArcSDE. I found a solution: After ...
0
votes
1answer
78 views

Pythonic way to recalculate feature extent in ArcGIS 10.2

I am creating a tool that will automate a tedious process of data standardization. One of the steps is to recalculate the feature extent of a SDE file. Surprisingly I cannot find anything useful in ...
2
votes
2answers
97 views

Differences between ArcSDE 9.3 and 10.0?

I am curious that what is differences between ArcSDE 9.3 and ArcSDE 10? Is there ArcSDE 10 to use it? Or ArcSDE 10 is coming with ArcGIS for Servers? Can anyone explain me? Edit : Another ...
5
votes
3answers
247 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 ...
3
votes
3answers
872 views

Transfering a lot of features from geodatabases?

I'm having a problem where I need to export a large amount of content from 2 geodatabases of different nature (SDE -> File). I have three options: Spatial Select, a regular SQL select and the full ...
2
votes
1answer
673 views

Create feature task could not be completed because 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 ArcCatalog and linked it to PostgreSQL). The feature class that I've created is registered as ...
3
votes
0answers
39 views

Any way to speed up an append of data to SDE database while it is still versioned?

My group works on a database and about once a month I receive data that must be appended. This process has required me to reconcile and post all versions to default. I then pull down the database ...
2
votes
1answer
24 views

Create field on open ArcGIS map - not saved

I am using ArcGIS desktop with an SDE feature layer with enterprise data that I do not have rights to edit. The data changes weekly but I need a field that is sum of 2 current fields without creating ...
2
votes
0answers
26 views

Save edits before disconnecting users from enterprise geodatabase?

Is there any method that enables the Administrator to save the users edits before disconnecting them for an enterprise geodatabase. Because I am disconnecting users as shown in the screenshot, but ...
2
votes
1answer
2k views

ArcGIS 10 querying Oracle 10g without SDE

I'm interested to see if anyone has successfully got this setup working, and if so how many sacrifices were required and to which deities. I am hoping to ultimately get ArcGIS Server 10 serving map ...
0
votes
2answers
77 views

Does hibernate spatial support st_geometry created by ArcSDE?

We are using ArcSDE 10.0 to export data to the Oracle database, and the spatial property are saved using the SDE.st_geometry format. Now in our J2EE application we tried to manage these data by ...
3
votes
1answer
87 views

ArcGIS 10.3 geocoder

I recently upgraded, desktop, server, engine and SDE to 10.3, and of course had to upgrade some other features and extensions. It seems that now that I've upgraded to 10.3 my new 10.3 geocoders will ...
21
votes
5answers
15k views

Is ArcSDE no longer needed at ArcGIS 10.1?

Through my frustration of not finding the post-installation wizard with ArcSDE 10.1 and being unsuccessful with the command line tool to start an SDE service on our SDE databases, I found I was able ...
2
votes
2answers
45 views

FME SDE Writer changing the part sequence of a Multi-part polygon on Insert

I am creating a FME script that will accept to databases (MDB file and SDE Database) and will update the SDE database if there are any changes to the MDB file. I have a CRCCalculator for both SDE and ...
0
votes
1answer
25 views

How to identify Unposted/Outstanding (A&D) edits of a version in Enterprise SDE Database using SQL interface?

I am working on ArcSDE10.2.2 Oracle11G(11.2.0.4) enterprise geodatabase with user base 600+ and 2000 versions( Created from DEFAULT). For effective GDB compression and optimized performance delta ...