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

How can I find whether a feature class has editor tracking set to database time instead of UTC?

I'm trying to publish a map service with about thirty layers in it. During the Service Editor Analyze step, it gave me a high-severity error 00129: Services cannot include data where Editor ...
3
votes
1answer
59 views

Incremental Network Loader failing with ArcSDE Geometric Network

I've been testing the Incremental Network Loader tool for loading new lines into a geometric network from an outside feature class. The tool worked perfectly on a File GeoDatabase copy of our SDE. ...
2
votes
0answers
60 views

Locking geometry of ArcSDE feature class from ArcGIS for Desktop?

I am using ArcGIS 10.2. Does anyone know how I can allow editors to select features and update attributes of an ArcSDE feature class but prevent accidental edits (shifts/deletions) to the geometry? ...
0
votes
1answer
48 views

Copy multiple feature classes in FME without merging

I am trying to create an FME workspace that reads a series of feature classes from an Oracle SDE database and copies them to another Oracle SDE database, one by one. The key thing is I do not want to ...
2
votes
0answers
72 views

Geodatabase performance and Archiving [closed]

We have SDE (10.3) running on SQL Server (SQL Server 2012 on Windows Server 2012 R2) Over time we've noticed our GIS performance degrade, and can have good days and bad days. We run versioned ...
0
votes
0answers
210 views

Failure to access the DBMS server, communication link failure

I am using ArcGIS suite 10.2 and have SSMS 2012 installed. I have a database connection through ArcSDE to a SQL database. After roughly 15mins, I am unable to add data from this database. Has anyone ...
3
votes
1answer
91 views

SQL Spatial select record where intersects another record

I have two tables - 'Tree' (point) and 'ServiceArea' (polygon) in the GIS database. Trying to select all Tree records that intersect a ServiceArea where the value in Tree.ServiceAreaNumber field ...
0
votes
0answers
41 views

Automatically picking up OBJECTID in ArcMap from Create View in SQL Server

I have a plain SQL table stored in an SDE database on SQL Server 2008 as below. CREATE TABLE [dbo].[AAA_TEST]( [ID] [int] NOT NULL, [LON] [decimal](9, 6) NOT NULL, [LAT] [decimal](9, 6) ...
0
votes
1answer
38 views

ReconcileVersions and “out_log”

I'm automating some sde geodatabase management. In the ReconcileVersions_management function there is an option create a log file of the result ("reconcileLog"). If the script runs five nights a ...
0
votes
3answers
29 views

Layer File data source

I have saved group of layers which reading from SDE DB as layer file when i open the layer file in any other MXD it takes the same SDE data source How i can make the Layer file with out data source ...
0
votes
1answer
64 views

Can't execute a simple psycopg2 script twice when running from ArcGIS Desktop as a script tool

I'm building a geoprocessing service that queries an SDE database (running on postgres) and returns results. I do a lot of development by calling the script from a toolbox in ArcGIS desktop 10.3. ...
1
vote
1answer
90 views

arcpy.PackageWorkspace doesn't keep reference to SDE enterprise geodatabase

I am publishing a geoprocessing service on ArcGIS Server v10.3.0 that updates data on an ArcSDE Enterprise Geodatabase. I have the following at the beginning of my script: arcpy.env.workspace = ...
1
vote
1answer
55 views

Viewing list of data sets that have been edited under specific ArcSDE Version?

I'm wondering if it's possible to list all of the data sets (feature classes, tables, etc.) that have been edited under a particular version in ArcSDE. A tool that does this would be ideal (I see ...
0
votes
0answers
66 views

How to access ArcSDE metadata using OGR?

I'm trying to get a list of all layers in an ArcSDE database hosted in oracle here is the command I'm using: ogrinfo -al SDE:localhost,5151,sde,sde,sde Note: I've replace the database, username ...
0
votes
1answer
21 views

Removing existing backup layers and renaming current live layer in ArcSDE

Looking at the attached screenshot of Catalog, there are the file "CRT_CANAL" and many backups. The aim of this code is deleting old backups in the ArcSDE database, renaming the existing "CRT_CANAL" ...
1
vote
0answers
73 views

Optimal SDE Database Configuration [closed]

I am starting to set up PostgreSQL as a DBMS for ESRI SDE instances. I am looking for recommendations for setting up the roles/schemas for this. My architecture is: Virtual private server with ...
1
vote
0answers
87 views

'sdetable' is not recognized as an internal or external command

I try use arcpy.JoinField_management(inFeatures, inField, joinTable, joinField, fieldList) to join SQL server database tables to shapefiles directly, using an ArcSDE connection. The database ...
0
votes
1answer
114 views

SDE GDB Versioning - reconcile and post from DEFAULT to Child

I am relatively new to versioning and think I have made a mistake in my workflow. I am using a SDE geodatabase, with a DEFAULT and 'Field Editing' child version in ArcGIS 10.3. I received a lot of ...
1
vote
1answer
35 views

Multi-writer (ArcGIS FME) for export to DGN

I would like to ask, if there is any way for export from one Reader (line geometry, format ArcSDE) to more writers (all in the same format DGN). Specific line with identical ID then would be displayed ...
0
votes
0answers
31 views

Set alias for subfields when performing query

As mentioned within the ESRI-docs we can set an Alias for the subfields of an SQL-query performed onto a file-geodatabase as follows: IQueryDef2 filter = (IQueryDef2) ...
1
vote
0answers
76 views

Releasing all schema locks in ArcGIS GDB

We use ArcGIS 10.3 products (Server, Desktop) with Oracle database. Our problem is we can not make any schema changes because of shared schema locks unless we stop all services and kill all database ...
0
votes
1answer
36 views

ArcPy function for changing data source server properties inside mxds?

Is it possible to change the parameters highlighted in the screenshot below? If so which ArcPy function would do this? I know about and do not want to use the function that references .sde files on ...
2
votes
0answers
37 views

Controlling precision of coordinates returned from ArcGIS for Server service?

I have a REST service that returns shapes as json. The shapes represent various natural features. The problem is the precision of the coordinates. Currently, 11 decimal places of precision are ...
1
vote
1answer
57 views

Creating a menu interface to update an sde feature class in ArcMap using arcpy?

I work in electrical utilities and we have stacks of paper records that need to be updated into an existing SDE feature class attribute table. My problem is that someone in the city's GIS office would ...
2
votes
0answers
94 views

Creating Checkout Replica in ArcObjects (from ArcSDE geodatabse to file geodatabase)?

I'm trying to create a checkout replica of some feature classes from an ArcSDE geodatabase to a file geodatabase using ArcObjects. I'm trying to follow this: How to create a replica in a connected ...
4
votes
2answers
70 views

Is there a LINQ-provider for GeoDatabase

I want to query my ArcSDE geodatabase using LINQ but I don´t know if there is an ESRI-provider that may also read geometries and which is able to handle archiving as well. Thus I´d like to read data ...
1
vote
2answers
281 views

RuntimeError: cannot open “feature class” with SearchCursor?

I have a very simple script that isn't working. import arcpy workspace = "C:\\Users\\Work\\AppData\\Roaming\\ESRI\\Desktop10.3\\ArcCatalog\\master.sde" arcpy.env.workspace = workspace wire = ...
0
votes
1answer
42 views

Delete tables from SDE including archive-tables

I want to delete some tables from my SDE as well as some featureclasses located in a feature-dataset. As some of those tables and featureClasses are enabled for archiving I get both the base-table/FC ...
0
votes
1answer
150 views

Connecting to ArcSDE with ArcSDE Geoserver extension?

I have a server running Geoserver 2.8 with the ArcSDE extension installed. I have added a new "ArcSDE ESRI(tm) ArcSDE 9.2+ vector data store" with credentials from our DBA. When I try to add a layer ...
0
votes
1answer
31 views

Listing geodatabases in local SQL Express Workgroup ArcSDE using ArcPy/Python? [duplicate]

I would like to create a list of the multiple geodatabases that sit in my local SQL Express Workgroup SDE server. I have set up a connection using the "Database Connections\Connection to ...
0
votes
0answers
27 views

ArcSDE data does not loaded in ArcGIS Runtime application

I'm developing an application that uses ArcGIS Runtime for WPF. The application should display a couple of layers from a map package (MPK file). The map packages is referencing to a SQL Server ...
1
vote
0answers
45 views

FME: floating point precision issues (ArcSDE / FGDB)

I am working on a (generic) FME Workbench that clips and exports data from ArcSDE database into the File Geodatabase (FGDB) format. The SDE features are clipped using an AOI, that arrives in the ...
0
votes
0answers
70 views

Selecting ArcSDE centroid in different coordinate system?

I have a polygon feature class stored in an Oracle ArcSDE geodatabase. I can extract the centroid of a polygon feature in SQL using SELECT sde.st_x(sde.st_centroid(SHAPE)) as lon, ...
2
votes
1answer
80 views

Esri ArcSDE 10.3.1 Query Inspire Metadata from Oracle (11g) Enterprise GeoDB via SQL

As the title says - I want to create a query in Oracle SQL which will read all dates from the geoprocessing history which can be found using ArcCatalog to show the "Description"-tab from a feature. ...
1
vote
1answer
47 views

Changing ArcSDE connection credentials for map document?

Is it possible to change the ArcSDE credentials used by an MXD, so that users with the same connection can open the MXD and use their own username and password to access that data? With our current ...
0
votes
0answers
41 views

Replica between ArcSDE databases not including all fields of a layer

I want to create a replica between two enterprise geodatabases, the replica include several layers, but one thing is I don't want include all fields of these layers. For example, the layer roadline I ...
1
vote
1answer
32 views

Item Description on a Feature Class Not Appearing on a Published Feature Access Service via ArcGIS Server?

I have a feature class in an SDE where metadata has been loaded via the 'Load XML Recordset Document' option of the feature class. When viewing the item description of the feature class, the metadata ...
3
votes
1answer
61 views

Linking file geodatabase and ArcSDE?

My office does a lot of field work where we log points via the Collector app. Those points are then always exported to a geodatabase feature class for further editing and analysis. If edits and ...
1
vote
0answers
32 views

Geoserver not displaying ArcSDE versioned table data as it is updated

Has anybody managed to get GeoServer 2.8 with the ArcSDE plugin (ArcSDE 10.0) to retrieve updates to data as soon as they are made when data is retrieved from a SDE view? The SDE view is in Oracle ...
0
votes
1answer
44 views

ArcSDE to Shapefile Async in .NET

I have a question about exporting an (versioned) featureclass stored in a ArcSDE geodatabase to a shapefile with VB.Net. I've created the code which I think should work fine, but ArcObjects "says ...
3
votes
0answers
101 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 ...
1
vote
0answers
38 views

ArcSDE post installation error?

I had a problem during post installation of ArcSDE for SQL server 2008, and this is the message : The ArcSDE Repository was unsecessfully completed. would you like to view this error? then when I ...
2
votes
1answer
49 views

Why might data sources of Current ArcSDE layers vary in way they are listed?

I would be interested to know if someone can tell me why SDE Connection: Layer Data-source shows C:\USER\JOHN_SMITH and not DATABASE CONNECTIONS\**** Back ground is we are going through a migration ...
4
votes
1answer
64 views

How to use MAX SQL statement in ArcGIS?

I would like to use a MAX SQL query for a column in a definition query, where there records that are being queried are the MAXIUM from the field UPDATE_DATE_DATE while grouping by the field ...
1
vote
1answer
65 views

Feature class to feature class code

I have some code that will take a ArcGIS 10.2.2 feature class and post a copy of it in a different geodatabase. My code is set up so the end user can pick the feature class they want the model to ...
4
votes
0answers
140 views

Creating materialized view from ArcSDE layer

In the past I've used materialized views in Oracle to replicate non-spatial data from one database to another. I'd like to do the same thing with an ArcSDE feature class, but I'm wondering how that ...
2
votes
2answers
76 views

How to use IDatabaseConnectionInfo3 Interface ArcObjects!

I try to retrive the connected users from an entreprise geodatabase using ArcObjects . first I tried to cast My workspace to IDatabaseConnectionInfo3 but it throws ClassCastException ...
1
vote
1answer
96 views

How to change owner of a version in an enterprise geodatabase using ArcObjects?

I have ArcObjects/.NET code used to create few versions for workspace. Versions are created successfuly but their owner is who created them (the user connected to the workspace). I want to change the ...
0
votes
1answer
128 views

How do I find out when a shapefile was created?

I am working on a project at an agency with a large amount of prior data stored in a shared database connection .sde folder to which I have access. While this is incredibly helpful, I would like to ...
1
vote
1answer
79 views

How to set a specific ArcSDE version for tabular reporting?

I have created a multiversioned view in Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production. I can access a specific version using a SQL script in SQL Developer. However, using ...