Dataset collection 'helosaalue' from Helsingin kaupunkiympariston toimiala in Finland
Tables
-
Helsinki Area Subarea DataTSV
This table contains data from 'Helsinki City Environment Sector' website. It provides information about different areas within Helsinki. The data originates from Finland (ISO country code: 'fi'). The table has various columns that store information such as the extraction date, row number, municipality name, district names, ID, code, geographical data, and more. These columns can be utilized for various data analytics purposes. For example, the 'peruspiiri' column can be used to analyze the basic districts within Helsinki, while the 'geom_type' column can be used to determine the type of geometry data stored in the 'geom' column. The 'kunta_nimi' and 'suurpiiri' columns can be utilized to analyze municipalities and major districts within Helsinki, respectively. The 'geom_centroid' column...
-
Version History of Helsingin kaupunkiympariston toimiala Table Rows in FinlandTSV
This table contains the version history of the rows from the 'Helsingin kaupunkiympariston toimiala' data source. The data in this table is sourced from the web site of the Helsinki Urban Environment Division, which originates from Finland (ISO country code 'fi'). The table has additional columns compared to its base table, including '_start_date' which signifies the date when the row was extracted from the data source, and '_end_date' which indicates the date when a new version of the row was extracted. If the value of '_end_date' is null, it means that the row is the most recent version. The data in this table can be utilized in various data analytics tasks, such as analyzing the historical changes and trends of the 'kunta_nimi', 'suurpiiri', 'peruspiiri', 'id', 'tunnus', 'kunta',...
Column Descriptions
Helsinki Area Subarea Data
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date when the data was extracted. |
| _row_number | long | The number of the row in the table. |
| kunta_nimi | string | The name of the municipality. |
| kunta_nim0 | string | An alternate name of the municipality. |
| suurpiiri | string | The name of the major district. |
| suurpiiri0 | string | An alternate name of the major district. |
| peruspiiri | string | The name of the basic district. |
| id | int | The unique identifier of the table row. |
| tunnus | int | An additional identifier for the table row. |
| peruspiir0 | int | An alternate name of the basic district. |
| suurpiiri1 | int | An additional name of the major district. |
| kunta | int | An additional name of the municipality. |
| nimi | string | The name of the district. |
| nimi_se | string | The name of the district in Swedish. |
| peruspiir1 | string | An additional name of the basic district. |
| geom_geojson | string | The geometrical representation of the district in GeoJSON format. |
| geom_geotext | string | The text representation of the geometrical information. |
| geom_type | string | The type of geometry of the district. |
| geom_centroid | string | The centroid of the district. |
| geom_center_x | double | The X coordinate of the center of the district. |
| geom_center_y | double | The Y coordinate of the center of the district. |
| geom | binary | The geometrical representation of the district. |
Version History of Helsingin kaupunkiympariston toimiala Table Rows in Finland
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The start date indicating the beginning of the validity period for the row version. |
| _end_date | date | The end date indicating the end of the validity period for the row version. |
| _row_number | long | The row number of the version history row. |
| kunta_nimi | string | The name of the municipality. |
| kunta_nim0 | string | The previous name of the municipality. |
| suurpiiri | string | The name of the big district. |
| suurpiiri0 | string | The previous name of the big district. |
| peruspiiri | string | The name of the basic district. |
| id | int | The unique identifier of the row. |
| tunnus | int | The code or symbol associated with the row. |
| peruspiir0 | int | The previous name of the basic district. |
| suurpiiri1 | int | Another name of the big district. |
| kunta | int | Another name of the municipality. |
| nimi | string | The name of the place. |
| nimi_se | string | The name of the place in Swedish. |
| peruspiir1 | string | Another name of the basic district. |
| geom_geojson | string | The geometry of the place in GeoJSON format. |
| geom_geotext | string | The geometry of the place in geotext format. |
| geom_type | string | The type of the geometry (point, line, polygon, etc.). |
| geom_centroid | string | The centroid point of the geometry. |
| geom_center_x | double | The X coordinate of the center point of the geometry. |
| geom_center_y | double | The Y coordinate of the center point of the geometry. |
| geom | binary | The full geometry object. |
Additional Info
| Last Updated | September 13, 2024 |
|---|---|
| Created | October 21, 2018 |