Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix WZBY FM Station DMA
array(0) { }
*** DMA ***
array(12) { ["odbcts"]=> string(19) "2009-06-13 09:56:14" ["dmarank"]=> string(1) "0" ["dmaID"]=> string(1) "0" ["dmaType"]=> string(1) "C" ["Minority"]=> NULL ["QualType"]=> NULL ["DMAName"]=> string(13) "United States" ["Population25up"]=> string(9) "300000000" ["scanned"]=> NULL ["AvgLatitude"]=> NULL ["AvgLongitude"]=> NULL ["State"]=> string(2) "WW" }
Database: media
SQL: select * from cities where CityName = 'GRAND PORTAGE' and State = 'MN'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 0
Start: 1754143966.0341
End: 1754143966.0343
Elapsed time: 0.1452 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('MN','Grand Portage',-1)

*** city ***************
array(22) { ["id"]=> string(5) "79860" ["State"]=> string(2) "MN" ["CityName"]=> string(13) "Grand Portage" ["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) "55605" ["zip3"]=> string(3) "556" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(13) "GRAND PORTAGE" ["zipstate"]=> string(2) "MN" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "47.96" ["iplongitude"]=> string(6) "-89.68" ["ziplocation"]=> string(22) "NA-US-MN-GRAND PORTAGE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "330" ["zippopulation"]=> string(3) "502" ["zipincome"]=> string(7) "8239011" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "556" ["zipcity"]=> string(11) "TWO HARBORS" ["zipstate"]=> string(2) "MN" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "9619" ["State"]=> string(2) "MN" ["CityName"]=> string(11) "Two Harbors" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(1) "1" ["Population"]=> string(4) "3651" ["Latitude"]=> string(9) "47.025369" ["Longitude"]=> string(10) "-91.673904" ["PrimaryAC"]=> string(3) "218" ["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(4) "9619" ["Population2000"]=> string(4) "3613" ["FIPS"]=> string(7) "2765956" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "204" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
14 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
9160MNCloquet-1561088546.718089-92.465797218000009160112012712160-6-1204
21057WIAshland-12869546.587376-90.880391715000002105786205503225-6-1204
21490WIRice Lake-11799845.498408-91.738844715000002149083205567350-6-1204
9619MNTwo Harbors-11365147.025369-91.67390421800000961936132765956-6-1204
21070WIBarron-10298645.400527-91.847948715000002107032485504875-6-1204
21535WISpooner-11246445.825941-91.891116715000002153526535575625-6-1204
21585WIWashburn-10228546.673989-90.897674715000002158522805583525-6-1204
21261WIHayward-11189746.013085-91.483874715000002126121295533450-6-1204
21518WIShell Lake-10116145.73359-91.917368715000002151813095573200-6-1204
21523WISiren-1086345.783633-92.38016171500000215239885574175-6-1204
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
21066WIBalsam Lake-1079245.45805-92.45487271500000210669505504475-6-1204
21557WISuperior-1248146.65614-92.10363871500000215575005578660-6-1204
21280WIIron River-1046.599552-91.4374377150000021280-6-1204
21505WISarona-1045.73714-91.7758757150000021505-6-1204
**** cities in zip3 **************
11 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
55616TWO HARBORSMN5913Two Harbors204
55604GRAND MARAISMN3068Grand Marais
55614SILVER BAYMN2081Silver Bay
55605GRAND PORTAGEMN502Grand Portage
55612LUTSENMN455
55603FINLANDMN433
55602BRIMSONMN0Brimson
55606HOVLANDMN0Hovland
55613SCHROEDERMN0
55607ISABELLAMN0Isabella
zipcodezipcityzipstatezippopulationcitynameDMAID
55615TOFTEMN0Tofte
***** stations in DMA*************
29 records found!
stationidCallSignLicenseeServicecitynamexStatexcityid
22710BTRNWorld Wide WebWW79841
23163CRN1World Wide WebWW79841
23164CRN2World Wide WebWW79841
23165CRN3World Wide WebWW79841
23166CRN4World Wide WebWW79841
23167CRN5World Wide WebWW79841
23168CRN6World Wide WebWW79841
42585CSPAN1World Wide WebWW79841
42586CSPAN2World Wide WebWW79841
42587CSPAN3World Wide WebWW79841
stationidCallSignLicenseeServicecitynamexStatexcityid
22711ESPNWorld Wide WebWW79841
58943EWTNWorld Wide WebWW79841
22652Fox NewsWorld Wide WebWW79841
22712Fox SportsWorld Wide WebWW79841
41312GCN1World Wide WebWW79841
22706GCN2World Wide WebWW79841
41480GCN3World Wide WebWW79841
41481GCN4World Wide WebWW79841
77684GCN5World Wide WebWW79841
32729MOYLWorld Wide WebWW79841
stationidCallSignLicenseeServicecitynamexStatexcityid
44298NPRWorld Wide WebWW79841
44299PRIWorld Wide WebWW79841
22707Radio AmericaWorld Wide WebWW79841
44583SportsBylineWorld Wide WebWW79841
23558TalkStarWorld Wide WebWW79841
40372TammyRadioWorld Wide WebWW79841
44584TheBlazeWorld Wide WebWW79841
22714USA/IRN3World Wide WebWW79841
44301YSNWorld Wide WebWW79841
Station WZBY-FM
City GRAND PORTAGE-MN

City Grand Portage, MN is located in DMAID: