List of Geopoints of Countries/Capital Cities in Excel

947
1
Jump to solution
03-17-2021 01:59 PM
JulietK
Occasional Contributor II

Hi I am looking to use the Calculations on Geopoints method to map my Survey123 output data on a world map. 

For this I need geopoints data of all countries (or specifically, geopoints of the capital cities to make it consistent) in a format shown in this example. 

JulietK_0-1616014486172.png

Does ArcGIS have a excel table of all countries and the corresponding geopoint data available for download? I'm planning to use this data with the ArcGIS World Countries Generalised Shapefile layer , so looking for something created by ArcGIS for good compatibility. 

Any help would be hugely appreciated! 

 

0 Kudos
1 Solution

Accepted Solutions
Tim_McGinnes
Occasional Contributor III

It's not geopoint format, but there is an ESRI World Cities layer in ArcGIS Hub, which has direct download in spreadsheet (CSV) format:

https://hub.arcgis.com/datasets/6996f03a1b364dbab4008d99380370ed_0 

 

View solution in original post

0 Kudos
1 Reply
Tim_McGinnes
Occasional Contributor III

It's not geopoint format, but there is an ESRI World Cities layer in ArcGIS Hub, which has direct download in spreadsheet (CSV) format:

https://hub.arcgis.com/datasets/6996f03a1b364dbab4008d99380370ed_0 

 

0 Kudos