Wrong time zone for Huelva, Cádiz & Almería Spain provinces

As an example, when you use the city of Cádiz, the assigned timezone is not the Spain timezone, but the timezone of Portugal, Iceland, United Kingdom and part of Africa.

However, when you use another city not in Huelva, Cádiz or Almería (say, Madrid), the timezone is correct, i.e. the Spain timezone.

You can see here that Cádiz and Madrid has assigned two different timezones:

- Cádiz has the wrong UTC timezone.

- Madrid has the right UTC+2 timezone.

Both Cádiz and Madrid (actually, all the Spain cities except Canary islands) must have the same UTC+2 timezone.

I can confirm this bug and I´ve assigned this bug to the tzdata package.
Thanks for reporting it.

Architecture: i386
DistroRelease: Ubuntu 11.04
LiveMediaBuild: Ubuntu 11.04 "Natty Narwhal" - Release i386 (20110427.1)
Package: tzdata 2011f-1
PackageArchitecture: all
ProcEnviron:
 LANGUAGE=es_ES:en
 PATH=(custom, no user)
 LANG=es_ES.UTF-8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 2.6.38-8.42-generic 2.6.38.2
Tags: natty
Uname: Linux 2.6.38-8-generic i686
UpgradeStatus: No upgrade log present (probably fresh install)
UserGroups:

apport information

I added the ubuntu-geoip task because I think the problem isn't in the tzdata, as tzdata only maps contry capitols with timezones. Huelva, Cádiz & Almería aren't country capitols.

I believe geoip is the service which assigns a timezone to a city (not only contry capitols), but maybe I'm wrong.

Interestingly, today Huelva has assigned the right timezone, although Cádiz and Almería still hasn't.

However, some other cities like "Ayamonte" or "Sanlúcar de Guadiana" (both in the Huelva province) still has the wrong timezone.

When I do:

  $ wget http://geoip.ubuntu.com/lookup

I get the following response:

<?xml version="1.0" encoding="UTF-8"?><Response><Ip>84.122.158.151</Ip><Status>OK</Status><CountryCode>ES</CountryCode><CountryCode3>ESP</CountryCode3><CountryName>Spain</CountryName><RegionCode>51</RegionCode><RegionName>Andalucia</RegionName><City>Sanl<FA>car De Barrameda</City><ZipPostalCode></ZipPostalCode><Latitude>36.7833</Latitude><Longitude>-6.3500</Longitude><AreaCode>0</AreaCode><TimeZone>Africa/Ceuta</TimeZone></Response>

All the above information is right, EXCEPT for the time zone. The right timezone for Sanlúcar de Barrameda (Spain) is "Europe/Madrid", and NOT "Africa/Ceuta".

Obviously, the GeoIP database in geoip.ubuntu.com is wrong.

What can I do in order to fix the above entry in the database?

The problem is in the GeoIP database on geoip.ubuntu.com, not in the tzdata package.