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 = 'CAPSHAW' and State = 'AL'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 0
Start: 1754170306.205
End: 1754170306.2053
Elapsed time: 0.2398 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('AL','Capshaw',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80064" ["State"]=> string(2) "AL" ["CityName"]=> string(7) "Capshaw" ["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) "35742" ["zip3"]=> string(3) "357" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(7) "CAPSHAW" ["zipstate"]=> string(2) "AL" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "34.77" ["iplongitude"]=> string(6) "-87.01" ["ziplocation"]=> string(16) "NA-US-AL-CAPSHAW" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "357" ["zipcity"]=> string(7) "MADISON" ["zipstate"]=> string(2) "AL" }
**** zip3 city**************
array(22) { ["id"]=> string(3) "745" ["State"]=> string(2) "AL" ["CityName"]=> string(7) "Madison" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(2) "92" ["Population"]=> string(5) "14904" ["Latitude"]=> string(9) "34.715065" ["Longitude"]=> string(10) "-86.739644" ["PrimaryAC"]=> string(3) "256" ["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(3) "745" ["Population2000"]=> string(5) "29329" ["FIPS"]=> string(6) "145784" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "115" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
21 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
713ALHuntsville025315978934.712341-86.59629625610000713158216137000-6-1115
635ALDecatur01774876134.580992-86.9833922560000063553929120104-6-1115
664ALFlorence01843642634.820287-87.662862560000066436264126896-6-1115
577ALAthens02041690134.789602-86.9694242560000057718967102956-6-1115
18768TNTullahoma01321676135.368511-86.2132589310000018768179944775320-6-1115
745ALMadison-1921490434.715065-86.7396442560000074529329145784-6-1115
819ALScottsboro-1671378634.651368-86.042572560000081914762168736-6-1115
706ALHartselle-1781079534.440383-86.9403852560000070612019133448-6-1115
763ALMoulton-156324834.482307-87.285621256000007633260151600-6-1115
594ALBridgeport-10293634.947303-85.718966256000005942728109328-6-1115
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
772ALNew Hope-11224834.538194-86.412129256000007722539154168-6-1115
708ALHazel Green-175220834.923712-86.567206256000007083805133808-6-1115
830ALStevenson-10204634.869442-85.831829256000008301770173080-6-1115
32370ALHarvest-10192234.852827-86.748047000003054133472-6-1115
32494ALTrinity-10138034.603808-87.086137000001841176872-6-1115
722ALKillen-174104734.861586-87.529374256000007221119139784-6-1115
32291ALAddison-1062634.200042-87.17785100000723100484-6-1115
32379ALHolly Pond-1060234.174657-86.61700400000645135560-6-1115
654ALEva-1043834.325209-86.74772225600000491124688-6-1115
648ALElkmont-1038934.930155-86.97708625600000648470123488-6-1115
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
32477ALSomerville-1021134.469961-86.79878200000347171496-6-1115
**** cities in zip3 **************
32 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
35758MADISONAL36090Madison115
35749HARVESTAL18078Harvest115
35763OWENS CROSS ROADSAL12115Owens Cross Roads
35750HAZEL GREENAL11022Hazel Green115
35757MADISONAL10855Madison115
35773TONEYAL10273
35761NEW MARKETAL9306New Market
35768SCOTTSBOROAL9177Scottsboro115
35769SCOTTSBOROAL7517Scottsboro115
35756MADISONAL7381Madison115
zipcodezipcityzipstatezippopulationcitynameDMAID
35759MERIDIANVILLEAL5666Meridianville
35748GURLEYAL5240Gurley
35747GRANTAL4377Grant
35754LACEYS SPRINGAL4182Laceys Spring
35760NEW HOPEAL3967New Hope115
35739ARDMOREAL3887Ardmore
35772STEVENSONAL3742Stevenson115
35771SECTIONAL2819Section
35765PISGAHAL2818Pisgah
35776WOODVILLEAL2758Woodville
zipcodezipcityzipstatezippopulationcitynameDMAID
35740BRIDGEPORTAL2724Bridgeport115
35741BROWNSBOROAL2578
35744DUTTONAL1814Dutton
35752HOLLYWOODAL1698Hollywood
35746FACKLERAL691
35775VALHERMOSO SPRINGSAL520
35764PAINT ROCKAL492Paint Rock
35745ESTILLFORKAL0Estillfork
35751HOLLYTREEAL0
35755LANGSTONAL0Langston
zipcodezipcityzipstatezippopulationcitynameDMAID
35766PRINCETONAL0
35774TRENTONAL0
Station W251AC-FX
City CAPSHAW-AL

City Capshaw, AL is located in DMAID: