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
311 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
170 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
1answer
291 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
178 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
414 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
512 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
338 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
471 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
698 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
700 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
487 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
28 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
52 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
65 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
62 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
55 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
126 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
134 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
213 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
242 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
104 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
470 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
59 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
69 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
591 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
339 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
271 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
578 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
596 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
556 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
164 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
194 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
320 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
323 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
609 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
452 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 ...
2
votes
1answer
254 views

Is there a way to delete definition querys of multiple layers in ArcMap 9.3.1?

I'm searching for a way to freeze/delete definition queries of several layers at once (instead of doing it manually by opening the properties of each layer). I'm working on a SDE 9.3.1 Geodatabase.
2
votes
3answers
2k views

Trigger on SQL Server 2008 ArcSDE 10 and ArcGIS Server 10

I need to build a sql server db trigger to update a date field with the current date when a record is inserted or updated, I think. I will be using the date field as a way to recognize ...
2
votes
2answers
1k views

ArcPy Changing Spatial Database Connection

hi we have conveyed our some servers which has ArcGIS application and SDE on it to another server and its ip has changed. now when i want to open my .mxd file it tries to connect remote SDE with old ...
2
votes
1answer
520 views

ArcSDE 10 FeatureLayer is read only, FeatureTypes property is null, not sure why

I have a WPF FeatureLayer backed by an ArcSDE feature class that I hope to use for editing. After the layer is done initializing its readOnly property is true, I think that this points to some problem ...
2
votes
1answer
740 views

How to create SDE GDB without post installation?

Is there any way to create a SDE sqlserver2008 geodatabase without : SDE post-installation execution on the server having sde service running on the server and using : execution of some DDL ...
2
votes
4answers
2k views

Table to Table script fails when copying to SDE

Since TBL2SDE no longer exists (we're running a 64-bit server and ArcGIS 10 doesn't include that executable on a 64-bit installation) I've been using the Table to Table script in ArcToolbox to copy ...
2
votes
2answers
521 views

Big IRowBuffer problem

I have a small software that connects to a database (SQLServer) reads a few values and transfers them to a SDE Oracle instance (11g). The problem is: I have over half million records that I need to ...
2
votes
1answer
21 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 ...