Questions tagged [enterprise-geodatabase]
Use this tag for questions about the Enterprise Geodatabase (ArcSDE in earlier versions) component of ArcGIS for Server.
1,351
questions
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 ...