Fix KVMK FM 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 = 'WHEELOCK' and State = 'TX'

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

Number of rows returned = 0
Start: 1754178677.3839
End: 1754178677.3842
Elapsed time: 0.2320 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('TX','Wheelock',-1)

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

array(22) { ["id"]=> string(5) "80236" ["State"]=> string(2) "TX" ["CityName"]=> string(8) "Wheelock" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> NULL ["Population"]=> NULL ["Latitude"]=> NULL ["Longitude"]=> NULL ["PrimaryAC"]=> NULL ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> NULL ["ISPCount"]=> NULL ["CovadDSL"]=> NULL ["VerizonDSL"]=> NULL ["allegiance"]=> NULL ["SBC"]=> NULL ["RateCenterCityid"]=> NULL ["Population2000"]=> NULL ["FIPS"]=> NULL ["cTZoffset"]=> NULL ["DST"]=> string(1) "0" ["DMAID"]=> NULL }

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

array(13) { ["zipcode"]=> string(5) "77882" ["zip3"]=> string(3) "778" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(8) "WHEELOCK" ["zipstate"]=> string(2) "TX" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "30.91" ["iplongitude"]=> string(6) "-96.38" ["ziplocation"]=> string(17) "NA-US-TX-WHEELOCK" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }

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

array(3) { ["zip3"]=> string(3) "778" ["zipcity"]=> string(5) "BRYAN" ["zipstate"]=> string(2) "TX" }

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

array(22) { ["id"]=> string(5) "18953" ["State"]=> string(2) "TX" ["CityName"]=> string(5) "Bryan" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "215" ["Population"]=> string(5) "55002" ["Latitude"]=> string(9) "30.665547" ["Longitude"]=> string(10) "-96.366745" ["PrimaryAC"]=> string(3) "979" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "0" ["VerizonDSL"]=> string(1) "1" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "18953" ["Population2000"]=> string(5) "65660" ["FIPS"]=> string(7) "4810912" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "239" }

**** 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
18953	TX	Bryan	0	215	55002	30.665547	-96.366745	979		0		0	1	0	0	18953	65660	4810912	-6	-1	239
19035	TX	College Station	0	0	52456	30.601433	-96.314464	409		0		0	0	0	0		67890	4815976	-6	-1	239
18938	TX	Brenham	-1	183	11952	30.161901	-96.397004	979		0		0	0	0	0	18938	13507	4810156	-6	-1	239
19583	TX	Navasota	-1	25	6296	30.388005	-96.085951	936		0		0	0	0	0	19583	6789	4850472	-6	-1	239
18977	TX	Cameron	-1	20	5580	30.854544	-96.978716	254		0		0	0	0	0	18977	5634	4812040	-6	-1	239
19290	TX	Hearne	-1	0	5132	30.877989	-96.595665	979		0		0	0	0	0	19290	4690	4832972	-6	-1	239
19480	TX	Madisonville	-1	103	3569	30.950915	-95.912623	936		0		0	0	0	0	19480	4159	4845996	-6	-1	239
18975	TX	Caldwell	0	93	3181	30.52858	-96.70035	979		0		0	0	0	0	18975	3449	4811836	-6	-1	239
19846	TX	Somerville	-1	49	1542	30.344616	-96.530335	979		0		0	0	0	0	19846	1704	4868720	-6	-1	239
19202	TX	Franklin	-1	0	1336	31.026222	-96.486086	979		0		0	0	0	0	19202	1470	4827288	-6	-1	239
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
19402	TX	Kurten	-1	62		30.65212	-96.341012	979		0		0	0	0	0	19402			-6	-1	239
18878	TX	Bedias	-1	19		30.706523	-95.954649	936		0		0	0	0	0	18878			-6	-1	239

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

25 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
77845	COLLEGE STATION	TX	35385	College Station	239
77803	BRYAN	TX	20368	Bryan	239
77833	BRENHAM	TX	19892	Brenham	239
77840	COLLEGE STATION	TX	17629	College Station	239
77802	BRYAN	TX	17103	Bryan	239
77868	NAVASOTA	TX	9960	Navasota	239
77808	BRYAN	TX	8997	Bryan	239
77836	CALDWELL	TX	8783	Caldwell	239
77801	BRYAN	TX	7685	Bryan	239
77807	BRYAN	TX	6276	Bryan	239
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
77864	MADISONVILLE	TX	5881	Madisonville	239
77859	HEARNE	TX	5428	Hearne	239
77856	FRANKLIN	TX	3468	Franklin	239
77879	SOMERVILLE	TX	3257	Somerville	239
77871	NORMANGEE	TX	2796	Normangee
77831	BEDIAS	TX	2191	Bedias	239
77830	ANDERSON	TX	2140	Anderson
77835	BURTON	TX	2021	Burton
77861	IOLA	TX	1815	Iola
77880	WASHINGTON	TX	1439	Washington
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
77872	NORTH ZULCH	TX	1365	North Zulch
77865	MARQUEZ	TX	1311	Marquez
77837	CALVERT	TX	1213	Calvert
77873	RICHARDS	TX	964	Richards
77853	DIME BOX	TX	847	Dime Box

Station KVMK-FM

City WHEELOCK-TX

City Wheelock, TX is located in DMAID: