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; } } }

How to select points within a boundary layer and displaying the table of selected points in Data Driven Pages using Python?

FarhanMustafa

Dear sir,

Xander Bakker‌ Dan_Patterson

hope you are fine. I require your little favor. Please don't mind, I'm fairly new to development. Can you please rectify my code. I just tell you the detail about.

I am working on MapBook via DDP. I have to select points which are within the boundary layer of current page and then want to display the table in maps. I am done with other work just facing problem with selection.

I have a layer named "IndexLayer" which contains the boundaries of cities under the attribute "Division". There is another layer which contains points, that is named "tlsf". I want to select the points which are within the opened page boundary but as per my script, all the points are selected and displayed in the table. I am posting python code here. Please don't mind. Is it possible if I can get your email address? The code is given by:

<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> os<SPAN class="punctuation token">,</SPAN> sys
relpath <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>dirname<SPAN class="punctuation token">(</SPAN>sys<SPAN class="punctuation token">.</SPAN>argv<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

division <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#Reference MXD and layers</SPAN>
mxd <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>MapDocument<SPAN class="punctuation token">(</SPAN>relpath <SPAN class="operator token">+</SPAN> r<SPAN class="string token">"\map.mxd"</SPAN><SPAN class="punctuation token">)</SPAN>
transferStation <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListLayers<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"tlsf"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token">#Reference page layout elements</SPAN>
<SPAN class="keyword token">for</SPAN> elm <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListLayoutElements<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp; <SPAN class="keyword token">if</SPAN> elm<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN> <SPAN class="string token">"bar1"</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp; bar1 <SPAN class="operator token">=</SPAN> elm
&nbsp; <SPAN class="keyword token">if</SPAN> elm<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN> <SPAN class="string token">"bar2"</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp; bar2 <SPAN class="operator token">=</SPAN> elm
&nbsp; <SPAN class="keyword token">if</SPAN> elm<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN> <SPAN class="string token">"bar3"</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp; bar3 <SPAN class="operator token">=</SPAN> elm
&nbsp; <SPAN class="keyword token">if</SPAN> elm<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN> <SPAN class="string token">"bar1txt"</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp; bar1txt <SPAN class="operator token">=</SPAN> elm
&nbsp; <SPAN class="keyword token">if</SPAN> elm<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN> <SPAN class="string token">"bar2txt"</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp; bar2txt <SPAN class="operator token">=</SPAN> elm
&nbsp; <SPAN class="keyword token">if</SPAN> elm<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN> <SPAN class="string token">"bar3txt"</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp; bar3txt <SPAN class="operator token">=</SPAN> elm
&nbsp; <SPAN class="keyword token">if</SPAN> elm<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN> <SPAN class="string token">"NoGrowth"</SPAN><SPAN class="punctuation token">:</SPAN> noGrowth <SPAN class="operator token">=</SPAN> elm
&nbsp; <SPAN class="keyword token">if</SPAN> elm<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN> <SPAN class="string token">"horzLine"</SPAN><SPAN class="punctuation token">:</SPAN> horzLine <SPAN class="operator token">=</SPAN> elm
&nbsp; <SPAN class="keyword token">if</SPAN> elm<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN> <SPAN class="string token">"vertLine"</SPAN><SPAN class="punctuation token">:</SPAN> vertLine <SPAN class="operator token">=</SPAN> elm
&nbsp; <SPAN class="keyword token">if</SPAN> elm<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN> <SPAN class="string token">"cellTxt"</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp; cellTxt <SPAN class="operator token">=</SPAN> elm
&nbsp; <SPAN class="keyword token">if</SPAN> elm<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN> <SPAN class="string token">"headerTxt"</SPAN><SPAN class="punctuation token">:</SPAN> headerTxt <SPAN class="operator token">=</SPAN> elm
<SPAN class="comment token">#Clean-up before next page</SPAN>
<SPAN class="keyword token">for</SPAN> elm <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListLayoutElements<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"GRAPHIC_ELEMENT"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"*clone*"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp; elm<SPAN class="punctuation token">.</SPAN>delete<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> elm <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListLayoutElements<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"TEXT_ELEMENT"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"*clone*"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp; elm<SPAN class="punctuation token">.</SPAN>delete<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp; 
noGrowth<SPAN class="punctuation token">.</SPAN>elementPositionX <SPAN class="operator token">=</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">3</SPAN>
cellTxt<SPAN class="punctuation token">.</SPAN>elementPositionX <SPAN class="operator token">=</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">3</SPAN>
headerTxt<SPAN class="punctuation token">.</SPAN>elementPositionX <SPAN class="operator token">=</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">3</SPAN>
horzLine<SPAN class="punctuation token">.</SPAN>elementPositionX <SPAN class="operator token">=</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">3</SPAN>
vertLine<SPAN class="punctuation token">.</SPAN>elementPositionX <SPAN class="operator token">=</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">3</SPAN>

<SPAN class="comment token">#Reference DDP object and set appropriate page</SPAN>
ddp <SPAN class="operator token">=</SPAN> mxd<SPAN class="punctuation token">.</SPAN>dataDrivenPages
ddp<SPAN class="punctuation token">.</SPAN>currentPageID <SPAN class="operator token">=</SPAN> ddp<SPAN class="punctuation token">.</SPAN>getPageIDFromName<SPAN class="punctuation token">(</SPAN>division<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#Graphic table variable values</SPAN>
tableHeight <SPAN class="operator token">=</SPAN> <SPAN class="number token">3.0</SPAN>
tableWidth <SPAN class="operator token">=</SPAN> <SPAN class="number token">4.5</SPAN>
headerHeight <SPAN class="operator token">=</SPAN> <SPAN class="number token">0.2</SPAN>
rowHeight <SPAN class="operator token">=</SPAN> <SPAN class="number token">0.15</SPAN>
upperX <SPAN class="operator token">=</SPAN> <SPAN class="number token">11</SPAN>
upperY <SPAN class="operator token">=</SPAN> <SPAN class="number token">3.2</SPAN>

<SPAN class="comment token">#Build selection set</SPAN>
divisionName <SPAN class="operator token">=</SPAN> ddp<SPAN class="punctuation token">.</SPAN>pageRow<SPAN class="punctuation token">.</SPAN>Division
arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Processing: "</SPAN> <SPAN class="operator token">+</SPAN> division<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"IndexLayer"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Division"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; exp <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Division = divisionName'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"IndexLayer"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> exp<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># selection</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByLocation_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"transferStation"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"INTERSECT"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"IndexLayer4"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Select_analysis<SPAN class="punctuation token">(</SPAN>transferStation<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"in_memory\IndexLayer4"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">)</SPAN>
numRecords <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"in_memory\IndexLayer4"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>getOutput<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#Sort selection</SPAN>

<SPAN class="comment token">#Show selected features</SPAN>


<SPAN class="comment token">#Add note if there are no counties > 100%</SPAN>
<SPAN class="keyword token">if</SPAN> numRecords <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp; noGrowth<SPAN class="punctuation token">.</SPAN>elementPositionX <SPAN class="operator token">=</SPAN> <SPAN class="number token">3</SPAN>
&nbsp; noGrowth<SPAN class="punctuation token">.</SPAN>elementPositionY <SPAN class="operator token">=</SPAN> <SPAN class="number token">2</SPAN>
<SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp; <SPAN class="comment token">#if number of rows exceeds page space, resize row height</SPAN>
&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>tableHeight <SPAN class="operator token">-</SPAN> headerHeight<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">/</SPAN> numRecords<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token"><</SPAN> rowHeight<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; headerHeight <SPAN class="operator token">=</SPAN> headerHeight <SPAN class="operator token">*</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>tableHeight <SPAN class="operator token">-</SPAN> headerHeight<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">/</SPAN> numRecords<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">/</SPAN> rowHeight
&nbsp;&nbsp;&nbsp; rowHeight <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>tableHeight <SPAN class="operator token">-</SPAN> headerHeight<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">/</SPAN> numRecords
&nbsp; 
<SPAN class="comment token">#Set and clone vertical line work</SPAN>
vertLine<SPAN class="punctuation token">.</SPAN>elementHeight <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>headerHeight<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="punctuation token">(</SPAN>rowHeight <SPAN class="operator token">*</SPAN> numRecords<SPAN class="punctuation token">)</SPAN>
vertLine<SPAN class="punctuation token">.</SPAN>elementPositionX <SPAN class="operator token">=</SPAN> upperX
vertLine<SPAN class="punctuation token">.</SPAN>elementPositionY <SPAN class="operator token">=</SPAN> upperY

temp_vert <SPAN class="operator token">=</SPAN> vertLine<SPAN class="punctuation token">.</SPAN>clone<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"_clone"</SPAN><SPAN class="punctuation token">)</SPAN>
temp_vert<SPAN class="punctuation token">.</SPAN>elementPositionX <SPAN class="operator token">=</SPAN> upperX <SPAN class="operator token">+</SPAN> <SPAN class="number token">1.5</SPAN>
temp_vert <SPAN class="operator token">=</SPAN> vertLine<SPAN class="punctuation token">.</SPAN>clone<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"_clone"</SPAN><SPAN class="punctuation token">)</SPAN>
temp_vert<SPAN class="punctuation token">.</SPAN>elementPositionX <SPAN class="operator token">=</SPAN> upperX <SPAN class="operator token">+</SPAN> <SPAN class="number token">2.5</SPAN>
temp_vert <SPAN class="operator token">=</SPAN> vertLine<SPAN class="punctuation token">.</SPAN>clone<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"_clone"</SPAN><SPAN class="punctuation token">)</SPAN>
temp_vert<SPAN class="punctuation token">.</SPAN>elementPositionX <SPAN class="operator token">=</SPAN> upperX <SPAN class="operator token">+</SPAN> <SPAN class="number token">3.5</SPAN>
temp_vert <SPAN class="operator token">=</SPAN> vertLine<SPAN class="punctuation token">.</SPAN>clone<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"_clone"</SPAN><SPAN class="punctuation token">)</SPAN>
temp_vert<SPAN class="punctuation token">.</SPAN>elementPositionX <SPAN class="operator token">=</SPAN> upperX <SPAN class="operator token">+</SPAN> <SPAN class="number token">4.5</SPAN>
 
<SPAN class="comment token">#Set and clone horizontal line work</SPAN>
horzLine<SPAN class="punctuation token">.</SPAN>elementWidth <SPAN class="operator token">=</SPAN> tableWidth
horzLine<SPAN class="punctuation token">.</SPAN>elementPositionX <SPAN class="operator token">=</SPAN> upperX
horzLine<SPAN class="punctuation token">.</SPAN>elementPositionY <SPAN class="operator token">=</SPAN> upperY

horzLine<SPAN class="punctuation token">.</SPAN>clone<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"_clone"</SPAN><SPAN class="punctuation token">)</SPAN>
horzLine<SPAN class="punctuation token">.</SPAN>elementPositionY <SPAN class="operator token">=</SPAN> upperY <SPAN class="operator token">-</SPAN> headerHeight

<SPAN class="keyword token">print</SPAN> numRecords
y<SPAN class="operator token">=</SPAN>upperY <SPAN class="operator token">-</SPAN> headerHeight
<SPAN class="keyword token">for</SPAN> horz <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> numRecords<SPAN class="operator token">+</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp; y <SPAN class="operator token">=</SPAN> y <SPAN class="operator token">-</SPAN> rowHeight
&nbsp; temp_horz <SPAN class="operator token">=</SPAN> horzLine<SPAN class="punctuation token">.</SPAN>clone<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"_clone"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp; temp_horz<SPAN class="punctuation token">.</SPAN>elementPositionY <SPAN class="operator token">=</SPAN> y

<SPAN class="comment token">#Set header text elements</SPAN>
headerTxt<SPAN class="punctuation token">.</SPAN>fontSize <SPAN class="operator token">=</SPAN> headerHeight <SPAN class="operator token">/</SPAN> <SPAN class="number token">0.0155</SPAN>
headerTxt<SPAN class="punctuation token">.</SPAN>text <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Name"</SPAN>
headerTxt<SPAN class="punctuation token">.</SPAN>elementPositionX <SPAN class="operator token">=</SPAN> upperX <SPAN class="operator token">+</SPAN> <SPAN class="number token">0.75</SPAN>
headerTxt<SPAN class="punctuation token">.</SPAN>elementPositionY <SPAN class="operator token">=</SPAN> upperY <SPAN class="operator token">-</SPAN> <SPAN class="punctuation token">(</SPAN>headerHeight <SPAN class="operator token">/</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN>

newFieldTxt <SPAN class="operator token">=</SPAN> headerTxt<SPAN class="punctuation token">.</SPAN>clone<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"_clone"</SPAN><SPAN class="punctuation token">)</SPAN>
newFieldTxt<SPAN class="punctuation token">.</SPAN>text <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Type"</SPAN>
newFieldTxt<SPAN class="punctuation token">.</SPAN>elementPositionX <SPAN class="operator token">=</SPAN> upperX <SPAN class="operator token">+</SPAN> <SPAN class="number token">2</SPAN> 

newFieldTxt <SPAN class="operator token">=</SPAN> headerTxt<SPAN class="punctuation token">.</SPAN>clone<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"_clone"</SPAN><SPAN class="punctuation token">)</SPAN>
newFieldTxt<SPAN class="punctuation token">.</SPAN>text <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Longitude"</SPAN>
newFieldTxt<SPAN class="punctuation token">.</SPAN>elementPositionX <SPAN class="operator token">=</SPAN> upperX <SPAN class="operator token">+</SPAN> <SPAN class="number token">2.75</SPAN> 

newFieldTxt <SPAN class="operator token">=</SPAN> headerTxt<SPAN class="punctuation token">.</SPAN>clone<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"_clone"</SPAN><SPAN class="punctuation token">)</SPAN>
newFieldTxt<SPAN class="punctuation token">.</SPAN>text <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Latitude"</SPAN>
newFieldTxt<SPAN class="punctuation token">.</SPAN>elementPositionX <SPAN class="operator token">=</SPAN> upperX <SPAN class="operator token">+</SPAN> <SPAN class="number token">3.25</SPAN> 

<SPAN class="comment token">#Set and clone cell text elements</SPAN>
cellTxt<SPAN class="punctuation token">.</SPAN>fontSize <SPAN class="operator token">=</SPAN> rowHeight <SPAN class="operator token">/</SPAN> <SPAN class="number token">0.0155</SPAN>

y <SPAN class="operator token">=</SPAN> upperY <SPAN class="operator token">-</SPAN> headerHeight
rows <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"in_memory\IndexLayer4"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> rows<SPAN class="punctuation token">:</SPAN>
&nbsp; x <SPAN class="operator token">=</SPAN> upperX <SPAN class="operator token">+</SPAN> <SPAN class="number token">0.05</SPAN>
&nbsp; col1CellTxt <SPAN class="operator token">=</SPAN> cellTxt<SPAN class="punctuation token">.</SPAN>clone<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"_clone"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp; col1CellTxt<SPAN class="punctuation token">.</SPAN>text <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">.</SPAN>getValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Name"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp; col1CellTxt<SPAN class="punctuation token">.</SPAN>elementPositionX <SPAN class="operator token">=</SPAN> x
&nbsp; col1CellTxt<SPAN class="punctuation token">.</SPAN>elementPositionY <SPAN class="operator token">=</SPAN> y
&nbsp; col2CellTxt <SPAN class="operator token">=</SPAN> cellTxt<SPAN class="punctuation token">.</SPAN>clone<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"_clone"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp; col2CellTxt<SPAN class="punctuation token">.</SPAN>text <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">.</SPAN>getValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Type"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp; col2CellTxt<SPAN class="punctuation token">.</SPAN>elementPositionX <SPAN class="operator token">=</SPAN> x <SPAN class="operator token">+</SPAN> <SPAN class="number token">1.75</SPAN>
&nbsp; col2CellTxt<SPAN class="punctuation token">.</SPAN>elementPositionY <SPAN class="operator token">=</SPAN> y
&nbsp; col3CellTxt <SPAN class="operator token">=</SPAN> cellTxt<SPAN class="punctuation token">.</SPAN>clone<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"_clone"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp; col3CellTxt<SPAN class="punctuation token">.</SPAN>text <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>round<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">.</SPAN>getValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Longitude"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp; col3CellTxt<SPAN class="punctuation token">.</SPAN>elementPositionX <SPAN class="operator token">=</SPAN> x <SPAN class="operator token">+</SPAN> <SPAN class="number token">3</SPAN>
&nbsp; col3CellTxt<SPAN class="punctuation token">.</SPAN>elementPositionY <SPAN class="operator token">=</SPAN> y
&nbsp; col4CellTxt <SPAN class="operator token">=</SPAN> cellTxt<SPAN class="punctuation token">.</SPAN>clone<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"_clone"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp; col4CellTxt<SPAN class="punctuation token">.</SPAN>text <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>round<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">.</SPAN>getValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Longitude"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp; col4CellTxt<SPAN class="punctuation token">.</SPAN>elementPositionX <SPAN class="operator token">=</SPAN> x <SPAN class="operator token">+</SPAN><SPAN class="number token">4.75</SPAN>
&nbsp; col4CellTxt<SPAN class="punctuation token">.</SPAN>elementPositionY <SPAN class="operator token">=</SPAN> y
&nbsp; y <SPAN class="operator token">=</SPAN> y <SPAN class="operator token">-</SPAN> rowHeight
arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"in_memory\IndexLayer4"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"in_memory\IndexLayer4"</SPAN><SPAN class="punctuation token">)</SPAN>



arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ExportToPDF<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">,</SPAN> relpath <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\\"</SPAN> <SPAN class="operator token">+</SPAN> division <SPAN class="operator token">+</SPAN> <SPAN class="string token">".pdf"</SPAN><SPAN class="punctuation token">)</SPAN>
os<SPAN class="punctuation token">.</SPAN>startfile<SPAN class="punctuation token">(</SPAN>relpath <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\\"</SPAN> <SPAN class="operator token">+</SPAN> division <SPAN class="operator token">+</SPAN> <SPAN class="string token">".pdf"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

All comments

FarhanMustafa

Dear sir, hope you are fine. I require your little favor. Please don't mind, I'm fairly new to development. Can you please rectify my code. I just tell you the detail about.

I am working on MapBook via DDP. I have to select points which are intersecting the boundary layer of current page and then want to display the table in maps. I am done with other work just facing problem with selection.

I have a layer named "IndexLayer" which contains the boundaries of cities under the attribute "Division". There is another layer which contains points, that is named "tlsf". I want to select the points which are intersecting the opened page boundary but as per my script, all the points are selected and displayed in the table. I am posting python code here. I tried to write the code under suggested format but with very sorry I coudn't write in that way. Please don't mind. Is it possible if I can get your email address? The code is given by

import arcpy, os, sys
relpath = os.path.dirname(sys.argv[0])

division = arcpy.GetParameterAsText(0)

#Reference MXD and layers
mxd = arcpy.mapping.MapDocument(relpath + r"\map.mxd")
transferStation = arcpy.mapping.ListLayers(mxd, "tlsf")[0]

#Reference page layout elements
for elm in arcpy.mapping.ListLayoutElements(mxd):
if elm.name == "bar1": bar1 = elm
if elm.name == "bar2": bar2 = elm
if elm.name == "bar3": bar3 = elm
if elm.name == "bar1txt": bar1txt = elm
if elm.name == "bar2txt": bar2txt = elm
if elm.name == "bar3txt": bar3txt = elm
if elm.name == "NoGrowth": noGrowth = elm
if elm.name == "horzLine": horzLine = elm
if elm.name == "vertLine": vertLine = elm
if elm.name == "cellTxt": cellTxt = elm
if elm.name == "headerTxt": headerTxt = elm
#Clean-up before next page
for elm in arcpy.mapping.ListLayoutElements(mxd, "GRAPHIC_ELEMENT", "*clone*"):
elm.delete()
for elm in arcpy.mapping.ListLayoutElements(mxd, "TEXT_ELEMENT", "*clone*"):
elm.delete()

noGrowth.elementPositionX = -3
cellTxt.elementPositionX = -3
headerTxt.elementPositionX = -3
horzLine.elementPositionX = -3
vertLine.elementPositionX = -3

#Reference DDP object and set appropriate page
ddp = mxd.dataDrivenPages
ddp.currentPageID = ddp.getPageIDFromName(division)

#Graphic table variable values
tableHeight = 3.0
tableWidth = 4.5
headerHeight = 0.2
rowHeight = 0.15
upperX = 11
upperY = 3.2

#Build selection set
divisionName = ddp.pageRow.Division
arcpy.AddMessage("Processing: " + division)
with arcpy.da.SearchCursor("IndexLayer", ("Division")) as cursor:
for row in cursor:
exp = 'Division = divisionName'.format(row[0])
arcpy.SelectLayerByAttribute_management("IndexLayer", "NEW_SELECTION", exp)
# selection
arcpy.SelectLayerByLocation_management("transferStation", "INTERSECT", "NEW_SELECTION", "IndexLayer4")
arcpy.Select_analysis(transferStation, "in_memory\IndexLayer4", '')
numRecords = int(arcpy.GetCount_management("in_memory\IndexLayer4").getOutput(0))

#Sort selection

#Show selected features

#Add note if there are no counties > 100%
if numRecords == 0:
noGrowth.elementPositionX = 3
noGrowth.elementPositionY = 2
else:
#if number of rows exceeds page space, resize row height
if ((tableHeight - headerHeight) / numRecords) < rowHeight:
headerHeight = headerHeight * ((tableHeight - headerHeight) / numRecords) / rowHeight
rowHeight = (tableHeight - headerHeight) / numRecords

#Set and clone vertical line work
vertLine.elementHeight = (headerHeight) + (rowHeight * numRecords)
vertLine.elementPositionX = upperX
vertLine.elementPositionY = upperY

temp_vert = vertLine.clone("_clone")
temp_vert.elementPositionX = upperX + 1.5
temp_vert = vertLine.clone("_clone")
temp_vert.elementPositionX = upperX + 2.5
temp_vert = vertLine.clone("_clone")
temp_vert.elementPositionX = upperX + 3.5
temp_vert = vertLine.clone("_clone")
temp_vert.elementPositionX = upperX + 4.5

#Set and clone horizontal line work
horzLine.elementWidth = tableWidth
horzLine.elementPositionX = upperX
horzLine.elementPositionY = upperY

horzLine.clone("_clone")
horzLine.elementPositionY = upperY - headerHeight

print numRecords
y=upperY - headerHeight
for horz in range(1, numRecords+1):
y = y - rowHeight
temp_horz = horzLine.clone("_clone")
temp_horz.elementPositionY = y

#Set header text elements
headerTxt.fontSize = headerHeight / 0.0155
headerTxt.text = "Name"
headerTxt.elementPositionX = upperX + 0.75
headerTxt.elementPositionY = upperY - (headerHeight / 2)

newFieldTxt = headerTxt.clone("_clone")
newFieldTxt.text = "Type"
newFieldTxt.elementPositionX = upperX + 2

newFieldTxt = headerTxt.clone("_clone")
newFieldTxt.text = "Longitude"
newFieldTxt.elementPositionX = upperX + 2.75

newFieldTxt = headerTxt.clone("_clone")
newFieldTxt.text = "Latitude"
newFieldTxt.elementPositionX = upperX + 3.25

#Set and clone cell text elements
cellTxt.fontSize = rowHeight / 0.0155

y = upperY - headerHeight
rows = arcpy.SearchCursor("in_memory\IndexLayer4")
for row in rows:
x = upperX + 0.05
col1CellTxt = cellTxt.clone("_clone")
col1CellTxt.text = row.getValue("Name")
col1CellTxt.elementPositionX = x
col1CellTxt.elementPositionY = y
col2CellTxt = cellTxt.clone("_clone")
col2CellTxt.text = row.getValue("Type")
col2CellTxt.elementPositionX = x + 1.75
col2CellTxt.elementPositionY = y
col3CellTxt = cellTxt.clone("_clone")
col3CellTxt.text = str(round(row.getValue("Longitude"), 2))
col3CellTxt.elementPositionX = x + 3
col3CellTxt.elementPositionY = y
col4CellTxt = cellTxt.clone("_clone")
col4CellTxt.text = str(round(row.getValue("Longitude"), 2))
col4CellTxt.elementPositionX = x +4.75
col4CellTxt.elementPositionY = y
y = y - rowHeight
arcpy.Delete_management("in_memory\IndexLayer4")
arcpy.Delete_management("in_memory\IndexLayer4")

arcpy.mapping.ExportToPDF(mxd, relpath + "\\" + division + ".pdf")
os.startfile(relpath + "\\" + division + ".pdf")

XanderBakker

You should really repost the code using these instrucciones: https://community.esri.com/docs/DOC-8691-posting-code-with-syntax-highlighting-on-geonet . The way you posted the code makes it very hard to read since all the important indentations are removed and the code is no longer valid.

FarhanMustafa

0-Dear sir,

I am hopeful that you will be fine. Please look at the problem I am pointing at:

I am working on mapbook and data driven is applied on a layer named "IndexLayer" against "Divsion" field. This layer contains the boundaries of Divisions (Division is an administrative distribution, which contains more than one city in my country). I have some point which are placed in a layer named, "tlsf". At the data driven pages, on the each division page, I want to select the point which lie into the corresponding boundary and then want them to display on the map. I have worked on the table. The problem I am getting is a the selection end. The received error is attached in the screen shot. I am also pasting the code here. I require your kindness. Thanks

The error I am receiving while executing.

import arcpy, os, sys
relpath = os.path.dirname(sys.argv[0])

division = arcpy.GetParameterAsText(0)

#Reference MXD and layers
mxd = arcpy.mapping.MapDocument(relpath + r"\map.mxd")
transferStation = arcpy.mapping.ListLayers(mxd, "tlsf")[0]

#Reference DDP object and set appropriate page
ddp = mxd.dataDrivenPages
ddp.currentPageID = ddp.getPageIDFromName(division)

#Graphic table variable values
tableHeight = 3.0
tableWidth = 2.5
headerHeight = 0.2
rowHeight = 0.15
upperX = 2.8
upperY = 3.2

#Build selection set
divisionName = ddp.pageRow.Division
arcpy.AddMessage("Processing: " + division)
with arcpy.da.SearchCursor("IndexLayer", ("Division")) as cursor:
for row in cursor:
exp = 'Division = division'.format(row[0])
arcpy.SelectLayerByAttribute_management("IndexLayer", "NEW_SELECTION", exp)
# selection
arcpy.SelectLayerByLocation_management("transferStation", "WITHIN", "NEW_SELECTION", "IndexLayer")
arcpy.Select_analysis(transferStation, "in_memory\select1", '')
numRecords = int(arcpy.GetCount_management("in_memory\select1").getOutput(0))

#Sort selection

#Show selected features

temp_vert = vertLine.clone("_clone")
temp_vert.elementPositionX = upperX + 1.5
temp_vert = vertLine.clone("_clone")
temp_vert.elementPositionX = upperX + 2.5

#Set and clone horizontal line work
horzLine.elementWidth = tableWidth
horzLine.elementPositionX = upperX
horzLine.elementPositionY = upperY

horzLine.clone("_clone")
horzLine.elementPositionY = upperY - headerHeight

print numRecords
y=upperY - headerHeight
for horz in range(1, numRecords+1):
y = y - rowHeight
temp_horz = horzLine.clone("_clone")
temp_horz.elementPositionY = y

#Set header text elements
headerTxt.fontSize = headerHeight / 0.0155
headerTxt.text = "Name"
headerTxt.elementPositionX = upperX + 0.75
headerTxt.elementPositionY = upperY - (headerHeight / 2)

newFieldTxt = headerTxt.clone("_clone")
newFieldTxt.text = "Type"
newFieldTxt.elementPositionX = upperX + 2

newFieldTxt = headerTxt.clone("_clone")
newFieldTxt.text = "Longitude"
newFieldTxt.elementPositionX = upperX + 2

newFieldTxt = headerTxt.clone("_clone")
newFieldTxt.text = "Latitude"
newFieldTxt.elementPositionX = upperX + 2

#Set and clone cell text elements
cellTxt.fontSize = rowHeight / 0.0155

y = upperY - headerHeight
rows = arcpy.SearchCursor("in_memory\select1")
for row in rows:
x = upperX + 0.05
col1CellTxt = cellTxt.clone("_clone")
col1CellTxt.text = row.getValue("Name")
col1CellTxt.elementPositionX = x
col1CellTxt.elementPositionY = y
col2CellTxt = cellTxt.clone("_clone")
col2CellTxt.text = row.getValue("Type")
col2CellTxt.elementPositionX = x + 1.75
col2CellTxt.elementPositionY = y
col3CellTxt.text = str(round(row.getValue("Longitude"), 2))
col3CellTxt.elementPositionX = x + 3
col3CellTxt.elementPositionY = y
col4CellTxt.text = str(round(row.getValue("Longitude"), 2))
col4CellTxt.elementPositionX = x +4.75
col4CellTxt.elementPositionY = y
y = y - rowHeight

arcpy.mapping.ExportToPDF(mxd, relpath + "\\" + division + ".pdf")
os.startfile(relpath + "\\" + division + ".pdf")

FarhanMustafa

Thank you sir for your kindness, I found it really helpful.

boletin5_video_lab2.png

MicahBabinski

Hello Farhan,

I think Gurminder's advice is quite good. If you have access to the Esri Production Mapping extension, it looks like you can use the dynamic table layout element to configure and produce the table according to these guidelines.

Once you get the dynamic table set up in your layout, here is some code that may help you get started with producing your maps:

<SPAN class="keyword token">import</SPAN> arcpy

<SPAN class="comment token"># create mxd and data frame objects</SPAN>
mxd <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>MapDocument<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"CURRENT"</SPAN><SPAN class="punctuation token">)</SPAN>
df <SPAN class="operator token">=</SPAN> mxd<SPAN class="punctuation token">.</SPAN>activeDataFrame

<SPAN class="comment token"># create a counter that you can use to name your output PDFs</SPAN>
counter <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>

<SPAN class="comment token"># loop through the cities layer with a search cursor</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"cities_layer"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"OBJECTID"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># select the city</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; exp <SPAN class="operator token">=</SPAN> <SPAN class="string token">'OBJECTID = {}'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"cities_layer"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> exp<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># zoom to the city</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; df<SPAN class="punctuation token">.</SPAN>zoomToSelectedFeatures<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>RefreshActiveView<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># select the population points within the current city</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByLocation_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"population_points"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"INTERSECT"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"cities_layer"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># export the map to PDF and increment the counter</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ExportToPDF<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"CityPDF_{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">(</SPAN>counter<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; counter <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Hope that helps! Good luck.

Micah

GurminderBharani

You can use the Search Cursor in the python module named arcpy to query the feature layer.

You can also use the result from the Search Cursor with Make Feature Layer tool to create a new Feature Layer.

For zooming up to certain extent here is the StackOverflow Article where you can set the extent of the data frame.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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