topic Re: Create a new layer of mosaic dataset with definition query in ArcMap. in Python Questions

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

BenasPekarskis1 — Sat, 11 Dec 2021 17:52:46 GMT

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

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

DavidPike — Sat, 11 Dec 2021 17:52:49 GMT

field = "Date"
values = "1950"
query = '"' + field + " = " + values + '"'‍‍‍

Is it Sacle_1250 or Scale_1250 maybe?

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

BenasPekarskis1 — Tue, 31 Mar 2020 14:50:11 GMT

Thanks David.

The typo happened while copying the code into Geonet.

I have tried your suggested query. unfortunately it doesnt do the trick.

Mosaic datsets have three component: Boundary, Footprint and Image.

Definition queries are set in Footprint.

The naming of footprint is a mystery for me as well.

For instance I have some possible options in

if lyr.name == "Sacle_1250":

I have tried Scale_1250\Footprint, I have tried Scale_1250\AMD_Scale_1250_CAT.

Nothing seems to work.

Regards,

Ben

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

DavidPike — Tue, 31 Mar 2020 14:57:57 GMT

I'll try it on a dummy mosaic and get the syntax right for you.

The data type on your screenshot is FGdb Raster Catalog not Mosaic Dataset?

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

BenasPekarskis1 — Tue, 31 Mar 2020 15:15:14 GMT

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:

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

DavidPike — Tue, 31 Mar 2020 17:57:45 GMT

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.

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

BenasPekarskis1 — Tue, 31 Mar 2020 18:02:40 GMT

Thanks David,

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

Regards,

Ben