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
83
votes
8answers
10k views

Managing large amounts of geospatial data? [closed]

How do you manage your geospatial data? I have terabytes of data spread out over hundreds of datasets, and have an ad-hoc solution using symbolic links within projects which link back to an domain-...
28
votes
8answers
10k views

When Versioning with ArcSDE can posted edits be cancelled or rejected?

I am using ArcGIS 9.3.1 and attempting to work with an SDE geodatabase (with one polygon feature class) that has already been registered as versioned. I'm new to versioning and am still trying to ...
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 (...
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 ...
13
votes
2answers
655 views

Getting differences between old and new versions of ArcSDE database?

Is there a tool or a process that can reveal changes made to the schema of an ArcSDE database when comparing two versions of the same database hosted on different servers? I have an old database ...
11
votes
3answers
792 views

How to deal with versioning in OpenStreetMap?

The topic of managing geospatial data in a more general sense has come up before here. The topic of versioning was mentioned there as well, but not really dealt with. Traditional geospatial data ...
9
votes
2answers
2k views

In a versioned geodatabase, what impact do delta tables and the state tree have on query performance?

We have a versioned arcsde geodatabase (arcgis 9.3.1 on oracle 10g) with a fairly complex data model that includes about 100 featureclasses and non spatial tables, a geometric network and many ...
9
votes
1answer
894 views

Is there a way to check if data was versioned using “move edits to base” option?

Is there a way to check if data was versioned using "move edits to base" option? Preferably through ArcGIS itself or using Python, but any way will work. EDIT Is there way to see if this box was ...
9
votes
1answer
630 views

Changing to Historical version using ArcPy?

I am having an issue trying to change to a historical version on an SDE feature class using Python and arcpy.ChangeVersion_management. I am able to manually change the version to a specific date and ...
9
votes
2answers
597 views

Tools to compare unversioned copies of geospatial data [closed]

My office has about 100 GB of geospatial data of varying forms (imagery, feature classes in geodatabases, LIDAR, tables, etc) that have gone somewhat unmanaged for the decade during which they were ...
8
votes
2answers
3k views

Using ArcGIS and QGIS together in multi-user editing environment?

We have a GIS staff of 7, and another group of about 14 who "use GIS" from time to time. We really, really want multi-user editing. Mostly of a large point file, and we're almost never in the same ...
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 ...
8
votes
1answer
491 views

How to store historical versions of road (route) portions?

Part of my job is to analyze certain portions of road for our clients. A client will ask, I want to look at Road A from parcel XYZ to parcel RST and Road B from parcel RST to parcel OPQ. The way I do ...
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 ...
7
votes
2answers
556 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: ...
7
votes
4answers
838 views

Comparing 2 vector files

I'm looking for a tool which compares two vector files (eg shapefiles). Eg 2 versions of a river network. Quite a lot of the records are equal, but some are different. A possible output would be eg a ...
7
votes
1answer
4k views

Does a high number of SDE_state_lineages slow performance?

In our SDE database, the SDE_state_lineages table has around 200,000 records, the SDE_states has around 900, and our SDE_versions table has around 1,300 records. We've been having performance issues ...
7
votes
1answer
227 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 ...
7
votes
0answers
594 views

What qualifications should auditor have to auditing GIS? [closed]

Background summary: Various systems are being audited and GIS is the next to be audited. The initial kick-off for the audit was a meeting between me and a single auditor. Initially, I thought it was ...
6
votes
3answers
3k views

Reconcile Versioned Geodatabase with only DEFAULT version?

Follow up to this: Spatial Database Connection String I am trying to reconcile a versioned geodatabase that has only one version, DEFAULT. I am following the steps from the ESRI documentation: A ...
6
votes
5answers
582 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 ...
6
votes
3answers
934 views

Can primary keys and foreign keys be used in versioned geodatabases?

I've been brushing up on relational database design theory, and I keep coming across primary keys (PKs) and foreign keys (FKs). PKs and FKs are said to be pillars of relational database design and ...
6
votes
2answers
3k views

Understanding Geodatabase Archiving and H tables in ArcSDE?

We have ArcSDE 10.0 on MSSQL 2008 with Geodatabase archiving enabled. In the process of updating a topology I deleted the topology, disabled archiving, unregistered as versioned and then recreated ...
6
votes
2answers
2k views

Problems when trying to Undo edit operations in ArcGIS

I'm trying to programatically stop/abort/undo an edit operation inside a ArcSDE environment. My environment is currently Oracle, ArcSDE 9.3.1 and in our custom code (I inherited a large ugly portion ...
6
votes
3answers
1k views

Has anyone discovered any compatibility issues between ArcGIS 10 clients editing older ArcSDE geodatabases (e.g 9.3.x)? [closed]

I’ve read the ESRI documentation here: http://goo.gl/UUSM (link to ESRI) and http://goo.gl/TsmV (link to ESRI) , so I know the documentation states that you can. And I’ve actually edited data (a ...
6
votes
2answers
2k views

Autonumbering fields in versioned ArcSDE Geodatabase?

I want to have a field with autonumbering in ArcGIS. I have a versioned ArcSDE for SQL Server geodatabase. Thus, using the identity seed attribute in the SQL Server is not an option. Is it not ...
6
votes
1answer
230 views

How to store and serve data and its progress over time in GeoServer?

I recently started working with GeoServer and stored some shapefiles. I successfully can retrieve the data as JSON. The data I want to maintain in the database changes over time. I do not want to ...
6
votes
2answers
647 views

How to undo ArcGIS “Move Edits to Base” mistake?

I'm trying to help a client who mistakenly checked the "Move Edits to Base" option when versioning a feature class in ArcGIS. They would now like to fix this mistake. However, they don't want to ...
5
votes
3answers
10k views

Unable to edit data in an ArcSDE geodatabase

I'm dealing for the first time with an ArcSDE geodatabase so I'm facing simple problems to you. ESRI help wasn't of much help (to a begginer at least). I can't edit my data in ArcMap, most probably ...
5
votes
1answer
597 views

Listing ArcSDE versions using ArcPy?

I have an ArcSDE geodatabase with different versions for each user. How can I list each version using ArcPy?
5
votes
4answers
2k views

Creating a multiversioned view with ArcSDE and SQL Server 2008 R2

I am using the administration command sdetable -o create_mv_view to create a multiversioned view on a table in SQL Server 2008 R2. Everything appears to be working correctly with one exception: The ...
5
votes
1answer
919 views

What is Diffrent Between Version & Replica In ArcGIS Geodatabase

I know Versioning allows multiple editors to alter the same data in an enterprise or workgroup geodatabase without duplicating data and Geodatabase replica allows creates copies of data across two or ...
5
votes
3answers
154 views

How to track alignment changes?

I work for a small company that designs alignments using ArcGIS. (To give you an idea of company size, we have about 50 employees; I am the only full-time GIS person, although we have 4 ArcMap ...
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 ...
5
votes
2answers
2k views

How can we use SQL to update feature class attributes in a versioned geodatabase in ArcGIS Workgroup

ArcGIS Workgroup Edition 9.3.1, MS SQL 2005 Express I have some attribute data that I want to periodically update with information from another RDBMS using SQL UPDATE commands. The data is ...
5
votes
1answer
233 views

Versioning commercial datasets in ArcSDE + Oracle

We are building an application with several spatial tables, provided by a commercial vendor, at its core. The vendor provides updates quarterly. We maintain several tables of our own, derived from ...
5
votes
2answers
315 views

Utilizing versioning with ArcGIS Collector

I have done a lot of research on the internet with this and I am unable to find a cut and dry answer. I am utilizing ArcMap 10.3.1. and PostgreSQL 9.3. I have been able to get everything set up ...
5
votes
1answer
215 views

Is there a tool to track edits that were made?

Is there a tool/report that keeps track of what edits were made that I could run prior to or after reconciling my versions? This would help me to know if there are any changes I need to make to any ...
5
votes
3answers
411 views

After running the Version Changes tool ..Export pre-reconcile/post records from parent

I would like to export those records identified as changes after running the Version Changes tool before running Reconcile and Post tools. Preferably with python or having python call a program to do ...
4
votes
2answers
906 views

What is the significance of the SDE lineage length?

ORA-55378 left a great answer to my question: Does a high number of SDE_state_lineages slow performance? But, I realized I don't really understand what lineage length means and how it affects ...
4
votes
2answers
69 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 ...
4
votes
1answer
1k views

ArcGIS 9.3.1 cannot delete a version

We are having trouble deleting a version made in our 9.3.1 sde. When we attempt to delete it, ArcCatalog returns a message saying Unable to Delete - Target State not found in States table. Upon ...
4
votes
1answer
1k views

Creating Stored Procedure in versioned SDE_SQLServer geodatabase using DDL?

I've almost used SQL server_SDE geodatabases for 3 years in GIS projects and I don't know how can I create a stored procedure in geodatabase.I use ESRI case tool to create a geodatabase in ArcCatalog(...
4
votes
1answer
94 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
937 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 ...
4
votes
1answer
615 views

How to repair Geometric Network in Versioned ArcSDE Geodatabase?

Our Versioned ArcSDE workflow has a feature dataset with Geometric Network in the parent (Default), which users derive in their own versions. It is now observed that in some versions, the geometric ...
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 ...
4
votes
1answer
913 views

Does ArcGIS Online support versioning?

Using ArcSDE with a relational database, it is possible to set up versioning. Is this available in ArcGIS Online, aka ArcGIS.com? When working with a feature layer in ArcGIS Online, there is the ...
3
votes
3answers
2k views

Tracking change with ArcSDE/Oracle

I'm looking for the simplest way to track changes ([delete, update, create] feature(s)) made to the DEFAULT version of a given feature class in ArcSDE(10) and Oracle(11g). Qualifier: I am not a dba ...
3
votes
3answers
3k views

How do I access versioned spatial data in SDE with SQL queries?

We're running SDE and have several feature sets with versioning turned on. When I query those layers via ArcGIS Engine or ArcGIS Server, all expected features are returned. We have numerous non-GIS ...