|
Have figured it out, distance earth works fine, in the underlying query I was using I had added the workaround below to get the points to show together on a map across the meridian. AssignCoordSys(NewPoint(CAST(IIf([Longitude]<150,180+(180-([Longitude])*-1),[Longitude]) AS DOUBLE), CAST([Latitude] AS DOUBLE)), CoordSys("Latitude / Longitude")) [GeomData] So some of the points had longitudes over 180 which gave null result in distance earth, so now have two queries, one for the map and another for distance calculation.
|