10 Replies Latest reply on Sep 5, 2018 7:59 PM by Alex Kerin

    Calculating/Mapping Lat+Long Points within Polygon/Geofence

    David Yao

      Hello!

       

      I'd love to know if Tableau is able to calculate or map how many lat/long points, within a given dataset, reside in a given map polygon/geofence.

       

      Context: Assume I have a CSV file with the following type of data.

       

      UseridOriginLatitude
      OriginLongitudeDestinationLatitude
      DestinationLongitude
      1

        

      37.79035506

        

      -122.4219632

        

      37.79369068

        

      -122.4028353
      2

        

      37.78669896

        

      -122.41365

        

      37.78639968

        

      -122.4078175
      3

        

      37.78714752

        

      -122.4105019

        

      37.80840905

        

      -122.4101554

       

      I also have a GeoJSON .json file with a few geofence polygon outlines. I'm trying to find out how many of these lat/long points in the csv file, exist within any of the geofence polygons. I can also have a .kml file with these polygons.

       

      Is this possible? Or would I somehow have to map each of these csv rows to a polygon, for Tableau to understand.

       

      Any other tools/solutions are welcome. Thank You!