Fix W242BH Station DMA

array(0) { }

*** DMA ***

array(12) { ["odbcts"]=> string(19) "2008-06-09 18:15:15" ["dmarank"]=> string(3) "261" ["dmaID"]=> string(3) "259" ["dmaType"]=> string(1) "C" ["Minority"]=> string(1) "B" ["QualType"]=> string(2) "QD" ["DMAName"]=> string(16) "Battle Creek, MI" ["Population25up"]=> string(6) "117100" ["scanned"]=> NULL ["AvgLatitude"]=> string(7) "42.2705" ["AvgLongitude"]=> string(8) "-84.9601" ["State"]=> string(2) "MI" }

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

array(22) { ["id"]=> string(4) "8783" ["State"]=> string(2) "MI" ["CityName"]=> string(8) "Marshall" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(2) "67" ["Population"]=> string(4) "6891" ["Latitude"]=> string(9) "42.270467" ["Longitude"]=> string(9) "-84.96005" ["PrimaryAC"]=> string(3) "269" ["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) "8783" ["Population2000"]=> string(4) "7459" ["FIPS"]=> string(7) "2651940" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "259" }

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

array(13) { ["zipcode"]=> string(5) "49068" ["zip3"]=> string(3) "490" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(8) "MARSHALL" ["zipstate"]=> string(2) "MI" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "42.26" ["iplongitude"]=> string(6) "-84.95" ["ziplocation"]=> string(17) "NA-US-MI-MARSHALL" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "7104" ["zippopulation"]=> string(5) "12659" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "490" ["zipcity"]=> string(9) "KALAMAZOO" ["zipstate"]=> string(2) "MI" }

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

array(22) { ["id"]=> string(4) "8725" ["State"]=> string(2) "MI" ["CityName"]=> string(9) "Kalamazoo" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "203" ["Population"]=> string(5) "80277" ["Latitude"]=> string(9) "42.279207" ["Longitude"]=> string(10) "-85.583902" ["PrimaryAC"]=> string(3) "269" ["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) "8725" ["Population2000"]=> string(5) "77145" ["FIPS"]=> string(7) "2642160" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "184" }

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

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
8783	MI	Marshall	-1	67	6891	42.270467	-84.96005	269		0		0	0	0	0	8783	7459	2651940	-5	-1	259

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

22 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
8725	MI	Kalamazoo	0	203	80277	42.279207	-85.583902	269		0		0	0	0	0	8725	77145	2642160	-5	-1	184
8891	MI	Portage	-1	0	41042	42.209592	-85.588525	616		0		0	0	0	0		44897	2665560	-5	-1	184
8478	MI	Benton Harbor	0	125	12818	42.11114	-86.448226	269		0		0	0	0	0	8478	11182	2607520	-5	-1	184
8974	MI	Sturgis	0	59	10130	41.798235	-85.416575	269		0		0	0	0	0	8974	11285	2676960	-5	-1	184
8685	MI	Hastings	0	74	6549	42.647299	-85.287005	269		0		0	0	0	0	8685	7095	2637120	-5	-1	184
8588	MI	Dowagiac	0	90	6409	41.984415	-86.108032	269		0		0	0	0	0	8588	6147	2622880	-5	-1	184
8958	MI	South Haven	0	87	5563	42.399123	-86.273121	269		0		0	0	0	0	8958	5021	2674980	-5	-1	184
8438	MI	Allegan	0	56	4547	42.528314	-85.851685	269		0		0	0	0	0	8438	4838	2601260	-5	-1	184
8864	MI	Otsego	-1	64	3937	42.457976	-85.698622	269		0		0	0	0	0	8864	3933	2661620	-5	-1	184
8872	MI	Paw Paw	-1	15	3169	42.217088	-85.890106	269		0		0	0	0	0	8872	3363	2662980	-5	-1	184
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
8497	MI	Bronson	0	91	2342	41.873485	-85.194119	517		0		0	0	0	0	8497	2421	2610860	-5	-1	184
8681	MI	Hartford	-1	54	2341	42.20614	-86.167759	269		0		0	0	0	0	8681	2476	2636960	-5	-1	184
9003	MI	Vicksburg	-1	53	2216	42.120481	-85.534188	269		0		0	0	0	0	9003	2320	2682300	-5	-1	184
8556	MI	Constantine	-1	4	2032	41.839589	-85.66468	269		0		0	0	0	0	8556	2095	2617840	-5	-1	184
8643	MI	Galesburg	-1	54	1863	42.289241	-85.419048	269		0		0	0	0	0	8643	1988	2631260	-5	-1	184
8523	MI	Cassopolis	0	16	1822	41.910713	-86.007885	269		0		0	0	0	0	8523	1740	2613900	-5	-1	184
8851	MI	Olivet	-1	45	1604	42.443213	-84.922198	269		0		0	0	0	0	8851	1758	2660580	-5	-1	184
8941	MI	Schoolcraft	0	103	1517	42.115191	-85.635212	269		0		0	0	0	0	8941	1587	2671860	-5	-1	184
8452	MI	Athens	-1	47	990	42.085906	-85.234793	269		0		0	0	0	0	8452	1111	2603880	-5	-1	184
8651	MI	Gobles	-1	3	769	42.360102	-85.879398	269		0		0	0	0	0	8651	815	2632640	-5	-1	184
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
8908	MI	Richland	-1	63	465	42.376489	-85.455659	269		0		0	0	0	0	8908	593	2668240	-5	-1	184
8911	MI	Riverside	-1	0		42.178035	-86.38557	616		0		0	0	0	0				-5	-1	184

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

74 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49009	KALAMAZOO	MI	32845	Kalamazoo	184
49024	PORTAGE	MI	24373	Portage	184
49015	BATTLE CREEK	MI	22475	Battle Creek	67
49022	BENTON HARBOR	MI	22263	Benton Harbor	184
49085	SAINT JOSEPH	MI	20883	Saint Joseph
49048	KALAMAZOO	MI	18574	Kalamazoo	184
49036	COLDWATER	MI	18378	Coldwater	121
49017	BATTLE CREEK	MI	17445	Battle Creek	67
49014	BATTLE CREEK	MI	16679	Battle Creek	67
49002	PORTAGE	MI	15993	Portage	184
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49091	STURGIS	MI	15930	Sturgis	184
49058	HASTINGS	MI	15617	Hastings	184
49001	KALAMAZOO	MI	15484	Kalamazoo	184
49093	THREE RIVERS	MI	14374	Three Rivers	178
49037	BATTLE CREEK	MI	14320	Battle Creek	67
49010	ALLEGAN	MI	14231	Allegan	184
49080	PLAINWELL	MI	13032	Plainwell
49004	KALAMAZOO	MI	12982	Kalamazoo	184
49006	KALAMAZOO	MI	12928	Kalamazoo	184
49068	MARSHALL	MI	12659	Marshall	259
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49008	KALAMAZOO	MI	11602	Kalamazoo	184
49047	DOWAGIAC	MI	11320	Dowagiac	184
49079	PAW PAW	MI	11301	Paw Paw	184
49090	SOUTH HAVEN	MI	11182	South Haven	184
49097	VICKSBURG	MI	9161	Vicksburg	184
49071	MATTAWAN	MI	8532	Mattawan
49078	OTSEGO	MI	7773	Otsego	184
49038	COLOMA	MI	7664	Coloma
49083	RICHLAND	MI	6387	Richland	184
49031	CASSOPOLIS	MI	6077	Cassopolis	184
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49046	DELTON	MI	5973	Delton
49007	KALAMAZOO	MI	5718	Kalamazoo	184
49053	GALESBURG	MI	5708	Galesburg	184
49065	LAWTON	MI	5697	Lawton
49087	SCHOOLCRAFT	MI	5556	Schoolcraft	184
49021	BELLEVUE	MI	5247	Bellevue
49057	HARTFORD	MI	5214	Hartford	184
49028	BRONSON	MI	5165	Bronson	184
49055	GOBLES	MI	5164	Gobles	184
49082	QUINCY	MI	5008	Quincy
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49098	WATERVLIET	MI	4796	Watervliet
49099	WHITE PIGEON	MI	4678	White Pigeon
49045	DECATUR	MI	4503	Decatur
49013	BANGOR	MI	4084	Bangor
49042	CONSTANTINE	MI	4056	Constantine	184
49073	NASHVILLE	MI	4000	Nashville
49067	MARCELLUS	MI	3737	Marcellus
49088	SCOTTS	MI	3473	Scotts
49094	UNION CITY	MI	3344	Union City
49076	OLIVET	MI	3277	Olivet	184
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49064	LAWRENCE	MI	3136	Lawrence
49012	AUGUSTA	MI	3124	Augusta
49056	GRAND JUNCTION	MI	3030	Grand Junction
49072	MENDON	MI	2691	Mendon
49096	VERMONTVILLE	MI	2678	Vermontville
49040	COLON	MI	2644	Colon
49032	CENTREVILLE	MI	2413	Centreville
49051	EAST LEROY	MI	2225
49070	MARTIN	MI	2102	Martin
49034	CLIMAX	MI	2071	Climax
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49030	BURR OAK	MI	2020	Burr Oak
49011	ATHENS	MI	1862	Athens	184
49092	TEKONSHA	MI	1824	Tekonsha
49026	BLOOMINGDALE	MI	1727	Bloomingdale
49043	COVERT	MI	1657	Covert
49033	CERESCO	MI	1650
49095	VANDALIA	MI	1576	Vandalia
49060	HICKORY CORNERS	MI	1566	Hickory Corners
49089	SHERWOOD	MI	1412	Sherwood
49050	DOWLING	MI	1395
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49029	BURLINGTON	MI	1383	Burlington
49061	JONES	MI	1361
49052	FULTON	MI	861	Fulton
49066	LEONIDAS	MI	570

***** stations in DMA*************

3 records found!

stationid	CallSign	Licensee	Service	citynamex	Statex	cityid
24866	WMLY-LP	MARSHALL CHRISTIAN RADIO	FL	Marshall	MI	8783
66247	W242BH	SMILE FM	FX	Marshall	MI	8783
8847	WBXX	TOWNSQUARE LICENSE, LLC	FM	Marshall	MI	8783

Station W242BH-FX

City Marshall-MI

City Marshall, MI is located in DMAID: