Public services and facilities in Helsinki, Finland
Tables
-
Educational Institutions by Municipality in FinlandTSV
This table contains data related to the education system in Finland. The data is sourced from the website of Helsingin kaupunkiympäristön toimiala, which is the City of Helsinki's Urban Environment Division. The table provides information on various aspects of elementary education in Finland, such as the division of areas, municipalities, unique identifiers, names in Finnish and Swedish, educational institutions, creation and modification dates, geographic data in GeoJSON and Geotext formats, geometry type, centroid, center coordinates, and the full geometry object. The table can be used for data analytics to gain insights into the spatial distribution of elementary education facilities, analyze changes in the education system over time, perform geographical analysis, and visualize the...
-
Version history of the 'Opev Ooa Alaaste Suomi Tuleva' polygon table from the 'Helsinki City Environment Department' in FinlandTSV
This table contains the version history of rows from the 'avoindataopev_ooa_alaaste_suomi_tuleva__opev_ooa_alaaste_suomi_tulevapolygon' base table. Each row represents a specific version of a geographical entity related to education in Finland. The '_start_date' column indicates the date when the row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row was extracted. If the '_end_date' value is null, it signifies that the row is the most recent version. The table includes various columns such as 'id', 'aluejako', 'kunta', 'tunnus', 'nimi_fi', 'nimi_se', 'toimipiste', 'yhtluontip', 'yhtdatanom', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y' which store...
Column Descriptions
Educational Institutions by Municipality in Finland
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date when the record was extracted. |
| _row_number | long | The row number of each record. |
| id | int | The unique identifier for each record. |
| aluejako | string | The division of the area. |
| kunta | int | The municipality associated with the record. |
| tunnus | int | The code or identifier for the record. |
| nimi_fi | string | The name of the record in Finnish language. |
| nimi_se | string | The name of the record in Swedish language. |
| toimipiste | int | The location or site associated with the record. |
| yhtluontip | string | The creation date of the entity associated with the record. |
| yhtdatanom | string | The last modification date of the entity associated with the record. |
| paivitetty | string | The date when the record was last updated. |
| geom_geojson | string | The geometrical information represented in GeoJSON format. |
| geom_geotext | string | The geometrical information represented in WKT (Well-Known Text) format. |
| geom_type | string | The type of geometrical shape associated with the record. |
| geom_centroid | string | The centroid point of the geometrical shape associated with the record. |
| geom_center_x | double | The X-coordinate of the center point of the geometrical shape associated with the record. |
| geom_center_y | double | The Y-coordinate of the center point of the geometrical shape associated with the record. |
| geom | binary | The geometrical information associated with the record. |
Version history of the 'Opev Ooa Alaaste Suomi Tuleva' polygon table from the 'Helsinki City Environment Department' in Finland
| Column | Type | Comment |
|---|---|---|
| _start_date | date | Column indicating the start date of the validity period for the row version. |
| _end_date | date | Column indicating the end date of the validity period for the row version. |
| _row_number | long | Column representing the row number of the version history table. |
| id | int | Column representing the identifier of the base table row. |
| aluejako | string | Column representing the distribution area of the base table row. |
| kunta | int | Column representing the municipality of the base table row. |
| tunnus | int | Column representing the code identifier of the base table row. |
| nimi_fi | string | Column representing the Finnish name of the base table row. |
| nimi_se | string | Column representing the Swedish name of the base table row. |
| toimipiste | int | Column representing the location of the office for the base table row. |
| yhtluontip | string | Column representing the creation date of the base table row. |
| yhtdatanom | string | Column representing the data retrieval date of the base table row. |
| paivitetty | string | Column representing the last updated date of the base table row. |
| geom_geojson | string | Column containing the geometry data of the base table row in GeoJSON format. |
| geom_geotext | string | Column containing the geometry data of the base table row in geotext format. |
| geom_type | string | Column representing the geometry type of the base table row. |
| geom_centroid | string | Column representing the centroid of the geometry of the base table row. |
| geom_center_x | double | Column representing the x-coordinate of the center of the geometry of the base table row. |
| geom_center_y | double | Column representing the y-coordinate of the center of the geometry of the base table row. |
| geom | binary | Column containing the geometry data of the base table row. |
Additional Info
| Last Updated | September 13, 2024 |
|---|---|
| Created | April 24, 2024 |