rekola/okffi-geocoder

okf.fi geocoder

okffi-geocoder's Issues

Import house number data for more municipalities

Please import house number datasets for more municipalities than just the capital region.

Tampere: http://palvelut2.tampere.fi/tietovaranto/tietovaranto.php?id=88&alasivu=1&vapaasana=

Oulu: http://www.ouka.fi/oulu/oulu-tietoa/avoin-data/-/asset_publisher/Wz43/content/oulun-kaupungin-karttapalvelun-osoitteet

More information: http://avoindata.net/171/mista-saa-osoitteiden-koordinaatit?show=463#a463

Missing postcode

The following address has no postcode:
Pappilantie 1, Kurikka, Suomi

Itella database has a row with no house number, and that should match with this road

List applications that use the API

http://api.okf.fi/console/ should include a list of applications and demos that use the API. You could find some of them looking at the referer information in HTTP access logs. Here's some demos:

http://www.karttatehdas.fi:3000/

http://tuukka.kapsi.fi/tmp/kapsi-kartat/leaflet.html

http://dev.hsl.fi/navigator-geocoder/

has_irregular_house_numbers column missing in sql file

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

Data should be downloadable in some more compatible format

Geocoding data is available in MySQL dump format, but because this MySQL dump contains geographical data in binary format, it is not easy to import the data into other database management systems (e.g. PostgreSQL + PostGIS).

I believe ESRI Shapefile might be most compatible format and there are a lot of free tools (e.g. ogr2ogr) which can convert shapefiles to other formats or import them into a database.

Could you provide data in some more compatible format in addition to MySQL dump?

Sample PostGIS compatible geo data point in HEX-format below:

select st_geomfromtext('POINT(24.94 60.171)', 4326);
                  st_geomfromtext                   
----------------------------------------------------
 0101000020E6100000713D0AD7A3F03840D9CEF753E3154E40

500 Internal Server Error

The following request results in 500 Internal Server Error: http://data.okf.fi/gis/1/geocode.json?address=pappilantie&lat=&lng=&language=fin

Disambiguate repository name

The current repository name "geocoder" is ambiguous as numerous "geocoders" already exist. Should we rename this as "okffi-geocoder"?

Missing postcode

The following address has no postcode:
Aleksis Kiven katu 1 Helsinki
Should pick the closest housenumber from Itella database "Aleksis Kiven katu 3 - 9"

Use the national dataset from VRK

The national dataset for Finland from VRK is now open: https://www.avoindata.fi/data/fi/dataset/rakennusten-osoitetiedot-koko-suomi

It could solve or alleviate many of the other issues such as #16, #13, #11, #7, #3, if there's no need for address and postcode interpolation or new municipality-specific data sources.

Document how to rebuild database

Document where to download the source data, how to process it, how to import it. (I see there has been an earlier discussion about maybe using the ogr2ogr tool in this.)

Asennusohjeet

Opasta varten tarvittaisiin asennusohjeet: http://books.okf.fi/geocoder/_draft/_v/1.0/asennus/

Irregular responses for reverse geocoding requests

Its me again :)

When you try to make reverse geocoding request, you might get at least two different responses for same query.

Tested this with OKF test console and also with my own server.
http://api.okf.fi/gis/1/geocode.json?address=&language=fin&lat=60.04080&lng=23.57450

Case1:

Case2:

Return multiple results

The interface should return a list of results if there are multiple matches. For example, this should return Helsinki in addition to Skogby: http://data.okf.fi/gis/1/geocode.json?address=mannerheimintie+1&lat=&lng=&language=fin

Street with space in name not found

Search for "Väinö Auerin katu" returns no results in geocoder or autocomplete.

Search for "Väinö Auerin katu 1" works correctly in geocoder but returns "Väinö Auerin katu 11" in autocomplete.

Link from README and Github to data.okf.fi

The README file and the repository description in Github settings should link to http://data.okf.fi/console/