Version history of Street Noise Areas in Helsinki, Finland
Click here for a data sample
This table contains the version history of the 'avoindatamelualueet_2017_12_kadut_maant_hki_lyo__melualueet_2017_12_kadut_maant_hki_lyopolygon' table. It provides information about the different versions of rows extracted from the data source. The table includes columns such as '_start_date', '_end_date', '_row_number', 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. The '_start_date' column represents the date when a row was extracted, while '_end_date' denotes the date when a new version of the row was obtained. If the '_end_date' value is null, it means the row is the most recent version. The data in this table can be utilized for data analytics purposes, such as monitoring changes in geographical boundaries or analyzing data ownership and update frequency. The table is sourced from the website of 'Helsinki City Environment Sector' and originates from Finland (ISO country code 'fi').
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | Indicates the start date of the validity period for the row version. |
|---|
| _end_date | date | Indicates the end date of the validity period for the row version. |
|---|
| _row_number | long | Represents the row number of the version in the table. |
|---|
| id | int | Unique identifier for each row in the table. |
|---|
| db_lo | float | Low-order bits of the database identifier. |
|---|
| db_hi | float | High-order bits of the database identifier. |
|---|
| datanomist | string | The data source responsible for the row version. |
|---|
| paivitetty | date | Timestamp indicating when the row version was last updated. |
|---|
| geom_geojson | string | Geometric representation of the version using GeoJSON format. |
|---|
| geom_geotext | string | Textual representation of the version's geometry. |
|---|
| geom_type | string | Indicates the type of geometry for the version. |
|---|
| geom_centroid | string | The centroid coordinates of the version's geometry. |
|---|
| geom_center_x | double | X-coordinate of the center point of the version's geometry. |
|---|
| geom_center_y | double | Y-coordinate of the center point of the version's geometry. |
|---|
| geom | binary | The binary representation of the version's geometry. |
|---|
