Basic District Information in Helsinki, Finland
Click here for a data sample
This table contains data from Helsingin kaupunkiympariston toimiala, a website from Finland (ISO country code 'fi'). It includes various information such as extract date, row number, gml_id, municipality, municipality name, municipality name variant, name, name in Swedish, major district, major district variant 1, major district variant 2, identifier, geometry in GeoJSON format, geometry in Geotext format, geometry type, centroid of the geometry, center x-coordinate of the geometry, center y-coordinate of the geometry, and full geometry. This data can be utilized in data analytics for various purposes such as geographical analysis, municipality-level statistics, and spatial visualization.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data was extracted from the source system. |
|---|
| _row_number | long | The sequential number of the row in the table. |
|---|
| gml_id | string | The unique identifier of the record in GML format. |
|---|
| kunta | int | The code representing the municipality. |
|---|
| kunta_nimi | string | The name of the municipality. |
|---|
| kunta_nim0 | string | An alternative name of the municipality. |
|---|
| nimi | string | The name of the locality. |
|---|
| nimi_se | string | The Swedish name of the locality. |
|---|
| suurpiiri | string | The code representing the major region. |
|---|
| suurpiiri0 | string | An alternative code representing the major region. |
|---|
| suurpiiri1 | int | Another alternative code representing the major region. |
|---|
| tunnus | int | A unique identifier of the locality. |
|---|
| geom_geojson | string | The geometry of the locality in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the locality in geotext format. |
|---|
| geom_type | string | The type of geometry. |
|---|
| geom_centroid | string | The centroid of the locality's geometry. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the locality's geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the locality's geometry. |
|---|
| geom | binary | The spatial representation of the locality's geometry in WKT format. |
|---|
