Sea Area Data Collection from Metsantutkimuslaitos in Finland
Tables
-
Sea Areas data from the Finnish Forest Research InstituteTSV
This table contains data on sea areas obtained from the website of Metsantutkimuslaitos, originating from Finland (ISO country code 'fi'). It includes information such as the extraction date, row number, unique identifier, name of the sea area, geographic coordinates in GeoJSON format, geotext format, type of geometry, centroid of the geometry, center x-coordinate, center y-coordinate, and the original geometry. The data in this table can be utilized in various data analytics scenarios, such as analyzing the distribution and boundaries of different sea areas, calculating the area of each sea area, studying the proximity of certain points to the sea areas, and visualizing the spatial relationships between various geographical features.
-
Version History of Sea Area Data from Metsantutkimuslaitos in FinlandTSV
This table contains the version history of rows from the 'seal_sea_area' table. The 'seal_sea_area__history' table is sourced from the website of 'Finnish Forest Research Institute' located in Finland. It provides information about various seal sea areas in Finland. Each row in the table represents a particular version of a seal sea area, captured at different times. The '_start_date' column indicates the date when the particular version was extracted from the data source, while the '_end_date' column represents the date when a newer version of the row was extracted. If the '_end_date' value is null, it implies that the row is the most recent version. This table could be utilized in data analytics to track the changes and updates made to seal sea areas over time, analyze the frequency...
Column Descriptions
Sea Areas data from the Finnish Forest Research Institute
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date when the data was extracted. |
| _row_number | long | The sequential number of the row. |
| id | int | The unique identifier of the data. |
| name | string | The name of the data. |
| geom_geojson | string | The geometry of the data in GeoJSON format. |
| geom_geotext | string | The geometry of the data in Geotext format. |
| geom_type | string | The type of the geometry data. |
| geom_centroid | string | The centroid of the geometry data. |
| geom_center_x | double | The x-coordinate of the center point of the geometry data. |
| geom_center_y | double | The y-coordinate of the center point of the geometry data. |
| geom | binary | The full geometry data. |
Version History of Sea Area Data from Metsantutkimuslaitos in Finland
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The date when the row version becomes valid. |
| _end_date | date | The date when the row version expires. |
| _row_number | long | A sequential number indicating the position of the row version in the version history. |
| id | int | The unique identifier of the row. |
| name | string | The name of the row. |
| geom_geojson | string | The geometry of the row in GeoJSON format. |
| geom_geotext | string | The geometry of the row 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 of the row in a general format. |
Additional Info
| Last Updated | April 23, 2024 |
|---|---|
| Created | September 10, 2018 |