Samuel Mascarenhas Posted May 17, 2020 Share Posted May 17, 2020 I have a table with postcode, latitute and longitude and I wonder if it is possible to calculate the distance of each observation to a single point Link to comment Share on other sites More sharing options...
Shashank Gurnalkar Posted May 18, 2020 Share Posted May 18, 2020 Can you try to use the GreatCircleDistance() function in Spotfire It is described as below: Returns the shortest distance between two points, calculated on the surface of a unit sphere. The arguments are the latitude and longitude of the coordinates (lat1, long1, lat2, long2), expressed in degrees. Multiply the result with the radius of the sphere to get the desired unit. The radius of the earth is ca. 6371 km (3959 miles). The first two examples gives the distance between two cities expressed in kilometers and the third example gives the distance in miles. Examples: 6371*GreatCircleDistance(57.717829, 11.990509, 42.355145, -71.057892) 6371*GreatCircleDistance([Latitude], [Longitude], 42.355145, -71.057892) 3959*GreatCircleDistance(57.717829, 11.990509, 42.355145, -71.057892) Link to comment Share on other sites More sharing options...
Manoj Singh Posted May 18, 2020 Share Posted May 18, 2020 It is worth to check the analysis file attached to the article as well:https://support.tibco.com/s/article/Tibco-KnowledgeArticle-Article-41913 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now