Open Data Helsinki Environmental Sector Dataset Collection

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

Tables

Geographical Areas in Finland by Educational Institutes and MunicipalitiesTSV
This table contains data from the 'Helsinki City Environment Sector' website in Finland. It includes various information related to the 'avoindataopev_ooa_ylaaste_suomi_tuleva__opev_ooa_ylaaste_suomi_tulevapolygon' dataset. 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'. This data can be utilized in various data analytics tasks such as analyzing geographical distribution, investigating trends in municipal areas, performing spatial analysis, and identifying patterns in the educational landscape.
Version History of Ooa Ylaaste Suomi Tuleva Polygon - Helsingin Kaupunkiympariston Toimiala (Finland)TSV
This table contains the version history of the base table 'avoindataopev_ooa_ylaaste_suomi_tuleva__opev_ooa_ylaaste_suomi_tulevapolygon'. It is sourced from the website of 'Helsinki City Environment Sector' from the country of Finland. The table consists of rows with additional columns '_start_date' and '_end_date' indicating the extraction dates. The data in this table can be utilized for various data analytics purposes, such as studying the changes in 'aluejako' (area division), analyzing trends in 'kunta' (municipality), examining 'nimi_fi' (name in Finnish) and 'nimi_se' (name in Swedish) variations, understanding the distribution of 'toimipiste' (office), and tracking updates in 'paivitetty' (last updated) field. Additionally, one can leverage the geographic data stored in the...

Column Descriptions

Geographical Areas in Finland by Educational Institutes and Municipalities

Column	Type	Comment
_extract_date	date	The date when the data was extracted
_row_number	long	The unique identifier for each row in the table
id	int	The unique identifier for each record in the table
aluejako	string	The distribution of the area
kunta	int	The municipality of the location
tunnus	int	The identifier for the location
nimi_fi	string	The name of the location in Finnish
nimi_se	string	The name of the location in Swedish
toimipiste	int	The office or facility associated with the location
yhtluontip	string	The type of unified creation
yhtdatanom	string	The nominal unified data
paivitetty	string	The date when the data was last updated
geom_geojson	string	The geometry data in GeoJSON format
geom_geotext	string	The geometry data in geotext format
geom_type	string	The type of geometry
geom_centroid	string	The centroid of the geometry
geom_center_x	double	The x-coordinate of the center of the geometry
geom_center_y	double	The y-coordinate of the center of the geometry
geom	binary	The spatial geometry data

Version History of Ooa Ylaaste Suomi Tuleva Polygon - Helsingin Kaupunkiympariston Toimiala (Finland)

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 row number indicating the order of the row version.
id	int	The unique identifier of the row version.
aluejako	string	The division of the area.
kunta	int	The municipality.
tunnus	int	The identification code.
nimi_fi	string	The name in Finnish.
nimi_se	string	The name in Swedish.
toimipiste	int	The office location.
yhtluontip	string	The date of the joint creation.
yhtdatanom	string	The date of the joint data nomination.
paivitetty	string	The date of the last update.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry in plain text format.
geom_type	string	The type of geometry.
geom_centroid	string	The centroid point of the geometry.
geom_center_x	double	The x-coordinate of the geometry center.
geom_center_y	double	The y-coordinate of the geometry center.
geom	binary	The geometry in raw format.

Additional Info

Last Updated	September 13, 2024
Created	May 2, 2024