Revisa aca http://download.geonames.org/export/dump/

Este archivo es lo correspondiente a Argentina
http://download.geonames.org/export/dump/AR.zip

El contenido es:

XX.zip                   : features for country with iso code XX, see
'geoname' table for columns
The main 'geoname' table has the following fields :
---------------------------------------------------
geonameid         : integer id of record in geonames database
name              : name of geographical point (utf8) varchar(200)
asciiname         : name of geographical point in plain ascii
characters, varchar(200)
alternatenames    : alternatenames, comma separated varchar(4000)
(varchar(5000) for SQL Server)
latitude          : latitude in decimal degrees (wgs84)
longitude         : longitude in decimal degrees (wgs84)
feature class     : see http://www.geonames.org/export/codes.html, char(1)
feature code      : see http://www.geonames.org/export/codes.html, varchar(10)
country code      : ISO-3166 2-letter country code, 2 characters
cc2               : alternate country codes, comma separated, ISO-3166
2-letter country code, 60 characters
admin1 code       : fipscode (subject to change to iso code), isocode
for the us and ch, see file admin1Codes.txt for display names of this
code; varchar(20)
admin2 code       : code for the second administrative division, a
county in the US, see file admin2Codes.txt; varchar(80)
admin3 code       : code for third level administrative division, varchar(20)
admin4 code       : code for fourth level administrative division, varchar(20)
population        : integer
elevation         : in meters, integer
gtopo30           : average elevation of 30'x30' (ca 900mx900m) area
in meters, integer
timezone          : the timezone id (see file timeZone.txt)
modification date : date of last modification in yyyy-MM-dd format



2009/4/2 Gaston Ramos <[email protected]>

> Alguien sabe de dónde puedo sacar un listado (en csv o algo por el estilo)
> del todas las provincias, localidades y departamentos de argentina?
>
> Saludos.
>
> --
> "I always thought Smalltalk would beat Java, I just didn't know it would be
> called 'Ruby' when it did."
>
>   (Kent Beck)
>
>
> +-------------------------------------+
> Gast\xF3n Ramos
> http://gastonramos.com.ar/
> GNU/Linux <http://gastonramos.com.ar/%0AGNU/Linux> Counter user #450312
> _______________________________________________
> Ruby mailing list
> [email protected]
> http://lista.rubyargentina.com.ar/listinfo.cgi/ruby-rubyargentina.com.ar
>
_______________________________________________
Ruby mailing list
[email protected]
http://lista.rubyargentina.com.ar/listinfo.cgi/ruby-rubyargentina.com.ar

Responder a