Version History of Helsinki Railway and Noise Areas - Source: Helsinki Urban Environment Sector, Finland
Click here for a data sample
The table contains the version history of a dataset sourced from the website of Helsingin kaupunkiympariston toimiala in Finland. It provides information on a specific data domain, with each row representing a version of the data extracted from the source. The table includes the '_start_date' column, indicating the date when each row was extracted, and the '_end_date' column, indicating the date when a new version of the row was extracted. If '_end_date' is null, it means that the row represents the most recent version of the data. The table contains various columns such as 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These columns provide different attributes and characteristics related to the dataset. Analysis of this data can be used to gain insights into the spatial attributes and changes over time, enabling data analytics and visualizations.
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. |
|---|
| id | int | The identifier of the row in the base table. |
|---|
| db_lo | float | Lower 32 bits of the hash value of the row version. |
|---|
| db_hi | float | Upper 32 bits of the hash value of the row version. |
|---|
| datanomist | string | The data scientist who updated the row version. |
|---|
| paivitetty | date | The date when the row version was last updated. |
|---|
| geom_geojson | string | The spatial information of the row version in GeoJSON format. |
|---|
| geom_geotext | string | The spatial information of the row version in Geotext format. |
|---|
| geom_type | string | The type of the spatial geometry of the row version. |
|---|
| geom_centroid | string | The centroid point of the spatial geometry of the row version. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the spatial geometry of the row version. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the spatial geometry of the row version. |
|---|
| geom | binary | The spatial geometry of the row version. |
|---|
