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)

3
votes
1answer
111 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 ...
2
votes
1answer
55 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
25 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
1answer
51 views

Populate X and Y fields in SDE Point Data Using SQL trigger

Here is my situation. I am running ESRI ArcGIS Server and Desktop 10.2 on SQL Server 2008 R2. I would like to populate the Latitude and Longitude fields from point data (Signs data collected using ...
2
votes
1answer
95 views

How to add ST_GEOMETRY column to an exitsting table that already has X Y columns

I have created and Oracle 11g geospatial geodatabase and have create an arcsde connection. I have been connected using arcmap, as a simple user (not sde or schema-user), who has all the proper rights ...
1
vote
0answers
227 views

Creating relationship class in ArcSDE?

I can not seem to create a relationship class in ArcSDE, or at least one that works. I am succseful in creating the class however ArcMap does not recongnize it (there are no related tables shown) and ...
1
vote
0answers
297 views

Loaded shapefile into SDE without spatial proj creates problem

Via a Python script - various shapefiles were loaded into SDE with no spatial reference set. This causes a strange problem - when you view the featureclass in ArcCatalog (geography view) - it shows ...
1
vote
0answers
90 views

Can we do replication and versioning in User schema geodatabases version with sde default version

As both are administrators to their own schemas, is there any possibility to post and reconcile data across schemas?
1
vote
0answers
301 views

T-SQL with SDE and Web Map ArcGIS Server 10 MSSQL 2008

I need to build a system whereby the user of a web map (the standard web map that ArcGIS Server Manager builds) can edit a feature class's attributes. The attribute will be a 'Comments' field. The ...
0
votes
0answers
22 views

Accessing Versioned data using database link

I have geodatabase on one Oracle server. The data is versioned. I am trying to access the versioned data from another Oracle server using a database link. While accessing the a feature class named ...
0
votes
0answers
26 views

Is a unioned feature class the fastest/best way to quickly get attributes from multiple feature classes at once?

I've been asked to create a feature class by unioning 18 polygon feature classes together, and retaining only certain attributes. The goal is to have a single feature class that can be queried once to ...
0
votes
0answers
24 views

Python script can't find custom module in ArcSDE

I've been working on a python script for some time. Its working well but I'm having trouble running it in SDE. My main issue is that the python script, when run in SDE, cannot find any of the ...
0
votes
0answers
18 views

Map Control Didn't Show Editing Result

I have created an application with data from SDE Geodatabase (Oracle). I've registered it as version without tick on the option to move edits to base. Anyway, in my application there is a part where ...
0
votes
0answers
34 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 ...
0
votes
0answers
20 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 ...
0
votes
0answers
77 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
0answers
33 views

Trouble with select by attribute on ArcSDE

I am having trouble with some extracts on a csv table on ArcSDE. Verifying my expression results in the following pop up: "The expression was verified successfully but no records were returned."
0
votes
0answers
25 views

View Oracle GeoRaster in ArcMap

I have imported SRTM DEM into Oracle 11g using FME.The block size is set to 128X128.I am able to view the data in QGIS,Tatuk and play with it using GDAl command line.Unable to view the same in ArcMap. ...
0
votes
0answers
22 views

How to …NonRelational geoDB to Relational geoDB

I have Access personal database without any relations and would like to import all data in SQL using ARCSDE Personal and build relations. This is bad structured database and I just couldn't figure out ...
0
votes
0answers
73 views

Unable to create multiversion view in ArcSDE 10.2 and Oracle 11g

I couldnt create a multiversion view using 10.2. I registered feature dataset as versioned, it created MV view for one class but didnt create the MV view for the other one. Even I tried creating the ...
0
votes
0answers
65 views

How to correctly uncompress and re-compress an msd file using 7zip from command line

I am trying to uncompress and recompress both the msd and sd file so as to tweak some things I want. In fact I want to get inside the layers folder and for each layer.xml file to string replace the ...
0
votes
0answers
143 views

Error selecting geometry from Oracle DB

I'm trying to select a geometry column as well-known text from a feature class in an Oracle 11g/ArcSDE 10.1 geodatabase. (This is in a Python script using pypyodbc as a driver). This is my SQL: ...
0
votes
0answers
61 views

What is the most efficient method for deleting row/features from a versioned FC in python?

I'm trying to delete all records from a feature class in SDE and then append new data using python. My dataset is versioned in SDE. I've tried Truncate Table (doesn't work with versioned tables), ...
0
votes
0answers
29 views

How to see original versions of imported features with archiving enabled

I recently imported several feature classes into an ArcSDE Oracle database, registered them as versioned, and then enabled archiving. I was under the impression that I would be able to see a ...
0
votes
0answers
46 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 ...
0
votes
0answers
233 views

ORA-04043: object ST_GEOMETRY_SHAPELIB_PKG does not exist

I uninstalled ArcSDE using the esri.exe, and dropped user sde through running the sql statement "drop user sde cascade". Now I want to reinstall ArcSDE. The installation runs successfully, but when I ...
0
votes
0answers
48 views

Exporting ArcSDE feature class to shapefile using OGR?

I'd like to export data from ArcSDE for SQL Server to SHP. I've tried first to run this python script in QGIS: http://trac.osgeo.org/gdal/browser/trunk/autotest/ogr/ogr_sde.py But finally I've got ...
0
votes
0answers
85 views

How to get ArcSDE plugin working with Geoserver 2.5.1

I'm trying to get the ESRI ArcSDE plugin to work with my instance of Geoserver. This is my current setup: Tomcat 7 GeoServer 2.5.1 ArcSDE Plugin for GeoServer 2.5.1 WEB-INF\lib\icu4j-3.4.4.jar ...
0
votes
0answers
38 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 ...
0
votes
0answers
70 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
0answers
62 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 ...
0
votes
0answers
111 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 ...
0
votes
0answers
14 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 ...
0
votes
0answers
82 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
125 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
111 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 ...
0
votes
0answers
32 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 ...
0
votes
0answers
22 views

Why can I see the data from a second sde database connection in my database?

I have an sde 9.3 database which when opened in arccatalog shows the data from another sde database. Under settings > Source this is confirmed. Why and how can this happen? The only thing the 2 ...
0
votes
0answers
66 views

Update ArcGIS metadata Tags field with feature class name

We have ArcGIS 10.1 Enterprise SDE/SQL Server and are trying to figure out the best way to automatically update the tags field by using the feature class name. All our fc names have underscores, I'd ...
0
votes
0answers
290 views

post instlacion ArcSde 10 "error creating Arcsde direct Connection (-9)

I installed SQL sever 2008'm doing the post installation used ArcSDE 10 these are the steps I am doing in post installation of ArcSDE 10 complete installation. SDE Schema. put the name of my ...
0
votes
0answers
218 views

Nullable fields in feature service will not save with null values

I created my file gdb schema in Diagrammer, which included setting up several coded value domains, and applying them to fields in the feature class. All the fields have their Required property as the ...
0
votes
0answers
202 views

Why does Append on large annotation layer give WARNING 000594: Input feature falls outside of output geometry domains?

I am trying to Append about 3,000,000 records in an annotation layer to another, empty annotation layer. I'm using ArcCatalog and I get the following error messages: WARNING 000594: Input feature ...
0
votes
0answers
170 views

While Exporting from SDE, null geometry features attack?

I'm working on a layer in an SDE Database (ArcMap 10.1 SP1 for desktop (Build 3143)), I just export to a local working database on my workstation the layer I want to work on and load it back when ...
0
votes
0answers
117 views

SDE Replication works through ArcMap but not through ArcCatalog

I'm running 10.1 on a 10.0 SDE database. We're trying to replicate our database (one-way parent to child) to a file geodatabase. Ideally I'd like to have this automated using python or .bat files but ...
0
votes
0answers
230 views

Export From PGDB to ArcSde Using C#

I need help exporting a personal geodatabase Feature Class to an ArcSDE geodatabase using C# ArcObjects with ArcGIS 9.3. I just want to replicate the tool Feature Class to Feature Class ...
0
votes
0answers
150 views

ESRI AddFeatures call on rest endpoint with attributes

I can add a line feature via the rest endpoint with my hand crafted call from C#. However, if i add any attributes to the call it will fail and say unable to perform operation. All of the fields in ...
0
votes
0answers
140 views

SDE Connection raise exception

I am supporting a .NET code that is running on ArcGIS Server 10.1, and communicating with ArcSDE Application Server 9.3 There is part of the code that is doing long loop. And when it comes back to ...
0
votes
0answers
493 views

Configuring image popups in a Silverlight application

My Silverlight application contains a points layer which contains paths to a folder of geotagged photos. These points were generated using the GeoTagged Photos to Points tool. I chose not to import ...
0
votes
0answers
614 views

ARCSDE; creating new geodatabase in database servers in arccatalog

I use arcsde 9.3. I want to access a geodatabase on mobile. when I want to create new geodatabase in the list of database servers in arccatalog the error is "error creating geodatabase no arcsde ...
0
votes
0answers
156 views

How can I upload an annotation featureclass to ArcSDE using C#?

I can upload the shape files to ArcSDE database successfully,but I fail to upload annotation featureclass.