Version History of Meluselvitys 2017 Alue 14 Maantiet L Yo Polygon
Click here for a data sample
This table contains the version history of the rows in the 'avoindatameluselvitys_2017_alue_14_maantiet_l_yo__meluselvitys_2017_alue_14_maantiet_l_yopolygon' table. The rows in this table represent different versions of the base table rows, each extracted from the data source on a specific date. The columns of this table include '_start_date' which indicates the date when the row was extracted, and '_end_date' which indicates the date when a new version of the row was extracted. If the value of '_end_date' is null, it means that the row is the most recent version. The remaining columns in this table contain various attributes related to the data, such as 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These columns store information about the data source, data quality, and the geometry of the features. This table is sourced from the website of 'Helsinki City Environment Sector' in Finland (ISO country code 'fi'). The historical data in this table can be utilized in data analytics for various purposes, such as tracking changes over time, analyzing patterns and trends, identifying outliers, and conducting spatial analysis.
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 sequential number assigned to the row version. |
id | int | The unique identifier of the row. |
db_lo | int | The lower boundary of the database version. |
db_hi | int | The higher boundary of the database version. |
datanomist | string | The name of the data analyst. |
paivitetty | string | The date when the row version was last updated. |
geom_geojson | string | The geometry data of the row version in GeoJSON format. |
geom_geotext | string | The geometry data of the row version in Geotext format. |
geom_type | string | The type of geometry data in the row version. |
geom_centroid | string | The centroid point of the geometry in the row version. |
geom_center_x | double | The x-coordinate of the center point of the geometry in the row version. |
geom_center_y | double | The y-coordinate of the center point of the geometry in the row version. |
geom | binary | The spatial data of the row version. |