Tiekeperuspiiri Dataset Collection from Helsingin kaupunkiympäristön toimiala, Finland
Tables
-
Basic District Information in Helsinki, FinlandTSV
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.
-
Version History of Tiekeperuspiiri PeruspiiriTSV
This table, sourced from the website of 'Department of Urban Environment, City of Helsinki' in the country of Finland (ISO country code: 'fi'), represents the version history of the base table rows of 'tiekeperuspiiri__peruspiiri'. It contains additional columns '_start_date' and '_end_date' which store the extraction dates of each version. The table contains historical data related to 'gml_id', 'kunta', 'kunta_nimi', 'kunta_nim0', 'nimi', 'nimi_se', 'suurpiiri', 'suurpiiri0', 'suurpiiri1', 'tunnus', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. It also includes 'geom' column which stores geometric data. This table provides valuable information for data analysis and can be utilized, for example, to track the changes in geographical...
Column Descriptions
Basic District Information in Helsinki, Finland
Column | Type | Comment |
---|---|---|
_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. |
Version History of Tiekeperuspiiri Peruspiiri
Column | Type | Comment |
---|---|---|
_start_date | date | The start date of the validity period for the row version. |
_end_date | date | The end date of the validity period for the row version. |
_row_number | long | The unique row number identifier for the version history. |
gml_id | string | The GML identifier for the row. |
kunta | int | The municipality code. |
kunta_nimi | string | The name of the municipality. |
kunta_nim0 | string | An alternate name of the municipality. |
nimi | string | The name of the row. |
nimi_se | string | The name of the row in Swedish. |
suurpiiri | string | The administrative division code. |
suurpiiri0 | string | An alternate administrative division code. |
suurpiiri1 | int | An additional administrative division code. |
tunnus | int | The unique identifier for the row. |
geom_geojson | string | The geographic shape of the row in GeoJSON format. |
geom_geotext | string | The geographic shape of the row in Geotext format. |
geom_type | string | The type of geographic shape. |
geom_centroid | string | The centroid of the geographic shape. |
geom_center_x | double | The x-coordinate of the center of the geographic shape. |
geom_center_y | double | The y-coordinate of the center of the geographic shape. |
geom | binary | The original geographic shape data. |
Additional Info
Last Updated | September 13, 2024 |
---|---|
Created | October 22, 2018 |