Latest Contributions by NealBanerjee

Hello, I often find myself getting data in a geodatabase format, and usually first thing I want to do is just get a basic sense of contents.  Im sure others do/feel the same way.  If you are not familiar with it, the XRay addon for ArcCatalog has been/is great for listing feature classes, fields, domains, etc.  The one thing it doesnt provide is feature counts.  I havent been able to find something lightweight and simple to get the feature count information as well, so just spent a few minutes and wrote a very low-tech python code snippet.  It will go through a geodatabase and print each feature class name, type, and number of records.  It will also total number of feature classes and total feature at end.  Attached is a python code snippet (I saved just as .txt file) that you can  load (or copy/paste) to run within Arc Pro or ArcMap in command line.  Just make sure to change reference to GDB on line 5.  Below is exerpt of results that I ran in Pro   ... View more

Hello I want to basically clear all values in an existing raster and then replace them with values from another raster, without writing to a new raster dataset.  It seem like basically all functions/tools write things to a new raster dataset.  For instance if I want to make all cells in an existing raster dataset to be equal to 100 is there a tool/process without writing to a new raster?   Thanks! ... View more

Hello, I have a dashboard with several indicators that show the numbers of features in the current zoom extent (one for each data source).  I would like to have a separate indicator that basically sums up all the individual indicator.  I have been successful in creating a custom data expression to total all the features in the individual layers, however, since that is pulling directly from the feature layer using the 'FeatureSetByID' function.  Is there a way in a data expression for it to reference the return valued in another widget/indicator in the dashboard.  Attached is a annotated graphic that gives context           ... View more

Hello, Over the years I have built many script tools to run in Arc Toolbox within ArcMap.  These tools have run fine for years with no issue.  Several months ago (or maybe longer) I noticed often when I double-click the script to to open/run, there is a new message that Ive never saw before that says ' Click error and warning icons for more information' (see screenshot below).  However, there are no errors or warnings (when I click the yellow ribbon it goes away).  What is more problematic, some script tools that have lots of parameters now take extremely long to initialize (i.e. just open the form with the parameters) - sometimes as much as 7+ minutes.  Most of these tools do not have any special validation defined (in 'Validation' tab), so not sure why it takes so long.  Any thoughts/pointers on what may be contributing to this would be greatly appreciated.  I am running ArcMap 10.6.1 on Windows 10 (but that hasnt changed for a few years).  Thanks Neal   ... View more

Hello, Ive noticed that when I try to project a flow direction raster (D8 format) it sometimes changes values of the cells and makes the output flow direction raster not work.  Im keeping same cell size (but switching units).  Im assuming this has something to do when how raster is interpolated (Im using Nearest).  Anyone have idea/suggestion to force values to stay the same?   Thanks neal ... View more

Hello, I have had challenges querying date field (in a file geodatabase) within Model Builder when passing a date value using inline variable substitution.  After some frustration with many attempts,  I figured out a very simple and effective solution that I  thought I would share.   Situation You have a model that gets a date value as input parameter (user entered, from an existing field in feature class, etc.) and store as inline variable (e.g. valDate)  You want to query a date field (e.g. 'CompletionDate') in existing feature class again the date passed by the inline variable date.  For example you want query 'CompletionDate' > valDate in the 'MakeFeatureLayer' tool (see below) You may try a simple syntax as shown below - THIS WILL NOT WORK Issue Even if the valDate inline variable is defined as a 'Date' is is passed as a string, so you would need to include the reference %valDate% in quotes as such '%valDate%' However, that wouldnt fix issue since the date value passed as string is likely to be in mm/dd/yyyy format (e.g. 07/04/2020) but date format for file geodatabase in SQL query is "date '<date> <time>'" (date '2020-07-04) Solution Use the CAST function in your SQL query so that it "casts" (i.e. converts) string being passed from valDate to a Date value. See example below - THIS SHOULD WORK Hope you find this helpful Neal ... View more