kamiar3001
kamiar3001

Reputation: 2676

Countries and their province web service

I need a webservice to get information of whole of the countries and their provinces location and area or population is anyone who knows this web service ?

Upvotes: 2

Views: 1447

Answers (2)

Yosoyadri
Yosoyadri

Reputation: 551

You can also use the great service from the chaps at http://www.geonames.org/

I did a small tool to generate an XML file based on the output of their webservices: https://github.com/yosoyadri/GeoNames-XML-Builder

All credit should really go to the C# library at http://geonamesdotorgdotnet.codeplex.com/ that I'm using to parse the response XML from the services.

You have an already made list of countries and provinces at https://raw.github.com/yosoyadri/GeoNames-XML-Builder/master/continents-countries-statesprovinces.xml

As Muhammad I think it is always good practice to keep your local copy of the data rather than querying the service everytime.

Upvotes: 1

Muhammad Akhtar
Muhammad Akhtar

Reputation: 52241

why you need web service? I don't think so its exist.

what you need to do is, you can create table in your DB and add data, Its easy to find SQL insert queries to dump the data. please check these URLs

http://amrelgarhytech.blogspot.com/2008/08/list-of-countries-cities-languages.html

Country, state list for SQL Server

Upvotes: 1

Related Questions