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

Filtering a Feature Class in using ArcGISDynamicMapServiceLayer

I'm using the following code in Flex to display all the features in a Feature Class defined in the "Data Layer". var dataLayer:ArcGISDynamicMapServiceLayer= map.getLayer("Data Layers") as ...
1
vote
1answer
165 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 ...
8
votes
2answers
2k views

How can I more efficiently select related records?

Below is the code I'm using to replicate the "related tables" button in ArcMap. In ArcMap that button selects features in one feature class or table based on the selection of features in another ...
2
votes
0answers
41 views

Is it possible to re-point operational layers ArcGIS Mobile projects v.3.0

We have an ArcGIS mobile project with two operational layers for data collection. The layers source from a GIS server on the cloud, running on top of an SDE. The database has a feature dataset, and ...
1
vote
0answers
122 views

Extract an ArcSDE datasets (rasters/shape files) using python?

I would like to write a python script to extract/export a dataset (rasters/shape files) in ArcSDE. I saw this posts to connect to the server: Define Workspace for SDE Connection in Python But how ...
6
votes
2answers
602 views

How to Export a Personal Geodatabase to ArcSDE

I want to copy/export my personal geodatabase which consists of feature datasets, relationship class etc to an Enterprise geodatabase. What would be the best approach?
0
votes
0answers
455 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 ...
1
vote
2answers
187 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
0answers
174 views

How to run SDE view commands in Oracle DB?

I would like to create SDE view to compare two tables in my oracle spatial database. I already prepared the view commands. But I dont know where and how to run this? I unable to run this commands in ...
3
votes
2answers
269 views

Running Regular Queries Through ArcSDE

Working on an .net arcobjects app that's connecting to a Geodatabase (Oracle) through ArcSDE. I make a bunch of edits inside a EditSession but the data I am touching have a bunch of foreign Key ...
4
votes
1answer
511 views

Access Metadata from ArcSDE-tables using python

Is it possible to access the metadata of a feature class in a ArcSDE-data, using arcpy / python (on Arcgis 10.0). I suppose I could export the metadata to xml and parse the xml, but is there a more ...
3
votes
0answers
1k views

Error opening feature class from SDE (which can be opened in another application)

We're using ArcGis 10.1 with ArcSDE 9.3.1 on Oracle 10g. I've got 2 layers that cannot be opened or modified with ArcCatalog or ArcMap (but they show up in the list. Everything worked just fine ...
3
votes
1answer
106 views

Are there any publicly available ArcSDE Servers I can use for developing client applications

I have been asked by our client if I can add the ability to connect to instances of ArcSDE servers from our desktop application. I am sure that we can do this a number of different ways, what I was ...
0
votes
1answer
102 views

Open source vs Proprietary [duplicate]

Possible Duplicate: What are the FOSS equivalents to these ArcGIS products? 'm especially interested in Open Source vs Proprietary decisions. Can any of the open source software for ...
3
votes
2answers
1k views

ST_Geometry vs SDE Binary: seeking recommendations, experiences

I've got some questions I've collected as we try to come to a decision about whether to use ST_Geometry or SDE native geometry for an Oracle/SDE datastore on a new project. The organization has quite ...
5
votes
0answers
204 views

Why do file geodatabase and SDE readers produce different fme_geometry types?

I have one very simple workbench that I am running against both SDE (9.3) and FGDB (10.0) sources. I noticed two different fme_geometry values for same type of objects. For the first one, i.e SDE ...
7
votes
1answer
199 views

What is the overall architecture of ArcSDE, and how does it fit into the enterprise?

I'm finding many gaps in my understanding of ArcSDE, particularly as it relates to Oracle. I just can't quite wrap my brain around the overall architecture of it, and how it fits into an enterprise. ...
5
votes
3answers
307 views

Updates to ArcSDE via Oracle trigger

Is it possible and/or feasible for an Oracle trigger to periodically update ArcSDE via a REST geoprocessing service? Does anyone have any experience with such a thing? The reason for this is that I ...
3
votes
1answer
207 views

Is it possible to add 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 ...
7
votes
2answers
216 views

ArcSDE : Cascading Subtypes in ArcGIS 10/SQL Server

I'm currently creating an ArcSDE DB on an SQL Server. It is designed to complete species survey, with information from the field. In order to help themselves, they asked me to implement a particular ...
3
votes
3answers
311 views

How to create feature dataset by pgAdmin(postgres) that can by use in sde conection?

How to create feature dateset in postgres(pgAdmin) that can by use in sde conection (arcgis)?
5
votes
1answer
183 views

Why Can't ArcPy Search the Newly Created Feature

I'm running the following tool in ArcGIS 10. I have an ArcPy Script like this: import arcpy from arcpy import env env.workspace=r"C:/sde/lcimrl.sde" fc="SDE.ATTACHMENTS\SDE.attachment_points" fcRows ...
2
votes
2answers
572 views

Can we use procedures in a Query layer (ArcGIS Desktop 10.1 & Server 10.1)?

I have one basic question that.. Can we use procedures in Query layer (ArcGIS Desktop 10.1)?? Currently I am using query layer for ArcGIS Desktop 10.1 and its working fine . My DBA person told me ...
0
votes
1answer
607 views

Where to execute sdetable command in Windows?

I am trying to fire some Sde Command in Arcgis Desktop 10.1 but I am not aware where to execute the command in windows operating system.Thank you in advance.
2
votes
1answer
743 views

How to auto-create a schema.ini file for a .csv?

I have been given some data in a csv file, which I need to import into my ArcSDE geodatabase. ArcGIS is having problems recognizing the field types, and is not importing some data. It is recognizing ...
4
votes
1answer
183 views

Installing ArcSDE engine plugin for Eclipse?

I'm looking for the following jars for the ArcSDE API: jsde_sdk.jar jpe_sdk.jar concurrent.jar icu4_3_2.jar thanks to this answer I've found that they can be gotten installing the ArcSDE engine ...
6
votes
2answers
473 views

Understanding Geodatabase Archiving and H tables in ArcSDE?

We have ArcSDE 10.0 on MSSQL 2008 with Geodatabase archiving enabled. In the process of updating a topology I deleted the topology, disabled archiving, unregistered as versioned and then recreated ...
4
votes
2answers
1k views

Where can I get jsde_sdk.jar for ArcSDE 10?

I had an environment working with no problems, with Geonetwork harvesting metadata from ArcSDE 9.3. It was done trhu the following libraries, copied from the ArcSDE installation to the Geonerwork lib ...
3
votes
1answer
164 views

Enabling ArcSDE Archiving with Python and C API using ArcGIS 10.0?

I have a script that does some register as versioned and updating privileges. How would I call into the c api for ArcSDE to enable archiving with python? ...
4
votes
1answer
484 views

How to register a Stored Procedure in ArcSDE?

I just registered a SQL Server view with ArcSDE through sdetable -o register [...]. I wonder, how to register a SQL Server stored procedure with ArcSDE? Is it the same process as the view? EDIT ...
5
votes
1answer
1k views

ARCMAP ERROR 000464: Cannot get exclusive schema lock

I am trying to run the "Near" tool in Arcmap. Both my layers involved are on a SDE database. When I run the tool I get the following error... ERROR 000464: Cannot get exclusive schema lock. ...
1
vote
1answer
203 views

How to update a value in an ArcSde table using ArcMap's VBA

First of all, I want to update a table, not a feature class (no geographical information). I tried the following Public Sub updateInSql(tableName As String, whereClause As String, field As String, ...
2
votes
1answer
399 views

Create dynamically multiple layers in ArcGIS Server 10.1

I am using ArcGIS Server 10.1 and Desktop 10.1 software. I am publishing table from sqlserver to the ArcGIS server, that table (from sqlserver) is updating hourly, and the types are increasing. I ...
5
votes
1answer
349 views

Can you synchronize tables between ArcSDE(MSSQL) and PostgreSQL(PostGIS) regularly?

I have spatial tables in ArcSDE 10.1 (MSSQL 2008 R2) geodatabases and need to update the same spatial tables in PostgreSQL 9.1(PostGIS 2.0.1) geodatabases. Basically I use my ArcSDE environment for ...
3
votes
2answers
144 views

Why I see different data from PostGIS and ArcSDE

I have installed ArcSDE 10 on PostgreSQL 8.4.3 with PostGIS 1.4.2. I did some tests. I imported one feature layer with 8500 features into ArcSDE through ArcCatalog. and I deleted 8499 features in ...
1
vote
1answer
126 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 ...
4
votes
1answer
204 views

Using xml workspace to overwrite geodatabase in ArcGIS Server 10 with ArcSDE for SQL Server?

I want to transfer a geodatabase from my development server to my client's production server. We are using SQL Server, but in different versions. Hence I cannot use Backup/restore or detach/attach. ...
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
3answers
215 views

Arcsde - FME - import data

I have a problem with the import of data with FME 2012 and ArcSDE 10. After import, my data are not visibles in ArcMap or ArcCatalog. My layers are registered in ArcSDE. I found a solution: After ...
8
votes
1answer
342 views

How to apply schema changes on Esri geodatabase two-way replica set?

I have an Esri geodatabase two-way replica set. I need to update the schema on both databases in the replica set. Esri describes doing this using ArcGIS schema tools (compare/export/import replica ...
3
votes
2answers
333 views

Is it possible to load features into ArcSDE without using ArcObjects?

I have a SDE geodatabase in MS SQL Server, where geometries are stored in MS SQL's native geometry types, rather than the ArcSDE Binary. It seems like it would be relatively easy to create new ...
2
votes
0answers
880 views

What is fastest way to copy feature dataset from ArcSDE to File Geodatabase in ModelBuilder?

What geoprocessing tool is the fastest for copying feature datasets from SDE to fgdb? I want to make a model in ModelBuilder that copies an entire featuredataset from my SDE database to a file ...
8
votes
4answers
1k views

How to identify “true arcs” in Arcmap?

This is really annoying: the only good way of creating circles in ArcMap is using true arc, (compound curves) but I need to convert those to vertex (densifying) because of a compatibility problem. I ...
1
vote
1answer
235 views

Geodata Service in ArcGIS Java script api (3.1)

Can I use Geodata service in ArcGIS JavaScript API 3.1 ??? Background : I have simple map service and the all attribute data is stored in Sql Server database. I want to perform query operation on map ...
1
vote
1answer
211 views

How to replace corrupt representations stored in a geodatabase using symbology from layer file?

I have a lyr file with symbology that I want to store in the database. Symbolology is already stored in the geodatabase but the symbology levels has been corrupted migrating from 9.3 to 10. Thus, I ...
6
votes
3answers
432 views

Help! - ArcSDE is locking our Oracle schemas

We changed a password on an Oracle schema, but apparently we have some rogue SDE clients - probably old ArcGIS map services on a dev machine somewhere - attempting to connect with the old password. ...
21
votes
5answers
14k views

Is ArcSDE no longer needed at ArcGIS 10.1?

Through my frustration of not finding the post-installation wizard with ArcSDE 10.1 and being unsuccessful with the command line tool to start an SDE service on our SDE databases, I found I was able ...
6
votes
2answers
1k views

Autonumbering fields in versioned ArcSDE Geodatabase?

I want to have a field with autonumbering in ArcGIS. I have a versioned ArcSDE for SQL Server geodatabase. Thus, using the identity seed attribute in the SQL Server is not an option. Is it not ...
1
vote
0answers
177 views

Best practice for loading shapefiles into ArcSDE geodatabase using web application

We are developing a web GIS using Flexviewer and we want to allow users to upload a shp file and insert it into a ArcSDE geodatabase. I think there are two steps at least. upload the shp file (zip) ...
0
votes
1answer
980 views

arcpy - how to run geoprocessing python script on SDE

I was testing my script on a .gdb on my local drive and I got it to work. The actual geodatabase I would like to run the script on is an SDE. I tried changing my filepath from the .gdb to the .sde and ...