Hi Everyone, I am working on a toolbox that creates a table of extracted values. I have the output parameter set to DEtable, but whenever I run the tool the table is not created. Any help on this would be appreciated. # Start script #----------------------------------------------------------------------------- import arcpy import os # Tool initialization #----------------------------------------------------------------------------- class Toolbox ( object ) : def __init__ ( self ) : """Define the toolbox (the name of the toolbox is the name of the .pyt file).""" self . label = "Value_Extraction_Tool" self . alias = "Value Extraction Tool" # List of tool classes associated with this toolbox self . tools = [ Tool ] class Tool ( object ) : def __init__ ( self ) : """Define the tool (tool name is the name of the class).""" self . label = "Value Extraction Tool" self . description = "" self . canRunInBackground = False def getParameterInfo ( self ) : DataSource = arcpy . Parameter ( displayName = "DataSource" , name = "DataSource" , datatype = "DEWorkspace" , parameterType = "Required" , direction = "Input" ) InputPoint = arcpy . Parameter ( displayName = "InputPoint" , name = "InputPoint" , datatype = "DEFeatureClass" , parameterType = "Required" , direction = "Input" ) OutputTB = arcpy . Parameter ( displayName = "OutputTB" , name = "OutputTB" , datatype = "DEArcInfoTable" , parameterType = "Required" , direction = "Output" ) params = [ DataSource , InputPoint , OutputTB ] return params def isLicensed ( self ) : # Set whether tool is licensed to execute. return True def updateParameters ( self , parameters ) : # Modify the values and properties of parameters before internal # validation is performed. This method is called whenever a parameter # has been changed. return def updateMessages ( self , parameters ) : #Modify the messages created by internal validation for each tool #parameter. This method is called after internal validation.""" return def execute ( self , parameters , messages ) : # User input arguments DataSource = parameters [ 0 ] . valueAsText InputPoint = parameters [ 1 ] . valueAsText OutputTB = parameters [ 2 ] . valueAsText # Add geometry attributes to inupt point arcpy . AddGeometryAttributes_management ( InputPoint , "POINT_X_Y_Z_M" , "" , "" , 4326 ) # add fields to output table to hold the temporal data arcpy . AddField_management ( OutputTB , "POINTID" , "SHORT" ) arcpy . AddField_management ( OutputTB , "DATAINDEX" , "SHORT" ) arcpy . AddField_management ( OutputTB , "VALUE" , "DOUBLE" ) # Loop through geometry attributes and get the x and y with arcpy . da . SearchCursor ( InputPoint , "*" ) as cursor : PointIndex = 0 for row in cursor : X = row [ 3 ] Y = row [ 4 ] # Get rasters and extract data at an X and Y index = 0 for ( path , dirs , files ) in os . walk ( DataSource ) : for ThisFile in files : fName , fExt = os . path . splitext ( ThisFile ) if fExt . upper ( ) == ".IMG" or fExt . upper ( ) == ".TIF" : RasterPath = path + "\\" + ThisFile data = ( arcpy . GetCellValue_management ( RasterPath , str ( X ) + " " + str ( Y ) , "" ) ) aquisition_date = arcpy . GetRasterProperties_management ( in_raster = RasterPath , property_type = "ACQUISITIONDATE" ) if str ( aquisition_date ) . upper ( ) == "UNKNOWN" : insertcursor = arcpy . InsertCursor ( OutputTB ) row = insertcursor . newRow ( ) row . setValue ( "POINTID" , PointIndex ) row . setValue ( "DATAINDEX" , index ) row . setValue ( "VALUE" , data ) insertcursor . insertRow ( row ) del insertcursor index += 1 PointIndex += 0 del row del cursor return

I think a table is a 'non-transportable object' which means you can only pass it back as a file. The zip and ship example in the help is probably the way to move anything of appreciable size back. Well, glad you got something to work for now, even if not ideal.

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

Python Toolbox failing to create a table

GrantHaynes

Hi Everyone,

I am working on a toolbox that creates a table of extracted values. I have the output parameter set to DEtable, but whenever I run the tool the table is not created. Any help on this would be appreciated.

<SPAN class="comment token"># Start script</SPAN>
<SPAN class="comment token">#-----------------------------------------------------------------------------</SPAN>
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> os

<SPAN class="comment token"># Tool initialization</SPAN>
<SPAN class="comment token">#-----------------------------------------------------------------------------</SPAN>
<SPAN class="keyword token">class</SPAN> <SPAN class="token class-name">Toolbox</SPAN><SPAN class="punctuation token">(</SPAN>object<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">def</SPAN> <SPAN class="token function">__init__</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="string token">"""Define the toolbox (the name of the toolbox is the name of the
        .pyt file)."""</SPAN>
        self<SPAN class="punctuation token">.</SPAN>label <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Value_Extraction_Tool"</SPAN>
        self<SPAN class="punctuation token">.</SPAN>alias <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Value Extraction Tool"</SPAN>

        <SPAN class="comment token"># List of tool classes associated with this toolbox</SPAN>
        self<SPAN class="punctuation token">.</SPAN>tools <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>Tool<SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">class</SPAN> <SPAN class="token class-name">Tool</SPAN><SPAN class="punctuation token">(</SPAN>object<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">def</SPAN> <SPAN class="token function">__init__</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="string token">"""Define the tool (tool name is the name of the class)."""</SPAN>
        self<SPAN class="punctuation token">.</SPAN>label <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Value Extraction Tool"</SPAN>
        self<SPAN class="punctuation token">.</SPAN>description <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN>
        self<SPAN class="punctuation token">.</SPAN>canRunInBackground <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">False</SPAN>

    <SPAN class="keyword token">def</SPAN> <SPAN class="token function">getParameterInfo</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        DataSource <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Parameter<SPAN class="punctuation token">(</SPAN>
		    displayName<SPAN class="operator token">=</SPAN><SPAN class="string token">"DataSource"</SPAN><SPAN class="punctuation token">,</SPAN>
		    name<SPAN class="operator token">=</SPAN><SPAN class="string token">"DataSource"</SPAN><SPAN class="punctuation token">,</SPAN>
		    datatype<SPAN class="operator token">=</SPAN><SPAN class="string token">"DEWorkspace"</SPAN><SPAN class="punctuation token">,</SPAN>
		    parameterType<SPAN class="operator token">=</SPAN><SPAN class="string token">"Required"</SPAN><SPAN class="punctuation token">,</SPAN>
		    direction<SPAN class="operator token">=</SPAN><SPAN class="string token">"Input"</SPAN><SPAN class="punctuation token">)</SPAN>

        InputPoint <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Parameter<SPAN class="punctuation token">(</SPAN>
            displayName<SPAN class="operator token">=</SPAN><SPAN class="string token">"InputPoint"</SPAN><SPAN class="punctuation token">,</SPAN>
		    name<SPAN class="operator token">=</SPAN><SPAN class="string token">"InputPoint"</SPAN><SPAN class="punctuation token">,</SPAN>
		    datatype<SPAN class="operator token">=</SPAN><SPAN class="string token">"DEFeatureClass"</SPAN><SPAN class="punctuation token">,</SPAN>
		    parameterType<SPAN class="operator token">=</SPAN><SPAN class="string token">"Required"</SPAN><SPAN class="punctuation token">,</SPAN>
		    direction<SPAN class="operator token">=</SPAN><SPAN class="string token">"Input"</SPAN><SPAN class="punctuation token">)</SPAN>

        OutputTB <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Parameter<SPAN class="punctuation token">(</SPAN>
            displayName<SPAN class="operator token">=</SPAN><SPAN class="string token">"OutputTB"</SPAN><SPAN class="punctuation token">,</SPAN>
		    name<SPAN class="operator token">=</SPAN><SPAN class="string token">"OutputTB"</SPAN><SPAN class="punctuation token">,</SPAN>
		    datatype<SPAN class="operator token">=</SPAN><SPAN class="string token">"DEArcInfoTable"</SPAN><SPAN class="punctuation token">,</SPAN>
		    parameterType<SPAN class="operator token">=</SPAN><SPAN class="string token">"Required"</SPAN><SPAN class="punctuation token">,</SPAN>
		    direction<SPAN class="operator token">=</SPAN><SPAN class="string token">"Output"</SPAN><SPAN class="punctuation token">)</SPAN>

        params <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>DataSource<SPAN class="punctuation token">,</SPAN> InputPoint<SPAN class="punctuation token">,</SPAN> OutputTB<SPAN class="punctuation token">]</SPAN>
        <SPAN class="keyword token">return</SPAN> params

    <SPAN class="keyword token">def</SPAN> <SPAN class="token function">isLicensed</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="comment token"># Set whether tool is licensed to execute.</SPAN>
        <SPAN class="keyword token">return</SPAN> <SPAN class="token boolean">True</SPAN>

    <SPAN class="keyword token">def</SPAN> <SPAN class="token function">updateParameters</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">,</SPAN> parameters<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="comment token"># Modify the values and properties of parameters before internal</SPAN>
        <SPAN class="comment token"># validation is performed.  This method is called whenever a parameter</SPAN>
        <SPAN class="comment token"># has been changed.</SPAN>
        <SPAN class="keyword token">return</SPAN>

    <SPAN class="keyword token">def</SPAN> <SPAN class="token function">updateMessages</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">,</SPAN> parameters<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="comment token">#Modify the messages created by internal validation for each tool</SPAN>
        <SPAN class="comment token">#parameter.  This method is called after internal validation."""</SPAN>
        <SPAN class="keyword token">return</SPAN>

    <SPAN class="keyword token">def</SPAN> <SPAN class="token function">execute</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">,</SPAN> parameters<SPAN class="punctuation token">,</SPAN> messages<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>

        <SPAN class="comment token"># User input arguments</SPAN>
        DataSource <SPAN class="operator token">=</SPAN> parameters<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>valueAsText
        InputPoint <SPAN class="operator token">=</SPAN> parameters<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>valueAsText
        OutputTB <SPAN class="operator token">=</SPAN> parameters<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>valueAsText


        <SPAN class="comment token"># Add geometry attributes to inupt point</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>AddGeometryAttributes_management<SPAN class="punctuation token">(</SPAN>InputPoint<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"POINT_X_Y_Z_M"</SPAN><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="number token">4326</SPAN><SPAN class="punctuation token">)</SPAN>

        <SPAN class="comment token"># add fields to output table to hold the temporal data</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>OutputTB<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"POINTID"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SHORT"</SPAN><SPAN class="punctuation token">)</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>OutputTB<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DATAINDEX"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SHORT"</SPAN><SPAN class="punctuation token">)</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>OutputTB<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VALUE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DOUBLE"</SPAN><SPAN class="punctuation token">)</SPAN>

        <SPAN class="comment token"># Loop through geometry attributes and get the x and y</SPAN>
        <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>InputPoint<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"*"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
            PointIndex <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
            <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
                X <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN>
                Y <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN>

                <SPAN class="comment token"># Get rasters and extract data at an X and Y        </SPAN>
                index <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
                <SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN>path<SPAN class="punctuation token">,</SPAN> dirs<SPAN class="punctuation token">,</SPAN> files<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">in</SPAN> os<SPAN class="punctuation token">.</SPAN>walk<SPAN class="punctuation token">(</SPAN>DataSource<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
                    <SPAN class="keyword token">for</SPAN> ThisFile <SPAN class="keyword token">in</SPAN> files<SPAN class="punctuation token">:</SPAN>
                        fName<SPAN class="punctuation token">,</SPAN>fExt <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>splitext<SPAN class="punctuation token">(</SPAN>ThisFile<SPAN class="punctuation token">)</SPAN>
                        <SPAN class="keyword token">if</SPAN> fExt<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">".IMG"</SPAN> <SPAN class="operator token">or</SPAN> fExt<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">".TIF"</SPAN><SPAN class="punctuation token">:</SPAN>
                            RasterPath <SPAN class="operator token">=</SPAN> path <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\\"</SPAN> <SPAN class="operator token">+</SPAN> ThisFile

                            data <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetCellValue_management<SPAN class="punctuation token">(</SPAN>RasterPath<SPAN class="punctuation token">,</SPAN> str<SPAN class="punctuation token">(</SPAN>X<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>Y<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
                            aquisition_date <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetRasterProperties_management<SPAN class="punctuation token">(</SPAN>in_raster <SPAN class="operator token">=</SPAN> RasterPath<SPAN class="punctuation token">,</SPAN> property_type <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ACQUISITIONDATE"</SPAN><SPAN class="punctuation token">)</SPAN>

                            <SPAN class="keyword token">if</SPAN> str<SPAN class="punctuation token">(</SPAN>aquisition_date<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">"UNKNOWN"</SPAN><SPAN class="punctuation token">:</SPAN>
                                insertcursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>OutputTB<SPAN class="punctuation token">)</SPAN>
                                row <SPAN class="operator token">=</SPAN> insertcursor<SPAN class="punctuation token">.</SPAN>newRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
                                row<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"POINTID"</SPAN><SPAN class="punctuation token">,</SPAN> PointIndex<SPAN class="punctuation token">)</SPAN>
                                row<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"DATAINDEX"</SPAN><SPAN class="punctuation token">,</SPAN> index<SPAN class="punctuation token">)</SPAN>
                                row<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"VALUE"</SPAN><SPAN class="punctuation token">,</SPAN> data<SPAN class="punctuation token">)</SPAN>
                                insertcursor<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>
                                <SPAN class="keyword token">del</SPAN> insertcursor
                                index <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</SPAN>

                PointIndex <SPAN class="operator token">+=</SPAN> <SPAN class="number token">0</SPAN>
            <SPAN class="keyword token">del</SPAN> row
            <SPAN class="keyword token">del</SPAN> cursor
        <SPAN class="keyword token">return</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

GrantHaynes

Thanks, guess I must have misread something when I said it doesn't support tables, says right in there it does. I still don't know what I'm doing wrong, I ran this script successfully with a table output in arcmap only to have it fail in server. It kept creating the table locally on my machine and the feature class on the server. I've overcome this problem by returning a large feature class with 1 point per raster that holds the associated data. I know it's not the greatest way to do this, but its working.

curtvprice

I just read that GP services on arcserver don't support tables.

There are several approaches to returning 'non transportable' outputs, including tables.

Geoprocessing task settings: Outputs—Documentation | ArcGIS Enterprise

GrantHaynes

I was trying a few different table outputs, I accidentally pasted in a version of the script with a different table type. Whenever I've written one of these python toolboxes I've never had to use create feature class,when outputting a feature class, a blank one would be automatically be created. Ultimately this is all a mute point since I'm trying to use this script as a custom geoprocessing service and I just read that GP services on arcserver don't support tables.

Luke_Pinner

You state:

I have the output parameter set to DEtable

But your code shows:

        OutputTB <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Parameter<SPAN class="punctuation token">(</SPAN>
            displayName<SPAN class="operator token">=</SPAN><SPAN class="string token">"OutputTB"</SPAN><SPAN class="punctuation token">,</SPAN>
              name<SPAN class="operator token">=</SPAN><SPAN class="string token">"OutputTB"</SPAN><SPAN class="punctuation token">,</SPAN>
              datatype<SPAN class="operator token">=</SPAN><SPAN class="string token">"DEArcInfoTable"</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="comment token"># <======== ???</SPAN>
              parameterType<SPAN class="operator token">=</SPAN><SPAN class="string token">"Required"</SPAN><SPAN class="punctuation token">,</SPAN>
              direction<SPAN class="operator token">=</SPAN><SPAN class="string token">"Output"</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>

Are you really trying to create an INFO table?

it seems like Arc wont create a table inherently like it will a feature class

ArcMap won't inherently create a feature class either. If you're trying to create an empty feature class from scratch (rather than exporting or copying an existing one or as an output from a geoprocessing operation), you need to use the Create Feature Class tool, just like when you want to create an empty table, you need to use the Create Table tool.

GrantHaynes

Sort of, it seems like Arc wont create a table inherently like it will a feature class, guess I'll have to break up that input string to create a table. I've posted the entire updated script above.

RandyBurton

For a bit of clarity, here is the execute section formatted as Dan suggests. I've added the return on line 28, but I think you have additional code that goes before that line.

<SPAN class="keyword token">class</SPAN> <SPAN class="token class-name">Tool</SPAN><SPAN class="punctuation token">(</SPAN>object<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="comment token">#......</SPAN>

    <SPAN class="keyword token">def</SPAN> <SPAN class="token function">execute</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">,</SPAN> parameters<SPAN class="punctuation token">,</SPAN> messages<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="string token">"""The source code of the tool."""</SPAN>

        DataSource <SPAN class="operator token">=</SPAN> parameters<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>valueAsText
        InputPoint <SPAN class="operator token">=</SPAN> parameters<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>valueAsText
        OutputTB <SPAN class="operator token">=</SPAN> parameters<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>valueAsText

        <SPAN class="comment token"># Add geometry attributes to inupt point</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>InputPoint<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"POINTID"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SHORT"</SPAN><SPAN class="punctuation token">)</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>AddGeometryAttributes_management<SPAN class="punctuation token">(</SPAN>InputPoint<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"POINT_X_Y_Z_M"</SPAN><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="number token">4326</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>InputPoint<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"POINTID"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
            index <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
            <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
                row<SPAN class="punctuation token">[</SPAN>index<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> index
                index <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</SPAN>

        <SPAN class="keyword token">del</SPAN> row
        <SPAN class="keyword token">del</SPAN> cursor

        <SPAN class="comment token"># add fields to output table to hold the temporal data</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>OutputTB<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"POINTID"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SHORT"</SPAN><SPAN class="punctuation token">)</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>OutputTB<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DATAINDEX"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SHORT"</SPAN><SPAN class="punctuation token">)</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>OutputTB<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VALUE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DOUBLE"</SPAN><SPAN class="punctuation token">)</SPAN>
        
        <SPAN class="keyword token">return</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>

I believe you need to use Create Table before lines 23-26 that are adding fields. Your third parameter appears to be the name for the table, but the table is not created just by giving it a name in the parameter form. I'm also not sure if your code is getting past line 17, which probably should be row[0] = index. Since you are incrementing index, the value of row[index] would quickly be out of range.

If I understand what you are trying to do, you are adding longitude and latitude fields to a point feature with the Add Geometry Attributes tool. This will add two fields of type double to the feature (POINT_X and POINT_Y as default names). You are also adding an id field as a short integer instead of using the OID@ field.

I am assuming that you want to read the point id, longitude and latitude into your table. Your table will need 2 fields of type double for the xy coordinates. So it seems you may want to rethink your table design.

Since things can be a bit tricky to debug inside a python toolbox, I would suggest trying the execute function as a stand-alone script. Then add it back into your toolbox script.

Hope this helps.

DanPatterson_Retired

hard to tell since your code as posted will fail due to copy-paste issues, I presume,

/blogs/dan_patterson/2016/08/14/script-formatting

Nimm an der Unterhaltung teil

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

Anmelden
Registrieren

Schnellzugriffe

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