Version History of Area 05 Noise Study - Rail Traffic in Helsinki - 2007
Click here for a data sample
This table, sourced from the website of the Helsinki City Environment Sector, contains the version history of rows from the table 'avoindatameluselvitys_2007_alue_05_raideliikenne_l_den__meluselvitys_2007_alue_05_raideliikenne_l_denpolygon'. It has additional columns '_start_date' and '_end_date' to track the extraction dates of each row. The data in this table can be used for various data analytics purposes. For example, it can be utilized to analyze the changes in the 'geom_geojson' and 'geom_geotext' columns over time, providing insights into the geographical aspects of noise studies related to rail transportation. Moreover, the 'tietopalve' column can be used to determine the data service responsible for providing the information, while the 'paivitetty' column can help identify when the data was last updated. Overall, this table provides valuable historical information for conducting comprehensive data analysis tasks in the field of urban environmental studies. The table originates from Finland (ISO country code 'fi').
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column indicates the start date of the validity period for the row version. |
|---|
| _end_date | date | This column indicates the end date of the validity period for the row version. |
|---|
| _row_number | long | This column represents the row number of the version in the history table. |
|---|
| tietopalve | int | This column stores the tietopalve information associated with the row version. |
|---|
| db_lo | int | This column holds the db_lo value for the row version. |
|---|
| db_hi | int | This column stores the db_hi value for the row version. |
|---|
| datanomist | string | This column contains the information of the datanomist associated with the row version. |
|---|
| paivitetty | string | This column represents the date when the row version was last updated. |
|---|
| geom_geojson | string | This column holds the geometrical data in JSON format for the row version. |
|---|
| geom_geotext | string | This column stores the geometrical data in geotext format for the row version. |
|---|
| geom_type | string | This column indicates the type of the geometry for the row version. |
|---|
| geom_centroid | string | This column represents the centroid of the geometry for the row version. |
|---|
| geom_center_x | double | This column stores the X-coordinate of the center of the geometry for the row version. |
|---|
| geom_center_y | double | This column holds the Y-coordinate of the center of the geometry for the row version. |
|---|
| geom | binary | This column contains the geometrical data for the row version. |
|---|
