10 Replies Latest reply on Jan 22, 2019 12:24 PM by Don Wise

    London boroughs with mapping

    Qandeel Warrich

      Hi

       

      I've seen a few posts around maps of London boroughs (and outlines of the boroughs). However, nothing that quite meets what I need. I want to map specific locations within borough outlines. I need to be able to show some detail about the locations too, for example, full address, name etc. I've found a few tableau downloads on the internet which look something like this:

      Map.png

      I'm trying to add in simple locations like below:

      Service mapping.png

      I've tried the map layers but these include postcodes not boroughs. This workbook Mortality by London Borough  was helpful but I couldn't map/see the level of detail of each individual location. It would be create if I could create another tab with the borough level summaries like the infant mortality rate map too. I'm relatively new to Tableau so not yet overly familiar with polygons. I did try to use this RUSSIAN SPHINX: Tableau Mapping Template for London Boroughs but without the source data I got stuck.

       

      Any help would be greatly appreciated! Thanks in advance.

        • 1. Re: London boroughs with mapping
          Don Wise

          Hi Qandeel,

          It sounds like you want to perform a Dual-Axis map.  Here's an excellent blog by Sarah Battersby on not only how to create and combine the two different types of data (polygons and data points), but different methodologies for joining the two different types of data sets depending on type of data. Dual Axis Mapping - Many Ways

           

          Hope it helps. 

           

          PS - FYI It would be helpful if you could post sample data of what you're trying to do if possible.  Thx, Don

          • 2. Re: London boroughs with mapping
            Qandeel Warrich

            Hi Don

             

            Thank you for your response. I will definitely check out the blog. The data is pretty simple, most text descriptors but thats the categories that might be used for colour/breakdown:

             

            Address

            Post Code

            Client Group

            Region

            Ownership Type

            Latitude

            Longtitude

             

            I guess I could introduce a column for borough but I was hoping someone had already resolved it! I might just have to write to Tableau about introducing a borough map for London...

             

            Kind regards

             

            Qandeel

            • 3. Re: London boroughs with mapping
              Don Wise

              Hi Qandeel,

              I'm attaching a packaged workbook .twbx which contains the necessary .shp files for both London Boroughs and Wards. The files were located from the London Data Store: Statistical GIS Boundary Files for London – London Datastore You should be able to go forward on your own, using Sarah's techniques for joining your point (Lat. Lon.) data with the attached workbook (2018.3) version.  If you have problems, feel free to come back.  Thx!  Don

              Screen Shot 2019-01-18 at 9.41.40 AM.png

              • 4. Re: London boroughs with mapping
                Qandeel Warrich

                Hi Don

                 

                You're a star! I've done it. I've got some of the data missing but I'm sure I'll be able to work out how to fix it to show all the points. I can't quite work out why some of them are missing at the moment. It might be because I've used full outer joins to link the data to make it work. The data is also messy as I've had to link two similar tables with duplicated data.

                 

                Thank you so much for your help. I couldn't have done it without you! Have a lovely weekend.

                 

                Kind regards

                 

                Qandeel

                • 5. Re: London boroughs with mapping
                  Don Wise

                  You're welcome! If you could close the thread by marking my response as correct that way others can find it useful in the future too.  Thx! Don

                  • 6. Re: London boroughs with mapping
                    Qandeel Warrich

                    Hi Don

                     

                    For some reason, it seems to be only plotting individual points in the middle of the boroughs and I can't quite work out why. Excuse my ignorance but if I remove the COLLECT (Geometry) measure - all my marks disappear.

                     

                    Screen Shot 2019-01-19 at 13.38.17.png

                    Your expertise would be greatly appreciated.

                     

                    Kind regards

                     

                    Qandeel

                    • 7. Re: London boroughs with mapping
                      Don Wise

                      Hi Qandeel,

                      Right now I'd say it's plotting only your PostCode, as that's the only Geo attribute being recognized in Tableau (notice the Globe symbol). 

                       

                      If you were to click on ANALYSIS in the upper MENU BAR and uncheck Aggregate Measures, that might disaggregate the points and spread them out, but difficult for me to say without more understanding of the point data. Yes, your COLLECT (Geometry) pill will need to remain at this point. 

                       

                      The only other thing for you to try is not to use Tableau's generated Latitude for your point data, instead use the Latitude from Measures (Boroughs Geo Client).

                       

                      Any chance you can upload your data or some sample data?

                       

                      Thx!  Don

                      • 8. Re: London boroughs with mapping
                        Qandeel Warrich

                        Hi Don

                         

                        I disaggregated the measures and its now plotting in the middle of each ward:

                        Screen Shot 2019-01-21 at 20.31.05.png

                        The address detail has disappeared from the points. The data is as simple as below:

                         

                        Thanks again for your help.

                         

                        Kind regards

                         

                        Qandeel

                        • 9. Re: London boroughs with mapping
                          Don Wise

                          Hi Qandeel,

                          Edited: I just noticed a bit of detail in your graphic for your point data in your Excel worksheet. It looks like you have the same Lat/Lon for each row/record.  If each address and post code is geocoded (lat/lon) to just the post code, then that's all that will display, just the geocoded post code to the lat//lon of the post code.  However, If you're looking to display exact addresses, you'll need to geocode the exact address and obtain new lat/lon for each...as example below, the Latitude and Longitude for each Full Address is geocoded to that specific location, not to the Post Code, so each are different from each other.

                           

                          Postcode

                          Full Address

                          Client Group

                          Property Reference

                          Latitude

                          Longitude

                          BR2 6AA

                          3 Holwood Cottages, Shire Lane, Keston, BR2 6AA

                          LD

                          100102POND1104

                          51.34816

                          -0.04391

                          BR2 6AA

                          Holwood Farm Shire Lane, Biggin Hill, Keston

                          LD

                          100102POND1105

                          51.34678

                          -0.04408

                          BR2 6AA

                          Unit 6, Glebe Farm Business Park, Westerham Rd, Keston

                          LD

                          100102POND1106

                          51.3671

                          -0.03895

                          BR2 6DF

                          Leaves Green Rd, Leaves Green, Keston BR2 6DQ, UK

                          LD

                          100102POND1107

                          51.34374

                          -0.03248

                          BR2 6DF

                          Cudham Raod, Downe Village, Downe, Orpington BR6 7LF, UK

                          LD

                          100102POND1108

                          51.33505

                          -0.05564

                          BR2 6DN

                          8 Leaves Green Cres, Keston BR2 6DN, UK

                          LD

                          100102POND1109

                          51.33605

                          -0.02962

                          BR2 6DN

                          Litchfield Lodge, 1 Curchin Close, Biggin Hill, Westerham TN16 3GF, UK

                          LD

                          100102POND1110

                          51.33147

                          -0.02477

                          BR2 6DN

                          Leaves Green Rd, Leaves Green, Keston BR2 6DQ, UK

                          LD

                          100102POND1111

                          51.343739

                          -0.03248

                          BR2 6DN

                          Milking Ln, Keston BR2 6DD, UK

                          LD

                          100102POND1112

                          51.33544

                          -0.03019

                          BR6 7LA

                          Downe, Orpington BR6 7LA, UK

                          LD

                          100102POND1113

                          51.32335

                          -0.05613

                          BR6 7LA

                          Luxted Rd, Downe, Orpington BR6 7JT, UK

                          LD

                          100102POND1114

                          51.32335

                          -0.05613

                           

                          Which results in a map more similar to this...looks like my geocoder is off or the .shp files are off, but you get the idea:

                          Screen Shot 2019-01-21 at 5.03.24 PM.png

                          Also note what I did with Sheet 1 points data.  I left the original Latitude (Generated) on Rows, but removed all former attributes for that Latitude from the Marks Card and replaced with the data from Sheet 1:

                          Screen Shot 2019-01-21 at 5.03.24 PM.png

                          • 10. Re: London boroughs with mapping
                            Qandeel Warrich

                            You're a star! With your help, I've managed to do it. Thank you Don. Now to work out the borough summaries.

                            • 11. Re: London boroughs with mapping
                              Don Wise

                              Glad to have helped! Thx, Don