Version History of Copyright Polygons for 'Helsinki City Environment Sector' from Finland
Click here for a data sample
This table contains the version history of the rows in the 'seutukarttacopyright__copyrightpolygon' table. The rows in this table represent different versions of the data extracted from the website of Helsingin kaupunkiympariston toimiala, which originates from the country 'Finland' (ISO country code: 'fi'). Each row in this table includes the '_start_date' column indicating the date when the version was extracted, and the '_end_date' column indicating the date when a new version was extracted. If the '_end_date' column is null, it means that the corresponding row is the most recent version. The table also includes additional columns such as 'copyright', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y' which provide data related to the copyright information and geometry of the polygons. This table can be utilized for various data analytics purposes, such as tracking changes in the copyright information over time or analyzing the spatial characteristics of the polygons.
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 assigned to each row version. |
copyright | string | The copyright information related to the row. |
geom_geojson | string | The geometry of the row in GeoJSON format. |
geom_geotext | string | The geometry of the row in geotext format. |
geom_type | string | The type of geometry used in the row. |
geom_centroid | string | The centroid of the geometry of the row. |
geom_center_x | double | The X-coordinate of the center of the geometry of the row. |
geom_center_y | double | The Y-coordinate of the center of the geometry of the row. |
geom | binary | The geometry of the row. |