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)

3
votes
0answers
62 views

Save edits before disconnecting users from enterprise geodatabase?

Is there any method that enables the Administrator to save the users edits before disconnecting them for an enterprise geodatabase. Because I am disconnecting users as shown in the screenshot, but ...
3
votes
0answers
84 views

Any way to speed up an append of 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
0answers
692 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 ...
3
votes
1answer
212 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 ...
3
votes
0answers
397 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
0answers
126 views

Pulling ArcSDE feature classes from current map to fieldmapping as DETable?

I'm working with SDE layers in arcmap. trying to avoid pointing to the sde file itself. I've tried workspace.Pathname, it was empty for sde remote workspace. I've also tried IName from workspace, ...
3
votes
0answers
171 views

Which edition of ArcGIS for Server and which capacity level?

I need to define the edition of ArcGIS for Server product to invest for a small scale oil & gas company. What we need is to be able to: Work on a geodatabase with 2-3 concurrent desktop users ...
3
votes
3answers
176 views

Preparations for a transition to ArcSDE [closed]

So I'm a GIS Intern for a city government, we are preparing to purchase ArcSDE and implement it to our current GIS setup. I'm curious as to what should be done before it is purchased. Our GIS consists ...
3
votes
0answers
158 views

What are the pros/cons of using an MSSQL SDE Database rather than a File-gdb in ArcGIS Server

I have taken over an ArcSDE 9.3 Enterprise database setup which has around 80% of it´s vector data in an MSSQL SDE Database system and 20% in FileGDB on the application server. I am trying to ...
3
votes
0answers
115 views

New SQL Monitor Showing Database Deadlocks, Should I be alarmed?

We recently installed a SQL Monitoring tool that is raising High Alerts for SQL Server Deadlocks on my SDE database at random times during the day. Using the information provided in the Alert I have ...
3
votes
0answers
589 views

ArcGIS 10.1 & SQL Server 2012

We currently updated to SQL Server 2012 and now we are encountering a slower performance when connecting to the geodatabase on SQL Server 2012. Here are the things that we tried to fix the issue: - ...
3
votes
0answers
2k views

Error opening feature class from SDE (which can be opened in another application)

We're using ArcGis 10.1 with ArcSDE 9.3.1 on Oracle 10g. I've got 2 layers that cannot be opened or modified with ArcCatalog or ArcMap (but they show up in the list. Everything worked just fine ...
3
votes
1answer
229 views

Enabling ArcSDE Archiving with Python and C API using ArcGIS 10.0?

I have a script that does some register as versioned and updating privileges. How would I call into the c api for ArcSDE to enable archiving with python? ...
3
votes
0answers
484 views

Create ESRI ArcSDE Connection File (.sde) using Python/ArcPy at the ArcView license level?

Is there an alternative way to create ArcSDE connections in ArcGIS 10.0 using Python at the ArcView license level? I need to create 4 separate connection files for a MXD SDE data source re-point tool. ...
3
votes
0answers
203 views

ArcSDE Database Refactoring Tools?

We are using liquibase as evolutionary DB change management tool in our applications, it works great when we use it in "common" database schemas. But we also work with GIS applications using esri ...
3
votes
0answers
745 views

How to get WKT from SHAPE column in the ArcSDE geodatabase?

I have an ArcSDE geodatabase running on top of SQL Server 2008. A table for a feature layer was added from ArcCatalog. The SHAPE column is a type of int which was automatically converted from ...
3
votes
0answers
314 views

Cartographic Representations Load Rather Than Feature Symbology [closed]

We use ArcSDE to allow multiple users (both in my office and elsewhere) to access feature classes that my office maintains. We also use cartographic representations for many of our feature classes. ...
3
votes
3answers
252 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 ...
2
votes
2answers
1k views

Connecting Desktop to SQL Server 2012 SP1 via ArcGIS Server 10.1 very slow?

We have just built and new ArcGIS/ArcSDE system with SQL Server 2012 SP1. We are experiencing very long periods (up to 2 minutes) just to connect to the database in Desktop. Desktop does connect and ...
2
votes
1answer
529 views

ArcSDE performance and table changes on upgrade from 9.3 to 10.1?

I'm using ArcSDE 9.3 and SQL Server 2008 R2 and I want to migrate from ArcSDE 9.3 to ArcSDE 10.1. Is there any performance differences between ArcSDE 10.1 and ArcSDE 9.3 ? Is there any change ...
2
votes
2answers
3k views

Formatting SQL queries for use in Arcpy?

I have to make an SQL query on a column having not adequat name "type_borne_id", I couldn't make SQL queries using arcpy.Select_analysis neither selectbyattribute, but when I use select_analysis ...
2
votes
1answer
306 views

How can I change my ArcSDE binary formatted data to MSSQL Geography or Geometry data types?

We are currently using ArcSDE 9.3 to store our Geodata. In a project which is currently being implemented, the software being used can access most data formats including the ArcSDE binary format ...
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
2answers
195 views

Creating spatial view from materialized view?

I have a materialized view that runs nightly and performs an intersection of point locations and polygons. The materialized view works as designed and returns the desired results. It contains ...
2
votes
2answers
2k 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 ...
2
votes
1answer
349 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
314 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
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
1answer
520 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
2k 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
189 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
795 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
186 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
3answers
2k views

Is it possible to import an autocad feature to a feature layer without exporting to .shp/.dwg

Does anyone know if it is possible to import a feature (point, line or polygon) drawn in Autocad directly to a feature layer in ArcMap, so in essence a "feature sucker", rather then exporting the ...
2
votes
1answer
224 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
190 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
190 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
511 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
420 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
304 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
809 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
2answers
949 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
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
411 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
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
213 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
413 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
2answers
92 views

Why does FeatureClassToFeatureClass work in ArcMap but not in Python script?

When trying to copy a feature class from an SDE connection file to a scratch GDB, the FeatureClassToFeatureClass_conversion works in the ArcMap Python window, but I can't get it to work in a Python ...