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
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
73 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
88 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
51 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
44 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
33 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
63 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
34 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
46 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
114 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
66 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
66 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
148 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
78 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
103 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
144 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
80 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 ...
2
votes
1answer
62 views

Determine if ArcSDE service or direct connect

Does anybody knows if there is the ability to check a layers datasource, if it is an direct connect to a database or if an ArcSDE service is used? For both the esriDataSourcesGDB.SdeWorkspaceFactory ...
0
votes
1answer
95 views

Reconcile and post with c#

I am trying to understand Esri example of reconciling and post with C#. Could someone give me some hints or point me in the right direction. The reconcile and post in Arcmap toolbox has edit version ...
2
votes
1answer
81 views

Image cache on network drive vs. SDE/Oracle

We currently have all of our image data loaded into ArcGIS SDE/Oracle 9.3. There is a proposal to not load our 2015 orthoimagery into SDE/Oracle in order to save time and place it in a tile cache or ...
1
vote
0answers
77 views

Registering database to ArcGIS for Server gives null error?

I'm trying to register a database to ArcGIS for Server 10.2.0 from the web server manager using sde file from ArcMap. The connection works fine in ArcMap. But when registering I'm only getting a ...
0
votes
0answers
32 views

Copying ArcSDE environment from LIVE to TEST with SQL Server?

I was looking for some advice on how best to go about migrating a copy of our LIVE sde environment across to our TEST sde environment which are on two separate servers - both running MS SQL 2012. I ...
1
vote
2answers
174 views

Using Python to backup ArcSDE geodatabase on SQL Server Express?

Is it possible to use Python to do a backup of ArcSDE databases stored in SQL Server Express? I have been using a custom executable that uses Arcobjects IDataServerManagerAdmin.BackupGeodatabase() ...
0
votes
0answers
52 views

Same script works in ArcMap Python window and fails when executed on different computer?

I have a simple python window script: mxd = arcpy.mapping.MapDocument("CURRENT") df = arcpy.mapping.ListDataFrames(mxd)[0] sr = df.spatialReference ...
1
vote
1answer
102 views

Creating geodatabase administrator account other than SDE?

I need to create another account other than SDE and make it geodatabase administrator. Is it possible? I have already created another account and have given SUPERUSER priviledge. However I cannot do ...
0
votes
0answers
137 views

Changing alias of ArcSDE feature class?

I have a feature class. I want to edit the alias. When I go into the Properties of the FC and try to edit the alias, nothing happens. The field will not accept focus and changes are not allowed. How ...
2
votes
1answer
77 views

Select by attributes for Arabic fonts in SDE/ file geodatabases?

I have a layer with names of electrical substations in Arabic language. there is no any problem when searching any Field names in English language whether from the SDE of file goedatabase I got the ...
3
votes
3answers
118 views

Migrate datatypes from geometry to geography in MS SQL

I have three ESRI feature classes (POINT, LINE and POLYGON) that contain a geometry datatype column with data in a projected coordinate system. I'm looking for a way that I can convert & project ...
1
vote
1answer
139 views

ArcGIS Tool to Delete only Geodatabase content (feature classes, tables, etc)?

Situation: Need to add a Tool to my ModelBuider to Delete only the content from an Enterprise (SDE) Geodatabase (containing features classes, tables, relationship classes). Tool "Delete" (from ...
0
votes
1answer
119 views

Copy shapefile to SDE feature class using arcpy

Is it possible to copy shapefiles to SDE geodatabases using ArcPy? I have tried using Copy_management, but it says that it cannot copy between different workspaces. Is there a different function that ...
0
votes
1answer
96 views

How do I set the domain extents to default?

I have a feature class that seems to be cutting off geometry. I looked around to see if there is a bounding box applied and found the Domain, Resolution and Tolerance tab in the Feature Class ...
0
votes
1answer
859 views

Error connecting to SDE 10.3.1 on Oracle 12c from 10.1 client

We are currently planning an server migration. We have our current server on SDE 10.1 on Oracle 11 Currently our editors are on ArcGIS 10.1 with Oracle client 11.2 Our new server is setup and ready ...
1
vote
0answers
99 views

Issues creating ArcSDE sde_logfile for certain users (username begins with a numeral)

I am having issues when editing an sde feature class from certain users. The way my database is set up is that the authentication roles are updating constantly by comparing the current authentication ...
1
vote
1answer
79 views

How do I keep my python loop going if there is an error with an SDE workspace?

I have a folder with several .SDE connections. I want my Python code to execute various SDE maintenance procedures (such as compress) on each of these databases. If there is a bad/corrupt/not ...
0
votes
1answer
464 views

arcpy.env.overwriteOutput = True not working for one dataset

I am doing a basic copy from sde database to file geodatabase. I have a loop going through each feature dataset in the sde database, this loop is really basic it just uses arcpy.Copy_Management to ...
2
votes
1answer
331 views

ArcGIS Online related table not displaying correctly in popup

I have an ArcGIS Online Map composed of three spatial feature classes and a table. All three feature layers are related to the table and all the layers and table are housed within the same SDE. I ...
0
votes
0answers
33 views

Changing names of versions that have a child

Is it possible to change the name of a version that currently has a child associated with it?
0
votes
1answer
14 views

TableSet Imported to Table of Contents

If I have a SDE table view between two Feature Classes am I able to drag and drop into ToC or will I have to create a feature class of the tableset? The files are in a SDE database. I would also like ...
0
votes
1answer
50 views

Error: Failed to convert: Database Connections… when trying to export to shape file

I have created a table with some derived data in SDE using sql server. The following is an example row of the table: T_OBJECTID T_GEOID T_STATE T_COUNTY T_TRACT T_NAME T_LSAD T_CENSUSAREA ...
0
votes
0answers
26 views

How to edit ArcGIS archive layer?

I am working in the ArcGIS enterprise Geo database environment. all feature data sets are enabled for archiving. When I was editing the default feature data set some important data was deleted by a ...
2
votes
1answer
98 views

SDE State ID with Python

I have created a Python script which compresses an ArcSDE geodatabase and now I would like to view the State ID after the compress. Is there a way with Python I can get this info?
1
vote
1answer
62 views

Is Create Spatial Type necessary

When I enable an enterprise geodatabase for a database in postgresql, the st_geometry type get installed with it. So Is it necessary to use "Create Spatial Type" tool to create st_geometry type in ...
1
vote
1answer
438 views

Database connection fails when using db authentication, succeeds using OS

When i attempt to make a connection to a database on my SQL Server 2014 sever via Database connections in ArcCatalog using with db authentication i get "Connection was attempted with an older ...
2
votes
0answers
55 views

Autonumbering using ArcGIS Web AppBuilder?

I work for a water utility division and we are using ArcMap 10.1 with attribute assistant. I used the AutoNumber method to auto increment and populate a field with the next highest integer. ...
1
vote
0answers
58 views

How to reconnect Arc GIS Schematics diagrams to GIS data in another oracle/SDE

My problem: An Arc GIS Schematics diagram export with versioned oracle/sde GIS features can't be reconnected to GIS data on another oracle/sde instance. I'm working on a project where in the first ...
0
votes
3answers
192 views

Reading Arcsde Data of a specific version in python

how can i read a version within python. for example lets say I set up a workspace which points to a .SDE file connection. Now how can I read the features from a version within python? I have looked ...
3
votes
1answer
171 views

How are orphan gsrvr.exe processes created?

I just inherited a server running SDE application server 10.1 against an Oracle 11g database. I'm finding that many connections are not getting properly dropped and stay on as Orphans. Eventually the ...
3
votes
2answers
131 views

Switch between test and production database in ArcMap?

I have two Oracle 11g databases, one for testing (tst.world) and one for production (prd.world). Except when I am trying out new things, they have exactly the same table structure. In ArcCatalog I ...