Fix K259AE Station DMA

Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix K259AE Station DMA

array(0) { }

*** DMA ***

array(12) { ["odbcts"]=> string(19) "2009-06-13 09:56:14" ["dmarank"]=> string(1) "0" ["dmaID"]=> string(1) "0" ["dmaType"]=> string(1) "C" ["Minority"]=> NULL ["QualType"]=> NULL ["DMAName"]=> string(13) "United States" ["Population25up"]=> string(9) "300000000" ["scanned"]=> NULL ["AvgLatitude"]=> NULL ["AvgLongitude"]=> NULL ["State"]=> string(2) "WW" }
Database: media
SQL: select * from cities where CityName = 'WILLIAMS' and State = 'OR'

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

Number of rows returned = 0
Start: 1754170046.8573
End: 1754170046.8575
Elapsed time: 0.1750 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('OR','Williams',-1)

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

array(22) { ["id"]=> string(5) "80060" ["State"]=> string(2) "OR" ["CityName"]=> string(8) "Williams" ["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) "97544" ["zip3"]=> string(3) "975" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(8) "WILLIAMS" ["zipstate"]=> string(2) "OR" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "42.14" ["iplongitude"]=> string(7) "-123.32" ["ziplocation"]=> string(17) "NA-US-OR-WILLIAMS" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "929" ["zippopulation"]=> string(4) "1616" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "975" ["zipcity"]=> string(7) "MEDFORD" ["zipstate"]=> string(2) "OR" }

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

array(22) { ["id"]=> string(5) "16148" ["State"]=> string(2) "OR" ["CityName"]=> string(7) "Medford" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "194" ["Population"]=> string(5) "46951" ["Latitude"]=> string(9) "42.331998" ["Longitude"]=> string(11) "-122.861874" ["PrimaryAC"]=> string(3) "541" ["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) "16148" ["Population2000"]=> string(5) "63154" ["FIPS"]=> string(7) "4147000" ["cTZoffset"]=> string(2) "-8" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "212" }

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

No Rows in Recordset!

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

20 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
16148	OR	Medford	0	194	46951	42.331998	-122.861874	541		0		0	0	0	0	16148	63154	4147000	-8	-1	212
16124	OR	Klamath Falls	0	175	17737	42.223441	-121.777578	541		0		0	0	0	0	16124	19462	4139700	-8	-1	212
16094	OR	Grants Pass	-1	140	17488	42.438969	-123.328249	541		0		0	0	0	0	16094	23003	4130550	-8	-1	212
16002	OR	Ashland	0	128	16234	42.191396	-122.700752	541		0		0	0	0	0	16002	19522	4103050	-8	-1	212
16038	OR	Central Point	-1	59	7509	42.374847	-122.912089	541		0		0	0	0	0	16038	12493	4112400	-8	-1	212
39601	OR	Talent	-1	0	3274	42.239985	-122.7821			0		0	0	0	0		5589	4172500	-8	-1	212
16194	OR	Phoenix	-1	57	3239	42.274523	-122.818748	541		0		0	0	0	0	16194	4060	4157500	-8	-1	212
39533	OR	Eagle Point	-1	0	3008	42.467881	-122.80162			0		0	0	0	0		4797	4121550	-8	-1	212
16116	OR	Jacksonville	0	10	1896	42.314456	-122.967157	541		0		0	0	0	0	16116	2235	4137000	-8	-1	212
16214	OR	Rogue River	0	1	1759	42.436226	-123.169488	541		0		0	0	0	0	16214	1847	4163450	-8	-1	212
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
16037	OR	Cave Junction	-1	9	1126	42.166779	-123.646999	541		0		0	0	0	0	16037	1363	4111850	-8	-1	212
16089	OR	Gold Hill	0	1	964	42.433618	-123.054397	541		0		0	0	0	0	16089	1073	4129950	-8	-1	212
16150	OR	Merrill	-1	1	837	42.025582	-121.599566	541		0		0	0	0	0	16150	897	4147700	-8	-1	212
16141	OR	Malin	-1	0	725	42.012814	-121.407482	541		0		0	0	0	0	16141	638	4145400	-8	-1	212
16042	OR	Chiloquin	-1	0	673	42.575109	-121.864171	541		0		0	0	0	0	16042	716	4113050	-8	-1	212
16024	OR	Bonanza	-1	0	323	42.199333	-121.404639	541		0		0	0	0	0	16024	415	4107300	-8	-1	212
16029	OR	Butte Falls	-1	0	252	42.542379	-122.567509	541		0		0	0	0	0	16029	439	4110050	-8	-1	212
16225	OR	Selma	-1	1		42.265435	-123.551451	541		0		0	0	0	0	16225			-8	-1	212
16232	OR	Silver Lake	-1	2		42.805272	-120.355294	541		0		0	0	0	0	16232			-8	-1	212
16237	OR	Sprague River	-1	0		42.486975	-121.531087	541		0		0	0	0	0	16237			-8	-1	212

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

24 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
97504	MEDFORD	OR	35337	Medford	212
97501	MEDFORD	OR	31960	Medford	212
97527	GRANTS PASS	OR	24158	Grants Pass	212
97526	GRANTS PASS	OR	24106	Grants Pass	212
97502	CENTRAL POINT	OR	22002	Central Point	212
97520	ASHLAND	OR	19338	Ashland	212
97524	EAGLE POINT	OR	11363	Eagle Point	212
97503	WHITE CITY	OR	8234	White City
97530	JACKSONVILLE	OR	6416	Jacksonville	212
97540	TALENT	OR	6328	Talent	212
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
97537	ROGUE RIVER	OR	5962	Rogue River	212
97523	CAVE JUNCTION	OR	4309	Cave Junction	212
97525	GOLD HILL	OR	4095	Gold Hill	212
97535	PHOENIX	OR	4050	Phoenix	212
97532	MERLIN	OR	2777
97539	SHADY COVE	OR	2763	Shady Cove
97544	WILLIAMS	OR	1616	Williams
97538	SELMA	OR	1455	Selma	212
97541	TRAIL	OR	1049
97536	PROSPECT	OR	709	Prospect
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
97543	WILDERVILLE	OR	656
97522	BUTTE FALLS	OR	529	Butte Falls	212
97534	O BRIEN	OR	434
97531	KERBY	OR	0

***** stations in DMA*************

26 records found!

stationid	CallSign	Licensee	Service	citynamex	Statex	cityid
22710	BTRN			World Wide Web	WW	79841
23163	CRN1			World Wide Web	WW	79841
23164	CRN2			World Wide Web	WW	79841
23165	CRN3			World Wide Web	WW	79841
23166	CRN4			World Wide Web	WW	79841
23167	CRN5			World Wide Web	WW	79841
23168	CRN6			World Wide Web	WW	79841
42585	CSPAN1			World Wide Web	WW	79841
42586	CSPAN2			World Wide Web	WW	79841
42587	CSPAN3			World Wide Web	WW	79841
stationid	CallSign	Licensee	Service	citynamex	Statex	cityid
22711	ESPN			World Wide Web	WW	79841
58943	EWTN			World Wide Web	WW	79841
22652	Fox News			World Wide Web	WW	79841
22712	Fox Sports			World Wide Web	WW	79841
41312	GCN1			World Wide Web	WW	79841
41481	GCN4			World Wide Web	WW	79841
77684	GCN5			World Wide Web	WW	79841
32729	MOYL			World Wide Web	WW	79841
44298	NPR			World Wide Web	WW	79841
44299	PRI			World Wide Web	WW	79841
stationid	CallSign	Licensee	Service	citynamex	Statex	cityid
22707	Radio America			World Wide Web	WW	79841
44583	SportsByline			World Wide Web	WW	79841
23558	TalkStar			World Wide Web	WW	79841
40372	TammyRadio			World Wide Web	WW	79841
44584	TheBlaze			World Wide Web	WW	79841
44301	YSN			World Wide Web	WW	79841

Station K259AE-FX

City WILLIAMS-OR

City Williams, OR is located in DMAID: