Fix WVMM FM Station DMA

array(0) { }

*** DMA ***

array(12) { ["odbcts"]=> string(19) "2019-07-16 06:29:49" ["dmarank"]=> string(4) "9999" ["dmaID"]=> string(4) "9999" ["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 = 'GRANTHAM' and State = 'PA'

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

Number of rows returned = 0
Start: 1754196402.6234
End: 1754196402.6236
Elapsed time: 0.1409 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('PA','Grantham',-1)

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

array(22) { ["id"]=> string(5) "80372" ["State"]=> string(2) "PA" ["CityName"]=> string(8) "Grantham" ["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) "17027" ["zip3"]=> string(3) "170" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(8) "GRANTHAM" ["zipstate"]=> string(2) "PA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "40.23" ["iplongitude"]=> string(6) "-77.02" ["ziplocation"]=> string(17) "NA-US-PA-GRANTHAM" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "289" ["zippopulation"]=> string(3) "439" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "170" ["zipcity"]=> string(13) "MECHANICSBURG" ["zipstate"]=> string(2) "PA" }

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

array(22) { ["id"]=> string(5) "16720" ["State"]=> string(2) "PA" ["CityName"]=> string(13) "Mechanicsburg" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(2) "93" ["Population"]=> string(4) "9452" ["Latitude"]=> string(9) "40.212089" ["Longitude"]=> string(10) "-77.006143" ["PrimaryAC"]=> string(3) "717" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "1" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "16720" ["Population2000"]=> string(4) "9042" ["FIPS"]=> string(7) "4248376" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "78" }

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

No Rows in Recordset!

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

16 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
16565	PA	Harrisburg	0	0	52376	40.269789	-76.875613	717		1		0	0	0	0		48950	4232800	-5	-1	78
16658	PA	Lebanon	0	163	24800	40.341529	-76.420853	717		0		1	1	0	0	16658	24461	4242168	-5	-1	78
16376	PA	Carlisle	0	161	18419	40.202553	-77.195016	717		0		0	1	0	0	16376	17970	4211272	-5	-1	78
16495	PA	Ephrata	-1	4	12133	40.180744	-76.182427	717		0		0	0	0	0	16495	13213	4223832	-5	-1	78
16584	PA	Hershey	0	136	11860	40.278423	-76.65124	717		0		1	1	0	0	16584	12771	4234144	-5	-1	78
16483	PA	Elizabethtown	-1	80	9952	40.153207	-76.600431	717		0		0	1	0	0	16483	11887	4223016	-5	-1	78
16720	PA	Mechanicsburg	0	93	9452	40.212089	-77.006143	717		0		1	1	0	0	16720	9042	4248376	-5	-1	78
16833	PA	Palmyra	-1	69	6910	40.30796	-76.593782	717		0		1	1	0	0	16833	7096	4257720	-5	-1	78
16731	PA	Middletown	-1	112	6866	40.645898	-75.327822	717		0		0	1	0	0	16731	7378	4249144	-5	-1	78
16738	PA	Millersburg	-1	0	2729	40.541676	-76.957283	717		0		0	0	0	0	16738	2562	4249680	-5	-1	78
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
39692	PA	Burnham	-1	0	2197	40.635137	-77.564678			0		0	0	0	0		2144	4210256	-5	-1	78
40005	PA	Milroy	-1	0	1456	40.713936	-77.585275			0		0	0	0	0		1386	4250000	-5	-1	78
16557	PA	Halifax	-1	49	911	40.467623	-76.931156	717		0		0	1	0	0	16557	875	4232032	-5	-1	78
16735	PA	Mifflintown	-1	22	866	40.570728	-77.395488	717		0		0	0	0	0	16735	861	4249304	-5	-1	78
69522	PA	Mexico		0	0	40.543341	-77.354771			0	0	0	0	0	0	0	279	4248904	-5	-1	78
16313	PA	Beaver Springs	-1	2		40.744464	-77.214598	570		0		0	0	0	0	16313	634	4204824	-5	-1	78

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

68 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
17042	LEBANON	PA	31671	Lebanon	78
17055	MECHANICSBURG	PA	31415	Mechanicsburg	78
17050	MECHANICSBURG	PA	29639	Mechanicsburg	78
17011	CAMP HILL	PA	28574	Camp Hill
17013	CARLISLE	PA	27763	Carlisle	78
17046	LEBANON	PA	24928	Lebanon	78
17022	ELIZABETHTOWN	PA	24660	Elizabethtown	78
17036	HUMMELSTOWN	PA	20463	Hummelstown
17015	CARLISLE	PA	19054	Carlisle	78
17057	MIDDLETOWN	PA	18622	Middletown	78
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
17078	PALMYRA	PA	18518	Palmyra	78
17044	LEWISTOWN	PA	16868	Lewistown	254
17019	DILLSBURG	PA	15958	Dillsburg
17025	ENOLA	PA	14850	Enola
17070	NEW CUMBERLAND	PA	14615	New Cumberland
17033	HERSHEY	PA	13190	Hershey	78
17067	MYERSTOWN	PA	12456	Myerstown
17003	ANNVILLE	PA	9333	Annville
17020	DUNCANNON	PA	7807	Duncannon
17032	HALIFAX	PA	7247	Halifax	78
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
17038	JONESTOWN	PA	7158	Jonestown	213
17074	NEWPORT	PA	6280	Newport
17059	MIFFLINTOWN	PA	6026	Mifflintown	78
17061	MILLERSBURG	PA	5854	Millersburg	78
17007	BOILING SPRINGS	PA	5354	Boiling Springs
17043	LEMOYNE	PA	5157	Lemoyne
17090	SHERMANS DALE	PA	4609
17053	MARYSVILLE	PA	4585	Marysville
17073	NEWMANSTOWN	PA	4480	Newmanstown
17018	DAUPHIN	PA	4070	Dauphin
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
17066	MOUNT UNION	PA	4009	Mount Union	254
17065	MOUNT HOLLY SPRINGS	PA	3792	Mount Holly Springs
17084	REEDSVILLE	PA	3704	Reedsville
17004	BELLEVILLE	PA	3683	Belleville
17051	MC VEYTOWN	PA	3613
17068	NEW BLOOMFIELD	PA	3577	New Bloomfield
17062	MILLERSTOWN	PA	3470	Millerstown
17028	GRANTVILLE	PA	3221
17026	FREDERICKSBURG	PA	3214	Fredericksburg
17023	ELIZABETHVILLE	PA	2913	Elizabethville	213
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
17048	LYKENS	PA	2895	Lykens
17045	LIVERPOOL	PA	2805	Liverpool
17082	PORT ROYAL	PA	2754	Port Royal
17063	MILROY	PA	2699	Milroy	78
17049	MC ALISTERVILLE	PA	2680
17087	RICHLAND	PA	2418	Richland
17040	LANDISBURG	PA	2260	Landisburg
17034	HIGHSPIRE	PA	2155	Highspire
17098	WILLIAMSTOWN	PA	2055	Williamstown
17047	LOYSVILLE	PA	2050	Loysville
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
17094	THOMPSONTOWN	PA	1986	Thompsontown
17086	RICHFIELD	PA	1974	Richfield
17009	BURNHAM	PA	1673	Burnham	78
17024	ELLIOTTSBURG	PA	1648
17017	DALMATIA	PA	1547
17058	MIFFLIN	PA	1462	Mifflin
17052	MAPLETON DEPOT	PA	1395
17060	MILL CREEK	PA	1046	Mill Creek
17099	YEAGERTOWN	PA	998	Yeagertown
17021	EAST WATERFORD	PA	861	East Waterford
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
17006	BLAIN	PA	837	Blain
17037	ICKESBURG	PA	809	Ickesburg
17030	GRATZ	PA	776	Gratz
17035	HONEY GROVE	PA	681
17002	ALLENSVILLE	PA	513	Allensville
17014	COCOLAMUS	PA	0
17029	GRANVILLE	PA	0
17076	OAKLAND MILLS	PA	0

Station WVMM-FM

City GRANTHAM-PA

City Grantham, PA is located in DMAID: