 |
|
10-04-2021, 01:14 PM
|
#1
|
|
Registered User
Join Date: Mar 2005
Location: Queens, NY
Posts: 20,605
|
Database Guys (especially Formulator)
I just ran my weekly database updates and noticed that some of the data has the new GP track surface field with a value of "Y".
As far as I can tell, that's a brand new value for the surface field. So if you have any coding out there looking for "D", "T", "X", "E", "O", "A" or "B", or any other legitimate values but not "Y" you could have some issues.
It was an easy fix for me, but I was lucky to find it right away before I did weeks of updates.
__________________
"Unlearning is the highest form of learning"
Last edited by classhandicapper; 10-04-2021 at 01:19 PM.
|
|
|
|
10-04-2021, 02:16 PM
|
#2
|
|
Registered User
Join Date: Nov 2012
Posts: 1,541
|
Thanks for the heads-up. I use trackmaster charts but I will check to make sure there's nothing new.
|
|
|
|
10-04-2021, 02:28 PM
|
#3
|
|
Registered User
Join Date: Mar 2005
Location: Queens, NY
Posts: 20,605
|
Quote:
Originally Posted by MJC922
Thanks for the heads-up. I use trackmaster charts but I will check to make sure there's nothing new.
|
No problem, I owe you plenty for all the help you've given me over the years.
I use Formulator, but the source for all this data is Equibase. So it's likely it was a change for other sources too.
I was just lucky to see that half the GP races were missing from one of my tables. When I debugged it, I found the new surface code. The system couldn't do a match on another table by surface and dropped the records. I already fixed it, but it would have been a bigger problem if I didn't notice it for a few weeks.
__________________
"Unlearning is the highest form of learning"
|
|
|
|
|
10-04-2021, 03:13 PM
|
#4
|
|
Registered User
Join Date: Jun 2007
Posts: 1,237
|
I was a bit concerned when I saw the original post so I double checked and the code for the Tapeta course_type in Equibase data is "E" as it is for all other all-weather surfaces in North America.
It might be something only in Formulator.
Last edited by ubercapper; 10-04-2021 at 03:14 PM.
|
|
|
|
|
10-04-2021, 03:38 PM
|
#5
|
|
Registered User
Join Date: Mar 2005
Location: Queens, NY
Posts: 20,605
|
Quote:
Originally Posted by ubercapper
I was a bit concerned when I saw the original post so I double checked and the code for the Tapeta course_type in Equibase data is "E" as it is for all other all-weather surfaces in North America.
It might be something only in Formulator.
|
It's interesting because on the results file I use the Surface is coded as "D" which is typical for Dirt and the Course is coded as "E" which is typical of Synthetic.
I import both the Formulator PPs and results charts separately.
Most people are probably OK, though I'm not sure why the Formulator PPs for Race Information would be coded differently when the source for everything is Equibase.
__________________
"Unlearning is the highest form of learning"
|
|
|
|
|
10-04-2021, 04:45 PM
|
#6
|
|
Registered User
Join Date: Nov 2012
Posts: 1,541
|
Yes sir(s), thank you, it checks out as E. I was going to yell for Ellis earlier but just in case he was tied up I checked it out during a coffee break.
|
|
|
|
|
10-04-2021, 05:26 PM
|
#7
|
|
The Voice of Reason!
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 112,810
|
Brought to you by the same people who time races so competently.
__________________
Who does the Racing Form Detective like in this one?
|
|
|
|
|
10-06-2021, 08:28 AM
|
#8
|
|
Registered User
Join Date: Feb 2003
Posts: 2,105
|
Class,
Thanks for the heads up. Hadn't watched the races the past few days to see it. They come through the same in my chart files so it will take some work to unscramble.
Do you think they will continue to use the about in the distances?
SK
|
|
|
|
|
10-06-2021, 09:34 AM
|
#9
|
|
Registered User
Join Date: Mar 2005
Location: Queens, NY
Posts: 20,605
|
Quote:
Originally Posted by sjk
Class,
Thanks for the heads up. Hadn't watched the races the past few days to see it. They come through the same in my chart files so it will take some work to unscramble.
Do you think they will continue to use the about in the distances?
SK
|
I noticed that also. I think CJ mentioned that on Twitter with regards to figure making. Then I saw it in the data. Maybe it will only last until they iron all the kinks on the new track.
__________________
"Unlearning is the highest form of learning"
|
|
|
|
|
10-06-2021, 10:13 AM
|
#10
|
|
@TimeformUSfigs
Join Date: Jan 2002
Location: Moore, OK
Posts: 46,828
|
Quote:
Originally Posted by sjk
Class,
Thanks for the heads up. Hadn't watched the races the past few days to see it. They come through the same in my chart files so it will take some work to unscramble.
Do you think they will continue to use the about in the distances?
SK
|
From what I understand that will go away, the course survey isn't completed yet.
|
|
|
|
|
10-06-2021, 11:43 AM
|
#11
|
|
Registered User
Join Date: Feb 2003
Posts: 2,105
|
It would be helpful if they could give us a different surface name like turf and iturf.
Ron?
|
|
|
|
|
10-07-2021, 09:09 AM
|
#12
|
|
Registered User
Join Date: Feb 2003
Posts: 2,105
|
In fact looking at the entries for today they are marked "idirt".
I guess I should look at it as an opportunity to get some figures up and running for the new track and perhaps beat the crowd.
Happy betting.
|
|
|
|
|
10-07-2021, 05:16 PM
|
#13
|
|
The Voice of Reason!
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 112,810
|
Is there any industry out there as pathetically incompetent as horse racing?
This isn't rocket science.
__________________
Who does the Racing Form Detective like in this one?
|
|
|
|
|
10-07-2021, 05:38 PM
|
#14
|
|
Registered User
Join Date: Dec 2011
Posts: 4,285
|
Quote:
Originally Posted by Tom
Is there any industry out there as pathetically incompetent as horse racing?
This isn't rocket science.
|
Does government count as an industry?
__________________
Best writing advice ever received: Never use a long word when a diminutive one will suffice.
|
|
|
|
|
10-07-2021, 05:42 PM
|
#15
|
|
The Voice of Reason!
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 112,810
|
Quote:
Originally Posted by AndyC
Does government count as an industry?
|
OK, ya got me. 
__________________
Who does the Racing Form Detective like in this one?
|
|
|
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
