Urban Development Areas - Polygon Data
Click here for a data sample
The table avoindatakorttelialue__korttelialuepolygon contains data sourced from the website of 'Helsinki City Environment Sector' in Finland. It includes various attributes such as '_extract_date', '_row_number', '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', 'geom_center_y', and 'geom'. These attributes can be analyzed to gain insights into urban planning, land usage, building characteristics, and other related areas in Helsinki city.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data was extracted. |
|---|
| _row_number | long | The unique identifier for each row in the table. |
|---|
| gid | int | The unique identifier for each record in the table. |
|---|
| korttelial | string | The block/square area in which the property is located. |
|---|
| kayttotark | string | The designated use or purpose of the property. |
|---|
| tyyppi | string | The type of the property (e.g. residential, commercial, etc.). |
|---|
| maanalaine | boolean | Indicator for whether the property has an underground structure. |
|---|
| tehokkuusl | float | The floor-area ratio for the property. |
|---|
| kaavamerki | string | The zoning mark or symbol used in the city's zoning plan. |
|---|
| km2 | int | The total area of the property in square kilometers. |
|---|
| lisakm2 | string | Additional area in square kilometers for the property. |
|---|
| lisakm2riv | boolean | Additional area in square kilometers for the property (record-specific value). |
|---|
| yhteensakm | string | The combined area of the property including additional areas. |
|---|
| kellari | string | Indicator for whether the property has a basement. |
|---|
| kerrosluku | int | The number of floors in the building. |
|---|
| ullakko | string | Indicator for whether the property has an attic. |
|---|
| korttelinn | int | The block/increment number of the property. |
|---|
| knumerokar | boolean | The street address number of the property. |
|---|
| pintaala | float | The total area of the property in square meters. |
|---|
| lisatietoj | string | Additional information about the property. |
|---|
| lisakm2kuv | string | Additional area in square kilometers for the property (visualized value). |
|---|
| yhtluontip | string | The date of creation for the record. |
|---|
| yhtmuokkau | string | The date of the last modification for the record. |
|---|
| yhtdatanom | string | Indicator for whether the record is currently being edited. |
|---|
| asemakaava | string | The zoning plan designation for the property. |
|---|
| geom_geojson | string | The geometry of the property in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the property in well-known text format. |
|---|
| geom_type | string | The type of the geometry (e.g. point, polygon, etc.). |
|---|
| geom_centroid | string | The centroid point of the property's geometry. |
|---|
| geom_center_x | double | The x-coordinate of the centroid point of the property's geometry. |
|---|
| geom_center_y | double | The y-coordinate of the centroid point of the property's geometry. |
|---|
| geom | binary | The spatial representation of the property's geometry. |
|---|
