This was one of the best demonstrations I've seen to date. Thank you so much for explaining and showing each step so well. I loved how comprehensive it was. It inspired me to give it a try!
Thanks for sharing! I am able to run it for the past week but somehow it started to have this warning saying an empty output is generated recently. I wonder if you could help me with it?
This is so helpful! I was curious if the same process could be done that doesn't have XY data. I have been manually joining it to a Section layer then exporting, then copying new records and pasting to the hosted feature layer. However, this doesn't account for any edits to the prior added features in the hosted feature layer. But if I delete rows, then append data, field mapping doesn't seem to work and the content comes up blank/null. Any advice?
Hi, at the 20 minute mark with the sql query to select the latest date, what if some stations do not have the same latest date. Then those would not be selected. How do you query the last date for all stations if they are different? Thank you.