Query to pull all cities worldwide.

  • 1
  • Question
  • Updated 5 years ago
I have a query which pulls all the cities in South Africa from the geolocation service and works 100%.
The query looks as follows:

I would like the change this so that it includes international cities as well and not country specific cities.

Is there something I could swap out with the ZA part of the query which would list all cities world wide?

Photo of iCode Web Solutions

iCode Web Solutions

  • 1 Post
  • 0 Reply Likes
  • happy

Posted 5 years ago

  • 1
Photo of iCode


  • 1 Post
  • 0 Reply Likes
Hi Any news regarding this?
We would like to use the wunderground api to pull all cities world wide instead of state, country, etc.
Photo of afelicioni


  • 227 Posts
  • 42 Reply Likes
According to http://apicommunity.wunderground.com/... , country or list city used in Weather Underground API are not disclosed, you have to supply yourself a worldwide city database and write code to cycle countries and cities for evey countries to forge API URLs to query.