General or Other Area - General or Other Area Polygon
Click here for a data sample
This table contains data from the Helsinki City Environment Sector website. It provides information about general or other areas in the form of polygons. The data includes various attributes such as '_extract_date', '_row_number', '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'. These attributes can be utilized in various data analytics tasks such as estimating the efficiency of different areas, analyzing the distribution of building types, calculating the total area covered by specific features, determining the number of floors in buildings, studying additional information related to the areas, and obtaining geometrical characteristics like centroid and center coordinates. The data in this table is sourced from the Helsingin kaupunkiympariston toimiala website and originates from Finland (ISO country code 'fi').
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date on which the data was extracted. |
|---|
| _row_number | long | The row number of the record in the database table. |
|---|
| gid | int | The unique identifier for each record in the table. |
|---|
| yleinen_ta | string | The general name or description of the column. |
|---|
| kayttotark | string | The designated usage or purpose for the property. |
|---|
| tyyppi | string | The type or category of the property. |
|---|
| maanalaine | boolean | Specifies whether the property is located underground. |
|---|
| tehokkuusl | string | The efficiency level of the property. |
|---|
| kaavamerki | string | The symbol or code that represents the property on a plan or map. |
|---|
| km2 | int | The area of the property in square kilometers. |
|---|
| lisakm2 | string | Additional area of the property in square kilometers. |
|---|
| lisakm2riv | boolean | Additional area of the property in square kilometers in riv. |
|---|
| yhteensakm | string | The total area of the property, including additional areas. |
|---|
| kellari | string | Specifies whether the property has a basement. |
|---|
| kerrosluku | string | The number of floors in the building. |
|---|
| ullakko | string | Specifies whether the property has an attic. |
|---|
| korttelinn | string | The block number of the property. |
|---|
| knumerokar | boolean | The parcel number of the property. |
|---|
| pintaala | float | The surface area of the property. |
|---|
| lisatietoj | string | Additional information about the property. |
|---|
| lisakm2kuv | string | Additional area of the property in square kilometers as an image. |
|---|
| yhtluontip | string | The date and time the property record was created. |
|---|
| yhtmuokkau | string | The date and time the property record was last modified. |
|---|
| yhtdatanom | string | The date and time the property record was last updated in the database. |
|---|
| asemakaava | string | Specifies whether the property is part of a detailed plan. |
|---|
| geom_geojson | string | The geometry of the property in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the property in geotext format. |
|---|
| geom_type | string | The type of geometry for the property. |
|---|
| geom_centroid | string | The centroid or center point of the property geometry. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the property geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the property geometry. |
|---|
| geom | binary | The geometry of the property. |
|---|
