Version history of Metro Noise Study Polygon data in Helsinki, Finland
Click here for a data sample
This table contains the version history of the rows from the 'avoindatameluselvitys_2017_alue_08_metro_l_aeq_yo__meluselvitys_2017_alue_08_metro_l_aeq_yopolygon' table. The rows in this table represent different versions of the base table rows, which were extracted from the data source. The '_start_date' column indicates the date when each row was extracted, while the '_end_date' column indicates the date when a new version of the row was extracted. If the '_end_date' is null, it means that the row is the most recent version. The table is sourced from the website of 'Helsinki Urban Environment Division', which originates from Finland (ISO country code 'fi'). The table contains various columns including '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 can be utilized for data analytics purposes such as analyzing noise measurements and patterns in different areas, calculating noise levels at specific locations, and identifying areas with high noise pollution.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column indicates the start date of the validity period of the row version. |
|---|
| _end_date | date | This column indicates the end date of the validity period of the row version. |
|---|
| _row_number | long | This column represents the row number of the version history entry. |
|---|
| id | int | This column contains the unique identifier of the row version. |
|---|
| db_lo | int | This column stores the lower part of a double precision number. |
|---|
| db_hi | int | This column stores the higher part of a double precision number. |
|---|
| datanomist | string | This column contains information about the data analyst. |
|---|
| paivitetty | string | This column indicates the date of the last update. |
|---|
| geom_geojson | string | This column stores the geometry data in GeoJSON format. |
|---|
| geom_geotext | string | This column stores the geometry data in geotext format. |
|---|
| geom_type | string | This column indicates the type of the geometry data. |
|---|
| geom_centroid | string | This column stores the centroid of the geometry data. |
|---|
| geom_center_x | double | This column stores the x-coordinate of the center of the geometry data. |
|---|
| geom_center_y | double | This column stores the y-coordinate of the center of the geometry data. |
|---|
| geom | binary | This column stores the geometry data in a specific format. |
|---|
