Version History of Neighborhood Polygon Area in Helsinki, Finland
Click here for a data sample
This table contains the version history of the rows from the base table 'avoindatakorttelialue__korttelialuepolygon'. It has additional columns '_start_date' and '_end_date' that indicate the extraction dates of each row. The data in this table is sourced from the website of 'City of Helsinki Urban Environment Division' in Finland (ISO country code: 'fi'). The table provides historical information about various attributes such as 'gid', 'korttelial', '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 data can be utilized for data analytics purposes, such as analyzing changes in building structures over time, identifying trends in land usage, assessing efficiency levels, and examining added or modified areas of buildings.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | Indicates the start date of the validity period for the row version. |
|---|
| _end_date | date | Indicates the end date of the validity period for the row version. |
|---|
| _row_number | long | A unique identifier for each row version. |
|---|
| gid | int | A unique identifier for each row in the table. |
|---|
| korttelial | string | The identifier for a city block. |
|---|
| kayttotark | string | The designated use of the area. |
|---|
| tyyppi | string | The type or category of the area. |
|---|
| maanalaine | boolean | Indicates if the area is located underground. |
|---|
| tehokkuusl | float | The permitted building ratio for the area. |
|---|
| kaavamerki | string | The symbol representing the area on a map. |
|---|
| km2 | int | The area in square kilometers. |
|---|
| lisakm2 | string | Additional area in square kilometers. |
|---|
| lisakm2riv | boolean | Additional area in square kilometers for a specific row version. |
|---|
| yhteensakm | string | The total area in square kilometers. |
|---|
| kellari | string | Indicates if there is a basement in the building. |
|---|
| kerrosluku | int | The number of floors in the building. |
|---|
| ullakko | string | Indicates if there is an attic in the building. |
|---|
| korttelinn | int | The block number within a city. |
|---|
| knumerokar | boolean | The number of the building. |
|---|
| pintaala | float | The surface area of the building. |
|---|
| lisatietoj | string | Additional information about the area or building. |
|---|
| lisakm2kuv | string | Additional area in square kilometers represented on a map. |
|---|
| yhtluontip | string | The date of creation of the row version. |
|---|
| yhtmuokkau | string | The date of modification of the row version. |
|---|
| yhtdatanom | string | The person who requested the row version. |
|---|
| asemakaava | string | The master plan for the area. |
|---|
| geom_geojson | string | The geometry of the area in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the area in geotext format. |
|---|
| geom_type | string | The type of geometry for the area. |
|---|
| geom_centroid | string | The centroid of the area geometry. |
|---|
| geom_center_x | double | The x-coordinate of the center of the area geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center of the area geometry. |
|---|
| geom | binary | The geometry of the area. |
|---|
