Latest Contributions by PaulSweeney3

‎09-23-2020

Hi james Can I add you to a group or is there another way I can share it with you. I d rather not post it here Thanks

‎09-22-2020

Hi All I have an xls form that uses choice filters across a number of section lists. Just recently i have been met with this error "The same instance id will be generated for different external instance source URLs. Please check form. Instance name 'Machinery', Existing type: 'pulldata', Existing URL: 'jr://file-csv/Machinery.csv', Duplicate type: 'choice', Duplicate URL: 'None', Duplicate context: 'survey'" the strange thing is if i remove the choice filter the form loads fine. the csv it references in the error was previously included in the form but it was removed and is no longer in use. there are other pulldata csv in the form. Has anyone come across this error before?James Tedrick‌ perhaps you may know something abut this error? Regards Paul

‎09-22-2020

HI Xander Bakker‌ Thanks xander i might post the question in the early adopter site if it hasn't already been asked. in relation to the model option I have set about creating the model on ArcGIS Pro and i have run into an issue wiithon of my expressions. Which totals the number of unique sections intersecting a polygon based on shape length. var portal = Portal('https://www.arcgis.com'); // get the ug Duct feature set: var sql = "(surface_ty = '" + "1" + "')"+" AND "+"(status = '" + 1 +"')"; var Ducts = Intersects($feature,filter(FeatureSetByPortalItem(portal, 'xxxxxxxxxxx', 0),sql)); var groupSections = GroupBy(Ducts,['Shape__Length'],[{ name: 'outputStatName', expression: '1', statistic: 'COUNT' }]); // count the overlapping lines var cnt = Count(groupSections); return cnt Using calculate field the expression validates ok but it will not run it fails with the error. 002717: Invalid Arcade expression—ArcGIS Pro | Documentation with no real description of why it is failing As a solution i found if i use the distinct function instead of grouby it works and returns the desired output but i was wondering if this is a bug or is groupby not available to use in Arcgis pro ?

‎09-16-2020

Hi Erica Tefft‌ I hope I've understood you correctly but I would have thought you would use if statements on different fields within the repeat first then use sum outside the repeat. You mentioned 31 values which can be selected at any time in any field so you would need 31x3 checks with in the repeat then a total sum out side. Eg Inside repeat for each code Field 1 = if cmr_violations 1 = 2a1 , violations1,0 Field 2= if cmr_violations 1 = 2a1 , violations1,0 Field 3 = if cmr_violations 1 = 2a1 , violations1,0 Outside repeat Sum (field1)+Sum (field2)+Sum (field3) Would this work for you ?

‎09-15-2020

Hi Xander Bakker‌ Thanks for your response that blog link is useful I can just about figure out what's happening I ll give it a shot and try, if i am really stuck I may ask for your help . A couple of additional points I had hope to use collector and pass values to survey123 however I realised featureset s were not supported. I am now calculating the fields first to pass them through.i am setting up a model in pro to do this but I was wondering if arcade expressions ,specifically using featuresetbyportalitem , are achievable using the python Api and would it be a faster method then model builder to run. Do you know if collector or the new field maps app will support featuresets anytime soon? Thanks

‎09-15-2020

Hi James Tedrick‌ Thanks that appears to be working now. I updated the referer to the form url in option 1 above and it seems to be opening correctly now. In relation to the redirect uris for the second option I did nt try that yet but when I do I will try to provide an update.

‎09-11-2020

Hi James I am using the following for the generate token username=xxxxxx password=xxxxxxx f=pjson referer=https://www.arcgis.com for the oath2 option i used the following client_id Client_secret grant_type client_credentials the token generates successfully for both and passes to the url i also have it working successfully in other scenarios to add features and update layers so i am pretty sure its the right way of doing it.

‎09-10-2020

Hi Lynsey I am trying to access a web form which was created on survey123 connect. I generate the token in integromat using the HTTP module and the rest API to generate a token , then i generate an email with the following link embedded. https://survey123.arcgis.com/share/xxxxxxxxxxxxxxxxx?mode=edit&globalId=xxxxxxxxx&token=xxxxxxxxx i have tried it with the oath2 method using the client id and secret and it seems to open up the web form form for a second but it closes it straight away and i am met with the error message "The survey does not exist or is not accessible" i then tried it using this method Generate Token—ArcGIS REST API | ArcGIS for Developers and it links to survey123 but the page just constantly refreshes

‎09-10-2020

Hi Xander Bakker‌ Thanks for getting back. In relation to the sql yes i think the reason it was like that is because i considered using variables at the start and then it changed, it was just easier for me to change it to a number. The number relates to a surface type. Your suggestion is much neater however. I probably did not explain myself fully the first time , the label where i take the last two letters may vary over the polygon so for example you may have 6 polylines in total intersecting the polygon 4 of these maybe overlapping polylines with the same label number and 2 may be another set of overlapping polylines with a different label with different lengths and different surfaces see example below. What i would like to show is the distance in grass total and the distance in footpath total for example. orig label New Label Length Surface 123456/28 123456 1.5 grass 123456/29 123456 1.5 grass 123456/30 123456 1.5 grass 123456/31 123456 1.5 grass 123456/32 123456 1.5 grass 678910/45 678910 3 footpath 678910/46 678910 3 footpath 599910/48 599910 5 grass 599910/49 599910 5 grass Total length 23.5 Total trenches 3 Distance in grass 11.5 Distance in footpath 3 ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ i tired to combine them originally but i couldn't figure out how to iterate through the polyline feature and group the various distinct labels and sum them by surface.

‎09-10-2020

I have a polygon layer and a polyline layer for the polyline layer i am able to count the distinct features using the following arcade expression. The distinct values are found by removing the last two numbers of the string Var textlenght =COUNT(TEXT($feature["label"])) Var label = textlenght-2 var stringleft = Left($feature["label"], label) var sql = "label LIKE '%" + stringleft+"%'" var Filt = filter($layer,sql) return count(Filt)‍‍‍‍‍‍ For the polygon layer i am able to get the total length of those polyline s in my first layer that intersect it using the following expression // get the ug Duct feature set: var sql = "(surface_ty = '" + 2 + "'"+" OR "+"surface_ty = ' " +3+ "'"+" OR "+"surface_ty = ' " +4+ "'"+" OR "+"surface_ty = ' " +5+ "'"+" OR "+"surface_ty = ' " +6+ "'"+" OR "+"surface_ty = ' " +7+ "')"+" AND "+"(status = '" + 1 + "'"+" OR "+"status = ' " +3+ "')" var lines = filter(FeatureSetByName($map,"LLD_Fibre_Duct_TLI"),sql) // polylines that intersect with the polygon var relevantlines = Intersects($feature, lines); var cnt = Count(relevantlines); var totlengthUG = 0; if (cnt > 0) { for (var line in relevantlines) { var lineint = Intersection(line, $feature); totlengthUG += LengthGeodetic(lineint, 'm'); } } return round(totlengthUG,2)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ my problem is the the polylines are overlapping and each polyline represents a duct in a trench. I want to be able to combine the two functions and divide the total length by the count of distinct polylines in order to get the trench length . I guess i would have to iterate through the feature set of the label field in the polyline and replace the values ,then sum them into an array where i can count the new distinct values i just cant figure out how to get this iteration to work. Xander Bakker‌ perhaps you can help ?

‎09-09-2020

Hi Phil thanks , i have already raised a case with ESRI support. Regards Paul

‎09-09-2020

Hi Philip Wilson‌ We have carried out a factory reset and installed all OS updates ect on a Samsung galaxy A20ea and still no joy with the camera.

‎09-09-2020

Hi Spatial Services I think the connection only allows you to see your own content , i could be wrong. but in relation to the list Are you saying you can only see the first 100 or so surveys in you account sorted alphabetically? i raised a ticket with integromat support but i have yet to hear back

‎09-05-2020

Hi All Can someone explain how the token parameter can be used to access secure surveys . My understanding is you can generate the token and use it to bypass the login screen but it does nt seem to work for me Integrate with other apps—ArcGIS Survey123 | Documentation

‎09-02-2020

Hi Philip mine is an Samsung galaxy A20e running android 10 and this issue is present across numerous similar devices in my org. I ll see if IT has a spare phone I can test with .

Online Status	Online
Date Last Visited	23 hours ago

My Ideas

Latest Contributions by PaulSweeney3

Re: Survey123 Instance id error with Choice filter present

Survey123 Instance id error with Choice filter present

Re: Arcade Count intersecting polyline features by distinct value in field

Re: Survey123 Tricks of the Trade: Repeats

Re: Arcade Count intersecting polyline features by distinct value in field

Re: Using the token parameter in survey123

Re: Using the token parameter in survey123

Re: Using the token parameter in survey123

Re: Arcade Count intersecting polyline features by distinct value in field

Arcade Count intersecting polyline features by distinct value in field

Re: Survey123 Camera will not switch from selfie to rear view

Re: Survey123 Camera will not switch from selfie to rear view

Re: Survey123 Tricks of the Trade: Integromat

Using the token parameter in survey123

Re: Survey123 Camera will not switch from selfie to rear view

Re: Connot create a row of size X which is greater...

Re: Connot create a row of size X which is greater...

Re: Publicly accessible view layer from a Survey12...

Re: Survey123 Power Automate Notification

Survey 123 form Error: Initializing form... Error:...