Corvallis Comcast HD
I spend a lot of my spare time playing around with MythTV, which could probably be most easily described as an opensource Tivo, except that really doesn't do it justice. In any event, the only thing up here now is the following data files with my recent HD project. These are the unencrypted QAM channels for Corvallis Comcast that I've been able to figure out by scanning, then watching a 10 second clip from each channel I could tune:
Note: This table has been updated due to a recent change by Comcast to the OPB channels. It's also worth pointing out that the latest version of MythTV seems to do an *excellent* job of scanning for channels. When someone pointed out that Comcast had changed the frequencies, I simply re-scaned the channels in mythtv-setup and let it alter the tables. It worked perfectly.
#QAM info callsign channel # #chanid:freq:QAM type:?:?:serviceid # 4:519000000:QAM_256:2114:2112:2 #KGW 8 15:525000000:QAM_256:2305:2304:4011 #Corvallis channel? ? 16:525000000:QAM_256:2369:2368:4012 #OPAN ? 17:525000000:QAM_256:2433:2432:4013 #KBVR-TV ? KLSR HDF:537000000:QAM_256:2048:2049:4 #Fox HD 705 KMTR HDF:537000000:QAM_256:2112:2113:3 #KMTR NBC HD 703 44:561000000:QAM_256:2049:2048:4014 #Research Channel 27 46:567000000:QAM_256:2561:2560:4022 #scola belarus? ? 47:567000000:QAM_256:2625:2624:4021 #blank ? 67:573000000:QAM_256:2561:2560:4024 #channel 29 86:585000000:QAM_256:2753:2752:5022 #Hard Times? CNW14 (14?) 14 87:591000000:QAM_256:2048:2049:210 #QVC 16 94:591000000:QAM_256:2496:2497:201 #C-SPAN 24 95:591000000:QAM_256:2560:2561:202 #C-SPAN2 25 107:603000000:QAM_256:2048:2049:2 #KEVU 20 108:603000000:QAM_256:2112:2113:3 #FOX 5 109:603000000:QAM_256:2176:2177:4 #KVAL CBS 13 110:603000000:QAM_256:2240:2241:5 #ABC - which one? 9 111:603000000:QAM_256:2304:2305:7 #KTVC 12 KOPB-HDF:123000000:QAM_256:4224:4225:13 #OPB HD 710 Create:123000000:QAM_256:5056:5057:14 #OPB Create? 210 OC:123000000:QAM_256:5120:5121:15 #OPB OC? Oregon Channel? 311 KVAL-DT:627000000:QAM_256:2048:2049:6 #CBS HD 713 KEZI-HD:627000000:QAM_256:2112:2113:1 #ABC HD 709 174:657000000:QAM_256:2496:2497:1104 #some add channel ? 182:663000000:QAM_256:2434:2432:4031 #OPB? 10 195:669000000:QAM_256:2433:2432:1072 #adds - channel 15 196:675000000:QAM_256:2048:2049:303 #Discovery 7 215:681000000:QAM_256:2560:2561:5024 #univision channel 31 217:687000000:QAM_256:2049:2048:2 #telemundo channel 30 219:687000000:QAM_256:2177:2176:3 #Jewelty TV channel 0/98 226:687000000:QAM_256:2626:2624:4 #CBS channel 6 228:693000000:QAM_256:2049:2048:13 #WGN (CW?) but times are off 11 245:705000000:QAM_256:2049:2048:16 #Hallmark 18 302:747000000:QAM_256:0:2497:4 #TV Guide Channel 4
So, how do you use this information? Let's assume that you want to setup OPB HD and that you already have your listing data configured. All that remains is to get the channels table fixed up so that the channel for OPB HD has the correct freqid, mplexid, and serviceid. Note that using mythtv-setup to scan your HD channels is how the dtv_multiplex table in the mythconverg DB gets setup. So, from above for OPB HD we have: freq=621000000 and serviceid=60. Query the dtv_multiplex table to get:
mysql> select mplexid,frequency from dtv_multiplex where frequency=621000000 and modulation='qam_256'; +---------+-----------+ | mplexid | frequency | +---------+-----------+ | 88 | 621000000 | +---------+-----------+
Now you would update your channels table with this mplexid and the serviceid. I'm assuming you would know how to do this part and just showing the results:
mysql> select chanid,channum,callsign,name,freqid,mplexid,serviceid from channel where callsign='KOPB HD'; +--------+---------+----------+---------+--------+---------+-----------+ | chanid | channum | callsign | name | freqid | mplexid | serviceid | +--------+---------+----------+---------+--------+---------+-----------+ | 10710 | 710 | KOPB HD | KOPB HD | 710 | 88 | 60 | +--------+---------+----------+---------+--------+---------+-----------+
Notice that your chanid will be different and that I have fixed up the channum to match what Comcast uses in their channel lineup. Here are the channels that I'm using currently:
mysql> select chanid,channum,callsign,name,freqid,mplexid,serviceid from channel where channum like '7__' ; +--------+---------+----------+----------------------+--------+---------+-----------+ | chanid | channum | callsign | name | freqid | mplexid | serviceid | +--------+---------+----------+----------------------+--------+---------+-----------+ | 10703 | 703 | KMTR HD | KMTR HD | 76 | 57 | 3 | | 10705 | 705 | KLSR HD | KLSR HD | 76 | 57 | 4 | | 10709 | 709 | KEZI HD | KEZI HD | 91 | 71 | 1 | | 10710 | 710 | KOPB HD | KOPB HD | 710 | 88 | 60 | | 10713 | 713 | KVAL HD | KVAL HD | 91 | 71 | 6 | +--------+---------+----------+----------------------+--------+---------+-----------+