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

0
votes
0answers
22 views

Error changing version using ArcPy, produced from escape character in version name

I've got a script which creates a version from BASE, appends a feature to a dataset and then reconciles/posts. It runs successfully when I use a different SDE connection that doesn't have a backslash, ...
3
votes
1answer
300 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 ...
10
votes
4answers
844 views

Applying version control to ArcGIS 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 ...
3
votes
1answer
253 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 ...
7
votes
1answer
454 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 ...
1
vote
2answers
49 views

How to get a search cursor on a particular version in arcpy

I have a versioned database in ArcGIS and I am wondering how can I tell arcpy what version to query. The closest I have got to an answer has been building a particular connection file that specifies ...
2
votes
0answers
136 views

Using arcpy.da.editor on a transactional version raising errors

I've run up against a wall trying to get an edit session to work on a version. These are the scenarios Ive gone through in the code and their error mesages: Setting up an edit session not as a ...
0
votes
0answers
30 views

Unable to create multiversion view in ArcSDE 10.2 and Oracle 11g

I couldnt create a multiversion view using 10.2. I registered feature dataset as versioned, it created MV view for one class but didnt create the MV view for the other one. Even I tried creating the ...
1
vote
0answers
33 views

Versioning In QGIS

Are we planning to have in QGIS implementation 1 Versioning like ESRI. How that can implemented? There is a general need for the the implementation where QGIS is used for planning and planned design ...
0
votes
2answers
125 views

How to explain why a particular ArcSDE state does not compress?

I am maintaining an ArcSDE database and would like to avoid killing connections to ArcSDE in order to run the compress operation. Our versioning workflow is very simple. Everyone edits the DEFAULT ...
2
votes
1answer
44 views

How can I extract the data showed in Version Changes before reconcile/post process?

I want to make a script in python to extract the data about version changes before make the reconcile/post process. Is that possible? I trying to avoid use C# or VB script.
0
votes
0answers
15 views

Delete a Feature from a Different Version While Editing

We have one feature class that always loads from the default version (named 'Work Request'), even when you are editing inside a different version. We use this feature class to identify areas where ...
7
votes
2answers
415 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 ...
4
votes
2answers
115 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 ...
7
votes
2answers
914 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 ...
5
votes
1answer
155 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?
2
votes
0answers
38 views

How to know Who is reconciling the Version to DEFAULT(Parent) in Geodatabase

We have Public DEFAULT version and working Versions(Child) have been created directly from DEFAULT. We have also provided Reconcile-Post Option to group of Users placed at separate locations. Hence ...
3
votes
1answer
55 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 ...
17
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 ...
0
votes
0answers
38 views

What is the most efficient method for deleting row/features from a versioned FC in python?

I'm trying to delete all records from a feature class in SDE and then append new data using python. My dataset is versioned in SDE. I've tried Truncate Table (doesn't work with versioned tables), ...
4
votes
1answer
143 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 ...
0
votes
1answer
33 views

arcsde topology register issue

I am in trouble with the topology in a sde database. I create a topology in a dataset from arccatalog, after managing to register it as aversion, I try to validate it from arccatalog, it tells me ...
1
vote
3answers
233 views

How to register as versioned using SDELayer?

This is the normal process using ArcCatalog : I want to automate this process using sdeLayer or any tools - does anybody have an idea as to how to do it? there is an application sdelayer ...
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 ...
0
votes
0answers
13 views

How to see original versions of imported features with archiving enabled

I recently imported several feature classes into an ArcSDE Oracle database, registered them as versioned, and then enabled archiving. I was under the impression that I would be able to see a ...
0
votes
0answers
30 views

Web Editing Versioned Enterprise GDB

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
0answers
71 views

Editing versioned view in ArcSDE 10.1 error

I am working in an ArcSDE 10.1 instance sitting on Oracle that I believe was upgraded from a previous ArcSDE version. It has a versioned view for the table I am trying to edit (specifically, delete ...
6
votes
2answers
969 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 ...
3
votes
1answer
143 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 ...
54
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 ...
3
votes
1answer
81 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: ...
0
votes
1answer
44 views

Identifying inserts, updates, deletes, and conflicts between a parent and child version in ArcSDE with ArcPy

I'm looking for a way to identify records that have changed between the present and the last time a version was reconciled. It would also be great to be able to identify conflicting records. Ideally ...
2
votes
1answer
159 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 ...
3
votes
1answer
114 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, ...
-1
votes
1answer
555 views

Reconcile and post versions through C#?

I want to know if we can post the versions based on events through coding. How we do batch reconcile and post through c# code? Is it possible for automatic replication also?
6
votes
2answers
434 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 ...
1
vote
1answer
72 views

ArcSDE register with gdb vs register as versioned

When wanting to update tables within a sde gdb, is there a difference between registering as versioned vs registering with the gdb vs registering with sde? I've read the question below and it hints ...
0
votes
1answer
112 views

Creating “Empty” version of ArcSDE geodatabase?

Is it possible to create an "Empty" version of an ArcSDE geodatabase? I have a large default ArcSDE geodatabase that I would like to create an empty version for a new project. By "Empty" version I ...
0
votes
2answers
101 views

Is editing geometric network in versioned geodatabase any different from when such data is stored elsewhere?

I need to work on "Checked Out" version of a geodatabase, editing geometric networks. What will be the difference in terms of the working process of the editor ?-do i need to use some special toolbars ...
3
votes
1answer
68 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 ...
2
votes
1answer
85 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 ...
1
vote
0answers
37 views

Is it possible to retrieve lost versioned data in SQL Server Management Studio?

One of my staff accidentally deleted a feature class she was creating in her version before I reconciled it. I have grabbed a back up of the database from yesterday in SQL Management Studio. Is ...
0
votes
1answer
28 views

Maintain Feature Data without Creating It

I work in City Gov. We utilize County Assessor data (Parcels) as they are updated from the Assessors office. Currently we store then in our Enterprise SDE system. As we get new updates, we have to ...
0
votes
1answer
330 views

Why can't a user with db_owner role version data?

I've made an enterprise geodatabase and added a user with db_owner permissions. When I add a database connection in ArcCatalog and connect to this geodatabase using the user I created, I'm not able ...
1
vote
1answer
517 views

ArcGIS: Versioning, Post & Reconcile, Compressing, and Lost in Space

Alright guys, I'm in a bad way here. Here is the short version, and I'll post the long detailed version below. I'm needing to figure out an easier way to post changes to the data on our SDE ...
2
votes
0answers
108 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: # ...
5
votes
1answer
141 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 ...
3
votes
1answer
1k 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 ...
1
vote
0answers
60 views

Problems with versioning

I have 5 PostgreSQL_PostGIS database in my company and i conneting on them through ArcSDE. Four of database work correctly, only with one i have i realy big problem. When i make two versions of ...
0
votes
1answer
47 views

How can I list version name in my silverlight application?

I need to populate combobox with arcsde version name in my silverlight 5 application. Please give me some suggestions.