DB issues

Status
Not open for further replies.

QDP2012

Member
Joined
Feb 8, 2012
Messages
1,921
For some reason, trying to retrieve frequencies for Oakland (ZOA) Air Route Traffic Control Center gets the error "Could not connect to the database", same for ZLA and ZSE.

The RR Wiki: ARTCC page lists all 22 of the ARTCC pages in the DB and in the Wiki. All 22 of the ARTCC pages in the DB show the "Could not connect to the database" error.

Hope this helps,
 

kma371

QRT
Joined
Feb 20, 2001
Messages
6,204
I think I remember the same thing happening a few years ago. I don't remember what the fix was. I'll do some checking.

All the info is still there on the admin side of the database. I think this may have been an issue with the FAA data pull for the table that's normally listed at the top of the page.
 

nd5y

Member
Joined
Dec 19, 2002
Messages
11,284
Location
Wichita Falls, TX
I found an error with the raw FAA data at the top of each ARTCC page. I don't know if this has been reported or not.

It looks like frequencies that end in 5 in the 3rd decimal place are chopped and the 5 appears as the first character in the Usage column.

The ones with ARTCC in the ARTCC Type column have all zeros for the frequency.

Like this:
Code:
ARTCC Site Location        State    ARTCC Type        Frequency        Usage        Special Notes
EL DORADO        RCAG    272.75000    HIGH       DO NOT PUBLISH
FORT WORTH       ARTCC     0.00000    LOW    
FRANKSTON        RCAG    134.02000    5 HIGH    
FRANKSTON        RCAG    135.25000    LOW        DISCRETE
 
Status
Not open for further replies.
Top