Menu
I'm writing a program to display the expected lifetime of our product as it relates to average weather conditions in various locations across the globe and I'd like my map to reflect the latest country borders.
Can anyone recommend somewhere to get a dataset of latitude/longitude points for the world's latest country borders?
795
On your computer, open Google Maps. Right-click the place or area on the map. This will open a pop-up window. You can find your latitude and longitude in decimal format at the top.
Create a Map chart with Data Types Simply input a list of geographic values, such as country, state, county, city, postal code, and so on, then select your list and go to the Data tab > Data Types > Geography.
To get the latitude of the address in cell B2, use the formula = GetLatitude(B2) To get the longitude of the address in cell B2, use the formula = GetLongitude(B2) To get both the latitude and longitude of the address in cell B2, use the formula = GetCoordinates(B2)
Go to maps.google.com. 2. Type out the coordinates into the search bar — using either the degrees, minutes, and seconds (DMS) format, the degrees and decimal minutes (DMM) format, or decimal degrees (DD) format — then hit enter or click on the search icon.
You can get the world country borders for free from Natural Earth:
Natural Earth
Layer Admin 0 contains the country borders
165
I'm aware this question is three years old, but someone might find this useful:
If a somewhat rough outline is acceptable, you may want to have a look at these KML files: https://www.google.com/fusiontables/DataSource?docid=1uL8KJV0bMb7A8-SkrIe0ko2DMtSypHX52DatEE4#rows:id=1
I only needed the Germany file, so I only tested that one, but I found it to be quite satisfying for my purpose. The border is described with about a hundred coordinates and major islands are included as well.
There is also a second set of KMLs which are even more generalised, but include more islands (again, at least for the Germany file): https://www.google.com/fusiontables/data?docid=1zn8cjdD6qlAFI7ALMEnwn89g50weLi1D-bAGSZw#rows:id=1
37
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
