Health Center Area Division Version History
Click here for a data sample
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 Aluejako' dataset. By comparing the versions, it is possible to identify changes in the allocated areas, municipalities, names, owners, facilities, codes, geometries, and centroids over time.
Field Descriptions
| Name |
Data type |
Description |
| _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. |
|---|
