Table collection of 'seutukarttavihti_suuralueet' dataset from Helsingin kaupunkiympariston toimiala in Finland (FI)

The dataset collection is sourced from the web site of Helsingin kaupunkiympariston toimiala in Finland.

Tables

Version History of Suuralueet in Vihdi, sourced from Helsingin kaupunkiympariston toimiala (Finland)TSV
This table contains the version history of the 'seutukarttavihti_suuralueet__vihti_suuralueetpolygon' table. The table was sourced from the website of Helsingin kaupunkiympariston toimiala, which is the Urban Environment Division of the City of Helsinki, Finland (ISO country code: FI). The table records the changes made to the base table over time, with two additional columns '_start_date' and '_end_date'. The '_start_date' column indicates the date when a row was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted. If the value of '_end_date' is null, it means that the row is the most recent version. The table is valuable for data analytics purposes, allowing users to track the historical changes made to the data,...
Vihti Districts - Areas in Vihti MunicipalityTSV
This table contains data on the different areas within the Vihti region, sourced from the website of Helsingin kaupunkiympariston toimiala in Finland. The table includes information such as the extract date, row number, area size, municipality, region, new name, ISO name, metro group, geographic coordinates in GeoJSON format, geographic text, geometry type, centroid coordinates, and the complete geometry of the area. These data can be utilized in various data analytics scenarios, such as analyzing the distribution of different regions within Vihti, calculating the average size of the areas, visualizing the geographic information on a map, and examining the relationships between different metro groups and the regions.

Column Descriptions

Vihti Districts - Areas in Vihti Municipality

Column	Type	Comment
_extract_date	date	The date on which the data was extracted
_row_number	long	The row number of the record
kokotun	int	The total population count
kunta	int	The municipality of the population
suur	int	The size of the population
nimi_uusi	string	The new name of the location
nimi_iso	string	The ISO code for the location
mtryhm	int	The population group
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 centroid
geom_center_y	double	The y-coordinate of the centroid
geom	binary	The geometry of the location

Version History of Suuralueet in Vihdi, sourced from Helsingin kaupunkiympariston toimiala (Finland)

Column	Type	Comment
_start_date	date	The start date of the validity period of the row version.
_end_date	date	The end date of the validity period of the row version.
_row_number	long	The number of the row version.
kokotun	int	Description of column 'kokotun' is not available.
kunta	int	Description of column 'kunta' is not available.
suur	int	Description of column 'suur' is not available.
nimi_uusi	string	Description of column 'nimi_uusi' is not available.
nimi_iso	string	Description of column 'nimi_iso' is not available.
mtryhm	int	Description of column 'mtryhm' is not available.
geom_geojson	string	Description of column 'geom_geojson' is not available.
geom_geotext	string	Description of column 'geom_geotext' is not available.
geom_type	string	Description of column 'geom_type' is not available.
geom_centroid	string	Description of column 'geom_centroid' is not available.
geom_center_x	double	Description of column 'geom_center_x' is not available.
geom_center_y	double	Description of column 'geom_center_y' is not available.
geom	binary	Description of column 'geom' is not available.

Additional Info

Last Updated	September 13, 2024
Created	October 21, 2018