Fix WRSY FM Station DMA

Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix WRSY 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 = 'MARLBORO' and State = 'VT'

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: 1754168033.512
End: 1754168033.5121
Elapsed time: 0.1612 ms No Rows in Recordset!

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

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

array(22) { ["id"]=> string(5) "79994" ["State"]=> string(2) "VT" ["CityName"]=> string(8) "Marlboro" ["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) "05344" ["zip3"]=> string(3) "053" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(8) "MARLBORO" ["zipstate"]=> string(2) "VT" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "42.86" ["iplongitude"]=> string(6) "-72.72" ["ziplocation"]=> string(17) "NA-US-VT-MARLBORO" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "264" ["zippopulation"]=> string(3) "431" ["zipincome"]=> string(7) "7718256" }

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

array(3) { ["zip3"]=> string(3) "053" ["zipcity"]=> string(11) "BRATTLEBORO" ["zipstate"]=> string(2) "VT" }

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

array(22) { ["id"]=> string(5) "20605" ["State"]=> string(2) "VT" ["CityName"]=> string(11) "Brattleboro" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(3) "106" ["Population"]=> string(4) "8612" ["Latitude"]=> string(9) "42.856099" ["Longitude"]=> string(10) "-72.564186" ["PrimaryAC"]=> string(3) "802" ["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) "20605" ["Population2000"]=> string(4) "8289" ["FIPS"]=> string(7) "5007975" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "277" }

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

No Rows in Recordset!

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

31 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
21515	WI	Sheboygan	0	201	49676	43.749694	-87.725013	920		0		0	0	0	0	21515	50792	5572975	-6	-1	277
8288	ME	Lewiston	0	143	39757	44.097473	-70.192416	207		0		0	1	0	0	8288	35690	2338740	-5	-1	277
21337	WI	Manitowoc	0	171	32520	44.096461	-87.675002	920		0		0	0	0	0	21337	34053	5548500	-6	-1	277
21136	WI	Cedarburg	-1	223	9895	43.29896	-87.987209	262		0		1	0	0	0	21136	10908	5513375	-6	-1	277
21464	WI	Port Washington	0	90	9338	43.39325	-87.881053	262		0		0	0	0	0	21464	10467	5564450	-6	-1	277
20605	VT	Brattleboro	-1	106	8612	42.856099	-72.564186	802		0		0	0	0	0	20605	8289	5007975	-5	-1	277
21460	WI	Plymouth	0	128	6769	43.749277	-87.976799	920		0		0	0	0	0	21460	7781	5563700	-6	-1	277
21516	WI	Sheboygan Falls	-1	34	5823	43.730444	-87.821078	920		0		0	0	0	0	21516	6772	5573025	-6	-1	277
21178	WI	Delafield	-1	1	5347	43.075629	-88.3953	262		0		0	0	0	0	21178	6472	5519400	-6	-1	277
21559	WI	Sussex	-1	45	5039	43.135072	-88.220346	262		0		0	0	0	0	21559	8828	5578750	-6	-1	277
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
21449	WI	Pewaukee	-1	87	4941	43.082659	-88.252842	262		0		0	0	0	0	21449	8170	5562250	-6	-1	277
21350	WI	Mayville	0	83	4374	43.497044	-88.547871	920		0		0	0	0	0	21350	4902	5550200	-6	-1	277
21041	WI	Algoma	-1	43	3353	44.608226	-87.442342	920		0		0	0	0	0	21041	3357	5501000	-6	-1	277
21406	WI	New Holstein	-1	78	3342	43.948185	-88.090931	920		0		0	0	0	0	21406	3301	5556800	-6	-1	277
21142	WI	Chilton	0	106	3240	44.030745	-88.158704	920		0		0	0	0	0	21142	3708	5514475	-6	-1	277
21299	WI	Kiel	0	95	2910	43.914718	-88.031812	920		0		0	0	0	0	21299	3450	5539525	-6	-1	277
21298	WI	Kewaunee	-1	3	2750	44.458758	-87.509496	920		0		0	0	0	0	21298	2806	5539350	-6	-1	277
36299	ME	South Paris	-1	0	2320	44.221609	-70.514603			0		0	0	0	0		2237	2371780	-5	-1	277
36292	ME	Mexico	-1	0	2302	44.557153	-70.540252			0		0	0	0	0		1946	2345250	-5	-1	277
21326	WI	Lomira	-1	6	1542	43.595089	-88.444602	920		0		0	0	0	0	21326	2233	5545475	-6	-1	277
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
21147	WI	Cleveland	-1	1	1398	43.917829	-87.74625	920		0		0	0	0	0	21147	1361	5515400	-6	-1	277
21524	WI	Sister Bay	-1	1	675	45.187192	-87.123852	920		0		0	0	0	0	21524	886	5574225	-6	-1	277
21222	WI	Forestville	-1	0	470	44.689462	-87.480758	920		0		0	0	0	0	21222	429	5526625	-6	-1	277
42078	WI	Ephraim	-1	0	261	45.156509	-87.171047			0		0	0	0	0		353	5524150	-6	-1	277
70304	WI	Ixonia		0	0	43.144787	-88.598207			0	0	0	0	0	0	0	642	5537575	-6	-1	277
21064	WI	Baileys Harbor	-1	33		45.077002	-87.14603	920		0		0	0	0	0	21064			-6	-1	277
20733	VT	Wilmington	-1	98		42.944039	-72.727518	802		0		0	0	0	0	20733			-5	-1	277
20687	VT	Putney	-1	107		43.016096	-72.534025	802		0		0	0	0	0	20687			-5	-1	277
20648	VT	Jamaica	-1	84		43.012776	-72.767275	802		0		0	0	0	0	20648			-5	-1	277
8396	ME	Turner	-1	1		44.265473	-70.254155	207		0		0	0	0	0	8396			-5	-1	277
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
8197	ME	Bethel	-1	2		44.428414	-70.770035	207		0		0	0	0	0	8197			-5	-1	277

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

20 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
05301	BRATTLEBORO	VT	12127	Brattleboro	277
05346	PUTNEY	VT	4067	Putney	277
05363	WILMINGTON	VT	1949	Wilmington	277
05354	VERNON	VT	1940
05345	NEWFANE	VT	1416	Newfane
05356	WEST DOVER	VT	1043
05353	TOWNSHEND	VT	857
05352	STAMFORD	VT	757	Stamford
05340	BONDVILLE	VT	720
05343	JAMAICA	VT	697	Jamaica	277
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
05350	READSBORO	VT	636	Readsboro
05361	WHITINGHAM	VT	601
05342	JACKSONVILLE	VT	572	Jacksonville
05359	WEST TOWNSHEND	VT	447
05341	EAST DOVER	VT	0
05355	WARDSBORO	VT	0	Wardsboro
05358	WEST HALIFAX	VT	0
05360	WEST WARDSBORO	VT	0
05351	SOUTH NEWFANE	VT	0
05362	WILLIAMSVILLE	VT	0	Williamsville

Station WRSY-FM

City MARLBORO-VT

City Marlboro, VT is located in DMAID: