Hi, I'm writing a script that is part 2 of a bigger automation process. Part 1 was written by someone else (who, of course, doesn't work at the company anymore) and works perfectly. My script piggy backs on features created in part 1 and I'm getting 2 errors: Traceback ( most recent call last ) : File "Y:\BI\Alicia\Scripts\ShrinkModel_3_0_SingleSite_2016Data.py" , line 46 , in module > arcpy . SpatialOverlay_ba ( inputLayer , inputSimpleRing , ShrDemoFields , ShrSimpleRing ) File "C:\Program Files (x86)\ArcGIS\Desktop10.4\Business Analyst\ArcToolbox\Toolboxes\Business Analyst Tools.tbx" , line 483 , in SpatialOverlay ExecuteError : ERROR 000622 : Failed to execute ( SpatialOverlay ) . Parameters are not valid . ERROR 000800 : The value is not a member of TOTPOP_CY | HHPOP_CY | FAMPOP_CY | GQPOP_CY | POPDENS_CY | TOTHH_CY | AVGHHSZ_CY | FAMHH_CY | AVGFMSZ_CY | TOTHU_CY | OWNER_CY | RENTER_CY | VACANT_CY | POPGRW10CY | HHGRW10CY | FAMGRW10CY | POP0_CY | POP5_CY | POP10_CY | POP15_CY | POP20_CY | POP25_CY | POP30_CY | POP35_CY | POP40_CY | POP45_CY | POP50_CY | POP55_CY | POP60_CY | POP65_CY | POP70_CY | POP75_CY | POP80_CY | POP85_CY | POP18UP_CY | POP21UP_CY | MEDAGE_CY | I already checked my parameters and the only thing I didn't add were the last two optional parameters. SpatialOverlay_ba (InputFeatureLayer, OverlayLayer, SelectedSummarizations, OutputFeatureClass, {SpatialOverlayAppendData}, {UseSelectedFeatures}) For the 2nd error, I already checked the spelling of all 27 fields that I'm asking the overlay to get. I misspelled A55NW150CY originally as _CY. The data is the 2016 U.S. Data for BA extension. Any ideas on how to solve this conundrum? Thanks and Happy New Year!!! # Import arcview and arcpy library import arcview import arcpy # Overwrite any previous output arcpy . env . overwriteOutput = True # Set workspace from the selection in tool menu ####myWorkspace = arcpy.GetParameterAsText(0) ####arcpy.env.workspace = myWorkspace myWorkspace = "X:\Users\Alicia.Shyu\TestingScript\ScriptTest" arcpy . env . workspace = myWorkspace print myWorkspace # Check out extensions for Business and Network Analyst arcpy . CheckOutExtension ( "Business" ) arcpy . CheckOutExtension ( "Network" ) print ( "Business Analyst and Network Analyst extensions available" ) # Set spatial reference; 4269 is code for GCS_North_American_1983 spatialRef = arcpy . SpatialReference ( 4269 ) print ( "Spatial reference set" ) # Add Business Analyst toolbox to script arcpy . AddToolbox ( "C:\Program Files (x86)\ArcGIS\Desktop10.4\Business Analyst\ArcToolbox\Toolboxes\Business Analyst Tools.tbx" ) print ( "Business Analyst toolbox added" ) # Set simple ring feature class from selection in tool menu # Simple ring were created during internal model script inputRing = arcpy . GetParameterAsText ( 1 ) # Create variables for spatial overlay function inputLayer = "C:\ArcGIS\Business Analyst\US_2016\Data\Demographic Data\esri_bg.bds" ShrDemoFields = "POPDENS_CY ; INDCONS_CY ; INDRTTR_CY ; OCCSSRV_CY ; OCCHLTH_CY ; OCCPERS_CY ; OCCCONS_CY ; \ DIVORCD_CY ; A45I15_CY ; A55I0_CY ; A55I50_CY ; A25DI15_CY ; A55NW15_CY ; A55NW50_CY ; \ A55NW150CY ; A65NW35_CY ; A75NW15_CY ; AGGNWA75CY ; RURALHU10 ; RNT3PERS10 ; OOHHR75C10 ; \ VACRENT10 ; VACRNTED10 ; VACSOLD10 ; VACOTHER10 ; VACRNTED100 ; VACSOLD100" # Append shrink model data to simple ring feature class ShrRing = "ShrinkSimpleRingAppend" arcpy . SpatialOverlay_ba ( inputLayer , inputRing , ShrDemoFields , ShrRing ) print ( "Shrink Simple Ring Append Done" ) # Set drive time feature class from selection in tool menu # Drive time were created during internal model script inputDriveTime = arcpy . GetParameterAsText ( 2 ) # Append shrink model data to drive time feature class ShrDriveTime = "ShrinkDriveTimeAppend" arcpy . SpatialOverlay_ba ( inputLayer , inputDriveTime , ShrDemoFields , ShrDriveTime ) print ( "Shrink Drive Time Append Done" ) # Set new workspace as output for Excel file myWorkspaceTable = arcpy . GetParameterAsText ( 3 ) # Export shrink simple ring data to Excel excelExtension = ".xls" ShrSimpRStr = "ShrinkSimpRTable" ShrSimpRTable = myWorkspaceTable + "/" + ShrSimpRStr + excelExtension arcpy . TableToExcel_conversion ( ShrSimpleRing , ShrSimpRTable ) print ( "Shrink Simple Ring Table Done" ) # Export shrink drive time data to Excel excelExtension = ".xls" ShrinkDrivTStr = "ShrinkDrivTTable" ShrinkDrivTTable = myWorkspaceTable + "/" + ShrinkDrivTStr + excelExtension arcpy . TableToExcel_conversion ( ShrinkDriveTime , ShrinkDrivTTable ) print ( "Shrink Drive Time Table Done" ) # Return Business Analyst and Network Analyst extensions arcpy . CheckInExtension ( "Business" ) arcpy . CheckInExtension ( "Network" ) print ( "Business Analyst and Network Analyst extensions returned" ) print ( "Done" )

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

error 000622: Failed to execute (SpatialOverlay). Parameters are not valid.

Anonymous User

Hi, I'm writing a script that is part 2 of a bigger automation process. Part 1 was written by someone else (who, of course, doesn't work at the company anymore) and works perfectly.

My script piggy backs on features created in part 1 and I'm getting 2 errors:

Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp; File <SPAN class="string token">"Y:\BI\Alicia\Scripts\ShrinkModel_3_0_SingleSite_2016Data.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">46</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SpatialOverlay_ba<SPAN class="punctuation token">(</SPAN>inputLayer<SPAN class="punctuation token">,</SPAN> inputSimpleRing<SPAN class="punctuation token">,</SPAN> ShrDemoFields<SPAN class="punctuation token">,</SPAN> ShrSimpleRing<SPAN class="punctuation token">)</SPAN>
&nbsp; File <SPAN class="string token">"C:\Program Files (x86)\ArcGIS\Desktop10.4\Business Analyst\ArcToolbox\Toolboxes\Business Analyst Tools.tbx"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">483</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> SpatialOverlay
ExecuteError<SPAN class="punctuation token">:</SPAN> ERROR <SPAN class="number token">000622</SPAN><SPAN class="punctuation token">:</SPAN> Failed to execute <SPAN class="punctuation token">(</SPAN>SpatialOverlay<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN> Parameters are <SPAN class="operator token">not</SPAN> valid<SPAN class="punctuation token">.</SPAN>
ERROR <SPAN class="number token">000800</SPAN><SPAN class="punctuation token">:</SPAN> The value <SPAN class="keyword token">is</SPAN> <SPAN class="operator token">not</SPAN> a member of TOTPOP_CY <SPAN class="operator token">|</SPAN> HHPOP_CY <SPAN class="operator token">|</SPAN> FAMPOP_CY <SPAN class="operator token">|</SPAN> GQPOP_CY <SPAN class="operator token">|</SPAN> POPDENS_CY <SPAN class="operator token">|</SPAN> TOTHH_CY <SPAN class="operator token">|</SPAN> AVGHHSZ_CY <SPAN class="operator token">|</SPAN> FAMHH_CY <SPAN class="operator token">|</SPAN> AVGFMSZ_CY <SPAN class="operator token">|</SPAN> TOTHU_CY <SPAN class="operator token">|</SPAN> OWNER_CY <SPAN class="operator token">|</SPAN> RENTER_CY <SPAN class="operator token">|</SPAN> VACANT_CY <SPAN class="operator token">|</SPAN> POPGRW10CY <SPAN class="operator token">|</SPAN> HHGRW10CY <SPAN class="operator token">|</SPAN> FAMGRW10CY <SPAN class="operator token">|</SPAN> POP0_CY <SPAN class="operator token">|</SPAN> POP5_CY <SPAN class="operator token">|</SPAN> POP10_CY <SPAN class="operator token">|</SPAN> POP15_CY <SPAN class="operator token">|</SPAN> POP20_CY <SPAN class="operator token">|</SPAN> POP25_CY <SPAN class="operator token">|</SPAN> POP30_CY <SPAN class="operator token">|</SPAN> POP35_CY <SPAN class="operator token">|</SPAN> POP40_CY <SPAN class="operator token">|</SPAN> POP45_CY <SPAN class="operator token">|</SPAN> POP50_CY <SPAN class="operator token">|</SPAN> POP55_CY <SPAN class="operator token">|</SPAN> POP60_CY <SPAN class="operator token">|</SPAN> POP65_CY <SPAN class="operator token">|</SPAN> POP70_CY <SPAN class="operator token">|</SPAN> POP75_CY <SPAN class="operator token">|</SPAN> POP80_CY <SPAN class="operator token">|</SPAN> POP85_CY <SPAN class="operator token">|</SPAN> POP18UP_CY <SPAN class="operator token">|</SPAN> POP21UP_CY <SPAN class="operator token">|</SPAN> MEDAGE_CY <SPAN class="operator token">|</SPAN> <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I already checked my parameters and the only thing I didn't add were the last two optional parameters.

SpatialOverlay_ba (InputFeatureLayer, OverlayLayer, SelectedSummarizations, OutputFeatureClass,
{SpatialOverlayAppendData}, {UseSelectedFeatures})

For the 2nd error, I already checked the spelling of all 27 fields that I'm asking the overlay to get. I misspelled A55NW150CY originally as _CY. The data is the 2016 U.S. Data for BA extension.

Any ideas on how to solve this conundrum?

Thanks and Happy New Year!!!

<SPAN class="comment token"># Import arcview and arcpy library</SPAN>
<SPAN class="keyword token">import</SPAN> arcview
<SPAN class="keyword token">import</SPAN> arcpy

<SPAN class="comment token"># Overwrite any previous output</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

<SPAN class="comment token"># Set workspace from the selection in tool menu</SPAN>
<SPAN class="comment token">####myWorkspace = arcpy.GetParameterAsText(0)</SPAN>
<SPAN class="comment token">####arcpy.env.workspace = myWorkspace</SPAN>
myWorkspace <SPAN class="operator token">=</SPAN> <SPAN class="string token">"X:\Users\Alicia.Shyu\TestingScript\ScriptTest"</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> myWorkspace
<SPAN class="keyword token">print</SPAN> myWorkspace

<SPAN class="comment token"># Check out extensions for Business and Network Analyst</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CheckOutExtension<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Business"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CheckOutExtension<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Network"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Business Analyst and Network Analyst extensions available"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Set spatial reference; 4269 is code for GCS_North_American_1983</SPAN>
spatialRef <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">(</SPAN><SPAN class="number token">4269</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Spatial reference set"</SPAN><SPAN class="punctuation token">)</SPAN> 

<SPAN class="comment token"># Add Business Analyst toolbox to script</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddToolbox<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"C:\Program Files (x86)\ArcGIS\Desktop10.4\Business Analyst\ArcToolbox\Toolboxes\Business Analyst Tools.tbx"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Business Analyst toolbox added"</SPAN><SPAN class="punctuation token">)</SPAN> 

<SPAN class="comment token"># Set simple ring feature class from selection in tool menu</SPAN>
<SPAN class="comment token"># Simple ring were created during internal model script</SPAN>
inputRing <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Create variables for spatial overlay function</SPAN>
inputLayer <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:\ArcGIS\Business Analyst\US_2016\Data\Demographic Data\esri_bg.bds"</SPAN>
ShrDemoFields <SPAN class="operator token">=</SPAN> "POPDENS_CY<SPAN class="punctuation token">;</SPAN> INDCONS_CY<SPAN class="punctuation token">;</SPAN> INDRTTR_CY<SPAN class="punctuation token">;</SPAN> OCCSSRV_CY<SPAN class="punctuation token">;</SPAN> OCCHLTH_CY<SPAN class="punctuation token">;</SPAN> OCCPERS_CY<SPAN class="punctuation token">;</SPAN> OCCCONS_CY<SPAN class="punctuation token">;</SPAN> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DIVORCD_CY<SPAN class="punctuation token">;</SPAN> A45I15_CY<SPAN class="punctuation token">;</SPAN> A55I0_CY<SPAN class="punctuation token">;</SPAN> A55I50_CY<SPAN class="punctuation token">;</SPAN> A25DI15_CY<SPAN class="punctuation token">;</SPAN> A55NW15_CY<SPAN class="punctuation token">;</SPAN> A55NW50_CY<SPAN class="punctuation token">;</SPAN> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A55NW150CY<SPAN class="punctuation token">;</SPAN> A65NW35_CY<SPAN class="punctuation token">;</SPAN> A75NW15_CY<SPAN class="punctuation token">;</SPAN> AGGNWA75CY<SPAN class="punctuation token">;</SPAN> RURALHU10<SPAN class="punctuation token">;</SPAN> RNT3PERS10<SPAN class="punctuation token">;</SPAN> OOHHR75C10<SPAN class="punctuation token">;</SPAN> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VACRENT10<SPAN class="punctuation token">;</SPAN> VACRNTED10<SPAN class="punctuation token">;</SPAN> VACSOLD10<SPAN class="punctuation token">;</SPAN> VACOTHER10<SPAN class="punctuation token">;</SPAN> VACRNTED100<SPAN class="punctuation token">;</SPAN> VACSOLD100"

<SPAN class="comment token"># Append shrink model data to simple ring feature class</SPAN>
ShrRing <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ShrinkSimpleRingAppend"</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SpatialOverlay_ba<SPAN class="punctuation token">(</SPAN>inputLayer<SPAN class="punctuation token">,</SPAN> inputRing<SPAN class="punctuation token">,</SPAN> ShrDemoFields<SPAN class="punctuation token">,</SPAN> ShrRing<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Shrink Simple Ring Append Done"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Set drive time feature class from selection in tool menu</SPAN>
<SPAN class="comment token"># Drive time were created during internal model script</SPAN>
inputDriveTime <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Append shrink model data to drive time feature class</SPAN>
ShrDriveTime <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ShrinkDriveTimeAppend"</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SpatialOverlay_ba<SPAN class="punctuation token">(</SPAN>inputLayer<SPAN class="punctuation token">,</SPAN> inputDriveTime<SPAN class="punctuation token">,</SPAN> ShrDemoFields<SPAN class="punctuation token">,</SPAN> ShrDriveTime<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Shrink Drive Time Append Done"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Set new workspace as output for Excel file</SPAN>
myWorkspaceTable <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Export shrink simple ring data to Excel</SPAN>
excelExtension <SPAN class="operator token">=</SPAN> <SPAN class="string token">".xls"</SPAN>
ShrSimpRStr <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ShrinkSimpRTable"</SPAN>
ShrSimpRTable <SPAN class="operator token">=</SPAN> myWorkspaceTable <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> ShrSimpRStr <SPAN class="operator token">+</SPAN> excelExtension
arcpy<SPAN class="punctuation token">.</SPAN>TableToExcel_conversion<SPAN class="punctuation token">(</SPAN>ShrSimpleRing<SPAN class="punctuation token">,</SPAN> ShrSimpRTable<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Shrink Simple Ring Table Done"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Export shrink drive time data to Excel</SPAN>
excelExtension <SPAN class="operator token">=</SPAN> <SPAN class="string token">".xls"</SPAN>
ShrinkDrivTStr <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ShrinkDrivTTable"</SPAN>
ShrinkDrivTTable <SPAN class="operator token">=</SPAN> myWorkspaceTable <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> ShrinkDrivTStr <SPAN class="operator token">+</SPAN> excelExtension
arcpy<SPAN class="punctuation token">.</SPAN>TableToExcel_conversion<SPAN class="punctuation token">(</SPAN>ShrinkDriveTime<SPAN class="punctuation token">,</SPAN> ShrinkDrivTTable<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Shrink Drive Time Table Done"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Return Business Analyst and Network Analyst extensions</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CheckInExtension<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Business"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CheckInExtension<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Network"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Business Analyst and Network Analyst extensions returned"</SPAN><SPAN class="punctuation token">)</SPAN> 
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Done"</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>

Find more posts tagged with

Accepted answers

DanPatterson_Retired

line 23 and 32 still need raw formatting ... r'....

I wonder if it has something to do with your fancy formatting, since you have a whole load of spaces before the actual names... observe

ShrDemoFields <SPAN class="operator token">=</SPAN> "POPDENS_CY<SPAN class="punctuation token">;</SPAN> INDCONS_CY<SPAN class="punctuation token">;</SPAN> INDRTTR_CY<SPAN class="punctuation token">;</SPAN> OCCSSRV_CY<SPAN class="punctuation token">;</SPAN> OCCHLTH_CY<SPAN class="punctuation token">;</SPAN> OCCPERS_CY<SPAN class="punctuation token">;</SPAN> OCCCONS_CY<SPAN class="punctuation token">;</SPAN> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DIVORCD_CY<SPAN class="punctuation token">;</SPAN> A45I15_CY<SPAN class="punctuation token">;</SPAN> A55I0_CY<SPAN class="punctuation token">;</SPAN> A55I50_CY<SPAN class="punctuation token">;</SPAN> A25DI15_CY<SPAN class="punctuation token">;</SPAN> A55NW15_CY<SPAN class="punctuation token">;</SPAN> A55NW50_CY<SPAN class="punctuation token">;</SPAN> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A55NW150CY<SPAN class="punctuation token">;</SPAN> A65NW35_CY<SPAN class="punctuation token">;</SPAN> A75NW15_CY<SPAN class="punctuation token">;</SPAN> AGGNWA75CY<SPAN class="punctuation token">;</SPAN> RURALHU10<SPAN class="punctuation token">;</SPAN> RNT3PERS10<SPAN class="punctuation token">;</SPAN> OOHHR75C10<SPAN class="punctuation token">;</SPAN> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VACRENT10<SPAN class="punctuation token">;</SPAN> VACRNTED10<SPAN class="punctuation token">;</SPAN> VACSOLD10<SPAN class="punctuation token">;</SPAN> VACOTHER10<SPAN class="punctuation token">;</SPAN> VACRNTED100<SPAN class="punctuation token">;</SPAN> VACSOLD100"

ShrDemoFields
Out<SPAN class="punctuation token">[</SPAN><SPAN class="number token">14</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'POPDENS_CY; INDCONS_CY; INDRTTR_CY; OCCSSRV_CY; OCCHLTH_CY; OCCPERS_CY; OCCCONS_CY;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DIVORCD_CY; A45I15_CY; A55I0_CY; A55I50_CY; A25DI15_CY; A55NW15_CY; A55NW50_CY;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A55NW150CY; A65NW35_CY; A75NW15_CY; AGGNWA75CY; RURALHU10; RNT3PERS10; OOHHR75C10;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VACRENT10; VACRNTED10; VACSOLD10; VACOTHER10; VACRNTED100; VACSOLD100'</SPAN>

ShrDemoFields_list <SPAN class="operator token">=</SPAN> ShrDemoFields<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">";"</SPAN><SPAN class="punctuation token">)</SPAN>

ShrDemoFields_list
Out<SPAN class="punctuation token">[</SPAN><SPAN class="number token">16</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN> 
<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'POPDENS_CY'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' INDCONS_CY'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' INDRTTR_CY'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' OCCSSRV_CY'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' OCCHLTH_CY'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' OCCPERS_CY'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' OCCCONS_CY'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DIVORCD_CY'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' A45I15_CY'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' A55I0_CY'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' A55I50_CY'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' A25DI15_CY'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' A55NW15_CY'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' A55NW50_CY'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A55NW150CY'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' A65NW35_CY'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' A75NW15_CY'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' AGGNWA75CY'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' RURALHU10'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' RNT3PERS10'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' OOHHR75C10'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VACRENT10'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' VACRNTED10'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' VACSOLD10'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' VACOTHER10'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' VACRNTED100'</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="string token">' VACSOLD100'</SPAN><SPAN class="punctuation token">]</SPAN>


<SPAN class="comment token"># ---- I removed the BIG spaces below</SPAN>

ShrDemoFields <SPAN class="operator token">=</SPAN> <SPAN class="string token">"POPDENS_CY; INDCONS_CY; INDRTTR_CY; OCCSSRV_CY; OCCHLTH_CY; OCCPERS_CY; OCCCONS_CY; DIVORCD_CY; A45I15_CY; A55I0_CY; A55I50_CY; A25DI15_CY; A55NW15_CY; A55NW50_CY; A55NW150CY; A65NW35_CY; A75NW15_CY; AGGNWA75CY; RURALHU10; RNT3PERS10; OOHHR75C10; VACRENT10; VACRNTED10; VACSOLD10; VACOTHER10; VACRNTED100; VACSOLD100"</SPAN>

ShrDemoFields
Out<SPAN class="punctuation token">[</SPAN><SPAN class="number token">18</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'POPDENS_CY; INDCONS_CY; INDRTTR_CY; OCCSSRV_CY; OCCHLTH_CY; OCCPERS_CY; OCCCONS_CY; DIVORCD_CY; A45I15_CY; A55I0_CY; A55I50_CY; A25DI15_CY; A55NW15_CY; A55NW50_CY; A55NW150CY; A65NW35_CY; A75NW15_CY; AGGNWA75CY; RURALHU10; RNT3PERS10; OOHHR75C10; VACRENT10; VACRNTED10; VACSOLD10; VACOTHER10; VACRNTED100; VACSOLD100'</SPAN>

<SPAN class="comment token"># ---- then I replaced the single spaces ----</SPAN>

ShrDemoFields<SPAN class="punctuation token">.</SPAN>replace<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>
Out<SPAN class="punctuation token">[</SPAN><SPAN class="number token">19</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'POPDENS_CY;INDCONS_CY;INDRTTR_CY;OCCSSRV_CY;OCCHLTH_CY;OCCPERS_CY;OCCCONS_CY;DIVORCD_CY;A45I15_CY;A55I0_CY;A55I50_CY;A25DI15_CY;A55NW15_CY;A55NW50_CY;A55NW150CY;A65NW35_CY;A75NW15_CY;AGGNWA75CY;RURALHU10;RNT3PERS10;OOHHR75C10;VACRENT10;VACRNTED10;VACSOLD10;VACOTHER10;VACRNTED100;VACSOLD100'</SPAN>

<SPAN class="comment token"># ---- now a lot of Arc* software uses semi-colon delimited text strings which are</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; parsed to lists</SPAN>

test_list <SPAN class="operator token">=</SPAN> ShrDemoFields<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">";"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># ---- resulting in a clean list.... but the above space replacement stuff may suffice</SPAN>

test_list
Out<SPAN class="punctuation token">[</SPAN><SPAN class="number token">24</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'POPDENS_CY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' INDCONS_CY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' INDRTTR_CY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' OCCSSRV_CY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' OCCHLTH_CY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' OCCPERS_CY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' OCCCONS_CY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' DIVORCD_CY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' A45I15_CY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' A55I0_CY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' A55I50_CY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' A25DI15_CY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' A55NW15_CY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' A55NW50_CY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' A55NW150CY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' A65NW35_CY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' A75NW15_CY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' AGGNWA75CY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' RURALHU10'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' RNT3PERS10'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' OOHHR75C10'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' VACRENT10'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' VACRNTED10'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' VACSOLD10'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' VACOTHER10'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' VACRNTED100'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' VACSOLD100'</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>

All comments

Anonymous User

ok, here is the updated code:

<SPAN class="comment token"># Import arcview and arcpy library</SPAN>
<SPAN class="keyword token">import</SPAN> arcview
<SPAN class="keyword token">import</SPAN> arcpy

<SPAN class="comment token"># Overwrite any previous output</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

<SPAN class="comment token"># Set workspace from the selection in tool menu</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">####myWorkspace = arcpy.GetParameterAsText(0)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">####arcpy.env.workspace = myWorkspace</SPAN>
myWorkspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'X:\Users\Alicia.Shyu\TestingScript\ScriptTest'</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> myWorkspace
<SPAN class="keyword token">print</SPAN> myWorkspace

<SPAN class="comment token"># Check out extensions for Business and Network Analyst</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CheckOutExtension<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Business"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CheckOutExtension<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Network"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Business Analyst and Network Analyst extensions available"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Set spatial reference; 4269 is code for GCS_North_American_1983</SPAN>
spatialRef <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">(</SPAN><SPAN class="number token">4269</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Spatial reference set"</SPAN><SPAN class="punctuation token">)</SPAN> 

<SPAN class="comment token"># Add Business Analyst toolbox to script</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddToolbox<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"C:\Program Files (x86)\ArcGIS\Desktop10.4\Business Analyst\ArcToolbox\Toolboxes\Business Analyst Tools.tbx"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Business Analyst toolbox added"</SPAN><SPAN class="punctuation token">)</SPAN> 

<SPAN class="comment token"># Set simple ring feature class from selection in tool menu</SPAN>
<SPAN class="comment token"># Simple ring were created during internal model script</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">####inputRing = arcpy.GetParameterAsText(1)</SPAN>
inputRing <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'X:\Users\Alicia.Shyu\TestingScript\ScriptTest\InternalData.gdb\Buffer_LocationXY_ScriptTest'</SPAN>

<SPAN class="comment token"># Create variables for spatial overlay function</SPAN>
inputLayer <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:\ArcGIS\Business Analyst\US_2016\Data\Demographic Data\esri_bg.bds"</SPAN>
ShrDemoFields <SPAN class="operator token">=</SPAN> "POPDENS_CY<SPAN class="punctuation token">;</SPAN> INDCONS_CY<SPAN class="punctuation token">;</SPAN> INDRTTR_CY<SPAN class="punctuation token">;</SPAN> OCCSSRV_CY<SPAN class="punctuation token">;</SPAN> OCCHLTH_CY<SPAN class="punctuation token">;</SPAN> OCCPERS_CY<SPAN class="punctuation token">;</SPAN> OCCCONS_CY<SPAN class="punctuation token">;</SPAN> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DIVORCD_CY<SPAN class="punctuation token">;</SPAN> A45I15_CY<SPAN class="punctuation token">;</SPAN> A55I0_CY<SPAN class="punctuation token">;</SPAN> A55I50_CY<SPAN class="punctuation token">;</SPAN> A25DI15_CY<SPAN class="punctuation token">;</SPAN> A55NW15_CY<SPAN class="punctuation token">;</SPAN> A55NW50_CY<SPAN class="punctuation token">;</SPAN> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A55NW150CY<SPAN class="punctuation token">;</SPAN> A65NW35_CY<SPAN class="punctuation token">;</SPAN> A75NW15_CY<SPAN class="punctuation token">;</SPAN> AGGNWA75CY<SPAN class="punctuation token">;</SPAN> RURALHU10<SPAN class="punctuation token">;</SPAN> RNT3PERS10<SPAN class="punctuation token">;</SPAN> OOHHR75C10<SPAN class="punctuation token">;</SPAN> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VACRENT10<SPAN class="punctuation token">;</SPAN> VACRNTED10<SPAN class="punctuation token">;</SPAN> VACSOLD10<SPAN class="punctuation token">;</SPAN> VACOTHER10<SPAN class="punctuation token">;</SPAN> VACRNTED100<SPAN class="punctuation token">;</SPAN> VACSOLD100"

<SPAN class="comment token"># Append shrink model data to simple ring feature class</SPAN>
ShrRing <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ShrinkSimpleRingAppend"</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SpatialOverlay_ba<SPAN class="punctuation token">(</SPAN>inputLayer<SPAN class="punctuation token">,</SPAN> inputRing<SPAN class="punctuation token">,</SPAN> ShrDemoFields<SPAN class="punctuation token">,</SPAN> ShrRing<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Shrink Simple Ring Append Done"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Set drive time feature class from selection in tool menu</SPAN>
<SPAN class="comment token"># Drive time were created during internal model script</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">####inputDriveTime = arcpy.GetParameterAsText(2)</SPAN>
inputDriveTime <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'X:\Users\Alicia.Shyu\TestingScript\ScriptTest\InternalData.gdb\DriveTime_LocationXY_ScriptTest'</SPAN>

<SPAN class="comment token"># Append shrink model data to drive time feature class</SPAN>
ShrDriveTime <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ShrinkDriveTimeAppend"</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SpatialOverlay_ba<SPAN class="punctuation token">(</SPAN>inputLayer<SPAN class="punctuation token">,</SPAN> inputDriveTime<SPAN class="punctuation token">,</SPAN> ShrDemoFields<SPAN class="punctuation token">,</SPAN> ShrDriveTime<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Shrink Drive Time Append Done"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Set new workspace as output for Excel file</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">####myWorkspaceFolder = arcpy.GetParameterAsText(3)</SPAN>
myWorkspaceFolder <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'X:\Users\Alicia.Shyu\TestingScript\ScriptTest'</SPAN>

<SPAN class="comment token"># Export shrink simple ring data to Excel</SPAN>
excelExtension <SPAN class="operator token">=</SPAN> <SPAN class="string token">".xls"</SPAN>
ShrSimpRStr <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ShrinkSimpRTable"</SPAN>
ShrSimpRTable <SPAN class="operator token">=</SPAN> myWorkspaceFolder <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> ShrSimpRStr <SPAN class="operator token">+</SPAN> excelExtension
arcpy<SPAN class="punctuation token">.</SPAN>TableToExcel_conversion<SPAN class="punctuation token">(</SPAN>ShrRing<SPAN class="punctuation token">,</SPAN> ShrSimpRTable<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Shrink Simple Ring Table Done"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Export shrink drive time data to Excel</SPAN>
excelExtension <SPAN class="operator token">=</SPAN> <SPAN class="string token">".xls"</SPAN>
ShrinkDrivTStr <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ShrinkDrivTTable"</SPAN>
ShrinkDrivTTable <SPAN class="operator token">=</SPAN> myWorkspaceFolder <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> ShrinkDrivTStr <SPAN class="operator token">+</SPAN> excelExtension
arcpy<SPAN class="punctuation token">.</SPAN>TableToExcel_conversion<SPAN class="punctuation token">(</SPAN>ShrinkDriveTime<SPAN class="punctuation token">,</SPAN> ShrinkDrivTTable<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Shrink Drive Time Table Done"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Return Business Analyst and Network Analyst extensions</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CheckInExtension<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Business"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CheckInExtension<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Network"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Business Analyst and Network Analyst extensions returned"</SPAN><SPAN class="punctuation token">)</SPAN> 
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Done"</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>

Here is the error I get after updating the code:

Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp; File <SPAN class="string token">"Y:\BI\Alicia\Scripts\ShrinkModel_3_0_SingleSite_2016Data.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">49</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SpatialOverlay_ba<SPAN class="punctuation token">(</SPAN>inputLayer<SPAN class="punctuation token">,</SPAN> inputRing<SPAN class="punctuation token">,</SPAN> ShrDemoFields<SPAN class="punctuation token">,</SPAN> ShrRing<SPAN class="punctuation token">)</SPAN>
&nbsp; File <SPAN class="string token">"C:\Program Files (x86)\ArcGIS\Desktop10.4\Business Analyst\ArcToolbox\Toolboxes\Business Analyst Tools.tbx"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">263</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> SpatialOverlay
ExecuteError<SPAN class="punctuation token">:</SPAN> ERROR <SPAN class="number token">000622</SPAN><SPAN class="punctuation token">:</SPAN> Failed to execute <SPAN class="punctuation token">(</SPAN>SpatialOverlay<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN> Parameters are <SPAN class="operator token">not</SPAN> valid<SPAN class="punctuation token">.</SPAN>
ERROR <SPAN class="number token">000800</SPAN><SPAN class="punctuation token">:</SPAN> The value <SPAN class="keyword token">is</SPAN> <SPAN class="operator token">not</SPAN> a member of TOTPOP_CY <SPAN class="operator token">|</SPAN> HHPOP_CY <SPAN class="operator token">|</SPAN> FAMPOP_CY <SPAN class="operator token">|</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Anonymous User

<SPAN class="comment token"># Import arcview and arcpy library</SPAN>
<SPAN class="keyword token">import</SPAN> arcview
<SPAN class="keyword token">import</SPAN> arcpy

<SPAN class="comment token"># Overwrite any previous output</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

<SPAN class="comment token"># Set workspace from the selection in tool menu</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">####myWorkspace = arcpy.GetParameterAsText(0)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">####arcpy.env.workspace = myWorkspace</SPAN>
myWorkspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'X:\Users\Alicia.Shyu\TestingScript\ScriptTest'</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> myWorkspace
<SPAN class="keyword token">print</SPAN> myWorkspace

<SPAN class="comment token"># Check out extensions for Business and Network Analyst</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CheckOutExtension<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Business"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CheckOutExtension<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Network"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Business Analyst and Network Analyst extensions available"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Set spatial reference; 4269 is code for GCS_North_American_1983</SPAN>
spatialRef <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">(</SPAN><SPAN class="number token">4269</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Spatial reference set"</SPAN><SPAN class="punctuation token">)</SPAN> 

<SPAN class="comment token"># Add Business Analyst toolbox to script</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddToolbox<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"C:\Program Files (x86)\ArcGIS\Desktop10.4\Business Analyst\ArcToolbox\Toolboxes\Business Analyst Tools.tbx"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Business Analyst toolbox added"</SPAN><SPAN class="punctuation token">)</SPAN> 

<SPAN class="comment token"># Set simple ring feature class from selection in tool menu</SPAN>
<SPAN class="comment token"># Simple ring were created during internal model script</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">####inputRing = arcpy.GetParameterAsText(1)</SPAN>
inputRing <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'X:\Users\Alicia.Shyu\TestingScript\ScriptTest\InternalData.gdb\Buffer_LocationXY_ScriptTest'</SPAN>

<SPAN class="comment token"># Create variables for spatial overlay function</SPAN>
inputLayer <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:\ArcGIS\Business Analyst\US_2016\Data\Demographic Data\esri_bg.bds"</SPAN>
ShrDemoFields <SPAN class="operator token">=</SPAN> "POPDENS_CY<SPAN class="punctuation token">;</SPAN> INDCONS_CY<SPAN class="punctuation token">;</SPAN> INDRTTR_CY<SPAN class="punctuation token">;</SPAN> OCCSSRV_CY<SPAN class="punctuation token">;</SPAN> OCCHLTH_CY<SPAN class="punctuation token">;</SPAN> OCCPERS_CY<SPAN class="punctuation token">;</SPAN> OCCCONS_CY<SPAN class="punctuation token">;</SPAN> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DIVORCD_CY<SPAN class="punctuation token">;</SPAN> A45I15_CY<SPAN class="punctuation token">;</SPAN> A55I0_CY<SPAN class="punctuation token">;</SPAN> A55I50_CY<SPAN class="punctuation token">;</SPAN> A25DI15_CY<SPAN class="punctuation token">;</SPAN> A55NW15_CY<SPAN class="punctuation token">;</SPAN> A55NW50_CY<SPAN class="punctuation token">;</SPAN> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A55NW150CY<SPAN class="punctuation token">;</SPAN> A65NW35_CY<SPAN class="punctuation token">;</SPAN> A75NW15_CY<SPAN class="punctuation token">;</SPAN> AGGNWA75CY<SPAN class="punctuation token">;</SPAN> RURALHU10<SPAN class="punctuation token">;</SPAN> RNT3PERS10<SPAN class="punctuation token">;</SPAN> OOHHR75C10<SPAN class="punctuation token">;</SPAN> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VACRENT10<SPAN class="punctuation token">;</SPAN> VACRNTED10<SPAN class="punctuation token">;</SPAN> VACSOLD10<SPAN class="punctuation token">;</SPAN> VACOTHER10<SPAN class="punctuation token">;</SPAN> VACRNTED100<SPAN class="punctuation token">;</SPAN> VACSOLD100"

<SPAN class="comment token"># Append shrink model data to simple ring feature class</SPAN>
ShrRing <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ShrinkSimpleRingAppend"</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SpatialOverlay_ba<SPAN class="punctuation token">(</SPAN>inputLayer<SPAN class="punctuation token">,</SPAN> inputRing<SPAN class="punctuation token">,</SPAN> ShrDemoFields<SPAN class="punctuation token">,</SPAN> ShrRing<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Shrink Simple Ring Append Done"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Set drive time feature class from selection in tool menu</SPAN>
<SPAN class="comment token"># Drive time were created during internal model script</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">####inputDriveTime = arcpy.GetParameterAsText(2)</SPAN>
inputDriveTime <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'X:\Users\Alicia.Shyu\TestingScript\ScriptTest\InternalData.gdb\DriveTime_LocationXY_ScriptTest'</SPAN>

<SPAN class="comment token"># Append shrink model data to drive time feature class</SPAN>
ShrDriveTime <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ShrinkDriveTimeAppend"</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SpatialOverlay_ba<SPAN class="punctuation token">(</SPAN>inputLayer<SPAN class="punctuation token">,</SPAN> inputDriveTime<SPAN class="punctuation token">,</SPAN> ShrDemoFields<SPAN class="punctuation token">,</SPAN> ShrDriveTime<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Shrink Drive Time Append Done"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Set new workspace as output for Excel file</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">####myWorkspaceFolder = arcpy.GetParameterAsText(3)</SPAN>
myWorkspaceFolder <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'X:\Users\Alicia.Shyu\TestingScript\ScriptTest'</SPAN>

<SPAN class="comment token"># Export shrink simple ring data to Excel</SPAN>
excelExtension <SPAN class="operator token">=</SPAN> <SPAN class="string token">".xls"</SPAN>
ShrSimpRStr <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ShrinkSimpRTable"</SPAN>
ShrSimpRTable <SPAN class="operator token">=</SPAN> myWorkspaceFolder <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> ShrSimpRStr <SPAN class="operator token">+</SPAN> excelExtension
arcpy<SPAN class="punctuation token">.</SPAN>TableToExcel_conversion<SPAN class="punctuation token">(</SPAN>ShrRing<SPAN class="punctuation token">,</SPAN> ShrSimpRTable<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Shrink Simple Ring Table Done"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Export shrink drive time data to Excel</SPAN>
excelExtension <SPAN class="operator token">=</SPAN> <SPAN class="string token">".xls"</SPAN>
ShrinkDrivTStr <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ShrinkDrivTTable"</SPAN>
ShrinkDrivTTable <SPAN class="operator token">=</SPAN> myWorkspaceFolder <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> ShrinkDrivTStr <SPAN class="operator token">+</SPAN> excelExtension
arcpy<SPAN class="punctuation token">.</SPAN>TableToExcel_conversion<SPAN class="punctuation token">(</SPAN>ShrinkDriveTime<SPAN class="punctuation token">,</SPAN> ShrinkDrivTTable<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Shrink Drive Time Table Done"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Return Business Analyst and Network Analyst extensions</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CheckInExtension<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Business"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CheckInExtension<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Network"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Business Analyst and Network Analyst extensions returned"</SPAN><SPAN class="punctuation token">)</SPAN> 
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Done"</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>

Still got the same error:

Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp; File <SPAN class="string token">"Y:\BI\Alicia\Scripts\ShrinkModel_3_0_SingleSite_2016Data.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">49</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SpatialOverlay_ba<SPAN class="punctuation token">(</SPAN>inputLayer<SPAN class="punctuation token">,</SPAN> inputRing<SPAN class="punctuation token">,</SPAN> ShrDemoFields<SPAN class="punctuation token">,</SPAN> ShrRing<SPAN class="punctuation token">)</SPAN>
&nbsp; File <SPAN class="string token">"C:\Program Files (x86)\ArcGIS\Desktop10.4\Business Analyst\ArcToolbox\Toolboxes\Business Analyst Tools.tbx"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">263</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> SpatialOverlay
ExecuteError<SPAN class="punctuation token">:</SPAN> ERROR <SPAN class="number token">000622</SPAN><SPAN class="punctuation token">:</SPAN> Failed to execute <SPAN class="punctuation token">(</SPAN>SpatialOverlay<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN> Parameters are <SPAN class="operator token">not</SPAN> valid<SPAN class="punctuation token">.</SPAN>
ERROR <SPAN class="number token">000800</SPAN><SPAN class="punctuation token">:</SPAN> The value <SPAN class="keyword token">is</SPAN> <SPAN class="operator token">not</SPAN> a member of TOTPOP_CY <SPAN class="operator token">|</SPAN> HHPOP_CY <SPAN class="operator token">|</SPAN> FAMPOP_CY <SPAN class="operator token">|</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JoshuaBixby

It is helpful if you re-post your code after making the updates/corrections. Knowing exactly what arguments are being passed to the functions is key for those of use trying to help you.

DanPatterson_Retired

like this

'X:\Users\Alicia.Shyu\TestingScript\ScriptTest'

or raw formatted... like

r'X:\Users\Alicia.Shyu\TestingScript\ScriptTest'

my comment was about the lack of proper path specification when using python in scripts

Anonymous User

I replaced all the variables with actual paths and got the same error.

X<SPAN class="punctuation token">:</SPAN>\Users\Alicia<SPAN class="punctuation token">.</SPAN>Shyu\TestingScript\ScriptTest
Business Analyst <SPAN class="operator token">and</SPAN> Network Analyst extensions available
Spatial reference set
Business Analyst toolbox added

Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp; File <SPAN class="string token">"Y:\BI\Alicia\Scripts\ShrinkModel_3_0_SingleSite_2016Data.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">49</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SpatialOverlay_ba<SPAN class="punctuation token">(</SPAN>inputLayer<SPAN class="punctuation token">,</SPAN> inputRing<SPAN class="punctuation token">,</SPAN> ShrDemoFields<SPAN class="punctuation token">,</SPAN> ShrRing<SPAN class="punctuation token">)</SPAN>
&nbsp; File <SPAN class="string token">"C:\Program Files (x86)\ArcGIS\Desktop10.4\Business Analyst\ArcToolbox\Toolboxes\Business Analyst Tools.tbx"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">263</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> SpatialOverlay
ExecuteError<SPAN class="punctuation token">:</SPAN> ERROR <SPAN class="number token">000622</SPAN><SPAN class="punctuation token">:</SPAN> Failed to execute <SPAN class="punctuation token">(</SPAN>SpatialOverlay<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN> Parameters are <SPAN class="operator token">not</SPAN> valid<SPAN class="punctuation token">.</SPAN>
ERROR <SPAN class="number token">000800</SPAN><SPAN class="punctuation token">:</SPAN> The value <SPAN class="keyword token">is</SPAN> <SPAN class="operator token">not</SPAN> a member of TOTPOP_CY <SPAN class="operator token">|</SPAN> HHPOP_CY <SPAN class="operator token">|</SPAN> FAMPOP_CY <SPAN class="operator token">|</SPAN> GQPOP_CY <SPAN class="operator 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>

DanPatterson_Retired

could you start by raw formatting all your paths to rule out issues that may be indirectly related.

if you are using backslashes to specify paths, use r'c:\yourpathhere' ... with the little 'r' in front. especially since you are using python 2.7 presumably. In python 3 (aka in Pro), your paths will fail miserably, so prepare for the future.

Anonymous User

I see my mistake but even after making sure all the variables are defined. I'm still getting the same errors.

Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp; File <SPAN class="string token">"Y:\BI\Alicia\Scripts\ShrinkModel_3_0_SingleSite_2016Data.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">48</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SpatialOverlay_ba<SPAN class="punctuation token">(</SPAN>inputLayer<SPAN class="punctuation token">,</SPAN> inputRing<SPAN class="punctuation token">,</SPAN> ShrDemoFields<SPAN class="punctuation token">,</SPAN> ShrRing<SPAN class="punctuation token">)</SPAN>
&nbsp; File <SPAN class="string token">"C:\Program Files (x86)\ArcGIS\Desktop10.4\Business Analyst\ArcToolbox\Toolboxes\Business Analyst Tools.tbx"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">483</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> SpatialOverlay
ExecuteError<SPAN class="punctuation token">:</SPAN> ERROR <SPAN class="number token">000622</SPAN><SPAN class="punctuation token">:</SPAN> Failed to execute <SPAN class="punctuation token">(</SPAN>SpatialOverlay<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN> Parameters are <SPAN class="operator token">not</SPAN> valid<SPAN class="punctuation token">.</SPAN>
ERROR <SPAN class="number token">000800</SPAN><SPAN class="punctuation token">:</SPAN> The value <SPAN class="keyword token">is</SPAN> <SPAN class="operator token">not</SPAN> a member of TOTPOP_CY <SPAN class="operator token">|</SPAN> HHPOP_CY <SPAN class="operator token">|</SPAN> FAMPOP_CY <SPAN class="operator token">|</SPAN> GQPOP_CY <SPAN class="operator token">|</SPAN> POPDENS_CY <SPAN class="operator token">|</SPAN> TOTHH_CY <SPAN class="operator token">|</SPAN> AVGHHSZ_CY <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JoshuaBixby

Looking at the error and traceback, you are calling Spatial Overlay with 4 arguments: inputLayer, inputSimpleRing, ShrDemoFields, ShrSimpleRing. When I look at the code/script provided, I don't see where inputSimpleRing or ShrSimpleRing are defined. What am I missing?

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.