Fix WZMV 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 = 'MOHRSVILLE' and State = 'PA'

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: 1754172950.8005
End: 1754172950.8006
Elapsed time: 0.1600 ms No Rows in Recordset!

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

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

array(22) { ["id"]=> string(5) "80097" ["State"]=> string(2) "PA" ["CityName"]=> string(10) "Mohrsville" ["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) "19541" ["zip3"]=> string(3) "195" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(10) "MOHRSVILLE" ["zipstate"]=> string(2) "PA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "40.47" ["iplongitude"]=> string(6) "-76.02" ["ziplocation"]=> string(19) "NA-US-PA-MOHRSVILLE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "2168" ["zippopulation"]=> string(4) "3997" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "195" ["zipcity"]=> string(9) "BOYERTOWN" ["zipstate"]=> string(2) "PA" }

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

array(22) { ["id"]=> string(5) "16349" ["State"]=> string(2) "PA" ["CityName"]=> string(9) "Boyertown" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(1) "0" ["Population"]=> string(4) "3759" ["Latitude"]=> string(9) "40.331329" ["Longitude"]=> string(10) "-75.636087" ["PrimaryAC"]=> string(3) "610" ["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) "16349" ["Population2000"]=> string(4) "3940" ["FIPS"]=> string(7) "4207960" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "68" }

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

No Rows in Recordset!

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

20 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
16288	PA	Allentown	0	367	105090	40.601697	-75.477328	610		0		1	1	1	0	16288	106632	4202000	-5	-1	68
16581	PA	Hazleton	0	88	24730	40.958834	-75.974546	570		0		0	0	0	0	16581	23329	4233408	-5	-1	68
7667	MA	Newburyport	0	139	16317	16317	-70.87744	978		0		1	1	0	0	7667			-5	-1	68
12617	NJ	Hopatcong	0	114	15586	40.93865	-74.664462	973		0		0	1	1	0	12617	15888	3432910	-5	-1	68
12606	NJ	Hackettstown	0	270	8120	40.853248	-74.829351	908		0		0	1	1	0	12606	10403	3428710	-5	-1	68
17037	PA	Tamaqua	-1	52	7943	40.7986	-75.966498	570		0		0	0	0	0	17037	7174	4276032	-5	-1	68
12748	NJ	Washington	0	181	6474	40.760532	-74.979231	908		0		0	1	1	0	12748	6712	3477270	-5	-1	68
16663	PA	Lehighton	-1	106	5914	40.831932	-75.714701	610		0		0	0	0	0	16663	5537	4242472	-5	-1	68
17029	PA	Stroudsburg	-1	112	5312	40.985764	-75.195352	570		0		0	0	0	0	17029	5756	4274888	-5	-1	68
16641	PA	Kutztown	0	143	4704	40.519798	-75.77526	610		0		0	1	1	0	16641	5067	4240656	-5	-1	68
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
16653	PA	Lansford	-1	1	4583	40.831527	-75.883316	570		0		0	0	0	0	16653	4230	4241464	-5	-1	68
16559	PA	Hamburg	0	92	3987	40.556271	-75.982667	484		0		0	0	0	0	16559	4114	4232120	-5	-1	68
16526	PA	Freeland	-1	13	3909	41.019634	-75.89583	570		0		0	0	0	0	16526	3643	4227744	-5	-1	68
16349	PA	Boyertown	-1	0	3759	40.331329	-75.636087	610		0		0	0	0	0	16349	3940	4207960	-5	-1	68
12664	NJ	Netcong	0	207	3311	40.897548	-74.704356	973		0		0	1	1	0	12664	2580	3450130	-5	-1	68
12534	NJ	Belvidere	-1	44	2669	40.828299	-75.076496	908		0		0	0	0	0	12534	2771	3404990	-5	-1	68
40244	PA	Temple	-1	0	1491	40.4083	-75.921035			0		0	0	0	0				-5	-1	68
16662	PA	Leesport	0	0	1270	40.443893	-75.968137	717		0		0	0	0	0	16662	1805	4242352	-5	-1	68
39654	PA	Bechtelsville	-1	0	884	40.370078	-75.62859			0		0	0	0	0		931	4204896	-5	-1	68
12538	NJ	Blairstown	-1	50		40.942238	-74.937487	908		0		0	0	0	0	12538			-5	-1	68

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

28 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
19512	BOYERTOWN	PA	15010	Boyertown	68
19508	BIRDSBORO	PA	13937	Birdsboro
19522	FLEETWOOD	PA	13071	Fleetwood
19518	DOUGLASSVILLE	PA	13057	Douglassville
19525	GILBERTSVILLE	PA	12010	Gilbertsville
19540	MOHNTON	PA	10892	Mohnton
19526	HAMBURG	PA	9799	Hamburg	68
19530	KUTZTOWN	PA	9192	Kutztown	68
19565	WERNERSVILLE	PA	7511	Wernersville
19560	TEMPLE	PA	6965	Temple	68
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
19510	BLANDON	PA	6753
19506	BERNVILLE	PA	6458	Bernville
19533	LEESPORT	PA	5672	Leesport	68
19520	ELVERSON	PA	5150	Elverson
19543	MORGANTOWN	PA	4967	Morgantown
19567	WOMELSDORF	PA	4584	Womelsdorf
19551	ROBESONIA	PA	4573	Robesonia
19504	BARTO	PA	4491
19539	MERTZTOWN	PA	4176
19547	OLEY	PA	4118	Oley
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
19541	MOHRSVILLE	PA	3997	Mohrsville
19555	SHOEMAKERSVILLE	PA	3223	Shoemakersville
19505	BECHTELSVILLE	PA	3004	Bechtelsville	68
19507	BETHEL	PA	2863
19529	KEMPTON	PA	2697	Kempton
19562	TOPTON	PA	2093	Topton
19534	LENHARTSVILLE	PA	1862	Lenhartsville
19503	BALLY	PA	1099	Bally

Station WZMV-FM

City MOHRSVILLE-PA

City Mohrsville, PA is located in DMAID: