Fix WYKR 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) "" }

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

array(22) { ["id"]=> string(5) "80096" ["State"]=> string(2) "NH" ["CityName"]=> string(9) "Haverhill" ["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) "03765" ["zip3"]=> string(3) "037" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(9) "HAVERHILL" ["zipstate"]=> string(2) "NH" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "44.03" ["iplongitude"]=> string(6) "-72.06" ["ziplocation"]=> string(18) "NA-US-NH-HAVERHILL" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }

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

array(3) { ["zip3"]=> string(3) "037" ["zipcity"]=> string(9) "CLAREMONT" ["zipstate"]=> string(2) "NH" }

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

array(22) { ["id"]=> string(5) "12398" ["State"]=> string(2) "NH" ["CityName"]=> string(9) "Claremont" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "207" ["Population"]=> string(5) "13902" ["Latitude"]=> string(9) "43.377207" ["Longitude"]=> string(10) "-72.344555" ["PrimaryAC"]=> string(3) "603" ["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) "12398" ["Population2000"]=> string(5) "13151" ["FIPS"]=> string(7) "3312900" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "180" }

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

No Rows in Recordset!

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

23 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
12437	NH	Keene	0	280	22430	42.942452	-72.288368	603		0		0	1	0	0	12437	22563	3339300	-5	-1	180
20695	VT	Rutland	0	186	18230	43.607666	-72.974076	802		0		0	1	0	0	20695	17292	5061225	-5	-1	180
12398	NH	Claremont	0	207	13902	43.377207	-72.344555	603		0		0	1	0	0	12398	13151	3312900	-5	-1	180
12441	NH	Lebanon	0	104	12183	43.643897	-72.255242	603		0		0	0	0	0	12441	12568	3341300	-5	-1	180
20596	VT	Barre	-1	99	9482	44.198433	-72.501411	802		0		0	1	0	0	20596	9291	5003175	-5	-1	180
12428	NH	Hanover	0	161	6538	43.703708	-72.281371	603		0		0	0	0	0	12428	8162	3333780	-5	-1	180
20658	VT	Middlebury	-1	152	6007	44.014153	-73.163784	802		0		0	0	0	0	20658	6252	5044275	-5	-1	180
12443	NH	Littleton	0	230	4633	44.30708	-71.766795	603		0		0	0	0	0	12443	4431	3342500	-5	-1	180
12466	NH	Newport	0	204	3772	43.366338	-72.171396	603		0		0	0	0	0	12466	4008	3352500	-5	-1	180
12476	NH	Peterborough	0	232	2685	42.877909	-71.954886	603		0		0	0	0	0	12476	2944	3360500	-5	-1	180
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
20724	VT	West Rutland	-1	50	2246	43.595199	-73.048941	802		0		0	0	0	0	20724	2263	5082375	-5	-1	180
20671	VT	Northfield	-1	4	1889	44.151137	-72.657408	802		0		0	0	0	0	20671	3208	5050200	-5	-1	180
20683	VT	Poultney	-1	51	1731	43.517573	-73.235449	802		0		0	0	0	0	20683	1575	5056800	-5	-1	180
12432	NH	Hinsdale	-1	50	1718	42.788269	-72.487862	603		0		0	0	0	0	12432	1713	3336580	-5	-1	180
12442	NH	Lisbon	-1	47	1246	44.213256	-71.908196	603		0		0	0	0	0	12442	1070	3341940	-5	-1	180
41785	VT	Hyde Park	-1	0	457	44.594876	-72.614954			0		0	0	0	0		415	5034975	-5	-1	180
20694	VT	Rupert	-1	21		43.026984	-73.055156	802		0		0	0	0	0	20694			-5	-1	180
20682	VT	Plainfield	-1	50		44.283708	-72.552243	802		0		0	0	0	0	20682			-5	-1	180
20637	VT	Grand Isle	-1	98		44.723391	-73.303193	802		0		0	1	0	0	20637			-5	-1	180
12486	NH	Rindge	0	153		42.76509	-72.00912	603		0		0	0	0	0	12486			-5	-1	180
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
12462	NH	New London	-1	7		43.301663	-71.733643	603		0		0	0	0	0	12462			-5	-1	180
12407	NH	Dublin	-1	49		42.889124	-72.018993	603		0		0	0	0	0	12407			-5	-1	180
63587	NH	West Lebanon		49				603		0		0	0	0	0	63587			-5	-1	180

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

23 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
03743	CLAREMONT	NH	11223	Claremont	180
03766	LEBANON	NH	7995	Lebanon	180
03773	NEWPORT	NH	6469	Newport	180
03755	HANOVER	NH	6375	Hanover	180
03748	ENFIELD	NH	4101	Enfield
03741	CANAAN	NH	3514	Canaan
03784	WEST LEBANON	NH	3344	West Lebanon	180
03753	GRANTHAM	NH	3044
03782	SUNAPEE	NH	2498	Sunapee
03785	WOODSVILLE	NH	1755	Woodsville
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
03781	PLAINFIELD	NH	1532	Plainfield
03774	NORTH HAVERHILL	NH	1497	North Haverhill
03768	LYME	NH	1480	Lyme
03745	CORNISH	NH	1083
03777	ORFORD	NH	1064	Orford
03750	ETNA	NH	1061
03740	BATH	NH	868
03771	MONROE	NH	734	Monroe
03752	GOSHEN	NH	727
03779	PIERMONT	NH	675	Piermont
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
03770	MERIDEN	NH	662	Meriden
03765	HAVERHILL	NH	0	Haverhill
03780	PIKE	NH	0	Pike

Station WYKR-FM

City Haverhill-NH

City Haverhill, NH is located in DMAID: