Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

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
0answers
13 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
77 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
1answer
692 views

Severe performance difference using deleteSearchedRows [closed]

The issue I am having involves two versioned tables. A function deletes 48 rows from Table A and and 48 rows from Table B using deleteSearchedRows. However, the delete from Table A takes roughly 4 ...
1
vote
2answers
29 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 ...
0
votes
0answers
12 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 ...
6
votes
5answers
564 views

Versioned to unversioned: How to undo edits in an edit session on an unregistered table

I'm considering switching some of my tables in an Oracle enterprise geodatabase from versioned to unversioned. The pros of having unversioned tables would be: Simpler, traditional database design ...
1
vote
0answers
84 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 ...
2
votes
1answer
129 views

Accessing information about ArcSDE historical markers via arcpy or SQL?

I would like to be able to access the list of historical markers that is presented in the "Change Version" dialog in ArcMap - https://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/...
0
votes
0answers
16 views

Derive Event Measures Error Message?

Getting an Underlying DBMS Error message (ORA-20025: Not owner of state 1087699.ORA-06512: at “SDE.VERSION_USER_DDL” As anyone seen this type of error and how all the sudden would this become an ...
16
votes
5answers
2k views

Applying version control to ArcGIS ModelBuilder models?

Version control is an indispensable tool for software development, allowing one to reliably and cleanly step back in time to the last time X did it's job exactly right, or to see what changed between ...
7
votes
1answer
226 views

Distributed versioning of geospatial data?

I'm getting started on the design of a new system that would reconcile, merge, and synchronize changes made across numerous geospatial databases of common ancestry, on an ongoing basis. These ...
28
votes
1answer
2k views

Implementing version control system for geospatial data? [closed]

Not that I am in any immediate need of a right answer here, but I've lately seen some efforts to introduce the concept of "(distributed) version control systems" for geographic data. Some examples (...
2
votes
1answer
50 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
41 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
25 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
124 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
37 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
31 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 ...
0
votes
1answer
124 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
75 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
28 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
50 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. ...
4
votes
1answer
93 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 ...
0
votes
0answers
22 views

Using SDE versioned layers as inputs in FME

I am using the following FME script to compare the vertices between a line layer and a polygon layer (they should have the same vertices, but because of a resolution issue some areas have different ...
1
vote
0answers
48 views

Does QGIS have anything like Geodatabase Versioning? [duplicate]

I am just wondering if QGIS has anything like Esri's geodatabase versioning?
3
votes
3answers
2k views

Versioning in QGIS?

Are we planning to have in QGIS implementation of Versioning like Esri? There is a general need for the the implementation where QGIS is used for planning and planned design in utility can be ...
1
vote
0answers
169 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 ...
1
vote
0answers
74 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 ...
0
votes
1answer
210 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
2answers
249 views

Python Script updating default version and child version simultaneously

I am writing a script to auto update attributes for several FCs in my enterprise SDE. I am testing the script and there are no processing bugs however there is strange behavior. When the script ...
4
votes
2answers
1k views

ArcObjects IConflictsWindow3 not seeing version reconciliation conflicts

We are working on a reconcile and post add-in for one of our departments. I'm able to successfully complete the task if there are no conflicts or if I specify which version 'wins'. We would like to ...
1
vote
0answers
56 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
56 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 ...
1
vote
1answer
649 views

Viewing Edit Tracking History on Feature Service hosted at ArcGIS Online?

Is there a way to view the edit history of a specific feature service or feature? I have enabled edit tracking and have been doing fieldwork for 2 weeks now. I want to see how the data has changed ...
1
vote
1answer
145 views

Web Editing Versioned Enterprise GDB [closed]

I would like to implement a web editing environment where edits are posted to a version of a database (delta tables) not too default. The idea behind this is so that any edits made through a web app ...
1
vote
1answer
116 views

Migrate to Enterprise Geodatabase

We have basemap with shapefile, now we have purchased ArcGIS 10.2 with server and ArcSDE and Oracle. We want to establish Enterprise level so that multiple users can edit without overwrite the source ...
0
votes
0answers
54 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 ...
4
votes
2answers
914 views

ArcPy save edits without stopping an edit session

I am editing a versioned SDE Feature class with arcpy (ArcGIS 10.2.1). I know that to edit versioned data you should use the arcpy.da.Editor, start editing, start operation, do your edits, stop ...
0
votes
0answers
44 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
837 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., ...
5
votes
3answers
2k views

QGIS Plugin for PostGIS versioning

Does anyone of you know a QGIS-Plugin for Versioning PostGIS-Data? I know there was pgVersion of Horst Düster but as far as I know this was not updated for QGIS 2.x (at least not for the "normal" QGIS ...
0
votes
1answer
297 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 ...
7
votes
1answer
3k views

Check whether a feature class is registered as versioned using Python

How can I check whether or not a feature class is versioned using Python? I'm trying to register feature classes using a python script. Before I do this I need to check whether a feature class is ...
1
vote
1answer
759 views

How to change owner of a version in an enterprise geodatabase using ArcObjects?

I have ArcObjects/.NET code used to create few versions for workspace. Versions are created successfuly but their owner is who created them (the user connected to the workspace). I want to change the ...
1
vote
1answer
737 views

Using arcpy.da.Editor?

I am working with copies of feature Datasets that come from a versioned SDE. The copies are in an un-versioned 'development' SDE. I am attempting to do a field calculation on a single feature class ...
2
votes
1answer
92 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
0answers
129 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" ...
0
votes
1answer
147 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(...
0
votes
1answer
154 views

ArcMap, Editor and Geodatabase API edit session question [closed]

Say a feature class from a File GDB is added to ArcMap and an editing session on it is in progress. What happens if an add-in launched from the same ArcMap session tries to start an edit session using ...
8
votes
3answers
2k views

Version editing for Postgresql 9.2.4 / postGIS 2

Background: I am "building" a GIS with PostgreSQL 9.2.4 / PostGIS 2 as the database and QGIS 1.8.0 as the geographic application. There will be multiple users accessing, editing and viewing the data ...