Address List Point Registry Information Version History
Click here for a data sample
This table contains the version history of the rows from the base table 'avoindataosoiteluettelo_piste_rekisteritiedot__osoiteluettelo_piste_rekisteritiedotpoint'. Each row in this table represents a specific version of a row in the base table, with additional columns '_start_date' and '_end_date' indicating the extraction dates of the versions. The data in this table is sourced from the website of 'Helsinki City Environment Sector', which originates from the country 'Finland' (ISO country code 'fi'). The table can be utilized in data analytics to track changes in address information over time, analyze the historical state of properties and locations, and identify trends or patterns in the maintenance or updates of the dataset.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period of the row version. |
|---|
| _end_date | date | The end date of the validity period of the row version. |
|---|
| _row_number | long | The row number of the version. |
|---|
| id | int | The unique identifier of the row. |
|---|
| nimisto_id | int | The identifier of the naming system. |
|---|
| katuosoite | string | The address in Finnish. |
|---|
| adress | string | The address in Swedish. |
|---|
| katunimi | string | The street name in Finnish. |
|---|
| gatan | string | The street name in Swedish. |
|---|
| osoitenume | int | The address number. |
|---|
| nimistokoh | int | The name location. |
|---|
| nimistoko0 | string | The name location 0. |
|---|
| olotila | int | The condition. |
|---|
| olotila_se | string | The condition in Swedish. |
|---|
| kunta | int | The municipality. |
|---|
| kaupungino | int | The city. |
|---|
| kaupungin0 | string | The city 0. |
|---|
| kaupungin1 | string | The city 1. |
|---|
| postinumer | int | The postal code. |
|---|
| n | int | The latitude coordinate. |
|---|
| e | int | The longitude coordinate. |
|---|
| paivitetty | string | The date of update. |
|---|
| datanomist | string | The data owner. |
|---|
| geom_geojson | string | The geometry in GeoJSON format. |
|---|
| geom_geotext | string | The geometry in Geotext format. |
|---|
| geom_type | string | The type of geometry. |
|---|
| geom_centroid | string | The centroid of the geometry. |
|---|
| geom_center_x | double | The x-coordinate of the geometry center. |
|---|
| geom_center_y | double | The y-coordinate of the geometry center. |
|---|
| geom | binary | The geometry. |
|---|
