Version History of Social Assistance Areas in Helsinki, Finland
Click here for a data sample
This table contains the version history of the rows extracted from the data source 'Helsingin kaupunkiympariston toimiala' in the country 'Finland' (ISO country code: 'fi'). The table represents the base table 'helsote_toimeentulotukialue__sote_toimeentulotukialue', but includes two additional columns: '_start_date' and '_end_date'. The '_start_date' column indicates the date when the row was extracted, while the '_end_date' column represents the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it signifies that the row is the most recent version. The table contains various columns such as '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 various data analytics purposes, such as geographical analysis, identifying ownership information, and tracking changes over time.
Field Descriptions
| Name |
Data type |
Description |
| _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 number of the row version. |
|---|
| gml_id | string | The ID of the row version in the Geography Markup Language format. |
|---|
| aluejako | string | The area division associated with the row version. |
|---|
| kunta | int | The municipality associated with the row version. |
|---|
| nimi | string | The name of the row version. |
|---|
| nimi_se | string | The name of the row version in Swedish. |
|---|
| omistaja | string | The owner associated with the row version. |
|---|
| toimipiste | int | The location associated with the row version. |
|---|
| tunnus | int | The identifier of the row version. |
|---|
| geom_geojson | string | The geometry of the row version in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the row version in GeoText format. |
|---|
| geom_type | string | The type of geometry of the row version. |
|---|
| geom_centroid | string | The centroid point of the geometry of the row version. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geometry of the row version. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometry of the row version. |
|---|
| geom | binary | The geometry of the row version. |
|---|
