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
0answers
28 views

Scheduled reports in ArcGIS Enterprise (emailed; condition-based)

ArcGIS Enterprise 10.7.1; Oracle 18c I want to set up scheduled tabular reports based on Oracle GDB data: The reports would run weekly on a server (not an individual's computer) Emailed to a list of ...
0
votes
0answers
10 views

ArcGIS - SQL Database - .iNumber tables [duplicate]

We have ArcGIS Enterprise in SQL and I see a lot of iNumber tables. I can't find information about what is the purpose, how they got created and do I need to delete them?
0
votes
0answers
14 views

Geodatabase doesn't export all features into XML workspace

I try to export the database into XML workspace and when I import the XML into a new geodatabase I find that some features of latest update are missing (at least what I have identified). I'm facing ...
2
votes
1answer
40 views

View has no records when viewed in ArcCatalog

I have created a database view in an Oracle-backed Enterprise Geodatabase. I can see data in both of them when I view them using SQL Developer. However, when I look at the view in ArcCatalog (version ...
0
votes
0answers
13 views

Registered Spatial View ObjectID field error

I am creating a spatial view in postgresql (geodatabase) and adding auto incrementing objectid field. I tried the following two ways to create it but in both cases once I register the view to the ...
0
votes
1answer
19 views

Share ArcGIS Desktop and Pro 2.7 with FME Desktop

Actually, I use FME 2020.2, ArcGIS Desktop and ArcGIS Pro on the same computer. FME uses the ArcGIS products to read/write the data in a Enterprise geodatabase. Since I installed ArcGIS Pro, I cannot ...
0
votes
0answers
15 views

Copying an object with attachments from a distributed database to a distributed one

I wrote a addins to transfer selected objects from one distributed database to another. Each layer participates in a geographic service (MapService). The program works successfully sometimes, and ...
0
votes
1answer
48 views

Delete row with specific text in a specific field at a specific time

I have a feature class that resides in an Enterprise geodatabase, I need to delete a row that has specific text in a specific field at a specific. Data is being submitted daily to this feature class ...
1
vote
0answers
27 views

Replacing ghost feature class in ArcSDE

I deleted SiteAddressPoint in the enterprise geodatabase. Now when I try to replace it I get an error that says it already exists. I have disconnected all connections and cleared locks. I have gone ...
0
votes
1answer
27 views

Connecting to ArcSDE without ArcPy license

Currently, I do not have a license for ArcMap and I am wondering if it is possible to get data from an ArcSDE without ArcPy. I have been able to leverage GDAL to read / write to a file geodatabase but ...
1
vote
0answers
14 views

QGIS does not recognize the CRS when the data is provided by SQLServer Database with Esri SDE

We have a MS SQL Server: Microsoft SQL Server 2016 database with SDE from Esri on Windows Server 2012 R2. Loading data into QGIS results in the QGIS unkown CRS dialog. If we don't select one CRS the ...
0
votes
0answers
24 views

Does Analyze Actually Do Anything?

I was taught that you need to 'Analyze' each dataset in enterprise databases as much as you can. It was one of those things that I just did, and which I never thought much about. However, I recently ...
0
votes
0answers
20 views

ALTER TABLE in SDE

Is it OK to change the text length of a column in a featureclass in SDE using SQL? Using ALTER TABLE <tablename> ALTER COLUMN <columnname> nvarchar(255); I wonder this because I found ...
0
votes
2answers
25 views

Select specific attribute from SDE.ST_Geometry UDT? (without using accessor functions)

Oracle 18c; ArcGIS 10.7.1 I have an SDE.ST_Geometry polyline feature class. As an experiment/learning exercise, I am trying to learn how to interact directly with the user-defined type (UDT) SHAPE ...
2
votes
1answer
16 views

What densification method does SDE.ST_Geometry use to approximate arcs as segments?

Oracle 18c; ArcGIS 10.7.1 I have an SDE.ST_Geometry polyline FC that has arcs. In a related post, we established that true arcs/curves are only available to ArcObjects, whereas the actual geometry ...
2
votes
1answer
35 views

Convert ST_POINT subtype to ST_GEOMETRY supertype?

Oracle 18c; ArcGIS 10.7.1 I have a query that produces an ST_POINT column: --Mimics the SDO_GEOMETRY get_vertices function --https://docs.oracle.com/database/121/SPATL/sdo_util-getvertices.htm ...
0
votes
0answers
23 views

Combine SDE Versions in a SQL View

I have two versions, from same base table, with only one feature class in both that I want to combine in a database view for a presentation. Version feature classes differ both with attributes and ...
2
votes
2answers
62 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
1answer
36 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
29 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
25 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
1answer
34 views

What system tables get INSERTS when registering object with Oracle EGDB (ST_Geometry)?

In ArcGIS Desktop, I can register ST_Geometry objects with the geodatabase (Enterprise 10.7.1; Oracle 18c): Register with Geodatabase Register feature classes, tables, views, and raster layers that ...
0
votes
0answers
56 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
16 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
136 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
35 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
50 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
5answers
148 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
36 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
39 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
82 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
51 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
36 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
56 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
35 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
32 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
18 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
99 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
48 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
23 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
61 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
56 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
93 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
23 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
89 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
38 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 ...

1
2 3 4 5
28