Latest Contributions by DavidPike

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

I had a look at the GeoJSON spec and it looks fairly simple.  Same for KML. #GeoJSON { "type": "FeatureCollection", "features": [ { "type": "Feature", "geometry": { "type": "LineString", "coordinates": [ [102.0, 0.0], [103.0, 1.0], [104.0, 0.0], [105.0, 1.0] ] }, "properties": { "prop0": "value0", "prop1": 0.0 } } ] } For GeoJSON could have a python script or powershell or various to populate what is essentially just a list of coordinates in order.  Save it then upload to ArcGIS Online. https://gist.github.com/wavded/1200773?short_path=99c1af9 https://github.com/openlayers/openlayers/blob/main/examples/data/geojson/roads-seoul.geojson?short_path=84daf47 https://developers.google.com/kml/documentation/kml_tut#paths     ... View more

If you don't have access to any desktop GIS, you can likely find an online tool to convert the coordinates into Shapefile, GeoJSON or KML tracks (probably the easiest).  Obviously beware of the data you're sharing and apply common sense if  the website doesn't seem legitimate. ... View more

If you can't find the Survey in the 123 website or the hosted feature layer in ArcGIS Online then it's likely you've republished the survey at some point and made changes which required the hosted feature layer to be recreated (along with the loss of your data - things such as renaming fields and field types etc.). I'd certainly just check through all your content in ArcGIS Online again (also the survey may have changed owner - so someone with admin rights should do a keyword search on organisational content also). ... View more

@BrennanSmith1 that looks perfect.  Just my final recommendations for posterity as I'm sure people will copy your script for future use: # Check if any points were selected # if arcpy.Describe(points_lyr).FIDSet: ### selectlayerByLocation has a derived output for ### number of features selected already. The describe ### operation is quite expensive I think so perhaps this: layer, count = arcpy.management.SelectLayerByLocation(points_lyr, "WITHIN", boundary_lyr, "", "NEW_SELECTION") if int(count)>0: ### may sometimes be issues if boundaries have greater extent ### than the points, resulting in a rectangular clip before reaching ### the boundaries. But this is thinking from ArcMap days, maybe a long ### distant memory in Pro. # Set the extent environment using a feature class #(can also maybe be set outside loop??) arcpy.env.extent = boundary_fc # Create intermediate thiessen polygons temp_fc = r"memory\Thiessen_OID_" + str(oid) arcpy.analysis.CreateThiessenPolygons(points_lyr, temp_fc) ... View more