Latest Contributions by JustinNettleton1

‎02-26-2024

Thanks for this. This helps. It kind of led me to a knew issue though. I don't want the Closed events to show on the map. I can change the symbol to be blank, but when I click on a feature that is Open, it could have 4 other features under it that are closed and show up in the popup. So is there anyway to just show the date for the Open events on the map and in the popup? I wish they we could just run arcade expressions in the filter tool.

‎02-26-2024

I have web service that is showing road closures that usually last less than a day. I am trying to find a way to only show the closures on the map that are active, so after the start date/time and before the end date/time. I have been trying to accomplish this by using an arcade symbology expression, but I can't figure out. Says the expression is right but doesn't show the closures I want on the map. Is this the best way to accomplish this? Does anybody have an idea on how to best set up the expression? I have 3 types of date time fields to choose from, I can't figure out any of them out. I have attached an image of the field options I have. Here is one expression I tried with the epoch date fields. //ToLocal(Timestamp()) var started = $feature.closureStartEpoch var closed = $feature.closureEndEpoch var present = date() // if current date/time is greater than or equal to the start time // AND current date/time is less than or equal to the close time // return open, otherwise its closed If (present >= started && present <= closed) { return "Open" If (present <= started && present >= closed) { return "Closed" } } else { return "Other" } These are the Start and End Date/Time fields I have to choose from.

‎02-08-2024

I have created a model in ArcGIS Pro that takes a csv document, exports the date using XY to points tool, deletes some fields then adds and calculates some fields. When I run this model from the ArcPro model window below, it works just fine. No errors and the table populates just fine. The end product I am looking for, is to schedule the model to run several times a day to update this layer. I then have a different python script that update a web service in AGO. That portion works just fine. I just can't get the data to that point. The issue I am having is when I try to run the model from the Geoprocessing tool or try to schedule, it to run in task scheduler, it corrupts the table and I get this error. The model says it runs just fine, but get this image below when I try to open the table. Any one have any ideas on why this would be happening or different ways to go about this? I am using. ArcPro 3.1.3 Thanks, Justin Nettleton

‎08-25-2022

Thank you for these solutions. They have helped the performance.

‎08-23-2022

I am setting up some attribute rules to populate fields in my NG911 address database. A Lot of these fields are populated off of interests of 3 different polygon layers. I have them all set up as multiple rules now and they are working, but editing is very slow. I know I can combine these rules into one, just not sure how to do it when I am intersecting multiple layers to populate different fields. Can some one point me in the right direction or have a sample for me? Thanks, Justin

‎05-18-2021

Thank you both. This worked.

‎05-17-2021

I work with Address data that goes into a Computer aided Dispatch system. I am calculating a field in my Address Points that takes the Feature ID number for the corresponding street layer with the same name and puts it into the address layer for routing purposes. What I am trying to do is calculate the distance between the address point and its corresponding street segment to make sure I am using the correct street for routing and it didn't t populate the wrong ID into my address field. Do any know the best way or tool to do this? Thanks, Justin Nettleton

‎03-05-2020

This did it. Thanks for all the help.

‎03-05-2020

My source field is Call AddrNumber, I just copied it a new field called junk to copy exactly how you had it. Source field looks the same as the new junk field after the calculation. Sou

‎03-05-2020

Following your instructions it still isn't getting rid of anything. As you can see it is stacking the characters after the space.

‎03-05-2020

ok, but I don't want to keep anything after the space. I want the space any anything after it deleted from the field. I don't have any nulls or anything.

‎03-05-2020

Dan, the calculation worked but now it is showing as 12345 *0. Doesn't look like it deleted anything after the space.

‎03-04-2020

Hello, I am trying to move an address number field from a text to an integer field. The issue I am having is some of the addresses in the text field have spaces in them followed by a unit number. I already have another field with unit numbers so trying to figure out a way to mass updates these features. There is about 85000 of them. Address Num example: 12345 01 Is there some sort of function (replace, trim?) where I can search for the space and delete everything after it in my text address number field? Thanks, Justin

‎03-04-2020

Wow, I stared at this for 30 mins and never noticed this. That was the issue. Thanks sometimes it just takes another pair of eyes.

‎03-03-2020

I am working on an Attribute assitant IF statement. I am following replicating everything I am seeing on online but features won't update. Does anyone see any issues with my statement? IIF([lgcyPreDir] ="E", "EAST", IIF([lgcyPreDir]] ="N", "NORTH", IIF([lgcyPreDir]] ="W", "WEST", IIF([lgcyPreDir]] ="S", "SOUTH",""))))

Online Status	Offline
Date Last Visited	Monday

My Ideas

Latest Contributions by JustinNettleton1

Re: Only show Features on map that are between Start and End Date/Time Fields

Only show Features on map that are between Start and End Date/Time Fields

Run Module from Geoprocessing Pain or schedules Task Corrupts Table

Re: Calculate Multiple Fields from multiple Intersection poly layers using Attribute Rules

Calculate Multiple Fields from multiple Intersection poly layers using Attribute Rules

Re: Calculate Distance between Related Features

Calculate Distance between Related Features

Re: Replace in Field Calculator

Re: Replace in Field Calculator

Re: Replace in Field Calculator

Re: Replace in Field Calculator

Re: Replace in Field Calculator

Replace in Field Calculator

Re: Attribute Assistant IF Statement

Attribute Assistant IF Statement

Re: Calculate Distance between Related Features