Latest Contributions by LindsayRaabe_FPCWA

‎03-10-2021

Hi @DanPatterson . Thanks for the link. I think I had seen that page already and had tried the Extract function earlier but I must have been using it wrong. I tried again just now to make sure before posting, and just as well as I got it to work! (fih_fire_type IN ('WF') And fih_year1 >= (EXTRACT(YEAR FROM CURRENT_DATE())-20)) Or (fih_fire_type = 'PB' And fih_year1 >= (EXTRACT(YEAR FROM CURRENT_DATE())-2)) Formula now returns wildfires within the last 20 years and prescribed burns in the last 2.

‎03-09-2021

I may be wrong, but based on what I read here Include a map in your survey , you can only create a blank map with a customisable Basemap option for collecting locations. If it is possible, it might be using a more advanced design tool (which I know nothing of - my Survey123 experience is not overly in-depth).

‎03-09-2021

Hi Brains Trust. I'm trying to build a definition query (SQL) that looks a little like this; fih_fire_type IN ('WF') And fih_year1 >= (YEAR(CURRENT_DATE())-20) where fih_year1 is a short integer with a year in it (i.e. 2019, 2020, etc). I want to be able to filter my data by features that have a Year value within the last 20 years. I believe the CURRENT_DATE function works, but it looks like YEAR() isn't available in the definition query SQL window, meaning I can't extract the current Year as an integer. I've tried a few others and keep having the same problem (limited SQL commands available). Any tips on how to make this formula work?

‎03-08-2021

Thanks for the update @NaicongLi. Good to hear it's in the road map.

‎03-07-2021

I find a lot of people in our organisation now use their corporate OneDrive folder for storing their GIS projects, data and outputs. Whilst I know we can add OneDrive as a connection under folders, I think it would be useful if these Cloud locations (i.e. Dropbox, Google Drive, etc) could automatically be made available under the Computer section like your Desktop, Downloads and Documents folders are for easy access.

‎03-04-2021

Hi All. I was going to ask a question, but then figured out the answer and thought I'd share it with the world so that you could all benefit from my hard grey matter work 😉 When creating Dynamic Text (for instance, a Table Attribute Value), the type of element created can be influenced and can impact on the behaviour of the text box created. I was having trouble creating a dynamic text element that I could resize, but found that the aspect ratio was locked and no matter what, it would just get bigger and smaller and showed all values returned (Straight Text element). What I wanted was to have a text box of a set size that would only show the 1st value returned (not many). The problem was that when I created the Dynamic Text element, it was defaulting to the "Straight Text" graphic option (shown below in red) which will automatically show all text present in the element and resize to suit with the aspect ratio unable to be modified. What I actually wanted was for it to create the Dynamic Text box as a "Rectangle Text" element. To do this, ensure you click on the Rectangle Text button first (blue box), then click the Insert Dynamic Text option and create the element. This will result in a text box being created that allows you to change the size in any direction, and won't have the Aspect Ratio permanently locked. I hope someone finds this useful!

‎03-03-2021

If you want the border to match your map frame, then best to use the map frame border symbology to get what you want (you can offset lines like in my below demo). If you want it separate to your map frame, then a rectangle graphic is the simplest I can imagine.

‎03-03-2021

There's that option too. I usually like these sorts of elements at the bottom anyway - out of the way when looking for the things that are likely to need editing.

‎03-03-2021

To insert a simple border graphic around the whole layout (page), use the Insert > Graphics and Text option, selecting Rectangle. Once you've drawn it, you can change the properties to make it hollow (No Fill) and the outline to suit your border requirements. Once you've drawn your rectangle, I'd suggest making sure it's at the bottom of the Drawing Order list in the Table of Contents (under all your other elements and map frames) so you're not constantly selecting it when clicking on the layout.

‎03-03-2021

I don't have a specific use case for this, but I can imagine a few that would be handy. In a forestry setting, forest inventory or post fire assessments with 360 images could be a handy tool.

‎03-03-2021

Hi Todd. Yes, I was a copy/paste of the .aprx using the windows OS tools. Thanks for the tips. I have come to understand the links that these projects have to default/home databases and folders, and how these are maintained when you move/copy a project, but would have thought that data sources to other locations entirely shouldn't be affected. If this is not the case, then surely thats something that should be on the improvement pathway. If it is an acceptable file path in the first instance, it should be honoured and maintained through basic OS functions like copy/paste. At least for now the fix is easy and I'll keep your tips in mind for future, similar duplications. Maybe opening and going Save As would be the better option.

‎03-02-2021

Hi All. I've come across this a couple of times now and was hoping to find out if others have experienced it too. The below screenshots show the data source of a layer before and after copying an ArcGIS Pro project from one folder to another (project already existed in a folder and we saved a copy to make changes to without affecting the original). Before; After; This didn't affect just one layer, but many layers referencing the same folder structure ("External" folder). When we opened the new project, all the layers were broken as the data doesn't exist at this pathway. Repairing the data source on one layer fixed it, but I'd like to know why they changed in the first place. The folder the project was copied into was a couple of folders further down from the one displayed in the second screenshot (W:\2020_2021\Custom Map, Data & Report Requests\2021-02-23_DanMaples_NFPostHarvestArcProTemplate\Working Folder).

‎02-24-2021

I'm finding a similar problem with my project. I have a number of layers in a map with labels applied to numerous layers (i.e. road names, lot numbers, etc). I have World Hillshade half way down the list in my table of contents, with Linear Burn blending applied to the Hillshade layer. It was all working as expected, and still exports the layout to PDF correctly, but when I'm viewing the map view or layout view, all the layers above the hillshade have stopped displaying, making editing the map really annoying. As soon as I turn the hillshade off, or just turn the blending back to Normal, then it all works as it should. I'm going to go with (another) bug, but I'll give it until Monday to be taught otherwise. If nobody has any tips for fixing this, I'll log (another) support request and update back here when I get an answer.

‎02-24-2021

Just received this update; "Thank you for your patience as we have investigated this issue. I just wanted to update you on this case. After extensive testing, it does appear that there is an issue with the Distinct function when used in the Table Attributes option for Dynamic Text. We were able to replicate this issue and found that a blank output was returned when applying the Distinct function as outlined in the Esri Community post that you sent through. Because of this, we have lodged a bug on the issue BUG-000137676: Unable to remove duplicates using 'Distinct' Arcade function in Table Attribute Value Dynamic Text in ArcGIS Pro. " Hopefully see a fix in 2.8!

‎02-24-2021

Just received this update; "Thank you for your patience as we have investigated this issue. I just wanted to update you on this case. After extensive testing, it does appear that there is an issue with the Distinct function when used in the Table Attributes option for Dynamic Text. We were able to replicate this issue and found that a blank output was returned when applying the Distinct function as outlined in the Esri Community post that you sent through. Because of this, we have lodged a bug on the issue BUG-000137676: Unable to remove duplicates using 'Distinct' Arcade function in Table Attribute Value Dynamic Text in ArcGIS Pro. " Hopefully see a fix in 2.8!

Online Status	Offline
Date Last Visited	Friday

My Ideas

Latest Contributions by LindsayRaabe_FPCWA

Re: Use Short Integer attribute Year (YYYY) in definition query referencing CURRENT_DATE

Re: Can Survey123 Features Automatically Populate ArcGIS Online Map?

Use Short Integer attribute Year (YYYY) in definition query referencing CURRENT_DATE

Re: Include Cloud Locations (i.e. OneDrive) in "Computer" section of file explorer window

Include Cloud Locations (i.e. OneDrive) in "Computer" section of file explorer window

Tips for creating Table Value dynamic text

Re: How to put a border on a layout (not just the map frame border)

Re: How to put a border on a layout (not just the map frame border)

Re: How to put a border on a layout (not just the map frame border)

Re: Support 360 photos in Field Maps/AGOL

Re: Layer data sources changing when copying an ArcGIS Pro project to a different folder

Layer data sources changing when copying an ArcGIS Pro project to a different folder

Re: Issue with Labels and Annotation Layers Blend

Re: How to remove duplicate values from Dynamic Text (Attribute Value)

Re: Arcade function to show unique values (remove duplicate values)

Re: Roll back the June 2026 update?

Import Contingent Values from CSV

Improve Contingent Value selection and filtering i...

Re: First Thoughts On The June 2026 ArcGIS Online ...

Re: GeoPDFs from Outlook with MDM not opening in F...

Experience Builder Tips and Tricks

ArcGIS Arcade

Esri Forestry Group (EFG)