Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix W237CD 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 = 'HARRISONVILLE' and State = 'NJ'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const2Using where


Number of rows returned = 0
Start: 1754170116.7327
End: 1754170116.7334
Elapsed time: 0.6492 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('NJ','Harrisonville',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80061" ["State"]=> string(2) "NJ" ["CityName"]=> string(13) "Harrisonville" ["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) "08039" ["zip3"]=> string(3) "080" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(13) "HARRISONVILLE" ["zipstate"]=> string(2) "NJ" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "39.73" ["iplongitude"]=> string(6) "-75.32" ["ziplocation"]=> string(22) "NA-US-NJ-HARRISONVILLE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "080" ["zipcity"]=> string(11) "CHERRY HILL" ["zipstate"]=> string(2) "NJ" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "12559" ["State"]=> string(2) "NJ" ["CityName"]=> string(11) "Cherry Hill" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(1) "0" ["Population"]=> string(5) "69319" ["Latitude"]=> string(9) "39.902342" ["Longitude"]=> string(10) "-74.996106" ["PrimaryAC"]=> string(3) "856" ["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"]=> NULL ["Population2000"]=> NULL ["FIPS"]=> NULL ["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!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
16850PAPhiladelphia0453158557739.998012-75.144793215Zone 1 - Downtown111101685015175504260000-5-16
12552NJCamden02308749239.937195-75.1061866090110012552799043410000-5-16
16333PABethlehem01677142840.626198-75.3756736100110016333713294206088-5-16
12559NJCherry Hill006931939.902342-74.99610685600000-5-16
38205NJPennsauken-103473339.956562-75.05591800000357373457690-5-16
12567NJCollingswood-11151528939.916141-75.0746718560010012567143263414260-5-16
12609NJHammonton-1961220839.641181-74.7861626090000012609126043429430-5-16
12660NJMount Holly02741063939.995033-74.7868246090110012660-5-16
12641NJMarlton01521022839.898863-74.9275348560110012641102603444100-5-16
12548NJBurlington0182983540.07311-74.855693609001001254897363408920-5-16
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
12715NJSalem-192688339.569584-75.467622856001001271558573465490-5-16
16854PAMedia-1160595739.918761-75.388127610 (Philadelphia SZ 12)011101685455334248480-5-16
12535NJBerlin0105567239.793015-74.93518856001001253561493405440-5-16
16307PABangor-14538340.866749-75.210759610000001630753194204032-5-16
12537NJBlackwood-1104512039.795981-75.062304856011001253746923406040-5-16
16616PAJenkintown00457440.09606-75.1294152150000044784238000-5-16
16842PAPen Argyl-10349240.868854-75.255451610000001684236154258696-5-16
12737NJTuckerton-160304839.601355-74.338125609000001273735173474210-5-16
12731NJSwedesboro0175202439.748125-75.311411856001001273120553471850-5-16
40126PARed Hill-10179440.376288-75.4843080000021964263808-5-16
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
40161PASchnecksville-10178040.675741-75.616260000019894268192-5-16
12687NJPemberton089136739.97032-74.683368609001001268712103457480-5-16
12526NJBarnegat0141116039.754153-74.221239609000001252616903403040-5-16
**** cities in zip3 **************
75 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
08081SICKLERVILLENJ41753
08053MARLTONNJ40939Marlton6
08054MOUNT LAURELNJ38300
08021CLEMENTONNJ37348Clementon
08080SEWELLNJ33729
08094WILLIAMSTOWNNJ33155Williamstown
08012BLACKWOODNJ33128Blackwood6
08096WEST DEPTFORDNJ29504
08003CHERRY HILLNJ27889Cherry Hill6
08016BURLINGTONNJ27446Burlington6
zipcodezipcityzipstatezippopulationcitynameDMAID
08046WILLINGBORONJ27170Willingboro
08055MEDFORDNJ24851Medford
08043VOORHEESNJ24732
08075RIVERSIDENJ24711Riverside
08088VINCENTOWNNJ22028Vincentown
08060MOUNT HOLLYNJ21570Mount Holly6
08050MANAHAWKINNJ20931Manahawkin51
08037HAMMONTONNJ20771Hammonton6
08087TUCKERTONNJ20609Tuckerton6
08005BARNEGATNJ19593Barnegat6
zipcodezipcityzipstatezippopulationcitynameDMAID
08002CHERRY HILLNJ18807Cherry Hill6
08057MOORESTOWNNJ18385Moorestown
08015BROWNS MILLSNJ17598Browns Mills
08077RIVERTONNJ16482Riverton
08034CHERRY HILLNJ16356Cherry Hill6
08052MAPLE SHADENJ15607Maple Shade
08085SWEDESBORONJ15563Swedesboro6
08033HADDONFIELDNJ14871Haddonfield
08062MULLICA HILLNJ13484Mullica Hill
08028GLASSBORONJ13452Glassboro22
zipcodezipcityzipstatezippopulationcitynameDMAID
08009BERLINNJ11467Berlin6
08070PENNSVILLENJ11154Pennsville
08004ATCONJ10625
08048LUMBERTONNJ10599
08069PENNS GROVENJ10482Penns Grove
08030GLOUCESTER CITYNJ10400Gloucester City
08031BELLMAWRNJ9879Bellmawr
08051MANTUANJ9204
08010BEVERLYNJ9089Beverly
08079SALEMNJ8679Salem6
zipcodezipcityzipstatezippopulationcitynameDMAID
08071PITMANNJ8346Pitman
08022COLUMBUSNJ8335
08083SOMERDALENJ8321Somerdale
08093WESTVILLENJ7971Westville
08098WOODSTOWNNJ7744Woodstown
08090WENONAHNJ7368Wenonah
08086THOROFARENJ7031
08078RUNNEMEDENJ7017Runnemede
08008BEACH HAVENNJ6743Beach Haven
08035HADDON HEIGHTSNJ6656Haddon Heights
zipcodezipcityzipstatezippopulationcitynameDMAID
08065PALMYRANJ6356Palmyra
08066PAULSBORONJ6356Paulsboro
08084STRATFORDNJ6077Stratford
08068PEMBERTONNJ5490Pemberton6
08036HAINESPORTNJ5464
08059MOUNT EPHRAIMNJ4835Mount Ephraim
08091WEST BERLINNJ4550
08049MAGNOLIANJ4500Magnolia
08007BARRINGTONNJ4458Barrington
08027GIBBSTOWNNJ4419Gibbstown
zipcodezipcityzipstatezippopulationcitynameDMAID
08056MICKLETONNJ4070
08029GLENDORANJ4040Glendora
08089WATERFORD WORKSNJ3545
08092WEST CREEKNJ3158
08097WOODBURY HEIGHTSNJ2916Woodbury Heights
08063NATIONAL PARKNJ2747National Park
08061MOUNT ROYALNJ2344
08045LAWNSIDENJ2342Lawnside
08026GIBBSBORONJ2097Gibbsboro
08020CLARKSBORONJ1925
zipcodezipcityzipstatezippopulationcitynameDMAID
08067PEDRICKTOWNNJ1451
08041JOBSTOWNNJ897
08019CHATSWORTHNJ871
08014BRIDGEPORTNJ467
08032GRENLOCHNJ0
Station W237CD-FX
City HARRISONVILLE-NJ

City Harrisonville, NJ is located in DMAID: