Fix K250BU Station DMA

Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix K250BU Station DMA

array(0) { }

*** DMA ***

array(12) { ["odbcts"]=> string(19) "2019-07-16 06:29:49" ["dmarank"]=> string(4) "9999" ["dmaID"]=> string(4) "9999" ["dmaType"]=> NULL ["Minority"]=> NULL ["QualType"]=> NULL ["DMAName"]=> string(7) "Unrated" ["Population25up"]=> string(1) "0" ["scanned"]=> NULL ["AvgLatitude"]=> NULL ["AvgLongitude"]=> NULL ["State"]=> string(0) "" }
Database: media
SQL: select * from cities where CityName = 'BETTENDORF' and State = 'IA'

Table	Type	Possible Keys	Key	Key Length	Ref	Rows	Extra
cities	ref	CityName	CityName	53	const	1	Using where

Number of rows returned = 1
Start: 1754153024.2607
End: 1754153024.2609
Elapsed time: 0.1881 ms 1 records found!
id State CityName RuralArea PopCount Population Latitude Longitude PrimaryAC ZoneDesc EartlinkDSL ISPCount CovadDSL VerizonDSL allegiance SBC RateCenterCityid Population2000 FIPS cTZoffset DST DMAID
3838 IA Bettendorf -1 0 28132 41.550044 -90.493679 563 0 0 0 0 0 31275 1906355 -6 -1 143

*** city ***************

NULL

****** zip code ************

array(13) { ["zipcode"]=> string(5) "52722" ["zip3"]=> string(3) "527" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(10) "BETTENDORF" ["zipstate"]=> string(2) "IA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "41.56" ["iplongitude"]=> string(6) "-90.47" ["ziplocation"]=> string(19) "NA-US-IA-BETTENDORF" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "17207" ["zippopulation"]=> string(5) "30958" ["zipincome"]=> string(7) "8388607" }

******* zip3 ***********

array(3) { ["zip3"]=> string(3) "527" ["zipcity"]=> string(10) "BETTENDORF" ["zipstate"]=> string(2) "IA" }

**** zip3 city**************

array(22) { ["id"]=> string(4) "3838" ["State"]=> string(2) "IA" ["CityName"]=> string(10) "Bettendorf" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(1) "0" ["Population"]=> string(5) "28132" ["Latitude"]=> string(9) "41.550044" ["Longitude"]=> string(10) "-90.493679" ["PrimaryAC"]=> string(3) "563" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "0" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> NULL ["Population2000"]=> string(5) "31275" ["FIPS"]=> string(7) "1906355" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "143" }

**** cities in DMA per station **************

No Rows in Recordset!

***** cities in DMA by city *************

12 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
3938	IA	Davenport	0	125	95333	41.542982	-90.590745	563		0		0	0	0	0	3938	98359	1919000	-6	-1	143
5348	IL	Moline	0	90	43202	41.490966	-90.502006	309		0		0	0	0	0	5348	43768	1749867	-6	-1	143
5527	IL	Rock Island	0	68	40552	41.489083	-90.573154	309		0		0	0	0	0	5527	39684	1765078	-6	-1	143
3907	IA	Clinton	-1	78	29201	41.846863	-90.20733	563		0		0	0	0	0	3907	27772	1914430	-6	-1	143
3838	IA	Bettendorf	-1	0	28132	41.550044	-90.493679	563		0		0	0	0	0		31275	1906355	-6	-1	143
4285	IA	Muscatine	-1	46	22881	41.424018	-91.056093	563		0		0	0	0	0	4285	22697	1955110	-6	-1	143
5024	IL	East Moline	0	78	20147	41.51194	-90.435203	309		0		0	0	0	0	5024	20333	1722073	-6	-1	143
5107	IL	Geneseo	-1	2	5990	41.449915	-90.153347	309		0		0	0	0	0	5107	6480	1728846	-6	-1	143
5356	IL	Morrison	-1	2	4363	41.809258	-89.967953	815		0		0	0	0	0	5356	4447	1750530	-6	-1	143
4748	IL	Aledo	-1	3	3681	41.200172	-90.749956	309		0		0	0	0	0	4748	3613	1700646	-6	-1	143
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
3991	IA	Eldridge	-1	0	3378	41.648697	-90.581492	563		0		0	0	0	0	3991	4159	1924600	-6	-1	143
5061	IL	Erie	-1	0	1572	41.657802	-90.078931	309		0		0	0	0	0	5061	1589	1724374	-6	-1	143

**** cities in zip3 **************

37 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
52722	BETTENDORF	IA	30958	Bettendorf	143
52761	MUSCATINE	IA	25359	Muscatine	143
52732	CLINTON	IA	21927	Clinton	143
52748	ELDRIDGE	IA	7608	Eldridge	143
52742	DE WITT	IA	6617	De Witt
52753	LE CLAIRE	IA	4434	Le Claire
52772	TIPTON	IA	4232	Tipton
52730	CAMANCHE	IA	4102	Camanche
52776	WEST LIBERTY	IA	4010	West Liberty
52726	BLUE GRASS	IA	4006	Blue Grass
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
52778	WILTON	IA	3454	Wilton
52738	COLUMBUS JUNCTION	IA	3027	Columbus Junction
52773	WALCOTT	IA	2086	Walcott
52756	LONG GROVE	IA	2008	Long Grove
52747	DURANT	IA	1983	Durant
52755	LONE TREE	IA	1653	Lone Tree
52768	PRINCETON	IA	1205	Princeton
52777	WHEATLAND	IA	1131	Wheatland
52754	LETTS	IA	1121	Letts
52751	GRAND MOUND	IA	927	Grand Mound
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
52746	DONAHUE	IA	843	Donahue
52749	FRUITLAND	IA	836	Fruitland
52720	ATALISSA	IA	798	Atalissa
52731	CHARLOTTE	IA	791	Charlotte
52729	CALAMUS	IA	755	Calamus
52721	BENNETT	IA	668	Bennett
52766	NICHOLS	IA	667	Nichols
52739	CONESVILLE	IA	608	Conesville
52769	STOCKTON	IA	574	Stockton
52745	DIXON	IA	572	Dixon
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
52760	MOSCOW	IA	529	Moscow
52750	GOOSE LAKE	IA	525	Goose Lake
52759	MONTPELIER	IA	0
52771	TEEDS GROVE	IA	0
52737	COLUMBUS CITY	IA	0	Columbus City
52727	BRYANT	IA	0
52765	NEW LIBERTY	IA	0	New Liberty

Station K250BU-FX

City BETTENDORF-IA

City , is located in DMAID: