Latest Contributions by MollyMoore

I have a custom Python Toolbox that has been running fine. Since the update to Pro, when I run the script, the program immediately crashes and if I can open the dialog box in time, it contains the following error: Error 000819: The tool is not available or is unassigned All of my third party packages are in the python environment that is active in Pro and I have background processing turned off int he script. I'm not sure what else to try. What would have changed in the update to make this suddenly start to happen? ... View more

I am trying to install a third-party Python package from within a Python script so that other users can run the script and the package can be installed and loaded without having to manually download and install. This is the code I'm using:     import subprocess     def install(package):         subprocess.call([sys.executable, "-m", 'pip', 'install', package])         install('pyodbc')     import pyodbc This seems to work fine from within my stand-alone Python script. However, when I try to run it as a script tool set up in ArcGIS Pro, it is not finding the installed package and is failing with this error message:     ModuleNotFoundError: No module named 'pyodbc' Does anyone know what the issue is? Do I need to change a path or environment setting? ... View more

I have a Python script that I would like to operate as a standalone script. When I copy and paste it into the Python window in a fresh ArcMap .mxd, it operates fine. However, when I attempt to run it as a standalone script within my Python IDE, it fails during the tabulate area tool that is written like this:      tab_area = TabulateArea(target_features,"unique_id",sdm,"Value",os.path.join(outTable,"tab_area_temp"),"30") I am getting the ambiguous 999998 error message:     ExecuteError: ERROR 999998: Unexpected Error. Does anyone have any ideas as to why this might be working fine when copied and pasted into the Python window in ArcMap, but failing as a standalone script? Full Python script is below for reference: import arcpy, os, datetime from arcpy import env from arcpy.sa import * from itertools import groupby from operator import itemgetter print "start time: " + datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S") arcpy.env.overwriteOutput = True target_features = r'C:\Users\mmoore\Documents\ArcGIS\COA.gdb\PlanningUnit_Hex10acre' sdm_folder = r'C:\Users\mmoore\Documents\ArcGIS\SDMs.gdb' outTable = r'C:\Users\mmoore\Documents\ArcGIS\out_tables.gdb' arcpy.env.workspace = sdm_folder sdms = arcpy.ListRasters() species_tables = [] for sdm in sdms:     print sdm + " started at: " + datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")     sdm_path = os.path.join(sdm_folder,sdm)     arcpy.CheckOutExtension("Spatial")     tab_area = TabulateArea(target_features,"unique_id",sdm,"Value",os.path.join(outTable,"tab_area_temp"),"30")     sdm_table = arcpy.TransposeFields_management(tab_area,"VALUE_1 Low;VALUE_2 Medium",os.path.join(outTable,sdm),"OccProb","PERCENTAGE","unique_id")     arcpy.AddField_management(sdm_table,"ElSeason","TEXT","","",20,"ElSeason")     with arcpy.da.UpdateCursor(sdm_table,["OccProb","PERCENTAGE","ElSeason"]) as cursor:         for row in cursor:             row[1] = (int(row[1])/40468.383184)*100             cursor.updateRow(row)             row[2] = sdm             cursor.updateRow(row)             if row[0] == "VALUE_1":                 row[0] = "Low"             elif row[0] == "VALUE_2":                 row[0] = "Medium"                 cursor.updateRow(row)     with arcpy.da.UpdateCursor(sdm_table, "PERCENTAGE") as cursor:         for row in cursor:             if row[0] > 10:                 pass             else:                 cursor.deleteRow()     case_fields = ["unique_id", "ElSeason"]     max_field = "PERCENTAGE"     sql_orderby = "ORDER BY {}, {} DESC".format(",".join(case_fields), max_field)     # use groupby cursor to order by percent coverage     with arcpy.da.UpdateCursor(sdm_table, "*", sql_clause=(None, sql_orderby)) as cursor:         case_func = itemgetter(*(cursor.fields.index(fld) for fld in case_fields))         for key, group in groupby(cursor, case_func):             next(group)             for extra in group:                 cursor.deleteRow()     species_tables.append(sdm_table)     arcpy.Delete_management(tab_area)     print sdm + " finished at: " + datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S") merge = arcpy.Merge_management(species_tables, os.path.join(outTable, "SGCN_SDMxPU")) print "end time: " + datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ The full error message is as follows: Traceback (most recent call last):   File "H:\Scripts\COA\COA\COA_species_populator v.7_SDMraster.py", line 23, in <module>     tab_area = TabulateArea(target_features,"unique_id",sdm,"Value",os.path.join(outTable,"tab_area_temp"),30)   File "C:\Program Files (x86)\ArcGIS\Desktop10.5\ArcPy\arcpy\sa\Functions.py", line 6183, in TabulateArea     processing_cell_size)   File "C:\Program Files (x86)\ArcGIS\Desktop10.5\ArcPy\arcpy\sa\Utils.py", line 53, in swapper     result = wrapper(*args, **kwargs)   File "C:\Program Files (x86)\ArcGIS\Desktop10.5\ArcPy\arcpy\sa\Functions.py", line 6175, in Wrapper     processing_cell_size)   File "C:\Program Files (x86)\ArcGIS\Desktop10.5\ArcPy\arcpy\geoprocessing\_base.py", line 510, in <lambda>     return lambda *args: val(*gp_fixargs(args, True)) ExecuteError: ERROR 999998: Unexpected Error. Failed to execute (TabulateArea).‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more