Neighborhood division for health centers in Helsinki, Finland

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

Tables

Health center area classification in Helsinki, FinlandTSV
This table contains data from the Helsingin kaupunkiymparisto toimiala website, which is a source of information from Finland (ISO country code: fi). The table includes various columns including '_extract_date', '_row_number', 'gml_id', 'aluejako', 'kunta', 'nimi', 'nimi_se', 'omistaja', 'toimipiste', 'tunnus', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The data in this table can be utilized for data analytics purposes, such as analyzing the distribution and categorization of 'aluejako' (area division), identifying the municipalities ('kunta') in different regions, examining the names ('nimi') and their Swedish translations ('nimi_se'), understanding the ownership ('omistaja') information, and investigating the characteristics and...
Version History of Neuvola Area Distribution in Helsinki (from web site of Helsinki Urban Environment Sector, Finland)TSV
This table contains the version history of the 'sote_neuvola_aluejako' base table from the data source 'Helsingin kaupunkiympariston toimiala' in Finland (ISO country code: 'fi'). It includes rows with additional columns '_start_date' and '_end_date' indicating the extraction dates of each version. The table 'helsote_neuvola_aluejakosote_neuvola_aluejakohistory' can be used for data analytics to analyze the evolution of the 'sote_neuvola_aluejako' table over time. By comparing the start and end dates, users can track changes made to the rows. The table provides valuable information for studying trends, identifying updates, and understanding historical patterns in the 'sote_neuvola_aluejako' base table.

Column Descriptions

Health center area classification in Helsinki, Finland

Column	Type	Comment
_extract_date	date	The date on which the data was extracted.
_row_number	long	The row number of the record in the table.
gml_id	string	The GML identifier of the record.
aluejako	string	The division of the area.
kunta	int	The municipality.
nimi	string	The name of the record.
nimi_se	string	The name of the record in Swedish.
omistaja	string	The owner of the record.
toimipiste	int	The location of the record.
tunnus	string	The identifier of the record.
geom_geojson	string	The geometry of the record in GeoJSON format.
geom_geotext	string	The geometry of the record 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 full geometry of the record.

Version History of Neuvola Area Distribution in Helsinki (from web site of Helsinki Urban Environment Sector, 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 unique row number of the version history table.
gml_id	string	The GML ID of the row version.
aluejako	string	The partition of the area.
kunta	int	The municipality of the area.
nimi	string	The name of the area.
nimi_se	string	The name of the area in Swedish.
omistaja	string	The owner of the area.
toimipiste	int	The location of the area.
tunnus	string	The identifier of the area.
geom_geojson	string	The geometric data of the area in GeoJSON format.
geom_geotext	string	The geometric data of the area in Geotext format.
geom_type	string	The type of geometric data (e.g., polygon, point).
geom_centroid	string	The centroid of the geometric data.
geom_center_x	double	The x-coordinate of the center of the geometric data.
geom_center_y	double	The y-coordinate of the center of the geometric data.
geom	binary	The full geometric data of the area.

Additional Info

Last Updated	April 23, 2024
Created	October 22, 2018