Latest Contributions by bradeckrose

I need a strategy to create an and return an Excel spreadsheet as the result of a web-initiated GeoProcessing tool.   It feels like a common problem that has probably been solved already. Would one process the result on the web-client (javascript) to create rows in a spreadsheet or CSV, or put the result, say a table in an in_memory workspace, then write python to create an Excel file from the geoprocessing result on the server.   If I used the python way, how do I stream it back to the client?  Use native python web-api? Or would I have the javascript client initiate the GP task, and when notified of completion, send another AJAX request to fetch the Excel result from a web-service, say ASP.Net or Django? Need some patterns to play with! Thanks, Brad ... View more

GPers, Having given up on ModelBuilder and Script Tools due to repeated Arc Desktop crashes, I have arrived down at the bare-metal:   the promising Python Toolbox. I'm trying to write a tool that allows the user choose the workspace, then select from a specific set of feature classes, then automatically fill a dropdown of filtered subtypes for the selected feature. This immediately presents the following problems: What datatype to set for the parameters?  Should I make them all string instead of Workspace, feature class, etc Is there an enumeration for the arcpy parameter datatypes so I don't have to type the bloody things and spell them correctly? How to detect the appropriate change-events? Should I set parameterDependencies() for any of them? What is the actual datatype of arcpy.Parameter.value?  a describe object?  a string? type (arcpy.Parameter.value) merely returns "property" Is there an arcpy.mapping dialog box that can display a table control? For coded picklists, like subtypes, what is the strategy for picking the value, yet returning the code so it can be used in a SQL expression?   The best I've seen is a list expansion with a value matching criteria.   Can this be handled if the argument were defined as a Field Info instead? Thus far, this is all I've been able to muster with no success: import arcpy class Toolbox(object):     def __init__(self):         """Define the toolbox (the name of the toolbox is the name of the         .pyt file)."""         self.label = "Toolbox"         self.alias = ""         # List of tool classes associated with this toolbox         self.tools = [FeaturesBySubtype] class AbstractTool(object):     def __init__(self):         """Define the tool (tool name is the name of the class)."""         self.label = "Tool"         self.description = ""         self.canRunInBackground = False     def getParameterInfo(self):         """Define parameter definitions"""         params = None         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):         """The source code of the tool."""         return class FeaturesBySubtype(AbstractTool):     def __init__(self):         self.label = "Query Features By Subtype"         self.description = "Return all the features of the specified subtype for the specified feature class"         self.canRunInBackground = True     def getParameterInfo(self):         p1 = arcpy.Parameter(             displayName="Workspace",             name="in_workspace",             datatype="Workspace",             parameterType="Required",             direction="Input")         p2 = arcpy.Parameter(             displayName="Feature Class",             name="in_featureclass",             datatype="Feature Class",             parameterType="Required",             direction="Input")         p3 = arcpy.Parameter(             displayName="Subtype",             name="in_subtype",             datatype="string",             parameterType="Required",             direction="Input")         p4 = arcpy.Parameter(             displayName="Output Table",             name="out_resulttable",             datatype="Table View",             parameterType="Required",             direction="Output")                 params = [p1,p2,p3,p4]         return params         def updateParameters(self, parameters):         if parameters[0].value:             arcpy.env.workspace=parameters[0].value                     for a_parm in parameters:             if a_parm.altered and not(a_parm.hasBeenValidated):                a_parm.setWarningMessage(str.format('Parameter modified {0}', a_parm.name)  )         parameters[1].filter.list=['Fuse','Switch']         st = arcpy.da.ListSubtypes('Fuse')         parameters[2].filter.type='ValueList'         parameters[2].filter.list = st.values()         return             def execute(self, parameters, messages):         arcpy.AddMessage(parameters)                 tableList = [parameters[1].value]                 fc_descr = arcpy.Describe ( parameters[1].value)         subtype_field = fc_descr.subtypeFieldName                 whereClause = str.format("{0}={1}",subtype_field,parameters[2].value)         lyrName = "QueryOutput"                 arcpy.AddMessage(whereClause)         # Make Query Table...         arcpy.MakeQueryTable_management(tableList, lyrName, None, None, None, whereClause)              # Print the total rows         arcpy.AddMessage( arcpy.GetCount_management(lyrName))              return    ... View more

I created a 5 line python script tool: import arcpy import sys input_value = arcpy.GetParameterAsText(0) output_message = "Hello World " + input_value arcpy.SetParameterAsText(1, output_message ) I ran it and got a result. I right-clicked/shared the result and said "publish as a service", selected the server, filled in the required description fields I pushed publish and receive:  "ERROR: unable to connect to publishing tool. Verify the service is up and running" I checked, and the service is indeed up and running and there are no log files on the server to indicate that any attempt was made to do anything. Any help is greatly appreciated! Brad ... View more

If found this in the help file: To disable data from being copied to the server, follow the instuctions below. Steps: 1. Open the Administrator Directory and log in with a user that has administrative permissions to your site. The Administrator Directory is typically available at http://<server name>:6080/arcgis/admin. 2.Click data > config > update. 3.On the Update Datastore Configuration page, enter the following string into the Datastore Configuration Properties dialog box: {"blockDataCopy": true} 4.Click Update. HOWEVER-- There is no config/update path under arcgis/admin/data--or anywhere in the admin pages that I can find.    SO there is no "update" option, and no Datastore Configuration Properties dialog box to be found.  Hence nowhere to put {"blockDataCopy":true} What file does this get stored in on the server and can I just notepad it in order to get past this trainwreck of a week? Brad ... View more

I have registered an SDE geodatabase with ArcGIS Server. I have an MXD that refers to the same geodatabase and so proceed to "share as" in ArcMap I fixed the "Analyze"-detected problems so all that are left are warnings. I click publish, spins its gears, until it asks me what data to upload.  WTF, I don't want to upload any data, just publish my flippin' MXD after 3 days of horsing around... Where in any dialog do you EXPLICITLY connect your MXD to a published datastore?   And if you can't do that, how does it ACTUALLY do it behind the scenes then?  Is it comparing Oracle alias name?   .sde connection file names? Beyond frustrating. Brad ... View more