Fix W229AO 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) "" }

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

array(22) { ["id"]=> string(5) "79998" ["State"]=> string(2) "PA" ["CityName"]=> string(11) "Fogelsville" ["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) "18051" ["zip3"]=> string(3) "180" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(11) "FOGELSVILLE" ["zipstate"]=> string(2) "PA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "40.59" ["iplongitude"]=> string(6) "-75.66" ["ziplocation"]=> string(20) "NA-US-PA-FOGELSVILLE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "1806" ["zippopulation"]=> string(4) "3264" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "180" ["zipcity"]=> string(9) "BETHLEHEM" ["zipstate"]=> string(2) "PA" }

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

array(22) { ["id"]=> string(5) "16333" ["State"]=> string(2) "PA" ["CityName"]=> string(9) "Bethlehem" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "167" ["Population"]=> string(5) "71428" ["Latitude"]=> string(9) "40.626198" ["Longitude"]=> string(10) "-75.375673" ["PrimaryAC"]=> string(3) "610" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "1" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "16333" ["Population2000"]=> string(5) "71329" ["FIPS"]=> string(7) "4206088" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(1) "6" }

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

No Rows in Recordset!

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

23 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
16850	PA	Philadelphia	0	453	1585577	39.998012	-75.144793	215	Zone 1 - Downtown	1		1	1	1	0	16850	1517550	4260000	-5	-1	6
12552	NJ	Camden	0	230	87492	39.937195	-75.106186	609		0		1	1	0	0	12552	79904	3410000	-5	-1	6
16333	PA	Bethlehem	0	167	71428	40.626198	-75.375673	610		0		1	1	0	0	16333	71329	4206088	-5	-1	6
12559	NJ	Cherry Hill	0	0	69319	39.902342	-74.996106	856		0		0	0	0	0				-5	-1	6
38205	NJ	Pennsauken	-1	0	34733	39.956562	-75.055918			0		0	0	0	0		35737	3457690	-5	-1	6
12567	NJ	Collingswood	-1	115	15289	39.916141	-75.074671	856		0		0	1	0	0	12567	14326	3414260	-5	-1	6
12609	NJ	Hammonton	-1	96	12208	39.641181	-74.786162	609		0		0	0	0	0	12609	12604	3429430	-5	-1	6
12660	NJ	Mount Holly	0	274	10639	39.995033	-74.786824	609		0		1	1	0	0	12660			-5	-1	6
12641	NJ	Marlton	0	152	10228	39.898863	-74.927534	856		0		1	1	0	0	12641	10260	3444100	-5	-1	6
12548	NJ	Burlington	0	182	9835	40.07311	-74.855693	609		0		0	1	0	0	12548	9736	3408920	-5	-1	6
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
12715	NJ	Salem	-1	92	6883	39.569584	-75.467622	856		0		0	1	0	0	12715	5857	3465490	-5	-1	6
16854	PA	Media	-1	160	5957	39.918761	-75.388127	610	(Philadelphia SZ 12)	0		1	1	1	0	16854	5533	4248480	-5	-1	6
12535	NJ	Berlin	0	105	5672	39.793015	-74.93518	856		0		0	1	0	0	12535	6149	3405440	-5	-1	6
16307	PA	Bangor	-1	4	5383	40.866749	-75.210759	610		0		0	0	0	0	16307	5319	4204032	-5	-1	6
12537	NJ	Blackwood	-1	104	5120	39.795981	-75.062304	856		0		1	1	0	0	12537	4692	3406040	-5	-1	6
16616	PA	Jenkintown	0	0	4574	40.09606	-75.129415	215		0		0	0	0	0		4478	4238000	-5	-1	6
16842	PA	Pen Argyl	-1	0	3492	40.868854	-75.255451	610		0		0	0	0	0	16842	3615	4258696	-5	-1	6
12737	NJ	Tuckerton	-1	60	3048	39.601355	-74.338125	609		0		0	0	0	0	12737	3517	3474210	-5	-1	6
12731	NJ	Swedesboro	0	175	2024	39.748125	-75.311411	856		0		0	1	0	0	12731	2055	3471850	-5	-1	6
40126	PA	Red Hill	-1	0	1794	40.376288	-75.484308			0		0	0	0	0		2196	4263808	-5	-1	6
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
40161	PA	Schnecksville	-1	0	1780	40.675741	-75.61626			0		0	0	0	0		1989	4268192	-5	-1	6
12687	NJ	Pemberton	0	89	1367	39.97032	-74.683368	609		0		0	1	0	0	12687	1210	3457480	-5	-1	6
12526	NJ	Barnegat	0	141	1160	39.754153	-74.221239	609		0		0	0	0	0	12526	1690	3403040	-5	-1	6

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

46 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
18017	BETHLEHEM	PA	32654	Bethlehem	6
18042	EASTON	PA	30988	Easton
18018	BETHLEHEM	PA	25707	Bethlehem	6
18052	WHITEHALL	PA	23943	Whitehall
18045	EASTON	PA	23750	Easton
18015	BETHLEHEM	PA	22650	Bethlehem	6
18064	NAZARETH	PA	21767	Nazareth
18062	MACUNGIE	PA	21548	Macungie
18020	BETHLEHEM	PA	18523	Bethlehem	6
18067	NORTHAMPTON	PA	16693	Northampton
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
18049	EMMAUS	PA	16033	Emmaus
18013	BANGOR	PA	15081	Bangor	6
18040	EASTON	PA	13958	Easton
18036	COOPERSBURG	PA	11476	Coopersburg
18055	HELLERTOWN	PA	10340	Hellertown
18014	BATH	PA	10237	Bath
18080	SLATINGTON	PA	10196	Slatington
18071	PALMERTON	PA	8987	Palmerton
18032	CATASAUQUA	PA	8120	Catasauqua
18073	PENNSBURG	PA	7762	Pennsburg
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
18088	WALNUTPORT	PA	7590	Walnutport
18058	KUNKLETOWN	PA	7286	Kunkletown
18069	OREFIELD	PA	7222
18034	CENTER VALLEY	PA	6617
18078	SCHNECKSVILLE	PA	6560	Schnecksville	6
18037	COPLAY	PA	6486	Coplay
18031	BREINIGSVILLE	PA	6106
18072	PEN ARGYL	PA	6059	Pen Argyl	6
18066	NEW TRIPOLI	PA	5517	New Tripoli
18091	WIND GAP	PA	5275	Wind Gap
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
18011	ALBURTIS	PA	5062	Alburtis
18041	EAST GREENVILLE	PA	4993	East Greenville
18074	PERKIOMENVILLE	PA	4576
18054	GREEN LANE	PA	3949	Green Lane
18051	FOGELSVILLE	PA	3264	Fogelsville
18038	DANIELSVILLE	PA	2820
18092	ZIONSVILLE	PA	2807
18076	RED HILL	PA	2474	Red Hill	6
18053	GERMANSVILLE	PA	2117
18077	RIEGELSVILLE	PA	1938	Riegelsville
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
18059	LAURYS STATION	PA	1117
18056	HEREFORD	PA	894
18070	PALM	PA	801
18087	TREXLERTOWN	PA	765
18016	BETHLEHEM	PA	423	Bethlehem	6
18035	CHERRYVILLE	PA	0

Station W229AO-FX

City Fogelsville-PA

City Fogelsville, PA is located in DMAID: