History of the Area 13 Road Noise Evaluation for the Year 2017 - Polygon Representation - Version History
Click here for a data sample
This table, sourced from the website of Helsingin kaupunkiympäristön toimiala, contains the version history of rows from the base table avoindatameluselvitys_2017_alue_13_maantiet_l_den__meluselvitys_2017_alue_13_maantiet_l_denpolygon. The table includes columns such as '_start_date', '_end_date', 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The '_start_date' column represents the date when a row was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted. If the '_end_date' value is null, it means that the row is the most recent version. The data in this table can be utilized for data analytics purposes, such as analyzing and tracking changes over time in the geographic data, identifying trends in updates by the 'datanomist' (data owner), or calculating geometric properties related to the 'geom_geojson' and 'geom_geotext' columns. The source of this data is from Helsingin kaupunkiympäristön toimiala, which is an organization in Finland (ISO country code 'fi').
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 or index of the table. |
|---|
| id | int | This column stores the unique identifier for each row in the table. |
|---|
| db_lo | int | This column is a part of a composite key that represents the lower bound value of the database identifier range. |
|---|
| db_hi | int | This column is a part of a composite key that represents the upper bound value of the database identifier range. |
|---|
| datanomist | string | This column stores information about the data scientist or person responsible for the data. |
|---|
| paivitetty | string | This column represents the date and time when the data was last updated. |
|---|
| 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 geometry data. |
|---|
| geom_centroid | string | This column stores the centroid coordinates of the geometry. |
|---|
| geom_center_x | double | This column represents the X coordinate of the center of the geometry. |
|---|
| geom_center_y | double | This column represents the Y coordinate of the center of the geometry. |
|---|
| geom | binary | This column stores the geometry data in a specific format. |
|---|
