Vihti Neighborhoods Geographic Dataset Collection

This dataset collection consists of one or more dataset tables sourced from the website of 'Helsinki City Environment Sector' in Finland.

Small Areas in Vihti, Finland - Map of Local AreasTSV
This table contains data from the 'Helsinki Urban Environment Sector' website, sourced from Finland. The table includes information about small areas in the Vihri region. The data includes details such as the extraction date, row number, size, municipality, district, status, name, ISO name, main group, geographical information in GeoJSON format, geographical information in Geotext format, geographical type, centroid coordinates, center X coordinate, center Y coordinate, and geometry.
Version History for Vihiti Small AreasTSV
This table contains the version history of the 'seutukarttavihti_pienalueet__vihti_pienalueetpolygon' table. It includes additional columns '_start_date' and '_end_date' that indicate the extraction dates of each row. The data in this table is sourced from the website of Helsingin kaupunkiympariston toimiala, which originates from Finland (ISO country code 'fi'). The table can be used in various data analytics scenarios, such as tracking changes over time, analyzing the historical trends of geographical regions, or studying the evolution of specific attributes over different versions of the data.

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.
kokotun	int	The total number of something.
kunta	int	The name of a municipality or district.
suur	int	The size or magnitude of something.
tila	int	The status or condition of something.
pien	int	The small or minor value of something.
nimi	string	The name or title of something.
nimi_iso	string	The ISO code of a name or title.
mtryhm	int	The group or category of something.
geom_geojson	string	The geometry data in GeoJSON format.
geom_geotext	string	The geometry data in Geotext format.
geom_type	string	The type or shape of the geometry.
geom_centroid	string	The centroid point of the geometry.
geom_center_x	double	The x-coordinate of the center point of the geometry.
geom_center_y	double	The y-coordinate of the center point of the geometry.
geom	binary	The full geometry data.

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 row number indicating the order of the row version.
kokotun	int	The value of the 'kokotun' column.
kunta	int	The value of the 'kunta' column.
suur	int	The value of the 'suur' column.
tila	int	The value of the 'tila' column.
pien	int	The value of the 'pien' column.
nimi	string	The value of the 'nimi' column.
nimi_iso	string	The value of the 'nimi_iso' column.
mtryhm	int	The value of the 'mtryhm' column.
geom_geojson	string	The value of the 'geom_geojson' column.
geom_geotext	string	The value of the 'geom_geotext' column.
geom_type	string	The value of the 'geom_type' column.
geom_centroid	string	The value of the 'geom_centroid' column.
geom_center_x	double	The x-coordinate of the center point of the geometry.
geom_center_y	double	The y-coordinate of the center point of the geometry.
geom	binary	The geometry object containing spatial data.

Last Updated	April 23, 2024
Created	October 21, 2018