Fix WDEV 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 = 'WARREN' and State = 'VT'

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

Number of rows returned = 0
Start: 1754176802.2289
End: 1754176802.2293
Elapsed time: 0.4230 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('VT','Warren',-1)

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

array(22) { ["id"]=> string(5) "80146" ["State"]=> string(2) "VT" ["CityName"]=> string(6) "Warren" ["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) "05674" ["zip3"]=> string(3) "056" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(6) "WARREN" ["zipstate"]=> string(2) "VT" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "44.12" ["iplongitude"]=> string(6) "-72.85" ["ziplocation"]=> string(15) "NA-US-VT-WARREN" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "794" ["zippopulation"]=> string(4) "1263" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "056" ["zipcity"]=> string(5) "BARRE" ["zipstate"]=> string(2) "VT" }

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

array(22) { ["id"]=> string(5) "20596" ["State"]=> string(2) "VT" ["CityName"]=> string(5) "Barre" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(2) "99" ["Population"]=> string(4) "9482" ["Latitude"]=> string(9) "44.198433" ["Longitude"]=> string(10) "-72.501411" ["PrimaryAC"]=> string(3) "802" ["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) "20596" ["Population2000"]=> string(4) "9291" ["FIPS"]=> string(7) "5003175" ["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 **************

30 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
05641	BARRE	VT	13551	Barre	180
05602	MONTPELIER	VT	10117	Montpelier	266
05661	MORRISVILLE	VT	5006	Morrisville	266
05672	STOWE	VT	4344	Stowe	136
05676	WATERBURY	VT	4322	Waterbury	266
05663	NORTHFIELD	VT	3880	Northfield	180
05679	WILLIAMSTOWN	VT	2786	Williamstown
05673	WAITSFIELD	VT	2719	Waitsfield
05655	HYDE PARK	VT	2465	Hyde Park	180
05656	JOHNSON	VT	2331	Johnson	223
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
05677	WATERBURY CENTER	VT	1994
05667	PLAINFIELD	VT	1957	Plainfield	180
05680	WOLCOTT	VT	1662
05660	MORETOWN	VT	1642
05651	EAST MONTPELIER	VT	1465
05674	WARREN	VT	1263	Warren
05658	MARSHFIELD	VT	1228	Marshfield
05682	WORCESTER	VT	1110
05654	GRANITEVILLE	VT	1050
05649	EAST BARRE	VT	959
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
05650	EAST CALAIS	VT	906	East Calais
05647	CABOT	VT	853	Cabot
05675	WASHINGTON	VT	817	Washington
05652	EDEN	VT	651
05669	ROXBURY	VT	462
05648	CALAIS	VT	451
05640	ADAMANT	VT	0
05666	NORTH MONTPELIER	VT	0
05653	EDEN MILLS	VT	0
05681	WOODBURY	VT	0

Station WDEV-FM

City WARREN-VT

City Warren, VT is located in DMAID: