1 2 Previous Next 17 Replies Latest reply on Sep 25, 2013 11:04 AM by Allan Walker

    Polygon maps

    Ville Tyrväinen

      Jippijaijee!


      I was able to build a single polygon map with 2 different level of detail.  Borders and data aggregation work and change with single parameter(State<->Municipality). Thanks Allan Walker to give idea for this one!

        • 1. Re: Polygon maps
          Allan Walker

          Ville,

           

          Excellent!  Can you post a screenshot?

           

          Best Regards,

           

          Allan

          • 2. Re: Polygon maps
            Ville Tyrväinen

            Hi Allan

             

            Something like this:

            v1.PNG.png

            v2.PNG.png

             

            I could quite easily add 2 or 3 levels more under same parameter.

             

            Br

             

            Ville

            • 3. Re: Polygon maps
              Ville Tyrväinen

              vi_1.PNG.pngvi_2.PNG.png

              Filters work also fine.

               

              I have been looking for this kind of solution so long and finally caught it.

              Next thing is to get better basemaps..

              • 4. Re: Polygon maps
                Allan Walker

                Ville,

                 

                It works! I never doubted it

                 

                Ville Tyrväinen wrote:

                 

                Next thing is to get better basemaps..

                 

                We are working on that...

                 

                By the way, I have a new process that you'll probably be interested in.  I've managed to go cloudmade -> Tableau.

                 

                Quite an interesting process:

                Download all the SHP files for a country (soon, entire continents) for foreground analysis with default Urban Mapping background:

                Check all datum is WGS 84/EPSG:4326

                All Poly SHP -> ET Wizard in ESRI -> Points with Path Order (ET Order)

                All Line SHP -> ET Wizard in ESRI -> Points with Path Order (ET Order)

                All Points

                Merge

                Add X,Y (Data Management) in ESRI

                Output to txt (it's actually a CSV)

                Import CSV to Postgres SQL/PostGIS

                Load into Tableau

                X and Y as number but dimensions (X = Long, Y = Lat)

                Line mark type

                Add ET Order as path order

                Add Object ID to level of detail

                ***No dual axis required!!***


                This started off as 7 shapefiles, 2 Poly (Water and Natural), 3 line (Administrative, Coastline and Highway), and 2 Point (POI and Location).


                The project came about because of the Faroe Islands project where I had to separate these out.  No more!

                 

                Example: Every OpenStreetMap node, way and relationship - Scotland, default Urban Mapping background

                Scotland.png

                 

                Example: Address Level detail - Edinburgh, Scotland, using OpenStreetMap background

                 

                Edinburgh.png

                 

                Now we're getting there.  With the 64-bit version of Tableau, I expect we could map the entire planet not only as a background layer, but also as a foreground layer for analysis.  Note - as you can see from the filters, this isn't just a subset.  It's all the attributes from the nodes, relationships and ways*

                 

                Best Regards,

                 

                Allan

                 

                *Cloud made SHP files do not necessarily equate to the osm file.

                • 5. Re: Polygon maps
                  Juracy Americo

                  Hi Ville,

                   

                  Very interesting , how did you manage the parameter from State, Municipality and Province?

                  • 6. Re: Polygon maps
                    Ville Tyrväinen

                    Hi Allan,

                     

                    that certainly looks interesting and could be very useful! I'm now playing only with simple excel files, so I think, I should study also other alternatives if I'm going to increase the level of detail remarkably. Maybe I should read couple of your posts and try also that geoserver just to get more experience.

                     

                    Best regards

                     

                    Ville

                    • 7. Re: Polygon maps
                      Juracy Americo

                      Woww Allan, this is really great...

                       

                      Congratulation, very nice, very nice.

                      • 8. Re: Polygon maps
                        Ville Tyrväinen

                        Hi Juracy,

                         

                        You need shapefiles and then few tricks I thought about it  for couple of days and then did it in less than hour and suddendly it worked

                         

                        Ville

                        • 9. Re: Polygon maps
                          Ville Tyrväinen

                          Hi Allan,

                           

                          would you have time to look at my solution? I think you might have some ideas how to do it differently. If you are interested I can post example workbook.

                           

                          Best regards

                           

                          Ville

                          • 10. Re: Polygon maps
                            Juracy Americo

                            Hi Ville, I need some help, I already have shape files for my country, could you give more detail how you did the parameter? I not able to reproduce it

                             

                            thank you in advanced

                            • 11. Re: Polygon maps
                              Ville Tyrväinen

                              Have you already converted those shapefiles so that tableau can read them?

                              • 12. Re: Polygon maps
                                Juracy Americo

                                Hi Ville, yes I did

                                • 13. Re: Polygon maps
                                  Ville Tyrväinen

                                  So you have something like this for each shapefile:

                                   

                                  pos.PNG.png

                                  • 14. Re: Polygon maps
                                    Allan Walker

                                    Ville Tyrväinen wrote:

                                     

                                    Hi Allan,

                                     

                                    would you have time to look at my solution? I think you might have some ideas how to do it differently. If you are interested I can post example workbook.

                                     

                                    Best regards

                                     

                                    Ville

                                     

                                    Sure thing, it's probably a good thing for the community if you have time to post the workbook and also a tutorial of your process...

                                     

                                    I'm super busy at the moment though...

                                     

                                    Allan

                                    1 2 Previous Next