Fix W246CC Station DMA

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

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

Number of rows returned = 1
Start: 1754176740.7793
End: 1754176740.7795
Elapsed time: 0.1590 ms 1 records found!
id State CityName RuralArea PopCount Population Latitude Longitude PrimaryAC ZoneDesc EartlinkDSL ISPCount CovadDSL VerizonDSL allegiance SBC RateCenterCityid Population2000 FIPS cTZoffset DST DMAID
79883 CT Bolton -1 0 50

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

NULL

****** zip code ************

array(13) { ["zipcode"]=> string(5) "06043" ["zip3"]=> string(3) "060" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(6) "BOLTON" ["zipstate"]=> string(2) "CT" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "41.76" ["iplongitude"]=> string(6) "-72.43" ["ziplocation"]=> string(15) "NA-US-CT-BOLTON" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "2647" ["zippopulation"]=> string(4) "4713" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "060" ["zipcity"]=> string(11) "NEW BRITAIN" ["zipstate"]=> string(2) "CT" }

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

array(22) { ["id"]=> string(4) "2916" ["State"]=> string(2) "CT" ["CityName"]=> string(11) "New Britain" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "176" ["Population"]=> string(5) "75491" ["Latitude"]=> string(9) "41.674266" ["Longitude"]=> string(10) "-72.784303" ["PrimaryAC"]=> string(3) "860" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(4) "2916" ["Population2000"]=> string(5) "71538" ["FIPS"]=> string(6) "950370" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "50" }

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

No Rows in Recordset!

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

18 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
2959	CT	Waterbury	0	295	108961	41.55604	-73.038327	203		0		0	0	0	0	2959	107271	980000	-5	-1	50
2916	CT	New Britain	0	176	75491	41.674266	-72.784303	860		0		1	0	0	0	2916	71538	950370	-5	-1	50
2861	CT	Bristol	0	69	60640	41.682249	-72.933656	860		0		1	0	0	0	2861	60062	908420	-5	-1	50
33458	CT	West Hartford	-1	0	60110	41.76005	-72.743041			0		0	0	0	0		63589	982660	-5	-1	50
2954	CT	Torrington	0	305	33687	41.817487	-73.118706	860		0		0	0	0	0	2954	35202	976500	-5	-1	50
2915	CT	Naugatuck	-1	65	30625	41.493763	-73.051731	203		0		0	0	0	0	2915	30989	949880	-5	-1	50
2921	CT	New Milford	0	142	5775	41.582494	-73.408851	860		0		0	0	0	0	2921	6633	952560	-5	-1	50
33452	CT	Terryville	-1	0	5426	41.678898	-73.003948			0		0	0	0	0		5360	975240	-5	-1	50
2856	CT	Berlin	-1	0				860		0		0	0	0	0	2856			-5	-1	50
2969	CT	Windsor	0	130		41.909988	-72.804935	860		0		1	0	0	0	2969			-5	-1	50
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
2944	CT	Simsbury	0	150		41.868647	-72.819742	860		0		1	0	0	0	2944			-5	-1	50
2943	CT	Sharon	-1	5		41.874681	-73.433903	860		0		0	0	0	0	2943			-5	-1	50
2927	CT	Norfolk	-1	0		41.886811	-73.184674	860		0		0	0	0	0	2927			-5	-1	50
2907	CT	Manchester	0	157		41.791776	-72.718832	860		0		1	0	0	0	2907			-5	-1	50
2899	CT	Kent	-1	0		41.774725	-73.401908	860		0		0	0	0	0	2899			-5	-1	50
2881	CT	Enfield	0	134		41.791776	-72.718832	860		0		0	0	0	0	2881			-5	-1	50
2858	CT	Bloomfield	-1	0		41.851961	-72.738939	860		0		0	0	0	0				-5	-1	50
79883	CT	Bolton	-1																	0	50

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

57 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
06010	BRISTOL	CT	50388	Bristol	50
06082	ENFIELD	CT	35610	Enfield	50
06040	MANCHESTER	CT	29298	Manchester	50
06095	WINDSOR	CT	26020	Windsor	50
06033	GLASTONBURY	CT	25927	Glastonbury
06053	NEW BRITAIN	CT	24752	New Britain	50
06066	VERNON ROCKVILLE	CT	24424
06074	SOUTH WINDSOR	CT	23622
06051	NEW BRITAIN	CT	20529	New Britain	50
06042	MANCHESTER	CT	18594	Manchester	50
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
06002	BLOOMFIELD	CT	18034	Bloomfield	50
06037	BERLIN	CT	17190	Berlin	50
06067	ROCKY HILL	CT	17166
06001	AVON	CT	16788
06032	FARMINGTON	CT	16183	Farmington
06062	PLAINVILLE	CT	15474	Plainville
06070	SIMSBURY	CT	13868	Simsbury	50
06084	TOLLAND	CT	13549
06029	ELLINGTON	CT	13436
06096	WINDSOR LOCKS	CT	11081	Windsor Locks
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
06076	STAFFORD SPRINGS	CT	10627	Stafford Springs
06098	WINSTED	CT	9551	Winsted
06078	SUFFIELD	CT	8852
06019	CANTON	CT	8702	Canton
06013	BURLINGTON	CT	8379
06071	SOMERS	CT	8215
06035	GRANBY	CT	6864	Granby
06052	NEW BRITAIN	CT	6445	New Britain	50
06057	NEW HARTFORD	CT	6239	New Hartford
06085	UNIONVILLE	CT	6187	Unionville
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
06016	BROAD BROOK	CT	5434	Broad Brook
06073	SOUTH GLASTONBURY	CT	5078
06043	BOLTON	CT	4713	Bolton	50
06026	EAST GRANBY	CT	4698
06088	EAST WINDSOR	CT	4088
06092	WEST SIMSBURY	CT	4014	West Simsbury
06093	WEST SUFFIELD	CT	3130
06063	BARKHAMSTED	CT	2978
06089	WEATOGUE	CT	2654	Weatogue
06060	NORTH GRANBY	CT	2317	North Granby
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
06018	CANAAN	CT	2308	Canaan
06069	SHARON	CT	2013	Sharon	50
06039	LAKEVILLE	CT	1893	Lakeville
06058	NORFOLK	CT	1485	Norfolk	50
06027	EAST HARTLAND	CT	1332
06023	EAST BERLIN	CT	1204
06068	SALISBURY	CT	1191
06081	TARIFFVILLE	CT	1163	Tariffville
06090	WEST GRANBY	CT	1117
06031	FALLS VILLAGE	CT	1062
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
06065	RIVERTON	CT	746
06021	COLEBROOK	CT	588
06024	EAST CANAAN	CT	491
06020	CANTON CENTER	CT	0
06022	COLLINSVILLE	CT	0	Collinsville
06059	NORTH CANTON	CT	0
06091	WEST HARTLAND	CT	0

Station W246CC-FX

City BOLTON-CT

City , is located in DMAID: