Download correct finnish geodata for Osclass here

[soundposts]

I composed a new file for Finnish locations. The file failed to load and after I corrected the errors the file still fails to load and for the life of me I can not find the errors in the file. The regions that have problems are 'Pirkanmaa' and 'Varsinais-Suomi'. They only load the region but no cities.

[teseo]

Hi,

Can you attach here your SQL file?

Regards

[soundposts]

Here is the file. Thought I had it attached...

[teseo]

I've just checked Pirkanmaa, there is a syntax error here:

(36506, 742306, 'fi', 'Lempäälä' 1, 'lempaala'),

A comma is missing, it should be:

(36506, 742306, 'fi', 'Lempäälä', 1, 'lempaala'),

Carefully recheck the block of cities for those two regions.

Regards

[soundposts]

Thanks! Now it's working fine. Some code blindness. Here is the corrected file if you wish to incorporate it in the Osclass location files.

[teseo]

You're welcome.

So, the geodata for Finland available here, you see it flawed?

Regards

[soundposts]

Yes, sorry to say it is way off. Some places names are in swedish some are in finnish and the regions are in spanish it something. Regions and cities are either mixed up or totally wrong. The regions that are in the present file (in spanish or similar) are official regions but ones that normally are not used  and there are practically no cities in that file. In this file are the normally used region names and should have all the cities.

[soundposts]

Just as reference here is a link to one Finnish classifieds site that show the same regions and cities that I am about to use.

www.tori.fi

[teseo]

If you desire to make your contribution available to the community:

http://geo.osclass.org/downloads/

Do you want to add your country to the list?

If you want to add a new country or improve the existing ones you can email us to info@osclass.org attaching a file (with the regions and cities) and specifying the structure of the attached file.

Regards

[soundposts]

Well I tried first when I noticed the need for corrections maybe six months ago. I tryed again before I started the corrections and again when I finished but nobody ever answered my message except for the automated answer.

[teseo]

I see. I don't have any relation with the Osclass developer team, so I just wouldn't know what's happening to them.

Then I think best thing you can do is to change the title of this thread to something such as "Download correct finnish geodata for Osclass here" or similar.

Regards

[soundposts]

OK. Thanks very much for your help! I've noticed that support rests much on this forum so again thanks to you as an active member!

I'll see about changing the subject. I've been wondering about the concept as a newcomer. I think they are concentrating on projects that bring money for Osclass which is quite understandable. Still would be nice to see some improvement in user support