Statistical Areas of Seutukartta in Hyvinkää, Finland

The dataset collection consists of one or more dataset tables sourced from the website of 'Department of Urban Environment, Helsinki' in Finland.

Tables

Hyvinkää Statistical AreasTSV
This table contains statistical area information for the city of Hyvinkää, sourced from the website of Helsingin kaupunkiympäristön toimiala. The data originates from Finland (ISO country code: FI). It includes various attributes such as the extraction date, row number, size, municipality, region, status, name, ISO name, main group, geographic JSON representation, geotext representation, geometric type, centroid, center x-coordinate, center y-coordinate, and the overall geometry. The table provides valuable data for data analytics purposes, enabling insights and analysis related to the statistical areas in Hyvinkää, such as population trends, demographic patterns, spatial distribution, and various spatial analytics use cases.
Version History of Statistical Areas in Hyvinkaa, sourced from Helsingin kaupunkiympariston toimiala (Finland)TSV
This table contains the version history of rows from the base table 'seutukarttahyvinkaa_tilastoalueet__hyvinkaa_tilastoalueetpolygon'. Each row in this table represents a specific version of a row in the base table, with additional columns '_start_date' and '_end_date'. The '_start_date' column holds the date when the specific version of the row was extracted from the data source. The '_end_date' column denotes the date when a new version of the row was extracted, or it is null if the row is the most recent version. The data in this table is sourced from the website of Helsingin kaupunkiympariston toimiala, which is operated by the country with ISO country code 'fi'. The table provides valuable data for data analytics, such as analyzing changes and trends over time in various...

Column Descriptions

Hyvinkää Statistical Areas

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data entry.
kokotun	int	The name of the village.
kunta	int	The name of the municipality.
suur	int	The size of the area.
tila	int	The status of the entry.
nimi	string	The name of the location.
nimi_iso	string	The ISO code of the location name.
mtryhm	int	The group of municipalities.
geom_geojson	string	The geometry of the location in GeoJSON format.
geom_geotext	string	The geometry of the location 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 geometry of the location.

Version History of Statistical Areas in Hyvinkaa, sourced from Helsingin kaupunkiympariston toimiala (Finland)

Column	Type	Comment
_start_date	date	The start date of the row version validity period.
_end_date	date	The end date of the row version validity period.
_row_number	long	The number assigned to the row version.
kokotun	int	The value of column kokotun.
kunta	int	The value of column kunta.
suur	int	The value of column suur.
tila	int	The value of column tila.
nimi	string	The value of column nimi.
nimi_iso	string	The value of column nimi_iso.
mtryhm	int	The value of column mtryhm.
geom_geojson	string	The value of column geom_geojson.
geom_geotext	string	The value of column geom_geotext.
geom_type	string	The value of column geom_type.
geom_centroid	string	The centroid of the geometry.
geom_center_x	double	The x-coordinate of the geometry's center point.
geom_center_y	double	The y-coordinate of the geometry's center point.
geom	binary	The geometry object.

Additional Info

Last Updated	April 23, 2024
Created	October 21, 2018