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

learn more… | top users | synonyms

53
votes
7answers
5k views

What are some best practices for managing large amounts of geospatial data?

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 ...
16
votes
8answers
5k 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 ...
11
votes
3answers
443 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
239 views

Tools to compare unversioned copies of geospatial data

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
3answers
659 views

Applying version control to ArcGIS Models

Version control is an indispensible 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
4answers
509 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
3answers
1k views

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

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 ...
7
votes
2answers
815 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 ...
6
votes
3answers
2k 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
2answers
1k 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 ...
6
votes
2answers
789 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
2answers
378 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
909 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
2answers
340 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 ...
6
votes
2answers
265 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 ...
6
votes
1answer
132 views

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

I recently started working with GeoServer and stored some shape files. 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
1answer
434 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 ...
5
votes
1answer
143 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
1answer
882 views

How to check whether a fc is registered as versioned or not 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 ...
5
votes
1answer
122 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 ...
5
votes
1answer
214 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
3answers
307 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
87 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
746 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 ...
4
votes
1answer
82 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 ...
4
votes
1answer
98 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 ...
4
votes
1answer
373 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 ...
3
votes
3answers
3k 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 ...
3
votes
3answers
514 views

How to set up a Revision Control for ESRI File Geodatabase?

I'm interested in doing revision control (Mercurial) on some file geodatabases. Does anyone have an idea of which files are important (need to be saved) and which can be ignored? Note that I'm not ...
3
votes
4answers
1k 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 ...
3
votes
1answer
112 views

Reconciling vertex modification conflicts in Geodatabase Versioning?

Is it possible to edit the same feature in ArcSDE in two different versions ... and reconcile/post version A's edits to the parent, ... and then reconcile/post version B's edits of same feature, ...
3
votes
2answers
914 views

Which part(s) of the ArcMap user interface uses the Rogue Wave Objective Grid(OG1200ASU.DLL)?

I'm trying to troubleshoot ArcMap 10 crashing when I reconcile a version and I think it is OG1200ASU.DLL causing the problem. I'm guessing it's the attribute table or the attribute inspector. ...
3
votes
1answer
50 views

How do versioned views work with multiple editors?

I understand that in the database environment, by executing version_util.set_current_version('version1') Editor1 is able to write SQL statements against [table_name]_vw views to edit the data at ...
3
votes
1answer
128 views

How do I change to a Historical version using Python and 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 ...
3
votes
1answer
78 views

How to develop a Toolbox intended to be distributed in multiple version of ArcGIS?

I am currently developing a Toolbox for users who will use it in different versions of ArcGIS (10+ versions). Is there a recommended way to proceed in that situation? My main concerns about that are: ...
3
votes
1answer
224 views

Triggers for delta tables

I have been facing an issue to capture the delta updates on SDE. We have written triggers on A and D tables to capture the delta updates(to capture the version name based on state id's), however I ...
3
votes
1answer
960 views

How to edit a given version of geodatabase?

I have a versioned geodatabase. Any of that versions are used only by one user. So then user called "XXX" has a version called "XXX". So then now I want to make a changes on given version, but when I ...
3
votes
1answer
237 views

SDE Topology dirty areas don't go away

Just looking for an explanation on SDE Topology dirty areas that don't go away. My workflow involves editing a version of SDE data, then once finished I use the Validate Topology in Current Extent ...
3
votes
1answer
65 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 ...
3
votes
0answers
128 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 ...
3
votes
1answer
285 views

ArcSDE - How to edit mosaic dataset

I have a mosaic dataset (Raster) in an SDE database. As expected, when I click start editing, ArcMap says that I have to do "Register as Versioned" before, but I can't have a mosaic dataset in a ...
2
votes
3answers
1k 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 ...
2
votes
1answer
72 views

What's the proper way of deleting versioned data from an SDE geodatabase?

I haven't really read this anywhere. What is the proper way of deleting versioned data from an SDE geodatabase to make sure nothing is left behind in the A & D tables? Do I need to unversion the ...
2
votes
1answer
144 views

Moving Versioned Data between different geodatabases

Can you please let me know how to migrate feature class which is registered as version and archiving is enabled on it From: Database Environment: ArcSDE 9.3, RHEL 5, Oracle 11.2.0.2 To Database ...
2
votes
1answer
97 views

Change SDE Version in ArcGIS JavaScipt API depending on connected user

I am programming for an web editing application with ArcGIS API for JavaScript. I've published a version of ArcSDE with Feature Acces and I need to know how can I change in the web application from ...
2
votes
1answer
475 views

Steps to create an interface Editing ArcSDE Layers in a web service online. Similar to ArcGIS Desktop

The initial idea is to make a multiuser web service for editing versions of an ArcSDE geodatabase online (each version for each user. Is it possible to acces through a password and user name?). Can I ...
2
votes
1answer
142 views

Finding the Default version in a large linage tree

I have a very large versioning linage tree. I am using the arcGIS 10.0 GDBT tool. How can I find the node with the default version?
2
votes
1answer
876 views

How to solve an “Error found when retrieving conflicts.” error in ArcMap?

I uncovered this error when testing ArcMap 10 SP2 for a customer: This occurs when the conflict is detected--ArcMap is attempting to show the conflicts window but fails. I get this error on all ...
2
votes
0answers
103 views

Data loss after compressing geodatabase in ArcSDE

I suffer sometimes from data loss after compressing ArcSDE geodatabase, this geodatabase contains versioned feature classes, so the compressing script reconciles and compress the geodatabase: # ...
2
votes
0answers
33 views

Geoserver Feature Versioning Support

I am creating a map feature editor that supports versioning & rollback using Geoserver as the WFS. From what I've read online, it seems Geoserver supports feature versioning. My question is how ...