Latest Contributions by Mondi_GIS

‎07-17-2020

I just figured it out. I had to try several different ways, but this eventually worked for me if(${q2_1_1_height} >= 0 and ${q2_1_1_height} < 25, 1, if(${q2_1_1_height} >= 25 and ${q2_1_1_height} <= 45, 0, 1)) Thanks for the help

‎07-17-2020

Hello all I have a calculation that i need to do where I ask field workers to measure the height of seedlings. I have created a decimal field where they input their height in cm's. In the next line i have a hidden field where I now want to calculate whether the seedlings are between 25-45cm. If the height falls inside this range, they should get a 0 value, and if they are outside they should get a value of 1. I have used this if statement, but it doesn't seem to return the rigt value. It seems just to give me a zero. if(${q2_1_2_height}>=25, 0,(if(${q2_1_2_height} <=45, 0, 1))) I have other criteria that are just Yes/No answers, where the yes gets a zero and No a 1. I then add them all up to get a Pass/Fail according to certain criteria. This is the reason why i want to convert the height values to a zero or 1 as well so that i can sum them with the other questions Please could I get some help Thanks

‎07-16-2020

We are trying to publish a vector tile package to a map on Survey123 (using Connect version 3.9.12). We are publishing to Arcgis Enterprise 10.6.1. It publishes successful but we keep getting an error when downloading the survey saying "error unpacking". The survey is only 12mb when published, and the raw vtpk is 16mb.

‎03-06-2020

Hi Doug, I have many sum(repeat)s in my survey that work fine. The challenge here is not summing the repeat, the challenge is using the average of the repeats to validate the if statement inside the repeat.

‎03-04-2020

I have a survey where I am capturing the height of trees in a repeat, and then later on in the survey, I calculate the average height of these trees and then the values for 20% above the mean, and 20% below the mean. Now I need to do a count of the number of trees that are more or less than 20% above/below the mean. Is this at all possible? I have tried using the logic of if(${height} > ${top_from_mean}, '1', if(${height} < ${lower_from_mean},'1', '0')) inside the repeat, but this seems to write a static value to the field in the order that the data is captured, rather than a dynamic value that calculates as the average and top_from_mean values update. If I put that calc outside of the repeat it won't do the calc on the individual values and I won't get a count. Any suggestions? Would it be easier to do this in Arcade on the data after it is submitted? We did want to present the results as the survey is completed to pass/fail the sample plot.

‎03-04-2020

Hi Ismael, So I changed my settings to exactly what you have their, and now it is working (but now I have to suffer through American spelling in all my other documents. So, firstly, these were the settings that I had: So, it would seem that somewhere Survey123 is ignoring the fact that we changed the default South Africa setting (which is is a comma decimal separator) to a point. Then, we made the same changes to my colleague's pc, but he did not have the US language pack installed, and so the changes did not work. t.

‎02-27-2020

We are struggling with Survey123connect and the Survey123 app adding a comma as the decimal separator to decimal fields when it calculates a value or pulls it through from another field. My PC regional settings are set to US (originally South Africa, but I changed these in case it made a difference). My separator for decimals and currency is set to a decimal point. Excel is set to use a point as the decimal separator too. When I type into Survey123 decimal field it allows the decimal point: When it has calculated the field it uses a comma, and gives an error: When I have a calculated field using the first example, the calculation does not work and returns a null when I have a decimal point in place. It is expecting a comma. It does not allow me to enter a comma however, as the decimal separator is a point. It works on the web app, but we need this to work on mobile/offline. Changing all users regional settings to comma is not an option.

‎11-26-2019

I have a calculation that I would like to do on figures that I am entering into a repeat function. What I am trying to do is a survey that lets you measure the diameter of logs left in several 50m X 50m plots (hence the repeat for plots). In each plot, there will be several trees that need to be measured at two points on the log (hence the repeat for the logs). So, for each pair of calculations for the log, I need to multiply by the power of 2, and then do the same for each subsequent log repeat. These all need to be added up into a total at the end of all the log repeats. I then move onto the next plot and do the same. The calculations should be the same for the trees in this plot as well, and then added to the total of the first plot. This will continue until all trees in each plot have been captured. The problem that I am having is that I have a nested repeat for the plots and trees within. I have the formula that I need to do the exponent calculations. It is pow(${lg1},2) + pow(${lg2},2). lg1 and lg2 are the two diameters that need to be captured for each tree. When i use this formula, it will calculate the correct result, but as soon as I move onto the next repeat....it disappears. How do i retain this value, and add it onto the values from the next trees results. I am probably explaining myself really badly, but i will link the original spreadsheet I am trying to emulate as well as the survey I am working on. Thanks for the help Paul

‎10-30-2019

James Tedrick‌, We are experiencing a similar issue on Android and Windows devices. We have a form which has nested repeats which auto-increment up to a specified/calculated number of repeats based on earlier field (area in ha). This form works well when using it normally, but we have picked up that when you save it as a draft or close Survey123 and recover the incomplete survey the unpopulated repeats lose their calculations and validation, and you can’t scroll to the rest of the incomplete repeats. So, for example, I am completing a survey which has auto-incremented up to 5 repeats. I complete repeat 1 & 2, and accidentally close my app. When I reopen the app, I can scroll to repeat 3, but the calculations and field validation is missing. I cannot proceed beyond repeat 3 to repeats 4 & 5.

‎10-19-2018

Hi everyone. I am getting something strange. I have upgraded to ArcMap 10.6.1 and use a SDE running on a SQL database. Our GIS department uses local SQLExpress instances to create databases locally for replicas that we can edit and synchronize back to the SDE. When we add any feature classes from either the SDE or our local replica, we get an error that states "Error exporting data. open featureclass failed". The funny thing is that when we select all the records and then try export, everything exports fine!! Weird! Also, when we try do the export from Catalog it also works fine Does anyone have any ideas?

‎08-14-2015

Hi Dan, tch! So simple :-(. Thanks so much, you have halved the complexity of my model.

‎08-14-2015

Hi Jake, Thanks for your reply. The raster values were decimetres contained in an integer type field (GRID_CODE). I needed to convert these decimetre values to metres by dividing by 10. When I used the python formula !GRIDE_CODE! / 10, the result was a integer type, i.e. 53 became 5, instead of the 5.3 result I required. I had a look at the code snippet you included, but have not been able to make it work in the FIELD CALCULATOR. How would it look like in the Field Calculator? I am afraid my Python skills are very thin as I am just starting down that road! Thanks again.

‎08-14-2015

I extracted point data from a raster, using the GRID_CODE value from the raster data. This creates an integer field in the vector output. I needed to use this output in a division calculation but the answer had to be as a field type DOUBLE (i.e. I needed a decimal value). When doing this in a model using the CALCULATE FIELD tool, with the PYTHON syntax option, it would only produce an Integer value. Apparently this is a PYTHON limitation, judging by the Google search I ran on this issue. I did a work-around by creating a temporary DOUBLE field, copied the GRID_CODE value to it and then ran the CALCULATE FIELD division operation. I then deleted the temporary field. This works ok but is very cumbersome. Is there a smart way to set the PYTHON code so that it will divide an integer and produce a decimal output? The CALCULATE FIELD tool, with the VB syntax option, works fine, but VB is not supported in ArcGIS Pro 64Bit so I can foresee problems in using VB in the near future? Thanks very much.

‎01-07-2015

Hi Scott, Thanks very much for your reply to my query regarding a Model Builder calculation. The first GP model actually creates an output table with the required fields so there is a table to be read. What I am not sure of is how to get the CALCULATE FIELD operation that is in the second, separate GP model to read this table and include one of the fields of the first GP model output in it’s expression? If I try and connect the output table to the CALCULATE FIELD Operator it only sees it as a precondition but does not read the actual table. Any ideas on this? Thanks again. Kind regards, Mark Mark Norris-Rogers GIS/Remote Sensing Specialist South Africa Division Mondi Mondi House 380 Old Howick Rd, HILTON 3245 P.O. Box 39, Pietermaritzburg 3200, KZN, South Africa Tel.: (+27) 033 329 5362 email: [email protected]<mailto:[email protected]> www.mondigroup.com<http://www.mondigroup.com/> Mondi Limited 1967/013038/06

‎12-30-2014

I need to use the results of a geoprocessing workflow in a separate GP workflow calculation. I ran a TABLE_SELECT to create a table containing the required input values from the first GP model (top line of image below). I then wanted to use the GET_FIELD_VALUE function to extract the required value from the table and use this value in the CALCULATE_FIELD function of the second GP model (second line of image below). However, it does not "see" the field to be able include it in the calculation expression. I cannot find a way to do this this. Any ideas? Thanks very much.

Online Status	Offline
Date Last Visited	18 hours ago

My Ideas

Latest Contributions by Mondi_GIS

Re: How to use an IF statement with a number range

How to use an IF statement with a number range

Error unpacking on Survey123

Re: CountIf equivalent for Survey123

CountIf equivalent for Survey123

Re: Survey123 adding a comma to calculated decimal fields

Survey123 adding a comma to calculated decimal fields

Using the pow(value,power) function in nested repeats

Re: Calculate field not working properly after saving a draft

Error exporting data from SDE or SQLExpress replica

Re: Dividing Integers to create field type :DOUBLE output using Python

Re: Dividing Integers to create field type :DOUBLE output using Python

Dividing Integers to create field type :DOUBLE output using Python

Re: Adding an external field value in a Model Builder calculation

Adding an external field value in a Model Builder calculation

Re: Should Append tool perform Update and Add at t...

CalculationMode inside nested repeat

Re: CalculationMode inside nested repeat

Re: ArcGIS Field Maps: Offline Edits Fail to Sync ...

Calculation Mode Auto not working as expected afte...