Latest Contributions by JamalNUMAN

Thank you Francisco. It works fine   ... View more

It's there in 3.0.1       ... View more

What’s given here is the Parcels table and Owners table.   In the real life, we need to create another table that accommodates parcels with their owners:   one parcel can be owned be many owners one owner can owe many parcels   How this table can be structured according to the best practices? ... View more

The good thing in Pro that the name of the user is displayed with the name of the version.   Both the parent and child versions are accessed with the sa user which makes it possible to post the edits from the child to the protected parent. The child is accessed by the sa by adding the layer by sa (as usual) but then switching the version to child     ... View more

Great. It works fine with no issues.   The comparison demonstrates a slight difference when performing the “select by attribute” tool on an indexed data and a nonindexed for a data of around 340,000 records as per the screenshot below.     # -*- coding: utf-8 -*- """ Generated by ArcGIS ModelBuilder on : 2022-09-02 12:37:39 """ import arcpy, time def Model(): # IndexingElapsedTime # To allow overwriting outputs change overwriteOutput option to True. arcpy.env.overwriteOutput = True # Model Environment settings with arcpy.EnvManager(scratchWorkspace=r"C:\Z8\Q.gdb", workspace=r"C:\Z8\Parcels.gdb"): Parcels = "Parcels" # Process: Copy Features (Copy Features) (management) Output_Feature_Class = "C:\\Z8\\Q.gdb\\Parcels_CopyFeatures" arcpy.management.CopyFeatures(in_features=Parcels, out_feature_class=Output_Feature_Class, config_keyword="", spatial_grid_1=None, spatial_grid_2=None, spatial_grid_3=None) # Process: Add Attribute Index (Add Attribute Index) (management) Parcels_CopyFeatures = arcpy.management.AddIndex(in_table=Output_Feature_Class, fields=["ParcelNumber"], index_name="ParcelNumber", unique="NON_UNIQUE", ascending="NON_ASCENDING")[0] # Process: Select Layer By Attribute (Select Layer By Attribute) (management) startTime = time.time() Parcels_CopyFeatures_Layer, Count = arcpy.management.SelectLayerByAttribute(in_layer_or_view=Parcels_CopyFeatures, selection_type="NEW_SELECTION", where_clause="ParcelNumber = '72'", invert_where_clause="") endTime = time.time() elapsedTime = endTime - startTime print(f"Selection of indexed data took {elapsedTime} seconds to complete") # Process: Copy Features (2) (Copy Features) (management) Output_Feature_Class_2_ = "C:\\Z8\\Q.gdb\\Parcels_CopyFeatures1" arcpy.management.CopyFeatures(in_features=Parcels, out_feature_class=Output_Feature_Class_2_, config_keyword="", spatial_grid_1=None, spatial_grid_2=None, spatial_grid_3=None) # Process: Select Layer By Attribute (2) (Select Layer By Attribute) (management) startTime = time.time() Parcels_CopyFeatures1_Layer, Count_2_ = arcpy.management.SelectLayerByAttribute(in_layer_or_view=Output_Feature_Class_2_, selection_type="NEW_SELECTION", where_clause="ParcelNumber = '72'", invert_where_clause="") endTime = time.time() elapsedTime = endTime - startTime print(f"Selection on nonindexed data took {elapsedTime} seconds to complete") if __name__ == '__main__': Model()   ... View more

Both parent version and child version are logged in by their owners (sa and u1 respectively) as per the screenshots below. Then I’m still unable to perform the post (from the child to parent)   Right. I watched all the available videos and documentation related to versioning, nevertheless, I still do have tons of inquiries. This is why I prefer to post them in the forum. I do appreciate your time and help   ... View more

I’m running the script from inside the Pro as per screenshot in my pervious post.   What is the correct script for the print that needs to replace: arcpy.AddMessage(f"Selection took {elapsedTime} seconds to complete")     ... View more