Version History of Marine Area Names in Sweden for District Map Names in Sweden Sourced from the Website of 'City Environment Sector of Helsinki' (Country: Finland)
Click here for a data sample
This table contains the version history of the rows from the base table 'seutukarttanimet_merialueet_ruotsi__nimet_merialueet_ruotsi'. It has additional columns '_start_date' and '_end_date' that represent the extraction dates for each row. The data in this table is sourced from the website of 'Helsinki City Environment Sector' in Finland. The data source is from the country with the ISO country code 'FI'. This table can be utilized in data analytics to track the changes in the names of marine areas over time, analyze the spatial distribution of marine areas using geographic coordinates, and calculate the centroids and center points of the geometry of the marine areas.
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. |
|---|
| nimi_r | string | The name of the base table row. |
|---|
| ikoord | int | The X-coordinate of the spatial geometry. |
|---|
| pkoord | int | The Y-coordinate of the spatial geometry. |
|---|
| geom_geojson | string | The spatial geometry in GeoJSON format. |
|---|
| geom_geotext | string | The spatial geometry in Geotext format. |
|---|
| geom_type | string | The type of the spatial geometry. |
|---|
| geom_centroid | string | The centroid of the spatial geometry. |
|---|
| geom_center_x | double | The X-coordinate of the center point of the spatial geometry. |
|---|
| geom_center_y | double | The Y-coordinate of the center point of the spatial geometry. |
|---|
| geom | binary | The spatial geometry. |
|---|
