To download the data set, please sign up or log in

Tiekeperuspiiri Dataset Collection from Helsingin kaupunkiympäristön toimiala, Finland

The 'tiekeperuspiiri' dataset collection consists of one or more dataset tables sourced from the website of 'Helsinki City Environment Sector' in 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