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
0answers
21 views

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

ESRI has informed 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 ArcGISonline ...
1
vote
0answers
22 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?
1
vote
1answer
46 views

Bulk insert with Python and cx_Oracle into st_geometry enabled table

I'm trying to make a bulk insert of a CSV file with Python and cx_Oracle into an st_geometry enabled table of an Oracle database with ArcSDE. I could do it with the method execute() of cx_Oracle but ...
3
votes
2answers
45 views

How to get size of SDE geodatabase feature class

Is there a way in catalog or arcpy to determine the amount of hard drive space a SDE feature class takes up on disk? In catalog the 'size' column is blank and Esri help states: The size, ...
3
votes
0answers
49 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 ...
0
votes
0answers
14 views

Geoprocessing service error [duplicate]

I'm working on a project and I faced an issue regarding publish a geoprocessing service and use it in a javascript API. I created a simple model that includes a near geoprocessing tool with a point ...
1
vote
1answer
77 views

Where to download ArcSDE?

I have ArcSDE for SQL Server 2008 R2. I want to install ArcSDE for another version of SQL Server. I want to download the ArcSDE software but I cannot find it in search. Where can I find it?
0
votes
0answers
35 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
0
votes
0answers
30 views

Unable to create multiversion view in ArcSDE 10.2 and Oracle 11g

I couldnt create a multiversion view using 10.2. I registered feature dataset as versioned, it created MV view for one class but didnt create the MV view for the other one. Even I tried creating the ...
0
votes
1answer
48 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, ...
1
vote
2answers
125 views

Why do I have various *.sde files on my server?

I have an old pc at work which has been used to serve a large aerial Photo. I can only imagine that this was done due to lack of space. I have now found 5 other sde files on the server. I have no idea ...
1
vote
1answer
29 views

Can't recreate missing address locators

My organization uses several address locators stored in SDE. The server license was recently updated, and shortly after, some of these locators simply disappeared -- they are no longer visible or ...
0
votes
0answers
22 views

How to correctly uncompress and re-compress an msd file using 7zip from command line

I am trying to uncompress and recompress both the msd and sd file so as to tweak some things I want. In fact I want to get inside the layers folder and for each layer.xml file to string replace the ...
2
votes
0answers
36 views

Database connection (SDE) failed after database was renamed

I created an enterprise geodatabase in SQL Server 2008 R2 with ArcCatalog (10.2). It was connected via an sde file in ArcCatalog then. Then I had to rename the database from SQL Server Management ...
1
vote
1answer
39 views

Using update mode with the SDE30 writer in FME

I'm recieving the following error when performing an Update operation against a table in ArcSDE using the FME 2011 and the SDE30 writer. Error retrieving dbtune keyword list:SDE_ERROR_CODE(-66) ...
3
votes
1answer
37 views

FME Dynamic schema error - Features With No Schema defined

I'm trying to update a column in an ArcSDE table using the sde30 reader/writers. Keep getting an error: Features With No Schema defined and no features are updated. Scrolling up there is a ...
0
votes
0answers
22 views

How to create a simple Web-Application using ArcGIS-Server? [duplicate]

my organizsation uses ArcGIS Server to serve geodata stored in MSSQL with an SDE. There are many departments that use the web clients to view information, but there are no web applications that allow ...
2
votes
2answers
86 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
2answers
59 views

Distinguishing between table and FC using arcpy, when exporting from SDE

I'm working on a project where I'm pulling some data out of SDE and putting it into a file geodatabase for a group of people to look at with a custom map. I'm writing a script using the ...
1
vote
1answer
70 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
0answers
48 views

Arcpy cannot connect to SDE on PostgreSQL with 32-bit version

So I've been banging my head against a wall for awhile with this one. I recently setup an SDE database in Postgres, and all seemed good. I am able to connect to it from both ArcMap and ArcCatalog, ...
3
votes
1answer
73 views

Error in creating output … table already registered?

I am afraid I am a complete newbie to GIS and ArcGIS and it has fallen on my shoulders to try and resolve a problem with our ArcGIS installation. Assume I know nothing about GIS or the software ...
1
vote
1answer
30 views

Associating 9.3 geodatabase domains to a SDE feature class' field in ArcCatalog 10.1 fails

I have succesfully created Domains into a 9.3 geodatabase based on Oracle (SDE) by using ArcCatalog (ArcGIS 10.1). Proof: If I open the table GDB_DOMAINS in Oracle the new domains are listed. ...
1
vote
0answers
31 views

'OutofMemoryException' whilst data trasnfer

I have a process in which data is transferred from PGDB to SDE GDB, recently I have encountered error - 'OutofMemoryException' and the process stops. I have noticed this error while trying to transfer ...
1
vote
0answers
22 views

How to reduce MSSQL Logfile size?

First of all I am not a Database specialist. I am using MSSQL to store my SDE 9.3 Data which is served with AGS 10.0. I have Vector and raster data stored in the databases and have very little room ...
0
votes
1answer
34 views

Is there a performance difference between SQL Server 2008 and 2008 R2?

We are currently hosting our ArcSDE geodatabase on SQL Server 2008 SP3. I was wondering if there'd be any type of performance boost if we jumped up to 2008 R2?
2
votes
1answer
179 views

Error with da.UpdateCursor and SDE feature classes

I am making my first attempt at editing an ArcSDE feature class with python through a da.UpdateCursor. I'm essentially taking code I've written for a file geodatabase feature class and applying it to ...
1
vote
1answer
66 views

where is the sequence in Oracle associated with the Objectid field in ArcGIS, and how to manage it?

I am working in ArcGIS 10.1 with non-spatial Oracle tables. These tables have a field named 'objectid' because were created originally for inserting/updating records by using ArcGIS instead, not ...
1
vote
0answers
36 views

Are there naming rules for direct connections from ArcGIS to PostgreSQL?

I don't have problem direct connecting arcgis to postgresql if my database name contains only letters, but when the name contains dashes or underscore e.g:"gisdb-dev", I receive an error when setting ...
1
vote
1answer
56 views

Arcpy ListFeatureClasses in same workspace differs when run from ArcMap VS IDLE

This Works The following python script works when connecting to my dev ArcGIS server, from both the ArcMap python window and the IDLE python GUI/shell running on my dev workstation: import arcpy ...
1
vote
1answer
51 views

Change sde connection parameters with ArcPy

I know you can create a database connection with Arcpy using the CreateDatabaseConnection_management function. I am wondering if anyone knows a way in which to change the parameters of that file. ...
1
vote
0answers
45 views

Why do pgadmin III views show up as empty ArcSDE geodatabase tables in ArcCatalog? [closed]

I have an SDE geodatabase connection set up in a server with data stored in a postgres database. I have successfully created views using pgadmin III but they show up as empty tables in ArcCatalog ...
2
votes
1answer
75 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 ...
1
vote
1answer
38 views

Make FeatureClass that has a FileGeodatabase data source editable?

I wasn't able to find any documentation on this, but is it possible to use the Editor widget in the Esri JS API to edit a FeatureLayer whose data source is that's stored in a FileGeodatabase? I've ...
1
vote
0answers
26 views

My layers are not visible after restart geoserver

I have ArcSDE connection on Geoserver. In order to make geoserver faster I have restarted it. After restarting my published layers (datas) are not visible. When I publish this layer again, geoserver ...
2
votes
2answers
107 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, ...
1
vote
1answer
22 views

Multiple (seperate) Attachment Tables

Is it possible to have multiple attachment tables related to one feature class? The purpose is to only show specific attachments at certain times. We are trying to only show pertinent attached ...
2
votes
1answer
40 views

Moving geodatabase from SQL Server 2008 R2 Express to SQL Server 2012 Enterprise

I am able to successfully move an ArcSDE geodatabase from one SQL Server 2008 R2 Express to another SQL Server of the same version using the restore backup method. Now I tried to move it the same way ...
2
votes
1answer
63 views

How to add ST_GEOMETRY column to an exitsting table that already has X Y columns

I have created and Oracle 11g geospatial geodatabase and have create an arcsde connection. I have been connected using arcmap, as a simple user (not sde or schema-user), who has all the proper rights ...
1
vote
1answer
23 views

Syntax to view permissions on Oracle table

I want to be able to see what permissions have been granted on a specific object in my Oracle geodatabase. What would my script look like? Thank you.
0
votes
2answers
84 views

Integrate geodatabase with other nonspatial databases in oracle 11g using ArcGis for Desktop 10.2

I have an oracle database namely xe which I have spatially enabled. using the Create Enterprise Geodatabase geoprocessing tool. The application I am going to implement has an already created ...
0
votes
0answers
78 views

Error selecting geometry from Oracle DB

I'm trying to select a geometry column as well-known text from a feature class in an Oracle 11g/ArcSDE 10.1 geodatabase. (This is in a Python script using pypyodbc as a driver). This is my SQL: ...
1
vote
2answers
79 views

Create an enterprise geodatabase - Administrator username and password are required

I am trying to create an enterprise geodatabase in oracle 11g, using the create enterprise geodatabase tool in arcmap 10.2. I have properly installed the oracle client needed and I am able to create ...
1
vote
1answer
36 views

Concurrency and lock challenge in Nonversioned editing in ArcMap

I use a non version SQLServer geodatabse with geometry type for spatial data storing.To do so,I have registered all layers in SDE repository and geodatabase and ArcMap shows all layers and edit them ...
2
votes
1answer
88 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
41 views

Using a selection tool will select everything

When I use the Selected Features tool and try to drag a box around a few small items it grabs everything. If i use the edit tool it will correctly select only features that are inside/intersect the ...
3
votes
0answers
75 views

ArcObjects Memory Leak with IWorkspaceEdit?

I have ArcGIS 10.1 installed. I have created a function for copying all of the features from one shapefile to another using IFeatureBuffer, now every time the function when it is called, it takes ...
3
votes
2answers
266 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: ...
2
votes
2answers
55 views

connect ArcGIS server with different instances of oracle database

Is it possible for a development team to have personal oracle database instances, for testing purposes, connected with the same GIS server? In other words I want every user to work with his own data, ...
1
vote
1answer
6 views

Generate Statistics from check-out GDB While performing Check-in

I have created Check-out Replica from the main ArcSDE GDB. I have below questions. How to generate statistics of the edits performed on the check-out GDB, before check-in. for example: i want to have ...