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.
|