Latest Contributions by AndreasRuloffs1

Hello everybody, I have an arcpy program, that performs a series of different clips on an incoming geometry. I am only interested in the result, if there are geometries in the clip's result. To use this tool in an web application, I have published it as a geoprocessing service, For the sake of performance I want to calculate the several clips simultaneously. I found this tutorial: Parallel Python: Multiprocessing with ArcPy - YouTube  So I came to this solution (compressed to the basic I hope not have cut something important): import time import sys, os from multiprocessing import Pool import logging import arcpy logging.basicConfig(filename=os.path.join(arcpy.env.scratchWorkspace, "../", "20181204_BQ1_I.log"), level=logging.INFO, format='%(created)f %(asctime)s %(message)s') # Some constants are set to link in the databases out_path = "in_memory" arcpy.env.workspace = out_path arcpy.env.scratchWorkspace = out_path out_name_geometry = "JustAName" spatial_reference = arcpy.SpatialReference(2056) def clipfun(result, kind, out_geometry,timeString,sde): # the data will be set according to the kind arcpy.analysis.Clip(kind , arcpy.env.scratchGDB + "\\" + out_name_geometry + timeString, out_geometry + "_Clip_" + kind) rows = arcpy.da.SearchCursor(out_geometry + "_Clip_" + kind, ["SHAPE@AREA"]) result[kind+"_res"] = {} ergebnis[kind+"_res"] = False for row in rows: if row[0] >= schwellwertMeter: result[kind+"_res"] = True break del rows if row is not None: del row return result[kind+ "_res"] if __name__ == '__main__': geometry_as_json = arcpy.GetParameter(0) # Set local variables timeString = str(time.time()).replace(".", "_") out_geometry = out_path + "\\" + out_name_geometry + timeString # Execute CreateFeatureclass arcpy.CreateFeatureclass_management(arcpy.env.scratchGDB, out_name_geometry + timeString, "POLYGON", "#", "DISABLED", "DISABLED", spatial_reference) c = arcpy.da.InsertCursor(arcpy.env.scratchGDB + "\\" + out_name_geometry + timeString, ["SHAPE@JSON"]) c.insertRow([geometry_as_json]) del c res={ "LV_res":"", "NkB_res":"", "NkBW_res": "", "DG_res":"" ps = [] funcs=[(res,"LV",out_geometry,timeString,sde), (res,"NkB",out_geometry,timeString,sde), (res,"NkBW",out_geometry,timeString,sde), (res,"DG",out_geometry,timeString,sde)] p = Pool (processes=4) erg = p.map(callfunction,funcs) arcpy.SetParameter(1, res["LV_res"]) arcpy.SetParameter(2, res["NkB_res"]) arcpy.SetParameter(3, res["NkBW_res"]) arcpy.SetParameter(4, res["DG_res"]) logging.info('Ende')‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I can run this Tool in an arcGIS for desktop Toolbox and I can publish it to an arcGIS for server as an geoprocessing service. But when I try to run this new service I got this error: Fehler bei der Ausführung des Werkzeuges. ITest Job ID: j0cc0f30e501247dba8e7877929cc45ec : Traceback (most recent call last): File "D:\arcgisserver\directories\arcgissystem\arcgisinput\I2.GPServer\extracted\v101\lokal\Inventare_bestaende_ITest.py", line 255, in erg = p.map(clipfun,funcs) File "C:\Python27\ArcGISx6410.5\Lib\multiprocessing\pool.py", line 251, in map return self.map_async(func, iterable, chunksize).get() File "C:\Python27\ArcGISx6410.5\Lib\multiprocessing\pool.py", line 567, in get raise self._value PicklingError: Can't pickle <type 'function'="">: attribute lookup __builtin__.function failed Fehler beim Ausführen von (I2). Fehler beim Ausführen von (ITest). Has anybody done something like that and can help me with this? Tank you, Andreas Ruloffs ... View more

Hi there, I am facing a strange Problem. In the following Script two Tables in an sql-Server Database should be exported. The first one works, the second one not (I am sure it is spelled right). import tempfile import arcpyout Location = tempfile.mkdtemp() arcpy.TableToTable_conversion("../bamo.sde/bko.bkEingriffart",outLocation, "bkEingriffart.dbf") arcpy.TableToTable_conversion("../bamo.sde/bko.bkMassnahmenbkMassnahmenZiele",outLocation, "bkMassnahmenbkMassnahmenZiele.dbf")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ‍‍‍‍‍‍‍ I got the Error: Traceback (most recent call last):  File "C:\Users\xxx\.p2\pool\plugins\org.python.pydev_5.7.0.201704111357\pysrc\pydevd.py", line 1546, in <module>    globals = debugger.run(setup['file'], None, None, is_module)  File "C:\Users\xxx\.p2\pool\plugins\org.python.pydev_5.7.0.201704111357\pysrc\pydevd.py", line 982, in run    pydev_imports.execfile(file, globals, locals)  # execute the script  File "C:\Repositories\Python\bkonline2-deploy\gp-services\bko\exportSHP.py", line 13, in <module>    arcpy.TableToTable_conversion("../bamo.sde/bko.bkMassnahmenbkMassnahmenZiele",outLocation, "bkMassnahmenbkMassnahmenZiele.dbf")  File "C:\Program Files (x86)\ArcGIS\Desktop10.3\ArcPy\arcpy\conversion.py", line 2133, in TableToTable    raise earcgisscripting.ExecuteError: Failed to execute. Parameters are not valid. ERROR 000732: Input Rows: Dataset ../bamo.sde/bko.bkMassnahmenbkMassnahmenZiele does not exist or is not supportedFailed to execute (TableToTable).‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I use ArcGIS 10.3.1 for develpoing, but the error also occurs when using ArcGIS 10.5.1. Later the Script shell run as a geoprocessing Task on an ArcGIS for server. Has anybody an idea? Best Regard, Andreas ... View more