Stack Overflow
Stack Overflow

Questions tagged [geographic-distance]

Geographical distance is the distance measured along the surface of the earth.

Geographical distance is the distance measured along the surface of the earth.

77 questions
1
vote
1 answer

How to plot a variable with geographic distance in R?

I would like to plot a simple xy graphic being y=variable and x=geographic distance. I have data.frame with my data of interest in separate columns (ex: Species$Latitude, Species&Longitude, Species$Variable). All coordinates are in decimal degrees…
Mohr
  • 323
  • 1
  • 3
  • 9
1
vote
0 answers

Is it possible to search through a very large excel file that includes latitude and longitudes and return rows within a certain radius? (Java)

I have a very large excel sheet (about 30,000+) records of house prices and their location (a latitude and longitude value). At the moment I can parse parts of the excel sheet into the console of Eclipse using Apache POI. However is it possible to…
user7746076
1
vote
0 answers

how to convert decimal degree to metric unit in simulating the moving of an object in c#

i have a simulating of moving object in c#. i have some coordinates and speed(moving force) vector value in every coordinate. all of the coordination are decimal degree like below: lon:57.513958 lat:30.369513 in each point there is two force value…
Siamak Farsi
  • 37
  • 1
  • 8
1
vote
1 answer

Geopy distance between locations

I am using geopy for calculating distance between two locations. from geopy.distance import distance loc1 = (41.49008, -71.312796) loc2 = (41.499498, -81.695391) dist = distance(loc1,loc2).miles print dist this gives an output 538.390445157 But…
Ankush Rathi
  • 622
  • 1
  • 6
  • 26
1
vote
0 answers

call DbGeography distance function using EF 6.1 in batch mode

I am using the DbGeography type in Entity Framework 6.1 with SQL Server 2014, I need to find the nearest location for possibly 100,000 entities, it is slow when doing it one by one like below, is it possible to use a similar method as I have below…
sprocket12
  • 5,368
  • 18
  • 64
  • 133
1
vote
2 answers

How to cluster lat-long given fixed cluster size in R?

I have about 50 locations and I want to cluster them spatially with size of cluster fixed. say following few locations…
areddy
  • 373
  • 3
  • 7
  • 18
1
vote
1 answer

Combining SQL SUM clauses

I have a script that requires executing four rather large MySQL queries on the same subset of data. Is there a way to combine them into one query? Here is what the query looks like: Select sum(value) From ( Select lat, lng, value From…
nucleon
  • 861
  • 6
  • 22
0
votes
0 answers

Best method of visualizing starting latitude / longitude to ending latitude / longitude (distance traveled) in R

The goal of the project is to determine how far casual riders travel vs. membership riders and have a visual graphic that supports the data conclusions. I have plotted the maps using mapviewer and ggplot of start and end points. I would like to see…
Kyle Kulinski
  • 21
  • 1
  • 4
0
votes
0 answers

How to get minimum/maximum latitude and longitude from center and given radius?

I need to calculate a square area that is equivalent to different zoom heights. To achieve this I am using the scale in meters as radius and the latitude and longitude of where I click (LatLng center). Doing it this way I get a square area, but it's…
LDHugeman
  • 1
  • 1
0
votes
0 answers

convert geographic coordinates into Cartesian coordinate system

i am looking for a method to convert geographic coordinates (latitude, longitude) to a cartesian reference system with x, y coordinates. Since I have to be able to locate the points on the geographic map using the x, y coordinates. It is obvious…
Siamonlemon
  • 1
  • 1
0
votes
0 answers

Tableau Desktop - array of latitudes & longitudes, calculate total distance of path

I have a dataset in which I have a column of geographical points, and I want to calculate the total distance of the path that these geographical points cover, so that I can add it to the details of the 'route'. What's the cleanest and simplest way…
FairyLiquid
  • 41
  • 5
0
votes
2 answers

What is a good way to calculate geographical distances in MYSQL?

I want to get distance from the database entry; I've tried the below code so far SELECT ST_Distance_Sphere( POINT(LNG1, LAT1), POINT(LNG2,LNG2) )* .000621371 ; Though I've gotten a result, I'm not sure its accurate. I've compared my results with…
anupamb
  • 37
  • 8
0
votes
0 answers

convert geographic coordinate system [lon, lat] to Cartesian [X,Y] preserving The great-circle distance in python

(true newbie here,) I have a (large) geo-data set containing [lat ,lon] and I'd like to convert it all to a flat two-dimensional surface (x,y). The result needs to preserve the great-circle distance between each two points (what I mean here is the…
shayn
  • 1
  • 1
0
votes
0 answers

Get "strongest" cluster from geographic data

I'm designing an algorithm to work with sets of coordinates. Each user has a list of coordinates (latitude and longitude) and adds a new pair to the list every time he/she performs an action. Most of the times, points will be very concentrated, but…
Guillermo Moreno Castaño
  • 45
  • 7
0
votes
1 answer

Trying to find the longitude to metres ratio given a latitude for Google Maps Static API Stitching

I'm working on a project that hopes to convert Google maps static images into larger, stitched together maps. I have created an algorithm that given a starting and ending, latitude and longitude, it will fetch the Google Maps Static image for that…
lopu
  • 175
  • 1
  • 18
1 2
3
4 5 6