Dataset collection from Helsingin kaupunkiympariston toimiala in country FI

This dataset collection consists of one or more dataset tables sourced from the website of Helsingin kaupunkiympariston toimiala in Finland.

Tables

Historical Version of Table: Finnish Primary Education Areas in Sweden (Polygon)TSV
The table contains the version history of rows from the 'Helsingin kaupunkiympariston toimiala' data source, which originates from the country 'Finland' (ISO country code 'fi'). The table provides a historical record of changes made to rows in the base table, 'avoindataopev_ooa_alaaste_ruotsi__opev_ooa_alaaste_ruotsipolygon'. Each row in the history table includes the '_start_date' and '_end_date' columns, indicating the extraction dates of the row versions. The table includes additional columns like '_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', which store various attributes and location-related...
Primary Education Areas in Finland - Swedish Language InstructionTSV
This table contains data sourced from the website of the 'Helsinki City Environment Department'. The data originates from the country with the ISO country code 'Finland'. It provides information about the various attributes related to education in the Helsinki region. The table has columns such as '_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'. These columns contain data that can be utilized for various data analytics purposes, such as geographical analysis, demographic analysis, and education statistics. By analyzing the data in this table, one can gain insights into the education...

Column Descriptions

Primary Education Areas in Finland - Swedish Language Instruction

Column	Type	Comment
_extract_date	date	The date when the data was extracted
_row_number	long	The row number of the data
id	int	The unique identifier of the record
aluejako	string	The value distribution
kunta	int	The municipality
tunnus	int	The identifier
nimi_fi	string	The name in Finnish
nimi_se	string	The name in Swedish
toimipiste	int	The location
yhtluontip	string	The creation date
yhtdatanom	string	The data validity
paivitetty	string	The date when the data was last updated
geom_geojson	string	The geometry in GeoJSON format
geom_geotext	string	The geometry in Geotext format
geom_type	string	The type of the geometry
geom_centroid	string	Coordinate of the centroid
geom_center_x	double	X-coordinate of the center
geom_center_y	double	Y-coordinate of the center
geom	binary	The geometry

Historical Version of Table: Finnish Primary Education Areas in Sweden (Polygon)

Column	Type	Comment
_start_date	date	The start date of the validity period for the row version.
_end_date	date	The end date of the validity period for the row version.
_row_number	long	The sequential number assigned to each row version in the table.
id	int	The unique identifier for each row in the table.
aluejako	string	The area division of the row.
kunta	int	The municipality of the row.
tunnus	int	The identifier for the row.
nimi_fi	string	The name of the row in Finnish language.
nimi_se	string	The name of the row in Swedish language.
toimipiste	int	The office of the row.
yhtluontip	string	The creation date of the row.
yhtdatanom	string	The data creator of the row.
paivitetty	string	The update date of the row.
geom_geojson	string	The geometry of the row in GeoJSON format.
geom_geotext	string	The geometry of the row in GeoTEXT format.
geom_type	string	The type of geometry for the row.
geom_centroid	string	The centroid of the geometry for the row.
geom_center_x	double	The x-coordinate of the center point of the geometry for the row.
geom_center_y	double	The y-coordinate of the center point of the geometry for the row.
geom	binary	The geometry data for the row.

Additional Info

Last Updated	September 13, 2024
Created	April 24, 2024