Helsinki Area Subarea Data
Click here for a data sample
This table contains data from 'Helsinki City Environment Sector' website. It provides information about different areas within Helsinki. The data originates from Finland (ISO country code: 'fi'). The table has various columns that store information such as the extraction date, row number, municipality name, district names, ID, code, geographical data, and more. These columns can be utilized for various data analytics purposes. For example, the 'peruspiiri' column can be used to analyze the basic districts within Helsinki, while the 'geom_type' column can be used to determine the type of geometry data stored in the 'geom' column. The 'kunta_nimi' and 'suurpiiri' columns can be utilized to analyze municipalities and major districts within Helsinki, respectively. The 'geom_centroid' column provides the centroid coordinates for the geographical areas described in the 'geom' column. Overall, this table provides valuable information for analyzing and understanding the areas within Helsinki, Finland.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data was extracted. |
|---|
| _row_number | long | The number of the row in the table. |
|---|
| kunta_nimi | string | The name of the municipality. |
|---|
| kunta_nim0 | string | An alternate name of the municipality. |
|---|
| suurpiiri | string | The name of the major district. |
|---|
| suurpiiri0 | string | An alternate name of the major district. |
|---|
| peruspiiri | string | The name of the basic district. |
|---|
| id | int | The unique identifier of the table row. |
|---|
| tunnus | int | An additional identifier for the table row. |
|---|
| peruspiir0 | int | An alternate name of the basic district. |
|---|
| suurpiiri1 | int | An additional name of the major district. |
|---|
| kunta | int | An additional name of the municipality. |
|---|
| nimi | string | The name of the district. |
|---|
| nimi_se | string | The name of the district in Swedish. |
|---|
| peruspiir1 | string | An additional name of the basic district. |
|---|
| geom_geojson | string | The geometrical representation of the district in GeoJSON format. |
|---|
| geom_geotext | string | The text representation of the geometrical information. |
|---|
| geom_type | string | The type of geometry of the district. |
|---|
| geom_centroid | string | The centroid of the district. |
|---|
| geom_center_x | double | The X coordinate of the center of the district. |
|---|
| geom_center_y | double | The Y coordinate of the center of the district. |
|---|
| geom | binary | The geometrical representation of the district. |
|---|
