Latest Contributions by NealBanerjee

Hello, I have a fairly simple model that creates a subset of a point feature class using the 'Select' tool, and then assigns raster values for 7 different rasters using the ' Multi Values to Points' tool (see below).  When I run it in the ModelBuilder interface everything works fine everytime.  However when I run it through the toolbox, it seems to run fine (see 2nd graphic), but it deletes the feature class that it creates, so essentially does nothing.  Any ideas why this may be happening?  Ive confirmed that the output feature class that it writes is not 'Intermediate'.  I only have this problem with this tool.  There is very frustrating as Im trying to run this in a series using a batch script tool, but it creates the process to fail Any insight/help would be greatly appreciated! Neal ... View more

Hello, I have a custom toolbox that I have created with a bunch (20+) of ModelBuilder tools.  I have created a Script Tool in Python that basically runs all of the individual tools in batch mode.  The script tool is stored in the same tool box (different tool set) than the individual components.  In order to run the script tool successfully it seems I have to explicitly load the toolbox (arcpy.ImportToolbox(<name>.tbx)) even though Im running the script from the tool box that is already loaded in the current ArcMap document/session.  If I dont load it, I get the following error (the RskPreA_rarr is the name of my first model/tool) Not that it is a big deal to load the toolbox, but this seems like rather odd behavoir that I dont recall happening before in other things Ive done.  Any insights on what is happening or if I am setting up something wrong? Thanks Neal ... View more

Hello, I have some ModelBuilder models and Python scripts that create "in-memory" feature layers.  If they are already created, is there a way to load them into ArcMap?  If I try to run a standard geoprocessing tool in my session, I can they show up as options, but wanted to see if direct way I can load them.  Thanks Neal ... View more

Hello, I have created a toolbox and developed a series of about 20 tools in ModelBuilder that represent different components of an analysis.  Each model runs fine without error when run in model building or executed in the Python command line within ArcMap.  Some of the models are fairly complex and involve iterators, in-line variables, etc. I created a script tool with an associated Python script that basically runs all the component models in sequence.  Most of the models run fine, but a few that have iterators keep giving error when run through the Python Script tool.  The first model that the script chokes on involves an iterator with the 'Get Field Value' tool that then writes a value to a variable field name based on the get value value.  The values that  should be produced start at 2 and go to 500.  However, when I run Python script it for some reason returns a value of 1 and then bombs.  Again model run fine in model builder.   Below is an annotated screenshot of model. Im stumped where/why it is return a value of 1.  Any ideas on why something in ModelBuilder works but not the identical process run from python script?  The input parameters and model reference work fine - so it is definitely something occurring within the model.  I cant imagine it is something in the script itself because it is just calling the model and the other models run fine. Any help would be greatly appreciated Thanks! Neal ... View more

I have a table (tblImprv) with two fields - an unique ImprvID and an associated ParcelID. There can be 1 or more improvements.  What I am trying to do is create a query for this table that returns the ParcelIDs and the number of improvements.   I realize I can do this by summarizing the data on ParcelID and returning the count, but was wondering if something like this can be done using the 'Make Table Query' using a subquery.  The general SQL syntax I would use would be something like that shown below, but Im not clear how to implement in Make Table Query tool or if it can event be done.  Ultimately I want to only select the parcels with 2 or more improvements, but I cant even get past this first step (SELECT ParcelID, Count(ImprvID) AS CntImpv FROM tblImprv GROUP BY ParcelID;) Example tblImprv and query result      ... View more