Latest Contributions by DavidPike

https://doc.arcgis.com/en/survey123/browser/create-surveys/webdesigneressentials.htm#ESRI_SECTION1_21723D9039E847AF9E69867C802C695A ... View more

Possibly https://pro.arcgis.com/en/pro-app/latest/tool-reference/spatial-analyst/zonal-statistics-as-table.htm just choose any statistic, as you really just need the COUNT value. Assuming your polygons are all the same size - the COUNT values will be very similar, but probably not identical unless polygons are perfectly aligned with the raster cells.  just sort the table by COUNT and you'll likely see the polygon OIDs that have missing data (i.e. less cell count). If polygons not the same size - possibly calculate the area of your polygons and compare it to the combined area of the raster cells within the polygon (cell size * COUNT).  Apply the same logic as previously. Maybe better ways. ... View more

Just set the Output Location parameter to the Geodatabase location? ... View more

What's the issue you're experiencing? Bit reluctant with zipfiles, so if you can share a screenshot if possible also. ... View more

Where are you saving them to initially and what location is the broken source referencing? ... View more

That's  very interesting.  Seems like a serialisation quirk.   ... View more

yeh it seems more of a data wrangling exercise in Excel after the entire attribute table is exported.   ... View more

Can you share what the data looks like i.e. how to group by floor (spatial or attribute based selection criteria etc.) What do you mean by 'split' i.e. what's the exact intended outcome?   For write table to CSV - what does this look like?  A table with all the ObjectIDs and attributes for features in each floor?   ... View more

I think you're missing the searchType Parameter which is confusing the rest of the Parameters. How the search copes with multiple tags to narrow-down and multi choice list I'm not sure. possibly:   #per help doc hyperlinked example #supported search types are contains, startswith, #endswith, and matches #search('csvName', 'matches', 'breed', ${DogQuestion}) #your appearance search('t', 'contains', 'label', ${filterTags})   You may also just want to instead have a type 'select_multiple_from file t.csv' and set the appearance to minimal 'autocomplete' instead and do away with the tags question. https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformsappearance.htm#ESRI_SECTION1_46A700D2AABF47F1AE4D5004762DB372   Parameter Description searchType Controls what type of search is performed, and accepts different values depending on whether the table being searched is a spatial table within a feature layer or a nonspatial table in a CSV or feature table. For spatial tables, the accepted search types are intersects, contains, crosses, envelope_intersects, index_intercepts, overlaps, touches, and within. To learn more, see Spatial relationships. For a nonspatial table, the supported search types are contains, startswith, endswith, and matches. searchColumn Determines the column that will be searched for the text in the searchText parameter. These columns are taken from the table itself. In addition, a spatial table in a feature layer can search the columns @geopoint, @geotrace, and @geoshape. searchText Contains the text that will be searched for and returned in the searchColumn parameter. ... View more

I think you need to specify an alias for the toolbox on the fly, or set the alias beforehand in the tbx. https://learn.finaldraftmapping.com/how-to-use-custom-tools-in-a-python-script-with-arcpy/   import arcpy aprx = arcpy.mp.ArcGISProject("CURRENT") #import toolbox with alias 'default_toolbox' arcpy.ImportToolbox(aprx.defaultToolbox, 'default_toolbox') #run SE4() arcpy.default_toolbox.SE4Polygons()     ... View more

Maybe another way is shown here, Solved: Calculate time between two date-times using a date... - Esri Community and broken down into more bite-sized chunks:     #Considering your dates are epoch times, they represent the #number of seconds #since 1970. #Esri use milliseconds. so: #ms_diff is the milliseconds (ms) between the two dates. ms_diff = ${endtime} - ${starttime} #there are 60,00 ms in a minute, #3,600,000 ms in an hour. decimal_hours = ${ms_diff} div 3600000 #round down using int rounded_hours = int(${decimal_hours}) decimal_mins = ${ms_diff} div 60000 #round down using int rounded_mins = int(${decimal_mins}) # rounded_mins is your total minutes difference between #the two datetimes, # if you use it alongside hours, you need to subtract #the rounded hours*60 to get the minutes remainder. #or take the modulus as below: modulo_mins = ${rounded_mins} mod 60 #H, M padding and logic to pad a 0 if Hrs <10 times = if(${rounded_hours} < 10, '0' + ${rounded_hours}, ${rounded_hours}) + 'H:' + if(${modulo_mins} < 10, '0' + ${modulo_mins}, ${modulo_mins}) + 'M' #I'd set all to visible to see what's going on and trial a few time #differences in the app, then set appearance field to 'hidden' as needed #after.     type name label readonly calculation dateTime starttime starttime     dateTime endtime endtime     decimal ms_diff ms_diff yes ${endtime} - ${starttime} decimal decimal_hours decimal_hours yes ${ms_diff} div 3600000 integer rounded_hours rounded_hours yes int(${decimal_hours}) decimal decimal_mins decimal_mins yes ${ms_diff} div 60000 integer rounded_mins rounded_mins yes int(${decimal_mins}) integer modulo_mins modulo_mins yes ${rounded_mins} mod 60 text times times yes if(${rounded_hours} < 10, '0' + ${rounded_hours}, ${rounded_hours}) + 'H:' + if(${modulo_mins} < 10, '0' + ${modulo_mins}, ${modulo_mins}) + 'M'     ... View more

Same for hidden group members please. ... View more