History of Industrial Areas in Open Data Metropolitan Area Land Use Polygon Table - 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 '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_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 unique row number for identifying each row version.
maankayttostringThe land use information for the row version.
mtryhmintThe maintenance group for the row version.
geom_geojsonstringThe geometric information represented in GeoJSON format for the row version.
geom_geotextstringThe geometric information represented as text for the row version.
geom_typestringThe type of geometric object for the row version.
geom_centroidstringThe centroid of the geometric object for the row version.
geom_center_xdoubleThe X-coordinate of the center of the geometric object for the row version.
geom_center_ydoubleThe Y-coordinate of the center of the geometric object for the row version.
geombinaryThe geometric object for the row version.
tietopalveintThe information service for the row version.

No sample for this dataset

Additional Information

Last updated May 2, 2024
Created May 2, 2024
License No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapterdelta
Countryfi
Databasefi_helsingin_kaupunkiympariston_toimiala
Id1c0e60de-fe47-4533-a0ea-2da57a833407
Package id6dd83605-2562-48ed-b22d-7a707f8b1c23
Position1
Revision id8ba56172-7a8e-4b66-a3e4-4e93ab446abd
Stateactive
Tableavoindataseutukartta_maankaytto_teollisuusalueet__seutukartta_maankaytto_teollisuusalueetpolygon__history