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

Reading ESRI SDE data from network port 5151

I am performing a network vulnerability scan of an Android Automotive platform. My setup consists of a Kali Linux machine and an Android Automotive Infotainment System on a local network. During the ...
0
votes
0answers
12 views

ST_GEOMETRY: spatial column must appear immediately after spatial relationship function for spatial index to be used

The docs for SDE.ST_GEOMETRY have a blurb that says the following: When are spatial indexes used with ST_Geometry? ...the spatial column must appear immediately after the spatial relationship ...
0
votes
0answers
22 views

FME Oracle SDE Invalid column definition

I am using FME on daily basis working with sde feature classes. Sometime I am receiving data with more then hundred columns and when working I receive the following error. The error number from Arc ...
1
vote
1answer
22 views

ST_GEOMETRY points: get attribute of intersecting polygon

I have an SDE.ST_GEOEMTRY point feature class. I want to create an SQL query from the points. The query would perform a spatial join/intersection with an SDE.ST_GEOMETRY polygon feature class. An ...
0
votes
0answers
16 views

System tables that get INSERTS when registering object with Enterprise geodatabase (Oracle)

In ArcGIS Desktop, I can register objects with the geodatabase (Enterprise 10.7.1; Oracle 18c): Register with Geodatabase Register feature classes, tables, views, and raster layers that were created ...
0
votes
0answers
25 views

Problems with sde.next_rowid, ArcMap still uses 'old' values

Due to reasons beyond the scope of this question, I'm forced to import data into an SQL Server SDE database using SQL statements (importing using ArcGIS is not possible). The data already contains ...
0
votes
0answers
14 views

How does multiuser work with versioned ArcGIS?

I am new at versioned editing and am confused a bit and have some questions. For example I have five editor users and versioned dataset or featureclass. So, Should each editor create their own ...
0
votes
2answers
45 views

Creating feature class on ArcSDE schema with different user

I have created an enterprise geodatabase using ArcCatalog 10.5 on a PostgreSQL database. I have a database admin user named administrator and another user named sde. The geodatabase admin is sde user. ...
0
votes
0answers
27 views

Editing and Versioning with ArcGIS Rest API

I'm developing a web app with ArcGIS REST API. I created Version A from default version, made some edits on an event layer where I acquired locks for Route A, then deleted Version A. (The API I called ...
2
votes
1answer
42 views

Function-based spatial index: Use sdo_geometry() constructor instead of custom function?

I have an Oracle 18c table that has XY columns, but not a SHAPE column. I've created a query on the table that dynamically generates an sdo_geometry SHAPE column. sdo_geometry(2001, 26917, ...
3
votes
4answers
122 views

Materialized view with FAST refresh on remote table: How to include a SHAPE column?

I want to create an Oracle materialized view with the fast refresh option on a remote table (in an enterprise GDB). I can do this successfully without a SHAPE column: create materialized view log on ...
0
votes
1answer
35 views

How can a MXD point to a path that does not exist?

We work on ArcMap 10.6, and have MXDs using database connections (.sde files) that point to the C:\ of a user that no longer exists (e.g. C:\users\alpha\test.sde) and certainly, that path doesn’t ...
3
votes
1answer
38 views

Use multiprocessing to speed up rebuild index in ArcPy

We are in ArcGIS 10.6.1 (on Windows Server 2012) and Enterprise GeoDatabase Oracle 19c (on Linux). I was wondering if it is feasible to use the Python's ProcessPoolExecutor to open two separate Oracle ...
0
votes
1answer
78 views

Are XY event layers optimized/indexed on-the-fly?

Oracle 18c; 10.7.1 EGDB; ArcGIS Desktop 10.7.1 I have a non-spatial WORKORDER table that has X & Y columns. The table has 10,000 records. I’ve created an XY event layer from the table in ArcMap. ...
0
votes
1answer
43 views

SDO_GEOM materialized view: Why is static field slower than dynamic field?

EGDB: Oracle 18c; ArcGIS 10.7.1 External system: Oracle 12c I have a materialized view in an EGDB that syncs data from an external system (on a schedule via a dblink). The materialized view has an ...
0
votes
0answers
25 views

Materialized view breaks when registered with the GDB

EGDB: Oracle 18c/10.7.1 External system: Oracle 12c I have created a non-spatial materialized view in an EGDB that syncs data from an external system (on a 5 second schedule; via a dblink). It is ...
0
votes
1answer
39 views

ArcSDESQLExecute is not able to DELETE rows in one database but works in other

I have two ESRI enterprise geodatabases on SQLServer: A and B. They are almost the same database (structure) I have this code snippet in python to deleted several rows from versions: def ...
1
vote
0answers
34 views

Add Undo/Redo functionality in ArcMap to ArcPy script with manually started edit session

I've written a set of simple ArcPy scripts for use with ArcMap 10.5.1 in versioned PostgreSQL Enterprise geodatabases. They're loaded into an add-in toolbar and intended to be used like a speed dial ...
0
votes
2answers
30 views

Sync changes from view to feature class (using a GP tool; without fully replacing the data)

I have an ST_GEOMETRY view with 50,000 rows (in an Oracle 18c/10.7.1 geodatabase). The view references a WORKORDER table in an external system (via a dblink/Oracle 12c). Problem: The view is too slow ...
0
votes
0answers
17 views

After replacing table with updated data on Enterprise geodatabase, popups no longer work on Portal map

I have to do weekly updates on a table on SQL Server Enterprise geodatabase using Safe FME ETL Tool (drop/recreate). The table has the exact same name and exact same fields every time. When I do ...
0
votes
0answers
53 views

Creating database view in ArcMap

I have the following issue when using the Create Database View tool in ArcMap. My query runs fine in Microsoft SSMS and Visual Code (with mssql extension) against the enterprise geodatabase. But for ...
0
votes
1answer
32 views

arcpy.da.InsertCursor() Fails with SDE But Works with Local FGDB

I am trying to use arcpy.da.InsertCursor() to insert rows to an SDE table but no rows were added and without any error message. I tried the same code with an exact replica table in a local FGDB and it ...
1
vote
0answers
19 views

Data flow documentation tool

I am in the process of mapping the journey of our data through the different apps used by our service. We use an ArcSDE geodatabase as main data source. This data is viewed in ArcMap edited with ...
1
vote
0answers
45 views

Error 0x8004159D while loading data from PostGIS to ArcGIS Pro

I successfully connected to the PostgreSQL database, and I can see the tables/data. When I load one of the data (linestring data) it works well. But when I loaded the polygon data it prompted the ...
0
votes
0answers
38 views

SDE connections to geodatabase as schema owners not working properly

An enterprise GDB that was working fine seems to have gone wrong somewhere. When I connect to it as the system admin from ArcGIS Pro, I can see all the spatial data that is stored in the SQL Server ...
0
votes
1answer
62 views

ArcGIS Enterprise 10.8.1: Trying to create feature layer with referenced data in Python

I am trying to write a script that creates feature layers in ArcGIS Enterprise based on layers in an ArcGIS Pro Project. I do not want to copy the data to the server, only reference it. The data comes ...
0
votes
0answers
21 views

Automatically move points so that they don't overlap (reposition into cluster pattern)

I have workorder points in a SDE.ST_GEOMETRY feature class (Oracle 18c/10.7.1. geodatabase). I serve up the point feature class to an external system via a Map Service. Problem: The workorder points ...
0
votes
0answers
16 views

Editing EGDB data with Portal/Collector: Do error messages from the DB pop up in the app?

Oracle 18c; Portal/ArcGIS Server 10.7.1 I'm considering setting up Portal so that I can edit my on-premise EGDB data in the field using ArcGIS Collector. As part of this implementation, I would have ...
0
votes
1answer
72 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
31 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
24 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
29 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
104 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
53 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
27 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
36 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
79 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
115 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
26 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
40 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 ...
0
votes
0answers
16 views

What does the ArcGIS10.2 sde_state_id suffix 'L' mean in delta tables, when read using pyodbc in Python?

Enterprise geodatabase sits in MS SQL Server database. I'm using Python's pyodbc SQL driver to read SDE delta tables. I'm running the following query: select delete_table.SDE_STATE_ID, ...
-1
votes
1answer
85 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
38 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
48 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
43 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
16 views

Can I prevent Planarize from resetting Domain Values?

Is there some setting I have that is causing this or is this just a BUG in ArcMap? I'm using ArcMap 10.8 with an Enterprise Geodatabase. When I run Planarize on a pair (or more than 2) Road Centerline ...

1
2 3 4 5
28