Fix WMRE AM Station DMA

array(0) { }

*** DMA ***

array(12) { ["odbcts"]=> string(19) "2008-06-09 18:15:11" ["dmarank"]=> string(3) "225" ["dmaID"]=> string(3) "225" ["dmaType"]=> string(1) "C" ["Minority"]=> string(1) "-" ["QualType"]=> string(2) "QD" ["DMAName"]=> string(14) "Winchester, VA" ["Population25up"]=> string(6) "155900" ["scanned"]=> NULL ["AvgLatitude"]=> string(7) "38.8709" ["AvgLongitude"]=> string(8) "-78.3913" ["State"]=> string(2) "VA" }
Database: media
SQL: select * from cities where CityName = 'CHARLES TOWN' and State = 'WV'

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: 1754178573.2078
End: 1754178573.2081
Elapsed time: 0.2899 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
21673 WV Charles Town -1 58 39.284237 -77.856211 304 0 0 0 0 0 2907 5414610 -5 -1

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

NULL

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

array(13) { ["zipcode"]=> string(5) "25414" ["zip3"]=> string(3) "254" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(12) "CHARLES TOWN" ["zipstate"]=> string(2) "WV" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "39.28" ["iplongitude"]=> string(6) "-77.85" ["ziplocation"]=> string(21) "NA-US-WV-CHARLES TOWN" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "7506" ["zippopulation"]=> string(5) "13677" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "254" ["zipcity"]=> string(11) "MARTINSBURG" ["zipstate"]=> string(2) "WV" }

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

array(22) { ["id"]=> string(5) "21756" ["State"]=> string(2) "WV" ["CityName"]=> string(11) "Martinsburg" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "185" ["Population"]=> string(5) "14073" ["Latitude"]=> string(9) "39.459207" ["Longitude"]=> string(10) "-77.967814" ["PrimaryAC"]=> string(3) "304" ["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) "21756" ["Population2000"]=> string(5) "14972" ["FIPS"]=> string(7) "5452060" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "166" }

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

9 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
20581	VA	Winchester	0	179	21947	39.178355	-78.166771	276	0		0	0	0	0	20581	23585	5186720	-5	-1	225
20336	VA	Front Royal	-1	100	11880	38.925768	-78.191914	276	0		0	0	0	0	20336	13589	5129968	-5	-1	225
20534	VA	Strasburg	-1	0	3762	38.99055	-78.358615	540	0		0	0	0	0	20534	4017	5176000	-5	-1	225
20584	VA	Woodstock	-1	0	3182	38.877075	-78.511521	540	0		0	0	0	0	20584	3952	5187712	-5	-1	225
20209	VA	Berryville	-1	11	3097	39.150973	-77.982395	540	0		0	0	0	0	20209	2963	5106968	-5	-1	225
20317	VA	Elkton	-1	36	1935	38.408298	-78.620321	540	0		0	0	0	0	20317	2042	5125408	-5	-1	225
20531	VA	Stephens City	0	4		39.086098	-78.219601	540	0		0	0	0	0	20531	1146	5175344	-5	-1	225
63658	VA	Gore		12					0	0	0	0	0	0	63658			-5	-1	225
80023	VA	Flint Hill	-1																0	225

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

19 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
8038	MD	Frederick	0	218	40148	39.426294	-77.420403	301		0		0	0	0	0	8038	52767	2430325	-5	-1	166
8048	MD	Hagerstown	0	184	35445	39.642771	-77.719954	301		0		0	0	0	0	8048	36687	2436075	-5	-1	166
16388	PA	Chambersburg	0	142	16647	39.934813	-77.656352	717		0		0	1	0	0	16388	17862	4212536	-5	-1	166
21756	WV	Martinsburg	0	185	14073	39.459207	-77.967814	304		0		0	0	0	0	21756	14972	5452060	-5	-1	166
17095	PA	Waynesboro	-1	73	9578	39.753685	-77.58198	717		0		0	0	0	0	17095	9614	4281824	-5	-1	166
8039	MD	Frostburg	-1	62	8075	39.654687	-78.927773	301		0		0	0	0	0	8039	7873	2430900	-5	-1	166
36094	MD	Braddock Heights	-1	0	4778	39.420895	-77.504931			0		0	0	0	0		4627	2409100	-5	-1	166
8151	MD	Walkersville	-1	0	4145	39.484846	-77.348943	301		0		0	0	0	0	8151	5192	2481275	-5	-1	166
16551	PA	Greencastle	-1	13	3600	39.789466	-77.726604	717		0		0	0	0	0	16551	3722	4230896	-5	-1	166
8178	MD	Williamsport	-1	0	2103	39.598496	-77.818464	301		0		0	0	0	0	8178	1868	2485100	-5	-1	166
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
8050	MD	Hancock	-1	61	1926	39.701937	-78.180802	240		0		0	0	0	0	8050	1725	2436600	-5	-1	166
8077	MD	Middletown	0	13	1834	39.441155	-77.543761	301		0		0	0	0	0	8077	2668	2452425	-5	-1	166
8030	MD	Emmitsburg	-1	46	1688	39.704697	-77.325294	240		0		0	0	0	0	8030	2290	2426200	-5	-1	166
16725	PA	Mercersburg	-1	0	1640	39.829388	-77.901952	717		0		0	0	0	0	16725	1540	4248704	-5	-1	166
16807	PA	Newville	-1	12	1349	40.169614	-77.402029	717		0		0	0	0	0	16807	1367	4254320	-5	-1	166
21815	WV	Shepherdstown	-1	0	1287	39.432005	-77.806108	304		0		0	0	0	0	21815	803	5473468	-5	-1	166
21651	WV	Berkeley Springs	0	112	735	39.625469	-78.227133	304		0		0	0	0	0	21651			-5	-1	166
8085	MD	Myersville	0	77	464	39.506627	-77.566271	301		0		0	0	0	0	8085	1382	2454875	-5	-1	166
16802	PA	Newburg	-1	40	117	40.137528	-77.555696	717		0		0	0	0	0	16802	372	4253344	-5	-1	166

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

24 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
25404	MARTINSBURG	WV	14198	Martinsburg	166
25414	CHARLES TOWN	WV	13677	Charles Town
25427	HEDGESVILLE	WV	11492	Hedgesville
25401	MARTINSBURG	WV	10936	Martinsburg	166
25411	BERKELEY SPRINGS	WV	10129	Berkeley Springs	166
25425	HARPERS FERRY	WV	10035	Harpers Ferry
25403	MARTINSBURG	WV	9792	Martinsburg	166
25405	MARTINSBURG	WV	8929	Martinsburg	166
25428	INWOOD	WV	8680	Inwood
25419	FALLING WATERS	WV	7866	Falling Waters
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
25430	KEARNEYSVILLE	WV	6639
25413	BUNKER HILL	WV	6154
25443	SHEPHERDSTOWN	WV	5438	Shepherdstown	166
25438	RANSON	WV	5046
25420	GERRARDSTOWN	WV	3295
25442	SHENANDOAH JUNCTION	WV	1602
25434	PAW PAW	WV	1558	Paw Paw
25446	SUMMIT POINT	WV	1147
25422	GREAT CACAPON	WV	1116
25444	SLANESVILLE	WV	712
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
25421	GLENGARY	WV	0
25432	MILLVILLE	WV	0
25431	LEVELS	WV	0	Levels
25437	POINTS	WV	0

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

31 records found!

stationid	CallSign	Licensee	Service	citynamex	Statex	cityid
15461	WMRE	IHM LICENSES, LLC	AM	CHARLES TOWN	WV
8387	WACL	IHM LICENSES, LLC	FM	Elkton	VA	20317
59133	WXDM	CHRISTENDOM EDUCATIONAL CORPORATION	FM	Front Royal	VA	20336
9520	WFQX	IHM LICENSES, LLC	FM	Front Royal	VA	20336
59398	W255CK	POSITIVE ALTERNATIVE RADIO, INC.	FX	Front Royal	VA	20336
2645	WFTR	ROYAL BROADCASTING, INC.	AM	Front Royal	VA	20336
12915	WZRV	ROYAL BROADCASTING, INC.	FM	Front Royal	VA	20336
11882	WSIG	TIDEWATER COMMUNICATIONS, LLC	FM	Mount Jackson	VA	20433
41998	WKSI	IHM LICENSES, LLC	FM	Stephens City	VA	20531
15417	WKSI	IHM LICENSES, LLC	FM	Stephens City	VA	20531
stationid	CallSign	Licensee	Service	citynamex	Statex	cityid
137305	WVRX	POINT FM MINISTRIES, INC.	FM	Strasburg	VA	20534
12123	WTRM	AMERICAN FAMILY ASSOCIATION, INC.	FM	Winchester	VA	20581
25614	W267AK	BIBLE BROADCASTING NETWORK, INC.	FX	Winchester	VA	20581
59613	WHFW	CHRISTENDOM EDUCATIONAL CORPORATION	FM	Winchester	VA	20581
126251	W275BV	CITY COMMONS LLC VA SERIES A	FX	Winchester	VA	20581
2941	WINC	COLONIAL RADIO GROUP OF WILLIAMSPORT, LLC	AM	Winchester	VA	20581
137017	WAIW	EDUCATIONAL MEDIA FOUNDATION	FM	Winchester	VA	20581
9944	WINC	EUCLID AVENUE PROPERTIES, LLC	FM	Winchester	VA	20581
66211	W239BV	IHM LICENSES, LLC	FX	Winchester	VA	20581
41844	WUSQ	IHM LICENSES, LLC	FM	Winchester	VA	20581
stationid	CallSign	Licensee	Service	citynamex	Statex	cityid
12229	WUSQ	IHM LICENSES, LLC	FM	Winchester	VA	20581
30544	W233AA	JAMES MADISON UNIVERSITY BOARD OF VISITORS	FX	Winchester	VA	20581
68649	W271BR	POSITIVE ALTERNATIVE RADIO, INC.	FX	Winchester	VA	20581
76689	W279CV	POSITIVE ALTERNATIVE RADIO, INC.	FX	Winchester	VA	20581
134871	W292CI	POSITIVE ALTERNATIVE RADIO, INC.	FX	Winchester	VA	20581
40135	WXVA	WINCHESTER RADIO BROADCASTERS, LLC	AM	Winchester	VA	20581
8601	WAZR	IHM LICENSES, LLC	FM	Woodstock	VA	20584
71538	WUDS-LP	MASSANUTTEN MILITARY ACADEMY	FL	Woodstock	VA	20584
1941	WAMM	SHENANDOAH VALLEY GROUP, INC.	AM	Woodstock	VA	20584
56248	WVRS	POINT FM MINISTRIES, INC.	FM	Gore	VA	63658
stationid	CallSign	Licensee	Service	citynamex	Statex	cityid
30799	W243AF	POSITIVE ALTERNATIVE RADIO, INC.	FX	Flint Hill	VA	80023

Station WMRE-AM

City CHARLES TOWN-WV

City , is located in DMAID: