Create a new layer of mosaic dataset with definition query in ArcMap.

Question

Hello GISesrs,

Hope you are keeping safe in current events.

Im trying to Save new mosaic dataset with new definition query. But it seems that the script below saves new mosaic dataset, but without a query. Any advise would be appreciated.

import arcpy
mxd = arcpy.mapping.MapDocument(\Historic_Maps.mxd")
df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0]
field = 'Date'
values = "'1950'"
query=str(field) +" "+ "=" + str(values)

for lyr in arcpy.mapping.ListLayers(mxd, "*"):
if lyr.name == "Sacle_1250":
        lyr.definitionQuery = query
        arcpy.mapping.AddLayer(df, lyr, "BOTTOM")

arcpy.RefreshActiveView()
arcpy.RefreshTOC()
mxd.saveACopy (\my_mxd3.mxd")
del mxd

BenasPekarskis1 · Answer

Thanks David,

I think it might be related to this bug- NIM067173: A definition query applied to a Mosaic Dataset is no..

Regards,

Ben

DavidPike · Answer

Hi Benas,

I've tried multiple syntax but no avail. I've been able to apply definition queries to feature classes using your code, but not a MD.

wrt the raster catalog footprints, it seems this is correct for a mosaic dataset (I think the MD is a repackaged raster catalog rolled in glitter)

Look forward to someone solving this.

BenasPekarskis1 · Answer

This is what confusing me.   When I view properties it is Mosaic dataset. I also created a new from scratch as a mosaic dataset.

But when I view properties of Footprint, it says its Raster catalog: