Fix W246AR 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 = 'BENSALEM' and State = 'PA'

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: 1754167530.03
End: 1754167530.0303
Elapsed time: 0.2761 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('PA','Bensalem',-1)

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

array(22) { ["id"]=> string(5) "79977" ["State"]=> string(2) "PA" ["CityName"]=> string(8) "Bensalem" ["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) "19020" ["zip3"]=> string(3) "190" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(8) "BENSALEM" ["zipstate"]=> string(2) "PA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(4) "40.1" ["iplongitude"]=> string(6) "-74.93" ["ziplocation"]=> string(17) "NA-US-PA-BENSALEM" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "27969" ["zippopulation"]=> string(5) "47276" ["zipincome"]=> string(7) "8388607" }

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

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

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

array(22) { ["id"]=> string(5) "16878" ["State"]=> string(2) "PA" ["CityName"]=> string(9) "Levittown" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "276" ["Population"]=> string(5) "55362" ["Latitude"]=> string(9) "40.154109" ["Longitude"]=> string(10) "-74.849756" ["PrimaryAC"]=> string(3) "267" ["ZoneDesc"]=> string(20) "(Philadelphia SZ 44)" ["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) "16878" ["Population2000"]=> string(5) "53966" ["FIPS"]=> string(7) "4242928" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }

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

No Rows in Recordset!

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

65 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
19020	BENSALEM	PA	47276	Bensalem
19067	MORRISVILLE	PA	47005	Morrisville
19083	HAVERTOWN	PA	32532	Havertown
19063	MEDIA	PA	31040	Media	6
19082	UPPER DARBY	PA	30828	Upper Darby
19047	LANGHORNE	PA	30760	Langhorne
19002	AMBLER	PA	28814	Ambler
19087	WAYNE	PA	27128	Wayne
19038	GLENSIDE	PA	26925	Glenside
19026	DREXEL HILL	PA	26723	Drexel Hill
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
19061	MARCUS HOOK	PA	26101	Marcus Hook
19053	FEASTERVILLE TREVOSE	PA	24238
19050	LANSDOWNE	PA	23056	Lansdowne
19064	SPRINGFIELD	PA	22318	Springfield
19013	CHESTER	PA	21559	Chester
19018	CLIFTON HEIGHTS	PA	19766	Clifton Heights
19006	HUNTINGDON VALLEY	PA	19754	Huntingdon Valley
19040	HATBORO	PA	18843	Hatboro
19014	ASTON	PA	18502
19008	BROOMALL	PA	18432	Broomall
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
19007	BRISTOL	PA	17778	Bristol
19046	JENKINTOWN	PA	17162	Jenkintown	6
19090	WILLOW GROVE	PA	16854	Willow Grove
19027	ELKINS PARK	PA	16454	Elkins Park
19073	NEWTOWN SQUARE	PA	16449	Newtown Square
19023	DARBY	PA	16055	Darby
19010	BRYN MAWR	PA	15730	Bryn Mawr
19054	LEVITTOWN	PA	15140	Levittown
19001	ABINGTON	PA	15006
19057	LEVITTOWN	PA	14645	Levittown
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
19044	HORSHAM	PA	14168	Horsham
19056	LEVITTOWN	PA	13810	Levittown
19015	BROOKHAVEN	PA	13552	Brookhaven
19096	WYNNEWOOD	PA	12684
19055	LEVITTOWN	PA	11766	Levittown
19030	FAIRLESS HILLS	PA	11015	Fairless Hills
19036	GLENOLDEN	PA	10991	Glenolden
19003	ARDMORE	PA	10660	Ardmore
19086	WALLINGFORD	PA	10584
19078	RIDLEY PARK	PA	9956	Ridley Park
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
19004	BALA CYNWYD	PA	9165	Bala Cynwyd
19072	NARBERTH	PA	8771	Narberth
19021	CROYDON	PA	8630	Croydon
19081	SWARTHMORE	PA	8194	Swarthmore
19079	SHARON HILL	PA	7196	Sharon Hill
19033	FOLSOM	PA	6874	Folsom
19075	ORELAND	PA	6573	Oreland
19070	MORTON	PA	6334	Morton
19034	FORT WASHINGTON	PA	6067	Fort Washington
19012	CHELTENHAM	PA	5933	Cheltenham
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
19032	FOLCROFT	PA	5451	Folcroft
19076	PROSPECT PARK	PA	5397	Prospect Park
19025	DRESHER	PA	5352
19085	VILLANOVA	PA	5346
19074	NORWOOD	PA	5208	Norwood
19095	WYNCOTE	PA	5124	Wyncote
19066	MERION STATION	PA	5008	Merion Station
19041	HAVERFORD	PA	4830
19031	FLOURTOWN	PA	4002	Flourtown
19035	GLADWYNE	PA	3761
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
19094	WOODLYN	PA	3711	Woodlyn
19029	ESSINGTON	PA	3453
19022	CRUM LYNNE	PA	2710
19043	HOLMES	PA	2430
19060	GARNET VALLEY	PA	0

Station W246AR-FX

City BENSALEM-PA

City Bensalem, PA is located in DMAID: