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
1answer
82 views

Get domain descriptions for multiple fields using SQL (ArcSDE 10.3/Oracle back-end)

How can I get domain descriptions for multiple fields using SQL (ArcSDE 10.3/Oracle back-end)? I have successfully used the Oracle SQL in the ESRI document: Resolving domain codes to description ...
3
votes
1answer
68 views

Create SDE-file returns warning but creates the file

When I create an SDE-file using arcpy I get the following warning: WARNING 000565: Could not connect to server. This is the appropriate code temp = r'C:\Users\admin\AppData\Local\Temp' host = "...
3
votes
0answers
51 views

Rename the output file ArcGIS

I am copying a tons of features from a file geodatabase to a database server. First I created an enterprise geodatabase connenction and after a database connection. In the first step I added a ...
3
votes
0answers
149 views

Is it possible to change or reconfigure a domain owner on SDE?

We have had to reconfigure a few things within a geodatabase managed in SDE. This inadvertently has caused some issues updating the domains within the gdb, to the point where not even the DBO can ...
3
votes
0answers
140 views

How to hide system tables of oracle in sde connection?

I connected to oracle 11g r2 with ArcGIS 10.2 using SDE connection. The connection is ok but in the connection i see system tables of APEX_030200 and other schemas. Same question is in the Geonet ...
3
votes
0answers
116 views

Attaching old archive table (_h) back to original feature class on re-enabling geodatabase archiving?

I'm trying to figure out a way to update the schema of an archived feature class. There was a lot of discussion about this from 2012 and prior. https://geonet.esri.com/message/115340#115340 < -- ...
3
votes
0answers
91 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
742 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
228 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
419 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
178 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
183 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
172 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
615 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
245 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? http://help.arcgis.com/en/geodatabase/10....
3
votes
0answers
505 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
207 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
760 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
315 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
253 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
545 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
337 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 and/...
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
290 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
357 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
584 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
198 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
813 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
187 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
228 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
60 views

saving survey123 data programmatically using python

I'm recording data using the Survey123 app which logs data into a standard ESRI rest service, stored in my AGOL account. I would like to save this data an SDE dataset. Is it possible to do so using ...
2
votes
1answer
222 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
210 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
538 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
447 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
328 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
858 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
1k 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 confusing....
2
votes
1answer
2k 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
422 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 ...