Registry Information for Public Outdoor Recreation Spaces in Helsinki, Finland
Tables
-
Piste Register Data HistoryTSV
This table contains the version history of rows in the 'avoindatanimisto_piste_rekisteritiedot__nimisto_piste_rekisteritiedotpoint' table. It has additional columns '_start_date' and '_end_date' which represent the extraction dates of the rows from the data source. The data in this table is sourced from the website of 'Helsinki City Environment Services' in Finland (FI). The table can be utilized for various data analytics purposes such as analyzing changes in the 'nimi_suomi' (Finnish name) and 'nimi_ruots' (Swedish name) columns over time, studying the 'olotila' (condition) and 'laji' (type) of the points, investigating the distribution of points across different 'kunta' (municipality) in Finland, and analyzing the spatial attributes provided in the 'geom' column such as 'geom_type'...
-
Register Information for Points of Public and Semi-public Areas in Helsinki, FinlandTSV
This table contains data from Helsingin kaupunkiympariston toimiala website, which originates from Finland. It contains information about avoindatanimisto_piste_rekisteritiedot__nimisto_piste_rekisteritiedotpoint. The table includes various columns such as '_extract_date', '_row_number', 'id', 'kaava_viit', 'kaavatunnu', 'nimi_suomi', 'nimi_ruots', 'olotila', 'olotila_se', 'laji', 'laji_selit', 'nimeamispe', 'nimikatego', 'lisatieto', 'kunta', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. These columns hold valuable data that can be utilized in various data analytics tasks such as spatial analysis, identifying and categorizing geographical features, understanding the state and condition of the...
Column Descriptions
Register Information for Points of Public and Semi-public Areas in Helsinki, Finland
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date when the data was extracted. |
| _row_number | long | The row number of the entry. |
| id | int | The unique identifier of the entry. |
| kaava_viit | int | The reference of the formula. |
| kaavatunnu | int | The identification code of the formula. |
| nimi_suomi | string | The name of the entry in Finnish. |
| nimi_ruots | string | The name of the entry in Swedish. |
| olotila | int | The status of the entry. |
| olotila_se | string | The status of the entry in Swedish. |
| laji | int | The category of the entry. |
| laji_selit | string | The description of the entry category. |
| nimeamispe | string | The designation category of the entry. |
| nimikatego | string | The category of the name. |
| lisatieto | string | Additional information about the entry. |
| kunta | int | The municipality of the entry. |
| datanomist | string | The data custodian or owner. |
| paivitetty | int | The date when the entry was last updated. |
| geom_geojson | string | The geometry of the entry in GeoJSON format. |
| geom_geotext | string | The geometry of the entry in Geotext format. |
| geom_type | string | The type of geometry of the entry. |
| geom_centroid | string | The centroid of the entry's geometry. |
| geom_center_x | double | The x-coordinate of the center point of the entry's geometry. |
| geom_center_y | double | The y-coordinate of the center point of the entry's geometry. |
| geom | binary | The geometry of the entry in a general format. |
Piste Register Data History
| 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 each row in the version history table. |
| id | int | The unique identifier of the row in the base table. |
| kaava_viit | int | The reference number of the plan. |
| kaavatunnu | int | The identification number of the plan. |
| nimi_suomi | string | The name of the plan in Finnish language. |
| nimi_ruots | string | The name of the plan in Swedish language. |
| olotila | int | The status of the plan. |
| olotila_se | string | The status of the plan in Swedish language. |
| laji | int | The type of the plan. |
| laji_selit | string | The description of the plan type. |
| nimeamispe | string | The designation of the plan. |
| nimikatego | string | The category of the plan. |
| lisatieto | string | Additional information about the plan. |
| kunta | int | The municipality where the plan is located. |
| datanomist | string | The owner of the data. |
| paivitetty | int | The date when the plan was last updated. |
| geom_geojson | string | The geometry of the plan in GeoJSON format. |
| geom_geotext | string | The geometry of the plan in a textual representation. |
| geom_type | string | The type of the plan geometry. |
| geom_centroid | string | The centroid coordinates of the plan geometry. |
| geom_center_x | double | The X coordinate of the center of the plan geometry. |
| geom_center_y | double | The Y coordinate of the center of the plan geometry. |
| geom | binary | The plan geometry in a binary format. |
Additional Info
| Last Updated | September 13, 2024 |
|---|---|
| Created | April 23, 2024 |