Reply to thread

Message

<blockquote data-quote="James" data-source="post: 102306" data-attributes="member: 12681">Help required!Ok to try an improve the TV/Radio setup I have been looking at ways to setup a channel information database.I have found that I can download a full database from the fcc in the US. However, this database is way too big!! So I was wondering if someone would be able to filter it for me <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />I'm hoping it will be a lot smaller, once all the non relevant data is thrown away.The database can be downloaded here (include information of database structure, etc):<a href="http://www.fcc.gov/mb/databases/cdbs/" target="_blank">http://www.fcc.gov/mb/databases/cdbs/</a>and searched on line here:<a href="http://www.fcc.gov/mb/video/tvq.html" target="_blank">http://www.fcc.gov/mb/video/tvq.html</a>The database has many tables and I haven't quite worked out how they all fit together. However, when searching on the I can see the useful information:state, city, call sign, channel and Licensee&nbsp; (Where service=TV and TX)Currently the db is a 66Meg zip download (updated daily) but becomes 300Meg of data on the disk!I don't think we need to update everyday. However, some form of scripting that would allow the data to be filtered automatically and updated once in a while would be good.Anyway, post here or PM me if you are interested. Being from/in the US may help understanding the data. There are no garantees this can/will be used, but it is worth a try <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink&nbsp; &nbsp; ;)" loading="lazy" data-shortname=";)" /></blockquote>

[QUOTE="James, post: 102306, member: 12681"] Help required! Ok to try an improve the TV/Radio setup I have been looking at ways to setup a channel information database. I have found that I can download a full database from the fcc in the US. However, this database is way too big!! So I was wondering if someone would be able to filter it for me :) I'm hoping it will be a lot smaller, once all the non relevant data is thrown away. The database can be downloaded here (include information of database structure, etc): [url]http://www.fcc.gov/mb/databases/cdbs/[/url] and searched on line here: [url]http://www.fcc.gov/mb/video/tvq.html[/url] The database has many tables and I haven't quite worked out how they all fit together. However, when searching on the I can see the useful information: state, city, call sign, channel and Licensee (Where service=TV and TX) Currently the db is a 66Meg zip download (updated daily) but becomes 300Meg of data on the disk! I don't think we need to update everyday. However, some form of scripting that would allow the data to be filtered automatically and updated once in a while would be good. Anyway, post here or PM me if you are interested. Being from/in the US may help understanding the data. There are no garantees this can/will be used, but it is worth a try ;) [/QUOTE]

Verification