Seutukartta Helsinki Pienalueet

The dataset collection 'seutukarttahelsinki_pienalueet' consists of one or more dataset tables sourced from the web site of 'Helsingin kaupunkiympariston toimiala' (Helsinki City Environment Sector) in Finland. The tables in this collection provide detailed information about small areas in Helsinki.

Tables

Helsinki Small Areas Polygon Data from City of Helsinki, FinlandTSV
This table contains data from the 'Helsinki City Districts - Helsinki City District Polygons' dataset, sourced from the website of Helsinki City Environment Sector. The data is sourced from Finland (ISO country code: 'fi'). The table includes various columns such as '_extract_date', '_row_number', 'kokotun', 'kunta', 'suur', 'perus', 'osa', 'pien', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom'. This data can be utilized for various data analytics tasks such as analyzing the distribution of different district sizes, municipalities, urban areas, basic areas, partial areas, and small areas. It can also be used for spatial analysis and visualization using the geometry columns such as 'geom_geojson'. The table provides...
Version History of Helsinki Sub-Areas (Polygon)TSV
This table contains the version history of the 'seutukarttahelsinki_pienalueet__helsinki_pienalueetpolygon' table. It includes additional columns '_start_date' and '_end_date' which respectively indicate the extraction date of each row and the date when a new version of the row was extracted. The data in this table is sourced from the website of 'Helsinki City Environment Sector' in Finland ('fi' ISO country code). The table provides valuable information that can be used for data analytics purposes such as studying the changes in 'kokotun', 'kunta', 'suur', 'perus', 'osa', 'pien', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom' over time. By analyzing the version history, trends and patterns can be identified, enabling...

Column Descriptions

Helsinki Small Areas Polygon Data from City of Helsinki, Finland

Column	Type	Comment
_extract_date	date	The date the record was extracted
_row_number	long	The unique identifier for each row
kokotun	int	The total population of the region
kunta	int	The name of the municipality
suur	int	The size of the region in square kilometers
perus	int	The basic unit of the region
osa	int	The subunit of the region
pien	int	The small unit of the region
mtryhm	int	The demographic group
geom_geojson	string	The geographic data in GeoJSON format
geom_geotext	string	The geographic data in Geotext format
geom_type	string	The type of geographic feature
geom_centroid	string	The centroid coordinates of the geographic feature
geom_center_x	double	The x-coordinate of the center of the geographic feature
geom_center_y	double	The y-coordinate of the center of the geographic feature
geom	binary	The geometry of the geographic feature

Version History of Helsinki Sub-Areas (Polygon)

Column	Type	Comment
_start_date	date	This column indicates the start date of the validity period of the row version.
_end_date	date	This column indicates the end date of the validity period of the row version.
_row_number	long	This column represents the row number in the table.
kokotun	int	This column stores the value for 'kokotun' attribute.
kunta	int	This column stores the value for 'kunta' attribute.
suur	int	This column stores the value for 'suur' attribute.
perus	int	This column stores the value for 'perus' attribute.
osa	int	This column stores the value for 'osa' attribute.
pien	int	This column stores the value for 'pien' attribute.
mtryhm	int	This column stores the value for 'mtryhm' attribute.
geom_geojson	string	This column stores the geometric data in GeoJSON format.
geom_geotext	string	This column stores the geometric data in Geotext format.
geom_type	string	This column stores the type of geometric data.
geom_centroid	string	This column stores the centroid of the geometric data.
geom_center_x	double	This column stores the X-coordinate of the center of the geometric data.
geom_center_y	double	This column stores the Y-coordinate of the center of the geometric data.
geom	binary	This column stores the geometric data in a general format.

Additional Info

Last Updated	September 13, 2024
Created	October 21, 2018