Seutukarttahyvinkaa Pienalueet

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

Tables

Hyvinkaa Small Areas in Hyvinkaa CityTSV
This table contains data from the web site of 'Helsinki City Environment Sector' in Finland. It represents a geographic area division called 'Hyvinkaa subregions' with the technical name 'seutukarttahyvinkaa_pienalueet__hyvinkaa_pienalueetpolygon'. The table includes various attributes related to these subregions. The data in this table can be utilized for data analytics purposes such as analyzing population sizes, assessing the status of each subregion, exploring the distribution of different categories within each subregion, studying the geographical characteristics, and calculating geometric properties.
Version History of Hyvinkaa Small Areas for Seutukartta from Helsingin kaupunkiympariston toimiala (Finland)TSV
This table contains the version history of the 'seutukarttahyvinkaa_pienalueet__hyvinkaa_pienalueetpolygon' table. It is sourced from the website of 'Helsinki City Planning Department' in Finland. The table includes information about the start and end dates of each row, along with other columns like 'row_number', 'kokotun', 'kunta', 'suur', 'tila', 'pien', 'nimi', 'nimi_iso', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The 'geom' column contains the geometric data. This historical versioning framework allows tracking changes over time. Not listing its individual columns, this data can be utilized in various data analytics tasks such as tracking changes in 'tila' (status) over time, analyzing the geographical distribution...

Column Descriptions

Hyvinkaa Small Areas in Hyvinkaa City

Column	Type	Comment
_extract_date	date
_row_number	long
kokotun	int
kunta	int
suur	int
tila	int
pien	int
nimi	string
nimi_iso	string
mtryhm	int
geom_geojson	string
geom_geotext	string
geom_type	string
geom_centroid	string
geom_center_x	double
geom_center_y	double
geom	binary

Version History of Hyvinkaa Small Areas for Seutukartta from 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 in the version history.
kokotun	int	The value representing the 'kokotun' attribute of the row.
kunta	int	The value representing the 'kunta' attribute of the row.
suur	int	The value representing the 'suur' attribute of the row.
tila	int	The value representing the 'tila' attribute of the row.
pien	int	The value representing the 'pien' attribute of the row.
nimi	string	The value representing the 'nimi' attribute of the row.
nimi_iso	string	The value representing the 'nimi_iso' attribute of the row.
mtryhm	int	The value representing the 'mtryhm' attribute of the row.
geom_geojson	string	The value representing the 'geom_geojson' attribute of the row.
geom_geotext	string	The value representing the 'geom_geotext' attribute of the row.
geom_type	string	The geometry type of the row.
geom_centroid	string	The centroid of the geometry of the row.
geom_center_x	double	The x-coordinate of the center point of the geometry of the row.
geom_center_y	double	The y-coordinate of the center point of the geometry of the row.
geom	binary	The geometry of the row.

Additional Info

Last Updated	April 23, 2024
Created	October 21, 2018