Suuralueet dataset collection from Helsingin kaupunkiympariston toimiala in Finland

This dataset collection consists of one or more tables sourced from the website of Helsingin kaupunkiympäristön toimiala in Finland.

Tables

Map Districts in Kirkkonummi, FinlandTSV
This table contains data from the 'Helsinki City Environment Sector' website. The data represents the polygon areas of different districts in Kirkkonummi, Finland. The table includes various columns such as the extraction date, row number, district name, district code, municipality, group name, ISO name, geometry in GeoJSON format, geometry in GeoText format, geometry type, centroid of the geometry, centroid's X-coordinate, centroid's Y-coordinate, and the original geometry. The data in this table can be utilized for various data analytics purposes such as analyzing the population distribution across different districts, conducting spatial analyses to study the land area, or performing geolocation-based queries for further analysis.
Version History of 'Kirkkonummi Municipality Areas' in 'Helsinki Urban Environment Sector' Dataset from FinlandTSV
This table contains the version history of the rows in the 'seutukarttakirkkonummi_suuralueet__kirkkonummi_suuralueetpolygon' table. The data in this table is sourced from the website of 'Helsinki City Environment Sector' in Finland (ISO country code: 'fi'). The '_start_date' column indicates the extraction date of each row, while the '_end_date' column indicates the date when a new version of the row was extracted. If the '_end_date' is null, it means that the row is the most recent version. The table includes additional columns such as 'kokotun', 'kunta', 'suur', 'nimi', 'nimi_iso', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y', which contain various attributes related to the data. This table provides valuable information...

Column Descriptions

Map Districts in Kirkkonummi, Finland

Column	Type	Comment
_extract_date	date	Date when the data was extracted
_row_number	long	Row number in the table
kokotun	string	City name
kunta	string	Municipality name
suur	string	Population size
nimi	string	Name of the city or municipality
nimi_iso	string	ISO name of the city or municipality
mtryhm	int	Municipality group
geom_geojson	string	Geographical data in GeoJSON format
geom_geotext	string	Geographical data in Geotext format
geom_type	string	Type of geographical object
geom_centroid	string	Centroid of the geographical object
geom_center_x	double	X-coordinate of the center of the geographical object
geom_center_y	double	Y-coordinate of the center of the geographical object
geom	binary	Geographical data in geometrical format

Version History of 'Kirkkonummi Municipality Areas' in 'Helsinki Urban Environment Sector' Dataset from Finland

Column	Type	Comment
_start_date	date	The start date indicating the validity period of the row version.
_end_date	date	The end date indicating the validity period of the row version.
_row_number	long	A unique identifier for each row version within the table.
kokotun	string	Unknown or unspecified column.
kunta	string	Unknown or unspecified column.
suur	string	Unknown or unspecified column.
nimi	string	Unknown or unspecified column.
nimi_iso	string	Unknown or unspecified column.
mtryhm	int	Unknown or unspecified column.
geom_geojson	string	Unknown or unspecified column containing geometry data in GeoJSON format.
geom_geotext	string	Unknown or unspecified column containing geometry data in geotext (text-based) format.
geom_type	string	The type of geometry represented by the row version.
geom_centroid	string	The centroid of the geometry represented by the row version.
geom_center_x	double	The x-coordinate of the center point of the geometry represented by the row version.
geom_center_y	double	The y-coordinate of the center point of the geometry represented by the row version.
geom	binary	Unknown or unspecified column containing geometry data.

Additional Info

Last Updated	May 17, 2024
Created	October 21, 2018