Questions tagged [versioning]

In databases, an alternative state of the database that has an owner, a description, a permission (private, protected, or public), and a parent version.

Filter by
Sorted by
Tagged with
0
votes
1answer
26 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
0answers
46 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 ...
0
votes
0answers
23 views

Under what circumstances would the _DELETE trigger get called? (_EVW)

Oracle 18c/10.7.1 geodatabase: When an FC is registered as versioned (with option to move edits to base), several triggers get automatically created: V000001_DELETE V000001_INSERT V000001_UPDATE ...
2
votes
2answers
101 views

Prevent deletes in a versioned table at the database level

I have a table in an Oracle 18c/10.7.1 geodatabase. The table is versioned with the option to move edits to base. As far as I can tell, it's not possible to prevent ArcGIS Desktop users from deleting ...
1
vote
0answers
32 views

Missing 'Expression' option in 'Random Points in Polygon' tool

I am running QGIS Desktop version 3.8.2 I need to use the 'Random Points in Polygon' tool as part of a process. The number of points per polygon is defined by one of the fields so I simply add that ...
1
vote
0answers
37 views

Are there any examples or tutorials showing Branch Version editing with ArcGIS Server JavaScript API?

I am trying to implement branch versioning in an application that I'm building using the ArcGIS Server JavaScript API. I found a blog post showing how to edit branch-versioned data in ArcGIS Pro, and ...
1
vote
0answers
36 views

ArcSDE version status stuck in 33554433

One of our ArcSDE versions (esri v10.1 and oracle 11g) in SDE.Versions table shows a 'status' field value of 33554433 instead of the usual 0, 1, 2 for private, public, protected. I understand this is ...
0
votes
0answers
26 views

Why utility network layer is not versioned?

I am working with an ArcGIS Pro Utility network. I have published the Utility network dataset from my Enterprise database to ArcGIS Online. Prior to publishing, I have added global Id's, enabled ...
2
votes
1answer
20 views

How store feature changes with geotools?

I stored a vector layer in postgis and I can add, remove or update featues successfully. Now I want to store feature change log(This means if a feature property changed, we can access new and old ...
-1
votes
2answers
39 views

Cannot figure out what is wrong with my code [closed]

I am trying to create a code that will make a new version of a feature class and then geoprocesses some stuff per feature layer. However something in my code is going wrong and I can't figure out for ...
0
votes
1answer
53 views

Do feature classes need to be versioned for editing with ArcGIS Collector/feature service?

I have an Oracle 18c/10.7.1 geodatabase with feature classes that have the following properties: Unversioned SDO_GEOMETRY datatype Registered with the GDB My organization plans to serve up the ...
2
votes
1answer
55 views

Listlayers, but exclude group names/feature dataset names with Arcpy

I am looking for a way to loop through all the feature classes (feature layers) within a mxd, to then use some geoprocessing tools on them. Before I run these geoproccesses, the script needs to change ...
0
votes
0answers
115 views

Getting “Workspace Already in Transaction Mode” Error when trying to use updateCursor on versioned sde

There are are numerous post on this error, but I can't seem to find a solution for myself. We have a versioned sde and need to add new fields to some of our feature classes and populate them with an ...
1
vote
0answers
39 views

Updating field from table used as source in network dataset

I have a Feature Dataset that contains a Network Dataset and a Feature Class (as a source of Network Dataset) in enterprise geodatabase (PostgreSQL). The Feature Dataset is versioned because we want ...
0
votes
0answers
14 views

Database Population in wrong Authentication Type

I've populated a database while connected to it as an editor with an Operating System Authentication Type. I should have populated it while connected to the Database as the GIS administrator with a ...
1
vote
0answers
38 views

Feature Class Update Trigger with Archiving

We are deploying Collector in our institution and for offline work on unversioned data we need to enable archiving. The feature class needs some updates when the user enters new records using the ...
1
vote
0answers
64 views

Backup of ArcSDE version

Is there any way how to backup particular version in ArcSDE geodatabase? I want to delete some versions from our geodatabase, but it would be great if I can create backup first and restore version ...
1
vote
2answers
116 views

Why do arcpy.GetCount_management and arcpy.ArcSDESQLExecute yield different row counts?

I was benchmarking which method was faster for counting the number of rows in a table, when something curious happened: import arcpy import os import time test_tuple = ("path\to\connection", "...
0
votes
0answers
14 views

Prevent row deletion in versioned tables: Put the functionality in ArcMap?

In a related question, I asked how to prevent rows from being deleted from versioned tables using database privileges. Unfortunately, this does not seem to be possible. As an alternative, is there a ...
1
vote
2answers
79 views

Prevent row deletion in versioned tables using database privileges

I have versioned tables in an Oracle geodatabase (versioned with the option to move edits to base). I would like to prevent users from deleting rows from the tables when using ArcGIS Desktop. (With ...
2
votes
1answer
103 views

File Geodatabase and Versioning

I'm trying to setup a versioned database to a small office and was wondering whether ESRI's File Geodatabase has that type of capabilities? Researching the topic I found conflicting data from ESRI's ...
1
vote
0answers
44 views

How to transfer data from a version to default version in ArcMap? [closed]

I have lost all data from default version and also from the base tables in Oracle. But luckily, there is a version that has all the data in it. I have reconciled and posted that version to default but ...
1
vote
0answers
26 views

Geodatabse Compression does not make changes in Base Tables [closed]

This question has been asked here GDB Compression Not Updating Base Tables, but the solution provided is not what I am looking for. I have registered a feature class and made some edits in that ...
2
votes
2answers
194 views

How to make ArcMap aware of the changes that are made in base table? [duplicate]

I am using ArcMap One-way replication tool to synchronize feature classes from Oracle to MS SQL Server (once a day), but replication only works for the versioned data with move edits to base option as ...
1
vote
0answers
59 views

Versioning in PostGIS on PostgreSQL database [duplicate]

I have a cadastral database which requires multi-user editing/updating on daily basis. I am trying to migrate from Esri enterprise geodatabase to PostGIS/PostgreSQL. I am not sure PostGIS offers ...
2
votes
0answers
37 views

Editing Parcel Fabric in Versioned Geodatabase

We keep our parcel fabric in a SDE database with an intermediate staging version that multiple users post changes to from their own personal edit versions. We're able to edit the parcel fabric ...
1
vote
0answers
190 views

Recovering accidental edits through ArcGIS Pro Version Changes window?

We have a situation with our ArcSDE where features were accidentally deleted inside a version and we would like to recover those changes. We cannot undo edits because they were saved in a previous ...
0
votes
1answer
229 views

Changing version with arcpy

I am looking to change versions of an .sde through Arcpy to then afterwards, run a few geoprocesses on it. I do not want it to automatically update after that. So far I have managed to create a ...
1
vote
2answers
111 views

Refreshing Versioned Feature Class using ArcObjects?

I have a FeatureClass A. This Feature Class is Versioned. User X has a tool open, that reads records from this Feature Class, by clicking a refresh button. The refresh button code is basically a ...
1
vote
0answers
36 views

Using primary key in ArcSDE Enterprise Geodatabase with MS SQL Server?

Does setting a primary key constraint in a field obstruct the compression of a versioned geodatabase? I read someone mentioning that the primary key in a versioned geo-database will cause problem ...
1
vote
0answers
63 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
0answers
260 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 ...
2
votes
0answers
93 views

Versioning with Oracle Workspace Manager in QGIS?

I'm working with a workspace enabled oracle database. Through the database connection properties in QGIS meanwhile it is possible to set the workspace or version. So I can edit my spatial data in a ...
1
vote
0answers
89 views

How export geodatabase version differences in ArcPy?

With ArcObjects I have this code in C# to export the differences to a XML file: ESRI.ArcGIS.GeoDatabaseDistributed.IVersionDataChangesInit pVDataChgs; var pvTemp = new ESRI.ArcGIS....
0
votes
1answer
64 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 ...
0
votes
1answer
242 views

Access geodatabase simultaneously by several users

We have a requirement to edit a Geodatabase simultaneously by several users. We have several GIS specialists who are loading the data at the same time and each time we have to copy paste the data ...
0
votes
0answers
64 views

How to undelete from ArcGIS versioned table?

We have a versioned table of polygons and one of our users have deleted every geometries. With Oracle's SQL Developer, i can see the table still containing the missing data, along with its Axxxx and ...
0
votes
0answers
70 views

Versioning error when creating a Topology on a File GDB

Im having an issue with the 99999 Error. Im creating a Topology dataset for each of the featureclasses within a GDB. For some reason my script works for some feature classes and errors on others. I ...
3
votes
2answers
1k views

Spatial Data Version Control or Versioning Software [duplicate]

I have a lot of shapefile or fgdb feature classes that I am working with now and it gets updated almost every month. As of right now, I am just making the file name with extra name after '-' (i.e., ...
0
votes
0answers
193 views

Deleting ArcMap Versions using Arcpy

The versionName "JNMILLER" won't delete. Any idea why it's not finding the name? Terminal: ================= RESTART: C:\Users\jnmiller\Desktop\test.py ================= Found - "EGAS\JMEESE" ...
1
vote
1answer
205 views

Creating ArcMap Versions using Arcpy

Why doesn't the script break if the Version exists? Traceback (most recent call last): File "C:\Users\jnmiller\Desktop\Create User Version.py", line 30, in arcpy.CreateVersion_management(...
2
votes
1answer
109 views

Pasting features into a feature class doesn't honour subtypes

I'm encountering an issue where features that I'm copying from a feature class in a file geodatabase are all going to a single subtype when I paste them in the destination feature class in an ...
0
votes
1answer
436 views

Query for tables that are not registered with option to move edits to base

I have an Oracle enterprise geodatabase. In theory, all 500+ tables in the database should be registered as versioned, with the option to move edits to base. However, it has come to my attention that ...
2
votes
1answer
65 views

Visualize Polygon Changes

I've unfortunately experienced a version control issue between offices where one person was editing an older version of a polygon shapefile. Now I need to reconcile those edits into the current ...
4
votes
1answer
115 views

ArcGIS database feature class editor default version settings

I created an enterprise geodatabase with ArcCatalog 10.5 in my PostgreSQL database. And I created feature class in database. But when I add feature class in arcmap, I need to change the editor ...
4
votes
2answers
79 views

Keeping Default Version of Geodatabase protected?

I have a multiuser geodatabase with Oracle Enterprise RDBMS. The Version of the geodatabase is 10.4.1 and Oracle 11g. We have over 35 data editors with the flat version tree, each user having their ...
0
votes
1answer
121 views

Reason for a Data Loss While Making Schema Changes on SDE - Oracle DB [closed]

I am not an expert when it comes to Administering Multi-User Geodatabase. However, I refer to Esri's documentation for best practices and efficient workflows before putting on my GIS Admin's hat to ...
1
vote
1answer
361 views

Change Version Option Grayed out in ArcGIS Pro

I am experimenting with versioning data from an SDE database in ArcGIS Pro. I able able to create a new version, no problems, but when I go to change the version in the Data Source tab on the Contents ...
7
votes
2answers
682 views

How are unsaved/temporary edits stored during versioned editing?

In ArcGIS Desktop, I can edit versioned, Oracle tables. I generally edit the default version, and I've registered the tables as versioned with the option to move edits to base. I do things like: ...
2
votes
0answers
319 views

Using ArcGIS workspace defined as version in ArcPy?

I am trying to define my workspace as the current version that I am connected to. The Python tool that I am running utilizes the arcpy.da.Editor() function, and I used a workspace variable that is ...

1
2 3 4 5