nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data Driven Pages-Restrict Indexed Feature

BarbaraMcIntosh

I'm creating a series of Data Driven pages at a fixed scale of 1:12000. I have multiple features in my index layer that, at that scale, appear within the data frame. I'd like to be able to restrict the feature that appears within the data frame to only the one feature defined by the indexing for that page. Is there an easy way to do this? Used to be able to do this in DSMapbook by clicking "Restrict display to active feature"

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

DarrenWiens2

You should check out Page Definition Queries. They are meant to restrict features based on the data driven page displayed.

BarbaraMcIntosh

Thanks...works great...

JasonMoore

This seems to be limited to the field used for the PageName. Is there a way to Query a layer based off of a different field in the Data Driven Pages Layer?

Is there a way to make the Page Definition Query look at Field 2 but the PageName be pulled from Field 1 in the Data Driven Pages (DDP) layer?

Example:
DDP Layer: Field 1 (PageName), Field 2 (Global ID)
Map Layer: Field 1 (Map Reference), Field 2(Global ID)

DarrenWiens2

I don't know of a way to apply a Page Definition to a field other than the Page Name, but you should be able to join the DDP Layer to the Map Layer table to access the matching Page Names.

Example:
DDP Layer: Field1 (PageName), Field2 (Global ID)
Map Layer: Field1 (Map Reference), Field2(Global ID)

JOIN ->

Map Layer: Map.Field1 (Map Reference), Map.Field2 (Global ID), DDP.Field2 (Global ID), DDP.Field1 (PageName)

Screenshot 2024-08-20 171535.png

MichaelBranscomb_0-1724152129616.png

MichaelBranscomb_2-1724152338068.png

JasonMoore

Thank you for your promt reply. I tried your solution and came up bust.

That would work under most normal circumsances.

However, the problem is that when you join the two layers the each Global_ID actually has two PageName record associated with them, so there isn't a unique match that way.

DarrenWiens2

I'm pretty sure this is what you want: Make Query Table. You need a many-to-one join between your map layer (many) and data driven pages (one), based on Global ID being equal.

JasonMoore

Thanks again for your prompt reply.

I will look into this and let you know of the outcome.

JasonMoore

This works great if the data is stored in the same database. However, that is another hurdle I must overcome. The Map Layer is in an SDE database, that I do not have adequate privledges to alter the schema as I would need it, and the Pages Layer is in a File GDB.

I really wish I could just write a definition query on a layer based upon a sub query from another layer.

Map Layer: GLOBALID IN (SELECT GLOBALID FROM DDP_LAYER)

JasonMoore

I have found a work around. PYTHON saved the day again. Something like the following.

# Import Modules
import arcpy, os

# Set Variables
mxdpath = r'FULL PATH TO MXD FILE' # string
outputfolder = 'FULL PATH TO OUTPUT FOLDER' # string
namefield = 'THE FIELD CONTAINING THE NAME OF THE RESULTING PDF FILE' # string
queryfield = 'THE FIELD CONTAINING THE VALUE FOR THE DESIRED QUERY' # string
layers = ['LIST','OF','LAYERS'] # list

mxd = arcpy.mapping.MapDocument(mxdpath)
# Start Loop through Data Driven Pages
for pageNum in range(1, mxd.dataDrivenPages.pageCount + 1)
mxd.dataDrivenPages.currentPageID = pageNum # set the current page
pageName = mxd.dataDrivenPages.pageRow.getValue(field) # get the pageName
pageName += '.pdf' # add '.pdf' extension for file name
pdf = os.path.join(outputfolder, pageName) # add pageName to output folder to get full output path
# Start Loop through all layers of mxd file
for lyr in arcpy.mapping.ListLayers(mxd) # for every layer in mxd's Layer List
    if lyr.name in layers: # if layer name in user input list above
      value = mxd.DataDrivenPages.pageRow.getValue(queryfield) # get the value out of the query field
      if lyr.defintionQuery == True: # if a defintionQuery Exsts...
        query = lyr.defintionQuery + "AND QueryField = \'%s\'" % (value) # Add the new to the old
      else:
        query = "QueryField = \'$s\'" % (value) # else create a new query
      lyr.defintionQuery = query # set the layers defintionQuery
    else:
      print 'Next' # else print next, this isn't necassary, but its a good place holder
    arcpy.mapping.ExportToPDF(mxd, pdf) # export the current Page to pdf

del mxd, lyr, pageName, pageNum, query, value

JasonMoore

It dropped the indentation, so be careful. Sorry.

JeffreyBarrette

Just as an FYI. If you highlight your code and click the # button it will wrap your code in special CODE tags so you don't lose the python indentation. For example - not 100% sure I got your indents correct:

# Import Modules
import arcpy, os

# Set Variables
mxdpath = r'FULL PATH TO MXD FILE' # string 
outputfolder = 'FULL PATH TO OUTPUT FOLDER' # string 
namefield = 'THE FIELD CONTAINING THE NAME OF THE RESULTING PDF FILE' # string 
queryfield = 'THE FIELD CONTAINING THE VALUE FOR THE DESIRED QUERY' # string 
layers = ['LIST','OF','LAYERS'] # list

mxd = arcpy.mapping.MapDocument(mxdpath)
# Start Loop through Data Driven Pages
for pageNum in range(1, mxd.dataDrivenPages.pageCount + 1)
    mxd.dataDrivenPages.currentPageID = pageNum # set the current page
    pageName = mxd.dataDrivenPages.pageRow.getValue(field) # get the pageName
    pageName += '.pdf' # add '.pdf' extension for file name
    pdf = os.path.join(outputfolder, pageName) # add pageName to output folder to get full output path
    # Start Loop through all layers of mxd file
    for lyr in arcpy.mapping.ListLayers(mxd) # for every layer in mxd's Layer List
        if lyr.name in layers: # if layer name in user input list above
            value = mxd.DataDrivenPages.pageRow.getValue(queryfield) # get value of query field
            if lyr.defintionQuery == True: # if a defintionQuery Exsts...
                query = lyr.defintionQuery + "AND QueryField = \'%s\'" % (value) # Add new to old
            else:
                query = "QueryField = \'$s\'" % (value) # else create a new query
                lyr.defintionQuery = query # set the layers defintionQuery
        else:
            print 'Next' # else print next, this isn't necassary, but its a good place holder

arcpy.mapping.ExportToPDF(mxd, pdf) # export the current Page to pdf
del mxd, lyr, pageName, pageNum, query, value

JasonMoore

Thank you, that is nice to know.

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.