Version History of Place Names in Swedish in the Helsinki Metropolitan Area
Click here for a data sample
The table contains the version history of the rows extracted from the data source 'Helsinki City Environment Sector' in the country Finland (ISO country code: 'fi'). It represents the historical records of a base table named 'avoindataseutukartta_nimisto_paikannimet_ruotsi__seutukartta_nimisto_paikannimet_ruotsipoint'. The table includes the following columns: '_start_date', '_end_date', '_row_number', 'nimi_r', 'ikoord', 'pkoord', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom', 'tietopalve'. The '_start_date' column indicates the date when a row was extracted, while the '_end_date' column represents the date when a new version of the row was extracted. If a row has a null value in the '_end_date' column, it denotes that it is the most recent version of the row. This historical data can be utilized for various data analytics purposes, such as tracking changes over time, analyzing trends, and conducting historical comparisons of the geographic locations, names, coordinates, and other information present in the table.
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 history entry. |
|---|
| nimi_r | string | The name of the row. |
|---|
| ikoord | int | The i-coordinate of the row. |
|---|
| pkoord | int | The p-coordinate of the row. |
|---|
| geom_geojson | string | The geometry of the row in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the row in Geotext format. |
|---|
| geom_type | string | The type of the geometry stored in the row. |
|---|
| geom_centroid | string | The centroid of the geometry stored in the row. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometry. |
|---|
| geom | binary | The geometry stored in the row. |
|---|
| tietopalve | int | The data service associated with the row. |
|---|
