Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix WKMB AM Station DMA
array(0) { }
*** DMA ***
array(12) { ["odbcts"]=> string(19) "2019-07-16 06:29:49" ["dmarank"]=> string(4) "9999" ["dmaID"]=> string(4) "9997" ["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 = 'STIRLING' and State = 'NJ'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const2Using where


Number of rows returned = 0
Start: 1754142738.8884
End: 1754142738.8886
Elapsed time: 0.1669 ms No Rows in Recordset!

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

*** city ***************
array(22) { ["id"]=> string(5) "79851" ["State"]=> string(2) "NJ" ["CityName"]=> string(8) "Stirling" ["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) "07980" ["zip3"]=> string(3) "079" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(8) "STIRLING" ["zipstate"]=> string(2) "NJ" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "40.68" ["iplongitude"]=> string(6) "-74.49" ["ziplocation"]=> string(17) "NA-US-NJ-STIRLING" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "1183" ["zippopulation"]=> string(4) "2093" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "079" ["zipcity"]=> string(10) "MORRISTOWN" ["zipstate"]=> string(2) "NJ" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "12658" ["State"]=> string(2) "NJ" ["CityName"]=> string(10) "Morristown" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "361" ["Population"]=> string(5) "16189" ["Latitude"]=> string(7) "40.7989" ["Longitude"]=> string(10) "-74.478526" ["PrimaryAC"]=> string(3) "973" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "1" ["allegiance"]=> string(1) "1" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "12658" ["Population2000"]=> string(5) "18544" ["FIPS"]=> string(7) "3448300" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "39" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
6 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
12665NJNew Brunswick004171140.488304-74.44775173200000485733451210-5-139
12637NJLong Branch02672865840.297932-73.9909717320011012637313403441310-5-139
12658NJMorristown03611618940.7989-74.4785269730111012658185443448300-5-139
12575NJDover01501511540.885899-74.5582419730111012575181883418070-5-139
12580NJEatontown01891380040.293571-74.0567157320011012580140083419840-5-139
12536NJBernardsville0179659740.7188-74.577675908011101253673453405590-5-139
**** cities in zip3 **************
25 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
07960MORRISTOWNNJ33647Morristown39
07920BASKING RIDGENJ24379
07901SUMMITNJ19255Summit
07950MORRIS PLAINSNJ17593Morris Plains
07928CHATHAMNJ16921Chatham
07940MADISONNJ12693Madison
07922BERKELEY HEIGHTSNJ11230Berkeley Heights
07936EAST HANOVERNJ10659East Hanover
07974NEW PROVIDENCENJ10648New Providence
07932FLORHAM PARKNJ9267Florham Park
zipcodezipcityzipstatezippopulationcitynameDMAID
07945MENDHAMNJ9193Mendham
07981WHIPPANYNJ8057Whippany
07930CHESTERNJ7622Chester
07921BEDMINSTERNJ6958Bedminster
07924BERNARDSVILLENJ6545Bernardsville39
07927CEDAR KNOLLSNJ3204Cedar Knolls
07931FAR HILLSNJ3060Far Hills
07946MILLINGTONNJ2970Millington
07933GILLETTENJ2952
07980STIRLINGNJ2093Stirling
zipcodezipcityzipstatezippopulationcitynameDMAID
07934GLADSTONENJ1371
07976NEW VERNONNJ1310
07935GREEN VILLAGENJ529
07999WHIPPANYNJ0Whippany
07939LYONSNJ0
Station WKMB-AM
City STIRLING-NJ

City Stirling, NJ is located in DMAID: