Overlay Route Events - Standalone Python Script with definition queries

Question

My org started using Roads and Highways this year and would like to create a standalone python script to run the overlay route events tool. We were able to create a script based on the code here: Overlay Route Events—Location Referencing for Roads and Highways | ArcGIS Desktop

However, we would like both the LRSN and event layers to have definition queries set on them so that only current roads are output. When I bring the LRSN and event layers to ArcMap, they are automatically queried as follows:

(FromDate is null or FromDate<=CURRENT_TIMESTAMP) and (ToDate is null or ToDate>CURRENT_TIMESTAMP)

Would anyone know how to apply the query in the python before running the overlay route events tool?

Thanks,

Charmalee

NathanEasley · Answer

Hi Charmalee,

Glad to hear you got the tool working using python.

Nathan

ArcGIS Roads and Highways team

CharmaleeSandanayake1 · Answer

I had asked our Esri rep about this  previously and she recommended the Make Feature Layer Tool (Make Feature Layer (Data Management)—ArcGIS Pro | Documentation ) or saving layer files of the events and then running the Overlay Route Events tool. Just had to reread the email she had sent months ago.  So far that seems to be working. Thanks for your help.

CharmaleeSandanayake1 · Answer

Thanks Nathan. I tried creating a query layer in ArcMap using the script from the link you provided. When I  try to input the query layer Road LRS into the Overlay Route Event Tool I get the following error message:

Unable to get Network properties from the LRS Meta Data table.
Unable to parse parameters.
Failed to execute (OverlayRouteEvents).

I did try to run the Overlay Route Event tool both programmatically and within ArcMap. I also tried using the ArcMap Make Query Layer tool and then putting the output query into the Overlay Route Event Tool but get the same result.

Any idea where the error could be coming from?