Fix WSCY FM Station DMA

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

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

Number of rows returned = 0
Start: 1754152101.9632
End: 1754152101.9633
Elapsed time: 0.1168 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('NH','Moultonborough',-1)

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

array(22) { ["id"]=> string(5) "79920" ["State"]=> string(2) "NH" ["CityName"]=> string(14) "Moultonborough" ["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) "03254" ["zip3"]=> string(3) "032" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(14) "MOULTONBOROUGH" ["zipstate"]=> string(2) "NH" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "43.75" ["iplongitude"]=> string(6) "-71.39" ["ziplocation"]=> string(23) "NA-US-NH-MOULTONBOROUGH" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "1816" ["zippopulation"]=> string(4) "3190" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "032" ["zipcity"]=> string(7) "LACONIA" ["zipstate"]=> string(2) "NH" }

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

array(22) { ["id"]=> string(5) "12439" ["State"]=> string(2) "NH" ["CityName"]=> string(7) "Laconia" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "265" ["Population"]=> string(5) "15743" ["Latitude"]=> string(9) "43.550769" ["Longitude"]=> string(10) "-71.467935" ["PrimaryAC"]=> string(3) "603" ["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) "12439" ["Population2000"]=> string(5) "16411" ["FIPS"]=> string(7) "3340180" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "169" }

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

No Rows in Recordset!

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

13 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
12400	NH	Concord	0	255	36006	43.220093	-71.549127	603		0		0	1	0	0	12400	40687	3314200	-5	-1	169
12439	NH	Laconia	0	265	15743	43.550769	-71.467935	603		0		0	1	0	0	12439	16411	3340180	-5	-1	169
12418	NH	Franklin	0	147	8304	43.446956	-71.656966	603		0		0	0	0	0	12418	8405	3327380	-5	-1	169
12483	NH	Plymouth	0	223	3967	43.755207	-71.690623	603		0		0	1	0	0	12483	3528	3362580	-5	-1	169
12518	NH	Wolfeboro	0	216	2783	43.589666	-71.206529	603		0		0	1	0	0	12518	2979	3386340	-5	-1	169
12430	NH	Henniker	-1	3	1693	43.180303	-71.823298	603		0		0	0	0	0	12430	1627	3335460	-5	-1	169
12451	NH	Meredith	0	101	1654	43.655952	-71.500515	603		0		0	0	0	0	12451	1739	3347060	-5	-1	169
12402	NH	Conway	0	147	1604	43.978936	-71.126716	603		0		0	0	0	0	12402	1692	3314580	-5	-1	169
12384	NH	Bristol	-1	68	1483	43.596198	-71.743777	603		0		0	0	0	0	12384	1670	3307620	-5	-1	169
12385	NH	Campton	-1	49		43.841799	-71.665223	603		0		0	0	0	0	12385			-5	-1	169
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
12377	NH	Belmont	-1	50		43.455551	-71.40709	603		0		0	0	0	0	12377			-5	-1	169
12503	NH	Tilton	-1	48		43.524872	-71.445841	603		0		0	0	0	0	12503			-5	-1	169
12376	NH	Bedford	-1	97		42.93743	-71.535515	603		0		0	1	0	0	12376			-5	-1	169

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

52 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
03246	LACONIA	NH	12852	Laconia	169
03275	SUNCOOK	NH	10177	Suncook
03281	WEARE	NH	7854	Weare
03244	HILLSBOROUGH	NH	6896	Hillsborough
03276	TILTON	NH	6892	Tilton	169
03235	FRANKLIN	NH	6820	Franklin	169
03220	BELMONT	NH	6141	Belmont	169
03249	GILFORD	NH	6003
03253	MEREDITH	NH	5790	Meredith	169
03229	CONTOOCOOK	NH	5355	Contoocook
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
03222	BRISTOL	NH	4689	Bristol	169
03234	EPSOM	NH	4174	Epsom
03290	NOTTINGHAM	NH	4061
03264	PLYMOUTH	NH	3990	Plymouth	169
03261	NORTHWOOD	NH	3887	Northwood
03257	NEW LONDON	NH	3804	New London	180
03223	CAMPTON	NH	3750	Campton	169
03242	HENNIKER	NH	3693	Henniker	169
03263	PITTSFIELD	NH	3366	Pittsfield
03254	MOULTONBOROUGH	NH	3190	Moultonborough
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
03225	CENTER BARNSTEAD	NH	3042	Center Barnstead
03278	WARNER	NH	2640	Warner
03269	SANBORNTON	NH	2620
03226	CENTER HARBOR	NH	2204	Center Harbor
03258	CHICHESTER	NH	2183	Chichester
03237	GILMANTON	NH	2180	Gilmanton
03224	CANTERBURY	NH	2165	Canterbury
03217	ASHLAND	NH	1929	Ashland
03221	BRADFORD	NH	1901	Bradford
03266	RUMNEY	NH	1886	Rumney
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
03256	NEW HAMPTON	NH	1819
03216	ANDOVER	NH	1775	Andover
03255	NEWBURY	NH	1702
03245	HOLDERNESS	NH	1676
03251	LINCOLN	NH	1455
03268	SALISBURY	NH	1116	Salisbury
03287	WILMOT	NH	1056
03218	BARNSTEAD	NH	1040	Barnstead
03240	GRAFTON	NH	1038
03285	THORNTON	NH	1035
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
03262	NORTH WOODSTOCK	NH	1012	North Woodstock
03230	DANBURY	NH	985	Danbury
03243	HILL	NH	938
03280	WASHINGTON	NH	902	Washington
03227	CENTER SANDWICH	NH	881	Center Sandwich
03282	WENTWORTH	NH	806
03241	HEBRON	NH	721
03284	SPRINGFIELD	NH	676
03279	WARREN	NH	652	Warren
03233	ELKINS	NH	0
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
03259	NORTH SANDWICH	NH	0
03291	WEST NOTTINGHAM	NH	0

Station WSCY-FM

City MOULTONBOROUGH-NH

City Moultonborough, NH is located in DMAID: