Need to have a list of popular locations in latitude / longitude, decimal format. We already have a list of locations. We need you to write a script, apply a simple formula to the data, and output results to a sql file. A bonus will be given if you can produce an output file in the correct format with even more locations.
## Deliverables
I need a script that produces a file in CSV output.
Data comes from here:
<[login to view URL]>
I need all points listed on the pages? USA, CANADA, and OTHER COUNTRIES. The more points the better.
Here is the formula to convert DMS to degrees:
Decimal Degrees = Degrees + minutes/60 + seconds/3600
I am actually more interested in the output than the script itself. I don't care what language is used to create the end result. In fact, if you can get this data from some other place, it's fine with me. We just want to populate it into our database.
Here's an example:
Input:
AFGHANISTAN
? ? ? ? ? ? ? Kabul? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 34° 35' N? ? ? ? 69° 12' E
ILLINOIS
? ? ? ? ? ? ? Aurora? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 41° 45' N? ? ? ? 88° 20' W
Output:
"AFGHANISTAN? - Kabul",? ? 34.58333, 69.2
"USA - ILLINOIS - Aurora", 41.75, -88.33333