Water Bodies in Finland
Click here for a data sample
This table contains data about lakes in Finland. It is sourced from the website of the 'City of Helsinki Environment Sector', which originates from the country with ISO country code 'fi'. The table includes information such as the extraction date, row number, water source, water area, water group, geographic data in the form of JSON and text format, geometry type, centroid coordinates, and the full geometry of the lake. The data in this table can be utilized in various data analytics scenarios, such as analyzing the distribution of lakes based on their water group, calculating the total water area in a specific region, identifying the location of a lake's centroid, or studying the geographical characteristics of different lake shapes.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date on which the data was extracted. |
|---|
| _row_number | long | The row number of the record. |
|---|
| vesistap | string | The unique identifier of the waterbody. |
|---|
| vesista0 | string | The type of waterbody. |
|---|
| mtryhm | int | The group the waterbody belongs to. |
|---|
| geom_geojson | string | The geometry of the waterbody in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the waterbody in Well-Known Text (WKT) format. |
|---|
| geom_type | string | The type of geometry of the waterbody (point, line, or polygon). |
|---|
| geom_centroid | string | The centroid location of the waterbody. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the waterbody. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the waterbody. |
|---|
| geom | binary | The complete geometry information of the waterbody. |
|---|
