16 votes

How can I discover the Python version in QGIS?

Looks like in QGIS v3.0, python v3 will be implemented: Help us to plan for QGIS 3.0 Updating Python 2.7 to Python 3: Currently we bundle in Python 2.7 in our windows installers and require 2.7 ...
user avatar
  • 34.6k
8 votes

How are unsaved/temporary edits stored during versioned editing?

In short, unsaved/temporary edits in ArcGIS geodatabase are stored in a table, specifically Delta tables also know as A (add) & D (delete) tables based on the information I'm aware of and ...
user avatar
  • 11.8k
7 votes
Accepted

Does a high number of SDE_state_lineages slow performance?

The answer is yes that the number of rows in the sde_state_lineages table directly impacts performance of the geodatabase. 200k rows is not considered "alot" but that is relative to your available ...
user avatar
  • 816
7 votes
Accepted

What is Diffrent Between Version & Replica In ArcGIS Geodatabase

Versioning is for editing in a multi-user environment. Replication is for replicating your data in a multi-database environment. They are two very different things. In a multi-user environment the ...
user avatar
  • 29.2k
6 votes
Accepted

Changing to Historical version using ArcPy?

After some further research I have confirmed that this is a known bug. Hopefully adding this information here will save someone some time in the future as it was not easy to find using Google or the ...
user avatar
6 votes
Accepted

What is the significance of the SDE lineage length?

A lineage length of 289 indicates 289 states participate in that lineage. If this is after a compress operation, this indicates there are 289 states that cannot be compressed together to collapse that ...
user avatar
  • 816
6 votes

Applying version control to ArcGIS ModelBuilder models?

ModelBuilder is old, clunky, and is not getting any significant updates with ArcGIS Pro, if this tweet is any indication. I have never been a big fan of it (though begrudgingly still use it when I ...
user avatar
  • 35.4k
6 votes

How can I discover the Python version in QGIS?

Another way to know what version of python you are using can be to run the following command on the python console that has QGIS: from platform import python_version print(python_version())
user avatar
  • 1,198
6 votes
Accepted

Creating ArcMap Versions using Arcpy

It fails because the version creation block is inside the loop over existing version. As it is now, the code loads the list of version, reads the name of the 1st one, and if the owner is different ...
user avatar
  • 34.3k
6 votes
Accepted

Spatial Data Version Control or Versioning Software

You are looking for geogig: http://geogig.org/ This is like "git for spatial data". There's a learning curve (as with all new software).
user avatar
  • 51.1k
5 votes

Managing large amounts of geospatial data?

Postgres all the way as others have said, however if you want to keep it portable and easy to move, then you could always look at using SQLite + the Spatialite extension. Not as easy to use as ...
5 votes
Accepted

Post and Reconcile buttons in versionig toolbar grayed out in Arcmap

You need to start editing in order for the versioning buttons to be available. Go to Editor toolbar and "Start Editing". When you are finished with Reconcile and Post, Save and Stop Editing.
user avatar
  • 110
5 votes
Accepted

OSM queries on history?

The best solution we found is to use Overpass-Turbo "diff" functionnality. Here is the XML script I use to get changes on roads in a given bounding box, between 2 dates: <osm-script date="2014-09-...
user avatar
4 votes

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

Since you would "prefer everyone on ArcGIS, using ArcSDE, but ... don't have the budget" you may be interested in "GISquirrel" http://www.gisquirrel.com which gives multi-user editing of PostGIS ...
user avatar
4 votes
Accepted

arcsde topology register issue

I found what looks to be the solution to this from Thomas Brown at the old ArcGIS Discussion Forums: Once a topology dataset is register as versioned, you must perform the validation within ...
user avatar
  • 63.7k
4 votes

Severe performance difference using deleteSearchedRows

Geodatabase type matters for the type of delete you should use. If you're using an ArcSDE geodatabase, the recommended method is to use IRow.Delete(). The ITable.deleteSearchedRows() is ...
user avatar
4 votes
Accepted

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

Unversioning removes the A and D tables associated with a single versioned feature class. Any edits not reconciled and posted to the base table will be lost, which appears to be your goal.
user avatar
  • 18.8k
4 votes

Applying version control to ArcGIS ModelBuilder models?

The introduction of Python toolboxes at ArcGIS 10.1 for Desktop invalidates your four year old statement that all: Toolboxes, and thus their models, are binary. Standard toolboxes are binary but ...
user avatar
  • 63.7k
4 votes

Versioning in QGIS?

Geogig (http://geogig.org/) can do geospatial data versioning. If different users modify the same feature, it can get tricky, but merging and versioning distributed editing is easy. Geogig works on ...
user avatar
  • 297
4 votes

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

In Arcgis the dataset version is set at Workspace level. As you have mentioned in your question, you should create a connection file for that version and change the handle to the featureclass or table....
user avatar
4 votes
Accepted

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

You are almost there. You just need to test in the list comprehension you get that the v.name is not equal to certain strings. def getParameterInfo(self): """Define parameter definitions""" ...
user avatar
4 votes
Accepted

Changing ArcSDE version of *.mxd in ArcPy?

Have you considered using the arcpy ChangeVersion_management() tool? From the ESRI Help page: "Each input feature layer or table view will have its workspace modified to connect to the requested ...
user avatar
  • 4,888
4 votes
Accepted

Unable to post edits to the default database when default version access is “protected”

The Protected version allows other users to create child versions and edit them, but they cannot (as you have discovered) post their edits back. The owner of the protected parent version can post the ...
user avatar
  • 29.2k
4 votes
Accepted

Python Script to generate log files with time and date and output events and error messages to the log files

You need to actually write to the file - currently all you're doing is writing to the console using print. Something like file.write() will write to your log file, or add a function that will write ...
user avatar
  • 29.2k
4 votes

Versioned to unversioned: How to undo edits in an edit session on an unregistered table

The best resource I've come across to provide an answer is Esri's Not registered as versioned or unregistering data as versioned There are no ways I'm aware of redoing/undoing edits in unregistered ...
user avatar
  • 11.8k
4 votes
Accepted

How are unsaved/temporary edits stored during versioned editing?

Manually trace what the database does: Create a test table: In SQL Developer,: create table test_table ( field1 varchar2(255) ); In ArcCatalog: Register the table with the Geodatabase ...
user avatar
  • 756
4 votes
Accepted

File Geodatabase and Versioning

No, you cannot use versioning within a file geodatabase. As the second reference states, versioning is a capability of an Enterprise geodatabase (only a database can do the UNION ALL versioned ...
user avatar
  • 18.8k
4 votes
Accepted

Why do arcpy.GetCount_management and arcpy.ArcSDESQLExecute yield different row counts?

When querying the table of a versioned (or archive-enabled) feature class directly using SQL, your results would not be expected to reflect the current state of the feature class. You should use the ...
user avatar
4 votes
Accepted

Cannot figure out what is wrong with my code

Taking a look at your code I see four different errors: 1) You wrote: Date = datetime.date.today().strftime("%d%m%Y") However, you never import datetime. Add import datetime at the start of your ...
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible