Version History of Urban District Names and Coordinates in Finland
Click here for a data sample
This table contains the version history of the 'avoindataseutukartta_nimisto_kaupunginosanimet_suomi__seutukartta_nimisto_kaupunginosanimet_suomipoint' table. The table is sourced from the website of 'Helsinki City Environment Sector' in Finland. It provides historical information about various attributes of city district names, including the start and end dates of each version. The '_start_date' column indicates the extraction date of the row, while the '_end_date' column specifies the date when a new version of the row was extracted. If the '_end_date' value is null, it means that the corresponding row represents the latest version. The table can be utilized for data analytics purposes, such as tracking the changes in city district names over time, analyzing the frequency of updates, or identifying patterns or trends in the data.
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 in the table. |
|---|
| nimi_s | string | The name of the row in the base table. |
|---|
| ikoord | int | The coordinate i value. |
|---|
| pkoord | int | The coordinate p value. |
|---|
| geom_geojson | string | The geometry in GeoJSON format. |
|---|
| geom_geotext | string | The geometry in Geotext format. |
|---|
| geom_type | string | The type of the geometry. |
|---|
| geom_centroid | string | The centroid of the geometry. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry. |
|---|
| geom | binary | The geometry. |
|---|
| tietopalve | int | The data service that provided the information. |
|---|
