Fix K212DG 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 = 'BUSHLAND' and State = 'TX'

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

Number of rows returned = 1
Start: 1754169915.1662
End: 1754169915.1664
Elapsed time: 0.1369 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
80040 TX Bushland -1 0

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

NULL

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

array(13) { ["zipcode"]=> string(5) "79012" ["zip3"]=> string(3) "790" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(8) "BUSHLAND" ["zipstate"]=> string(2) "TX" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "35.19" ["iplongitude"]=> string(7) "-102.06" ["ziplocation"]=> string(17) "NA-US-TX-BUSHLAND" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "453" ["zippopulation"]=> string(3) "945" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "790" ["zipcity"]=> string(9) "PLAINVIEW" ["zipstate"]=> string(2) "TX" }

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

array(22) { ["id"]=> string(5) "19672" ["State"]=> string(2) "TX" ["CityName"]=> string(9) "Plainview" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(3) "265" ["Population"]=> string(5) "21700" ["Latitude"]=> string(9) "34.191204" ["Longitude"]=> string(11) "-101.718806" ["PrimaryAC"]=> string(3) "806" ["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(5) "19672" ["Population2000"]=> string(5) "22336" ["FIPS"]=> string(7) "4857980" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "195" }

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

No Rows in Recordset!

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

34 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
18813	TX	Amarillo	0	1133	157615	35.199252	-101.845163	806		0		0	0	0	0	18813	173627	4803000	-6	-1	195
19672	TX	Plainview	-1	265	21700	34.191204	-101.718806	806		0		0	0	0	0	19672	22336	4857980	-6	-1	195
19646	TX	Pampa	-1	209	19959	35.543005	-100.964744	806		0		0	0	0	0	19646	17887	4854912	-6	-1	195
18923	TX	Borger	-1	52	15675	35.662789	-101.401565	806		0		0	0	0	0	18923	14302	4809556	-6	-1	195
19299	TX	Hereford	-1	73	14745	34.821961	-102.398617	806		0		0	0	0	0	19299	14597	4833320	-6	-1	195
19129	TX	Dumas	-1	58	12871	35.862478	-101.966931	806		0		0	0	0	0	19129	13747	4821556	-6	-1	195
18984	TX	Canyon	-1	57	11365	34.979326	-101.925849	806		0		0	0	0	0	18984	12875	4812532	-6	-1	195
19658	TX	Perryton	-1	61	7607	36.391752	-100.806109	806		0		0	0	0	0	19658	7774	4856912	-6	-1	195
19082	TX	Dalhart	-1	105	6246	36.060856	-102.518656	806		0		0	0	0	0	19082	7237	4818524	-6	-1	195
19116	TX	Dimmitt	-1	36	4408	34.549052	-102.315355	806		0		0	0	0	0	19116	4375	4820464	-6	-1	195
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
19209	TX	Friona	-1	28	3688	34.638987	-102.721571	806		0		0	0	0	0	19209	3854	4827660	-6	-1	195
19852	TX	Spearman	-1	43	3197	36.19445	-101.194048	806		0		0	0	0	0	19852	3021	4869476	-6	-1	195
19526	TX	Memphis	-1	63	2465	34.726716	-100.54156	806		0		0	0	0	0	19526	2479	4847616	-6	-1	195
19973	TX	Wellington	-1	14	2456	34.854616	-100.213626	281		0		0	0	0	0	19973	2275	4877152	-6	-1	195
18981	TX	Canadian	-1	68	2417	35.910701	-100.38376	806		0		0	0	0	0	18981	2233	4812412	-6	-1	195
19647	TX	Panhandle	-1	39	2353	35.347409	-101.381997	806		0		0	0	0	0	19647	2589	4854960	-6	-1	195
19818	TX	Shamrock	-1	32	2286	35.217116	-100.247171	806		0		0	0	0	0	19818	2029	4867160	-6	-1	195
19868	TX	Stinnett	-1	12	2166	35.826231	-101.443617	806		0		0	0	0	0	19868	1936	4870340	-6	-1	195
19267	TX	Hale Center	-1	48	2067	34.064795	-101.84594	806		0		0	0	0	0	19267	2263	4831820	-6	-1	195
19871	TX	Stratford	-1	20	1781	36.336158	-102.071451	806		0		0	0	0	0	19871	1991	4870544	-6	-1	195
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
19882	TX	Sunray	-1	9	1729	36.01928	-101.82386	806		0		0	0	0	0	19882	1950	4871180	-6	-1	195
18924	TX	Bovina	-1	36	1549	34.515467	-102.888018	806		0		0	0	0	0	18924	1874	4809628	-6	-1	195
19986	TX	Wheeler	-1	11	1393	35.442424	-100.274068	806		0		0	0	0	0	19986	1378	4878208	-6	-1	195
18921	TX	Booker	-1	49	1236	36.453926	-100.538125	806		0		0	0	0	0	18921	1315	4809448	-6	-1	195
19025	TX	Claude	-1	19	1199	35.107524	-101.364094	806		0		0	0	0	0	19025	1313	4815196	-6	-1	195
19264	TX	Gruver	-1	64	1172	36.262731	-101.405143	806		0		0	0	0	0	19264	1162	4831412	-6	-1	195
19519	TX	McLean	-1	8	849	35.233836	-100.600055	806		0		0	0	0	0	19519	830	4845780	-6	-1	195
19434	TX	Lefors	-1	26	656	35.438787	-100.803721	806		0		0	0	0	0	19434	559	4842148	-6	-1	195
19191	TX	Follett	-1	40	441	36.43215	-100.141073	806		0		0	0	0	0	19191	412	4826328	-6	-1	195
19006	TX	Channing	-1	20	277	35.683612	-102.331817	806		0		0	0	0	0	19006	356	4814260	-6	-1	195
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
19934	TX	Umbarger	-1	6		34.96539	-101.895894	806		0		0	0	0	0	19934			-6	-1	195
17241	PR	Humacao	-1	18		18.138029	-65.788499	787		0		0	0	0	0	17241			-4	0	195
19284	TX	Hartley	-1	25		35.884358	-102.398395	806		0		0	0	0	0	19284	441	4832612	-6	-1	195
79532	TX	Kerrick		14						0	0	0	0	0	0	16283	0		-6	-1	195

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

53 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
79072	PLAINVIEW	TX	19711	Plainview	195
79045	HEREFORD	TX	15188	Hereford	195
79065	PAMPA	TX	15161	Pampa	195
79015	CANYON	TX	13932	Canyon	195
79029	DUMAS	TX	12948	Dumas	195
79007	BORGER	TX	11067	Borger	195
79070	PERRYTON	TX	8013	Perryton	195
79022	DALHART	TX	7294	Dalhart	195
79035	FRIONA	TX	4213	Friona	195
79036	FRITCH	TX	4126	Fritch
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
79088	TULIA	TX	3992	Tulia	182
79027	DIMMITT	TX	3692	Dimmitt	195
79014	CANADIAN	TX	3184	Canadian	195
79081	SPEARMAN	TX	3077	Spearman	195
79068	PANHANDLE	TX	2569	Panhandle	195
79041	HALE CENTER	TX	2371	Hale Center	195
79079	SHAMROCK	TX	2158	Shamrock	195
79095	WELLINGTON	TX	2057	Wellington	195
79064	OLTON	TX	2019	Olton
79083	STINNETT	TX	1988	Stinnett	195
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
79084	STRATFORD	TX	1911	Stratford	195
79096	WHEELER	TX	1776	Wheeler	195
79086	SUNRAY	TX	1748	Sunray	195
79009	BOVINA	TX	1683	Bovina	195
79019	CLAUDE	TX	1486	Claude	195
79040	GRUVER	TX	1479	Gruver	195
79005	BOOKER	TX	1336	Booker	195
79043	HART	TX	1136	Hart
79052	KRESS	TX	1039	Kress
79097	WHITE DEER	TX	1013	White Deer
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
79092	VEGA	TX	996	Vega
79031	EARTH	TX	983	Earth
79057	MCLEAN	TX	957	McLean	195
79042	HAPPY	TX	926	Happy
79059	MIAMI	TX	671	Miami
79044	HARTLEY	TX	659	Hartley	195
79039	GROOM	TX	646	Groom
79063	NAZARETH	TX	615	Nazareth
79034	FOLLETT	TX	546	Follett	195
79087	TEXLINE	TX	546	Texline
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
79080	SKELLYTOWN	TX	471	Skellytown
79001	ADRIAN	TX	0	Adrian
79011	BRISCOE	TX	0
79018	CHANNING	TX	0	Channing	195
79058	MASTERSON	TX	0
79094	WAYSIDE	TX	0
79085	SUMMERFIELD	TX	0	Summerfield
79046	HIGGINS	TX	0	Higgins
79056	LIPSCOMB	TX	0	Lipscomb
79061	MOBEETIE	TX	0	Mobeetie
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
79062	MORSE	TX	0	Morse
79082	SPRINGLAKE	TX	0	Springlake
79098	WILDORADO	TX	0	Wildorado

Station K212DG-FX

City BUSHLAND-TX

City , is located in DMAID: