Measurement Forum Archive

Read-only historical archive of measure.infopop.cc

Status Codes in the Course list

#1 • 11/28/07 @ 5:24 AM
COURSE STATUS CODES

The course list contains codes which give a bit of information. They are shown below:

A - Active course
04, 05 etc - Restored to list after 10 year expiration. "04," "05" refers to date of renewal.
X - Expired
D - Deleted by certifier
F - Failed post-race validation
M - No map on file - some early courses.
P - Passed post-race validation
R - Replaced by another course
U - Course unusable
V - Prevalidated

Sometimes two or more letters are used in combination. For example, "PD" means passed validation, but later deleted

Note: "Active" does not mean that the course is still used. It means only that the course has neither expired nor been deleted by the state certifier. A number of race courses have several certification numbers. In these cases, the latest number may be presumed to be the currently-used course.
#2 • 11/28/07 @ 9:04 AM
If it is known that due to road changes/construction the course as shown on the map is no longer accurate, which code should be used, course unusable?
#3 • 11/28/07 @ 9:45 AM
That's right. Unusable.
#4 • 12/11/07 @ 5:43 PM
Okay, I give up. Why can't I find any expired courses in the list I downloaded from the Website? I asked for the entire list, all fields.

I looked, but could find no courses with status "X".

What am I missing? Having expired courses in the list would help me in my endeavor to list all certified races in 2008, as a way to cross-check my info.

Thanks,

Confused
#5 • 12/11/07 @ 7:41 PM
If you downloaded all 29,000 courses, you should have no trouble finding one that's expired. If you didn't, I can send it to you.

You'll want Microsoft Access for best results.
#6 • 12/11/07 @ 8:16 PM
I see now that I had to go over to the right and change "Active" to "Any". Now I am downloading all courses. My oversight.

Thanks