Noise study 2017 - Tram traffic L_Aeq daily sound level in area 5 - Helsinki
Click here for a data sample
This table contains data from the dataset 'Helsinki City Environment Department' available on their website. The data originates from Finland, which has the ISO country code 'FI'. The table 'avoindatameluselvitys_2017_alue_05_raitioliikenne_l_aeq_paiva__meluselvitys_2017_alue_05_raitioliikenne_l_aeq_paivapolygon' includes information regarding noise surveys conducted in 2017 for areas related to tram traffic. The table consists of various columns such as '_extract_date', '_row_number', 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The data in this table could be utilized in data analytics to study the noise levels in different tram traffic areas, analyze the impact of noise on the surrounding environment, identify noise hotspots, and assess the effectiveness of noise mitigation strategies.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date and time when the data was extracted. |
|---|
| _row_number | long | The unique identifier for each row in the table. |
|---|
| id | int | The unique identifier for each record in the table. |
|---|
| db_lo | int | The lower bound value of the primary key. |
|---|
| db_hi | int | The upper bound value of the primary key. |
|---|
| datanomist | string | The name of the person or organization who provided the data. |
|---|
| paivitetty | string | The date and time when the record was last updated. |
|---|
| geom_geojson | string | The geometry of the record in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the record in textual format. |
|---|
| geom_type | string | The type of geometry. |
|---|
| geom_centroid | string | The centroid 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 geometry of the record. |
|---|
