History of Region Map Names in Swedish in Finland
Click here for a data sample
This table contains the version history of rows extracted from the web site of Helsingin kaupunkiympäristön toimiala in Finland. It is related to the seutukarttanimet_ruotsi__nimet_ruotsi base table. The table includes information about the start and end dates of each row version, a row number, 'nimi_r' data, 'ikoord' coordinates, 'pkoord' coordinates, 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The 'geom' column contains geometrical data. This table can be utilized in data analytics to analyze changes over time, track updates, compare different versions of rows, and perform spatial analysis on the geographical data.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period for the row version. |
|---|
| _end_date | date | The end date of the validity period for the row version. |
|---|
| _row_number | long | The unique identifier for each row version. |
|---|
| nimi_r | string | The name of the row. |
|---|
| ikoord | int | The x-coordinate of the row. |
|---|
| pkoord | int | The y-coordinate of the row. |
|---|
| geom_geojson | string | The geometry of the row in GeoJSON format. |
|---|
| geom_geotext | string | The text representation of the geometry of the row. |
|---|
| 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 point of the geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometry. |
|---|
| geom | binary | The geometry of the row. |
|---|
