History of Industrial Areas in Open Data Metropolitan Area Land Use Polygon Table - Helsingin kaupunkiympariston toimiala (Finland)
Click here for a data sample
This table contains the version history of the 'seutukartta_maankaytto_teollisuusalueetpolygon' base table. The rows in this table represent different versions of the base table's rows, with each version having a start date and an end date. The '_start_date' column stores the date when the row was extracted from the data source, while the '_end_date' column stores the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it indicates that the row is the most recent version. The table includes additional columns such as '_row_number', 'maankaytto', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom', and 'tietopalve'. The data in this table can be utilized for various data analytics purposes. For example, it can be used to analyze the historical changes in industrial areas ('maankaytto') and their classifications ('mtryhm'). The geographic information stored in the 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom' columns can be used to perform spatial analysis and visualization. The '_row_number' column can be used to keep track of the row version numbers. This data is sourced from the website of the 'Helsinki City Environment Sector' in Finland (ISO country code: FI).
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 unique row number for identifying each row version. |
maankaytto | string | The land use information for the row version. |
mtryhm | int | The maintenance group for the row version. |
geom_geojson | string | The geometric information represented in GeoJSON format for the row version. |
geom_geotext | string | The geometric information represented as text for the row version. |
geom_type | string | The type of geometric object for the row version. |
geom_centroid | string | The centroid of the geometric object for the row version. |
geom_center_x | double | The X-coordinate of the center of the geometric object for the row version. |
geom_center_y | double | The Y-coordinate of the center of the geometric object for the row version. |
geom | binary | The geometric object for the row version. |
tietopalve | int | The information service for the row version. |