Database of addresses of Helsinki

The database of addresses of Helsinki maintains information about the addresses and place names of properties and plan units located in the area of Helsinki. The street names and other names are in both Finnish and Swedish. The addresses are based on the address decisions of the City Survey Services, and the place names are based on the plan nomenclature, for which the Land Use and City Structure unit is responsible.

The database also contains address information of public services, sights and rail traffic stations. The address book consists of the addresses of the units in question and the coordinates of the locations. The addresses are maintained on a database basis and constantly updated based on address decisions and city planning.

The data is available for download in several formats, including JSON, KML, CSV, Esri Shape, and XML. Available formats can always be found under OutputFormat in the GetCapabilities query for the service.

Coordinate systems:

• Maintained in ETRS-GK25 (EPSG:3879), can be projected to other coordinate systems. See GetCapabilities query for other possible coordinate systems.

API addresses:

• WMS API: https://kartta.hel.fi/ws/geoserver/avoindata/wms
• WFS API: https://kartta.hel.fi/ws/geoserver/avoindata/wfs

Layers:

• Helsinki_nimisto
• Helsinki_osoiteluettelo
• Helsinki_osoitteet_rakennukset
• Osoiteluettelo_piste_rekisteritiedot

Helsinki_nimisto layer: attributes, data types and their key and reliability data in information services:

• id (int). Unique identifier of the feature. Reliable, comprehensively existing information.
• kunta (string). Municipality. Reliable, comprehensively existing information.
• tyyppi (string). Type of nomenclature. Reliable, comprehensively existing information.
• nimi (string). Finnish name. Reliable, comprehensively existing information.
• nimi_sv (string). Swedish name. Reliable, comprehensively existing information.
• east_etrs_gk (decimal). E coordinate (ETRS-GK25, EPSG:3879). Reliable, comprehensively existing information.
• north_etrs_gk (decimal). N coordinate (ETRS-GK25, EPSG:3879). Reliable, comprehensively existing information.
• datanomistaja (string). Data owner. Reliable, comprehensively existing information.
• paivitetty_tietopalveluun (date). Information service record date (yyyy-mm-dd). Reliable, comprehensively existing information.
• geom(GeometryPropertyType). Geometry of the feature.

Helsinki_osoiteluettelo layer: attributes, data types and their key and reliability data in information services:

• id (int). Unique identifier of the feature. Reliable, comprehensively existing information.
• katunimi (string). Name of the street address in Finnish. Reliable, comprehensively existing information.
• gatan (string). Name of the street address in Swedish. Reliable, comprehensively existing information.
• osoitenumero (short). Address number. Reliable, comprehensively existing information.
• osoitenumero2 (short). Latter digit of the two-part address number. Reliable, comprehensively existing information.
• osoitekirjain (string). Address letter associated with the address number. Reliable, comprehensively existing information.
• n (int). N coordinate (ETRS-GK25, EPSG:3879). Reliable, comprehensively existing information.
• e (int). E coordinate (ETRS-GK25, EPSG:3879). Reliable, comprehensively existing information.
• kaupunki (string). Finnish name of the city where the address is located. Reliable, comprehensively existing information.
• staden (string). Swedish name of the city where the address is located. Reliable, comprehensively existing information.
• tyyppi (short). Type of address. Reliable, comprehensively existing information.
• postinumero (string). Identification of the postal code area. Reliable, comprehensively existing information.
• postitoimipaikka (string). Name of the city in Finnish. Reliable, comprehensively existing information.
• osoitenumero_teksti (string). Assembled address number. Reliable, comprehensively existing information.
• datanomistaja (string). Data owner. Reliable, comprehensively existing information.
• paivitetty_tietopalveluun (date). Information service record date (yyyy-mm-dd). Reliable, comprehensively existing information.
• geom(GeometryPropertyType). Geometry of the feature.

Helsinki_osoitteet_rakennukset layer: attributes, data types and their key and reliability data in information services:

• id (int). Unique identifier of the feature. Reliable, comprehensively existing information.
• ratu (int). Permanent building identifier for Helsinki, i.e. “RATU”. Reliable, comprehensively existing information.
• vtj_prt (string). National permanent building identifier. Reliable, comprehensively existing information.
• katunimi_suomi (string). Name of the street address in Finnish. Reliable, comprehensively existing information.
• katunimi_ruotsi (string). Name of the street address in Swedish. Reliable, comprehensively existing information.
• osoitenumero (string). Assembled address number. Reliable, comprehensively existing information.
• postinumero (string). Identification of the postal code area. Reliable, comprehensively existing information.
• osoitetyyppi (string). Type of address. Reliable, comprehensively existing information.
• postitoimipaikka (string). Name of the city in Finnish. Reliable, comprehensively existing information.
• datanomistaja (string). Data owner. Reliable, comprehensively existing information.
• paivitetty_tietopalveluun (date). Information service record date (yyyy-mm-dd). Reliable, comprehensively existing information.
• geom(GeometryPropertyType). Geometry of the feature.

Attributes of the Osoiteluettelo_piste_rekisteritiedot layer:

• id (int): Serial ID number of the dataset.
• nimisto_id (int): ID of the place name feature to which the record relates.
• katuosoite (string): Address name + address number in Finnish.
• adress (string): Address name + address number in Swedish.
• katunimi (string): Street or marketplace/square address name in Finnish.
• gatan (string): Street or marketplace/square name in Swedish.
• osoitenumero (string): Address number (number + lower case letter, if any).
• postinumero (string): Postal code.
• nimistokohteen_laji (short): Type code of the place name feature.
• nimistokohteen_laji_selite (string): Key to the name place feature type.
• olotila (short): Status code. Valid.
• olotila_selite (string): Key to the status code.
• n (integer): North coordinate (ETRS-GK25).
• e (integer): East coordinate (ETRS-GK25).
• lisatieto (string): Any additional information.
• kunta (string): Municipality.
• kaupunginosa_tunnus (short): City district number.
• kaupunginosa_nimi_fi (string): Name of the city district in Finnish.
• kaupunginosa_nimi_se (string): Name of the city district in Swedish.
• pienalue_tunnus (string): Numeric identifier of the small district. Small districts do not have names.
• osaalue_tunnus (string): Numeric identifier of the city sub district.
• osaalue_nimi_fi (string): Name of the city sub-district in Finnish.
• osaalue_nimi_se (string): Name of the city sub-district in Swedish.
• peruspiiri_tunnus (string): Numeric identifier of the district.
• peruspiiri_nimi_fi (string): Name of the district in Finnish.
• peruspiiri_nimi_se (string): Name of the district in Swedish.
• suurpiiri_tunnus (string): Numeric identifier of the major district.
• suurpiiri_nimi_fi (string): Name of the major district in Finnish.
• suurpiiri_nimi_se (string): Name of the Major district in Swedish.
• datanomistaja (string): Owner of the data.
• paivitetty_tietopalveluun (date): Information service record date (yyyy-mm-dd).
• geom (geometry): Geometry of the feature (point).

Key to the tyyppi attribute:

• 1 osoite tai katu / address or street
• 2 puisto tai kenttä / park or field
• 3 muu / other
• 4 liikennepaikka / operating point
• 5 kaupunginosa / city district
• 6 saari / island
• 7 silta / bridge
• 8 liikuntapaikka / sports facility
• 9 tori tai aukio / marketplace or square
• 10 hautausmaa / cemetery
• 11 uimaranta / beach
• 12 satama / harbour
• 13 siirtolapuutarha tai mökkikylä / allotment garden or cottage village
• 14 luonnonsuojelualue / nature reserve
• 15 matkailukohde / tourist attraction
• 16 kortteli tai korttelinosa / quarter or part of quarter
• 17 maastonimi / terrain name
• 18 vesistönimi / name of water body
• 19 liittymä tai risteys / junction or crossing
• 20 rakennus / building
• 21 peruspiiri / district
• 22 osa-alue / city sub-district

The key to the tyyppi attribute does not apply to the layer Helsinki_osoitteet_rakennukset. The key to the osoitetyyppi attribute at that layer is the following:

• 1 ensisjainen osoite / primary address
• 2 rinnakkaisosoite / parallel address