Fix W232DI Station DMA

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

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

Number of rows returned = 1
Start: 1754150446.3166
End: 1754150446.3167
Elapsed time: 0.1109 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
11233 NC Monroe 0 183 16127 34.98876 -80.549792 704 0 1 0 0 0 11233 26228 3743920 -5 -1 35

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

NULL

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

array(13) { ["zipcode"]=> string(5) "28110" ["zip3"]=> string(3) "281" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(6) "MONROE" ["zipstate"]=> string(2) "NC" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "34.98" ["iplongitude"]=> string(6) "-80.54" ["ziplocation"]=> string(15) "NA-US-NC-MONROE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "20136" ["zippopulation"]=> string(5) "39034" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "281" ["zipcity"]=> string(6) "MONROE" ["zipstate"]=> string(2) "NC" }

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

array(22) { ["id"]=> string(5) "11233" ["State"]=> string(2) "NC" ["CityName"]=> string(6) "Monroe" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "183" ["Population"]=> string(5) "16127" ["Latitude"]=> string(8) "34.98876" ["Longitude"]=> string(10) "-80.549792" ["PrimaryAC"]=> string(3) "704" ["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(5) "11233" ["Population2000"]=> string(5) "26228" ["FIPS"]=> string(7) "3743920" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "35" }

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

No Rows in Recordset!

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

45 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
11134	NC	Gastonia	0	268	54732	35.25522	-81.180249	704		0		1	0	0	0	11134	66277	3725580	-5	-1	35
11179	NC	Kannapolis	0	73	29696	35.490589	-80.618353	704		0		0	0	0	0	11179	36910	3735200	-5	-1	35
11164	NC	Hickory	0	86	28301	35.737682	-81.328372	828		0		0	0	0	0	11164	37222	3731060	-5	-1	35
11086	NC	Concord	-1	99	27347	35.40434	-80.600474	704		0		0	0	0	0	11086	55977	3714100	-5	-1	35
11317	NC	Salisbury	0	214	23087	35.668289	-80.478479	704		0		1	0	0	0	11317	26462	3758860	-5	-1	35
17919	RI	Bristol	0	144	21625	41.6842	-71.268669	401		0		0	1	0	0	17919	22469	4409460	-5	-1	35
11352	NC	Statesville	0	201	17567	35.786793	-80.878531	704		0		0	0	0	0	11352	23320	3764740	-5	-1	35
11203	NC	Lexington	-1	2	16581	35.816768	-80.258643	336		0		0	0	0	0	11203	19953	3738060	-5	-1	35
11010	NC	Asheboro	-1	54	16362	35.715211	-79.813001	336		0		0	0	0	0	11010	21672	3702080	-5	-1	35
11233	NC	Monroe	0	183	16127	34.98876	-80.549792	704		0		1	0	0	0	11233	26228	3743920	-5	-1	35
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
11002	NC	Albemarle	-1	55	14939	35.35836	-80.195262	704		0		0	0	0	0	11002	15680	3700680	-5	-1	35
11331	NC	Shelby	0	207	14669	35.288272	-81.537787	704		0		0	0	0	0	11331	19477	3761200	-5	-1	35
11226	NC	Matthews	-1	107	13651	35.116851	-80.716409	704		0		0	0	0	0	11226	22127	3741960	-5	-1	35
18035	SC	Gaffney	-1	89	13145	35.071938	-81.653005	864		0		0	0	0	0	18035	12968	4528060	-5	-1	35
11235	NC	Mooresville	-1	82	9317	35.584337	-80.820139	704		0		0	0	0	0	11235	18823	3744220	-5	-1	35
11258	NC	Newton	-1	102	9304	35.665082	-81.224351	828		0		0	0	0	0	11258	12560	3747000	-5	-1	35
11186	NC	Kings Mountain	-1	68	8763	35.244105	-81.342544	704		0		0	0	0	0	11186	9693	3735880	-5	-1	35
11028	NC	Belmont	-1	123	8434	35.244496	-81.03565	704		0		0	0	0	0	11028	8705	3704840	-5	-1	35
11241	NC	Mount Holly	-1	106	7710	35.295178	-81.019319	704		0		0	0	0	0	11241	9618	3744960	-5	-1	35
11207	NC	Lincolnton	0	168	6847	35.47416	-81.242811	704		0		0	0	0	0	11207	9965	3738320	-5	-1	35
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
11069	NC	Cherryville	-1	61	4756	35.381169	-81.379168	704		0		0	0	0	0	11069	5361	3712340	-5	-1	35
11095	NC	Davidson	-1	160	4046	35.491165	-80.832864	704		0		1	0	0	0	11095	7139	3716400	-5	-1	35
11375	NC	Valdese	-1	40	3914	35.74327	-81.558662	828		0		0	0	0	0	11375	4485	3769520	-5	-1	35
11379	NC	Wadesboro	-1	54	3645	34.968096	-80.071488	704		0		0	0	0	0	11379	3552	3770380	-5	-1	35
11314	NC	Rutherfordton	0	138	3617	35.366306	-81.959024	828		0		0	0	0	0	11314	4131	3758460	-5	-1	35
11262	NC	North Wilkesboro	0	59	3384	36.17091	-81.142048	336		0		0	0	0	0	11262	4116	3747880	-5	-1	35
11143	NC	Granite Falls	-1	42	3253	35.800345	-81.432929	828		0		0	0	0	0	11143	4612	3727420	-5	-1	35
11173	NC	Huntersville	-1	148	3014	35.409544	-80.863622	704		0		1	0	0	0	11173	24960	3733120	-5	-1	35
37481	NC	Dallas	-1	0	3012	35.314816	-81.175215			0		0	0	0	0		3402	3716180	-5	-1	35
11281	NC	Pineville	0	2	2970	35.085737	-80.888167	704		0		0	0	0	0	11281	3449	3752220	-5	-1	35
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
11408	NC	Wingate	-1	42	2821	34.985021	-80.447254	704		0		0	0	0	0	11408	2406	3774760	-5	-1	35
37543	NC	Hudson	-1	0	2819	35.845476	-81.490337			0		0	0	0	0		3078	3732980	-5	-1	35
11070	NC	China Grove	-1	54	2732	35.570289	-80.577934	704		0		0	0	0	0	11070	3616	3712480	-5	-1	35
37443	NC	Boiling Springs	-1	0	2445	35.251752	-81.664288			0		0	0	0	0		3866	3706800	-5	-1	35
11344	NC	Sparta	-1	0	1957	36.505639	-81.121718	336		0		0	0	0	0	11344	1817	3763680	-5	-1	35
11174	NC	Indian Trail	-1	46	1942	35.069918	-80.654424	704		0		0	0	0	0	11174	11905	3733560	-5	-1	35
11156	NC	Harrisburg	-1	50	1625	35.322295	-80.653331	704		0		0	0	0	0	11156	4493	3729800	-5	-1	35
37549	NC	Jefferson	-1	0	1300	36.419922	-81.468899			0		0	0	0	0		1422	3734440	-5	-1	35
11391	NC	Waxhaw	-1	45	1294	34.928201	-80.744835	704		0		0	0	0	0	11391	2625	3771460	-5	-1	35
11039	NC	Blowing Rock	-1	48	1257	36.129663	-81.672566	828		0		0	0	0	0	11039	1418	3706500	-5	-1	35
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
37523	NC	Gaston	-1	0	1003	36.496013	-77.643881			0		0	0	0	0		973	3725560	-5	-1	35
11398	NC	West Jefferson	-1	0	1002	36.395181	-81.491742	336		0		0	0	0	0	11398	1081	3772540	-5	-1	35
11073	NC	Claremont	-1	49	980	35.713752	-81.150661	828		0		0	0	0	0	11073	1038	3712720	-5	-1	35
11256	NC	Newland	-1	74	645	36.086509	-81.926664	828		0		0	0	0	0	11256	704	3746740	-5	-1	35
11126	NC	Forest City	-1	84		35.331128	-81.870107	828		0		0	0	0	0	11126	7549	3724080	-5	-1	35

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

38 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
28110	MONROE	NC	39034	Monroe	35
28173	WAXHAW	NC	35179	Waxhaw	35
28105	MATTHEWS	NC	32992	Matthews	35
28117	MOORESVILLE	NC	29568	Mooresville	35
28115	MOORESVILLE	NC	27584	Mooresville	35
28104	MATTHEWS	NC	23202	Matthews	35
28146	SALISBURY	NC	20958	Salisbury	35
28112	MONROE	NC	19706	Monroe	35
28150	SHELBY	NC	19605	Shelby	35
28147	SALISBURY	NC	19006	Salisbury	35
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
28152	SHELBY	NC	16991	Shelby	35
28144	SALISBURY	NC	16371	Salisbury	35
28120	MOUNT HOLLY	NC	16127	Mount Holly	35
28139	RUTHERFORDTON	NC	14594	Rutherfordton	35
28164	STANLEY	NC	11986	Stanley
28138	ROCKWELL	NC	8491	Rockwell
28170	WADESBORO	NC	8450	Wadesboro	35
28168	VALE	NC	8020
28103	MARSHVILLE	NC	7924	Marshville
28166	TROUTMAN	NC	7617	Troutman
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
28134	PINEVILLE	NC	7418	Pineville	35
28174	WINGATE	NC	6303	Wingate	35
28128	NORWOOD	NC	5964	Norwood
28124	MOUNT PLEASANT	NC	5464	Mount Pleasant
28107	MIDLAND	NC	5436
28127	NEW LONDON	NC	4990	New London
28129	OAKBORO	NC	4475	Oakboro
28114	MOORESBORO	NC	4469	Mooresboro
28163	STANFIELD	NC	4116	Stanfield
28135	POLKTON	NC	2710	Polkton
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
28160	SPINDALE	NC	2671	Spindale	161
28137	RICHFIELD	NC	2392	Richfield
28159	SPENCER	NC	2388	Spencer
28133	PEACHLAND	NC	2229	Peachland
28125	MOUNT ULLA	NC	2112
28119	MORVEN	NC	2078	Morven
28167	UNION MILLS	NC	1793
28101	MC ADENVILLE	NC	721

Station W232DI-FX

City MONROE-NC

City , is located in DMAID: