Geo location corrections for austrian post codes

[Christian Bcn]

Hi,

This is my first lot for fixing geo location of some austian post codes.

Those ones are critical because the assigned geo location is not only out of bound their respective community and in one occasion even outside the country but also they don't match none of the possible communities by geo location. There is a lot more but I am still testing. The coordinates I have from google maps where I checked them by hand,

update geotables.PostCodes
set latitude =  46.542883,
longitude = 13.646370
where countrycode = 'AT' and postalcode = '9602' and placename = 'Unterthörl'

update geotables.PostCodes
set latitude =  46.543035,
longitude = 13.644340
where countrycode = 'AT' and postalcode = '9602' and placename = 'Oberthörl'

update geotables.PostCodes
set latitude =  46.601604,
longitude = 114.861083
where countrycode = 'AT' and postalcode = '9150' and placename = 'Weißenstein'

update geotables.PostCodes
set latitude =  48.941695,
longitude = 15.438467
where countrycode = 'AT' and postalcode = '3823' and placename = 'Neuriegers'

update geotables.PostCodes
set latitude =  48.554894,
longitude =  14.321509
where countrycode = 'AT' and postalcode = '4190' and placename = 'Roßberg'

update geotables.PostCodes
set latitude =  48.546807,
longitude = 14.316468
where countrycode = 'AT' and postalcode = '4190' and placename = 'Rading'

update geotables.PostCodes
set latitude =  47.168417,
longitude = 16.256768
where countrycode = 'AT' and postalcode = '7537' and placename = 'Neuberg im Burgenland / Nova Gora'

[Marc Wick]

Hi Christian

The all exist as PPL with some hundred meters offset. I have moved them
to a better position:
http://www.geonames.org/recent-changes/country/AT/

Do you have other changes? I will re-create the postalcode export
afterwards.

Best Regards

Marc

> --
> You received this message because you are subscribed to the Google
> Groups "GeoNames" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to geonames+u...@googlegroups.com
> <mailto:geonames+u...@googlegroups.com>.
> To post to this group, send email to geon...@googlegroups.com
> <mailto:geon...@googlegroups.com>.
> Visit this group at https://groups.google.com/group/geonames.
> For more options, visit https://groups.google.com/d/optout.

[Christian Bcn]

Hi Mark,

I have quite a few changes. I have an SQL Script I run after receiving updates. But in this script I fix predominantly admin1-3 codes (mainly admin3 when the place doesn't match up with the geodata table and then I fix iso to fips in admin1.

I am done with Andorra, Spain, Germany, Austria at least where PostCode to Admin3 Matching is concerned.

What is left is how to assure proper Place Naming for using the Post Code List for Mailing.

Here Austria is a Nightmare as all the 10?? Post Codes belong to Vienna but are mapped to communities within Vienna that are admin level 3. Just that you'd never use those names in Addressing.... and they are not really independent either.... There are 4 more areas in Autstria out of my head that work like this.....

Any way, what would be for you the easiest way to get post code update suggestions from me?

HAve a great Weekend!