-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Lester Caine wrote:
| Since we all deal with a lot of common data it makes sense to provide an
| archive where that data can be centralised. There have been various
| discussions on things like postcodes, zip codes and the like, and
| providing a means of combining data from several sources seems to be the
| best way forward.
|
| Since the Foundation only covers this planet, and I'm sure someone will
| come up with inter-planetary records, we are probably creating a
| 'Federation' of data sources.
|
| So far I have
| COUNTRIES with ISO2 and ISO3 code
| - need to add dialing number/international ref no
| GB_COUNTY
| GB_TOWN
| DE_STATE with state code
| US_STATE with state code
| CA_PROVINCE with code and space for flags
| - but then I could not load them ;)
|
| Hopefully people get the idea, and I am sure we will be adding such
| things as country flags, and other elements, but they will not be
| compatible with a csv download :( So I suspect we will have an image
| less view as an option for creating the csv extract.
|
| I do have the GB Postcode list, but I'll refrain from posting that
| 1492000 records making 200Mb of data, and while it has been created from
| sources I have control off, I'm not sure on the 'copyright' position
| over postcode data. I will have an 'area' code list - the first half of
| the postcode - but anything more accurate will need investigating.
|
| Can someone with better SQL skills than me tell me if we can combine the
| county/state/province tables to produce a world 'state' list as a view
| on the other tables, or will I need to 'build' the larger table via
| scripts and 'pump' the data?
|
| Who else has some contributions?
| Eating places in the Gamma Quadrant?
|
I i have the postal codes of mexico, whit states, and the colonia <= i
dont know the translation of that, and streets, the sources are from
sepomex "Servicio Postal Mexicano" and are from the year 2002.

if anyone interested drop me a mail..

Regards.

Enrique Martinez

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)

iD8DBQFB5pXH0G0vuXH/csoRAmXKAKDYFqZdds58hC2s7AEa8cBuYtyvBwCg4HDi
YBTKOIT8bSl7mb/yb0JaJAk=
=26Nv
-----END PGP SIGNATURE-----

---------- ADVERTENCIA ----------

Este mensaje de email es enviado solamente para la(s) direccion(es) del
mismo, y contiene información que puede ser confidencial y/o protegida. Si
usted no es el destinatario previsto por favor notifique el remitente por
el email y suprima inmediatamente este email.

La utilización, acceso o la reproducción de este email por cualquier
persona con excepción del destinatario previsto se prohíbe
terminantemente.

No se hace ninguna afirmación que este email o cualquier archivo adjunto
está libre de virus, sin embargo a sido explorado por el antivirus clamav
( www.clamav.net )

Reservados todos los derechos www.linsys.com.mx
------------------------------------------