I am currently working on a custom tool that helps me automate some of my reports. Part of the reports deliverable in a spreadsheet that has footage by each report generated. The reports are KMZs. My script runs as anticipated and created tables as the script says to, but the location in which they are being saved is the default.gdb in my local documents in the ArcGIS folder. I need to find a way to either be able to delete the tables created in the gdb after I'm able to pull my information using python or being able to save it in a custom location. My current code looks like this: import arcpy import arcpy . mapping as map from arcpy import env import datetime date = datetime . date . today ( ) stats = [ ] statesFS = { 6 : 'California' , 14 : 'Illinois' } statesAbbreviationsFS = { 6 : 'CA' , 14 : 'IL' } statesCDCCode = { 6 : 'California CDC Code' , 14 : 'Illinois CDC Code' } for state in statesFS : valueStatesFS = dict . get ( statesFS , state ) valueStatesAbbreviationsFS = dict . get ( statesAbbreviationsFS , state ) valueCDCCode = dict . get ( statesCDCCode , state ) stateMapName = str ( valueStatesAbbreviationsFS ) + "-" + str ( valueCDCCode ) + "-" + str ( date ) for field in arcpy . ListFields ( 'Input Feature Class' ) : if field . name == 'TotalFeet' : stats . append ( [ 'TotalFeet' , "SUM" ] ) arcpy . Statistics_analysis ( 'Input Feature Class' , stateMapName , stats , "" ) Any help is appreciated.

Figured it out. Here's my solution which just adds to your code Blake: Blake, thank you so much for the help! some of the variables were already defined before so not included in my solution code unless asked for! import arcpy import datetime import os mxd = arcpy . mapping . MapDocument ( "Current" ) date = datetime . date . today ( ) unitedStatesBoundary = arcpy . mapping . ListLayers ( mxd , 'United States Boundary' ) [ 0 ] targetFeature = arcpy . mapping . ListLayers ( mxd , 'Target Feature' ) [ 0 ] mapName = str ( mxd . filePath ) . split ( '\\' ) [ - 1 : ] [ 0 ] [ : - 4 ] mapFolder = str ( mxd . filePath ) [ : 23 ] saveLocFS = mapFolder folderNameFS = "{} UG {} {}" . format ( mapName [ 0 : 7 ] , mapName [ 8 : ] , date ) df = arcpy . mapping . ListDataFrames ( mxd ) [ 0 ] stats = [ ] statesFS = { 6 : 'California' } statesAbbreviationsFS = { 6 : 'CA' } statesCDCCode = { 6 : 'California CDC Code' } for state in statesFS : valueStatesFS = dict . get ( statesFS , state ) valueStatesAbbreviationsFS = dict . get ( statesAbbreviationsFS , state ) valueCDCCode = dict . get ( statesCDCCode , state ) unitedStatesBoundary . definitionQuery = "Name = '{}'" . format ( valueStatesFS ) arcpy . RefreshActiveView ( ) arcpy . SelectLayerByLocation_management ( targetFeature , "intersect" , unitedStatesBoundary , "" , "NEW_SELECTION" ) mxd . save ( ) stateMapNameXLS = "{}_{}.xls" . format ( valueStatesAbbreviationsFS , valueCDCCode ) outXLS = os . path . join ( footageReportFolder , footageReportFolderName , stateMapNameXLS ) exportLoc = "{}/{}/{}" . format ( footageReportFolder , footageReportFolderName , footageReportGDB ) stateMapName - "{}_{}" . format ( valueStatesAbbreviationsFS , valueCDCCode ) for field in arcpy . ListFields ( 'Target Feature' ) : if field . name == 'TotalFeet' : stats . append ( [ 'TotalFeet' , "SUM" ] ) stateMap_stats_inmem = os . path . join ( "in_memory" , "stateMap_stats_inmem" ) try : arcpy . Statistics_analysis ( 'Target Feature' , stateMap_stats_inmem , stats ) arcpy . TableToTable_conversion ( 'Target Feature' , exportLoc , stateMapName ) arcpy . TableToExcel_conversion ( stateMap_stats_inmem , outXLS ) finally : arcpy . Delete_management ( "in_memory" )

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

Need to delete tables created in default geodatabase

VishalShah2

I am currently working on a custom tool that helps me automate some of my reports. Part of the reports deliverable in a spreadsheet that has footage by each report generated. The reports are KMZs. My script runs as anticipated and created tables as the script says to, but the location in which they are being saved is the default.gdb in my local documents in the ArcGIS folder. I need to find a way to either be able to delete the tables created in the gdb after I'm able to pull my information using python or being able to save it in a custom location. My current code looks like this:

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping <SPAN class="keyword token">as</SPAN> map
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
<SPAN class="keyword token">import</SPAN> datetime

date <SPAN class="operator token">=</SPAN> datetime<SPAN class="punctuation token">.</SPAN>date<SPAN class="punctuation token">.</SPAN>today<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
stats <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

statesFS <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'California'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">14</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'Illinois'</SPAN><SPAN class="punctuation token">}</SPAN>
statesAbbreviationsFS <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'CA'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">14</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'IL'</SPAN><SPAN class="punctuation token">}</SPAN>
statesCDCCode <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'California CDC Code'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">14</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'Illinois CDC Code'</SPAN><SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">for</SPAN> state <SPAN class="keyword token">in</SPAN> statesFS<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; valueStatesFS <SPAN class="operator token">=</SPAN> dict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>statesFS<SPAN class="punctuation token">,</SPAN> state<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; valueStatesAbbreviationsFS <SPAN class="operator token">=</SPAN> dict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>statesAbbreviationsFS<SPAN class="punctuation token">,</SPAN> state<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; valueCDCCode <SPAN class="operator token">=</SPAN> dict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>statesCDCCode<SPAN class="punctuation token">,</SPAN> state<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; stateMapName <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>valueStatesAbbreviationsFS<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN><SPAN class="string token">"-"</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>valueCDCCode<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"-"</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>date<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Input Feature Class'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> field<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN> <SPAN class="string token">'TotalFeet'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stats<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'TotalFeet'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SUM"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Statistics_analysis<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Input Feature Class'</SPAN><SPAN class="punctuation token">,</SPAN> stateMapName<SPAN class="punctuation token">,</SPAN> stats<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</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>

Any help is appreciated.

Find more posts tagged with

Accepted answers

VishalShah2

Figured it out. Here's my solution which just adds to your code Blake:

Blake, thank you so much for the help!

some of the variables were already defined before so not included in my solution code unless asked for!

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

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>
date <SPAN class="operator token">=</SPAN> datetime<SPAN class="punctuation token">.</SPAN>date<SPAN class="punctuation token">.</SPAN>today<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
unitedStatesBoundary <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">'United States Boundary'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
targetFeature <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">'Target Feature'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
mapName <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">.</SPAN>filePath<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'\\'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN>

mapFolder <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">.</SPAN>filePath<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">23</SPAN><SPAN class="punctuation token">]</SPAN>
saveLocFS <SPAN class="operator token">=</SPAN> mapFolder
folderNameFS <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{} UG {} {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>mapName<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> mapName<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> date<SPAN class="punctuation token">)</SPAN>
df <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListDataFrames<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
stats <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

statesFS <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'California'</SPAN><SPAN class="punctuation token">}</SPAN>
statesAbbreviationsFS <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'CA'</SPAN><SPAN class="punctuation token">}</SPAN>
statesCDCCode <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'California CDC Code'</SPAN><SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">for</SPAN> state <SPAN class="keyword token">in</SPAN> statesFS<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; valueStatesFS <SPAN class="operator token">=</SPAN> dict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>statesFS<SPAN class="punctuation token">,</SPAN> state<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; valueStatesAbbreviationsFS <SPAN class="operator token">=</SPAN> dict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>statesAbbreviationsFS<SPAN class="punctuation token">,</SPAN> state<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; valueCDCCode <SPAN class="operator token">=</SPAN> dict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>statesCDCCode<SPAN class="punctuation token">,</SPAN> state<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; unitedStatesBoundary<SPAN class="punctuation token">.</SPAN>definitionQuery <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Name = '{}'"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>valueStatesFS<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>RefreshActiveView<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByLocation_management<SPAN class="punctuation token">(</SPAN>targetFeature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"intersect"</SPAN><SPAN class="punctuation token">,</SPAN>unitedStatesBoundary<SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; mxd<SPAN class="punctuation token">.</SPAN>save<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; stateMapNameXLS <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{}_{}.xls"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>valueStatesAbbreviationsFS<SPAN class="punctuation token">,</SPAN> valueCDCCode<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; outXLS <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>footageReportFolder<SPAN class="punctuation token">,</SPAN> footageReportFolderName<SPAN class="punctuation token">,</SPAN> stateMapNameXLS<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; exportLoc <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{}/{}/{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>footageReportFolder<SPAN class="punctuation token">,</SPAN> footageReportFolderName<SPAN class="punctuation token">,</SPAN> footageReportGDB<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; stateMapName <SPAN class="operator token">-</SPAN> <SPAN class="string token">"{}_{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>valueStatesAbbreviationsFS<SPAN class="punctuation token">,</SPAN> valueCDCCode<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Target Feature'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> field<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN> <SPAN class="string token">'TotalFeet'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stats<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'TotalFeet'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SUM"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stateMap_stats_inmem <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"in_memory"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"stateMap_stats_inmem"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Statistics_analysis<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Target Feature'</SPAN><SPAN class="punctuation token">,</SPAN> stateMap_stats_inmem<SPAN class="punctuation token">,</SPAN> stats<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableToTable_conversion<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Target Feature'</SPAN><SPAN class="punctuation token">,</SPAN> exportLoc<SPAN class="punctuation token">,</SPAN> stateMapName<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableToExcel_conversion<SPAN class="punctuation token">(</SPAN>stateMap_stats_inmem<SPAN class="punctuation token">,</SPAN> outXLS<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">finally</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"in_memory"</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>

All comments

VishalShah2

Figured it out. Here's my solution which just adds to your code Blake:

Blake, thank you so much for the help!

some of the variables were already defined before so not included in my solution code unless asked for!

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

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>
date <SPAN class="operator token">=</SPAN> datetime<SPAN class="punctuation token">.</SPAN>date<SPAN class="punctuation token">.</SPAN>today<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
unitedStatesBoundary <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">'United States Boundary'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
targetFeature <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">'Target Feature'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
mapName <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">.</SPAN>filePath<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'\\'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN>

mapFolder <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">.</SPAN>filePath<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">23</SPAN><SPAN class="punctuation token">]</SPAN>
saveLocFS <SPAN class="operator token">=</SPAN> mapFolder
folderNameFS <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{} UG {} {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>mapName<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> mapName<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> date<SPAN class="punctuation token">)</SPAN>
df <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListDataFrames<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
stats <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

statesFS <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'California'</SPAN><SPAN class="punctuation token">}</SPAN>
statesAbbreviationsFS <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'CA'</SPAN><SPAN class="punctuation token">}</SPAN>
statesCDCCode <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'California CDC Code'</SPAN><SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">for</SPAN> state <SPAN class="keyword token">in</SPAN> statesFS<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; valueStatesFS <SPAN class="operator token">=</SPAN> dict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>statesFS<SPAN class="punctuation token">,</SPAN> state<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; valueStatesAbbreviationsFS <SPAN class="operator token">=</SPAN> dict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>statesAbbreviationsFS<SPAN class="punctuation token">,</SPAN> state<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; valueCDCCode <SPAN class="operator token">=</SPAN> dict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>statesCDCCode<SPAN class="punctuation token">,</SPAN> state<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; unitedStatesBoundary<SPAN class="punctuation token">.</SPAN>definitionQuery <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Name = '{}'"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>valueStatesFS<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>RefreshActiveView<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByLocation_management<SPAN class="punctuation token">(</SPAN>targetFeature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"intersect"</SPAN><SPAN class="punctuation token">,</SPAN>unitedStatesBoundary<SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; mxd<SPAN class="punctuation token">.</SPAN>save<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; stateMapNameXLS <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{}_{}.xls"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>valueStatesAbbreviationsFS<SPAN class="punctuation token">,</SPAN> valueCDCCode<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; outXLS <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>footageReportFolder<SPAN class="punctuation token">,</SPAN> footageReportFolderName<SPAN class="punctuation token">,</SPAN> stateMapNameXLS<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; exportLoc <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{}/{}/{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>footageReportFolder<SPAN class="punctuation token">,</SPAN> footageReportFolderName<SPAN class="punctuation token">,</SPAN> footageReportGDB<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; stateMapName <SPAN class="operator token">-</SPAN> <SPAN class="string token">"{}_{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>valueStatesAbbreviationsFS<SPAN class="punctuation token">,</SPAN> valueCDCCode<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Target Feature'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> field<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN> <SPAN class="string token">'TotalFeet'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stats<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'TotalFeet'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SUM"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stateMap_stats_inmem <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"in_memory"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"stateMap_stats_inmem"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Statistics_analysis<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Target Feature'</SPAN><SPAN class="punctuation token">,</SPAN> stateMap_stats_inmem<SPAN class="punctuation token">,</SPAN> stats<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableToTable_conversion<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Target Feature'</SPAN><SPAN class="punctuation token">,</SPAN> exportLoc<SPAN class="punctuation token">,</SPAN> stateMapName<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableToExcel_conversion<SPAN class="punctuation token">(</SPAN>stateMap_stats_inmem<SPAN class="punctuation token">,</SPAN> outXLS<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">finally</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"in_memory"</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>

VishalShah2

Blake,

I was able to follow your script most of the way through. I did have a question though. I do want to be able to save a copy of the results in my custom gdb (footage.gdb) hence why in my original script I used TableToTable_conversion previously. Anyway to incorporate that into your potential solution script? Your way made sense for some of the things. I do need to run tests to see if it works for me.

blake.terhune

Try this. Hopefully I didn't mess up your other logic.

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

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>
date <SPAN class="operator token">=</SPAN> datetime<SPAN class="punctuation token">.</SPAN>date<SPAN class="punctuation token">.</SPAN>today<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
unitedStatesBoundary <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">'United States Boundary'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
targetFeature <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">'Target Feature'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
mapName <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">.</SPAN>filePath<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'\\'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN>

mapFolder <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">.</SPAN>filePath<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">23</SPAN><SPAN class="punctuation token">]</SPAN>
saveLocFS <SPAN class="operator token">=</SPAN> mapFolder
folderNameFS <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{} UG {} {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>mapName<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> mapName<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> date<SPAN class="punctuation token">)</SPAN>
df <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListDataFrames<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
stats <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

statesFS <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'California'</SPAN><SPAN class="punctuation token">}</SPAN>
statesAbbreviationsFS <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'CA'</SPAN><SPAN class="punctuation token">}</SPAN>
statesCDCCode <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'California CDC Code'</SPAN><SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">for</SPAN> state <SPAN class="keyword token">in</SPAN> statesFS<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; valueStatesFS <SPAN class="operator token">=</SPAN> dict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>statesFS<SPAN class="punctuation token">,</SPAN> state<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; valueStatesAbbreviationsFS <SPAN class="operator token">=</SPAN> dict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>statesAbbreviationsFS<SPAN class="punctuation token">,</SPAN> state<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; valueCDCCode <SPAN class="operator token">=</SPAN> dict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>statesCDCCode<SPAN class="punctuation token">,</SPAN> state<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; unitedStatesBoundary<SPAN class="punctuation token">.</SPAN>definitionQuery <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Name = '{}'"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>valueStatesFS<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>RefreshActiveView<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByLocation_management<SPAN class="punctuation token">(</SPAN>targetFeature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"intersect"</SPAN><SPAN class="punctuation token">,</SPAN>unitedStatesBoundary<SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; mxd<SPAN class="punctuation token">.</SPAN>save<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; stateMapNameXLS <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{}_{}.xls"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>valueStatesAbbreviationsFS<SPAN class="punctuation token">,</SPAN> valueCDCCode<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; outXLS <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>footageReportFolder<SPAN class="punctuation token">,</SPAN> footageReportFolderName<SPAN class="punctuation token">,</SPAN> stateMapNameXLS<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Target Feature'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> field<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN> <SPAN class="string token">'TotalFeet'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stats<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'TotalFeet'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SUM"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stateMap_stats_inmem <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"in_memory"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"stateMap_stats_inmem"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Statistics_analysis<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Target Feature'</SPAN><SPAN class="punctuation token">,</SPAN> stateMap_stats_inmem<SPAN class="punctuation token">,</SPAN> stats<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableToExcel_conversion<SPAN class="punctuation token">(</SPAN>stateMap_stats_inmem<SPAN class="punctuation token">,</SPAN> outXLS<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">finally</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"in_memory"</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>

VishalShah2

Blake,

my code still creates in the Default.gdb in my documents on my local server. I was thinking of using the in_memory workspace but not sure how to incorporate that into my code. Do you think you can help me out with that? I'll post my code that currently is working for me:

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping <SPAN class="keyword token">as</SPAN> map
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
<SPAN class="keyword token">import</SPAN> datetime

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>
date <SPAN class="operator token">=</SPAN> datetime<SPAN class="punctuation token">.</SPAN>date<SPAN class="punctuation token">.</SPAN>today<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
unitedStatesBoundary <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">'United States Boundary'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
targetFeature <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">'Target Feature'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
mapName <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">.</SPAN>filePath<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'\\'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN>

mapFolder <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">.</SPAN>filePath<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">23</SPAN><SPAN class="punctuation token">]</SPAN>
saveLocFS <SPAN class="operator token">=</SPAN> mapFolder
folderNameFS <SPAN class="operator token">=</SPAN> mapName<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">" UG "</SPAN> <SPAN class="operator token">+</SPAN> mapName<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">" "</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>date<SPAN class="punctuation token">)</SPAN>

df <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListDataFrames<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
stats <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

statesFS <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'California'</SPAN><SPAN class="punctuation token">}</SPAN>
statesAbbreviationsFS <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'CA'</SPAN><SPAN class="punctuation token">}</SPAN>
statesCDCCode <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">'California CDC Code'</SPAN><SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">for</SPAN> state <SPAN class="keyword token">in</SPAN> statesFS<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; valueStatesFS <SPAN class="operator token">=</SPAN> dict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>statesFS<SPAN class="punctuation token">,</SPAN> state<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; valueStatesAbbreviationsFS <SPAN class="operator token">=</SPAN> dict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>statesAbbreviationsFS<SPAN class="punctuation token">,</SPAN> state<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; valueCDCCode <SPAN class="operator token">=</SPAN> dict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>statesCDCCode<SPAN class="punctuation token">,</SPAN> state<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; unitedStatesBoundaryQuery <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Name = "</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>valueStatesFS<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN>
&nbsp;&nbsp;&nbsp; unitedStatesBoundary<SPAN class="punctuation token">.</SPAN>definitionQuery <SPAN class="operator token">=</SPAN> unitedStatesBoundaryQuery
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>RefreshActiveView<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByLocation_management<SPAN class="punctuation token">(</SPAN>targetFeature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"intersect"</SPAN><SPAN class="punctuation token">,</SPAN>unitedStatesBoundary<SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; mxd<SPAN class="punctuation token">.</SPAN>save<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; stateMapName <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>valueStatesAbbreviationsFS<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"_"</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>valueCDCCode<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; footageFolder <SPAN class="operator token">=</SPAN> footageReportFolder <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> footageReportFolderName <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN>
&nbsp;&nbsp;&nbsp; footageGDB <SPAN class="operator token">=</SPAN> <SPAN class="string token">"footages.gdb"</SPAN>
&nbsp;&nbsp;&nbsp; inTable <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Target Feature'</SPAN>
&nbsp;&nbsp;&nbsp; exportLoc <SPAN class="operator token">=</SPAN> footageFolder <SPAN class="operator token">+</SPAN> footageGDB
&nbsp;&nbsp;&nbsp; outTable <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>stateMapName<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; outXLS <SPAN class="operator token">=</SPAN> footageFolder <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>stateMapName<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">".xls"</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Target Feature'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> field<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN> <SPAN class="string token">'TotalFeet'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stats<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'TotalFeet'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SUM"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Statistics_analysis<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Target Feature'</SPAN><SPAN class="punctuation token">,</SPAN> stateMapName<SPAN class="punctuation token">,</SPAN> stats<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableToTable_conversion<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN> exportLoc<SPAN class="punctuation token">,</SPAN> outTable<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableToExcel_conversion<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN> outXLS<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">''</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>

This code is creating it first in my Default.gdb and then saving a copy in my custom gdb called footage (referenced in the code). Then it is creating an excel spreadsheet. I am looking to skip saving in the Default.gdb and preferrable store in temp in_memory workspace and then at the end of my code, clear out the in_memory workspace.

blake.terhune

Try building the stateMapName as a full path instead of just a table name. If you want it to be a temporary table that is deleted, use in_memory workspace and delete it when finished. If you want to save the output to your custom location, just build the path with the os module.

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.