Latest Contributions by Bud

FYI, as a plan B, you can calculate a weighted average in a database view or a query layer using SQL: https://dba.stackexchange.com/a/189236/100880 select road_id, to_char(trunc( insp_date), 'YYYY-MM-DD') as insp_day, avg(condition) condition_avg, sum(insp_length) insp_length_tot, round(sum(condition * insp_length) / sum(insp_length), 2) as CONDITION_WEIGHTED_AVG from road_insp group by road_id, trunc(insp_date) order by road_id, trunc( insp_date); ROAD_ID INSP_DAY CONDITION_AVG INSP_LENGTH_TOT CONDITION_WEIGHTED_AVG ---------- ---------- ------------- --------------- ---------------------- 100 2017-01-01 5 100 5 101 2017-02-01 5.75 1500 5.83 102 2018-04-01 7 6000 7.08 103 2018-07-01 8.25 6500 8.27 103 2019-09-01 9.25 8500 9.26 As always, be very careful with nulls: Tips about nulls in SQL And I have a different idea here that might interest people who use Summary Statistics: Summary Statistics — Tie fields to a primary field ... View more

Bear in mind that if TYPE is null, it won’t be captured by either of those SQL expressions. But that’s easily fixable if needed: (TYPE=‘STORM’ OR TYPE IS NULL) ... View more

What kind of geodatabase? I.e., Oracle enterprise geodatabase? You could use a database view or a query layer to combine the two fields into a SQL calculated field. Then symbolize on that calculated field. https://www.w3schools.com/sql/sql_case.asp  ... View more

This idea can be closed. I see now that I can: Drag an item from the Catalog Pane down to the Geoprocessing tab ...which will bring up the Geoprocessing Pane Then, drop the item into a geoprocessing parameter ... View more

I agree that ESRI’s minimum requirements are not enough. ... View more

As a workaround, I suppose we could implement the sample code and then look at the Logs tab in the Diagnostic Monitor in ArcGIS Pro (in the Help tab in the ribbon). One of the End Cursor log entries might show the SQL query that’s sent to the database. Untested. ... View more

https://pro.arcgis.com/en/pro-app/latest/help/data/excel/work-with-excel-in-arcgis-pro.htm#GUID-8414CA6E-2F80-4FB4-843F-36F303BDA6B2 ... View more

Possibly related:  BUG-000085841 The Create Database View tool does not accept the divide operator '/' in the view definition input field. ... View more

A note about the path_to_dataset in Python from @DrewFlater : ...Python uses the \ backslash character as an escape character, so you need to either use double backslashes, use forward slashes, or put an r at the front of the string to indicate raw string.  ... View more