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

enabling feature access without installing ArcSDE 10.1?

Is there any way to enable "feature access" when publishing a map using ArcGIS 10.1 server, without installing ArcSDE?
1
vote
2answers
188 views

ArcReader 10.1 trouble (loading and printing is taking very long ime)

We've run into printing problems in ArcReader 10.1. Our trouble is with a particular floodplain feature class located in an SDE database. It simply takes forever to load! Then, when printing, it takes ...
1
vote
2answers
716 views

Create a One-to-Many Spatial View with ArcGIS 10.1

We have two datasets: parcels and owners. This is a many-to-many relationship, where a parcel can have multiple owners and there may be multiple properties on a single parcel (also with multiple ...
1
vote
1answer
486 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 ...
1
vote
1answer
230 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 ...
1
vote
1answer
174 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, ...
1
vote
1answer
837 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 ...
1
vote
1answer
84 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
407 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 ...
1
vote
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 --------------------------- ...
1
vote
1answer
371 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 ...
1
vote
1answer
333 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
176 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
205 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
1k 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
256 views

How to store AutoCAD data in ArcSDE database?

Does anyone have an idea how i can create a database instance on my ArcSDE geodatabase to store my .dwg files? I have over 1 million of these files and would be happy to automatically extract and ...
1
vote
1answer
2k 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
568 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
341 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
204 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
477 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
953 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
507 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
467 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
485 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
1k 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
167 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
154 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
246 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

Import XML workspace file - why am I losing my z and m parameters?

I am attempting to import an XML Workspace document (database schema) from a file geodatabase into an SDE geodatabase sitting on top of Postgres. The steps I am taking are: In ArcCatalog - ...
1
vote
0answers
19 views

How to re-register a one way replica geodatabase

Long story short. Arcmap crashed during one of my regular synchronizations of a replica geodatabase created through one-way replication checkout. Upon reloading it seems to have unregistered the ...
1
vote
0answers
47 views

Spatial query by ESRI ST_Geometry take too long

I am using ESRI ST_Geometry in my application, and I found that the spatial query is rather slow: The following sql is used for query pois inside a certain bounding_box: select * from ( select ...
1
vote
0answers
22 views

How to recover from deleting the symbolid of a arcgis annotation feature class?

I have arcgis 10.1 (arcinfo license) and I am using a versionned database (arcsde) with SQL Server. I have accidentally deleted the symbolid of one of my annotation feature classes. All annotations ...
1
vote
1answer
39 views

ArcSdeSqlExecute ArcSDE Error -65

I am trying to Select certain fields, resulting from a join using ArcSDESQLExecute but encounter the following error when I try to include the Shape field: AttributeError: ...
1
vote
0answers
27 views

ArcSDESQLExecute to query and update from multiple SDE Databases

I am trying to use ArcSDESQLExecute to return the results of a join and then write the return query into a Feature Class located in a different database. Using Microsoft SQL Server and Arc10.2.2 Is ...
1
vote
0answers
27 views

Using FME, Is there a way to transfer Metadata from an SDE FeatureClass to a Shapefile (shp.xml)

Is there a way to transfer, using FME, the metadata from an SDE featureclass to a shapefile?
1
vote
0answers
39 views

Get Feature Count

My situation is as below, Database 1 : SDE database.Topo Feature Class : 170 Database 2 : SDE database.AOI Feature Class : 1 I want to get feature count of 170 feature classes base on selected AOI ...
1
vote
1answer
21 views

How to created the filtered versions in ArcSDE 10.1?

I am using ArcSDE 10.1 and Oracle 11g, I have a SDE user (parent), and two more users (ex: user1,user2) in my oracle database with required SDE permissions. In my SDE db, i have a polygon ...
1
vote
0answers
28 views

Verify Geodatabase Integrity?

I'm regularly backing up an ArcSDE Geodatabase. The backup is done by using arcpy.Copy_management to copy datasets from SDE to a local File GeoDatabase. How can I verify the integrity of the back up ...
1
vote
0answers
14 views

Using REST Services acquiring limited data from DataBase like LayerDefinition

I am working with ArcGIS Server 10.2 and MS SQL DB. I have a requirement in which i need to retrieve limited data using a query from a bulk data using the same Map Service REST URL which can give me ...
1
vote
0answers
36 views

get the ogr_SDE.dll from the MapServer

can please some one give help to get the ogr_SDE.dll from http://www.maptools.org/ms4w/index.phtml?page=home.html I will connect the ArcSDE to my QGis, like that intruction ...
1
vote
0answers
17 views

Geodatabase is registered with the server; new feature class is not [closed]

I have an SDE geodatabase with several feature datasets. The geodatabase is registered with the server, and I can publish services without copying the data to the server. I added a new feature ...
1
vote
0answers
34 views

Can SDEMON command be used on ArcGIS Desktop?

Working on ArcSDE I need to use SDEMON to monitor or stop users, so that I can do my updates. Can SDEMON command be used on ArcGIS 10.2 for Desktop?
1
vote
1answer
35 views

Can't recreate missing address locators

My organization uses several address locators stored in SDE. The server license was recently updated, and shortly after, some of these locators simply disappeared -- they are no longer visible or ...
1
vote
1answer
70 views

Using update mode with the SDE30 writer in FME

I'm recieving the following error when performing an Update operation against a table in ArcSDE using the FME 2011 and the SDE30 writer. Error retrieving dbtune keyword list:SDE_ERROR_CODE(-66) ...
1
vote
1answer
49 views

Associating 9.3 geodatabase domains to a SDE feature class' field in ArcCatalog 10.1 fails

I have succesfully created Domains into a 9.3 geodatabase based on Oracle (SDE) by using ArcCatalog (ArcGIS 10.1). Proof: If I open the table GDB_DOMAINS in Oracle the new domains are listed. ...
1
vote
0answers
52 views

'OutofMemoryException' whilst data trasnfer

I have a process in which data is transferred from PGDB to SDE GDB, recently I have encountered error - 'OutofMemoryException' and the process stops. I have noticed this error while trying to transfer ...
1
vote
0answers
27 views

How to reduce MSSQL Logfile size?

First of all I am not a Database specialist. I am using MSSQL to store my SDE 9.3 Data which is served with AGS 10.0. I have Vector and raster data stored in the databases and have very little room ...