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

Using Python to connect to Multiple SDE Database Connections

I am writing a script that accesses multiple sde Database connections. I have set the script to include accessing the environment workspace: import arcpy arcpy.GetParameterAsText(0) ...
0
votes
1answer
11 views

How to upgrade an PostgreSQL 8.3(32-bit)/ArcSDE 10.0 database to PostgreSQL 9.2(64-bit)/ArcGIS 10.2?

I need to upgrade a large production PG8.3(32-bit)/Arc10.0 database with a fair amount of programming (that has circular references) as-is. This is a system that I inherited, so I don't have the ...
1
vote
0answers
13 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
144 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 ...
0
votes
0answers
22 views

Trouble with select by attribute on ArcSDE

I am having trouble with some extracts on a csv table on ArcSDE. Verifying my expression results in the following pop up: "The expression was verified successfully but no records were returned."
-3
votes
0answers
18 views

Why can we use Raster dataset for raster migration in ArcSDE? [on hold]

Why can we use Raster dataset for raster migration in ArcSDE instead of raster catalog.
0
votes
1answer
28 views

SDE connection and multiple schema

I setup an sde connection for Oracle database, where multiple databases are sitting. All databases have same owner, sharing same password but identical user (e.g., BUI, EICU, FRNSW and LPI). While ...
0
votes
0answers
9 views

View Oracle GeoRaster in ArcMap

I have imported SRTM DEM into Oracle 11g using FME.The block size is set to 128X128.I am able to view the data in QGIS,Tatuk and play with it using GDAl command line.Unable to view the same in ArcMap. ...
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 ...
5
votes
3answers
2k views

How to copy an SDE geodatabase to a file geodatabase using Python?

I would like to make an exact copy (domains, feature datasets, feature classes, etc.) of an SDE database to a file geodatabase. I have tried several possibilities, including: using the Copy (Data ...
2
votes
1answer
24 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 ...
1
vote
1answer
145 views

How to create an SQL Persisted Computed Column which values are derived from spatial column

Our GDB is using the SQL native GEOMETRY data storage type (SQL 2012 Standard) and the spatial reference for this uses a unit of square feet. I want to create a (persisted) computed column which will ...
0
votes
0answers
11 views

ArcSDE Compress Issue [closed]

i am facing a problem about compress sde geodatabase. i am using oracle database for sde and create a multi user editing environment. i have deleted all edit versions after reconcile and post and all ...
5
votes
3answers
235 views

How do I retrieve a feature outside of ArcSDE into an IFeature in ArcObjects?

I would like to be able to use Entity Framework with a repository pattern for non-spatial querying of my SDE Sql Server database. I was hoping to reverse code-first engineer the database with the ...
0
votes
0answers
13 views

Start Editing Return Unspecified error (Exception from HRESULT: 0x80004005 (E_FAIL))

I'm using IEngineEditor.StartEditing method to start an edit session on SDE Workspace. My workspace is having a right value because I have no problem to get a feature class using it. I'm not sure ...
8
votes
4answers
2k views

Python script - how to avoid exclusive schema lock error?

I have a script for updating some features on my database every night (just for copying and replacing some features). This features are "read-only". My problem is that I can't avoid that these ...
2
votes
2answers
21 views

replaceDataSource for Tables from one SDE server to another server

I found the code that works to change the layers in my mxd from one SDE workspace to the other SDE worksspace. The script runs, but does not change the tables to the new SDE workspace. I replaced lyr ...
2
votes
2answers
121 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 ...
0
votes
2answers
47 views

ArcSDE Locks With No Owner

Running enterprise SDE on Sql Server 2008, ArcGIS 10.1, SP1. The issue is old locks on all feature classes within a specific feature dataset that aren't being released. When viewed with an admin ...
1
vote
0answers
19 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 ...
7
votes
3answers
3k views

Is there automated way of releasing all ArcSDE layers locks?

We have an issue where users do not close ArcGIS and layers get locked, and sometimes this affects our nightly updates for some of the layers. I know you can individually remove a lock using the ...
1
vote
0answers
35 views

Upgrade Geodatabase crashes python and ArcCatalog

We are currently in the process of upgrading our ArcGIS for Server license (10.0 to 10.2.2) and our SQL Server instance from 2008 (SQL Express) to 2012 (Full blown). We have around 60 databases to ...
4
votes
1answer
813 views

Editing ArcSDE table with ArcObjects?

The link below provides a code snippet for editing an ArcSDE table with ArcObjects. Are there any other or newer code examples out there of how to edit an ArcSDE table by using ArcObjects? Edit ...
0
votes
1answer
32 views

Connecting to ArcSDE with arcpy is slow (ArcSDESQLExecute)

I'm creating an API which will allow queries to be performed on my GeoDatabase. I'm using ArcSDESQLExecute to connect to ArcSDE (backed with an Oracle database). Creating the connection object is very ...
1
vote
1answer
245 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 ...
3
votes
3answers
355 views

How to connect QGIS to an Oracle DB (SDE)?

I want to access an Oracle Database (with SDE) from Qgis 2.4. I have tried many different options from within the window Create a new Oracle Connection but I always get an error message (ORA-12514: ...
0
votes
2answers
338 views

Cannot register a Feature dataset

I am having an issue trying to register a dataset, and being able to edit a featureclass within it. I am new to SDE so please bear with my explanation. I read online you cannot register a feature ...
0
votes
1answer
257 views

Not able to register spatial view with sde

I am using 10.2 ArcGIS and SOL Server 2008 R2. I have created a cross database spatial view in sql server using following syntax: USE [pipelines] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON ...
2
votes
1answer
42 views

Edit default version table view using SQL Server

I have a ArcSDE (10.3) geodatabase setup which is versioned as we have a few people working concurrently on the data. However, I want to run some background scripts in SQL Server to update the default ...
1
vote
0answers
14 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 ...
0
votes
2answers
54 views

What does the srid code mean in an sde.st_geometry?

In case of an sql insert query like : INSERT INTO OUTBREAKS (OID, address, city_code, loc) VALUES (1, '1420 kirchestrasse', 43, sde.st_geometry (0.00003, 0.00051, null, null, 4326) ...
3
votes
0answers
32 views

Any way to append data to SDE database while it is still versioned?

My group works on a database and about once a month I receive data that must be appended. This process has required me to reconcile and post all versions to default. I then pull down the database ...
3
votes
1answer
307 views

ArcSDE - How to edit mosaic dataset

I have a mosaic dataset (Raster) in an SDE database. As expected, when I click start editing, ArcMap says that I have to do "Register as Versioned" before, but I can't have a mosaic dataset in a ...
5
votes
5answers
2k views

Can I copy an entire geodatabase with relationship classes and domains and reproject all feature classes from wgs84 to state plane?

I have an SDE geodatabase with several feature classes, tables, relationship classes, and domains. All the feature classes are currently in WGS84 coordinate system. I need an exact copy of the ...
7
votes
3answers
1k views

Permanently replace/update server/service in each ArcSDE Layer in MXD?

Using the mxd.findAndReplaceWorkspacePaths method, if and MXD is updated and the path the the .sde connection file moves again all of the data sources will break again. Is there a method to ...
3
votes
0answers
99 views

Changing workspace path of query layer using ArcPy?

I'm trying to change the workspace path of a query layer using the code below and it always breaks. The layer is connected to a view in an Oracle Spatial 10g database. The database is SDE enabled ...
2
votes
1answer
72 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 ...
1
vote
0answers
58 views

ArcGIS Error 999999: Feature Compare Tool

I'm running the ArcGIS feature compare tool against 2 point feature class layers. I'm comparing 9.1 SDE layer against a 10.1 SDE layer. In the feature compare tool one of the input options is ...
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 ...
1
vote
1answer
249 views

ArcGIS 10.1 SDE database schema other than SDE or DBO

Just wondering if it's possible to apply a schema other than SDE or DBO to SDE feature or raster tables stored in an enterprise database on MS SQL Server 2008 R2. I have got a new customise schema ...
-1
votes
2answers
235 views

How to learn ArcGIS Server? [closed]

I have SQL Server, ArcGIS Server Standard Enterprise 10.0 - and I am new to both. How can I learn to use it. I want to learn ArcSDE but i am unable to understand it. Is ArcSDE available with ArcGIS ...
0
votes
0answers
21 views

How to …NonRelational geoDB to Relational geoDB

I have Access personal database without any relations and would like to import all data in SQL using ARCSDE Personal and build relations. This is bad structured database and I just couldn't figure out ...
3
votes
2answers
84 views

Creating a weekly FGDB backup of ArcSDE?

I need to create a script that will copy our county's parcel data, maintained in SDE/SQL, to a file geodatabase. This script will be run as a scheduled task over the weekend. What GP tool do you ...
2
votes
1answer
70 views

How can I create custom offline maps for Collector on an ipad without SDE?

ESRI has informed me that you can only create custom offline maps for collector units if you have an SDE set up with your GIS server. They said SDE is the only way to publish maps up to the ...
0
votes
1answer
40 views

How to make connection

How to connect a argis, sde version through stand alone python script. SDE.Mapping is child version of SDE.Default and I want to make child version of SDE.Mapping . I am using direct sde services
1
vote
0answers
29 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?
0
votes
1answer
55 views

Precision loss when trying to select the latitude and logitude coordinates from an sde.ST_GEOMETRY using SDE.STX() and SDE.STY() functions

In an oracle 11g enterprise geodatabase I am trying the following: INSERT INTO MySTATION (STATION_ID, DB_VERSION_NU, CREATED_DT, MOD_DT, SHAPE) VALUES (1, 0, sysdate, sysdate, ...
2
votes
2answers
1k views

Do I need to install ArcSDE?

I've successfully installed ArcSDE and ArcGIS for Server for 10.1. I'm running SQL Server 2012 on a Windows 2012 Server x64 machine. I'm able to direct connect to the SDE geodatabase and version the ...
3
votes
3answers
243 views

Is there any way to write a snipet of code with function of “SDELayer -o register” command

I try to create a geodatabase using some SQL command and then register some tables of it with SDE. I create an empty geodatabase using sde post installation and then create tables and other database ...
3
votes
1answer
498 views

Spatial Database Connection String

From MS Access, I'd like to create a link to the attribute table of an SDE feature class in a spatial database. For example, I have the following connection string which works for an OLE DB ...