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
47 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
80 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
256 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
2answers
185 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
2answers
920 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
323 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
180 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
389 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
1answer
298 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
179 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
428 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
516 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
340 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
250 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
480 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
699 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
704 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
491 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
40 views

Replacing layer ArcSDE connection

I am very new to using Python... I have an MXD with all of my layer files in it. They are grouped by category etc. Each layer file references a dataset within my SDE. My SDE has two different ...
2
votes
2answers
54 views

how to create a new ArcSDE Service?

I need to create a new sde service with the command line for the first time with mssql on ArcGIS Server 10.0 so that 3rd party software can access it. Direct connect will not work unfortunately. As ...
2
votes
1answer
84 views

Remove/Hide SHAPE.STArea() & SHAP.STLength() fields

Is there a way to hide SHAPE.STArea() & SHAP.STLength() fields in feature classes in an SDE GDB? I'm working with a client who says that these fields were not in any feature class in the GDB and ...
2
votes
1answer
86 views

Problem loading tif into raster dataset in ArcSDE 10.2

I have over 1000 raster datasets I need to mosaic into ArcSDE 10.2. I can't use a mosaic dataset because the county I am working for wants to keep the files on an external HD, so the pointers won't ...
2
votes
1answer
64 views

What is the best way to update a production ArcSDE database from staging?

We have development, staging and production instances of the same ArcSDE database, similar to this ancient thread. Our development to staging deployment employs lots of schema changes with exclusive ...
2
votes
2answers
134 views

Where to store Raster data?

I will soon have to plan where and how our raster data will be stored as we will be upgrading from ArcGIS 10.0 to ArcGIS 10.2. The following questions first need to be addressed before I can make any ...
2
votes
1answer
159 views

Changes not persisting in ArcGIS server from ArcPy script

I have a ArcPy script (10.2) which connects to an ArcGIS server (10.0) versioned geodatabase, via an .sde connection file in the Database connections directory through direct connect on a Microsoft ...
2
votes
1answer
241 views

using arcpy to get all database names within a server?

I am trying to populate a folder with ArcSDE database connection files for all the databases within a server instance. I need to be able to do this for several of our servers. Although I know within ...
2
votes
2answers
266 views

Get Coded Value Domains from a Oracle geodatabase using PLSQL

i'm trying to get all coded value domains from a Oracle geodatabase. I dont have access to arcmap. I only have access to oracle 10g database. SELECT I.NAME Domain, ...
2
votes
1answer
266 views

RuntimeError: Field is not editable when using InsertCursor on ArcSDE geodatabase with ArcFM installed?

We are running ArcGIS Desktop 10.1 SP1, and also have ArcFM installed. I have this simple code: workspace = "C:\\my.sde" arcpy.env.workspace = workspace edit = arcpy.da.Editor(arcpy.env.workspace) ...
2
votes
1answer
112 views

How to clear spatial reference identifier?

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. My table creation statement is: create table ...
2
votes
2answers
516 views

How to copy selected features from one sde feature class to another with different attributes using Arcpy?

I am new to Arcpy scripting, I need help on copying the features to SDE feature class. My Scenario: We have 2 Geo databases running on Oracle 11g ArcSDE 10.2 . I have been asked to write the python ...
2
votes
1answer
61 views

For loop within SDE

I have a list of SDE connection files in a folder in my computer. I can use arcpy.listWorkspaces("*", "SDE") to find the workspaces. But I then want to dig deeper into each of the SDE files and list ...
2
votes
1answer
73 views

How to stop transfer of large raster into arcsde geodatabase

I have just realised that I will not have enough space on my harddrive to accomodate a raster which is being copied into an arcsde geodatadatabase. I am afraid, that if I stop the process in ...
2
votes
1answer
631 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
1answer
359 views

gdal_translate produces tif with different colors as original

I am using SDE as my raster data source with the ultimate goal to tile this dataset: I am running the following gdal_translate command to generate the initial VRT: gdal_translate -projwin 390605 ...
2
votes
1answer
283 views

How to write an SQL query to select recently edited features with Editor Tracking enabled?

Conditions: ArcGIS for Desktop 10.2 and ArcSDE 10.1 Is there a way to select recently edited features using the automatically populated fields that Editor Tracking uses? The new Editor Tracking ...
2
votes
1answer
607 views

ArcGIS 10.0 get sde information out of .mxd

The overall goal here is to iterate through several directories of .mxd files and document which SQL Server instance of SDE they are pointing to, with the database name and feature class names. All ...
2
votes
3answers
2k views

ArcSDE 10: How to read/write to Oracle with ST_GEOMETRY using Java

I found the following in the deprecation plan of ArcGIS 10.2: ArcGIS 10.2 will be the last major release to support the ArcSDE SDK with the ArcSDE C and Java APIs. Today many other options are ...
2
votes
2answers
620 views

How to Register a Spatial View when ArcSDE is direct connect only?

I have an ArcSDE 10.0 set up with MS SQL 2008 R2 Database, on direct connect. There is no service running, nor installed. I have created a spatial view built on a couple of tables. I have followed ...
2
votes
2answers
589 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 ...
2
votes
1answer
484 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 ...
2
votes
1answer
170 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 ...
2
votes
1answer
196 views

Join feature classes from two ArcSDE geodatabases with same schema?

I am working with two ArcSDE geodatabases -- one for test, one for production. They both have the same schema. I recalculated an attribute in the test environment and wanted to push that to ...
2
votes
1answer
332 views

Why does Updating Location of ArcSDE Feature using ArcObjects .NET give Error HRESULT E_FAIL has been returned from call to COM component?

I have been able to connect to an Enterprise GeoDatabase, retrieve features from it and update attributes. However I am having problems accessing and then updating the shape property of a feature. ...
2
votes
2answers
328 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
2k views

ArcGIS 10 querying Oracle 10g without SDE

I'm interested to see if anyone has successfully got this setup working, and if so how many sacrifices were required and to which deities. I am hoping to ultimately get ArcGIS Server 10 serving map ...
2
votes
2answers
639 views

ArcSDE: Specifying fields to not allow null values

I have a feature class in SDE that has various fields where the setting AllowNulls is set to FALSE. When creating a feature in ArcMap in this feature class it still allows nulls to be specified in ...
2
votes
1answer
1k views

Creating ArcSDE feature class in MS SQL Server?

Unfortunately I am totally dumb when it comes to programming, and very new to databases (mainly because I studied geography), so : I have a Microsoft SQL Database Server, and a ArcSDE geodatabase. I ...
2
votes
1answer
462 views

validate SDE features within arcObjects (cant use sdeLayer)

I'm trying to sweep through a feature class checking for invalid features (and log the invalid features). Would IValidation.Validate work or does that just check for rules? If not I'm guessing I ...
2
votes
1answer
1k views

Using of esriFieldTypeDate field in Add Features REST service?

I need to use Add Features REST service to add a new record to a table in an ArcSDE geodatabase. One of the field is type of esriFieldTypeDate, but I don't know how to populate this field in JSON ...