Latest Contributions by JoeBorgione

Hey @XanderBakker ; for each layer I have a rule.  I did it that way because each layer has a value for a different field in my site address points:  Municipalities layer provides a city name for the point field CITY Zip code layer provides  a numeric zipcode value for the point field ZipCode etc...  For a 9-1-1 application there would be feature layers like PoliceBeat, FireZone, EMTZone etc... I don't know how to construct a single attribute rule for multiple attributes. ... View more

I'm not a big AGOL user so I really can't comment on your concerns.  I'm sure it made sense to the team that designed and built it.  You have to remember that AGOL is an extremely lightweight application compared to the other ArcGIS power houses, so there are trade offs.  I did notice the refresh thing too; if you look at my screen captures they are two different sets of points.... ... View more

@TINATHOMPSON  check this blog.  I don't work in 9-1-1 anymore but I still do addressing and I use the ESRI Address Data Management Solution.  I augmented the solution with a couple of my own rules that grab underlying polygon data to populate address points.  I really like the solution for addressing, but will be the first to tell you that the Arcade portion can be a challenge; but that's what this forum is for. Just ask @XanderBakker how many times he helped me out... ... View more

I'm trying to display addresses as labels and the address comes in as 1,612 instead of 1612. I was looking for a way to calculate the field ... Are you calculating the value of a field in your database that concatenates various field values, or are you trying to create a label on a map?  Are you using ArcMap or ArcGIS Pro? If you're using ArcMap, we'll have to get someone else involved, because I don't use it anymore; ArcGIS Pro only, and I know just the guy;  @DavidPike are you seeing this? Fill in the blanks for us here, and we'll try to get you going. ... View more

In order to deploy address rules on a feature or table record, they must be assigned Global IDs.  You accomplish this with Add Global IDs.  Global IDs are generated and maintained behind the scenes by the geodatabase itself.  So if you copy or otherwise move the records to another geodatabse, the global ids will change. ... View more

Interesting discussion: I'm not all that familiar with using time enabled data.  Thanks @jcarlson for the insight.   ... View more

I don't have ArcMap but I am seeing the exact same thing you are in AGOL and Pro. All 15,9937 records show <Null> Deaths and 0 Cases. Is the service based on a csv?  Can you get a copy of the data in csv and see what you can display? ... View more

I used the simple data loader extensively and often wondered the same thing. It's no longer available in ArcGIS Pro which is all I use now.  You might consider using the append tool and saving the execution to a python script. ... View more

F strings are new to python 3.x but the format() method is it's predecessor in 2.x python. ... View more

So we are not dealing with an actual global id field anymore? You mention that you want an attribute rule for each field. When do you want these rules to fire?  Are you adding new features to this layer, or do you want to validate the existing values and update them?  Depending what you are doing, I suggest you take a look at the online help that describes the difference between calculation and validation rules. You also mention a sequence.  You can add a database sequence that starts at any value and increments by any value.  Typically these are used when adding a new feature, but I think you could write a validation rule such that if that field is <null> or 0, return the next sequence value Is the cod_alfa always going to be 'PP' if so, I would simply calculate that field to equal 'PP'.  If you are adding features and want 'PP' to be the default, I suggest you use a domain for that. I tinkered around a bit in the arcade ' playground '  and got the following code working:   var values = [0, 'PP', 1234] var combined_value = []; for (var i in values) { var value = values[i]; if (value == 0) { value = "00000" } combined_value[Count(combined_value)] = value} Console(Concatenate(combined_value, ""));   The Console() function prints the value of the concatenated_value: Hopefully this helps a bit. ... View more

I was replying to the OP too... ... View more

I've done a few joins in my career; spatial and tabular.  I think I did my first in 1990 with ArcInfo, but thanks for the explanation on how they work none the less.. ... View more

How did you do it in ArcMap? ... View more