https://community.esri.com/t5/python-questions/getcountmanagement-for-mosaic-dataset/m-p/1148132#M63874 <P>Thanks, works nicely.&nbsp;</P> Fri, 25 Feb 2022 19:34:29 GMT KeonMonroe 2022-02-25T19:34:29Z https://community.esri.com/t5/python-questions/getcountmanagement-for-mosaic-dataset/m-p/1147691#M63871 <P>I'm trying to develop a geoprocessing tool for handling mosaic datasets. Using ArcGIS Pro - I can query a mosaic dataset and find how many primary rasters it contains. How can I replicate this behavior in a script? If I had a normal feature class I would make it a feature layer, select on the layer, then GetCount() to find the number of rows.</P><P>How would you do this with a mosaic dataset that contains primary and overview rasters?</P><P>&nbsp;</P><LI-CODE lang="python">def query_primary_rasters(input_md): """ Return the number of primary rasters in a given Mosaic dataset """ arcpy.AddMessage(f"Input Mosaic Dataset:\n{input_md}") query_by = "Category = 1" # primary rasters md_lyr = "md_lyr" # arcpy.MakeFeatureLayer_management(in_features=os.path.join(input_md, "Footprint"), out_layer = md_lyr, where_clause= query_by) # arcpy.MakeMosaicLayer_management(input_md, out_mosaic_layer= md_lyr, where_clause= query_by) # NOTE - below works but doesn't return selected row count (includes all items) arcpy.management.SelectLayerByAttribute(input_md, "NEW_SELECTION", query_by, None) count_primary = int(arcpy.GetCount_management(md_lyr)[0]) arcpy.AddMessage(f"There are {count_primary} primary rasters in the mosaic dataset") return count_primary update_md = arcpy.GetParameterAsText(0) query_primary_rasters(update_md)</LI-CODE><P>&nbsp;</P><P>&nbsp;</P> Thu, 24 Feb 2022 19:43:22 GMT https://community.esri.com/t5/python-questions/getcountmanagement-for-mosaic-dataset/m-p/1147691#M63871 KeonMonroe 2022-02-24T19:43:22Z https://community.esri.com/t5/python-questions/getcountmanagement-for-mosaic-dataset/m-p/1147709#M63872 <P>It appears as if Pro's Table to Table tool will allow the mosaic as input, and let you put a query of "Category = 1".&nbsp; This will output just the primary's to a new table (could probably go to memory, didn't test) that can now be fed into the GetCount tool.</P><P>&nbsp;</P><P>R_</P> Thu, 24 Feb 2022 20:31:31 GMT https://community.esri.com/t5/python-questions/getcountmanagement-for-mosaic-dataset/m-p/1147709#M63872 RhettZufelt 2022-02-24T20:31:31Z https://community.esri.com/t5/python-questions/getcountmanagement-for-mosaic-dataset/m-p/1148132#M63874 <P>Thanks, works nicely.&nbsp;</P> Fri, 25 Feb 2022 19:34:29 GMT https://community.esri.com/t5/python-questions/getcountmanagement-for-mosaic-dataset/m-p/1148132#M63874 KeonMonroe 2022-02-25T19:34:29Z