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)

2
votes
0answers
59 views

How to convert the BLOB value for the features geometry of type st_geometry kept in ArcGIS databse on Oracle [closed]

I am using ArcGIS Oracle database and I am trying to access feature geometry points as string. But the problem is that the points are kept as blobs and I cant convert to meaningful string. select ...
0
votes
1answer
31 views

View ArcSDE feature classes of published map service, when outside of corporate domain

I have a notorious problem, which keeps bugging me since days and I can´t find ANY proper answer on the net... In my company we´re using ArcGIS Server 10.1 and publish map services throughout our ...
2
votes
0answers
31 views

Where do field aliases reside in an SDE database?

If I want to get field aliases for an SDE table through pure SQL, what table do I query? My geodatabase was created with ArcGIS 10.1 in an Oracle database.
0
votes
5answers
69 views

PDF Plotting from ArcGIS for Desktop?

I am experiencing a very annoying phenomenon at the moment when trying to plot an A0 PDF Plot and would be interested to hear if anyone has had a similar problem and whether there is a solution or ...
0
votes
0answers
9 views

Altering old AXF before importing back into ArcSDE?

When we exported an AXF, the editable layer had all its fields turned on. When we bring it back in, months later, even if a field wasn't set up for editing outside the office, the values in the field ...
0
votes
0answers
37 views

Dynamically Create a Foreign Key for Relationship Classes

May be a relativity novice question but my research has turned up no direct answer. I have a feature class of land owner parcels that I would like to preserve its schema. I would like to add fields ...
1
vote
1answer
87 views

ArcGIS 10.1 crashes during connection with ArcSDE 10.2 in Oracle 11g database

I have been having this issues of ArcGIS (ArcMap and ArcCatalog) crashing on me every time I try to connect to the databases. I have updated both client and server patches for Oracle as suggested by ...
2
votes
2answers
93 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 ...
0
votes
0answers
15 views

Snapping a point into a raster grid

Currently I have a raster grid in the SDE. This raster grid represent certain region (For example: Raster grid for one island). On the other hand, I have point features which are plotted within the ...
1
vote
1answer
33 views

Find Delta only records in ArcGIS (SDE)

We have spatial layers in ArcSDE with objectid as unique value, I've taken this data to another platform & migrated data to cloud. Now, after months, back in ArcSDE and want to migrate new data ...
4
votes
2answers
79 views

Querying for underscore character in ArcMap?

For a standard LIKE query against an Oracle-based ArcSDE feature class, the underscore character represents a single character wildcard when used with a string. I'm trying to impose a definition ...
1
vote
0answers
42 views

Arcpy - Why does multi_user_mode have to be False in an edit session on non-versioned dataset?

I'm in the process of implementing Mintx's answer to my question What would cause a geoprocessing service to say "Cannot Open 'FeatureClass' Failed to Execute"? However, I had ...
2
votes
1answer
36 views

How can I access information about ArcSDE historical markers via arcpy or SQL

I would like to be able to access the list of historical markers that is presented by in the "Change Version" dialog in ArcMap - ...
3
votes
1answer
82 views

Deleting Oracle SDE features classes properly

I have got a few feature classes in an SDE connection. This is the situation: a) They are listed in ArcCatalog (10.1), but the open fails. The message says: 'Error opening feature class, DBMS table ...
2
votes
1answer
75 views

Repoint feature layers from one SDE to another

I am trying to repoint layer (.lyr) files to a new SDE connection. In a test project folder I have two test layer files. When using lyr.findAndReplaceWorkspacePath() the script runs with no errors, ...
0
votes
1answer
45 views

Undo option to 'move edits to base' ArcSDE

I have an ArcSDE Geodatabase where a number of layers are registered as versioned. Having spent some time troubleshooting an issue I'm having with syncing data on Collector, I have noticed that the ...
1
vote
2answers
69 views

Using Python to select records by date field

I am trying to write a python script to select records created within the past 7 hours (date field - database time) using a where-clause within arcpy. The table is ArcSDE database (Microsoft SQL ...
-2
votes
1answer
42 views

How much RAM do I need per SDE DB [closed]

Estimating RAM required is never a fixed number. However, there are base figures to follow for example for arcgis server services. How much RAM do I need to plan per DB? I'm using SQL Server but ...
3
votes
0answers
88 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 ...
2
votes
2answers
200 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 ...
1
vote
1answer
39 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
61 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
61 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
53 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
80 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
260 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
97 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
51 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
39 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
68 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
98 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
56 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
75 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
74 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
90 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
127 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
36 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
32 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
88 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
38 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
58 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
103 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
72 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
325 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
46 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
178 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
41 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 ...