JCapper Message Board

JCapper 101
-- Turf to poly

Home	Register Log In

Turf to poly

parshooter
4/3/2025
2:03:44 PM

I am trying to write a SQL UDM for turf to poly. For example at GPX when it rains and they switch surface from races taken off the turf and put on tapeta. I realize that means track code 4 going to track code 2. Just trying to determine how to correctly write a UDM for this. Please advise.

jeff
4/4/2025
4:45:35 PM

SQL Mode

The key for an Off Turf to Tapeta UDM at Gulfstream in SQL Mode is getting the SQL Expression right.

Note that text evaluations via the INSTR keyword made by the Microsoft Jet db driver aren't case sensitive.

Therefore, sql expressions like the one below, where I've referenced the track code, will do the trick.

Optionally, you can add factor rankings and dist, etc., like this:

SELECT * FROM STARTERHISTORY
           WHERE TRACK='GPX'
           AND RANKF23=1
           AND INSTR('O', SURFACE) > 0
           AND DIST >= 1650

UDM Wizard screenshot:

PL Mode UDM Wizard

-jp
.

jeff
4/4/2025
4:47:26 PM

PlayList File Mode

The key for an Off Turf to Tapeta UDM at Gulfstream in PlayList File Mode is selecting the lower case "o" (without the quotes) as your Surface Req.

Right now as I type this GPX is the only track with an Inner Tapeta Course (meaning you don't need to check the This Track Test box and add "GPX" to the Restrict TrackList field.

Of course that is going to change when BEL reopens - at which point you WILL need to check the This Track Test box and add "GPX" and/or "BEL" to the Restrict TrackList field.

UDM Wizard screenshot:

PL Mode UDM Wizard

Note: For Off Turf to Tapeta at Woodbine select upper case "O" without the quotes as your Surface Req.

-jp
.

parshooter
4/9/2025
6:45:33 PM

Thank you. Much Appreciated :)

JCapper Message Board

JCapper 101 -- Turf to poly

JCapper 101
-- Turf to poly