Latest Contributions by JohannesLindner

So, assuming you have a table like this:   Display the locations right-click the table in the table of contents, "Display XY Data" Choose where you want to save the point feature class, choose the appropriate coordinate fields and your coordinate system, click OK.   Display the view polygons This is a little more complicated. You could probably do that using a combination of geoprocessing tools, but I didn't find an easy one. This is a case where a small Python script gets the job done faster. Open the Python window   Copy/Paste these functions and hit enter twice   def circle_section(x, y, start, end, radius, wkid): """Creates a circle section. x, y: float, coordinates of the center start, end: int, start and end of the section in degrees, Nort=0°, East=90° radius: float, radius of the section wkid: int, well-known id of the coordinate system returns an arcpy.Polygon in the chosen coordinate system """ start = int(start) end = int(end) center = arcpy.Point(x, y) center_geo = arcpy.PointGeometry(center, wkid) angles = range(start, end, 1) if start > end: angles = list(range(start, 360, 1)) + list(range(0, end, 1)) arc_geos = [center_geo.pointFromAngleAndDistance(angle, radius, "PLANAR") for angle in angles] points = [center] + [ag.firstPoint for ag in arc_geos] + [center] return arcpy.Polygon(arcpy.Array(points), spatial_reference=wkid) def create_view_sheds(in_table, out_features, x_field, y_field, bearing_left_field, bearing_right_field, distance_field, wkid): """Creates a polygon feature class with circle sections. in_table: str, path to the input table or name of the table in the active map out_features: str, path to the output feature class *_field: str, names of the fields in the input table wkid: int, well-known id of the coordinate system """ # create output feature class from pathlib import Path folder = str(Path(out_features).parent) name = str(Path(out_features).name) arcpy.management.CreateFeatureclass(folder, name, "POLYGON", spatial_reference=wkid) arcpy.management.AddField(out_features, "FID", "LONG") with arcpy.da.InsertCursor(out_features, ["SHAPE@", "FID"]) as i_cursor: with arcpy.da.SearchCursor(in_table, ["OID@", x_field, y_field, bearing_left_field, bearing_right_field, distance_field]) as s_cursor: # for each table row for oid, x, y, bearing_left, bearing_right, distance in s_cursor: # create a circle section poly = circle_section(x, y, bearing_left, bearing_right, distance, wkid) # write the polygon and the table row's objectid into the feature class i_cursor.insertRow([poly, oid])     Call the function   create_view_sheds("Observations", "memory/Viewsheds", "X", "Y", "BearingLeft", "BearingRight", "Distance", 25832)       ... View more

# you can turn asset into a layer: asset_layer = arcpy.management.MakeFeatureLayer(asset, "asset_layer") # and then you can call the selection on the layer. # But, much easier: MakeFeatureLayer takes an optional SQL where clause. So: asset_layer = arcpy.management.MakeFeatureLayer(asset, "asset_layer", '"COORDINATE_VALID_DATE" = CURRENT_DATE' ) arcpy.SpatialJoin_analysis(asset_layer, polygonLayer01, "asset_join_poly01", "JOIN_ONE_TO_MANY", "KEEP_COMMON", "", "INTERSECT") ... View more

GroupBy() takes an SQL92 expression, not an Arcade expression. There are ways to group by day in SQL, but Arcade didn't like any of them, Group By seems to be very limited. Here's what I came up with in the end: // load feature set var fs = FeatureSetByPortalItem(Portal(url), id, layer, ["created_date"], false) // Convert datetime to date var fs_date = { geometryType: "", fields: [ {name: "DateShort", type: "esriFieldTypeDate"}, ], features: [] } for(var f in fs) { var d = f.created_date var date_short = Number(Date(Year(d), Month(d), Day(d))) Push(fs_date.features, {attributes: {DateShort: date_short}}) } // group by and order by DateShort var fs_grouped_by_date = GroupBy(FeatureSet(Text(fs_date)), "DateShort", {name: "Total", expression: "1", statistic: "COUNT"}) var fs_ordered_by_date = OrderBy(fs_grouped_by_date, "DateShort") // get cumulative count var fs_cumulative = { geometryType: "", fields: [ {name: "DateShort", type: "esriFieldTypeDate"}, {name: "Total", type: "esriFieldTypeInteger"}, {name: "Cumulative", type: "esriFieldTypeInteger"}, ], features: [] } var cumulative = 0 for(var f in fs_ordered_by_date) { cumulative += f.Total var new_feature = {attributes: {DateShort: Number(f.DateShort), Total: f.Total, Cumulative: cumulative}} Push(fs_cumulative.features, new_feature) } // return return FeatureSet(Text(fs_cumulative))   It loads reasonably fast for my 4.5k features, your mileage may vary...   If you publish from an enterprise gdb, it might be better to do the grouping in a database view with SQL and publish that view. ... View more