Version History of Test Test Rows from Helsingin kaupunkiympariston toimiala (Finland)
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_date | date | The start date of the validity period of the row version. |
_end_date | date | The end date of the validity period of the row version. |
_row_number | long | The unique identifier of the row version. |
geom_geojson | string | The geometry of the row version in GeoJSON format. |
geom_geotext | string | The geometry of the row version in GeoText format. |
geom_type | string | The type of geometry for the row version. |
geom_centroid | string | The centroid of the geometry for the row version. |
geom_center_x | double | The x-coordinate of the center point of the geometry for the row version. |
geom_center_y | double | The y-coordinate of the center point of the geometry for the row version. |
geom | binary | The geometry of the row version. |