Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Make your voice heard. Take the 2019 Developer Survey now

Questions tagged [enterprise-geodatabase]

Use this tag for questions about the Enterprise Geodatabase (ArcSDE in earlier versions) component of ArcGIS for Server.

2
votes
1answer
28 views

How to hide certain views from ArcCatalog?

I have users that connect to an enterprise geodatabase via OS authentication. They use a couple of methods: An .SDE connection in ArcMap A ODBC connection for MS Office The users need to be able to ...
0
votes
0answers
16 views

Creating geodatabase, that has all layers used in creating map from different geodatabses?

I have been working on creating a city map, that had layers sourced to different gdbs stored on my desktop, now my final product is ready after 3 months and I have to package the datasets and send ...
1
vote
0answers
44 views

Reading .sde connection file without Esri softwares?

I would like to be able to read connection properties from an sde file without any Esri dependencies such as Arcpy, ArcObjects etc. Is this possible?
0
votes
0answers
10 views

Exception while trying to sync SQLite to featureserver by Esri Android API after deleting and recreating mapService

I've developed a sample app which has a downloaded SQLite file from sync enabled feature server. for no reason, the feature server stopped and in the Android app, the user couldn't connect to feature ...
0
votes
0answers
22 views

One or more objects failed to paste. Underlying DBMS ORA-00932 : inconsistent datatype

I am migrating all data from a geodatabse oracle to a new oracle schema. I'm trying to copy / paste between the two db connections, but it stops in the middle of the operation by displaying the ...
0
votes
1answer
26 views

Portal And ArcSDE Geodatabase: Feature Datasets or Not

We recently had a health check with an Esri representative, to look at our Portal system. After looking at our ArcSDE enterprise geodatabase she said it was organized very well with everything put ...
0
votes
0answers
18 views

Using OS authentication for users with period in name when editing PostgreSQL database from ArcMap?

I am trying to set up a PostgreSQL server to integrate our active directory credentials. I can edit the pg_hba.conf file to allow users with an internal IP to connect with OS authentication. host ...
1
vote
0answers
35 views

Understanding terminologies on Esri ArcSDE [closed]

I am new to ArcSDE. Can anyone help me understand the differences between versioning, replication, synchronization, archiving, editor tracking, and schema change? Their concepts are similar to me. ...
1
vote
1answer
35 views

Execute Oracle stored procedure from ArcSDESQLExecute

I'm attempting to execute an Oracle 12c stored procedure using ArcSDESQLExecute: import arcpy egdb_conn = arcpy.ArcSDESQLExecute(r"Database Connections\con1.sde") sql = '''execute update_sle (...
0
votes
1answer
29 views

Why shouldn't you edit in a replicated database

Say you replicate a database to another database. Are there any reasons you wouldn't want to edit your replicated data other than having different data in the replica database than in the database you ...
0
votes
1answer
28 views

ArcSDE Enterprise geodatabase compress error

My organisation has ArcSDE enterprise geodatabase(ArcGIS 9.2) with MS SQL Server 2008 as DBMS. When I compress the geodatabase I am getting the follwoing error Failed to compress the database. ...
0
votes
0answers
20 views

Does the geodatabase administrator login rebuild indexes for datasets not owned by the login?

According to the ESRI documentation, the Rebuild Indexes tool is used in databases and enterprise, workgroup, and desktop geodatabases to rebuild existing attribute or spatial indexes. In ...
1
vote
0answers
23 views

Add spatial index to versioned feature class

I try to add spatial index to versioned feature class (Oracle SDE) using toolbox "Add Spatial Index" in ArcGIS 10.6 . When I try it as Data owner I have error message -"Tool must be run as owner of ...
1
vote
0answers
27 views

Setting PostgreSQL privileges for ArcGIS?

I'm migrating from SQL Server and setting up my first PostgreSQL server for use with ArcGIS. I've followed esri tutorials and related how-tos. I'll be using a versioned editing environment, as I ...
0
votes
0answers
10 views

Deleting users and roles on ArcSDE for PostgreSQL geodatabase?

I can easily create users and assign them to roles using the context menus in ArcCatalog or the geoprocessing tools, but how do I delete users and roles? Do I have to go into pgAdmin?
1
vote
0answers
22 views

Considerations for projecting enterprise database to a new coordinate system

I currently maintain an enterprise geodatabase where the data is projected in a state plane coordinate system. Recently the data has extended past state boundaries. The data units are in feet and ...
0
votes
0answers
19 views

AddRastersToMosaicDataset_management performs slow

I have an enterprise Geodatabase (SQL Server) on my ArcGIS server machine. I perform my computations on several rasters on another machine (80 *.tif s with mean size of 50kb). When I want to add the ...
1
vote
0answers
29 views

Appending polygon features from file geodatabase table to SDE table?

I am facing an issue while appending the feature class to ArcSDE feature class. All the I am trying to append the gdb feature classs data, I can see that the geometry is either changed and some cases ...
0
votes
2answers
62 views

Connect QGIS to Esri geodatabase hosted on RDBMS (PostgreSQL)

I have an ArcGIS 10.5.1 enterprise geodatabase hosted on PostgreSQL 9.4 (non-PostGIS enabled, but with SDE.ST_Geometry support). I'd like to add some feature classes as layers in QGIS. How can I do ...
-1
votes
0answers
16 views

Storing feature linked annotations in different feature dataset to features?

In an sde geodatabase, we currently store feature-linked annotations in a different feature dataset than the features that the annotations are linked to. This is because we use a different projection ...
2
votes
0answers
22 views

ArcMap Date values lose precision after copying feature class from fGDB to SDE GDB

I have some data in a file geodatabase feature class including some date fields. The precision on the date fields is to milliseconds and this is important. When I copythe feature class from the fGDB ...
0
votes
1answer
34 views

Updating/modifying Network Dataset roads source in Enterprise Geodatabase (ArcSDE) using ArcPy?

I am trying to create a Python script that automate the update of roads source used in a network dataset stored in a Enterprise Geodatabase (SDE). In short, I want to truncate the roads feature class ...
1
vote
0answers
39 views

How to Create 'Update Triggers' to Track Field Values Changes When Data is Versioned?

How can I create a trigger to capture when a field is changed from one value to another if my data is versioned? I am not able to run an UPDATE trigger and grab ':new' and ':old' values because with ...
0
votes
0answers
22 views

Working with a small spatial extent from a large dataset in ArcMap

I am currently working with large amounts of forest data where surveyors and ecologists measure and assess the quality of the vegetation in the field and send the result as CAD files on a daily basis ...
-1
votes
2answers
31 views

Field mappings remove field from arcpyTable to Table conversion

I want to export a table but would like to remove one of the fields before doing so using arcpy. I'm trying to use field mappings but am missing something: fields = arcpy.ListFields("some_table") ...
1
vote
0answers
36 views

Import ArcSDE db to Postgres/PostGIS

Is it possible to import an ArcSDE db in PostGIS? I don't have experience with ArcSDE and then I don't have any idea to what is the data exportation format of this software. A customer asked me to ...
1
vote
0answers
26 views

Where is XSD file for XML found in Gdb_Items table?

I would like to be able to deserialize the xml in Gdb_items table using .NET. The xml in an sde geodatabase appears to be the same as the xml returned using the File GDB API. I tried using xsd.exe ...
0
votes
0answers
27 views

Invalid column value

I've been working on a script that corrects some links in a few feature classes in an enterprise database I have. The script works fine for the most part. When it gets to a certain feature class my ...
1
vote
1answer
27 views

Schema Locks Starting As Soon As User is Disconnected

I am having continual issues with scheme locks on our ArcSDE database, as soon as users are disconnected schema locks start appearing. We have 20 or so feature classes and it will show anywhere from ...
0
votes
1answer
36 views

Syncing database with ArcMap and ArcSDE?

I am using SQL in Oracle to fill and empty feature class table, basically something like this: INSERT INTO DAMO_W.BRUG (OBJECTID,CODE,NAAM,GLOBALID,SHAPE,CREATED_USER,CREATED_DATE,LAST_EDITED_DATE,...
1
vote
0answers
53 views

ArcPy not seeing ArcSDE datasets from IDLE or PyScripter? [duplicate]

I tested the code below from ArcCatalog 10.5's python console and IDLE+PyScripter. While in ArcCatalog everything works correctly(code is supposed to list available datasets and feature layers), in ...
1
vote
1answer
128 views

Multi client (QGIS.ArcGIS Desktop)/ multi-user editing environment [duplicate]

I'm using ArcGIS Desktop 10.6.1 with PostgreSQL 10.3/PostGIS 2.4 and would like to edit PostgreSQL polygon features regardless of client (QGIS/ArcGIS desktop) without having to create an ArcGIS ...
1
vote
1answer
41 views

Stop ArcGIS 'Geodatabase Adminstration' Reporting Connection as 'DBO' Instead of My Username?

We are running ArcGIS 10.5.1 and MS SQL Server, and using an SDE connection file which is configured to use 'Operating System' credentials. When most users connect, the 'Geodatabase Administration' ...
1
vote
0answers
36 views

ArcGIS PostgreSQL Trigger

I currently have a trigger defined in my database which executes when my edits in ArcMap are saved using the AFTER INSERT ON method. Is there anyway to execute this trigger without having to select ...
2
votes
1answer
37 views

Read SDE Feature Attributes without Arcpy

I've been building some software that reads/writes spatial and non-spatial data out of our SQL SDEs dynamically when called. As I've pointed out before Time Delay in Importing ArcPy , ArcPy takes ...
0
votes
0answers
74 views

Is it possible to connect Alteryx to feature classes in an Oracle based SDE?

I am using Alteryx Designer x64 with Spatial. I would like to connect feature classes from our enterprise database in the same way that I do with ArcSDE. I know that connecting to a file GDB, personal ...
0
votes
1answer
104 views

“Runtime error: cannot open workspace” after creating a connection file and changing the version [duplicate]

I'm trying to run an update cursor. Usually if I have an issue with databases with enterprise connections, making a connection file clears it up. This time when I tried to execute my code I just get a ...
1
vote
1answer
43 views

Creating Relationship Class- Adding new records to table

I am creating a relationship class inside an SDE Environment (SQL Server 2016). I have a point feature class and a related table. I am trying to add rows to the currently empty table based off ...
0
votes
0answers
77 views

ERROR 000582 - Create a checkout to a file GDB

We are encountering "Error 000582: Error occurred during execution" while executing a Python script creating a checkout replica. We were able to create the checkout replica successfully from ArcMap ...
0
votes
0answers
39 views

ArcMap PostgreSQL unique sequence

I have connected my ArcMap to my PostgreSQL db using the Create Enterprise Geodatabase tool in ArcMap. I have multiple feature classes and the relevant relationships between them loaded into the db ...
1
vote
0answers
46 views

Editing Spatial View in ArcMap?

Can spatial views be edited via ArcMap and, if it is possible, then how do I do it? I do have my Enterprise Geodatabase on Oracle.
1
vote
0answers
26 views

Cannot Create Topology in SDE

I am trying create a topology for a zoning dataset in my SDE feature dataset. I've run into a few issues. First off was an issue with versioning that this questions resolved: How to solve "Cannot ...
0
votes
1answer
60 views

Pirmary key constraint on objectid field

I am trying to copy data from a PostgreSQL (9.4) DB table to an SDE table. Both have an objectid field. If I copy the data from the source table with the OID field, I get an error because the values ...
0
votes
0answers
34 views

Sync-ing dynamic data stored locally with ArcGIS Online?

I'm using ArcGIS online to show the GIS data to my client on the web. I have a level 2 (editor) user and my client a level 1 viewer user. I'm trying to find a way to keep AGOL synced with my local DB (...
0
votes
1answer
15 views

MSSQL SDE_GEOMETRYnnn Tables

In my database, I've found a table (SDE_GEOMETRY276) with permissions granted to one user. My first thought was the "276" was either a layer_id or table registration_id. Searching sde_layers and ...
0
votes
0answers
33 views

Editing data in nonversioned ArcSDE for SQL Server geodatabase?

Is is OK to edit geometry and delete rows from a nonversioned ArcSDE geodatabase in SQL Server? According to http://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/editing-...
0
votes
0answers
19 views

Downloading ArcSDE export from government website and loading onto own ArcSDE?

I have an Esri ArcSDE export which I downloaded. I'm having trouble importing it. I assume we use the "Import XML Workspace Document" but I get an error AdvanceToElement: unable to find xml ...
0
votes
1answer
41 views

Accessing ArcSDE feature class with ArcPy?

I have a script that runs perfectly with shapefiles and GDB feature classes but I need to change it to run on feature classes stored on an SDE. However I cannot figure out how to reference them ...
1
vote
1answer
18 views

Retire Dataset with Its Relationship Class

I need to retire datasets from our SDE databases to our Retirement Geodatabase. There are several relationship classes tied to these datasets. How can I export the feature class with its relationship ...
0
votes
1answer
36 views

Do Postgresql sequences work with SDE versioning?

I am migrating data from an older GIS system into an SDE system with PostgreSQL as the database engine. The current system generates a unique tag for several layers, I want to re-create this behavior ...