Latest Contributions by Mondi_GIS

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 ... View more

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.  ... View more

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.  ... View more

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 ... View more

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? ... View more

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. ... View more