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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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())
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 ...
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).
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 ...
Community wiki
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.
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-...
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 ...
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 ...
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 ...
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.
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 ...
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 ...
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....
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"""
...
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 ...
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 ...
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 ...
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 ...
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
...
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 ...
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 ...
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 ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
versioning × 247enterprise-geodatabase × 157
arcgis-desktop × 56
arcpy × 50
arcgis-server × 30
editing × 28
esri-geodatabase × 23
arcgis-10.1 × 19
arcgis-10.2 × 19
oracle-dbms × 19
arcgis-10.0 × 17
sql-server × 17
arcmap × 15
arcobjects × 14
arcgis-10.3 × 14
reconcile × 14
python × 11
arcgis-9.3 × 10
postgresql × 9
arcgis-pro × 9
qgis × 8
postgis × 8
oracle-spatial × 8
replication × 6
archiving × 6