Version History of Street and Road Noise Areas Data for Helsinki from Helsingin kaupunkiympariston toimiala in Finland
Click here for a data sample
This table represents the version history of the rows in the 'avoindatamelualueet_2017_01_kadut_maant_hki_laeq7_22_paiva_npm__melualueet_2017_01_kadut_maant_hki_laeq722_paiva_npmpolygon' table. It contains additional columns '_start_date' and '_end_date' which indicate the extraction dates of the rows from the data source. The data in this table is sourced from the website of 'Helsinki City Environment Sector', which originates from Finland (ISO country code 'fi'). The table can be used for data analytics purposes, such as analyzing the historical changes of noise areas in Helsinki's streets and roads 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 number assigned to the row version. |
|---|
| id | int | The unique identifier for the row version. |
|---|
| db_lo | float | The lower 32 bits of the database identifier. |
|---|
| db_hi | float | The higher 32 bits of the database identifier. |
|---|
| datanomist | string | The name of the data analyst who made the changes. |
|---|
| paivitetty | date | The date and time when the row version was last updated. |
|---|
| geom_geojson | string | The geometry data in GeoJSON format. |
|---|
| geom_geotext | string | The geometry data in geotext format. |
|---|
| geom_type | string | The type of geometry. |
|---|
| geom_centroid | string | The centroid coordinates 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 original geometry data. |
|---|
