Questions tagged [enterprise-geodatabase]

Use this tag for questions about the Enterprise Geodatabase (ArcSDE in earlier versions) component of ArcGIS for Server.

Filter by
Sorted by
Tagged with
0
votes
1answer
100 views

Get ArcGIS Pro to show which feature is causing copy/paste to fail

I have an Enterprise geodatabase feature class in a feature dataset that I need to copy over to a gdb. I've tried right click to copy and paste, the copy tool in ArcGIS Pro, copy management in ArcPy. ...
0
votes
1answer
15 views

Prevent users from deleting EGDB tables [closed]

Oracle 18c/10.7.1 geodatabase: My geodatabase has an owner/schema/user called OPERATIONS. Operations staff have a direct db connection in ArcMap/Catalog to the OPERATIONS owner. This connection is ...
0
votes
1answer
34 views

What happens in the DB when a user updates a record in a versioned table?

ArcGIS Desktop 10.7.1/Oracle 18c. In a table that is versioned (with the option to move edits to base): What happens in the database when a user updates a record? It would be helpful to know what ...
0
votes
1answer
42 views

Copying feature datasets weekly from EGDB to EGDB (geometric networks included)

I've been trying find a way to copy a few select feature datasets from our main production Enterprise geodatabase environment to a second Enterprise geodatabase. These datasets include geometric ...
0
votes
0answers
48 views

Prevent deletes in a versioned FC at the application level

In Prevent deletes in a versioned FC at the database level (a related question), we determined that it's not possible to prevent deletes from a versioned FC via functionality in the database. As an ...
0
votes
1answer
35 views

Under what circumstances would the _DELETE trigger get called? (_EVW)

Oracle 18c/10.7.1 geodatabase: When an FC is registered as versioned (with option to move edits to base), several triggers get automatically created: V000001_DELETE V000001_INSERT V000001_UPDATE ...
2
votes
2answers
107 views

Prevent deletes in a versioned table at the database level

I have a table in an Oracle 18c/10.7.1 geodatabase. The table is versioned with the option to move edits to base. As far as I can tell, it's not possible to prevent ArcGIS Desktop users from deleting ...
0
votes
0answers
62 views

Create ArcGIS geodatabase domains from a CSV file using Python

I want to create ArcGIS geodatabase domains from a CSV file.The problem is that my output says field values in the row are "None". It doesn't recognize the values in my CSV file. Any ideas ? ...
1
vote
0answers
30 views

How to choose proper edit session in arcpy?

There are 2 databases A and B; Each one has two tables: Table1 and Table2, both were created with the same script, defining for both: fields, versioning and archiving. It is required to delete some ...
1
vote
1answer
39 views

Esri ArcObjects - getting geometry directly from SHAPE value ID

I've been teaching myself ESRI ArcObjects in C# over the past few weeks, I'm still very new in the ArcObjects world. All of our data is in an Enterprise geodatabase on a MS SQL Server database. I've ...
0
votes
1answer
130 views

Is Enterprise GIS license required to use Production Mapping license? [closed]

I'm looking to build up a hybrid GIS Enterprise environment whereby multiple users can access data at the same time via Arcmap. If possible, we'd like to not have to spend a fortune doing this. My ...
2
votes
1answer
166 views

Is the ObjectId value guaranteed to be unique after features are deleted and re-created in an enterprise geodatabase?

I'm working with an enterprise MS SQL Server geodatabase which is accessed via SDE. ArcGIS manages ObjectId values such that they are uniquely assigned as features are added to the geodatabase. My ...
2
votes
1answer
18 views

Area Attribute in Feature Classes Gets Renamed to full FeatureClassName.AREA

I have a number of feature classes in an Oracle-backed Enterprise Geodatabase which have an attribute called "AREA" which is type double. All of these feature classes are part of the ...
0
votes
0answers
35 views

How do I set the type of geometry when creating a SQL table?

The table I am trying to recreate has these properties Data Type File Geodatabase Feature Class Feature Type Simple Geometry Type Polygon <<<< WHAT I WANT TO RECREATE My target ...
0
votes
1answer
41 views

ArcGIS10.2 SDE relationship class referencing a deleted feature - how to clean up relationship class?

I am looking for a smart approach to cleaning up a relationship class, which consists of relationships that look at previously deleted objects. To illustrate, we have db.schema.SITE (spatial), db....
0
votes
0answers
23 views

Feature class is not imported in ArcSDE in ArcCatalog

I installed ArcEditor and ArcSDE. In my computer ArcEditor 9.3.1, ArcGIS Server 9.3.1, ArcSDE 9.3.1 and Oracle 11g are installed. I did all things by the Guide of ESRI: ArcGIS Server, Configuration ...
-1
votes
1answer
163 views

This version of Geodatabase is incompatible with dataset and cannot open it using ArcGIS Pro

This implementation is done in ArcGIS Pro .Net SDK and has an Enterprise geodatabase. We had a polyline feature layer and move functionality was implemented in this. The functionality was working fine ...
2
votes
1answer
48 views

How are Modifications and Deletions represented when looking at enterprise geodatabase delta (add, delete) tables?

I'm trying to understand how to make sure a delete is a proper delete and not a modification, and vice versa. I'm using ArcGIS 10.2 and Enterprise geodatabase on MS SQL Server. See below SQL: select ...
1
vote
0answers
63 views

ArcSDE version status stuck in 33554433

One of our ArcSDE versions (esri v10.1 and oracle 11g) in SDE.Versions table shows a 'status' field value of 33554433 instead of the usual 0, 1, 2 for private, public, protected. I understand this is ...
1
vote
1answer
67 views

ArcGIS client user connection hanging when connecting to PostgreSQL geodatabase

ArcGIS Catalog and Pro are both hanging when I try to connect as a user that is a member of a role. I think it is related to the SDE schema permissions but I'm not sure. I have an enterprise ...
0
votes
0answers
155 views

ArcSDE - AutoIncrementing Object ID in table stored in ORACLE when doing INSERT or UPDATE or DELETE using FME SDE Writer

I have data in an Oracle table (11 million records) and would like to insert 2000 records approximately using the FME ArcSDE Writer to maintain ObjectID put on the Oracle table by ArcSDE via ArcGIS. ...
0
votes
1answer
70 views

FME Desktop 2019.2 Geodatabase_SDE writer copies Dataset parameter from reader when I said not to

I'm using FME 2019.2, Geodatabase_SDE reader and writer with different connection files. I have one database "Operations" with user1 and another database "Data_Sources" with user2. They both support ...
1
vote
1answer
110 views

Parse SQL geometry Value to Arcpy Python geometry object

I'm trying to get a multiPolgon value returned from an SQL query (SQL Server 2014) to a an Arcpy Geometry Object. I know this is very easy I just am missing something.Whats confusing is this is a ...
0
votes
1answer
94 views

Do feature classes need to be versioned for editing with ArcGIS Collector/feature service?

I have an Oracle 18c/10.7.1 geodatabase with feature classes that have the following properties: Unversioned SDO_GEOMETRY datatype Registered with the GDB My organization plans to serve up the ...
2
votes
2answers
318 views

Snap a point to a line and get the line ID (Oracle Spatial or SDE.ST_GEOMETRY)

I have an Oracle 18c/10.7.1 geodatabase that has: A sidewalk polyline feature class (existing features) And a sidewalk inspection point feature class (the features are created via ArcGIS Collector/...
2
votes
1answer
164 views

FME - Cannot load versions in ArcSDE Geodb Writer

I'm attempting to write to a version in a 10.6.1 ArcGIS Enterprise Geodatabase with a SQL Server 2017 Backend. I have created a version in the database and I want FME to write directly to it. I'm ...
0
votes
0answers
243 views

Getting “Workspace Already in Transaction Mode” Error when trying to use updateCursor on versioned sde

There are are numerous post on this error, but I can't seem to find a solution for myself. We have a versioned sde and need to add new fields to some of our feature classes and populate them with an ...
1
vote
0answers
62 views

Use a non-GDB SDO_GEOMETRY table in a map service?

I have a table with an SDO_GEOMETRY column (points) in an external system. The external system is an Oracle 12c database; it is not a geodatabase. I want to serve up the SDO_GEOMETRY table to a map ...
1
vote
0answers
41 views

Updating field from table used as source in network dataset

I have a Feature Dataset that contains a Network Dataset and a Feature Class (as a source of Network Dataset) in enterprise geodatabase (PostgreSQL). The Feature Dataset is versioned because we want ...
0
votes
0answers
22 views

Database Population in wrong Authentication Type

I've populated a database while connected to it as an editor with an Operating System Authentication Type. I should have populated it while connected to the Database as the GIS administrator with a ...
1
vote
0answers
71 views

Poor performance when adding layer indexed ArcGIS Service layer to AGOL

My data sits in enterprise geoddatabases on Windows Server 2012, SQL Server manager. I often add ArcGIS Server Web services to my AGOL maps and they perform really well. However, when I add a ...
0
votes
0answers
41 views

Recalculate extent for versioned featureclass

I try to recalculate extent for FC (versioned). I deleted some objects with null geometry, or with wrong location and reconcile every versions. But I still cannot recalculete extent to new proper ...
0
votes
1answer
82 views

Slow SDE Performance After Append - Geometric Network

I had an odd thing happen today, I do almost daily appends to our fiber network (fiber, splices, etc) and usually, it goes smoothly and with no complications. For some reason, I had an Append stall ...
1
vote
1answer
213 views

Projecting features to Enterprise Geodatabase in Oracle gives ERROR 000210: Cannot create output

I am trying to project features from a geodatabase and write into an enterprise geodatabase connection. I have permissions to create data and the name I am using also works, but I keep getting error: ...
1
vote
2answers
788 views

Converting SDE.ST_GEOMETRY polyline to SDO_GEOMETRY with SQL: Why are there so many nulls?

I have a SDE.ST_GEOMETRY polyline FC in an Oracle 18c/10.7.1 geodatabase. I want to convert the SDE.ST_GEOMETRY shape column to SDO_GEOMETRY using SQL. Reason: So that I can do linear referencing ...
0
votes
2answers
167 views

Convert X & Y columns to a SHAPE column (using a method that would perform well in Portal)

I have a non-spatial table in an external system. The table has X & Y columns. The table will be synced to an Oracle 18c/10.7.1 geodatabase table or FC (via the ArcGIS REST API). There will be ...
1
vote
0answers
72 views

Pre-populating list in Survey123 using SQL Server column

What I currently have is a Survey which enters the data collected from the survey in a SQL Server table, I'd like for one of those columns in that table to become the choices in another survey. If ...
2
votes
1answer
178 views

ArcPy UpdateCursor: How to find specific row index of dictionary key/value difference?

I have a Python script that hits a REST API and grabs attribute data for rooms in buildings from an IBM Tririga DB. I have an Enterprise geodatabase rooms feature class populated with these same ...
1
vote
1answer
180 views

Use SDE.ST_GEOMETRY functions in a custom function

I have a dummy query where I generate an SDE.ST_GEOMETRY point: select shape as srid_test from ( select sde.st_geometry ('point (10.01 50.76)', 4326) as shape from ...
0
votes
0answers
30 views

Creating database connection using ArcCatalog

I'm using ArcCatalog 10.2.2 which is installed on a Windows 2019 Server OS. I'm having trouble creating a database connection. Usually this is a very straight forward process. Put in the server name ...
2
votes
1answer
431 views

Get midpoint of SDE.ST_GEOMETRY polylines?

I have a polyline SDE.ST_GEOMETRY feature class in an Oracle 12c geodatabase (10.7.1). I want to create a view on the feature class that has X and Y columns that contain the coordinates of the ...
2
votes
0answers
282 views

Duplicate Global IDs within same feature class

I received a geodatabase from a contractor and I observed there are multiple feature classes with column of Global ID type. These Global ID type columns, when I checked data i realized there are ...
1
vote
1answer
366 views

“Error 999999: Error executing function - Attribute conversion error” when running RegisterWithGeodatabase

I am using ArcPy to run through all of the spatial views in an enterprise GDB, register them with the GDB, and assign domains to the registered view. It runs great for most of the views in the GDB, ...
2
votes
1answer
261 views

Converting ArcSDE point data from image to MSSQL geometry

I have a bunch of points in an SDE table which is currently stored in an MSSQL database. The full entry is below, while the data i'm trying to convert from binary to geometry is: ...
1
vote
0answers
102 views

Backup of ArcSDE version

Is there any way how to backup particular version in ArcSDE geodatabase? I want to delete some versions from our geodatabase, but it would be great if I can create backup first and restore version ...
1
vote
1answer
52 views

Extract subtype codes and descriptions in a view

I have an Oracle 10.7.1 geodatabase that has tables and feature classes with subtypes. How can I extract the codes and descriptions from the subtypes in a view?
3
votes
0answers
69 views

Registered view gets buggy when database link added [closed]

I have a view in an Oracle 12c geodatabse: create or replace view parcel_vw as ( select p.* from parcel p left join for_gis.gis_locations@gistomax loc --<-- Join to database link ...
0
votes
1answer
32 views

Converted timezone does not display properly in ArcMap

(Oracle 12c geodatabase) I have a view that converts a UTC timestamp to Eastern Time using the from_tz function: create or replace view test_vw as ( select cast(rownum as number(38,0)) as rownum_, ...
5
votes
1answer
87 views

Get notification if feature service fails?

I have ArcGIS 10.7.1 feature services that occasionally fail/have errors. The feature services are used to integrate/sync records to a separate work order management system. As such, the broken ...
2
votes
1answer
65 views

Geodatabase to UML

I want to convert geodatabase to the UML diagram in order to analyze the relations and the attribute of the gdb file. Is there a method for this transformation?

1
2
3 4 5
28