Latest Contributions by TimothyWoodfield

‎09-25-2020

Figured it out! One of my rows had an empty PopupInfo field so it was failing because there weren't enough indexes. So yes you were right that the index was only a length of 1. I only selected the features with the PopupInfo filled out and it worked. Thanks!

‎09-25-2020

Figured it out! One of my rows had an empty PopupInfo field so it was failing because there weren't enough indexes. So yes you were right that the index was only a length of 1. I only selected the features with the PopupInfo filled out and it worked. Thanks!

‎09-24-2020

Hi everyone, I am trying to use the .split() function on a string and keep gettings errors. The field is the popup information from a converted KMZ and is called PopupInfo. The code I am trying to use is: !PopupInfo!.split(" ")[14] but am getting Error 000539 and is saying "IndexError: list index out of range". The calculation will run fine if 14 is swapped out for 0 or -1 to get the first or last section. I am counting 27 sections if it is being broken at each " ". I've tried finding and replacing all of the 's with a dash or underscore but the calculation still fails with anything other than 0 or -1. The text string that I am trying to pull from looks something like this: US20 EB FID 57 RampDate 9/30/2013 RouteId 161 RouteName US20 EB TownId 314 TownName Watertown IsMissingR False IsMissingS False IsMissingC True InspNotes DistrictId 6 LegacyID 335 status 6 StatusText Deficient DstrctRank 669 deficient -1 GlobalID {C4BBAA58-9DFE-4953-AC74-FF3448002388} created_us created_da last_edite DAVID.DINOCCO last_edi_1 10/17/2017 ReInspectn 0 AssetID ProgNotes Rank 669 I would be trying to field calc a different field with the LegacyID from this PopupInfo. Is there a problem with this string that is causing the index errors? The lengths at both ends are never the same so I can't trim off the ends. Thanks for the help! Tim

‎09-11-2020

Has there been any update on this? The beta dashboard popups seem to be handling the formatting like line breaks better than the regular ones but are still reporting undefined for attribute expressions.

‎09-10-2020

Hey Xander, Another followup question for you regarding the related records. How would I access another field from that row in the related record? I would still want to reference the row with the max date but would want to grab a name field associated with that record instead. Thanks! Tim

‎09-08-2020

That worked! Thank you! I used this to set up a months since last submission which looks like this: // first read out the ID of the Feature1 var id = $feature.STATE_NAME; // access the table Feature2 var tbl = FeatureSetByName($map, 'Registration Submissions'); // create a sql expression to query on ID var sql = "STATE_NAME = '" + ID + "'"; // filter the table using the sql expression var related_data = Filter(tbl, sql); // validate if you have any related records if (Count(related_data)>0) { // get the max date and format the result var maxepoch = Max(tbl, 'SubmissionDate'); var maxdate = Date(maxepoch); var endDate = Now(); var diff = DateDiff(endDate,maxdate,'months'); var age = Round(diff,0) return age } else { // in case you don't have related records // define what to return return "No Previous Submissions"; } That all look correct? Another related question, is there a way to symbolize the polygons by this length since last submission? I thought I saw that the FeatureSetByName function isn't available for the symbology custom expression. Thanks again, Tim

‎09-08-2020

What would be the best way to reformat the months to go from 0-11 and not 1-12? Is that something I need to set in ArcMap or Pro before publishing the feature service?

‎09-08-2020

Hey Xander, Thanks for getting back so quick. I tried that out and got an error that says, " Execution Error: unable to find a number expression in pattern: MM/DD/Y". I was able to set up another one that worked but it seems to be returning the wrong date. The related record has a date of 9/8/2020 but the expression is returning 8/8/2020. I tried it with a few others and it seemed to always be off by a month. This was the code: // first read out the ID of the Feature1 var id = $feature.STATE_NAME; // access the table Feature2 var tbl = FeatureSetByName($map, 'Registration Submissions'); // create a sql expression to query on ID var sql = "STATE_NAME = '" + ID + "'"; // filter the table using the sql expression var related_data = Filter(tbl, sql); // initiate a variable to hold the result var result = Max(tbl, 'SubmissionDate'); var relateddate = Date(result) var formatteddate= Month(relateddate)+"/"+Day(relateddate)+"/"+Year(relateddate) // return the result return formatteddate; I'm guessing it's something to do with one of the Date functions. If I have it return 'result', it gives me the number 1599609600000. I checked this on epochconverter.com and it came back as 9/8/2020 at 9:40:47 PM GMT. I tried returning relateddate and that came back as 08 Sep 2020 08:00:00 pm so the date is correct at that point but gets skewed by the Month() function. Any idea of what might be throwing it off by a month? Is there another way instead of the Month, Day, and Year function to format the date? Thanks! Tim

‎09-08-2020

Xander Bakker‌ Hi again Xander, I had another question come up relating to this while working through the previous one. I was able to grab the expression from one of your other posts but am having a hard time getting the date in the format I need. I currently have this working but the date is being returned as "1599177600000": // first read out the ID of the Feature1 var id = $feature.STATE_NAME; // access the table Feature2 var tbl = FeatureSetByName($map, 'Registration Submissions'); // create a sql expression to query on ID var sql = "STATE_NAME = '" + ID + "'"; // filter the table using the sql expression var related_data = Filter(tbl, sql); // initiate a variable to hold the result var result = Max(tbl, 'SubmissionDate'); // return the result return result; I tried to reformat using the date functions but am getting "NaN/Nan/Nan" as the string using this: // first read out the ID of the Feature1 var id = $feature.STATE_NAME; // access the table Feature2 var tbl = FeatureSetByName($map, 'Registration Submissions'); // create a sql expression to query on ID var sql = "STATE_NAME = '" + ID + "'"; // filter the table using the sql expression var related_data = Filter(tbl, sql); // initiate a variable to hold the result var result = Max(tbl, 'SubmissionDate'); var relateddate = Month(result)+"/"+Day(result)+"/"+Year(result) // return the result return relateddate; Is there another way I can get the date in a MM/DD/YYYY format from 'result'? Thanks! Tim

‎09-08-2020

Hi Xander, Would this expression work with a related table? We would be trying to track time since last submission. We have a feature service with a polygon of every state and a related table with all submissions an their dates. Could we use this FeatureSetByName function to call the related table, filter for the max date to find the most recent one for a particular state, and then use the DateDiff to compare against Now()? Thanks! Tim

Online Status	Offline
Date Last Visited	Wednesday

My Ideas

Latest Contributions by TimothyWoodfield

Re: Using the .split() to grab attribute from KMZ

Re: Using the .split() to grab attribute from KMZ

Using the .split() to grab attribute from KMZ

Re: Arcade expressions undefined in Details

Re: ArcGIS Arcade DateDiff

Re: ArcGIS Arcade DateDiff

Re: ArcGIS Arcade DateDiff

Re: ArcGIS Arcade DateDiff

Re: ArcGIS Arcade DateDiff

Re: ArcGIS Arcade DateDiff