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)

2
votes
1answer
502 views

Can I use an Update cursor with a versioned feature class which has attachments in ArcObjects .NET

I have a problem with my code (C# ArcObjects 10.1). We are trying to update and insert 10 - 15 rows at a time into a feature class hosted in ArcSDE 10.1 on SQL Server 2008 R2. We have a feature class ...
0
votes
1answer
161 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 ...
1
vote
1answer
28 views

Is Create Spatial Type necessary

When I enable an enterprise geodatabase for a database in postgresql, the st_geometry type get installed with it. So Is it necessary to use "Create Spatial Type" tool to create st_geometry type in ...
2
votes
1answer
190 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 ...
1
vote
1answer
653 views

Appending from file geodatabase to ArcSDE fails using ArcPy?

I'm trying to append a feature class from a file geodatabase to an Arcsde featureclass using this line of code: arcpy.Append_management("parcel_copy", sde_path+"parcel" ,"NO_TEST") This line works ...
2
votes
1answer
396 views

Database connection (SDE) failed after database was renamed

I created an enterprise geodatabase in SQL Server 2008 R2 with ArcCatalog (10.2). It was connected via an sde file in ArcCatalog then. Then I had to rename the database from SQL Server Management ...
1
vote
3answers
258 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 ...
0
votes
0answers
36 views

Database connection fails when using db authentication, succeeds using OS

When i attempt to make a connection to a database on my SQL Server 2014 sever via Database connections in ArcCatalog using with db authentication i get the lovely "Connection was attempted with an ...
3
votes
1answer
35 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 ...
1
vote
0answers
19 views

Autonumbering using ArcGIS Web AppBuilder?

I work for a water utility division and we are using ArcMap 10.1 with attribute assistant. I used the AutoNumber method to auto increment and populate a field with the next highest integer. ...
2
votes
1answer
25 views

What are the options to auto populate metadata for data received from external sources?

We receive quite a many spatial data from various sources and export to our enterprise database (Esri). But no metadata is available in Description table. I am looking for a tool or method to get all ...
5
votes
3answers
278 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
2answers
107 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 ...
1
vote
1answer
313 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 ...
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 ...
1
vote
2answers
142 views

Using ArcPy dataSource Path with ArcSDE layers?

I have the following code: When I run it: conType = arcpy.mapping.ListLayers(imxd, "Construction_pt", df)[0] print conType.dataSource prints... "Database Connections\Edit - ...
1
vote
1answer
25 views

Where are Object class extension GUIDs stored in Oracle?

Where are the GUIDs for object class and workspace extensions stored in SDE for Oracle? I've looked through GDB.ITEMS but can't seem to find it. I think SQL Server stores it in an .xml column but I ...
1
vote
1answer
286 views

Using Geodata Service in ArcGIS API for JavaScript?

Can I use Geodata service in ArcGIS JavaScript API 3.1 ? Background : I have simple map service and the all attribute data is stored in Sql Server database. I want to perform query operation on map ...
2
votes
3answers
2k views

How do I access versioned spatial data in SDE with SQL queries?

We're running SDE and have several feature sets with versioning turned on. When I query those layers via ArcGIS Engine or ArcGIS Server, all expected features are returned. We have numerous non-GIS ...
0
votes
2answers
40 views

Reading Arcsde Data of a specific version in python

how can i read a version within python. for example lets say I set up a workspace which points to a .SDE file connection. Now how can I read the features from a version within python? I have looked ...
1
vote
0answers
12 views

How to reconnect Arc GIS Schematics diagrams to GIS data in another oracle/SDE

My problem: An Arc GIS Schematics diagram export with versioned oracle/sde GIS features can't be reconnected to GIS data on another oracle/sde instance. I'm working on a project where in the first ...
0
votes
0answers
37 views

ArcCatalog Unable to Connect to Database (Invalid object name SDE_table_registry)

Trying to make a database connection in ArcCatalog The ArcServer is on a separate vm than the SQL Server vm. When I attempt to connect to the database using integrated security I get the error: ...
1
vote
2answers
52 views

AddIndex_Management throws maximum open cursors exceeded

The following script is run to create indexes across all the feature classes within a particular dataset: import arcpy import os.path def listFcsInGDB(): for fds in ...
1
vote
1answer
155 views

Change sde connection parameters with ArcPy

I know you can create a database connection with Arcpy using the CreateDatabaseConnection_management function. I am wondering if anyone knows a way in which to change the parameters of that file. ...
0
votes
1answer
252 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 ...
1
vote
1answer
40 views

Upgrading from sde 9.2/oracle10g to sde 10.2/oracle11g

I have an old geodatabase created using Arcsde 9.2 on Oracle 10g. Now, I'm trying to update it to new system using ArcSDE 10.2 on Oracle 11g r2. Because SDE 9.2 schema and SDE 10.2 are not ...
2
votes
1answer
253 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 ...
0
votes
1answer
60 views

Foreign Key is not added to destination table after the creation of a relationship class

Let's say I have two tables A and B. The relationship between these two tables is as follows : A (1,*) <---- (1,1) B Now when I try to add a relationship class for these two tables on Arcatalog, ...
0
votes
1answer
60 views

Implementing ArcSDE cost effectively using PostgreSQL?

I wish to implement an ArcSDE environment without breaking the bank. I would be wanting SQL databases. If I use PostgreSQL what are the limitations and or the requirements to make it work? We have ...
0
votes
1answer
485 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 ...
3
votes
2answers
225 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 ...
5
votes
0answers
662 views

Connecting ArcSDE to Quantum GIS for dummies?

I really have a need to be able to connect to and edit ArcSDE data in Quantum GIS. This question has been asked before and apparently is possible, but the instructions are just not specific enough ...
0
votes
0answers
39 views

Establishing direct connection to ESRI geodatabase on Oracle hangs while not in debug mode

Recently I have been trying to establish direct connection to oracle geodatabase using Java API. The problem is, that when I execute the code, the connection works fine only in debug mode when I ...
2
votes
0answers
30 views

Loading feature linked annotation to existing sde Database

I have feature linked annotation (composite) in sde Databese and i need to add / load annotation from another Database FGDB, is there a way to do this? or i need to make all the prosses again (Lable ...
1
vote
1answer
118 views

Error Creating Feature Layer from Parcel Fabric, Error 000732

Currently I am writing a python script that creates a feature layer from our parcel fabric and then appends that data into a different SDE feature class. The problem is that when executing ...
1
vote
1answer
779 views

Why does copying ArcSDE datasets and features in Python give ERROR 000732 & 000735?

I keep getting a kick back that says this: ERROR 000732: Input Features: Dataset 'Database Connections\Wyoming.sde\Supporting_MT_DBO_Geology' does not exist or is not supported Failed to execute ...
1
vote
0answers
28 views

What tools are avialble to help keep DEV, UAT, and PROD environments in sync?

Recently, I was doing some development work against our DEV environment. It seems logical at the time. When nearly complete, and after much face palming, I found the DEV environment was way out of ...
0
votes
0answers
45 views

Using Arcpy to Update Data Source Does Not Update Related Tables

I have a python script that updates the data source of mxd's from staging to production. Here is an example of the code: import arcpy mxd = arcpy.mapping.MapDocument(r"C:\Project\MyMap.mxd") for lyr ...
0
votes
1answer
156 views

Direct connection from geotools to arcgis 10.3

Is it possible to direcly connect to ESRI 10.3 database using geotools ? I use geotools 13.0 and have ESRI database set up on oracle. Previously I was able to connect to SDE using gt-arcsde-plugin ...
3
votes
2answers
3k views

Error 001359 when publishing map service to ArcGIS server 10.1

I encountered this error when trying to publish a map service to an ArcGIS Server 10.1 (installed on linux). --------------------------- Service Publishing Result --------------------------- ...
0
votes
2answers
47 views

Learning about Editing on ArcSDE?

I am looking for some information about Editing in ArcSDE in a PDF or online that I would like to read about. I came to the USDA's Forest Service from the USDA NRCS and NRCS does not have ArcSDE. The ...
1
vote
0answers
65 views

Understanding Number of Feature Classes vs Connection Time with Enterprise Geodatabases

So here's the situation - at the moment I am having a problem where the more feature classes I load into a ArcGIS 10.2 enterprise geodatabase in PostgreSQL, the slower the connection time becomes. I ...
0
votes
1answer
49 views

Definition Query to find next date value in ArcSDE attribute table?

I have an ArcSDE feature class that contains a date field called "SALE_DATE". This sale date represents the bid date for ALberta crown mineral rights sales. A sale occurs about twice per month (one ...
6
votes
3answers
3k 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 ...
5
votes
2answers
583 views

What does it mean to QI and how is it done?

I'm new to Esri's Arc* interfaces, and trying to figure out how to register an existing table using the ArcObjects API. The following question answers this to some extent: Is there any way to write a ...
3
votes
1answer
1k views

Error importing XML workspace document to file geodatabase

Ok so I have a large SDE geodatabase that I exported to an XML Workspace Document. I tried to importing it again into a file geodatabase to test if the export worked correctly and got the following ...
1
vote
1answer
45 views

Surfacing data in ArcSDE enterprise geodatabases in Portal

Is it possible to use data from ArcSDE geodatabases (hosted in Oracle, in this instance) in Portal webmaps? I've been searching documentation and the internet for a while, and it's implied that it's ...
4
votes
2answers
4k views

What is the difference between ArcSDE and ArcGIS Server?

I have been working with ArcGIS Desktop where I use ArcMap for doing GIS work. Can anyone please explain to me in simple words What is ArcSDE and ArcGIS server? These can be independent dedicated ...
1
vote
0answers
24 views

User Permissions on ArcSDE Geodatabase in SQL Server 2012

We set up an enterprise geodatabase in SQL Server 2012; Is it possible to set user permissions at a feature class/table level to only view certain attribute types? For example, a pipe layer has ...
0
votes
2answers
121 views

Copying Personal Geodatabase (in Access) with relationship classes to ArcSDE for SQL Server?

How to copy a Personal Geodatabase (in Access) with relationship classes to ArcSDE for SQL Server. I tried a simple copy paste and imported, but didn't get the relationship classes. error: unable ...