Fix K239AE Station DMA

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

array(0) { }

*** DMA ***

array(12) { ["odbcts"]=> string(19) "2019-07-16 06:29:49" ["dmarank"]=> string(4) "9999" ["dmaID"]=> string(4) "9998" ["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 = 'BUENA VISTA' and State = 'CO'

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

Number of rows returned = 1
Start: 1754151790.0502
End: 1754151790.0503
Elapsed time: 0.1600 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
2645 CO Buena Vista -1 78 1752 38.83879 -106.132886 719 0 0 0 0 0 2645 2195 810105 -7 -1 97

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

NULL

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

array(13) { ["zipcode"]=> string(5) "81211" ["zip3"]=> string(3) "812" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(11) "BUENA VISTA" ["zipstate"]=> string(2) "CO" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "38.83" ["iplongitude"]=> string(7) "-106.14" ["ziplocation"]=> string(20) "NA-US-CO-BUENA VISTA" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "3150" ["zippopulation"]=> string(4) "5559" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "812" ["zipcity"]=> string(10) "CANON CITY" ["zipstate"]=> string(2) "CO" }

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

array(22) { ["id"]=> string(4) "2650" ["State"]=> string(2) "CO" ["CityName"]=> string(10) "Canon City" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(2) "93" ["Population"]=> NULL ["Latitude"]=> string(7) "38.4468" ["Longitude"]=> string(11) "-105.228305" ["PrimaryAC"]=> string(3) "719" ["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"]=> string(4) "2650" ["Population2000"]=> string(5) "15431" ["FIPS"]=> string(6) "811810" ["cTZoffset"]=> string(2) "-7" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "97" }

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

No Rows in Recordset!

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

33 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
2803	CO	Pueblo	0	245	98640	38.266933	-104.620393	719		0		0	0	0	0	2803	102121	862000	-7	-1	97
33364	CO	Security-Widefield	-1	0	23822	38.744731	-104.723226			0		0	0	0	0		29845	868847	-7	-1	97
33304	CO	Fountain	-1	0	9984	38.693787	-104.698156			0		0	0	0	0		15197	827865	-7	-1	97
2836	CO	Trinidad	-1	128	8580	37.170944	-104.506447	719		0		0	0	0	0	2836	9078	878610	-7	-1	97
2754	CO	Lamar	-1	2	8343	38.083288	-102.620891	719		0		0	0	0	0	2754	8869	843110	-7	-1	97
2748	CO	La Junta	-1	36	7637	37.981333	-103.54754	719		0		0	0	0	0	2748	7568	842110	-7	-1	97
2814	CO	Salida	-1	33	4737	38.531442	-105.99609	719		0		0	0	0	0	2814	5504	867280	-7	-1	97
2718	CO	Gunnison	-1	36	4636	38.545838	-106.931562	970		0		0	0	0	0	2718	5409	833640	-7	-1	97
33394	CO	Woodland Park	-1	0	4610	38.998226	-105.056269			0		0	0	0	0		6515	886090	-7	-1	97
33331	CO	Manitou Springs	-1	0	4535	38.856559	-104.909996			0		0	0	0	0		4980	848445	-7	-1	97
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
2809	CO	Rocky Ford	-1	0	4162	38.051	-103.721387	719		0		0	0	0	0	2809	4286	865190	-7	-1	97
2695	CO	Florence	-1	0	2990	38.390323	-105.116559	719		0		0	0	0	0	2695	3653	827040	-7	-1	97
2646	CO	Burlington	-1	1	2941	39.304293	-102.268683	719		0		0	0	0	0	2646	3678	810600	-7	-1	97
2755	CO	Las Animas	-1	0	2481	38.06698	-103.225937	719		0		0	0	0	0	2755	2758	843660	-7	-1	97
2757	CO	Limon	-1	73	1831	39.264256	-103.689925	719		0		0	0	0	0	2757	2071	844980	-7	-1	97
2645	CO	Buena Vista	-1	78	1752	38.83879	-106.132886	719		0		0	0	0	0	2645	2195	810105	-7	-1	97
2699	CO	Fowler	-1	0	1154	38.128343	-104.025007	719		0		0	0	0	0	2699	1206	827975	-7	-1	97
2659	CO	Colorado City	-1	0	1149	37.945237	-104.840885	719		0		0	0	0	0	2659	2018	815935	-7	-1	97
2656	CO	Cheyenne Wells	-1	1	1128	38.821141	-102.353637	719		0		0	0	0	0	2656	1010	814175	-7	-1	97
2666	CO	Crested Butte	-1	0	878	38.869409	-106.983645	970		0		0	0	0	0	2666	1529	818310	-7	-1	97
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
2726	CO	Holly	-1	0	877	38.05452	-102.125398	719		0		0	0	0	0	2726	1048	837215	-7	-1	97
2841	CO	Walsh	-1	0	692	37.38654	-102.278727	719		0		0	0	0	0	2841	723	882460	-7	-1	97
2733	CO	Hugo	-1	0	660	39.13352	-103.468089	719		0		0	0	0	0	2733	885	837875	-7	-1	97
2832	CO	Stratton	-1	0	649	39.302976	-102.604272	719		0		0	0	0	0	2832	669	874485	-7	-1	97
2648	CO	Calhan	-1	0	562	39.035395	-104.299835	719		0		0	0	0	0	2648	896	811260	-7	-1	97
33275	CO	Boone	-1	0	341	38.250083	-104.255166			0		0	0	0	0		323	807795	-7	-1	97
2844	CO	Westcliffe	-1	0	312	38.132874	-105.46592	719		0		0	0	0	0	2844	417	883450	-7	-1	97
33351	CO	Poncha Springs	-1	0	244	38.513451	-106.075607			0		0	0	0	0		466	860600	-7	-1	97
2812	CO	Rye	-1	0	168	37.921876	-104.929999	719		0		0	0	0	0	2812	202	866895	-7	-1	97
33385	CO	Vilas	-1	0	105	37.374134	-102.446928			0		0	0	0	0		110	881030	-7	-1	97
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
2650	CO	Canon City	-1	93		38.4468	-105.228305	719		0		0	0	0	0	2650	15431	811810	-7	-1	97
2752	CO	Lake George	-1	0		38.980056	-105.514472	719		0		0	0	0	0	2752			-7	-1	97
2635	CO	Beulah	-1	0		38.127363	-104.63577	719		0		0	0	0	0	2635			-7	-1	97

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

21 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
81212	CANON CITY	CO	18781	Canon City	97
81201	SALIDA	CO	6998	Salida	97
81230	GUNNISON	CO	6932	Gunnison	97
81211	BUENA VISTA	CO	5559	Buena Vista	97
81226	FLORENCE	CO	4384	Florence	97
81240	PENROSE	CO	3678	Penrose
81224	CRESTED BUTTE	CO	3512	Crested Butte	97
81252	WESTCLIFFE	CO	2984	Westcliffe	97
81223	COTOPAXI	CO	1220
81236	NATHROP	CO	822
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
81233	HOWARD	CO	669	Howard
81235	LAKE CITY	CO	668	Lake City
81210	ALMONT	CO	0
81228	GRANITE	CO	0
81251	TWIN LAKES	CO	0	Twin Lakes
81220	CIMARRON	CO	0
81247	GUNNISON	CO	0	Gunnison	97
81237	OHIO CITY	CO	0
81239	PARLIN	CO	0
81243	POWDERHORN	CO	0
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
81253	WETMORE	CO	0

Station K239AE-FX

City BUENA VISTA-CO

City , is located in DMAID: