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

5
votes
1answer
291 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
81 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 ...
3
votes
1answer
282 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 ...
6
votes
1answer
433 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
2answers
776 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
140 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
37 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 ...
2
votes
1answer
46 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 ...
0
votes
1answer
61 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 ...
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 ...
0
votes
0answers
27 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
66 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
21 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
197 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
11 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
24 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
49 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 ...
5
votes
2answers
884 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
126 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
215 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 ...
53
votes
7answers
4k 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
76 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
38 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
139 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
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, ...
-1
votes
1answer
527 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
348 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
54 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
101 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
90 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
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 ...
2
votes
1answer
71 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
27 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
270 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
382 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
98 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
118 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 ...
0
votes
0answers
26 views

Version problem When getting GML data with Mapxtreme WFS Client

When producing GML data with MapXtreme WFS Client in .Net, I have introduced the problem which is parameter of "gmlversion" is working on "GML3", but not working on "GML2". Has Anyone an idea about ...
3
votes
1answer
937 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
57 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
46 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.
0
votes
1answer
92 views

How to Avoid Object ID conflicts in Versioned geodatabase

We have just implemented a versioned Geodatabase and our schema has few feature classes and relationship classes. We do not Reconcile and Post to the parent ( Default) version, as we need some ...
1
vote
1answer
267 views

Error during reconcile: "The version could not be reconciled. Invalid network element id : Field is not editable

While reconciling a child version with the parent version, in a dataset containing Geometric network, the following error was noticed. Error during reconcile: "The version could not be reconciled. ...
2
votes
1answer
90 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
0answers
32 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 ...
1
vote
0answers
86 views

“Definition Query on a versioned Geodatabase”

I would like to implement Specific views to the SDE users, based on Definition Queries of common attributes , like Date created > = October 1. But on first look, the definition queries are for ...
3
votes
0answers
123 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 ...
1
vote
0answers
115 views

ESRI Versioning: A table doesn't match base table schema

ArcGIS 10.1 sp1 with Oracle 11g I've got a versioned feature class that I have discovered has a base table with a different schema than the corresponding A table. (A + registration_id from ...