Latest Contributions by AnninaRupe1

‎01-22-2024

No luck: I put exactly that in the expression and it's giving me the same response: For those polygons that have both Primary Contact (step3Phone) and Secondary Contact (step7Phone)--that is, they are not Null--the pop-up displays both Primary and Secondary Contact as expected. For those polygons that only have a Primary Contact (step3Phone)--that is, step7Phone is Null--the pop-up displays only a blank line. I have gotten both the Primary and Secondary Contact expressions working individually, so I know it's not something in lines 1-18. I would just like the blank line to disappear if there isn't a Secondary Contact, similar to what happens in lines 7 and 17, where if the second address line is Null it just goes on to the City/State/Zip and doesn't place a blank line in the address block. Appreciate the help...any other suggestions?

‎01-19-2024

Thanks, Johannes. That makes sense, but it seems I'm still doing something wrong. If there are both Primary and Secondary, both "step4Phone" and "step8Phone" displays (as I want). However, if there is just Primary, nothing displays. Any ideas? I feel like there should be an "else" statement, but I tried that and it didn't work. var step1Phone = $feature.prim_phone var step2Phone = FeatureSetByPortalItem(Portal('Removed for Privacy'), 'Removed for Privacy', 0, ['contact_name', 'contact_address1', 'contact_address2', 'contact_city', 'contact_state', 'contact_zip', 'contact_phone', 'contact_email'], false ) var step3Phone = First(Filter(step2Phone, 'contact_phone=@step1Phone')) var step4Phone = Concatenate("Primary Contact Name:" + TextFormatting.NewLine + step3Phone.contact_name + " (" + Proper($feature.prim_contact_type) + ")" + TextFormatting.NewLine + step3Phone.contact_address1 + (IIf(IsEmpty(step3Phone.contact_address2), '', TextFormatting.NewLine + step3Phone.contact_address2)) + TextFormatting.NewLine + step3Phone.contact_city + ", " + step3Phone.contact_state + " " + step3Phone.contact_zip + TextFormatting.NewLine + step3Phone.contact_phone + TextFormatting.NewLine + step3Phone.contact_email) var step5Phone = $feature.sec_phone var step6Phone = FeatureSetByPortalItem(Portal('Removed for Privacy'), 'Removed for Privacy', 0, ['contact_name', 'contact_address1', 'contact_address2', 'contact_city', 'contact_state', 'contact_zip', 'contact_phone', 'contact_email'], false ) var step7Phone = First(Filter(step6Phone, 'contact_phone=@step5Phone')) if(step7Phone==null){return step4Phone} var step8Phone = Concatenate("Secondary Contact Name:" + TextFormatting.NewLine + step7Phone.contact_name + " (" + Proper($feature.sec_contact_type) + ")" + TextFormatting.NewLine + step7Phone.contact_address1 + (IIf(IsEmpty(step7Phone.contact_address2), '', TextFormatting.NewLine + step7Phone.contact_address2)) + TextFormatting.NewLine + step7Phone.contact_city + ", " + step7Phone.contact_state + " " + step7Phone.contact_zip + TextFormatting.NewLine + step7Phone.contact_phone + TextFormatting.NewLine + step7Phone.contact_email) return step4Phone + TextFormatting.NewLine + TextFormatting.NewLine + step8Phone

‎01-19-2024

All, I have been stumped with getting an Arcade expression working! In the end, I would like to have an expression that has a Primary Contact (with address information) and, if present, Secondary Contact (with address information). I have the two working separately, but if there is not a Secondary Contact, it returns a blank line. If there isn't a Secondary Contact I'd like it to just be skipped so there isn't an extra line in the pop-up. Below is my expression. Lines 1-8 are for the Primary Contact, lines 9-16 are the Secondary Contact, and line 17 is where my problem lies. If the expression returns false, it appears correctly. If the expression returns true, however, nothing is written. I've tried too many different things to list here--help is much appreciated! var step1Phone = $feature.prim_phone var step2Phone = FeatureSetByPortalItem(Portal('Removed for Privacy'), 'Removed for Privacy', 0, ['contact_name', 'contact_address1', 'contact_address2', 'contact_city', 'contact_state', 'contact_zip', 'contact_phone', 'contact_email'], false ) var step3Phone = First(Filter(step2Phone, 'contact_phone=@step1Phone')) var step4Phone = Concatenate("Primary Contact Name:" + TextFormatting.NewLine + step3Phone.contact_name + " (" + Proper($feature.prim_contact_type) + ")" + TextFormatting.NewLine + step3Phone.contact_address1 + (IIf(IsEmpty(step3Phone.contact_address2), '', TextFormatting.NewLine + step3Phone.contact_address2)) + TextFormatting.NewLine + step3Phone.contact_city + ", " + step3Phone.contact_state + " " + step3Phone.contact_zip + TextFormatting.NewLine + step3Phone.contact_phone + TextFormatting.NewLine + step3Phone.contact_email) var step5Phone = $feature.sec_phone var step6Phone = FeatureSetByPortalItem(Portal('Removed for Privacy'), 'Removed for Privacy', 0, ['contact_name', 'contact_address1', 'contact_address2', 'contact_city', 'contact_state', 'contact_zip', 'contact_phone', 'contact_email'], false ) var step7Phone = First(Filter(step6Phone, 'contact_phone=@step5Phone')) var step8Phone = Concatenate("Secondary Contact Name:" + TextFormatting.NewLine + step7Phone.contact_name + " (" + Proper($feature.sec_contact_type) + ")" + TextFormatting.NewLine + step7Phone.contact_address1 + (IIf(IsEmpty(step7Phone.contact_address2), '', TextFormatting.NewLine + step7Phone.contact_address2)) + TextFormatting.NewLine + step7Phone.contact_city + ", " + step7Phone.contact_state + " " + step7Phone.contact_zip + TextFormatting.NewLine + step7Phone.contact_phone + TextFormatting.NewLine + step7Phone.contact_email) return IIf(IsEmpty(step7Phone), step4Phone, step4Phone + TextFormatting.NewLine + TextFormatting.NewLine + step8Phone)

‎01-05-2024

Thanks for this solution! Also, in case anyone else is having trouble with this, just copy/paste the code directly into the "Geometry" bar--not the f(x) bar in the Expression window that appears when you click in the "Geometry" bar.

‎01-02-2024

Rylee, thanks for your response! Unfortunately, the three layers/tables need to stay separate as they may not always relate to each other. For example, records in the Outreach Tracking table may not relate to a record in the spatial survey. The purpose of this table is for us to be able to summarize how much/what kind of outreach was done every month. Currently, techs are completing a spreadsheet that contains who they talked to, what kind of outreach it was (phone call, in-person meeting, workshop, etc.), contact information, among other things. Records in this table often aren't referencing a specific piece of land like the spatial survey is, although they can. In the case of the workshop outreach situation, we need to have the record added to the outreach table and also we'd need to add contact information directly to the Landowner Contact table (when the landowner attends the workshop they check in with the tech and the tech adds their information to the contact list). This way, if we end up talking specifically to that landowner about a piece of property late, when we start the landowner survey, the contact information is available and doesn't need to be added again. I've started to play around with the pulldata("@layer") and the link you provided hopefully will help me out--I hadn't found that page before. Let me know if I can expand on more of my workflow or needs; I know it's complicated and I'm not doing a great job of explaining. It's just that there's not one starting point! Annina

‎01-02-2024

Hey all! I'd appreciate any input you have! I have a project where I have three surveys (1 spatial, 2 non-spatial) that need to be connected. I've created a simplified diagram of what I need--see the attached screenshot. Let me explain; I'll start with the spatial survey, but the workflow doesn't necessarily need to start there: My field techs will be filling out a survey when talking to landowners about a specific piece of property (orange square in the screenshot). The techs will either place a point or polygon on a map, enter landowner contact information, and answer other questions about the property. I would like to create the capability for landowner name lookup, so if we've talked with this landowner before we 1) don't have duplicate contact information and 2) can automatically fill in the survey with the contact information. So, this would mean that we need a non-spatial list of landowner names and contact information (blue circle in the screenshot). If, while filling out the spatial survey the tech finds that the landowner hasn't been in contact with us before, the tech fills in the information in the spatial survey, but the landowner information also gets added to the landowner list. In addition, we need the capability of adding landowner information to this list without submitting a spatial survey (this will happen infrequently). Lastly, we need to keep track of all the times we talk to a landowner (green hexagon in the screenshot). We need to have another non-spatial survey that allows the techs to submit a survey when they talk to or meet with a landowner (similar to a call log). This survey needs to have a record completed along with the spatial survey, if a spatial survey is completed. It also needs to be connected to the first non-spatial landowner contact list and have the contact information automatically complete if it's in the list or add the landowner contact information to the landowner list if it's not included already. My plan is to use ExB to create a webpage that have links to the appropriate survey, depending on the situation. So, if a tech is talking to a new landowner about a specific piece of property, they will click on the link to the spatial survey. But if the tech is following up with a landowner who has questions, they will click on the link to fill out the survey for tracking outreach. We need to have this as streamlined and easy as possible because if it's not, it won't be used. I've been doing a lot of research and talking to my colleagues, and we think it's doable, but now need to start building. However, I don't know where I should begin (or even if this is completely doable!). My plans are to use Survey123 Connect and build the tool as though the user will always have internet connectivity. I also have a much more detailed workflow diagram and have created spreadsheets of survey questions, in which I have made sure those questions that are connected have the same properties so they can be referenced across surveys. Any help is much appreciated. Let me know if you need more information or clarification!

‎11-09-2023

@TanuHoque Thanks for replying. I have been following the article (I referenced that in my original post). Turns out, though, the "Dynamic Print Service" toolbox that is attached to the article is different than the tools that are named the same in the "Server Tools" toolbox included with ArcPro. Once I downloaded/used the "Dynamic Print Service" toolbox associated with the article, everything worked. Solved!

‎11-06-2023

I need some help with a custom print template I created. I successfully created and shared a print template for use in WAB, including dynamic text (date printed, sources). However, there is one piece of dynamic text that didn't work: I would like to summarize the acres attribute of a layer visible in the map extent. I've followed the nice tutorial here, but the text where the sum value is blank. I don't know where the issue might be, but I'm wondering about what's in the plain text view of the text element. When I have the layer in the Map frame, the "mapMemberUri" value is populated with a .json string, but as per the instructions, before the layout is exported, the layer needs to be removed. Once that is done, the plain text reads like this: Conserved Acres: <dyn type="table" property="sum" mapFrame="WEBMAP_MAP_FRAME" mapMemberUri="" isDynamic="true" field="activity_acres" decimalPlaces="2" separator="true"/> ac. I don't know where to go from here--any ideas? Thanks! *Update: I modified the link above to reference the correct page I was referring to. Sorry for any confusion.

‎09-19-2023

Very helpful! I thought nesting meant what you explained and I thought that's what was happening in the revised script. But it ended, so it's not considered nested anymore. Woohoo! As for your question: I'm not sure what was meant here; this was the part in the revised script where everyone was talking about loading all the data into memory first, so I thought I'd try it. Obviously it didn't work... Thanks, all. Appreciate the help!

‎09-18-2023

I can't thank you all enough for your insights! @HaydenWelch , your edits all make sense. However, when I tried to implement the edits, there were a couple of issues. There was an "EOL: String literal" error after the HUC10_RSTFile_Path after I changed the path to include the "r" at the beginning and removed the duplicate "\" in the path. I reverted back to the original path, which worked. Any idea why this might have errored? Also, why is the "r" solution better? I really like the "loading whole dataset into memory" idea, although the dataset size isn't as large as what you're working with, so it's not extremely necessary. However, I did try to implement it because, why not? There was an error saying that "row" wasn't defined. I thought I had it straight, but I guess I didn't. Here's what I inserted: with arcpy.da.SearchCursor(Point_Buffer_Output, fields) as cursor: rows = [row for row in rows_to_dict(cursor)] for row in rows_to_dict(cursor): So, I just wrote it singularly (the whole dataset wasn't loaded into memory). Lastly, the Append didn't work. The fields were added but no shapes/data were appended to the feature class. So, to "fix" my script, I modified the sql expression as @AlfredBaldenweck mentioned. It's running now. However, based on all of the feedback, I know it's not clear/efficient/"good" Python, so I'm interested in your thoughts on my questions above. And last question: in the dialogue between @HaydenWelch and @VinceAngelo , you guys talk about not nesting insert and update cursors. But isn't that what was implemented in my script you modified (lines beginning 115 and 129)?

‎09-15-2023

I have a Python script I created after my ModelBuilder model got too clunky and slow, but I'm stuck. I have a point shapefile that I want to buffer then run Zonal Statistics on that buffered point. Following that, I need to run raster calculator, int, and raster to polygon geoprocessing tools so the value output by the Zonal Statistics tool can be copied to another shapefile. There is also another attribute that needs to persist throughout. I've been having trouble with SearchCursor; it isn't iterating. It uses all the features in the input shapefile rather than the one it's on. So, I decided to try selecting the row it's on and exporting to a new shapefile, but I don't know how to include row[] in the SQL expression (I know the one in the code is incorrect). I'd appreciate any help--please be kind, though! I'm learning! I've also included a screen shot of my model that works in ModelBuilder, in case that helps. import sys import arcpy from arcpy.sa import * import math import os arcpy.env.overwriteOutput = False # Check out any necessary licenses. arcpy.CheckOutExtension("spatial") arcpy.CheckOutExtension("ImageAnalyst") arcpy.CheckOutExtension("3D") # Model Environment settings Depression_NHD_Intersect_Layer = "D:\\Projects\\TESTING_Depression_NHD_Intersect.shp" AOI_Raster = "D:\\Projects\\0710000404_DeerCreekDesMoinesRiver.tif" HUC10_RSTFile_Path = "D:\\Projects\\RSTFiles\\" HUC10_SHPFile_Path = "D:\\Projects\\SHPFiles\\" Point_Buffer_Output = HUC10_SHPFile_Path + "Buffer.shp" fields = ['FID', 'DepressFID'] #Create Empty Feature Class FP_Intersections_Elev = arcpy.management.CreateFeatureclass(HUC10_SHPFile_Path, "FP_Intersections_Elev_TEST.shp", "POLYGON", "D:\\Projects\\FP_Intersections_Elev_TEMPLATE.shp", "DISABLED", "DISABLED", "D:\\Projects\\FP_Intersections_Elev_TEMPLATE.shp") #Buffer arcpy.Buffer_analysis(Depression_NHD_Intersect_Layer, Point_Buffer_Output, "3 Meters", "" , "" , "NONE", "" , "PLANAR") with arcpy.da.SearchCursor(Point_Buffer_Output, fields) as cursor: for row in cursor: Make_Feature_Layer = HUC10_SHPFile_Path + str(row[1]) + '.shp' Single_Buffer_Layer = HUC10_SHPFile_Path + "DepressFID_" + str(row[1]) + '.shp' Zonal_Stats_Output = HUC10_RSTFile_Path + "ZoneStats_" + str(row[1]) + '.tif' Raster_Calc_Output = HUC10_RSTFile_Path + "RasterCalc_" + str(row[1]) + '.tif' Int_Output = HUC10_RSTFile_Path + "Int_" + str(row[1]) + '.tif' Raster_to_Poly_Output = HUC10_SHPFile_Path + "NHD_Poly_" + str(row[1]) + '.shp' sql = '"FID" = \'(row[0])\'' #Make Feature Layer arcpy.Select_analysis(Point_Buffer_Output, Single_Buffer_Layer, sql) #Zonal Statistics outZonalStats = ZonalStatistics(Single_Buffer_Layer, "DepressFID", AOI_Raster, "MEAN") outZonalStats.save(Zonal_Stats_Output) #Raster Calculator to prepare to change value to integer outRasCal = RasterCalculator([Zonal_Stats_Output], ["x"], "x*1000000") outRasCal.save(Raster_Calc_Output) #Int (integer) Raster outInt = Int(Raster_Calc_Output) outInt.save(Int_Output) #Raster to Polygon arcpy.conversion.RasterToPolygon(Int_Output, Raster_to_Poly_Output, "NO_SIMPLIFY", "VALUE") #Add Fields to Polygon Layer arcpy.management.AddField(Raster_to_Poly_Output, "DepressFID", "LONG") arcpy.management.AddField(Raster_to_Poly_Output, "gridfloat", "FLOAT") arcpy.management.AddField(Raster_to_Poly_Output, "elevft", "FLOAT") #Calculate New Fields arcpy.management.CalculateField(Raster_to_Poly_Output, "DepressFID", row[1]) arcpy.management.CalculateField(Raster_to_Poly_Output, "gridfloat", "!gridcode!/1000000", "PYTHON3") arcpy.management.CalculateField(Raster_to_Poly_Output, "elevft", "!gridfloat!*3.2808", "PYTHON3") #Append shapefile to FP_Intersections_Elev shapefile arcpy.management.Append(Raster_to_Poly_Output, FP_Intersections_Elev, "TEST", "" , "" , "" , "" , "NOT_UPDATE_GEOMETRY") #Delete Intermediate Files arcpy.management.Delete(Zonal_Stats_Output) arcpy.management.Delete(Raster_Calc_Output) arcpy.management.Delete(Int_Output) arcpy.management.Delete(Raster_to_Poly_Output) print("Completed DepressFID: " + str(row[1])) print("All DepressFIDs Completed!")

‎07-21-2023

Thanks for the information! I did notice in the blog post, though, that using the Esri geocoder consumes credits. I was hoping there was a solution that didn't, as I have the county data available to me already. I think the biggest hurdle is trying to get the coordinates of the centroid of my polygon. Any ideas on how to pull that?

‎07-18-2023

Hello! I've been doing a lot of research this morning on my problem, and I think there's a solution out there but everything I've come across is a little bit different of a situation and I need some help! I have started a survey in Connect. In this survey, the user draws a polygon and answers questions about practices they want to employ in that area. I am using Power Automate to direct the sites to be reviewed by the appropriate person. To utilize this to the fullest extent, I need to have a question about the county the area is in. I currently have it as a question for the user to populate, but I want to make it as automated as possible. I would like a hidden field to be populated with the county name based on the polygon the user draws. I have done this before using a geopoint--that's easy! However, the change to a geoshape makes things a little more tricky. I think the necessary workflow is to first get the centroid of the polygon and then pass those coordinates to another field to get the county name, but I'm not sure. And the things I've tried (e.g. pulldata) haven't worked. Any ideas? I'm open to other workflows, too. @IsmaelChivite

‎05-16-2023

If it only worked like that every time... I had to do the above workflow twice to get it to "stick." Stinks that you have to close out of the map and reopen just to see if it worked. Would be a nice fix on the next update!

‎05-16-2023

I am using the new map viewer for creating web maps and I'm pulling my hair out trying to figure out how to update the default map view; that is, the extent that is zoomed to when the "Home" button is clicked. I've read that this can be done in the "Set Extent" in the web map settings page BUT 1) it's not working and 2) my layers don't appear in that view so I can't know where or how far zoomed in I need to be. This workflow is clunky and results in so much extra work. Sometimes the extent is saved when I save the web map but that doesn't happen every time. Anyone have any insights?

Online Status	Offline
Date Last Visited	yesterday

My Ideas

Latest Contributions by AnninaRupe1

Re: Pop-up Arcade Expression Help, IIf Statement Not Working

Re: Pop-up Arcade Expression Help, IIf Statement Not Working

Pop-up Arcade Expression Help, IIf Statement Not Working

Re: Power Automate to create a record in AGOL FeatureLayer

Re: Survey123: Combine Multiple Surveys

Survey123: Combine Multiple Surveys

Re: Dynamic Text in Custom Print Template

Dynamic Text in Custom Print Template

Re: Select and Create New Layer in SearchCursor

Re: Select and Create New Layer in SearchCursor

Select and Create New Layer in SearchCursor

Re: Survey123: Draw Geoshape and Populate County Name it Intersects

Survey123: Draw Geoshape and Populate County Name it Intersects

Re: Update Default Map View, New Map Viewer

Update Default Map View, New Map Viewer

Re: Field Maps App Immediately Crashes

Re: Field Maps App Immediately Crashes

Re: Field Maps App Immediately Crashes

Re: Field Maps App Immediately Crashes

Re: Map Properties: Clip to an outline: Layer Clip...