Fix K257DB 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 = 'ANCHOR POINT' and State = 'AK'

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

Number of rows returned = 1
Start: 1754151752.3145
End: 1754151752.3147
Elapsed time: 0.1910 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
44 AK Anchor Point -1 0 866 59.777468 -151.77022 907 0 0 0 0 0 1845 203110 -9 -1 172

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

NULL

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

array(13) { ["zipcode"]=> string(5) "99556" ["zip3"]=> string(3) "995" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(12) "ANCHOR POINT" ["zipstate"]=> string(2) "AK" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "59.82" ["iplongitude"]=> string(7) "-151.59" ["ziplocation"]=> string(21) "NA-US-AK-ANCHOR POINT" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "1080" ["zippopulation"]=> string(4) "1802" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "995" ["zipcity"]=> string(9) "ANCHORAGE" ["zipstate"]=> string(2) "AK" }

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

array(22) { ["id"]=> string(2) "45" ["State"]=> string(2) "AK" ["CityName"]=> string(9) "Anchorage" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(2) "40" ["Population"]=> string(6) "226338" ["Latitude"]=> string(7) "61.1919" ["Longitude"]=> string(11) "-149.762097" ["PrimaryAC"]=> string(3) "907" ["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(2) "45" ["Population2000"]=> string(6) "260283" ["FIPS"]=> string(6) "203000" ["cTZoffset"]=> string(2) "-9" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "172" }

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

No Rows in Recordset!

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

69 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
45	AK	Anchorage	0	40	226338	61.1919	-149.762097	907		0		0	0	0	0	45	260283	203000	-9	-1	172
450	AK	Kodiak	0	2	6365	57.793109	-152.394188	907		0		0	0	0	0	450	6334	240950	-9	-1	172
440	AK	Kenai	-1	0	6327	60.558738	-151.229616	907		0		0	0	0	0	440	6942	238420	-9	-1	172
364	AK	Bethel	-1	1	4674	60.789724	-161.779332	907		0		0	0	0	0	364	5471	206520	-9	-1	172
552	AK	Valdez	-1	2	4068	61.122947	-146.305178	907		0		0	0	0	0	552	4036	282200	-9	-1	172
556	AK	Wasilla	-1	1	4028	61.581732	-149.452539	907		0		0	0	0	0	556	5469	283080	-9	-1	172
32279	AK	Sterling	-1	0	3802	60.529635	-150.797887			0		0	0	0	0		4705	273070	-9	-1	172
425	AK	Homer	-1	2	3660	59.643059	-151.5259	907		0		0	0	0	0	425	3946	233140	-9	-1	172
527	AK	Soldotna	0	5	3482	60.486617	-151.075373	907		0		0	0	0	0	527	3759	271640	-9	-1	172
551	AK	Unalaska	-1	0	3089	53.888984	-166.527239	907		0		0	0	0	0	551	4283	280770	-9	-1	172
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
492	AK	Palmer	-1	5	2866	61.601879	-149.117351	907		0		0	0	0	0	492	4533	258660	-9	-1	172
478	AK	Nikiski	-1	0	2743	60.707891	-151.262646	907		0		0	0	0	0		4327	254050	-9	-1	172
385	AK	Cordova	-1	0	2110	60.539206	-145.70223	907		0		0	0	0	0	385	2454	217410	-9	-1	172
391	AK	Dillingham	-1	0	2017	59.046751	-158.508665	907		0		0	0	0	0	391	2466	218950	-9	-1	172
32178	AK	Big Lake	-1	0	1477	61.537449	-149.891104			0		0	0	0	0	32178	2635	207070	-9	-1	172
514	AK	Sand Point	-1	0	878	55.336593	-160.493234	907		0		0	0	0	0	514	952	267020	-9	-1	172
44	AK	Anchor Point	-1	0	866	59.777468	-151.77022	907		0		0	0	0	0		1845	203110	-9	-1	172
427	AK	Hooper Bay	-1	0	845	61.52898	-166.096196	907		0		0	0	0	0	427	1014	233470	-9	-1	172
550	AK	Unalakleet	-1	2	714	63.878907	-160.78968	907		0		0	0	0	0	550	747	280660	-9	-1	172
32218	AK	Houston	-1	0	697	61.608309	-149.773719			0		0	0	0	0		1202	233800	-9	-1	172
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
405	AK	Emmonak	-1	0	642	62.777328	-164.54492	907		0		0	0	0	0	405	767	222910	-9	-1	172
542	AK	Togiak	-1	0	613	59.059134	-160.383186	907		0		0	0	0	0	542	809	277690	-9	-1	172
32184	AK	Chevak	-1	0	598	61.527673	-165.578702			0		0	0	0	0	32184	765	213230	-9	-1	172
40	AK	Akutan	-1	0	589	54.14495	-165.801457	907		0		0	0	0	0	40	713	201090	-9	-1	172
32247	AK	Naknek	-1	0	575	58.739857	-156.971704			0		0	0	0	0		678	252060	-9	-1	172
32170	AK	Alakanuk	-1	0	544	62.684616	-164.645414			0		0	0	0	0	32170	652	201200	-9	-1	172
355	AK	Aniak	-1	0	540	61.578821	-159.550255	907		0		0	0	0	0	355	572	203550	-9	-1	172
561	AK	Yakutat	-1	0	534	59.545012	-139.700175	907		0		0	0	0	0	561	680	286490	-9	-1	172
508	AK	Quinhagak	-1	0	501	59.753374	-161.902701	907		0		0	0	0	0	508	555	264600	-9	-1	172
38	AK	Akiachak	-1	0	481	60.899547	-161.413381	907		0		0	0	0	0	38	585	200760	-9	-1	172
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
481	AK	Ninilchik	-1	0	456	59.992821	-151.541946	907		0		0	0	0	0	481	772	254480	-9	-1	172
443	AK	King Cove	-1	0	451	55.072125	-162.31804	907		0		0	0	0	0	443	792	239410	-9	-1	172
416	AK	Glennallen	-1	1	451	62.109596	-145.557236	907		0		0	0	0	0	416	554	228740	-9	-1	172
544	AK	Toksook Bay	-1	0	420	60.530513	-165.103215	907		0		0	0	0	0	544	532	278240	-9	-1	172
462	AK	Manokotak	-1	0	385	58.981087	-159.055808	907		0		0	0	0	0	462	399	246890	-9	-1	172
32225	AK	Kasilof	-1	0	383	60.335274	-151.233594			0		0	0	0	0		471	238090	-9	-1	172
516	AK	Scammon Bay	-1	0	343	61.842489	-165.581694	907		0		0	0	0	0	516	465	267680	-9	-1	172
372	AK	Chefornak	-1	0	320	60.15907	-164.269437	907		0		0	0	0	0	372	394	212680	-9	-1	172
518	AK	Seldovia	-1	0	316	59.438827	-151.712377	907		0		0	0	0	0	518	286	268340	-9	-1	172
32281	AK	Sutton	-1	0	308	61.717255	-148.881229			0		0	0	0	0				-9	-1	172
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
32229	AK	Kongiganak	-1	0	294	59.953896	-162.895199			0		0	0	0	0	32229	359	241610	-9	-1	172
490	AK	Old Harbor	-1	0	284	57.197285	-153.307806	907		0		0	0	0	0	490	237	257340	-9	-1	172
424	AK	Holy Cross	-1	1	277	62.198048	-159.773418	907		0		0	0	0	0	424	227	233030	-9	-1	172
535	AK	Talkeetna	-1	0	250	62.311397	-150.087053	907		0		0	0	0	0	535	772	274830	-9	-1	172
512	AK	Russian Mission	-1	0	246	61.785522	-161.334074	907		0		0	0	0	0	512	296	265700	-9	-1	172
558	AK	Whittier	-1	0	243	60.774174	-148.677649	907		0		0	0	0	0	558	182	284510	-9	-1	172
418	AK	Goodnews Bay	-1	0	241	59.121408	-161.585835	907		0		0	0	0	0	418	230	229290	-9	-1	172
506	AK	Port Lions	-1	0	222	57.86807	-152.880047	907		0		0	0	0	0	506	256	263610	-9	-1	172
419	AK	Grayling	-1	0	208	62.910472	-160.06725	907		0		0	0	0	0	419	194	230060	-9	-1	172
32217	AK	Hope	-1	0	161	60.919433	-149.642044			0		0	0	0	0	32217	137	233580	-9	-1	172
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
383	AK	Cold Bay	-1	0	148	55.209038	-162.714298	907		0		0	0	0	0	383	88	216530	-9	-1	172
459	AK	Larsen Bay	-1	0	147	57.536651	-153.99144	907		0		0	0	0	0	459	115	243040	-9	-1	172
520	AK	Shageluk	-1	0	139	62.655998	-159.531132	907		0		0	0	0	0	520	129	268670	-9	-1	172
398	AK	Egegik	-1	0	122	58.219292	-157.357989	907		0		0	0	0	0	398	116	221150	-9	-1	172
537	AK	Tatitlek	-1	0	119	60.867083	-146.677209	907		0		0	0	0	0	537	107	275380	-9	-1	172
479	AK	Nikolai	-1	0	109	63.010838	-154.383895	907		0		0	0	0	0	479	100	254150	-9	-1	172
495	AK	Perryville	-1	0	108	55.913632	-159.151143	907		0		0	0	0	0	495	107	260200	-9	-1	172
526	AK	Sleetmute	-1	0	106	61.683931	-157.152024	907		0		0	0	0	0	526	100	271090	-9	-1	172
32196	AK	Crooked Creek	-1	0	106	61.859821	-158.128884			0		0	0	0	0	32196	137	217850	-9	-1	172
432	AK	Iliamna	-1	0	94	59.765135	-154.840312	907		0		0	0	0	0	432	102	235120	-9	-1	172
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
357	AK	Anvik	-1	0	82	62.655659	-160.209237	907		0		0	0	0	0	357	104	203880	-9	-1	172
470	AK	Moose Pass	-1	0	81	60.502499	-149.428269	907		0		0	0	0	0	470	206	250190	-9	-1	172
438	AK	Karluk	-1	0	71	57.578081	-154.362557	907		0		0	0	0	0	438	27	237540	-9	-1	172
408	AK	False Pass	-1	0	68	54.827886	-163.39909	907		0		0	0	0	0	408	64	224660	-9	-1	172
504	AK	Port Alsworth	-1	0	55	60.208281	-154.306586	907		0		0	0	0	0	504	104	262620	-9	-1	172
395	AK	Eagle River	-1	1		61.303131	-149.424518	907		0		0	0	0	0	395			-9	-1	172
471	AK	Mountain Village	-1	0		62.090075	-163.723936	907		0		0	0	0	0	471	755	251180	-9	-1	172
415	AK	Girdwood	-1	0		60.957674	-149.140623	907		0		0	0	0	0	415			-9	-1	172
79845	AK	Nunam Iqua	-1																	0	172

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

25 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
99504	ANCHORAGE	AK	31110	Anchorage	172
99507	ANCHORAGE	AK	30403	Anchorage	172
99508	ANCHORAGE	AK	24660	Anchorage	172
99577	EAGLE RIVER	AK	23726	Eagle River	172
99502	ANCHORAGE	AK	18918	Anchorage	172
99515	ANCHORAGE	AK	18877	Anchorage	172
99516	ANCHORAGE	AK	17313	Anchorage	172
99517	ANCHORAGE	AK	12984	Anchorage	172
99503	ANCHORAGE	AK	11361	Anchorage	172
99501	ANCHORAGE	AK	11113	Anchorage	172
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
99518	ANCHORAGE	AK	8070	Anchorage	172
99567	CHUGIAK	AK	7692	Chugiak
99506	JBER	AK	6290
99505	JBER	AK	4647
99556	ANCHOR POINT	AK	1802	Anchor Point	172
99588	GLENNALLEN	AK	1151	Glennallen	172
99573	COPPER CENTER	AK	878	Copper Center
99586	GAKONA	AK	455	Gakona
99513	ANCHORAGE	AK	0	Anchorage	172
99529	ANCHORAGE	AK	0	Anchorage	172
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
99530	ANCHORAGE	AK	0	Anchorage	172
99540	INDIAN	AK	0
99599	ANCHORAGE	AK	0	Anchorage	172
99568	CLAM GULCH	AK	0	Clam Gulch
99572	COOPER LANDING	AK	0	Cooper Landing

Station K257DB-FX

City ANCHOR POINT-AK

City , is located in DMAID: