1 Reply Latest reply on Jun 28, 2012 9:14 AM by philmodjunk

    Calculating Distance to Subject using address or lat/lon

    user17322

      Title

      Calculating Distance to Subject using address or lat/lon

      Post

      My questions to date have been pretty basic stuff. Now I have a challenge for all of you FMP guru's. How do I auto calc geographic distances between two points using either an address or lat/lon. The report I'm doing need to compare the distance of a group of properties to a single subject property that will be at the top of the report. So I will have a field "Distance to Subject" that will then be calculated for each record in the report using the address or lat/lon. Hopefully someone has done this and can help me out.

      Thanks

        • 1. Re: Calculating Distance to Subject using address or lat/lon
          philmodjunk

          Driving distance or "as the crow flies"?

          For the latter, you can do a google search to get a formula that computes distance between to points specified in lat and long. Addresses can be used with google maps, to get lat and long values to plug into such a formula.

          Other's here in the forum have done this, but I forget the formula and the precise details in how to get lat, long from google maps.