Fix WNNZ 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 = 'DEERFIELD' and State = 'MA'

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

Number of rows returned = 0
Start: 1754169017.9028
End: 1754169017.9038
Elapsed time: 0.9530 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('MA','Deerfield',-1)

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

array(22) { ["id"]=> string(5) "80031" ["State"]=> string(2) "MA" ["CityName"]=> string(9) "Deerfield" ["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) "01342" ["zip3"]=> string(3) "013" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(9) "DEERFIELD" ["zipstate"]=> string(2) "MA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "42.55" ["iplongitude"]=> string(5) "-72.6" ["ziplocation"]=> string(18) "NA-US-MA-DEERFIELD" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "703" ["zippopulation"]=> string(4) "1238" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "013" ["zipcity"]=> string(10) "GREENFIELD" ["zipstate"]=> string(2) "MA" }

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

array(22) { ["id"]=> string(4) "7594" ["State"]=> string(2) "MA" ["CityName"]=> string(10) "Greenfield" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "209" ["Population"]=> string(5) "14016" ["Latitude"]=> string(9) "42.592709" ["Longitude"]=> string(10) "-72.599584" ["PrimaryAC"]=> string(3) "413" ["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(4) "7594" ["Population2000"]=> string(5) "13716" ["FIPS"]=> string(7) "2527060" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "82" }

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

No Rows in Recordset!

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

11 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
7761	MA	Westfield	-1	31	38372	42.129492	-72.745986	413		0		0	1	0	0	7761	40072	2576030	-5	-1	82
7674	MA	Northampton	0	104	29289	42.327389	-72.657677	413		0		0	1	0	0	7674	28978	2546330	-5	-1	82
36069	MA	West Springfield	-1	0	27537	42.112793	-72.640665			0		0	0	0	0		27899	2577885	-5	-1	82
7505	MA	Amherst	0	89	17824	42.375121	-72.519989	413		0		0	1	0	0	7505			-5	-1	82
7594	MA	Greenfield	0	209	14016	42.592709	-72.599584	413		0		0	1	0	0	7594	13716	2527060	-5	-1	82
7512	MA	Athol	0	40	8732	42.591911	-72.230355	978		0		0	1	0	0	7512	8370	2502515	-5	-1	82
7748	MA	Ware	-1	49	6533	42.259965	-72.245841	413		0		0	1	0	0	7748	6174	2572845	-5	-1	82
7739	MA	Turners Falls	-1	41	4731	42.598943	-72.556809	413		0		0	1	0	0	7739	4441	2570815	-5	-1	82
7681	MA	Orange	-1	50	3791	42.587796	-72.308163	978		0		0	0	0	0	7681	3945	2551230	-5	-1	82
7573	MA	East Longmeadow	-1	15		42.062009	-72.49874	413		0		0	1	0	0	7573			-5	-1	82
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
7689	MA	Petersham	0	250		42.459632	-72.182962	978		0		0	0	0	0	7689			-5	-1	82

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

28 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
01301	GREENFIELD	MA	13381	Greenfield	82
01331	ATHOL	MA	10562	Athol	82
01364	ORANGE	MA	6044	Orange	82
01373	SOUTH DEERFIELD	MA	4019	South Deerfield
01376	TURNERS FALLS	MA	3968	Turners Falls	82
01370	SHELBURNE FALLS	MA	3439	Shelburne Falls
01375	SUNDERLAND	MA	2777
01360	NORTHFIELD	MA	2627	Northfield
01337	BERNARDSTON	MA	2438	Bernardston
01351	MONTAGUE	MA	2016	Montague
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
01340	COLRAIN	MA	1581	Colrain
01341	CONWAY	MA	1541	Conway
01330	ASHFIELD	MA	1345	Ashfield
01354	GILL	MA	1338
01339	CHARLEMONT	MA	1250	Charlemont
01344	ERVING	MA	1247
01342	DEERFIELD	MA	1238	Deerfield
01366	PETERSHAM	MA	1104	Petersham	82
01368	ROYALSTON	MA	1081
01355	NEW SALEM	MA	803
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
01349	MILLERS FALLS	MA	697	Millers Falls
01379	WENDELL	MA	625
01378	WARWICK	MA	611
01367	ROWE	MA	444	Rowe
01338	BUCKLAND	MA	0
01343	DRURY	MA	0
01346	HEATH	MA	0
01380	WENDELL DEPOT	MA	0

Station WNNZ-FM

City DEERFIELD-MA

City Deerfield, MA is located in DMAID: