Skip to main content

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
1 answer
48 views

Get "not data owner" error when execute register with geodatabase even I connect with the owner user in ArcGIS Pro

I am using ArcGIS Pro and connecting to a PostgreSQL database. I have enabled the database as Enterprise Geodatabase and it automatically creates a user "sde" for my PostgreSQL database. ...
kgs-tliu's user avatar
0 votes
0 answers
16 views

ArcPy automated compression 'A check constraint violation has occurred. [sde.DEFAULT]'

We have an automatic Python script for ArcMap 10.8.1 which compresses our database nightly after employees have finished their work. We're getting this error preventing the automatic script to run, we ...
megabytes's user avatar
0 votes
0 answers
9 views

Auto populating X and Y in Esri Enterprise

I have created a point layer in ArcGIS Enterprise with the intention of collecting Latitude and Longitude data of points to be collected. Is there a way to set the layer so that it populates the X and ...
Isaac Bowling's user avatar
0 votes
1 answer
39 views

Edits going Straight to DEFAULT instead of remaining in own version when using Reconcile and Post

We have user doing Traditional Versioning in ArcGIS Pro. User has enough access to make Edits, Reconcile & post to own version which Esri recommends. But when user is making Edits in Feature Class ...
SQLLogic's user avatar
0 votes
0 answers
19 views

Get vertex of SDE.ST_GEOMETRY polygon using SQL

Oracle 18c 10.7.1 EGDB: I want to write a SQL query that has rows with the XY coordinates of each vertex of an SDE.ST_GEOMETRY polygon feature class. I can do it for a line FC using a cross join, a ...
User1974's user avatar
  • 1,132
0 votes
1 answer
17 views

ST_GEOMETRY SQL function to find problem annotation shapes

ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB; SDE.ST_GEOEMTRY: I have a issue with an annotation feature class: In 2.9.12, I get a "shape integrity error" when I open the attribute table and ...
User1974's user avatar
  • 1,132
0 votes
0 answers
15 views

Exception while getting versioned table differences from an SOE

I have an SOE "Server Object Extension" The exception happens when I call versionedTable.Differences(). Exception message "Value does not fall within the expected range." No idea ...
ZZZ's user avatar
  • 573
0 votes
2 answers
49 views

Workspace is of wrong data type - ArcPy

I am trying to run this script inside of python in ArcGIS Pro to reconcile saved edits and post them to the default database (around line 7). I keep getting this error message "workspace is of ...
George's user avatar
  • 11
0 votes
0 answers
21 views

Appending SEDF (or arrow table) to Enterprise Feature Class

I have a Notebook that takes a Civil 3D CAD .dwg and converts it to a spatially-enabled dataframe. I want to take that dataframe and append it to an existing feature class in an Enterprise DB. However,...
R_ww_D's user avatar
  • 1
0 votes
0 answers
45 views

FME - Specify schema name in PostgreSQL database writer (ArcSDE)

I am attempting to transfer data from a file geodatabase into an enterprise geodatabase (PostgreSQL) using FME. By default, the writer copies it into either the "public" schema or the "...
RMT's user avatar
  • 39
0 votes
0 answers
24 views

Meaning of sde.DEFAULT in data source path: sde.DEFAULT (user@server_name:database_name)

I've pulled some MXDs into ArcGIS Pro that are using data from a very old PostgreSQL (9.3) server. The database looks to be set up with an sde schema. I don't think it was actually implemented ...
MKF's user avatar
  • 571
0 votes
0 answers
32 views

Load large amount of data to an ArcGIS Enterprise Geodatabase

I have a large amount of geospatial data stored within a File Geodatabase, currently, the GDB is 58 GB. I need to load this data into an Oracle Enterprise database. Considering that the Append tool in ...
Makita's user avatar
  • 3
0 votes
0 answers
30 views

How to compress only SDE.DEFAULT version of a geodatabase?

I'm new to GIS administration, specifically geodatabase administration. When I started my current job, the previous administrators had performed a partial compression of the SDE geodatabase. I work ...
IvanovIN's user avatar
0 votes
1 answer
53 views

Hosted layer in ArcGIS not getting updated

I'm encountering a peculiar issue while trying to add records to a Hosted Layer in ArcGIS using Python. I am using ArcGIS Pro 3.1.3 with ArcGIS Enterprise 11.1. I am running this code from the Jupyter ...
Mir Muhammad Murtaza's user avatar
0 votes
0 answers
41 views

ArcGIS REST query result order is random

What I try to do a identify operation on a polygon dataset in a ArcGIS REST MapService. For obscure reasons I can't change, the order of the results is important. To achieve this, the data is written ...
nielsgerrits's user avatar
  • 3,946
0 votes
0 answers
18 views

Access control point vertices using SQL

ArcGIS Pro 3.2.1; Oracle 18c 10.7.1 EGDB; SDE.ST_GEOMETRY Regarding control points: Video: Suppress symbol effect in ArcGIS Pro Introduction to control points CIMGeometricEffectAddControlPoints Class ...
User1974's user avatar
  • 1,132
0 votes
1 answer
116 views

Register a view in ArcGIS returns error 999999

I have created a view in an enterprise geodatabase (SQL Server) using arcpy.management.CreateDatabaseView. It shows correctly in ArcMap, and now I want to register it properly. I have done this many ...
Berend's user avatar
  • 4,757
0 votes
1 answer
150 views

How to add a field to an enterprise geodatabase feature class

I need to add a field to a feature class in my enterprise geodatabase, I haven't needed to add a field since my company switched to ArcGIS Pro. I can't add a field from the attribute table. I'm ...
Taylor Roberts's user avatar
0 votes
0 answers
26 views

10.3 SDE/Enterprise Geodatabase MS SQL missing expiry code in AUTH_key trying to Upgrade to 10.8

I am trying to upgrade a 10.3.1 Enterprise Geodatabase to 10.8. I come across a potential problem. I checked the SDE_server_config table to view AUTH_KEY and it says: arcsdeserver,101,ecp#,none,... ...
Alex's user avatar
  • 43
0 votes
1 answer
114 views

How to use Python to update enterpise geodatabase user connections for layers within an ArcGIS Pro Project map

I tried to use the following code to update the connected database user for layers within an ArcGIS Pro project map. The code runs but it does not change the data sources from one enterprise ...
Nicole's user avatar
  • 19
0 votes
0 answers
52 views

Set up SDE Raster Dataset alias layer name

Is it possible to set up SDE Raster Dataset alias layer name? Like it does in feature class?
Evemar's user avatar
  • 59
1 vote
0 answers
171 views

How to add new row to a related table (with Relationship Class) in ArcGIS Pro using Pro attribute table

I have a FC called Schools.SDE.Schools and a Table called Schools.SDE.Maintenance and there is a Relationship class between them called Schools.SDE.Schools_Maintenance Now using the Attribute Pane I ...
user1106951's user avatar
  • 1,498
1 vote
2 answers
259 views

Branch version editing in ArcGIS Online

I'm trying to figure out if you can publish a particular version for users to edit on an ArcGIS Online map in a branch versioned environment. It doesn't look like there is a way to select the version ...
benjip's user avatar
  • 41
0 votes
0 answers
24 views

Geometric Network and Replicas in Enterprise GDB

Are we supposed to use the split tool in a replica of geometric network gdb? When a consultant sends back the gdb and we sync it to the parent it throws a geometry error for the newly inserted ...
GISdude's user avatar
0 votes
1 answer
445 views

How to run Create Enterprise Geodatabase on PostgreSQL flexible server

I am using: Azure Database for PostgreSQL flexible server - version 13.10 ArcGIS Pro (advanced license) - version 3.1.2 The ESRI documentation lists this version of PostgreSQL flexible server as ...
Kelly Thomas's user avatar
  • 1,484
0 votes
0 answers
55 views

Sharing elevation layer to ArcGIS Online

I have a problem sharing a ground layer to ArcGIS Enterprise as elevation layer. My data is a raster from a database and I try to share it using "share as web layer". but the option is ...
Kunta Syah Thariqa's user avatar
0 votes
1 answer
171 views

Which parameter data types in a Python toolbox for selecting a path

I need to select a SDE PATH based on user selection on Python toolbox at ArcGIS Pro 2.7.1 and use this path at the code for setting like fc = 'Zone' SDEDir = inputPath arcpy.management.CalculateField(...
user1106951's user avatar
  • 1,498
1 vote
0 answers
159 views

Listing Schema Locks on SDE from arcpy

In ArcGIS Pro, if you right-click on a .sde file > Administration > Locks, you see a list of feature classes that currently have an active lock. Is it possible to get this list via Python, such ...
DeltaKilo's user avatar
2 votes
3 answers
280 views

Getting SQL that defines Query Feature Class using ArcPy with ArcGIS Pro

A map in my ArcGIS Pro 3.0.3 project has a layer with a Query Feature Class as its source. I can see the SQL that defines the Query Feature Class by looking at its Layer Properties. That SQL is ...
PolyGeo's user avatar
  • 65.2k
0 votes
0 answers
29 views

Trying to run TableToTable tool to export view from SQL server database to enterprise SDE in standalone Python script

I’m trying to export a view from an SDE connection to a SQL server database to new table in an enterprise SDE database. Both are saved as SDE connection files on a file share. I’m getting ERROR ...
TylerArmstrong's user avatar
1 vote
0 answers
182 views

Database trigger does not work with ArcGIS featureservice

I have set a database trigger on a featureclass in a (PostgreSQL) geodatabase that calculates one field. This works fine when editing in ArcMap or ArcGIS Pro, but when I insert a new record through a ...
Berend's user avatar
  • 4,757
1 vote
0 answers
46 views

ArcGIS Pro won't export unique identifier of View table to table

I have a view on a SQL Server enterprise SDE, with fields LocationID, RecordCount, Min, Max, etc. Just basic stats generated from another table. When I import the view into a map project, I choose ...
Mr. Geologist's user avatar
0 votes
1 answer
59 views

Importing a NAIP SID file into a geodatabase 10.5 results in the image being washed out

When importing a NAIP SID image into a geodatabase 10.5 the resulting image is washed out. I tried building pyramids and calculating statistics and did get some improvement yet the resulting image is ...
Leif Farr's user avatar
0 votes
1 answer
30 views

Error in Python script while executing through enterprise geodatabase (working fine FGDB) [closed]

I have the following script: workspace = r"D:\\Python\\Cend.gdb" MEGIS_ELECTRIC_CircuitSource = "CircuitSource" Fc = "ElectricDistribution\\...
Rpandia31's user avatar
  • 141
0 votes
0 answers
39 views

Revoke permissions to data granted to user SDE gives "Invalid use of GRANT/REVOKE function" error

I inherited an Oracle geodatabase where user SDE was granted indiscriminately to data in other schemas. I would like to revoke the privileges, but for some feature classes/datasets I am getting "...
mfrancis's user avatar
  • 125
0 votes
0 answers
279 views

ArcGIS Pro Troubleshooting Feature Dataset- some layers not drawing

I have an enterprise geodatabase with multiple feature datasets. I have one feature dataset that will not load any of the feature classes. One work around is to copy/paste the needed layer multiple ...
Megan's user avatar
  • 1
1 vote
0 answers
258 views

Getting count of intersect in Arcade attribute rule in enterprise geodatabase

Having two feature classes in an enterprise geodatabase like - EGDB.North.Parcels - EGDB.North.ProjectsInvest I am trying to get the total count of Intersection between EGDB.North.Projects in ...
Suffii's user avatar
  • 588
2 votes
0 answers
87 views

Coded Values/ Domain like with GeoServer and PostGIS

Coded Values in oralce SDE are exposed trough ArcGIS Server as Coded Values in the REST API. This ArcGIS Server REST API can provide the coded values to a webmap client to create a form with a drop ...
jlSta's user avatar
  • 1,096
0 votes
0 answers
77 views

PostgreSQL identity/generated columns do not work with Append to Esri Enterprise Geodatabase

I want to set a column as an integer primary key separate from what Esri maintains. This is so it can exist in non-spatial tables and the features retain the key as they exist across other tables. The ...
Andrew Nelson's user avatar
2 votes
0 answers
43 views

Is there any PostGIS st_makevalid equivalent for use in Esri's sde.st_geometry?

I am inserting into an Enterprise Geodatabase (Postgres running sde.st_geometry). I am encountering errors on inserts when a multipolygon has parts with a zero-area. I know of Desktop's Repair ...
Andrew Nelson's user avatar
0 votes
0 answers
89 views

ArcGIS Replica creation is too slow

I am trying to create a new Replica from my Oracle based SDE database. Its takes more than 24 hours to create a 23 GB replica which is practically not working for me. Is there any specific reason for ...
Abhishek koundal's user avatar
1 vote
0 answers
50 views

Moving points to new coordinates (arcpy.data.editor)

I have a versioned enterprise geodatabase. I need to move some points to new locations, which are in the attribute table. This script runs, but it doesn't seem to actually move any of the points. ...
LLCCG's user avatar
  • 11
1 vote
0 answers
98 views

Enterprise geodatabase connection feature geometry invisible in ArcGIS Pro

I have a database connection made to my PostgreSQL enterprise geodatabase through ArcGIS Pro. I can not see the geometry of the layer through ArcGIS Pro. I am connected to the database as a user other ...
Andrew Nelson's user avatar
0 votes
1 answer
142 views

The view from PostGIS isn't rendered in ArcGIS Pro 3

I'm using ArcGIS Pro 3 with an Enterprise DB based on PostgreSQL/PostGIS. After the upload on the DB of a polygon layer, I've created a view using DBeaver for dissolve some polygons. CREATE VIEW ...
MaxDragonheart's user avatar
-1 votes
1 answer
78 views

Mapping predecessors and successors, and visualizing it all

I have a current project that involves relocation of hundreds of utilities. Before a utility can be relocated, there are several utilities lines that that have to relocated prior (predecessors). We ...
user173714's user avatar
0 votes
2 answers
139 views

ArcSDESQLExecute is not able to handle unique identifiers

Using ArcGIS Pro 2.9.5 I found that ArcSDESQLExecute is not able to handle unique identifiers (UNIQUEIDENTIFIER) a.k.a GUIDS, in a table. I tried to run the following Script: database = 'C:\\...
XtianGIS's user avatar
  • 782
0 votes
2 answers
78 views

List of numeric default values using SQL

Oracle 18c 10.7.1 EGDB: I have fields in feature classes and tables that have numeric default values. How can I get a list of the default values using SQL? I believe the default values are stored in ...
User1974's user avatar
  • 1,132
0 votes
1 answer
38 views

Unable to Get Lat Lon from PostGIS point table

I am facing issue to get lat/lon from point table. I have two point table with different spatial reference and I am able to get lat/lon from nce_gis_table while I apply same query to another point ...
kawish abbas's user avatar
0 votes
1 answer
62 views

ArcGIS Enterprise: Layer Registered as versioned issues

I want to publish a feature service from an Enterprise file geodatabase to Portal yet when I try to validate the layer in ArcGISPro I get error 00231. I checked the feature dataset in which the layer ...
GISMapper's user avatar
  • 387
0 votes
1 answer
211 views

Cannot open enterprise geodatabase table from workspace

I'm trying to create a REST Flask API to use instead of geoprocessing with the toolbox. Using the ArcGIS Python environment, I was able to make use of the libraries in Flask, but I'm facing a problem ...
Marco Antônio de Lima Costa's user avatar

1
2 3 4 5
30