array(0) { }
*** DMA ***
array(12) { ["odbcts"]=> string(19) "2019-07-16 06:29:49" ["dmarank"]=> string(4) "9999" ["dmaID"]=> string(4) "9999" ["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 = 'NOCATEE' and State = 'FL'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 0
Start: 1754177281.2898
End: 1754177281.2907
Elapsed time: 0.8709 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('FL','Nocatee',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80172" ["State"]=> string(2) "FL" ["CityName"]=> string(7) "Nocatee" ["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) "34268" ["zip3"]=> string(3) "342" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(7) "NOCATEE" ["zipstate"]=> string(2) "FL" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "27.16" ["iplongitude"]=> string(6) "-81.89" ["ziplocation"]=> string(16) "NA-US-FL-NOCATEE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "720" ["zippopulation"]=> string(4) "1407" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "342" ["zipcity"]=> string(8) "SARASOTA" ["zipstate"]=> string(2) "FL" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "3279" ["State"]=> string(2) "FL" ["CityName"]=> string(8) "Sarasota" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "448" ["Population"]=> string(5) "50961" ["Latitude"]=> string(9) "27.337273" ["Longitude"]=> string(10) "-82.535318" ["PrimaryAC"]=> string(3) "239" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "0" ["VerizonDSL"]=> string(1) "1" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(4) "3279" ["Population2000"]=> string(5) "52715" ["FIPS"]=> string(7) "1264175" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "74" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
7 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
3279FLSarasota04485096127.337273-82.535318239001003279527151264175-5-174
3306FLVenice01341692227.098674-82.438985941001003306177641273900-5-174
3109FLEnglewood01861502526.963038-82.352016941001003109161961220825-5-174
3228FLNorth Port-11741197327.066004-82.172024941001003228227971249675-5-174
3244FLPalmetto-1301926827.522115-82.578418941001003244125711254250-5-174
3035FLArcadia-1114648827.217585-81.85991786300000303566041201750-5-174
33826FLNokomis-10344827.123732-82.4390160000033341248875-5-174
**** cities in zip3 **************
44 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
34293VENICEFL27611Venice74
34221PALMETTOFL26628Palmetto74
34232SARASOTAFL26377Sarasota74
34209BRADENTONFL26294Bradenton19
34203BRADENTONFL25432Bradenton19
34231SARASOTAFL23757Sarasota74
34208BRADENTONFL22553Bradenton19
34205BRADENTONFL21830Bradenton19
34243SARASOTAFL20697Sarasota74
34207BRADENTONFL19379Bradenton19
zipcodezipcityzipstatezippopulationcitynameDMAID
34287NORTH PORTFL17315North Port74
34202BRADENTONFL17023Bradenton19
34238SARASOTAFL15001Sarasota74
34286NORTH PORTFL14722North Port74
34233SARASOTAFL14328Sarasota74
34219PARRISHFL13972
34266ARCADIAFL13648Arcadia74
34234SARASOTAFL13181Sarasota74
34285VENICEFL12971Venice74
34223ENGLEWOODFL12865Englewood74
zipcodezipcityzipstatezippopulationcitynameDMAID
34275NOKOMISFL12625Nokomis74
34239SARASOTAFL12103Sarasota74
34212BRADENTONFL12027Bradenton19
34241SARASOTAFL11883Sarasota74
34210BRADENTONFL11326Bradenton19
34224ENGLEWOODFL11254Englewood74
34292VENICEFL11178Venice74
34237SARASOTAFL11174Sarasota74
34235SARASOTAFL11109Sarasota74
34236SARASOTAFL9818Sarasota74
zipcodezipcityzipstatezippopulationcitynameDMAID
34240SARASOTAFL9627Sarasota74
34222ELLENTONFL8591Ellenton
34288NORTH PORTFL8484North Port74
34242SARASOTAFL7186Sarasota74
34229OSPREYFL6356Osprey
34228LONGBOAT KEYFL5829Longboat Key
34251MYAKKA CITYFL5170Myakka City
34291NORTH PORTFL4595North Port74
34217BRADENTON BEACHFL3890Bradenton Beach
34201BRADENTONFL3187Bradenton19
zipcodezipcityzipstatezippopulationcitynameDMAID
34211BRADENTONFL2522Bradenton19
34269ARCADIAFL2315Arcadia74
34289NORTH PORTFL1436North Port74
34215CORTEZFL754Cortez
Station WZSP-FM
City NOCATEE-FL

City Nocatee, FL is located in DMAID: