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
417 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
95 views

How to Avoid Object ID conflicts in Versioned geodatabase

We have just implemented a versioned Geodatabase and our schema has few feature classes and relationship classes. We do not Reconcile and Post to the parent ( Default) version, as we need some ...
1
vote
0answers
254 views

Replicas: Synchronize changes for individual feature class (not entire replica)

I have two ArcSDE databases, running with a two-way replica.One serves our interactive mapping website which gives certain users the ability to update, add points, edit attributes, etc. Then we have ...
1
vote
1answer
304 views

Has anyone experienced problems editing between ArcGIS 10.1 and an older ArcSDE geodatabase 9.3.1?

We are unable to edit feature classes in an ArcSDE 9.3.1 Versioned GDB using an ArcGIS 10.1 .mxd map. The feature classes are part of a geometric network. Previously we were able to edit feature ...
1
vote
1answer
189 views

updating a feature class from an EXCEL spreadsheet

I created feature classes that only contains the data from an EXCEL file. I did this to enable the search function to search the data in these tables. The FCs also have relationships between ...
0
votes
0answers
159 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 ...
2
votes
1answer
251 views

How can you tell if a RDBMS is an ArcSDE Geodatabase?

I want to know if there is any way I can query the RDBMS to determine whether it is an ArcSDE Geodatabase, or if I have to do it through ArcObjects. I am wondering if it would be enough to check if ...
1
vote
1answer
147 views

SDE Versioned Data Editing Problem

ArcMap is telling our users that data from a certain feature dataset needs to be registered as versioned to edit. ArcCatalog is showing us that the feature dataset in the SDE is not registered as ...
0
votes
2answers
253 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
0answers
133 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 ...
3
votes
1answer
2k 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 ...
2
votes
1answer
137 views

Renaming shapefiles with prefix while running arcpy.FeatureClassToGeodatabase?

I'm fairly new to the arcpy world. I am trying to create a script in 10.0 that will load a dataset (file geodatabase) into ArcSDE and rename the feature classes with a prefix, i.e. San_Diego_Bay -> ...
1
vote
1answer
205 views

How to Change the schema of SDE dataset in Connected environment

We continuously use to receive changes in Schema ( field +/-, domain changes etc ) for our Utility dataset.. Since we have swicthed to a multiuser Geodatabase ( ArcSDE on Oracle ) , we would like to ...
0
votes
0answers
101 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 ...
3
votes
1answer
142 views

How to get any changes happened in the current SDE version?

How to get any change done on the map in the current version of sde. using arcObjects e.g. if i had a line on the map. and in the current sde version i changed the length of that line. how to get this ...
1
vote
0answers
113 views

How to display labels from many-to-many relationship in ArcGIS 10 using VB.NET?

I have two tables in a geodatabase: parcel; and person 1 or + parcel, can have 1 or + person (relationship is many-to-many) Using VB.NET I can display all the parcel labelled with the ...
3
votes
1answer
873 views

Change ArcSDE data source for mxds in specific folder using ArcPy?

I've searched all the forums and help and have made progess but recently got an error that has thrown me for a loop - also some mxds are not being changed at all! What I'd like my code to do: Iterate ...
2
votes
2answers
420 views

Understanding ArcGIS Server connection types

Being relatively new to ESRI ArcGIS Server I have a question regarding the storage of ESRI SDE Databases - AGS 10.0 Enterprise and ArcSDE 9.3. Firstly the naming of the whole structure gets ...
1
vote
1answer
156 views

arcpy update cursor: can't connect to a database table

I am using updateCursor to retrieve some rows from a non spatial table using a connection of type "Spatial Database Connection" (That creates a .sde file) from ArcCatalog. However, it doesn't work, ...
3
votes
3answers
332 views

ArcSDE command registration issues

I have an ArcSDE 10.0 enabled SQL Server 2008 R2 database on a development server. We are using TeamCity to run continual deployment to this development server, which runs through the following steps: ...
0
votes
0answers
192 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
1answer
204 views

Do any of the SQL Server 2008 R2 SP 2 cumulative updates contain the MAXDOP spatial index fix?

I am troubleshooting ArcGIS 10.1 performance issues with SQL Server 2008 R2 SP 2 (10.50.4000) and the issue appears to be this MAXDOP issue: ...
3
votes
5answers
336 views

Installing ArcGIS 10.1 on SQL Server 2008 R2 Cluster

We're running into some performance issues when accessing large enterprise geodatabases on a SQL Server 2008 R2 cluster. The database itself performs well and returns queries fine but presenting the ...
4
votes
1answer
196 views

Difference between registering with ArcSDE and registering with Geodatabase?

As I understand it : Registering with ArcSDE: gives the possibility to ArcGIS to recognize spatial data stored in a database Registering with Geodatabase: makes it possible for data to participate ...
1
vote
1answer
703 views

Trigger a python script to run after a row is added to the feature class

I have a Python script which runs on a SDE feature class daily (as a scheduled task). I would actually like this script to run whenever a new row is added to the feature class (data is captured in the ...
3
votes
2answers
88 views

Can feature classes have the same name in two different feature datasets?

I have an SDE Database called "Vector" which contains many feature datasets eg. Region_1, Region_2 etc. I have to reproject the feature classes inside these datasets. Instead of creating a new ...
2
votes
1answer
101 views

Add features to main SDE Table with geotools

Sorry for my english, I hope you can understand ;) I'am using geotools 8.4 version. I try to copy all features from SDE Table(TEST.DBO.MM_SOURCE) to another SDE Table(TEST.DBO.MM_TEST). All features ...
18
votes
2answers
1k views

Which geodatabase type is most appropriate for both open source and ESRI use?

Main Question: Is there a geodatabase type that seamlessly works with both ESRI and open source products? Details: My company currently passes around geodata in various vector and raster file ...
5
votes
2answers
320 views

Why shouldn't data be loaded into an enterprise geodatabase logged in with sde user?

I've read somewhere that it is not good practice to load data into an enterprise geodatabase using the sde user. I was wondering what the reason for this is? Thanks.
6
votes
2answers
786 views

What are benefits of using ArcGIS with PostgreSQL over simply ArcSDE?

I understand that in order to benefit from ArcGIS spatial datatypes (ST_GEOMETRY, versioned geodatabases etc.) ArcSDE needs to be installed - and with the 10.1 client it is automatically installed ...
1
vote
1answer
80 views

Migrating Lines to ArcGIS polyline

I'm trying to import geometry lines from Oracle Spatial database to ArcGIS enterprise geodatabase. and some data will cause the error. Its says not enough points for feature class, but when I look ...
1
vote
1answer
358 views

How to insert features in a MS SQL based SDE without giving ObjectID s?

I'm trying to load features into ArcSDE without using ArcObjects, and using SQL from my .NET Application instead. I have followed the answers given in this question: Is it possible to load features ...
3
votes
1answer
169 views

Convert OpenStreetMap schemas to ArcSDE in PostgreSQL database

I am trying to find a way to store OSM Extracts (or possibly the planetfile) in a PostgreSQL database, keep it up to date with diff files and then process the data further with ArcGIS (e.g. Geocoding, ...
0
votes
1answer
206 views

Problem in filling table of ArcSDE feature class in SQL Server 2008?

I have an ArcSDE point feature class and I add it to ArcMap 10. After that I add some points to it and fill every field for all points in the attribute table and Save Editing. However, the SQL ...
2
votes
1answer
132 views

Arcpad checkout to an area

I would like to check out data from an SDE database but for performance sake, i prefer to delete all features outside of my survey area. i've tried to copy features in area from sde to a file GDB ...
5
votes
1answer
152 views

Listing ArcSDE versions using ArcPy?

I have an ArcSDE geodatabase with different versions for each user. How can I list each version using ArcPy?
1
vote
1answer
220 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 ...
1
vote
1answer
348 views

Importing data from Oracle Data Pump into empty Oracle ArcSDE Geodatabase?

I have an ArcSDE Geodatabase that contains empty layers created using ArcCatalog. I would like to import data into those layers from a Data Pump of an Oracle database that has the same structure as ...
1
vote
1answer
213 views

ArcSDE/ST_Geometry: Can I store polygon and point geometries in same row?

In the system I'm building, we've got a facility that can be represented as either a point, or a point within a polygon (the point in the polygon may or may not be the polygon's centroid). I'm using ...
0
votes
2answers
210 views

How to learn ArcGIS Server? [closed]

I have SQL Server, ArcGIS Server Standard Enterprise 10.0 - and I am new to both. How can I learn to use it. I want to learn ArcSDE but i am unable to understand it. Is ArcSDE available with ArcGIS ...
4
votes
2answers
310 views

Problems displaying joined attribute data through ArcGIS Server

I have an ArcSDE feature class in an ArcMap MXD which I have 'joined' to a view into an external SQL database table, that is connected via an OLE DB connection. In the MXD the join works perfectly; I ...
0
votes
1answer
312 views

Why can't a user with db_owner role version data?

I've made an enterprise geodatabase and added a user with db_owner permissions. When I add a database connection in ArcCatalog and connect to this geodatabase using the user I created, I'm not able ...
3
votes
1answer
240 views

How can I validate a table name on SDE with Oracle backend?

Second title: "Is arcpy.ValidateTableName broken on Oracle?" I have an Oracle SDE database 9.3.1 (service connection). My arcGIS client tools are version 10.0 SP5). I have some names of feature ...
5
votes
3answers
231 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
2answers
2k 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 --------------------------- ...
1
vote
1answer
320 views

Can one edit an ArcSDE Oracle spatial view?

By 'edit' I mean edit the geometry in the feature class, not any attributes in the joined table. Unversioned. I really had it in my head that you can, as long as the objectid column is included in ...
3
votes
1answer
211 views

Synchronizing Changes From File Geodatabase to SDE Geodatabase

I have an SDE geodatabase that has a one way replication to a file geodatabase, where I will make edits to the feature classes offline somewhere. I know that this scenario doesn't support one-way or ...
3
votes
1answer
287 views

Is it possible to undo and redo outside edit session in ArcObjects?

I would like to know if it is possible to undo and redo changes outside of an edit session? If yes, how can I do it in ArcObjects using .NET? I am working on an ArcSDE 10.1 versioned geodatabase?
8
votes
2answers
1k views

Is there workaround for very slow ArcSDE 10.1 data display

I'm suffering from very slow viewing data of and ArcSDE database from an Arcgis engine application, the SDE database is in localhost so there's no network issues. but i still don't know the reasons ...
1
vote
0answers
211 views

Quering a ArcSDE featureclass attribute table after joining

I am trying to query a ArcSDE Feature Class after joining using Iqueryfilter I have two SDE feature classes. 1) Subdivisions : which has details of subdivision and districts (parent) 2) ...