What s New in Triton Software

Geocoding distance between two points

I have an SQL database containing hotel information, some of which is the geocoded lat/lng generated by Googles geocoder.

I want to be able to select (directly using an SQL query) all the hotels within a certain range. This range will never be more than 50km so I dont need to go as detailed as alot of answers on here are suggesting (taking into account earth curvature and the fact its not a perfect sphere isnt an issue over the distances im searching).

Im thinking a simple Pythagorian formula would suffice, but I dont know what the latitude and longitude figures represent (and therefore how to convert to metres) and also ive read on a couple of 'simple' solutions to my problem that there are issues with their formulas and calculating distances between two locations either side of the meridian line (as I am based in London this will be a big issue for me!!)

You might also like
calculating the distance between two points
calculating the distance between two points
distance between two points - Coordinate Geometry Basics.mp4
distance between two points - Coordinate Geometry Basics.mp4
Distance between two points
Distance between two points

Help with geocoding

by aoompaloompa

Morning-I'm trying to plot a list of addresses on a map using yahoo's service for that. Problem is, the data requires it being in a specific form according to an excel template they've provided as an example.
Now i'd like to know ;
1. General advice on the proccess
2. A way for excel to 'intelligently' break up data into corresponding cells
The problem is my data looks like this:
B & B Real Estate
7525 Auburn Boulevard
Citrus Heights, CA 95610-2239
And needs to look like this: (| being cell lines)
1600 Pennsylvania Avenue NW | Washington | DC | 20500 |The White House

Vintage History 1871 Map of Brazil, Bolivia, Paraguay, Uruguay & Chili of Brazil, Bolivia, Parag
Home (Vintage History)
  • 1871 Map of Brazil, Bolivia, Paraguay, and Uruguay ; Map of Chili. Scale ca. 1:10,, (W 74, W 69/S 24, S 42). Relief shown by hachures. Scale ca. 1:20,, (W 73, W...
  • Map size: 2 foot x 18 inches
  • Beautiful and Rare Historic Map
  • Archival Quality Reproduction

7 Game of Thrones Apps That Will Get You Through the Much-awaited Winter  — Gizmodo India
.. or Winterfell, you get a dialog box, which asks you to buy more maps. Unfortunately, you can't dismiss the dialogue box, leading to the obstruction of the cartography. ..

Flagstaff's rocky lava field became a little piece of the moon  — azcentral
If American know-how could put a man on the moon, the man should bring back rocks to study. The government agreed, and in 1963, the .. Volcanoes were chosen because of the moon's volcanic history, the test site for its impact craters.

Vintage History 1864 Civil War Map Petersburg shows Federal forces of the environs of Petersburg
Home (Vintage History)
  • 1864 Map of the environs of Petersburg from the Appomattox River to the Jerusalem Plank Road showing entrenchments occupied by Federal forces / Engineer Department...
  • Map size: 2 foot x 18 inches
  • Beautiful and Rare Historic Map
  • Archival Quality Reproduction

Missing in Alaska without a trace  — Anchorage Daily News
The official version of events, according to a still active missing person's bulletin from the Alaska State Troopers is that Griffis went into the wild "to test out a survival 'cocoon' that he had invented.

Vintage History 1895 Map of Knox County, Tennessee
Home (Vintage History)
  • 1895 Map of Knox County, Tennessee
  • Map size: 2 foot x 18 inches
  • Beautiful and Rare Historic Map
  • Archival Quality Reproduction
Vintage History 1746 map of Camarones Bay, Argentina, showing Camarones Bay and adjoining capes,
Home (Vintage History)
  • 1746 Map showing Camarones Bay and adjoining capes, Argentina. Oriented with north to the right.
  • Map size: 2 foot x 18 inches
  • Beautiful and Rare Historic Map
  • Archival Quality Reproduction
Lowrance Lowrance Elite-7 Gold CHIRP Fishfinder/Chartplotter with 83/200 KHz and 455/800 KHz Transducer and Navionics Cartography
GPS or Navigation System (Lowrance)
  • 7 Widescreen LCD
  • Includes Navionics Gold Cartography
  • Broadband CHIRP and Hi-Def. Down Imaging Sonar
  • Includes 83/200+455/800KHz transom mount transducer
  • Built-in GPS

Popular Q&A

avatar
What's the formula for the distance between two points?

Embed Quote

avatar
What is the distance between two points?

The distance between two points in length of line. The distance between two points is a straight line. Answer The distance between two points can often be measured with a ruler, but that depends upon how far apart the two point in question are. If the points are very far apart, then more sophisticated techniques are needed.

Related Posts