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)

2
votes
1answer
344 views

Is ArcSDE available with ArcGIS Desktop license?

I have ArcGIS Desktop with the ArcInfo license level. I want to know if I can configure ArcSDE, so that I can work with versioning of geodatabases? The ArcInfo license level is now known as the ...
2
votes
2answers
313 views

Short name for SDE featureclass?

Is there an ArcObjects function to get a short name version of an SDE featureclass? For example if my featureclass is: FOOSCHEMA.BARLAYER How do I just get "BARLAYER". Or is it just a simple case ...
2
votes
2answers
2k views

Create ArcSDE Database from ArcCatalog

Is there a way to create a spatial database from ArcCatalog that also creates the ArcSDE user, repository, and service. Basically, I am trying to do everything that the ArcSDE Post Installation does, ...
2
votes
6answers
2k views

How can I connect to a PostGIS database from ArcCatalog 9.3 via ArcSDE?

I have a problem connecting to my postgis database via ArcSDE in Arc Catalog. When i want to establish connection to my database i get an error:
2
votes
3answers
2k views

How do I access versioned spatial data in SDE with SQL queries?

We're running SDE and have several feature sets with versioning turned on. When I query those layers via ArcGIS Engine or ArcGIS Server, all expected features are returned. We have numerous non-GIS ...
2
votes
3answers
511 views

Repair/Check for empty geometry in ArcSDE?

I understand that the standard validation/repair tools are not for use with ArcSDE and that ESRI needs to fix this, but are there work-arounds for at least checking where there might be empty geometry ...
2
votes
2answers
247 views

Differences between ArcSDE 9.3 and 10.0?

I am curious that what is differences between ArcSDE 9.3 and ArcSDE 10? Is there ArcSDE 10 to use it? Or ArcSDE 10 is coming with ArcGIS for Servers? Can anyone explain me? Edit : Another ...
2
votes
1answer
428 views

Cannot upgrade User Schema Geodatabase when Master Schema Geodatabase is at previous release?

I am getting this error when trying to upgrade ArcSDE from 10.0 to 10.1: Cannot upgrade a user schema geodatabase when the master schema geodatabase is at a previous release. The master ...
2
votes
1answer
1k views

Deleting SQL Server database in order to delete ArcSDE geodatabase?

I'm new to this ArcSDE stuff and would like to know the best way to cleanly delete an SQL Server database in order to delete the ArcSDE geodatabase. Is it as easy as right clicking on the database in ...
2
votes
1answer
175 views

Choosing specific ArcSDE version to create replica geodatabase from?

I'm trying to automate the process of exporting a replica geodatabase using the geoprocessing tools and eventually a Python script. I can't figure out how to create the replica from a specific ...
2
votes
2answers
764 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 ...
2
votes
2answers
184 views

Spatial search to find featureclasses in SDE

Is there a way to find all featureclasses within SDE that fall within a spatial search e.g a user draws a rectangle on screen over a map of the world say. (I would like to do this progrmammatically, ...
2
votes
1answer
222 views

Connect to ArcSDE geodatabase over LAN?

I am running ArcGIS Server 10, with ArcSDE 10. I have a geodatabase that I would like my colleague to connect to over the LAN at our office. How do I go about doing this? I would prefer a list of ...
2
votes
1answer
139 views

Converting standard to feature linked annotation?

Is there a way in ArcGIS 10.2.2 & ArcSDE 9.3 to convert standard annotation to feature linked annotation?
2
votes
1answer
171 views

What's the proper way of deleting versioned data from an SDE geodatabase?

I haven't really read this anywhere. What is the proper way of deleting versioned data from an SDE geodatabase to make sure nothing is left behind in the A & D tables? Do I need to unversion the ...
2
votes
1answer
473 views

Installing ArcGIS 10.1 on Win7 64 bit

Just reformatted my PC with Win7 64bit to try and take advantage of 64-bit python processing. However I'm not sure what to do here: Our office runs ArcGIS 10.1, TOAD and SDE for Oracle. Toad ...
2
votes
1answer
349 views

How to register table with geodatabase with a command line?

Is there a way to register with geodatabase a table stored in an Oracle 11g database, without using ArcMap or Python script? I'd like to do it with a command line like when registering with ArcSDE ...
2
votes
2answers
262 views

Change SDE Version in ArcGIS JavaScipt API depending on connected user

I am programming for an web editing application with ArcGIS API for JavaScript. I've published a version of ArcSDE with Feature Acces and I need to know how can I change in the web application from ...
2
votes
3answers
714 views

Update license for enterprise geodatabase with GP/Python?

I am attaching dozens of database files to a SQL Server instance and then I have to run sdesetup command to update the geodatabase license by pointing to my ArcGIS Server license. I am trying to find ...
2
votes
1answer
1k 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 ...
2
votes
1answer
371 views

Using Geodata Service in ArcGIS API for JavaScript?

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 ...
2
votes
3answers
2k views

Is there a way to see the coded value domain list of possible values from arcmap 9.3.1?

Is there a way to see the possible values of a specific coded value domain in arcmap 9.3.1 (I have no access to the SDE which holds all the data in arcCatalog)?
2
votes
1answer
3k views

Web mapping within ASP MVC 3 framework

Just curious if anyone has used the ASP MVC 3 framework for creating web mapping applications. I have one coming up and am planning on using the ArcGIS javascript API. Would be interested in hearing ...
2
votes
2answers
208 views

How to store large amounts of text in an SDE table

I need to store a lot of text in a field in an SDE registered business table (an ITable, not a featureclass) - let's say 10,000 words roughly. I am using Oracle 10g and ArcSDE 9.1. I am programming ...
2
votes
2answers
403 views

Using ArcSDE on an Oracle DB, how can I tell which users have permissions to a Feature Class

I created a new Feature Class, and I assigned some users SELECT privileges to that Feature Class. I want to look at the list of users that I have assigned privileges to, how do I do that? Updated ...
2
votes
2answers
2k views

Restart IIS Admin Service or Recycle Default App Pool?

A weekly maintenance process requires stopping ArcGIS Server and ArcSDE services. After restarting all the services, is it better to restart IIS Admin Service or recycle Default App Pool? I currently ...
2
votes
1answer
48 views

Why might data sources of Current ArcSDE layers vary in way they are listed?

I would be interested to know if someone can tell me why SDE Connection: Layer Data-source shows C:\USER\JOHN_SMITH and not DATABASE CONNECTIONS\**** Back ground is we are going through a migration ...
2
votes
2answers
61 views

How to use IDatabaseConnectionInfo3 Interface ArcObjects!

I try to retrive the connected users from an entreprise geodatabase using ArcObjects . first I tried to cast My workspace to IDatabaseConnectionInfo3 but it throws ClassCastException ...
2
votes
1answer
108 views

problems overwriting files in ArcSDE with python script

I'm having a great deal of difficulty overwriting files when using ArcSDE. The usual 'arcpy.env.overwriteOutput' method doesn't seem to work. When I run this script: import arcpy from arcpy import ...
2
votes
2answers
155 views

FME SDE Writer changing the part sequence of a Multi-part polygon on Insert

I am creating a FME script that will accept to databases (MDB file and SDE Database) and will update the SDE database if there are any changes to the MDB file. I have a CRCCalculator for both SDE and ...
2
votes
1answer
1k views

How to configure ST_GEOMETRY Access for Oracle 64 bit?

I'm trying to configure the Oracle extproc to access the geodatabase with SQL, using the documentation here. This is a Windows 2008 R2 server with 64 bit, and the Oracle server is also 64 bit. I'm ...
2
votes
1answer
485 views

ArcGIS Publisher PMF Version Compatibility

Does anyone know of version compatibility issues of creating a PMF? Or links to that documentation? I have not seen anything from Esri. I have asked Esri Support, and will update with their response. ...
2
votes
1answer
978 views

Convert from Geometry to SDE Binary storage type in SDE database

We have been battling performance issues between SQL 2012 and ArcGIS 10.1. One of the most common solution is to convert to SDE Binary storage. We know that this storage type is not as dynamic as the ...
2
votes
2answers
1k views

How to copy selected features from one sde to another using ArcObjects?

Assuming I have two SDEs or other datasources with the same datamodel. One contains features the other one is empty. In ArcMap I have layers from both datasources in my table of contents. Now I would ...
2
votes
1answer
404 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 ...
2
votes
1answer
225 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 -> ...
2
votes
3answers
469 views

Creating feature dataset by pgAdmin (PostgreSQL) that can be useD in ArcSDE connection?

How to create feature dataset in PostgreSQL (pgAdmin) that can by use in ArcSDE conection (ArcGIS)?
2
votes
2answers
359 views

SDE 10.1 Layers Not Loading in ArcGIS Engine Application

I have an ArcGIS application that works great when loading layers from SDE 10.0 but fails when trying to load the layers when they're pointing to a SDE 10.1 server. The only difference is the layer ...
2
votes
1answer
346 views

Direct DBMS sql queries and ArcSDE geodatabase

i want to make updates from Arcobjects on several tables stored on a ArcSDE 10.1 versionned geodatabase based on Postgresql 9.0.5 , none of these update require spatial data , and making these updates ...
2
votes
1answer
189 views

SQL Plus error using sdeversion

I'm new to SQL Plus and I have a question. I've created several versions of a feature class located on a SDE database. I want to use ArcSDE Administration Commands found here but I'm getting an error ...
2
votes
1answer
499 views

How to run “sdetable register” command in SQL Server?

I was planning to run "sdetable register" command to register a particular field as OID for an non-spatial table already created in a SDE database. I am with SQL Server 2008 R2. I tried to run the ...
2
votes
2answers
545 views

Understanding How ArcGIS Displays Non Spatial Data Created in Microsoft Access

I am working on getting American Community Survey(ACS) data into SDE table format. I have managed to import all the text files downloaded from ACS into excel and then imported to Access for further ...
2
votes
1answer
348 views

Is there an se_toolkit version for ArcSDE 10?

I have the one for 9.3 downloaded--is there a version for ArcSDE 10? So far my 9.3 version of se_toolkit is working against 10 geodatabases, but I've only tried a couple of the tools(sdeping and ...
2
votes
1answer
255 views

Query for Selecting only Selected Fc's from a GDB

I need to version n number of fc's which start with sde."ENT-QA". I need to select only those feature classes and run versioning for it. Can anyone help me in writing the query for selecting only fc's ...
2
votes
1answer
534 views

How to cast SDE table to IFeatureClassLoad

How do you cast an SDE table to IFeatureClassLoad using ArcObjects? I'm getting an error with this attempt below which is not the correct method: Dim pSDEFeatWksp As IFeatureWorkspace = ...
2
votes
3answers
714 views

Definition Query to Python script on Oracle 9i and ArcGIS 9.3.1

SUBTYPECD=1 AND SERIESNAME NOT LIKE '%-%' AND OPERATIONALSTATUS IS NULL OR SUBTYPECD=1 AND SERIESNAME NOT LIKE '%-%' AND OPERATIONALSTATUS = 976 The above is my def query in ArcMap against ArcSDE ...
2
votes
2answers
740 views

How to add a Database Server in Catalog?

I have ArcSDE on an Oracle database and I want to add a database server connection to ArcCatalog, I've seen several sites but they don't say what I have to write down. Let me explain: From the tree ...
2
votes
3answers
1k views

how to configure an arcgis server service to enable multiple editing

I'm using ArcGIS Server 9.3.1, ArcSDE, VS.NET 2008 and I'm trying to enable a service to be edited multiple times, the service its going to be public and it will be used to report emergencies and ...
2
votes
2answers
532 views

Edits in SDE not showing up in AGS GeoData Service

I've got an ArcGIS Server GeoData service against an SDE MSSql database. When changes are made to the source data, the edits don't appear to show up in the GeoData service. If I restart the ...
2
votes
1answer
57 views

Determine if ArcSDE service or direct connect

Does anybody knows if there is the ability to check a layers datasource, if it is an direct connect to a database or if an ArcSDE service is used? For both the esriDataSourcesGDB.SdeWorkspaceFactory ...