Questions tagged [enterprise-geodatabase]
Use this tag for questions about the Enterprise Geodatabase (ArcSDE in earlier versions) component of ArcGIS for Server.
1,467
questions
0
votes
2
answers
32
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 ...
- 11
-1
votes
0
answers
13
views
Editing ArcSDE feature online through web app [duplicate]
I am working on building a web app where I would have a feature class from our ArcSDE. I want anyone in my organization to edit that feature class and want the changes to reflect on our ArcSDE too.
0
votes
0
answers
18
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,...
- 1
0
votes
0
answers
24
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 "...
- 39
0
votes
0
answers
20
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 ...
- 571
0
votes
0
answers
28
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 ...
- 3
0
votes
0
answers
24
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 ...
- 1
0
votes
0
answers
44
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 ...
0
votes
0
answers
38
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 ...
- 3,924
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
...
- 1,132
0
votes
1
answer
92
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,737
0
votes
1
answer
101
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
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,...
...
- 43
0
votes
1
answer
68
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
46
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
126
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,498
1
vote
2
answers
199
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
23
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
344
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,484
0
votes
0
answers
53
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
141
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,498
0
votes
0
answers
35
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
145
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
17
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
17
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
3
answers
243
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 ...
- 65.1k
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 ...
1
vote
0
answers
165
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,737
1
vote
0
answers
40
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
54
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
29
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
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 "...
- 125
0
votes
0
answers
214
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
240
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
2
votes
0
answers
75
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
70
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
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 ...
0
votes
0
answers
84
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 ...
1
vote
0
answers
49
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
89
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
121
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 ...
- 940
-1
votes
1
answer
62
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
116
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
74
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,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 ...
0
votes
1
answer
56
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 ...
- 387
0
votes
1
answer
193
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
60
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
808
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
45
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