History of Neighborhood Names in Finland from Helsingin kaupunkiympariston toimiala
Click here for a data sample
This table contains the version history of the 'seutukarttanimet_kaupunginosat_suomi__nimet_kaupunginosat_suomi' table sourced from the web site of 'Helsingin kaupunkiympariston toimiala' in Finland. It includes historical records of various attributes such as names, coordinates, geometries, and other related data. Each row in the table represents a specific version of the base table, identified by the '_start_date' and '_end_date' columns. The '_end_date' column indicates the date when a new version of the row was extracted. If its value is null, it implies that the corresponding row is the most recent version. The data in this table can be utilized for various data analytics purposes, such as analyzing the changes in neighborhood names and boundaries over time, identifying trends in geographic coordinates, or studying the evolution of geometries associated with city districts in Finland.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The date when the version of the row started being valid. |
|---|
| _end_date | date | The date when the version of the row stopped being valid. |
|---|
| _row_number | long | A unique identifier for each row version. |
|---|
| nimi_s | string | The name of the row version. |
|---|
| ikoord | int | The i-coordinate of the row version. |
|---|
| pkoord | int | The p-coordinate of the row version. |
|---|
| geom_geojson | string | The geometry of the row version in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the row version in GeoText format. |
|---|
| geom_type | string | The type of the geometry in the row version. |
|---|
| geom_centroid | string | The centroid of the geometry in the row version. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry in the row version. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry in the row version. |
|---|
| geom | binary | The geometry of the row version. |
|---|
