0 Members and 1 Guest are viewing this topic.

Zipcodes
« on: December 07, 2016, 12:09:02 PM »
Good morning,

i think there is an error on the german Zip Code CSV.

I had a look into the first one "Germany_zips_0001" and it seems that the zipcodes have only 4 digits what is wrong as germany has 5 digit Zipcodes and he Latitude and Longitude seem to be in the wrong order..

Longitude,Latitude instead Latitude,Longitude

Here an example:

1067     13.73659992   51.05070114 >> with this coordinates it's somewhere in the Ocean
01067 51.05070114   13.73659992 >> would be Dresden Wilsdruffer Str. what is right

Best regards
Dave



*

Pharg

  • *****
  • 2,789
    • OsDateFourm
  • osDate Version: osDate Evo v1.2
Re: Zipcodes
« Reply #1 on: December 07, 2016, 08:33:45 PM »
Hi Dave,

Your probably correct, the ZipCodes haven't been updated in like 7 years.
These were made by the original developers and there was a person that updated them but he never posted
them to this forum.

Sorry to say but the only way to fix this is to get the correct Zipcodes for Germany and rewrite them, I assume there
is a website where all the country codes are.
Try sending a messege to the member Benoitc64 to see if he has the updated codes and ask if he can give you them?

It's like my country a few years back, our services changed all our postal codes (Zipcodes) so even I don't have them up to date either but there was never any csv made for my country we had to do it ourselves also.
In my site, I just let the members write the code in themselves.

Sorry I can't be of further help for now.
Regards,
Pharg ( Phill )

REMEMBER: ALWAYS BACKUP BEFORE YOU MAKE ANY CHANGES!!

osDateEvo v1.2 | PHP: 5.3.42 & PHP: 5.6.18 | MySQL: 5.5.35

Re: Zipcodes
« Reply #2 on: December 07, 2016, 09:36:29 PM »
Hi Phrag,

no worries, i am working on them already alos on the States, counties etc... Once i have it for every Country i need can i upload it here :-)

But it will take a while as i am not working fulltime on it.

Is here any place in the Forum for userfiles? Maybe i overseen it

Best regards
Dave

*

Pharg

  • *****
  • 2,789
    • OsDateFourm
  • osDate Version: osDate Evo v1.2
Re: Zipcodes
« Reply #3 on: December 08, 2016, 01:32:53 AM »
Hi Dave,

Thank you, that would be much appreciated :)

Regards, Pharg
Regards,
Pharg ( Phill )

REMEMBER: ALWAYS BACKUP BEFORE YOU MAKE ANY CHANGES!!

osDateEvo v1.2 | PHP: 5.3.42 & PHP: 5.6.18 | MySQL: 5.5.35

*

Benoitc64

  • *
  • 31
  • osDate Version: osDate Evo v1.2
Re: Zipcodes
« Reply #4 on: March 24, 2017, 03:56:45 PM »
Good morning,

i think there is an error on the german Zip Code CSV.

I had a look into the first one "Germany_zips_0001" and it seems that the zipcodes have only 4 digits what is wrong as germany has 5 digit Zipcodes and he Latitude and Longitude seem to be in the wrong order..

Longitude,Latitude instead Latitude,Longitude

Here an example:

1067     13.73659992   51.05070114 >> with this coordinates it's somewhere in the Ocean
01067 51.05070114   13.73659992 >> would be Dresden Wilsdruffer Str. what is right

Best regards
Dave


Hi dave,  i can switch the coordinates without problem.

i will do it  and post a link so you can download it and pharg include it in the package

osDateEvo v1.2 | PHP 5.6.30-0+deb8u1 | MySQL: 5.5.51 |

*

Benoitc64

  • *
  • 31
  • osDate Version: osDate Evo v1.2
Re: Zipcodes
« Reply #5 on: March 24, 2017, 03:58:30 PM »
is it all zipcode is inverted or just the first
osDateEvo v1.2 | PHP 5.6.30-0+deb8u1 | MySQL: 5.5.51 |

*

Pharg

  • *****
  • 2,789
    • OsDateFourm
  • osDate Version: osDate Evo v1.2
Re: Zipcodes
« Reply #6 on: March 24, 2017, 09:36:19 PM »
Hi Benoitc64,

Sorry I have no idea if it's inverted.

Zip and Post codes have changed since they were last written.
Regards,
Pharg ( Phill )

REMEMBER: ALWAYS BACKUP BEFORE YOU MAKE ANY CHANGES!!

osDateEvo v1.2 | PHP: 5.3.42 & PHP: 5.6.18 | MySQL: 5.5.35

*

Benoitc64

  • *
  • 31
  • osDate Version: osDate Evo v1.2
Re: Zipcodes
« Reply #7 on: April 01, 2017, 03:11:31 AM »
Effectively all the latitude and longitude of the German zipcode files are inverted. I will correct and  I will  post them here soon.
osDateEvo v1.2 | PHP 5.6.30-0+deb8u1 | MySQL: 5.5.51 |

*

Pharg

  • *****
  • 2,789
    • OsDateFourm
  • osDate Version: osDate Evo v1.2
Re: Zipcodes
« Reply #8 on: April 01, 2017, 06:34:54 AM »
Hi Benoitc64,

Cool thanks that will be helpful.

I am updating all the languages with all the missing words from the menu and the plugins missing languages as some
have no text in them at all.
Regards,
Pharg ( Phill )

REMEMBER: ALWAYS BACKUP BEFORE YOU MAKE ANY CHANGES!!

osDateEvo v1.2 | PHP: 5.3.42 & PHP: 5.6.18 | MySQL: 5.5.35

*

Benoitc64

  • *
  • 31
  • osDate Version: osDate Evo v1.2
Re: Zipcodes
« Reply #9 on: April 01, 2017, 06:53:17 AM »
Hi  , here are the new zipcodes for Germany,  I've switch the longitude and latitude.

« Last Edit: June 01, 2017, 08:55:56 AM by Pharg »
osDateEvo v1.2 | PHP 5.6.30-0+deb8u1 | MySQL: 5.5.51 |

*

Pharg

  • *****
  • 2,789
    • OsDateFourm
  • osDate Version: osDate Evo v1.2
Re: Zipcodes
« Reply #10 on: April 01, 2017, 07:39:16 AM »
Thanks Benoitc64  :D
Regards,
Pharg ( Phill )

REMEMBER: ALWAYS BACKUP BEFORE YOU MAKE ANY CHANGES!!

osDateEvo v1.2 | PHP: 5.3.42 & PHP: 5.6.18 | MySQL: 5.5.35