Version History of Test Test Rows from Helsingin kaupunkiympariston toimiala (Finland)

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 'testtesttest' table sourced from the website of 'Helsingin kaupunkiympariston toimiala' in Finland. The table includes various columns such as '_start_date', '_end_date', '_row_number', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The '_start_date' column represents the date when the row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row was extracted. If the '_end_date' value is null, it indicates that the row is the most recent version. This table can be used in data analytics to analyze the changes in the geographic information, such as the centroid and type of geometry, over time. By comparing different versions of the rows, one can examine the evolution of data and assess trends and patterns related to the spatial data. The historic records in this table can provide insights into the modifications made to the original 'testtesttest' table and enable a detailed analysis of the geospatial data for various purposes.

Field Descriptions

Name Data type Description
_start_datedateThe start date of the validity period of the row version.
_end_datedateThe end date of the validity period of the row version.
_row_numberlongThe unique identifier of the row version.
geom_geojsonstringThe geometry of the row version in GeoJSON format.
geom_geotextstringThe geometry of the row version in GeoText format.
geom_typestringThe type of geometry for the row version.
geom_centroidstringThe centroid of the geometry for the row version.
geom_center_xdoubleThe x-coordinate of the center point of the geometry for the row version.
geom_center_ydoubleThe y-coordinate of the center point of the geometry for the row version.
geombinaryThe geometry of the row version.

No sample for this dataset

Additional Information

Last updated April 24, 2024
Created April 24, 2024
License No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapterdelta
Countryfi
Databasefi_helsingin_kaupunkiympariston_toimiala
Id42355935-408a-496f-abd6-690acb7a1101
Package id8ba7af57-70af-4811-8d5c-ef270186d842
Position1
Revision id0bff68d9-28aa-4812-a350-a3baaab852b7
Stateactive
Tabletesttest__test__history