Latest Contributions by JohnBrand

‎04-28-2020

I'm attempting to size my points by total production (double) and color by operator (text). So if I understand you correctly, I need to create a new field and populate it with a hex color code for each unique operator? Also, when I use this method, the size differences between my points are hard to discern. Most of the points look small and no matter what I set the size to, they remain the same size. Am I missing something on how to control the size of the points? I can successfully control point size when I'm just using graduated symbols, but I think I am doing something wrong with this Symbol Property Connection.

‎04-28-2020

I have a point shapefile and I want to vary the symbol size using a numeric attribute and vary the color using a text attribute. It seems like you can do one or the other but not both. Thanks.

‎03-09-2020

Like this? Setting the Default to the folder where the data is saved & extracted?

‎03-06-2020

I don't follow. My script (circled in green) downloads a zip file, unzips it, and overwrites existing data on my network. How do I make the newly downloaded data a precondition to execute the model?

‎03-06-2020

I want to make it a precondition. Not sure how. It won't allow me to connect it to anything else in the model.

‎03-06-2020

I'm running ArcPro 2.2. I wrote a small Python script and saved it as a Python Script Tool in my Toolbox. It has no parameters. I want to use it in in Model Builder in one of my existing models and I'm having trouble. All I want to do is make sure that the script runs first before the rest of the model. How do I make my script a precondition for the rest of the model? Thanks

‎10-03-2019

Any update on this?

‎09-19-2019

I'm trying to use the Field Calculator (python) to replace existing values (string) in Field1 with the values in Field2 (string) but only if Field2 is not Null. Having trouble with the syntax. Thanks, John

‎11-28-2017

I have a model that works fine.... until I hit the 'validate entire model' button. When I hit the button, some (not all) fields from my target feature disappear from the field map window in the spatial join tool near the end of my model. So then I have to reconnect the target features every time to get the fields to show back up in the spatial join field map window.

‎04-08-2016

Sorry. Using Desktop 10.1 SP1 I'm joining an Excel 2010 table to my shapefile and only keeping matching records. This works fine and the appropriate number of points show up in the map. I go into symbology, set up graduated symbols, everything looks great on the preview screen. I hit apply/ok and the points disappear from my map. The the identify tool recognizes them but there is no symbol on the map.

‎04-08-2016

I have a shapefile with lots of points in it. I perform a table join and only keep matching records. I try to use graduated symbols based on a double field in the joined table and the symbols disappear from the map. Anybody else have this problem?

‎01-22-2015

Hello, I have a join set up between a feature class and an Excel table and everything works great. When I open a second mxd that has the same join set up between the same feature class and Excel table, the join disappears. When I try to recreate the join, I get this message Failed to connect to database General Function failure External table is not in the expected format. Is there a work around for this? The table has to stay in Excel format so that other non-GIS users can make updates to it.

‎12-15-2011

I am trying to cut circles and squares out of an existing polygon. I could do this easily in 9.3 but the tools have changed and now I'm not sure how to do it.

‎01-06-2011

Is the field holding your acreages a 'float' or 'double' data type? If it is an 'integer' type, you can't use decimals.

‎01-06-2011

Is it possible to use the wildcard '%' on a numeric field (integer, double, etc) while using the 'like' operator? example I would like to select all numbers that end in zero. I know that "ELEVATION" LIKE '%0' works for strings. I would like to be able to use the expression on a numeric field.

Online Status	Offline
Date Last Visited	‎06-19-2024 09:32 PM

My Ideas

Latest Contributions by JohnBrand

Re: Symbology in ArcPro

Symbology in ArcPro

Re: Using a Python Script Tool in Modelbuilder

Re: Using a Python Script Tool in Modelbuilder

Re: Using a Python Script Tool in Modelbuilder

Using a Python Script Tool in Modelbuilder

Re: Highly Noticeable Flash

Use Calcuate Field to replace values

Why does validating my model cause fields in the field map of the spatial join tool to disappear?

Re: graduated symbols not showing up

graduated symbols not showing up

Join disappears

cut polygon - circles and squares

Re: Changing properties in attribute field

SQL Statements using 'Like'

graduated symbols not showing up

Re: Symbology in ArcPro