Geospatial Dataset Collection of Finland's Archipelago featuring Place Names
Tables
-
Geographical Names of Marine Areas in Finland from Helsingin kaupunkiympariston toimialaTSV
This table contains data from 'Helsinki City Environmental Sector' website, originating from Finland. It provides information about maritime areas in Finland. The dataset includes fields such as _extract_date, _row_number, nimi_s, ikoord, pkoord, geom_geojson, geom_geotext, geom_type, geom_centroid, geom_center_x, geom_center_y, geom, and tietopalve. The data in this table can be utilized for various data analytics purposes, such as analyzing the distribution and characteristics of different maritime areas in Finland, studying the spatial patterns and clustering of these areas, or conducting geographical analysis related to maritime infrastructure or activities.
-
Historical Versions of Location Names and Coordinates in Finnish Coastal Areas on Open Data Spatial MapTSV
This table contains the version history of rows extracted from the 'Helsingin kaupunkiympariston toimiala' website. The rows in this table represent various features found in marine areas in Finland. Each row has a unique identification number (_row_number) and includes information such as the name of the feature (nimi_s), geographical coordinates (ikoord and pkoord), geometrical data in both GeoJSON and Geotext formats (geom_geojson and geom_geotext), the type of geometry (geom_type), the centroid of the geometry (geom_centroid), the x and y coordinates of the center point (geom_center_x and geom_center_y), the full geometry (geom), and additional information provided by the 'tietopalve' service. The table includes two additional columns, '_start_date' and '_end_date', indicating the...
Column Descriptions
Geographical Names of Marine Areas in Finland from Helsingin kaupunkiympariston toimiala
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the row was extracted |
_row_number | long | The row number or identifier |
nimi_s | string | The name |
ikoord | int | The x-coordinate |
pkoord | int | The y-coordinate |
geom_geojson | string | The geometry in GeoJSON format |
geom_geotext | string | The geometry in Geotext format |
geom_type | string | The geometry type |
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 server providing the data |
Historical Versions of Location Names and Coordinates in Finnish Coastal Areas on Open Data Spatial Map
Column | Type | Comment |
---|---|---|
_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 row number of the version in the table. |
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 geometry for the row version. |
geom_centroid | string | The centroid of the geometry for the row version. |
geom_center_x | double | The x-coordinate of the center point of the geometry for the row version. |
geom_center_y | double | The y-coordinate of the center point of the geometry for the row version. |
geom | binary | The geometry of the row version. |
tietopalve | int | The data service of the row version. |
Additional Info
Last Updated | September 13, 2024 |
---|---|
Created | May 6, 2018 |