Hi I am trying to run the following script from py 2.7 IDLE that comes with ArcMap 10.7.1. When I try to run the following script: import arcpy import os from arcpy import env from arcpy . sa import * #Set the evironment settings arcpy . env . workspace = r 'D:\Spring2020\VIC\PCA_Reclass_2004\PCA_Reclass_04' #Load the rasters folder = r 'D:\Spring2020\VIC\PCA_Reclass_2004\PCA_Reclass_04' rasters = arcpy . ListRasters ( "*" , "TIF" ) print rasters inpoly = r 'D:\Spring2020\VIC\EB_Correct_File_ArcGIS\VIC.shp' out = r 'D:\Spring2020\VIC\EB_Correct_File_ArcGIS' print ( [ field . name for field in arcpy . ListFields ( inpoly ) ] ) cursor = arcpy . SearchCursor ( inpoly , [ 'GRID_CODE' ] ) print cursor with arcpy . da . SearchCursor ( inpoly , [ 'GRID_CODE' ] ) as cursor : for row in cursor : #print row for raster in rasters : out = os . path . join ( out , raster + ".dbf" ) outT = arcpy . gp . ZonalStatisticsAsTable ( inpoly , "GRID_CODE" , raster , out , "DATA" , 'MEAN' ) I get the following error ( even though I have the license and can use the tool in ArcMap ) : raceback ( most recent call last ) : File "D:/Spring2020/VIC/zonal_stats_Table.py" , line 21 , in module > outT = arcpy . gp . ZonalStatisticsAsTable ( inpoly , "GRID_CODE" , raster , out , "DATA" , 'MEAN' ) File "C:\Program Files (x86)\ArcGIS\Desktop10.7\ArcPy\arcpy\geoprocessing\_base.py" , line 510 , in lambda > return lambda * args : val ( * gp_fixargs ( args , True ) ) ExecuteError : Failed to execute . Parameters are not valid . ERROR 000824 : The tool is not licensed . Failed to execute ( ZonalStatisticsAsTable ) .

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

The tool is not licensed

Arthur_Morgan

Hi I am trying to run the following script from py 2.7 IDLE that comes with ArcMap 10.7.1. When I try to run the following script:

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> os
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
<SPAN class="keyword token">from</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>sa <SPAN class="keyword token">import</SPAN> <SPAN class="operator token">*</SPAN>
<SPAN class="comment token">#Set the evironment settings</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'D:\Spring2020\VIC\PCA_Reclass_2004\PCA_Reclass_04'</SPAN>
<SPAN class="comment token">#Load the rasters</SPAN>
folder <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'D:\Spring2020\VIC\PCA_Reclass_2004\PCA_Reclass_04'</SPAN>
rasters <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListRasters<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"*"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"TIF"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> rasters
inpoly <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'D:\Spring2020\VIC\EB_Correct_File_ArcGIS\VIC.shp'</SPAN>
out <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'D:\Spring2020\VIC\EB_Correct_File_ArcGIS'</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>field<SPAN class="punctuation token">.</SPAN>name <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>inpoly<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
cursor<SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>inpoly<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'GRID_CODE'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> cursor
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>inpoly<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'GRID_CODE'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
 <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
    <SPAN class="comment token">#print row</SPAN>
    <SPAN class="keyword token">for</SPAN> raster <SPAN class="keyword token">in</SPAN> rasters<SPAN class="punctuation token">:</SPAN>
    out <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>out<SPAN class="punctuation token">,</SPAN> raster <SPAN class="operator token">+</SPAN> <SPAN class="string token">".dbf"</SPAN><SPAN class="punctuation token">)</SPAN>
    outT<SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>gp<SPAN class="punctuation token">.</SPAN>ZonalStatisticsAsTable<SPAN class="punctuation token">(</SPAN>inpoly<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"GRID_CODE"</SPAN><SPAN class="punctuation token">,</SPAN>raster<SPAN class="punctuation token">,</SPAN> out<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DATA"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'MEAN'</SPAN><SPAN class="punctuation token">)</SPAN> 

I get the following error <SPAN class="punctuation token">(</SPAN>even though I have the license <SPAN class="operator token">and</SPAN> can use the tool <SPAN class="keyword token">in</SPAN> ArcMap<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
raceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
 File <SPAN class="string token">"D:/Spring2020/VIC/zonal_stats_Table.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">21</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
 outT<SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>gp<SPAN class="punctuation token">.</SPAN>ZonalStatisticsAsTable<SPAN class="punctuation token">(</SPAN>inpoly<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"GRID_CODE"</SPAN><SPAN class="punctuation token">,</SPAN>raster<SPAN class="punctuation token">,</SPAN> out<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DATA"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'MEAN'</SPAN><SPAN class="punctuation token">)</SPAN>
 File <SPAN class="string token">"C:\Program Files (x86)\ArcGIS\Desktop10.7\ArcPy\arcpy\geoprocessing\_base.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">510</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN><SPAN class="keyword token">lambda</SPAN><SPAN class="operator token">></SPAN>
 <SPAN class="keyword token">return</SPAN> <SPAN class="keyword token">lambda</SPAN> <SPAN class="operator token">*</SPAN>args<SPAN class="punctuation token">:</SPAN> val<SPAN class="punctuation token">(</SPAN><SPAN class="operator token">*</SPAN>gp_fixargs<SPAN class="punctuation token">(</SPAN>args<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
ExecuteError<SPAN class="punctuation token">:</SPAN> Failed to execute<SPAN class="punctuation token">.</SPAN> Parameters are <SPAN class="operator token">not</SPAN> valid<SPAN class="punctuation token">.</SPAN>
ERROR <SPAN class="number token">000824</SPAN><SPAN class="punctuation token">:</SPAN> The tool <SPAN class="keyword token">is</SPAN> <SPAN class="operator token">not</SPAN> licensed<SPAN class="punctuation token">.</SPAN>
Failed to execute <SPAN class="punctuation token">(</SPAN>ZonalStatisticsAsTable<SPAN class="punctuation 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>

Find more posts tagged with

Accepted answers

JoshuaBixby

Checking whether Spatial is available is the first step, next you need to call CheckOutExtension—ArcMap | Documentation . The example code in the documentation gives you the steps you need to follow.

All comments

Arthur_Morgan

I tried the following and based on the print, it does say that Spatial Analyst is available.

#Check the license
if arcpy.CheckExtension("Spatial")=="Available":
print "Spatial is available"
else:
print "Zonal Statistics As Table is unavailable"

Output

Spatial is available

JoshuaBixby

ZonalStatistics isn't a extension, it is a tool, and CheckOutExtension is for licensing extensions. You need to know what license is required for your tool, which is why I asked about Spatial Analyst (use "Spatial") because that is the license you will need.

Arthur_Morgan

But this is not be happening as I have the license and I even use the tool in ArcMap

Arthur_Morgan

Yes it says Zonal Statistics As Table is unavailable, I tried the following:

if arcpy.CheckExtension("ZonalStatisticsAsTable")=="Available":
arcpy.CheckOutExtension("ZonalStatisticsAsTable"

else:

print "Zonal Statistics As Table is unavailable"

JoshuaBixby

Have you tried checking out a Spatial Analyst license to use the tool? CheckOutExtension—ArcMap | Documentation

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.