GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Get provinces from Argentine  XML
Forum Index -> FAQ - frequently asked questions
Author Message
elrufoelrufo



Joined: 19/09/2017 13:50:59
Messages: 1
Offline

Hello,

I'm having problems getting provinces of Argentine. Executing the following query :

SELECT * FROM `geoname` WHERE country='AR' and fcode='ADM1'

Returns 24 rows, but Argentine only has 23 provinces. It's because AR.07 - Ciudad Autonoma de Buenos Aires.

If you have a look to the following URL : http://www.geonames.org/AR/administrative-division-argentina.html

You can see these 24 rows but Ciudad Autónoma de Buenos Aires appears like district how can I distinct between province and district?


Thanks in advanced.
 
Forum Index -> FAQ - frequently asked questions
Go to:   
Powered by JForum 2.1.5 © JForum Team