Version history of railyard noise assessment polygons in area 16 in Helsinki (Nighttime)
Click here for a data sample
This table contains the version history of the 'avoindatameluselvitys_2017_alue_16_raitioliikenne_l_yo__meluselvitys_2017_alue_16_raitioliikenne_l_yopolygon' table. It is sourced from the website of 'Helsinki City Environment Sector' in Finland. The table consists of rows with additional columns '_start_date' and '_end_date', indicating the extraction dates of each row. The table can be utilized for data analytics purposes, such as studying the changes in noise assessment for nighttime public transportation routes. The various attributes in the table can be used to analyze the characteristics of the noise levels, track updates in data, and calculate centroids or center points of geometries. Analyzing this historical data can provide insights into noise patterns and support decision-making processes related to urban planning and transportation.
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 row number indicating the version history of the base table rows. |
|---|
| id | int | The unique identifier of the row. |
|---|
| db_lo | int | The lower bound of the database version. |
|---|
| db_hi | int | The upper bound of the database version. |
|---|
| datanomist | string | The person responsible for the data. |
|---|
| paivitetty | string | The date of the last update of the row. |
|---|
| geom_geojson | string | The geometry in GeoJSON format. |
|---|
| geom_geotext | string | The geometry in Geotext format. |
|---|
| geom_type | string | The type of the 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. |
|---|
