Version History of General or Other Area Polygons for Helsingin kaupunkiympariston toimiala (Finland)
Click here for a data sample
This table contains the version history of the 'avoindatayleinen_tai_muu_alue__yleinen_tai_muu_aluepolygon' table sourced from the website of 'Helsinki City environment sector' in Finland. The table includes additional columns '_start_date' and '_end_date' which represent the extraction dates of each row. The table consists of various columns that store information such as 'gid', 'yleinen_ta', 'kayttotark', 'tyyppi', 'maanalaine', 'tehokkuusl', 'kaavamerki', 'km2', 'lisakm2', 'lisakm2riv', 'yhteensakm', 'kellari', 'kerrosluku', 'ullakko', 'korttelinn', 'knumerokar', 'pintaala', 'lisatietoj', 'lisakm2kuv', 'yhtluontip', 'yhtmuokkau', 'yhtdatanom', 'asemakaava', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This table provides a valuable resource for data analytics by allowing analysts to track the changes in the base table over time and perform historical analysis on various attributes. For example, it enables the analysis of changes in land use, building types, efficiency ratings, floor area, additional area, and more. With this data, users can gain insights into the development and transformation of areas in Helsinki City, Finland.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The validity start date of the row version. |
|---|
| _end_date | date | The validity end date of the row version. |
|---|
| _row_number | long | The row number in the version history table. |
|---|
| gid | int | The globally unique identifier of the row. |
|---|
| yleinen_ta | string | The general description of the table. |
|---|
| kayttotark | string | The designated use of the table. |
|---|
| tyyppi | string | The type of the table. |
|---|
| maanalaine | boolean | Indicates if the table is underground or not. |
|---|
| tehokkuusl | string | The efficiency level of the table. |
|---|
| kaavamerki | string | The mark symbolizing the table. |
|---|
| km2 | int | The area in square kilometers. |
|---|
| lisakm2 | string | The additional area in square kilometers. |
|---|
| lisakm2riv | boolean | The additional area in square kilometers for a specific row. |
|---|
| yhteensakm | string | The total area in square kilometers. |
|---|
| kellari | string | Indicates if the table has a basement or not. |
|---|
| kerrosluku | string | The number of floors in the table. |
|---|
| ullakko | string | Indicates if the table has an attic or not. |
|---|
| korttelinn | string | The block number of the table. |
|---|
| knumerokar | boolean | The street address number of the table. |
|---|
| pintaala | float | The surface area of the table. |
|---|
| lisatietoj | string | Additional information about the table. |
|---|
| lisakm2kuv | string | The additional area in square kilometers visualized. |
|---|
| yhtluontip | string | The creation date of the whole data. |
|---|
| yhtmuokkau | string | The modification date of the whole data. |
|---|
| yhtdatanom | string | The date the whole data became official. |
|---|
| asemakaava | string | The zoning plan for the table. |
|---|
| geom_geojson | string | The geometry in GeoJSON format. |
|---|
| geom_geotext | string | The geometry in plain text. |
|---|
| geom_type | string | The type of the geometry. |
|---|
| geom_centroid | string | The centroid of the geometry. |
|---|
| geom_center_x | double | The X coordinate of the center point of the geometry. |
|---|
| geom_center_y | double | The Y coordinate of the center point of the geometry. |
|---|
| geom | binary | The geometry data. |
|---|
