Latest Contributions by GavinWepener

‎07-28-2020

Good morning Zachary My issue was resolved by ESRI South Africa. When publishing a feature service from a layer hosted in SQL, it does not create a related table. Thus repeats does not work. So instead of having one repeat to capture several photos, you need to have several questions capturing one photo / attachment at a time. image photo1 Photo1 image photo2 Photo2

‎07-28-2020

Hi Zachary Thanks for this, but I suspect my issue is how I publish my feature service. When I publish a feature class that resides in SQL, to a feature service on my portal, the related table goes to my map service and not to my feature service. How do I publish / set up my feature class in order for the related table to go to the feature service and not to the map service? Thanks Gavin

‎07-21-2020

I am having issues getting the repeats going for attachments on a feature service published with data that resides in a SQL database. If I do not use repeats, the survey works 100%, but using repeats I do not know to which related table I need to point the repeat. My schema in Survey123 looks this. How I try to do the repeat and the error that I get when I try to publish the survey. How do I set up the repeats if my feature service is not hosted but uses data from SQL? Thanks Gavin

‎04-14-2020

Hi Xander Bakker‌ I managed to figure out the problem and it was not the arcade expression. My data is in a projected coordinated system, if I use one of the ESRI base maps, the expression works. If I use my own base map that is in the same projected coordinate system, the expression crashes. I assume it has to do with how ArcGIS calculates distance in a web map. (The expression works 100% in ArcGIS Pro.) Thanks for the help. Regards, Gavin

‎04-08-2020

Good morning Xander Bakker Thanks for the help, unfortunately when I run the script you gave, I just get a run time error. I ran the different functions separately to make sure they each work and that I get geometry out and not a feature set. But everything checks out, but still the run time error. Where do I look for the issue? Could it be my data? Regards, Gavin

‎04-08-2020

Good morning all I am trying to calculate the distance between points in two different feature layers using Arcade. Using FeatureSetById I can pull the data for the related feature layer, but how do I use the geometry of the related feature in the arcade Distance function? Please help, I cannot find any documentation on how to do this. Thanks Gavin //First read out the unique id of current feature var A1 = $feature.holenumber //Access the second feature var A2 = FeatureSetById($map, /* Designed_drilling */ "Designed_drilling_3788", ['holenumber'], true) //create sql expression var A3 = "holenumber = '" + A1 + "'" // filter the second feature using the sql expression var A4 = Filter(A2, A3) return A4 //Distance($feature, $A4, 'meters')

‎09-29-2013

Thanks Mark! Your solution work 100% first time around.

‎09-27-2013

The shapefile and file geodatabse formats works 100% when using the Data extract widget in ArcGIS Viewer for Flex 3.4. However when I try to extract the same feature in any of the default CAD formats, the output zip file is just empty. No errors, just empty. Any ideas as to what I am doing wrong? Regards, Gavin

Online Status	Offline
Date Last Visited	‎10-23-2025 02:39 AM

My Ideas

Latest Contributions by GavinWepener

Re: Repeats from a SQL hosted feature service

Re: Repeats from a SQL hosted feature service

Repeats from a SQL hosted feature service

Re: How to use the geometry of a related record in Arcade

Re: How to use the geometry of a related record in Arcade

How to use the geometry of a related record in Arcade

Re: Data extract tool - ArcGIS Server 10.2

Data extract tool - ArcGIS Server 10.2

Re: How to use the geometry of a related record in...