Questions tagged [enterprise-geodatabase]
Use this tag for questions about the Enterprise Geodatabase (ArcSDE in earlier versions) component of ArcGIS for Server.
1,460
questions
0
votes
1
answer
57
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 ...
- 4,597
0
votes
1
answer
30
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 ...
0
votes
0
answers
18
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,...
...
- 43
0
votes
1
answer
30
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 ...
- 19
0
votes
0
answers
39
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?
- 59
1
vote
0
answers
40
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 ...
- 1,496
1
vote
2
answers
96
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 ...
- 41
0
votes
0
answers
17
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 ...
- 1
0
votes
1
answer
210
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 ...
- 1,474
0
votes
0
answers
41
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 ...
0
votes
1
answer
86
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(...
- 1,496
0
votes
0
answers
28
views
named_version is not deleted using ReconcileVersions function
I am using below function to enter rows in table (branch versioning). My idea is to create a named version, submit the changes, reconcile and post it. After posting, named_version should be deleted.
...
- 11
1
vote
0
answers
108
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 ...
- 43
0
votes
0
answers
14
views
Hitting REST Feature services via console app (C#)
I have a console app that currently leverages arcObjects through a desktop license.
We are going to need it to transport data to and from a traditional versioned gdb to and from feature services along ...
- 213
0
votes
0
answers
15
views
How to use ArcSDE to extract raster value (equivalent to PostGIS ST_Value function)
Is it possible to use ArcSDE SQL functions to extract a raster value from a vector point in a database (Oracle/PostgreSQL/SQL Server) with ArcSDE, and if so then how?
I want to use SQL to do this, ...
- 713
2
votes
2
answers
176
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 ...
- 65k
0
votes
0
answers
23
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 ...
1
vote
0
answers
103
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 ...
- 4,597
1
vote
0
answers
33
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 ...
0
votes
1
answer
45
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 ...
0
votes
1
answer
22
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\\...
- 141
0
votes
0
answers
32
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 "...
- 115
0
votes
0
answers
133
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 ...
- 1
1
vote
0
answers
184
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 ...
- 588
0
votes
0
answers
31
views
SQL Server ArcSDE spatial index behavior
Does anyone know if there is harm in bypassing the ESRI GUIs and simply rebuilding the spatial index on a feature class natively via SQL Server?
When attempting to do so via the GUIs, there is a ...
- 2,018
2
votes
0
answers
56
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 ...
- 1,094
0
votes
0
answers
53
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 ...
2
votes
0
answers
40
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 ...
0
votes
0
answers
65
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 ...
0
votes
0
answers
229
views
ArcGIS Pro (3.0.4) "Share as web layer" fails with error 00231, despite the database already being registered as an ArcGIS Server data store
I have a PostgreSQL database instance running in the Azure Database for PostgreSQL service. I am able to successfully connect, create enterprise geodatabases within, and load feature classes. I am ...
- 91
1
vote
0
answers
36
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.
...
- 11
1
vote
0
answers
75
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 ...
0
votes
1
answer
81
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 ...
- 930
-1
votes
1
answer
56
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 ...
- 21
0
votes
2
answers
70
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:\\...
- 782
0
votes
2
answers
65
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 ...
- 1,114
0
votes
1
answer
32
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 ...
0
votes
1
answer
47
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 ...
- 287
0
votes
1
answer
152
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 ...
0
votes
0
answers
57
views
ArcPy comparing two databases and deleting and appending data from one to another
I currently am working on trying to ingest data from a client into our database. The schemas are almost the same so I want to compare feature class to feature class and want to delete and append the ...
0
votes
1
answer
629
views
Trying to use Python to copy feature datasets with many feature classes from an enterprise database to a file GDB
I'm trying to write a basic script that will take all the feature classes in every feature dataset in an enterprise geodatabase and copy to a file geodatabase.
import arcpy
from arcpy import ...
- 1
0
votes
1
answer
40
views
ESRI GEodatabase - LRS Metadata. Where to find it using SQL?
Prior, (I can confirm in version 2.4), I could check the LRS metadata using a query to the LRS_METADATA table in a Enterprise geodatabase.
I used to have this script
import xml.etree.ElementTree as ET
...
- 782
1
vote
1
answer
361
views
Extracting data shown in Version Changes on Branch-Versioned feature service before reconcile/post process using ArcGIS Pro [closed]
Currently there is no way to export version changes on feature service in ArcGIS Pro as a change report. Preferably a Python script to extract the details about version changes on a branch-versioned ...
- 11
0
votes
0
answers
165
views
Enterprise geodatabase maintenance Esri vs. SQL Server (rebuild index and update statistics)
I'm looking at two geodatabase maintenance practices and seeing if they need to be updated/refined, and I'm noticing that these can be accomplished via ESRI tools or directly via SQL / within SQL ...
- 11
1
vote
0
answers
91
views
Cursor script runs but not updating value
I have a script I wrote to use an update cursor to change any records in a feature class that has a field set to 'N' to 'Y'(coded domain values). I have ensured that the database connection file is in ...
- 11
0
votes
1
answer
282
views
Joining tables with GROUP BY in ArcGIS Pro
I have a layer "Table1" and an attribute table "Table 2" both stored in a PostgreSQL enterprise geodatabase, these 2 data have one field in common for which the cardinality of the ...
- 183
1
vote
1
answer
314
views
Using ArcPy to overwrite one SDE feature class with another SDE feature class (from different SDE)
I am a beginner with Python and ArcPy.
I am trying to write a Python script that will overwrite the viewer copy of our data with the most recent editor copy. Here is the code I am running through the ...
- 75
0
votes
0
answers
89
views
ArcGIS Oracle bulk update using spatial join
I am trying make bulk update the table using a spatial join which has millions of records,
updating the ID from Parcels layer to the Park (Points) layer using Oracle SQL query, I used geometry ...
0
votes
1
answer
82
views
Workspace generated unreadable characters
I am running a workspace on FME Server and I see that most of the columns have unreadable characters in them after running a workspace. I have not seen this before. Workspace is incorrectly writing ...
- 29
0
votes
0
answers
173
views
Branch versioning in ArcMap
We have a people that only use ArcMap. We have a project created in ArcGIS Pro, which obviously supports branch versioning.
How can we allow those using ArcMap to edit the ArcGIS Pro project ...
