The GeoDist() function can be used to find the distance between any two locations, and is therefore a much more general distance function than the UK specific ones described above.
An expression to calculate distance is:
This style of calculation is slightly cyprus mobile numbers different to the usual case in that each data record had two locations associated with it – to represent the start and end point of the flight. More typical is the situation where there’s a location associated to a record (usually a customer) and one or more reference points to represent locations of interest. The above expression could have been rewritten with fixed numeric values to find the distance between a customer and a set of locations (e.g. our retail stores).
Find my nearest…
In this example, we’re using a FastStats system comprising house price sale data from a two-year period in Melbourne. The dataset comprised latitude and longitude information to pinpoint the location of each sold property. The challenge was to build a model to predict sold house prices. However, some factors which may turn out to be important were not provided in the source data. For instance, proximity to public transport (e.g. train or tram stops) could have an influence on house prices.