Helpel Suojelulohko Dataset Collection
Tables
-
Historical Versions of Protection Area Blocks in Helsinki, FinlandTSV
This table contains the version history of rows from the 'Helsingin kaupunkiympariston toimiala' website's base table 'helpel_suojelulohko__pel_suojelulohko'. It is sourced from the country with ISO country code 'fi'. Each row in this table represents a specific version of a row from the base table, with additional columns '_start_date' and '_end_date' indicating the extraction dates of the row versions. The table contains various columns such as 'gml_id', 'kunta', 'kunta_nimi', 'kunta_nim0', 'suojeluloh', 'suojelulo0', 'suojelulo1', 'suojelupii', 'suojelupi0', 'suojelupi1', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y', which provide additional information about the rows. This historical table can be utilized in data analytics to...
-
Protected Areas in FinlandTSV
This table provides information about protected areas in the municipality of Helsinki, Finland. The data is sourced from the website of Helsinki City Environment Sector. The table contains various attributes such as extraction date, row number, GML ID, municipality code, municipality name, protected area code, protected area name, protection classification, protection classification details, protection level, protection level details, protection purpose, protection purpose details, the geometry of the protected area in GeoJSON and Geotext formats, geometry type, centroid coordinates, and the full geometry of the protected area. This data can be utilized in various data analytics scenarios such as analyzing the distribution of protected areas within the municipality, studying the...
Column Descriptions
Protected Areas in Finland
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date when the data was extracted. |
| _row_number | long | The row number of the record. |
| gml_id | string | The GML identifier of the record. |
| kunta | int | The municipality code. |
| kunta_nimi | string | The name of the municipality. |
| kunta_nim0 | string | Alternative name of the municipality. |
| suojeluloh | string | The level of protection of the area. |
| suojelulo0 | string | Additional level of protection of the area. |
| suojelulo1 | int | Additional level of protection of the area. |
| suojelupii | string | The classification of the area. |
| suojelupi0 | string | Additional classification of the area. |
| suojelupi1 | int | Additional classification of the area. |
| geom_geojson | string | The geometry of the record in GeoJSON format. |
| geom_geotext | string | The geometry of the record in Well-Known Text format. |
| geom_type | string | The type of geometry. |
| geom_centroid | string | The centroid point of the geometry. |
| geom_center_x | double | The x-coordinate of the centroid point. |
| geom_center_y | double | The y-coordinate of the centroid point. |
| geom | binary | The geometry of the record in binary format. |
Historical Versions of Protection Area Blocks in Helsinki, Finland
| Column | Type | Comment |
|---|---|---|
| _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 number assigned to the row version in the table. |
| gml_id | string | The unique identifier of the row version in the GML format. |
| kunta | int | The code representing the 'kunta' attribute of the row version. |
| kunta_nimi | string | The name of the 'kunta' attribute of the row version. |
| kunta_nim0 | string | The previous name of the 'kunta' attribute of the row version. |
| suojeluloh | string | The code representing the 'suojeluloh' attribute of the row version. |
| suojelulo0 | string | The previous value of the 'suojelulo' attribute of the row version. |
| suojelulo1 | int | The current value of the 'suojelulo' attribute of the row version. |
| suojelupii | string | The code representing the 'suojelupii' attribute of the row version. |
| suojelupi0 | string | The previous value of the 'suojelupii' attribute of the row version. |
| suojelupi1 | int | The current value of the 'suojelupii' attribute 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 of the row version. |
| geom_centroid | string | The centroid of the geometry of the row version. |
| geom_center_x | double | The x-coordinate of the centroid of the geometry of the row version. |
| geom_center_y | double | The y-coordinate of the centroid of the geometry of the row version. |
| geom | binary | The spatial data structure representing the geometry of the row version. |
Additional Info
| Last Updated | September 13, 2024 |
|---|---|
| Created | October 22, 2018 |