Version History of Meluselvitys 2017 Alue 14 Maantiet L Yo Polygon

To download the data set, please sign up or log in

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_datedateThe start date of the validity period for the row version.
_end_datedateThe end date of the validity period for the row version.
_row_numberlongThe sequential number assigned to the row version.
idintThe unique identifier of the row.
db_lointThe lower boundary of the database version.
db_hiintThe higher boundary of the database version.
datanomiststringThe name of the data analyst.
paivitettystringThe date when the row version was last updated.
geom_geojsonstringThe geometry data of the row version in GeoJSON format.
geom_geotextstringThe geometry data of the row version in Geotext format.
geom_typestringThe type of geometry data in the row version.
geom_centroidstringThe centroid point of the geometry in the row version.
geom_center_xdoubleThe x-coordinate of the center point of the geometry in the row version.
geom_center_ydoubleThe y-coordinate of the center point of the geometry in the row version.
geombinaryThe spatial data of the row version.

No sample for this dataset

Additional Information

Last updated April 23, 2024
Created April 23, 2024
License No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapterdelta
Countryfi
Databasefi_helsingin_kaupunkiympariston_toimiala
Ida31e11aa-7891-413c-aafc-7c45605b8cb5
Package id2c6b3633-7ce8-41d9-88ed-2ceb431778fe
Position1
Revision id98d746c2-a5ed-46ce-8108-d78bff75b1ad
Stateactive
Tableavoindatameluselvitys_2017_alue_14_maantiet_l_yo__meluselvitys_2017_alue_14_maantiet_l_yopolygon__history