Fix K220GE 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 = 'LEVAN' and State = 'UT'

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: 1754169881.3154
End: 1754169881.3156
Elapsed time: 0.1299 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
41547 UT Levan -1 0 416 39.556732 -111.861006 0 0 0 0 0 688 4944650 -7 -1

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

NULL

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

array(13) { ["zipcode"]=> string(5) "84639" ["zip3"]=> string(3) "846" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(5) "LEVAN" ["zipstate"]=> string(2) "UT" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "39.52" ["iplongitude"]=> string(7) "-111.88" ["ziplocation"]=> string(14) "NA-US-UT-LEVAN" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "386" ["zippopulation"]=> string(3) "774" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "846" ["zipcity"]=> string(5) "PROVO" ["zipstate"]=> string(2) "UT" }

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

array(22) { ["id"]=> string(5) "20149" ["State"]=> string(2) "UT" ["CityName"]=> string(5) "Provo" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "309" ["Population"]=> string(5) "86835" ["Latitude"]=> string(9) "40.244421" ["Longitude"]=> string(11) "-111.660804" ["PrimaryAC"]=> string(3) "801" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "20149" ["Population2000"]=> string(6) "105166" ["FIPS"]=> string(7) "4962470" ["cTZoffset"]=> string(2) "-7" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "31" }

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

No Rows in Recordset!

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

35 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
20161	UT	Salt Lake City	0	346	159936	40.7547	-111.892622	801		1		1	0	0	0	20161	181743	4967000	-7	-1	31
20149	UT	Provo	0	309	86835	40.244421	-111.660804	801		0		1	0	0	0	20149	105166	4962470	-7	-1	31
20139	UT	Orem	-1	0	67561	40.298753	-111.696486	801		0		0	0	0	0		84324	4957300	-7	-1	31
20137	UT	Ogden	0	299	63909	41.227744	-111.961193	801		0		1	0	0	0	20137	77226	4955980	-7	-1	31
20041	UT	Bountiful	0	211	36659	40.879645	-111.871553	801		0		1	0	0	0	20041	41301	4907690	-7	-1	31
20112	UT	Logan	0	164	32762	41.737878	-111.830846	435		0		0	0	0	0	20112	42670	4945860	-7	-1	31
20043	UT	Brigham City	-1	94	15644	41.510192	-112.015011	435		0		0	0	0	0	20043	17411	4908460	-7	-1	31
20169	UT	Springville	-1	83	13950	40.162768	-111.604241	801		0		0	0	0	0	20169	20424	4972280	-7	-1	31
41590	UT	South Jordan	-1	0	12220	40.561598	-111.960889			0		0	0	0	0		29437	4970850	-7	-1	31
41497	UT	Centerville	-1	0	11500	40.926824	-111.880086			0		0	0	0	0		14585	4911980	-7	-1	31
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
41594	UT	Spanish Fork	-1	71	11272	40.104546	-111.639954			0		0	0	0	0		20246	4971290	-7	-1	31
21883	WY	Evanston	-1	76	10903	41.263302	-110.964616	307		0		0	0	0	0	21883	11507	5625620	-7	-1	31
20145	UT	Payson	-1	75	9510	40.038835	-111.733147	801		0		0	0	0	0	20145	12716	4958730	-7	-1	31
20166	UT	Smithfield	-1	120	5566	41.835253	-111.828388	435		0		0	0	0	0	20166	7261	4969640	-7	-1	31
20176	UT	Tremonton	-1	1	4264	41.709383	-112.173778	435		0		0	0	0	0	20176	5592	4977120	-7	-1	31
20133	UT	Nephi	0	132	3515	39.709303	-111.831449	435		0		0	0	0	0	20133	4733	4954220	-7	-1	31
20069	UT	Ephraim	0	4	3363	39.358095	-111.584014	435		0		0	0	0	0	20069	4505	4923530	-7	-1	31
20058	UT	Delta	0	4	2998	39.353145	-112.573656	435		0		0	0	0	0	20058	3209	4918910	-7	-1	31
20116	UT	Manti	-1	0	2268	39.264759	-111.638913	435		0		0	0	0	0	20116	3040	4947730	-7	-1	31
41618	UT	Wellsville	-1	0	2206	41.635552	-111.932993			0		0	0	0	0		2728	4982620	-7	-1	31
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
41537	UT	Hyde Park	-1	0	2190	41.799944	-111.817853			0		0	0	0	0		2955	4937390	-7	-1	31
20129	UT	Mount Pleasant	-1	9	2092	39.543104	-111.456325	435		0		0	0	0	0	20129	2707	4953010	-7	-1	31
20077	UT	Fillmore	-1	6	1956	38.967642	-112.330698	435		0		0	0	0	0	20077	2253	4925510	-7	-1	31
20153	UT	Richmond	-1	118	1955	41.919337	-111.810169	435		0		0	0	0	0	20153	2051	4963680	-7	-1	31
20159	UT	Salina	-1	84	1943	38.949232	-111.861447	435		0		0	0	0	0	20159	2393	4965880	-7	-1	31
20088	UT	Gunnison	-1	0	1298	39.155882	-111.816556	435		0		0	0	0	0	20088	2394	4932660	-7	-1	31
20054	UT	Coalville	-1	1	1065	40.917231	-111.398385	435		0		0	0	0	0	20054	1382	4914840	-7	-1	31
41499	UT	Clarkston	-1	0	645	41.918798	-112.049319			0		0	0	0	0		688	4913190	-7	-1	31
41560	UT	Mona	-1	0	584	39.815392	-111.856354			0		0	0	0	0		850	4951140	-7	-1	31
20078	UT	Fountain Green	-1	0	578	39.627653	-111.63931	435		0		0	0	0	0	20078	945	4926720	-7	-1	31
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
20096	UT	Huntsville	-1	0	561	41.259864	-111.773446	801		0		0	0	0	0		649	4937060	-7	-1	31
41570	UT	Oakley	-1	0	522	40.718595	-111.287863			0		0	0	0	0		948	4955650	-7	-1	31
20151	UT	Randolph	-1	1	488	41.664397	-111.183461	435		0		0	0	0	0	20151	483	4963020	-7	-1	31
20092	UT	Holden	-1	0	402	39.099889	-112.269695	435		0		0	0	0	0	20092	400	4935960	-7	-1	31
20117	UT	Marysvale	-1	0	364	38.447585	-112.232763	435		0		0	0	0	0	20117	381	4948610	-7	-1	31

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

24 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
84660	SPANISH FORK	UT	26963	Spanish Fork	31
84604	PROVO	UT	25456	Provo	31
84601	PROVO	UT	22642	Provo	31
84663	SPRINGVILLE	UT	22010	Springville	31
84651	PAYSON	UT	17332	Payson	31
84606	PROVO	UT	16611	Provo	31
84655	SANTAQUIN	UT	7277	Santaquin
84653	SALEM	UT	6136	Salem
84664	MAPLETON	UT	5877	Mapleton
84648	NEPHI	UT	4378	Nephi	31
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
84624	DELTA	UT	4311	Delta	31
84627	EPHRAIM	UT	3049	Ephraim	31
84647	MOUNT PLEASANT	UT	2718	Mount Pleasant	31
84642	MANTI	UT	2456	Manti	31
84631	FILLMORE	UT	2287	Fillmore	31
84654	SALINA	UT	2053	Salina	31
84629	FAIRVIEW	UT	1912	Fairview
84645	MONA	UT	1716	Mona	31
84635	HINCKLEY	UT	638	Hinckley
84621	AXTELL	UT	0
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
84630	FAYETTE	UT	0	Fayette
84623	CHESTER	UT	0
84667	WALES	UT	0	Wales
84602	PROVO	UT	0	Provo	31

Station K220GE-FX

City LEVAN-UT

City , is located in DMAID: