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
1answer
237 views

How to add a column to table with sdelayer command?

I am working with an oracle11g database and I would like to add a new column to a feature class stored in this database. I would like to use the sdelayer command but can any one of you give me a tip ...
1
vote
1answer
150 views

“SDE error 6” when publishing GeoServer layer

I have successfully created an ArcSDE datastore in GeoServer 2.2.4. When I try to publish a feature class in the SDE database, the "Compute from data" link returns nothing, and the "Compute from ...
1
vote
2answers
159 views

Identifying the Primary Key field of the Layer in ArcGIS Server

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 ...
1
vote
2answers
954 views

arcsde - index LOADING/FAILED/UNUSABLE

I have a problem with import data with fme and arcsde. I have a loop of import data in the same arcsde table. I have a problem with index : Error while executing stream insert operation for table ...
1
vote
1answer
1k views

Delete SDE feature class features with ArcPy

I'm working on a script that will empty my SDE database of all data. How would I go about deleting features from feature classes using ArcPy? I have an SDE connection created with a user that should ...
1
vote
1answer
475 views

Creating bulk field aliases for several layers within same ArcSDE feature class using ArcPy? [duplicate]

I have an ArcMap with ~200 layers from the same sde feature class. After I finished adding all the layers it was brought to my attention that we need to add field alaises for the attribute table. ...
1
vote
1answer
310 views

How to convert int type OBJECTID to ObjectID type recognised by ArcSDE?

I have an ordinary table with OBJECTID column (type of int) in a MS SQL Server 2008 R2 instance. I need to store it in an ArcSDE geodatabase instance running on top of the SQL Server. The thing is how ...
1
vote
2answers
1k views

Select and highlight features

I have 2 ESRI feature layers on my map; points and polylines. I can select them just fine either by rectangle or polygon. What I am missing is how to highlight (larger size and different color) the ...
1
vote
1answer
189 views

ArcToolbox Create Replica tool advanced options

I am trying to create a two-way Replica of my SDE database to another SDE database in ArcGIS 10.0 If I use the Create Replica wizard from the 'Distributed Geodatabase' toolbar in ArcMap I am able to ...
1
vote
1answer
440 views

Copying and renaming files on SDE connection

I have a script that renames and copies files (feature classes) on an SDE connection. This script works just fine if the feature class name does not start with an 'S'. If the feature class name does ...
1
vote
1answer
1k views

Add Spatial Database Connection fails?

I created a Database Server (SQL Express 2008.) I created a "New GeoDatabase..." I double-click on "Add Spatial Database Connection." I fill out the dialog and change the transactional version. ...
1
vote
1answer
864 views

ArcGIS Server 10 and SQL Server 2008 R2 permissions and feature services

I have ArcGIS Server 10 with SP1 and SP2 on windows server 2008 and ArcSDE (from an edn liscense) installed on top of MS SQL Server 2008. When I make a spatial db connection in ArcCatalog (direct ...
1
vote
3answers
478 views

Editing non-nullable fields of ArcSDE layers in ArcMap

I'm using ArcSDE layer in my map project in ArcMap 10. Some of the fields of this layer allow null and some don't. I can't edit the non-nullable ones, neither programmatically (IField.Editable is ...
1
vote
2answers
447 views

Access Feature Classes on Multiple Database Schemas with ArcSDE

I am using ArcObjects to access a GeoDatabase that was set up with ArcSDE 10 and SQL Server 2008 R2. In this particular case, I have some tables set up on alternate schemas (this is to replicate a ...
1
vote
1answer
464 views

How to execute gp.execute ArcSDE tool in C#

So I created an ArcGIS 10 toolbox in ArcSDE and added a tool to it. There are enough examples out there on how to execute a tool.tbx that resides outside SDE or GeoDB. But in C#, how do you use ...
1
vote
3answers
961 views

ArcSDE & Oracle & Database Model — Best diagram the system

Having Oracle dbms with ArcSDE and ArgGIS Pipeline Database Model (APDM), I would like to best describe the system with a diagram. In MS SQL each db is autonomous, I think, meaning ArcSDE(using dbo ...
1
vote
1answer
159 views

Enable Archiving failing on sde 9.3.1 and MS SQL Server 2008

I am trying to enable archiving and am getting this error: Violation of PRIMARY KEY constraint 'archives_pk'. Cannot insert duplicate key in object 'dbo.SDE_archives'. Is this saying that there is ...
1
vote
1answer
153 views

ESRI fc is called database.DBO.fcname and version is called SDE.fcname

ArcSDE 9.3.1 and MS SQL 2008 R2 In ArcCatalog the feature class is called database.DBO.fcname and when I look at the connection properties in ArcCatalog the default is called DBO.Default and the other ...
1
vote
2answers
240 views

Keeping SDE for data maintenance, but use postgis for display

We build and maintain GIS data in a production environment with SDE on SQL 2008. We also have a need to open up WMS and WFS that will make a complete ESRI solution really expensive. With an ArcGIS ...
1
vote
0answers
10 views

Create an enterprise geodatabase - Administrator username and password are required

I am trying to create an enterprise geodatabase in oracle 11g, using the create enterprise geodatabase tool in arcmap 10.2. I have properly installed the oracle client needed and I am able to create ...
1
vote
0answers
15 views

Concurrency and lock challenge in Nonversioned editing in ArcMap

I use a non version SQLServer geodatabse with geometry type for spatial data storing.To do so,I have registered all layers in SDE repository and geodatabase and ArcMap shows all layers and edit them ...
1
vote
1answer
5 views

Generate Statistics from check-out GDB While performing Check-in

I have created Check-out Replica from the main ArcSDE GDB. I have below questions. How to generate statistics of the edits performed on the check-out GDB, before check-in. for example: i want to have ...
1
vote
0answers
16 views

Updated features from GDB after Check-out Replica created from ArcSDE GDB [closed]

I have created Check-out Replica from the main ArcSDE GDB. I have below questions. If GDB Admin update few things (Attribute or Spatial) after version was created, will it be reflected in the child ...
1
vote
0answers
23 views

How to extract xy coordinates to featuretable using ArcGIS web map/app to create points?

I have an ArcGIS online web app to collect points using the services served on our server. The featurelayer exists in our SDE server. How can I extract and update the xy (lat/long) coordinates ...
1
vote
0answers
53 views

SQL Prefix for arcpy.da.SearchCursor

Does the sql prefix - DISTINCT work well on SDE tables? http://resources.arcgis.com/en/help/main/10.1/index.html#//018w00000011000000 Syntax: SearchCursor (in_table, field_names, {where_clause}, ...
1
vote
0answers
29 views

arcpy geoprocessing service with sde database produces no output url

I'm trying to use a geoprocessing script to clip some data and return to the user (via url) the path to a zip file with the results of the clip. I also need to connect to an sde database. I can get ...
1
vote
0answers
46 views

ArcGIS Error 999999: Feature Compare Tool

I'm running the ArcGIS feature compare tool against 2 point feature class layers. I'm comparing 9.1 SDE layer against a 10.1 SDE layer. In the feature compare tool one of the input options is ...
1
vote
1answer
41 views

Cannot Register Database

I want to publish a database to ArcGIS Server. When I try and register the database, I get this error: Can anyone help me? I am using ArcGIS Server and Desktop 10.2 with Microsoft SQL Server 2008. ...
1
vote
1answer
27 views

Recommended approach to integrate GeoNetwork with SQL Server database

I am new to GeoNetwork. But now my organization wants to invest in it to see how we can make the best use of it for publishing, sharing and distributing metadata. We currently have all our GIS data ...
1
vote
0answers
25 views

Can I install GIS Software on RSS (informix server) running 11.7.fc6

I currently use ArcGIS Server 10.0 and consume data through a db2 database. I recently installed an RSS informix server and was hoping to pull data from this since it is updated real-time versus the ...
1
vote
1answer
99 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
25 views

ora-01747: user.table.column, table.column or column description is invalid

everyone. I created a table in oracle with a sde.st_geometry column. I followed the instructions of ArcGIS help to register the table into geodatabase. However, when I try to load data into this ...
1
vote
0answers
28 views

Renaming Feature Class within versioned Feature Dataset

I am working in ArcSDE. I have several feature datasets within an Oracle Enterprise Geodatabase. When I try to rename one of the feature classes that is within a feature dataset it "falls out" of the ...
1
vote
1answer
66 views

Cannot create new spatial database connection in ArcCatalog?

I have searched a lot in the net, but i just found Add Spatial Database Connection fails? here. However, I cannot see the confirmed answer. I want to know if anyone has found the solution? my ...
1
vote
1answer
54 views

ArcMap 10.2.1 issues diffferent SQL than 10.0 for “Select by location”?

I have a large point layer and I'm doing a "Select by Location" to select all points that intersect a specific selected polygon from a polygon table. In ArcMap 10.0 the SQL that was executed was ...
1
vote
0answers
49 views

Editing versioned view in ArcSDE 10.1 error

I am working in an ArcSDE 10.1 instance sitting on Oracle that I believe was upgraded from a previous ArcSDE version. It has a versioned view for the table I am trying to edit (specifically, delete ...
1
vote
0answers
73 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 ...
1
vote
0answers
139 views

ArcGIS 10.2.1 crashes during connection with ArcSDE 10.0 inside PostgreSQL 8.0.1 [closed]

I'm currently working in an infrastructure built with ArcGIS 10.0 (Desktop and Server) [SP2 build 3200] and because for some functionalities (ArcGIS for Desktop extensions) I need to use a newer ...
1
vote
0answers
75 views

Changing default precision and scale of number fields in ArcSDE geodatabase table?

After I change the precision and scale for my short, long, float, and double field types when creating a table in ArcMap SDE geodatabase, ArcMap will reset my precision and scale to default values. ...
1
vote
1answer
38 views

Select parcels from SDE layer using table list and exporting to shapefiles

Using a table of county fips codes and state name, I need to select from a large parcel layer stored in SDE and export to individual shapefiles based on the fips code and state name from the table. ...
1
vote
1answer
158 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 ...
1
vote
1answer
27 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
vote
0answers
47 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
66 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
0answers
168 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
40 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
0answers
41 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 ...
1
vote
0answers
60 views

Cannot Save Edits to File Geodatabase Replica in QGIS 2.2

When trying to edit a File Geodatabase Replica in QGIS 2.2, everything works as expected until the user saves their edits. When pressing save, all edits revert back to their original state with no ...
1
vote
0answers
128 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 ...
1
vote
2answers
123 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) ...