Fix K214FI 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 = 'RAYMOND' and State = 'WA'

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

Number of rows returned = 1
Start: 1754176700.8253
End: 1754176700.8255
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
20946 WA Raymond -1 0 2901 46.679599 -123.738091 360 0 0 0 0 0 20946 2975 5357430 -8 -1 14

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

NULL

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

array(13) { ["zipcode"]=> string(5) "98577" ["zip3"]=> string(3) "985" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(7) "RAYMOND" ["zipstate"]=> string(2) "WA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "46.64" ["iplongitude"]=> string(7) "-123.63" ["ziplocation"]=> string(16) "NA-US-WA-RAYMOND" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "2476" ["zippopulation"]=> string(4) "4517" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "985" ["zipcity"]=> string(7) "OLYMPIA" ["zipstate"]=> string(2) "WA" }

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

array(22) { ["id"]=> string(5) "20914" ["State"]=> string(2) "WA" ["CityName"]=> string(7) "Olympia" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "309" ["Population"]=> string(5) "33840" ["Latitude"]=> string(9) "47.042418" ["Longitude"]=> string(11) "-122.893077" ["PrimaryAC"]=> string(3) "360" ["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) "20914" ["Population2000"]=> string(5) "42514" ["FIPS"]=> string(7) "5351300" ["cTZoffset"]=> string(2) "-8" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "14" }

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

No Rows in Recordset!

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

28 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
20964	WA	Seattle	0	556	516259	47.626353	-122.333144	206		1		1	1	1	0	20964	563374	5363000	-8	-1	14
20753	WA	Bellevue	0	423	86874	47.597554	-122.159245	425		0		1	1	1	0	20753	109569	5305210	-8	-1	14
20761	WA	Bremerton	0	240	38142	47.570017	-122.652625	360		0		1	0	0	0	20761	37259	5307695	-8	-1	14
20914	WA	Olympia	0	309	33840	47.042418	-122.893077	360		0		1	0	0	0	20914	42514	5351300	-8	-1	14
41848	WA	Edmonds	-1	0	30744	47.807868	-122.360133			0		0	0	0	0		39515	5320750	-8	-1	14
20886	WA	Mercer Island	-1	0	20816	47.569271	-122.232337	206		0		0	0	0	0		22036	5345005	-8	-1	14
20860	WA	Lacey	-1	0	19279	47.026368	-122.80717	360		0		0	0	0	0		31226	5336745	-8	-1	14
20736	WA	Aberdeen	0	206	16565	46.975833	-123.818669	360		0		0	0	0	0	20736	16461	5300100	-8	-1	14
42004	WA	Tumwater	-1	0	9976	47.007768	-122.911074			0		0	0	0	0		12698	5372905	-8	-1	14
41888	WA	Hoquiam	-1	0	8972	46.980332	-123.885506			0		0	0	0	0		9097	5332300	-8	-1	14
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
20969	WA	Shelton	-1	162	7241	47.213702	-123.106088	360		0		0	0	0	0	20969	8442	5363735	-8	-1	14
20875	WA	Lynden	0	0	5709	48.946606	-122.456927	360		0		0	0	0	0		9020	5340805	-8	-1	14
20891	WA	Montesano	-1	1	3064	46.985865	-123.597726	360		0		0	0	0	0	20891	3312	5346895	-8	-1	14
20814	WA	Elma	-1	64	3011	47.005648	-123.406268	360		0		0	0	0	0	20814	3049	5321450	-8	-1	14
20946	WA	Raymond	-1	0	2901	46.679599	-123.738091	360		0		0	0	0	0	20946	2975	5357430	-8	-1	14
41947	WA	Ocean Shores	-1	0	2301	46.971711	-124.154701			0		0	0	0	0		3836	5350570	-8	-1	14
42025	WA	Westport	-1	0	1892	46.890803	-124.109926			0		0	0	0	0		2137	5377630	-8	-1	14
20977	WA	South Bend	-1	39	1551	46.663477	-123.801176	360		0		0	0	0	0	20977	1807	5365625	-8	-1	14
20808	WA	Eatonville	-1	35	1374	46.868253	-122.270065	360		0		0	0	0	0	20808	2012	5320260	-8	-1	14
41834	WA	Cosmopolis	-1	0	1372	46.955352	-123.773176			0		0	0	0	0		1595	5314870	-8	-1	14
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
20884	WA	Mccleary	-1	0	1235	47.055359	-123.268859	360		0		0	0	0	0	20884	1454	5341225	-8	-1	14
21029	WA	Winlock	-1	0	1027	46.491308	-122.937588	360		0		0	0	0	0	21029	1166	5379275	-8	-1	14
41997	WA	Taholah	-1	0	788	47.34561	-124.287767			0		0	0	0	0		824	5370175	-8	-1	14
20898	WA	Napavine	-1	0	745	46.579284	-122.910935	360		0		0	0	0	0		1361	5347980	-8	-1	14
41946	WA	Oakville	-1	0	493	46.839312	-123.233599			0		0	0	0	0		675	5350430	-8	-1	14
20961	WA	Roy	0	138	258	47.003382	-122.544171	253		0		0	0	0	0	20961	260	5360160	-8	-1	14
20844	WA	Hoodsport	-1	133		47.446972	-123.198634	360		0		0	0	0	0	20844			-8	-1	14
21010	WA	Union	-1	1		47.336838	-123.074952	360		0		0	0	0	0	21010			-8	-1	14

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

53 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
98501	OLYMPIA	WA	31077	Olympia	14
98503	LACEY	WA	28782	Lacey	14
98584	SHELTON	WA	26249	Shelton	14
98513	OLYMPIA	WA	25697	Olympia	14
98502	OLYMPIA	WA	22992	Olympia	14
98512	OLYMPIA	WA	22068	Olympia	14
98531	CENTRALIA	WA	17980	Centralia
98532	CHEHALIS	WA	17358	Chehalis
98516	OLYMPIA	WA	17177	Olympia	14
98597	YELM	WA	17154	Yelm
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
98520	ABERDEEN	WA	15882	Aberdeen	14
98506	OLYMPIA	WA	14357	Olympia	14
98579	ROCHESTER	WA	9937	Rochester
98528	BELFAIR	WA	8469	Belfair
98550	HOQUIAM	WA	8013	Hoquiam	14
98580	ROY	WA	7358	Roy	14
98541	ELMA	WA	7129	Elma	14
98563	MONTESANO	WA	6399	Montesano	14
98589	TENINO	WA	6175	Tenino
98596	WINLOCK	WA	4748	Winlock	14
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
98577	RAYMOND	WA	4517	Raymond	14
98569	OCEAN SHORES	WA	4354	Ocean Shores	14
98576	RAINIER	WA	3937	Rainier
98591	TOLEDO	WA	3330	Toledo
98570	ONALASKA	WA	3103	Onalaska
98524	ALLYN	WA	3019
98557	MCCLEARY	WA	2526	Mccleary	14
98595	WESTPORT	WA	2384	Westport	14
98546	GRAPEVIEW	WA	2093
98568	OAKVILLE	WA	1966	Oakville	14
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
98537	COSMOPOLIS	WA	1859	Cosmopolis	14
98564	MOSSYROCK	WA	1840	Mossyrock
98548	HOODSPORT	WA	1820	Hoodsport	14
98586	SOUTH BEND	WA	1730	South Bend	14
98592	UNION	WA	1587	Union	14
98588	TAHUYA	WA	1161
98547	GRAYLAND	WA	959	Grayland
98593	VADER	WA	861	Vader
98572	PE ELL	WA	692	Pe Ell
98582	SALKUM	WA	591	Salkum
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
98585	SILVER CREEK	WA	561
98542	ETHEL	WA	467
98555	LILLIWAUP	WA	411	Lilliwaup
98526	AMANDA PARK	WA	0	Amanda Park
98533	CINEBAR	WA	0
98535	COPALIS BEACH	WA	0	Copalis Beach
98536	COPALIS CROSSING	WA	0
98538	CURTIS	WA	0	Curtis
98552	HUMPTULIPS	WA	0	Humptulips
98560	MATLOCK	WA	0
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
98575	QUINAULT	WA	0
98581	RYDERWOOD	WA	0
98590	TOKELAND	WA	0	Tokeland

Station K214FI-FX

City RAYMOND-WA

City , is located in DMAID: