3 Replies Latest reply on Aug 31, 2012 10:29 PM by Shawn Wallwork

    (How to)Sorting by ZipCode and getting the map right.

    Cleveland Sasser

      Howdy,

      I'm working with Medicare HospitalCompare data (flat file, everything is a string, kinda large). I have a trial Tableau Desktop and I want to see if the info will "sing". I'm only interested in Atlanta GA MSA. I can sort by Zip manually but I know there is a better way.

      Also, how to get data onto one map instead of each hospital (20 in MSA) having its own map...

      What say ye?

      Thanks!

      Cleveland

        • 1. Re: (How to)Sorting by ZipCode and getting the map right.
          Shawn Wallwork

          Hi Cleveland, you're going to need to parse out the string to get it in shape for Tableau. (Post some of it and I'll reshape it for you.) Once you've got it formatted correctly, then Tableau handles maps well. You can have one map with all 20 hospitals, showing lots of different stats lots of different ways. Tableau does work with MSAs, once you've assigned the geographic role correctly. I'm certain you can get Tableau to sing.

           

          Give me some sample data and I'll be happy to show you how.

           

          --Shawn

          • 2. Re: (How to)Sorting by ZipCode and getting the map right.
            Cleveland Sasser

            Thanks DV Dude!

            I thought I might have to tease the zip code fields  (aha!). Here are the fields..Sorry about the dump. Where is the "attach file" icon? Thanks again for your help.

            Cleveland

            Provider NumberHospital NameAddress1Address2Address3CityStateZIP CodeCounty NamePhone NumberHospital TypeHospital OwnershipEmergency Service
            '010001'SOUTHEAST ALABAMA MEDICAL CENTER1108 ROSS CLARK CIRCLEDOTHANAL36301HOUSTON3.35E+09Acute Care HospitalsGovernment - Hospital District or AuthorityYes
            '010005'MARSHALL MEDICAL CENTER SOUTH2505 U S HIGHWAY 431 NORTHBOAZAL35957MARSHALL2.57E+09Acute Care HospitalsGovernment - Hospital District or AuthorityYes
            '010006'ELIZA COFFEE MEMORIAL HOSPITAL205 MARENGO STREETFLORENCEAL35631LAUDERDALE2.57E+09Acute Care HospitalsGovernment - Hospital District or AuthorityYes
            '010007'MIZELL MEMORIAL HOSPITAL702 N MAIN STOPPAL36467COVINGTON3.34E+09Acute Care HospitalsVoluntary non-profit - PrivateYes
            '010008'CRENSHAW COMMUNITY HOSPITAL101 HOSPITAL CIRCLELUVERNEAL36049CRENSHAW3.34E+09Acute Care HospitalsProprietaryYes
            '010009'HARTSELLE MEDICAL CENTER201 PINE STREET NORTHWESTHARTSELLEAL35640MORGAN2.57E+09Acute Care HospitalsProprietaryNot Available
            '010010'MARSHALL MEDICAL CENTER NORTH8000 ALABAMA HIGHWAY 69GUNTERSVILLEAL35976MARSHALL2.57E+09Acute Care HospitalsGovernment - Hospital District or AuthorityYes
            '010011'ST VINCENT'S EAST50 MEDICAL PARK EAST DRIVEBIRMINGHAMAL35235JEFFERSON2.06E+09Acute Care HospitalsVoluntary non-profit - PrivateYes
            '010012'DEKALB REGIONAL MEDICAL CENTER200 MED CENTER DRIVEFORT PAYNEAL35968DE KALB2.57E+09Acute Care HospitalsProprietaryYes
            '010015'SOUTHWEST ALABAMA MEDICAL CENTER33700 HIGHWAY 43THOMASVILLEAL36784CLARKE3.35E+09Acute Care HospitalsProprietaryNot Available
            '010016'SHELBY BAPTIST MEDICAL CENTER1000 FIRST STREET NORTHALABASTERAL35007SHELBY2.06E+09Acute Care HospitalsVoluntary non-profit - ChurchYes
            '010018'CALLAHAN EYE FOUNDATION HOSPITAL1720 UNIVERSITY BLVDBIRMINGHAMAL35233JEFFERSON2.05E+09Acute Care HospitalsVoluntary non-profit - PrivateYes
            '010019'HELEN KELLER MEMORIAL HOSPITAL1300 SOUTH MONTGOMERY AVENUESHEFFIELDAL35660COLBERT2.56E+09Acute Care HospitalsGovernment - Hospital District or AuthorityYes
            '010021'DALE MEDICAL CENTER126 HOSPITAL AVEOZARKAL36360DALE3.35E+09Acute Care HospitalsGovernment - Hospital District or AuthorityYes
            '010022'CHEROKEE MEDICAL CENTER400 NORTHWOOD DRCENTREAL35960CHEROKEE2.57E+09Acute Care HospitalsVoluntary non-profit - PrivateYes
            '010023'BAPTIST MEDICAL CENTER SOUTH2105 EAST SOUTH BOULEVARDMONTGOMERYAL36116MONTGOMERY3.34E+09Acute Care HospitalsVoluntary non-profit - ChurchYes
            '010024'JACKSON HOSPITAL & CLINIC INC1725 PINE STREETMONTGOMERYAL36106MONTGOMERY3.34E+09Acute Care HospitalsVoluntary non-profit - PrivateYes
            '010025'GEORGE H. LANIER MEMORIAL HOSPITAL4800 48TH STVALLEYAL36854CHAMBERS3.35E+09Acute Care HospitalsVoluntary non-profit - OtherYes
            '010027'ELBA GENERAL HOSPITAL987 DRAYTON STREETELBAAL36323COFFEE3.35E+09Acute Care HospitalsGovernment - Hospital District or AuthorityYes
            '010029'EAST ALABAMA MEDICAL CENTER AND SNF2000 PEPPERELL PARKWAYOPELIKAAL36801LEE3.35E+09Acute Care HospitalsGovernment - Hospital District or AuthorityYes
            '010032'WEDOWEE HOSPITAL209 NORTH MAIN STREETWEDOWEEAL36278RANDOLPH2.56E+09Acute Care HospitalsGovernment - LocalYes
            '010033'UNIVERSITY OF ALABAMA HOSPITAL619 SOUTH 19TH STREETBIRMINGHAMAL35233JEFFERSON2.06E+09Acute Care HospitalsGovernment - StateYes
            '010034'COMMUNITY HOSPITAL INC805 FRIENDSHIP ROADTALLASSEEAL36078ELMORE3.34E+09Acute Care HospitalsVoluntary non-profit - PrivateYes
            '010035'CULLMAN REGIONAL MEDICAL CENTER1912 ALABAMA HIGHWAY 157CULLMANAL35058CULLMAN2.57E+09Acute Care HospitalsGovernment - Hospital District or AuthorityYes
            '010036'ANDALUSIA REGIONAL HOSPITAL849 SOUTH THREE NOTCH STREETANDALUSIAAL36420COVINGTON3.34E+09Acute Care HospitalsProprietaryYes
            '010038'STRINGFELLOW MEMORIAL HOSPITAL301 EAST 18TH STANNISTONAL36201CALHOUN2.56E+09Acute Care HospitalsProprietaryYes
            '010039'HUNTSVILLE HOSPITAL101 SIVLEY RDHUNTSVILLEAL35801MADISON2.56E+09Acute Care HospitalsGovernment - Hospital District or AuthorityYes
            '010040'GADSDEN REGIONAL MEDICAL CENTER1007 GOODYEAR AVENUEGADSDENAL35903ETOWAH2.56E+09Acute Care HospitalsProprietaryYes
            '010043'CHILTON MEDICAL CENTER1010 LAY DAM ROADCLANTONAL35045CHILTON2.06E+09Acute Care HospitalsVoluntary non-profit - PrivateYes
            '010044'MARION REGIONAL MEDICAL CENTER1256 MILITARY STREET SOUTHHAMILTONAL35570MARION2.06E+09Acute Care HospitalsVoluntary non-profit - PrivateYes
            '010045'FAYETTE MEDICAL CENTER1653 TEMPLE AVENUE NORTHFAYETTEAL35555FAYETTE2.06E+09Acute Care HospitalsVoluntary non-profit - OtherYes
            '010046'RIVERVIEW REGIONAL MEDICAL CENTER600 SOUTH THIRD STREETGADSDENAL35901ETOWAH2.57E+09Acute Care HospitalsProprietaryYes
            '010047'GEORGIANA HOSPITAL515 MIRANDA STGEORGIANAAL36033BUTLER3.34E+09Acute Care HospitalsVoluntary non-profit - PrivateYes
            '010049'MEDICAL CENTER ENTERPRISE400 N EDWARDS STREETENTERPRISEAL36330COFFEE3.34E+09Acute Care HospitalsProprietaryYes
            '010050'ST VINCENTS BLOUNT150 GILBREATH DRIVEONEONTAAL35121BLOUNT2.05E+09Acute Care HospitalsVoluntary non-profit - PrivateYes
            '010051'GREENE COUNTY HOSPITAL509 WILSON AVENUEEUTAWAL35462GREENE2.05E+09Acute Care HospitalsGovernment - LocalYes
            '010052'LAKE MARTIN COMMUNITY HOSPITAL201 MARIARDEN ROADDADEVILLEAL36853TALLAPOOSA2.57E+09Acute Care HospitalsProprietaryYes
            '010054'PARKWAY MEDICAL CENTER1874 BELTLINE RD SWDECATURAL35601MORGAN2.56E+09Acute Care HospitalsProprietaryYes
            '010055'FLOWERS HOSPITAL4370 WEST MAIN STREETDOTHANAL36305HOUSTON3.35E+09Acute Care HospitalsProprietaryYes
            '010056'ST VINCENT'S BIRMINGHAM810 ST VINCENT'S DRIVEBIRMINGHAMAL35205JEFFERSON2.06E+09Acute Care HospitalsVoluntary non-profit - OtherYes
            '010058'BIBB MEDICAL CENTER208 PIERSON AVECENTREVILLEAL35042BIBB2.06E+09Acute Care HospitalsGovernment - Hospital District or AuthorityYes
            '010059'LAWRENCE MEDICAL CENTER202 HOSPITAL STREETMOULTONAL35650LAWRENCE2.57E+09Acute Care HospitalsGovernment - Hospital District or AuthorityYes
            '010061'HIGHLANDS MEDICAL CENTER380 WOODS COVE ROADSCOTTSBOROAL35768JACKSON2.56E+09Acute Care HospitalsGovernment - Hospital District or AuthorityYes
            '010062'WIREGRASS MEDICAL CENTER1200 W MAPLE AVENUEGENEVAAL36340GENEVA3.35E+09Acute Care HospitalsGovernment - Hospital District or AuthorityYes
            '010065'RUSSELL HOSPITAL3316 HIGHWAY 280ALEXANDER CITYAL35010TALLAPOOSA2.56E+09Acute Care HospitalsVoluntary non-profit - PrivateYes
            '010066'FLORALA MEMORIAL HOSPITAL24273 FIFTH AVENUEFLORALAAL36442COVINGTON3.35E+09Acute Care HospitalsProprietaryYes
            '010069'MEDICAL CENTER BARBOUR820 W WASHINGTON STEUFAULAAL36027BARBOUR3.35E+09Acute Care HospitalsGovernment - Hospital District or AuthorityYes
            '010073'CLAY COUNTY HOSPITAL83825 HIGHWAY 9    P O BOX 1270ASHLANDAL36251CLAY2.56E+09Acute Care HospitalsGovernment - Hospital District or AuthorityYes
            '010078'NORTHEAST ALABAMA REGIONAL MED CENTER400 EAST 10TH STREETANNISTONAL36207CALHOUN2.56E+09Acute Care HospitalsGovernment - LocalYes
            '010079'ATHENS-LIMESTONE HOSPITAL700 WEST MARKET STREETATHENSAL35611LIMESTONE2.56E+09Acute Care HospitalsGovernment - Hospital District or AuthorityYes
            '010083'SOUTH BALDWIN REGIONAL MEDICAL CENTER1613 NORTH MCKENZIE STREETFOLEYAL36535BALDWIN2.52E+09Acute Care HospitalsProprietaryYes
            '010085'DECATUR GENERAL HOSPITAL1201 7TH STREET SEDECATURAL35609MORGAN2.56E+09Acute Care HospitalsGovernment - Hospital District or AuthorityYes
            '010086'NORTHWEST MEDICAL CENTER1530 U S HIGHWAY 43WINFIELDAL35594MARION2.05E+09Acute Care HospitalsProprietaryYes
            '010087'UNIV OF SOUTH ALABAMA MEDICAL CENTER2451 FILLINGIM STREETMOBILEAL36617MOBILE2.51E+09Acute Care HospitalsGovernment - StateYes
            '010089'WALKER BAPTIST MEDICAL CENTER3400 HIGHWAY 78 EASTJASPERAL35502WALKER2.05E+09Acute Care HospitalsVoluntary non-profit - PrivateYes
            '010090'PROVIDENCE HOSPITAL6801 AIRPORT BOULEVARDMOBILEAL36608MOBILE2.52E+09Acute Care HospitalsVoluntary non-profit - ChurchYes
            • 3. Re: (How to)Sorting by ZipCode and getting the map right.
              Shawn Wallwork

              It looks like the admin has disabled the attach files permissions. So I opened a new discussion in the maps forum, so I could post the map I created for you. Here's the link. If that doesn't work go to the maps forum and search for "Cleveland' Questions" that should get you there.

               

              --Shawn