Noise Study 2017 Rail Traffic L Night - Helsinki City Environment Department
Click here for a data sample
This table contains data from the 'Helsinki City Environment Sector' website, which originates from the country Finland. It represents information from the 'avoindatameluselvitys_2017_alue_16_raitioliikenne_l_yo__meluselvitys_2017_alue_16_raitioliikenne_l_yopolygon' dataset. The table includes 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', 'geom_center_y', and 'geom'. This data can be utilized for various data analytics purposes such as analyzing noise levels related to nighttime public transportation routes in Helsinki. For example, the columns 'db_lo' and 'db_hi' provide information about the noise level range, while 'geom_geojson' and 'geom_geotext' contain the geometric data of the noise polygons. The 'datanomist' column indicates the data custodian and 'paivitetty' column represents the date of data update. The 'geom_centroid', 'geom_center_x' and 'geom_center_y' columns provide information about the centroid and center coordinates of the noise polygons. Overall, this table offers valuable insights for analyzing noise pollution and transportation patterns in Helsinki, Finland.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date and time when the data was extracted. |
|---|
| _row_number | long | The row number of the data entry. |
|---|
| id | int | The unique identifier of the record. |
|---|
| db_lo | int | The lower bound of the database index value. |
|---|
| db_hi | int | The upper bound of the database index value. |
|---|
| datanomist | string | The name of the data owner. |
|---|
| paivitetty | string | The date and time when the data was last updated. |
|---|
| geom_geojson | string | The geometry in GeoJSON format. |
|---|
| geom_geotext | string | The geometry in Geotext 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 spatial representation of the data. |
|---|
