Open Data Services and Results in Finland

The dataset collection consists of tables sourced from the website of Helsingin kaupunkiympäristön toimiala in Finland.

Primary School Areas in FinlandTSV
This table contains data from 'Helsinki City Environment Department' in Finland. The table consists of various columns including '_extract_date', '_row_number', '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'. The data in this table can be utilized in data analytics for various purposes such as geospatial analysis, statistical analysis, mapping, and visualization.
Version History of Education Data for Basic Education in FinlandTSV
This table, sourced from the website of the 'Helsinki City Environment Department' from Finland, provides the version history of rows in the 'avoindataopev_ooa_alaaste_suomi__opev_ooa_alaaste_suomipolygon' table. The rows in this table contain information about various attributes 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'. The '_start_date' column represents the date when a particular row was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted. If the '_end_date' value is null, it implies that the row is the most recent version. The data in...

Column	Type	Comment
_extract_date	date	The date when the row was extracted from the source
_row_number	long	The row number of the entry in the table
id	int	The unique identifier of the entry
aluejako	string	The division of the area
kunta	int	The municipality or city of the entry
tunnus	int	The identifier code of the entry
nimi_fi	string	The name of the entry in Finnish
nimi_se	string	The name of the entry in Swedish
toimipiste	int	The workplace or institution associated with the entry
yhtluontip	string	The overall creation type of the entry
yhtdatanom	string	The data authority of the entry
paivitetty	string	The date when the entry was last updated
geom_geojson	string	The entry's geometry in GeoJSON format
geom_geotext	string	The entry's geometry representation as text
geom_type	string	The type of geometry of the entry
geom_centroid	string	The centroid or center point 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 entry's geometry

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 row number indicating the position of the row version.
id	int	The unique identifier of the row.
aluejako	string	The division of the area.
kunta	int	The municipality of the area.
tunnus	int	The code or identifier of the area.
nimi_fi	string	The name of the area in Finnish.
nimi_se	string	The name of the area in Swedish.
toimipiste	int	The office location or branch.
yhtluontip	string	The combined creation type.
yhtdatanom	string	The combined data authority.
paivitetty	string	The timestamp of when the row was last updated.
geom_geojson	string	The geometry of the area in GeoJSON format.
geom_geotext	string	The textual representation of the area's geometry.
geom_type	string	The type of the area's geometry.
geom_centroid	string	The centroid of the area's geometry.
geom_center_x	double	The x-coordinate of the center of the area's geometry.
geom_center_y	double	The y-coordinate of the center of the area's geometry.
geom	binary	The detailed geometry information of the area.

Last Updated	September 13, 2024
Created	April 24, 2024