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
11 views

Geo-Database Corruption in a versioned 10.3 environment [on hold]

We are an EGIS group using ARCSDE and ARCDESKTOP v 10.3 in a versioned environment to manage public works service requests. We recently upgraded our desktop versions from 10.0 to 10.3 while our ...
0
votes
0answers
27 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") ...
0
votes
2answers
38 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
3answers
239 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 ...
2
votes
1answer
139 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
0answers
59 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
43 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
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 ...
5
votes
2answers
577 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
36 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
3k 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
11 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 ...
1
vote
0answers
18 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 ...
5
votes
3answers
271 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 ...
1
vote
1answer
305 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 ...
0
votes
2answers
113 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 ...
0
votes
0answers
22 views

Troubles setting correct projection in SDE

I have to transformate data and change the coordinate system but have troubles to set it correct programmatically. I have: ArcGIS 10.2 / MS SQL-Server 10.0.5520 / sde 10.2.2 My steps: 1) Some ...
0
votes
1answer
37 views

Error when enabling ArcGIS geodatabase

We're trying to enable enterprise geodatabase functionality in an existing PostgreSQL database. We've already created the sde user (set as superuser) & sde schema. We get the following error: ...
0
votes
0answers
30 views

ArcGIS Versioning - Conflicts option greyed out / disabled

I'm relatively new to the world of Versioning and using SDE databases, and have come across a problem that I can't solve. Summed up - the Conflicts option/button is greyed out/disabled, and I know ...
1
vote
2answers
22 views

Database Server Node vs. Database Connection Node

What are the main differences between the Server Node and the Connection Node? The only difference I have been able to find is that the Server Node is intended for administrative tasks while the ...
6
votes
1answer
930 views

How to transfer data and replica information from a file geodatabase to ArcSDE?

I've got an arcgis 10.1 file geodatabase that contains a number of featureclasses and a number of one-way child replicas. Is there any tool that I can use to transfer the data and replica information ...
0
votes
0answers
24 views

How to get metadata about Esri Geodatabase Replica synchronization

I'm using ArcObjects for .NET to create an one-way replica from my geodata-service (master) to an ArcSDE geodatabase (slave). During synchronization I do need metadata about the incoming changes to ...
1
vote
1answer
550 views

Feature Access ArcGIS 10.1 Registered Database Publishing Error

I created a feature class from an XY table in ArcCatalog, and I am trying to publish a feature access enabled map to my server. When I try, I keep getting a 00090 error which is "feature service ...
0
votes
1answer
65 views

Web Editing Versioned Enterprise GDB

I would like to implement a web editing environment where edits are posted to a version of a database (delta tables) not too default. The idea behind this is so that any edits made through a web app ...
4
votes
2answers
4k views

ArcGIS Server Error: “Feature service requires a registered database”

I'm attempting to publish a feature service to ArcGIS server. I'm running SQL Server Express and ArcSDE. When I try to publish the service I get the error "00090: Feature service requires a registered ...
0
votes
0answers
27 views

Unable to create multiple geodatabases in ArcSDE?

I am trying to create multiple instances in arcsde 10.3. Able to create and run the first instance. But, when I tried to run the second instance it throws error(attached) in create/enable geodatabase ...
1
vote
0answers
20 views

ArcSDE Enterprise Geodatabase - XML and Tolerance Issue

I set up an ArcSDE Enterprise Geodatabase in SQL Server 2012. I imported the XML file from the Utility and Pipeline Data Model without any modifications. I am now running into an issue: the XY ...
0
votes
1answer
158 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 ...
2
votes
3answers
389 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
234 views

Adding ArcGIS Server services or ArcSDE datasets to Tilemill?

Our web design department wants to use mapbox/tilemill to create webmaps for our public websites, but all our data is made available through ArcGIS-server or ArcSDE. Is there some way to use these ...
0
votes
1answer
47 views

Cannot add database connection using windows authetication SQL Server and ArcSDE 10.3

We can't seem to add a database connection from ArcSDE to sql server 2008 using ArcCatalog 10.3.1 from a specific computer with a specific username. When trying to add a database connection using this ...
1
vote
0answers
49 views

LOX table shows up instead of an address locator in SDE geodatabase on SQL server 2012

Tried to copy an address locator from a network share to an SDE database, that worked. Tried the same thing on another database and it shows up in the target geodatabase as an SDE table with LOX in ...
1
vote
1answer
239 views

Can't select geometry from Oracle DB using SQL

I'm trying to select the geometry field from an ArcSDE feature class in an Oracle 11g database (inside of a Python script via PyODBC). This is my query: SELECT SHAPE FROM USR.FEAT_CLASS This is ...
1
vote
0answers
53 views

Migrating ArcSDE data to Oracle Spatial?

We've got all the geospatial information of our company within an ArcSDE Database (over oracle Server): points lines polygons We consume these data with ArcGIS Desktop and with ArcGIS Server. ...
0
votes
0answers
27 views

Reviewing version conflicts - over 600!

I'm fairly new to working with versioned geodatabases and have found that one of my versions has over 600 conflicts which require review and replacing. I suspect that all objects will need to be ...
0
votes
0answers
28 views

Multiple editors

I am trying to have multiple editors editing the same layer at the same time. I am running ArcInfo v10.2 and have set up a SDE connection using sqlexpress. I have created a geodatabase on my personal ...
2
votes
1answer
229 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
0answers
39 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, ...
3
votes
1answer
188 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 ...
0
votes
1answer
446 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 ...
0
votes
1answer
180 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 ...
0
votes
0answers
30 views

Can't create address locator in SQL Express GDB

I am working out of a SQL Express ArcSDE geodatabase with ArcGIS 10.3.0 Standard and would like to create a composite address locator based on streets and parcels. I can copy and rebuild a streets ...
1
vote
1answer
25 views

ArcSDE feature class prefix issue

I believe this issue is is part of a bigger problem causing an issue with an arcpy script that I am trying to have run periodically to load data into ArcSDE feature classes using Append_management. I ...
1
vote
0answers
27 views

Can privileges be set to allow certain users read/write access to a protected version?

I have multiple versions of a database (some protected and some public). Would it be possible to allow some of the database users read/write access to the protected versions? I have read of protected ...
1
vote
1answer
43 views

ArcSDE - spatial index grid size for empty table

I'm trying to write the SQL to create a feature class and spatial index in an Oracle SDE geodatabase using ST_Geometry. This is how I'm making the table: CREATE TABLE STREETS (ID NUMBER(11) NOT NULL ...
1
vote
1answer
497 views

arcpy JoinField_managment RuntimeError

My script is supposed to pull weekly flu data from a department of health website, parse it for that week, and then push the data up to our ArcSDE server so that it can be displayed on our Web Mapping ...
18
votes
8answers
6k views

When Versioning with ArcSDE can posted edits be cancelled or rejected?

I am using ArcGIS 9.3.1 and attempting to work with an SDE geodatabase (with one polygon feature class) that has already been registered as versioned. I'm new to versioning and am still trying to ...
2
votes
1answer
40 views

Replacing layer ArcSDE connection

I am very new to using Python... I have an MXD with all of my layer files in it. They are grouped by category etc. Each layer file references a dataset within my SDE. My SDE has two different ...
0
votes
0answers
18 views

libst_raster_pg.dll for PostgreSQL 9.2

I need to store my raster in an enterprise geodatabase with st_raster data type. Copying libst_raster_pg.dll from C:\Program Files (x86)\ArcGIS\Desktop10.3\DatabaseSupport\PostgreSQL\9.2\Windows64 ...