search

rekola / okffi-geocoder

okf.fi geocoder
http://api.okf.fi/console/
MIT License
8 stars 2 forks source link

has_irregular_house_numbers column missing in sql file #14

Closed teemuha closed 9 years ago

teemuha commented 9 years ago

Current downloadable sql file doesn´t seems to include "has_irregular_house_numbers" column in geocoder table even though it is used in API.pm module.

[Sat Nov 22 10:42:09.745389 2014] [:error] [pid 5296] DBD::mysql::st execute failed: Unknown column 'has_irregular_house_numbers' in 'field list' at /var/www/okffi-geocoder/geocoder-perl/API.pm line 161.\n

rekola commented 9 years ago

My bad. I will update the file.

teemuha commented 9 years ago

Thanks :)

teemuha commented 9 years ago

I had also another question. geocode.json script includes this in row 53: my $db = $self->getMtkDB3;

getMtkDB3 subroutine isn´t available in any of the modules. getMtkDB and getMtkDB2 is in API.pm. Code works if I remove 3 from the call.

rekola commented 9 years ago

Here is a working version of the database:

http://data.okf.fi/dumps/okffi_geocoding_data.2014-10-27.zip

The new database has exact house number positions from Helsinki, Espoo, Kauniainen, Vantaa and Oulu and the new column "has_irregular_house_numbers" informs the client that such exact position data is available. Exact data from Tampere will be added soon.

getMtkDB3 was missing because a change wasn't committed. Fixed that too.

If you have any more questions, I'm happy to help you.

teemuha commented 9 years ago

Seems to work. Thanks.