Health Center Area Division Dataset Collection

The dataset collection 'helsote_terveysasema_aluejako' consists of one or more dataset tables sourced from the website of 'Helsingin kaupunkiympariston toimiala' in Finland.

Tables

Health Center Area Division Version HistoryTSV
This table contains the version history of the 'Helsote Terveysasema Aluejako' dataset sourced from the website of Helsingin kaupunkiympäristön toimiala. The dataset originates from Finland (ISO country code: FI). The table records the changes in the base table 'Helsote Terveysasema Aluejako' over time, with each row representing a specific version of the data. The '_start_date' column indicates the date when a particular version of a row was extracted from the data source. The '_end_date' column contains the date when a new version of the row was extracted. If the '_end_date' is null, it means that the row represents the most recent version. The table provides valuable information for data analytics, allowing for historical analysis and tracking of changes in the 'Helsote Terveysasema...
Health center areas division table from City of Helsinki Environment Services, FinlandTSV
This table contains information about healthcare clinic areas in Helsinki, Finland. It is sourced from the website of Helsinki City Environment Sector. The table includes various attributes such as the extraction date, row number, GML ID, division area, municipality, name, name in Swedish, owner, operational site, code, geometries in GeoJSON and Geotext formats, geometry type, centroid coordinates, and the full geometry details. The data in this table can be utilized for various data analytics purposes, such as analyzing the distribution of healthcare clinics across different division areas and municipalities in Helsinki, calculating the geometric properties of the clinic areas, and visualizing the clinic areas on a map to gain insights into the spatial distribution of healthcare...

Column Descriptions

Health center areas division table from City of Helsinki Environment Services, Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the record.
gml_id	string	The GML ID of the record.
aluejako	string	The division of the area.
kunta	int	The municipality of the area.
nimi	string	The name of the area.
nimi_se	string	The Swedish name of the area.
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 geometry of the area in GeoJSON format.
geom_geotext	string	The geometry of the area 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 area.

Health Center Area Division Version History

Column	Type	Comment
_start_date	date	The start date of the validity period for the row version.
_end_date	date	The end date of the validity period for the row version.
_row_number	long	The row number of the version in the table.
gml_id	string	The identifier for the row version in GML format.
aluejako	string	The division of the area for the row version.
kunta	int	The municipality for the row version.
nimi	string	The name for the row version.
nimi_se	string	The name in Swedish for the row version.
omistaja	string	The owner of the row version.
toimipiste	int	The business location for the row version.
tunnus	string	The identification number for the row version.
geom_geojson	string	The geometry in GeoJSON format for the row version.
geom_geotext	string	The geometry in geotext format for the row version.
geom_type	string	The type of geometry for the row version.
geom_centroid	string	The centroid coordinates of the geometry for the row version.
geom_center_x	double	The X-coordinate of the center of the geometry for the row version.
geom_center_y	double	The Y-coordinate of the center of the geometry for the row version.
geom	binary	The original geometry for the row version.

Additional Info

Last Updated	September 13, 2024
Created	October 22, 2018