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
980 views

Changing default precision and scale of number fields in ArcSDE geodatabase table?

After I change the precision and scale for my short, long, float, and double field types when creating a table in ArcMap SDE geodatabase, ArcMap will reset my precision and scale to default values. ...
1
vote
0answers
200 views

Is there a way to QGis read an SDE.ST_GEOMETRY field?

this is the type and name that Qgis displays for me when I connect with a oracle table,it is not displayed as a geo column, there is a setting I'm missing? Can Qgis Read this type of data?
1
vote
0answers
112 views

SDE Performance issue with SQL Spatial labelled lines on one server

Here is an issue that has stumped ESRI and SQL Server experts alike. I ask it here just to get more people thinking about it. Exhibit A is this screencast. I have two servers: ROGIS: A dedicated ...
1
vote
0answers
428 views

Using arcpy.CopyFeatures_management results in a 000210 using a database connection that does not contain saved credentials

Currently have a problem running CopyFeatures_management in ESRI's ArcGIS 10.1 The following shows two Enterprise Geodatabase connection files. One includes the username and password and the other ...
1
vote
0answers
423 views

Running python script outside of Arcmap's python console

My codes works fine in Arcmap's python windows. But when I try to run it in a command promt windows, It says that; ERROR 000837: The workspace is not the correct workspace type. But it works fine ...
1
vote
0answers
59 views

Multiuser Editing with ArcGIS through LAN

I am working on an ArcObjects application (C#), which is supposed to carry some customized editing operations, the database is ArcSDE based on Postgresql via (accessible via a LAN network). One ...
1
vote
0answers
565 views

ArcSDE Problems: Microsoft SQL Server 2008 R2 on Windows 2008 R2 Standard (64-Bit)

I´m trying to set up ArcSDE 10.2 on a Microsoft SQL Server 2008 R2 running on a Windows Server 2008 R2 Standard 64-Bit machine. I can create the database connection, but when I want to enable it for ...
1
vote
0answers
125 views

How do I bypass class extensions when reading from ArcSDE with FME 2014?

I'm trying to read Feature Class from our Enterprise Geodatabase and because we have custom class extensions registered on all our our data. I am not able to set the Reader to bypass the class ...
1
vote
0answers
72 views

How to implement subtype functionality in Oracle Spatial?

I am planning to shift my entire database from arcgis to oracle. I will not be using ArcSDE services also. I need subtitutes for ESRI's functionalities like domain, subtype, relationships in oracle. ...
1
vote
0answers
78 views

Is there a way to prevent losing metadata when generating a spatial view in ArcSDE 10.1?

When generating a spatial view in ArcSDE using a script, any previous metadata is dropped when the old view is dropped. Thus, any edits to metadata on the view, are lost. Is there a way to keep the ...
1
vote
0answers
86 views

Problems with versioning

I have 5 PostgreSQL_PostGIS database in my company and i conneting on them through ArcSDE. Four of database work correctly, only with one i have i realy big problem. When i make two versions of ...
1
vote
0answers
115 views

Why might ArcPy, TableToTable, MakeQueryTable and ArcSDE have performance issue in IDLE?

I have written a Python script tool to do: Make Query Table Table To Table (with fieldmapping). The code is nothing more than arcpy.MakeQueryTable("table1;table2;table3", "queryTable",..."where"...
1
vote
0answers
76 views

What is the relationship between Map Service Instances and SDE connections?

We have a GPS project based on ArcGIS Mobile 10.0. There are two web map services and each were kept as Nonpooled with Minimum instances 15 and maximum instances 60 by original developer. The database ...
1
vote
0answers
146 views

“Definition Query on a versioned Geodatabase”

I would like to implement Specific views to the SDE users, based on Definition Queries of common attributes , like Date created > = October 1. But on first look, the definition queries are for "...
1
vote
0answers
87 views

Is there tutorial available for PostGIS setup in ArcSDE 10.1 geodatabase on Linux?

Is there any tutorial for Set up PostGIS in an ArcSDE 10.1 geodatabase on Linux? There is one in tutorial arcgis 9 for ArcGIS version 9, but I couldn't find any for ArcGIS 10.1.
1
vote
0answers
392 views

Arcpy - change layer from sde connection to file geodatabase

We are copying data from our corporate office to field offices and we are creating a file geodatabase at these field offices. We are copying the layers that point to sde and they need to point to the ...
1
vote
0answers
694 views

Replicas: Synchronize changes for individual feature class (not entire replica)

I have two ArcSDE databases, running with a two-way replica.One serves our interactive mapping website which gives certain users the ability to update, add points, edit attributes, etc. Then we have ...
1
vote
0answers
349 views

Why does Append on large annotation layer give WARNING 000594: Input feature falls outside of output geometry domains?

I am trying to Append about 3,000,000 records in an annotation layer to another, empty annotation layer. I'm using ArcCatalog and I get the following error messages: WARNING 000594: Input feature ...
1
vote
0answers
259 views

While Exporting from SDE, null geometry features attack?

I'm working on a layer in an SDE Database (ArcMap 10.1 SP1 for desktop (Build 3143)), I just export to a local working database on my workstation the layer I want to work on and load it back when done....
1
vote
0answers
198 views

How to display labels from many-to-many relationship in ArcGIS 10 using VB.NET?

I have two tables in a geodatabase: parcel; and person 1 or + parcel, can have 1 or + person (relationship is many-to-many) Using VB.NET I can display all the parcel labelled with the "id"...
1
vote
0answers
382 views

Quering a ArcSDE featureclass attribute table after joining

I am trying to query a ArcSDE Feature Class after joining using Iqueryfilter I have two SDE feature classes. 1) Subdivisions : which has details of subdivision and districts (parent) 2) ...
1
vote
0answers
171 views

Extract an ArcSDE datasets (rasters/shape files) using python?

I would like to write a python script to extract/export a dataset (rasters/shape files) in ArcSDE. I saw this posts to connect to the server: Define Workspace for SDE Connection in Python But how ...
1
vote
0answers
233 views

How to run SDE view commands in Oracle DB?

I would like to create SDE view to compare two tables in my oracle spatial database. I already prepared the view commands. But I dont know where and how to run this? I unable to run this commands in ...
1
vote
0answers
45 views

Managing outages to make ArcSDE updates?

I would like options to manage ArcSDE outages for making updates to schema, which I am not able to do when users are just reading the feature classes. I would like to not have to stay late to get ...
1
vote
0answers
83 views

sdequery.exe: When using functions as column names (-C parameter), how do you escape the comma for functions with parameters?

Using sdequery, I'm specifically trying to return sys_context('USERENV', 'SESSIONID'). user and sysdate work fine. Functions with single parameters work fine. But as soon as I use a function with ...
1
vote
0answers
659 views

SQL sub query syntax does not work on versioned tables without base option- Modified

My original question asked why the where clause below, which includes a sub query, would not work on an SDE database but the same query against a file geodatabase would work. I had thought the ...
1
vote
0answers
48 views

Edits geodatabase

I am trying to reconcile and post the edits. Before doing that I want to manage the edits in such way that the edits are queued before reconcile and post. I am doing this using c#.
1
vote
0answers
385 views

Can feature layer in MXD with joined data from non-geodatabase be published as feature service?

I have a table stored in an SDE geodatabase for all point features with an additional GEOMETRY_ID. A few non-spatial data tables are stored in an ordinary MS SQL Server database. They can be joined by ...
1
vote
0answers
308 views

Creating relationship class in ArcSDE?

I can not seem to create a relationship class in ArcSDE, or at least one that works. I am succseful in creating the class however ArcMap does not recongnize it (there are no related tables shown) and ...
1
vote
0answers
328 views

Loaded shapefile into SDE without spatial proj creates problem

Via a Python script - various shapefiles were loaded into SDE with no spatial reference set. This causes a strange problem - when you view the featureclass in ArcCatalog (geography view) - it shows ...
1
vote
0answers
102 views

Can we do replication and versioning in User schema geodatabases version with sde default version

As both are administrators to their own schemas, is there any possibility to post and reconcile data across schemas?
1
vote
0answers
315 views

T-SQL with SDE and Web Map ArcGIS Server 10 MSSQL 2008

I need to build a system whereby the user of a web map (the standard web map that ArcGIS Server Manager builds) can edit a feature class's attributes. The attribute will be a 'Comments' field. The ...
0
votes
0answers
4 views

Error found while retrieving conflicts ArcMap 10.3

I have a problem when trying to review Conflicts in ArcMap 10.3 I have found a similar question ,and in the solution there was a link to download ArcSDE service pack , but the link was invalid . ...
0
votes
0answers
16 views

Updating ArcSDE Database using VB.Net?

I have a master feature in a SDE Database. This Master file contains the records of all "inspections" being undertaken. I have a second feature, which contains a "live" dataset of current inspections....
0
votes
0answers
31 views

HRESULT EXCEPTION error - Arcmap Geoprocessing .net

I am writing a script / Add-in for Arcmap and am coming unstuck with an error when I am trying to "delete identical" records in an SDE Geodatabase. Running through the process. I have a SDE ...
0
votes
0answers
23 views

bring back column info in sde descendant version

I have a feature class registered as versioned in sde with editor tracking turned on. In my edit version, I was updating one field for all records but forgot to turn off the editor tracking before ...
0
votes
0answers
24 views

Querying Archive Class with REST API of ArcGIS Server?

I would like to know if there is a way to access the archive class through a Map Service of ArcGIS Server. I have a Map Service with feature class stored in a SDE GeoDatabase with Archiving and ...
0
votes
0answers
11 views

Uploading Photos to SDE

We have several users using Collector for ArcGIS and the majority of them take pictures/videos. Once the database has been downloaded from ArcGIS Online, we’d like to load this data, including the ...
0
votes
0answers
15 views

Selection anchor when selecting features programatically

In an edit session, I am using code to select multiple features from an SDE polygon layer. After the selection is performed, the user can then use the rotate tool to adjust the features to their ...
0
votes
0answers
30 views

Updating old attribute values with new ones in enterprise geodatabase?

I want to update values of a field with a new value. For example, the old value is U13-1234 and I want to replace it with a new value of DT1-1453. I have around 500+ records and i want to update ...
0
votes
0answers
13 views

Aborted Reconcile, Negative FIDs

I have an ongoing project in the parcel fabric that has been in the works for near a month. I use a child version from the default and I have been reconciling and posting my edits at the end of each ...
0
votes
0answers
27 views

Is there an Esri ST_Geometry function to remove m-values?

I'd like to use SQL to select the WKT geometry of an ArcSDE feature class of the type POLYGON M. However, I'd also like to suppress the m-values as I read them. PostGIS has a function Force2D that can ...
0
votes
0answers
37 views

Create additional 'fields' in GDB domain system table (GDB_items)?

Is it possible to create additional 'fields' in the geodatabase domain system table (GDB_items) in SDE 10.3/Oracle? It would be handy to store additional information in domains. For example: CODE [...
0
votes
0answers
70 views

Unable to save edits. The requested operation is invalid on a closed state [State_id=3411]. Arcgis 10.4 oracle 11g

Recently updated our system from Arcgis 10.3 to 10.4 (both client and server side). When trying to edit my versioned arcsde oracle database following error appears. The error message reads: ...
0
votes
0answers
14 views

How can I create a definition query to show the next 5 years of data, based on a text field with the year on a joined table in SDE?

I need to show the next 5 years of construction data, but I want it to automatically update what is shown based on a text field called ConYearStartNbr that shows when the construction is set to start ...
0
votes
0answers
51 views

Export from SDE to Shapefile Bug

I'm exporting data from a large-ish SDE feature class (888,628 features) to a shapefile. I'm using the ArcMap GUI export process (add the SDE feature class as a layer, right click >> Data >> Export ...
0
votes
0answers
132 views

Receiving Error ORA-0094 B Invalid identifier when try to reconcile versioning in ArcSDE for Oracle?

I have one Edit child version and one default parent SDE version. When I try to reconcile from Edit version to SDE default version this error is coming. Error ORA-0094 B Invalid identifier I am ...
0
votes
0answers
11 views

Date Query 10.3 SQL SDE vs FGDC

I have a date field "FIRE_DSCR_DT" that I want to query for a specific month(s). For example,I want to get all of the records where the month = January. This query did not work in SDE, but it did ...
0
votes
0answers
41 views

Return table names for query layers using arcpy

The dataSource property for layers does not return the name of the tables used in query layers. Instead, it returns something like the following: 'Database Connections\\ConnectionFile.sde\\sde.SDE.%...
0
votes
0answers
31 views

Esri ST_Geometry function to make line from points

I'm attempting to write a SQL statement that joins two point feature classes, both in an Oracle ArcSDE geodatabase using ST_Geometry, and selects a line geometry connecting the points of each ...