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

-1
votes
0answers
20 views

How to edit the Oracle Versioned Tables in QGIS? [closed]

I Have Created a Version for one Table in Oracle Spatial, when i tried to edit and Attbributes in QGIS i am not able to save..
0
votes
1answer
17 views

How to identify Unposted/Outstanding (A&D) edits of a version in Enterprise SDE Database using SQL interface?

I am working on ArcSDE10.2.2 Oracle11G(11.2.0.4) enterprise geodatabase with user base 600+ and 2000 versions( Created from DEFAULT). For effective GDB compression and optimized performance delta ...
2
votes
1answer
43 views

ArcGIS Python Toolbox Parameter Filter.List ValueList Delete/Remove for Reconciling Versions

Does anyone know if and how you can remove a value from a parameter filter list? In my case, I am using a python toolbox in ArcGIS 10.2.2 and want a drop down list of all the versions for the person ...
1
vote
1answer
16 views

Can Arcpy Reconcile Initiate the Interactive Conflict Review?

I'm pretty new to python but trying to hide a lot of the nitty-gritty of creating a grandfathered version and reconciling from my users. I've gotten pretty far, but can't figure out a way for a ...
2
votes
1answer
53 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 ...
0
votes
2answers
36 views

RuntimeError: Underlying DBMS error ORA-00936: missing expression schema.tableName STATE_ID is not column in table?

I created a search cursor to retrieve some data from a feature class. The broken example shown below is used successfully in other scripts I created. The only difference that comes to mind is I'm ...
1
vote
1answer
19 views

How to created the filtered versions in ArcSDE 10.1?

I am using ArcSDE 10.1 and Oracle 11g, I have a SDE user (parent), and two more users (ex: user1,user2) in my oracle database with required SDE permissions. In my SDE db, i have a polygon ...
1
vote
1answer
35 views

Getting version of connected database using ArcPy?

I wrote a toolbox script that allows a user to append points from a text file to a feature class. The user picks a text file and a feature class from a database he is connected to, the script then ...
3
votes
2answers
45 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 ...
1
vote
2answers
51 views

OSM queries on history?

I would like to get a list of modifications on the OSM database, in a given bounding box, between two given dates and impacting a given set of tags. Does anyone know how to do this? Any command-line ...
0
votes
1answer
32 views

Post and Reconcile buttons in versionig toolbar grayed out in Arcmap

I have a versioned GDB (Postgresql) and I have versions DEFAULT-> A -> B. Version A modifies two poly lines and version B modifies one of the two that is modified in version A. In ArcMap, even though ...
0
votes
1answer
21 views

Reconciling to a non-parent version in ArcGIS

I am trying to find a neat way to clone a GDB version in ArcGIS and as suggested in Cloning a transactional version in ArcGIS, it seems reconciling from the source to the clone is the way to go. ...
0
votes
1answer
37 views

Cloning a transactional version in ArcGIS

In ArcGIS documentation, I cannot find any references to cloning a transactional version. Is there a built in method for it? I think I know how to do it manually in Arcpy, basically creating a new ...
2
votes
1answer
62 views

Edit default version table view using SQL Server

I have a ArcSDE (10.3) geodatabase setup which is versioned as we have a few people working concurrently on the data. However, I want to run some background scripts in SQL Server to update the default ...
3
votes
0answers
35 views

Any way to speed up an append of data to SDE database while it is still versioned?

My group works on a database and about once a month I receive data that must be appended. This process has required me to reconcile and post all versions to default. I then pull down the database ...
1
vote
2answers
76 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 ...
0
votes
0answers
55 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 ...
0
votes
0answers
27 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, ...
1
vote
1answer
43 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 ...
2
votes
1answer
80 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.
3
votes
0answers
325 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
1answer
23 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
537 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 ...
0
votes
2answers
212 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 ...
4
votes
2answers
132 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 ...
0
votes
0answers
49 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), ...
3
votes
1answer
57 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
51 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 ...
4
votes
1answer
230 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
0answers
22 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
37 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
89 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 ...
3
votes
1answer
157 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
91 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
52 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 ...
1
vote
1answer
89 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
2answers
108 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 ...
2
votes
1answer
97 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
39 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 ...
3
votes
1answer
78 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 ...
0
votes
1answer
30 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 ...
1
vote
1answer
627 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
120 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
160 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
190 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 ...
1
vote
0answers
63 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
49 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.
2
votes
2answers
137 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 ...
1
vote
3answers
256 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 ...
2
votes
0answers
39 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 ...