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

Statistical Areas Dataset for Pornainen, Finland

The dataset collection 'seutukarttapornainen_tilastoalueet' consists of one or more dataset tables. The tables are sourced from the website of 'Helsinki City Environment Sector' in Finland.

Tables

  • Polygon Statistical Areas in Pornainen, FinlandTSV

    This table contains statistical data for the municipality areas in Pornainen. It provides information such as the extract date, row number, total area, municipality name, area size, status, name in Finnish and ISO name, group, geographic polygann as geojson, geographic polygann as geotext, geographic polygann type, centroid of the geographic polygann, center x-coordinate of the geographic polygann, center y-coordinate of the geographic polygann, and the full geographic polygann. The data in this table can be utilized for various data analytics tasks such as analyzing the distribution of municipal areas, calculating the size of different areas, comparing the status of different areas, visualizing geographic boundaries, and conducting spatial analysis. The table is sourced from the...

  • Version History of Area Statistics in Pornainen, FinlandTSV

    This table contains the version history of rows from the table 'seutukarttapornainen_tilastoalueet__pornainen_tilastoalueetpolygon'. The rows in this table represent the different versions of the base table rows, with each version having a corresponding '_start_date' and '_end_date' indicating the extraction dates. The base table provides various information such as 'kokotun', 'kunta', 'suur', 'tila', 'nimi', 'nimi_iso', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. This version history table can be utilized in data analytics by tracking changes and analyzing trends over time. For example, it can be used to identify when and how certain attributes of the base table rows have changed, monitor update frequencies, and...

Column Descriptions

Polygon Statistical Areas in Pornainen, Finland

Column Type Comment
_extract_date date The date when the row was extracted
_row_number long The row number in the table
kokotun int The size of the object
kunta int The municipality of the object
suur string The area of the object
tila int The status of the object
nimi string The name of the object
nimi_iso string The ISO name of the object
mtryhm int The object's main group
geom_geojson string The geometry in GeoJSON format
geom_geotext string The geometry in geotext format
geom_type string The type of geometry
geom_centroid string The centroid of the geometry
geom_center_x double The X-coordinate of the center of the geometry
geom_center_y double The Y-coordinate of the center of the geometry
geom binary The geometry

Version History of Area Statistics in Pornainen, Finland

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 assigned number of the row version.
kokotun int Description not available.
kunta int Description not available.
suur string Description not available.
tila int Description not available.
nimi string Description not available.
nimi_iso string Description not available.
mtryhm int Description not available.
geom_geojson string Description not available.
geom_geotext string Description not available.
geom_type string Description not available.
geom_centroid string Description not available.
geom_center_x double Description not available.
geom_center_y double Description not available.
geom binary Description not available.

Additional Info

Last Updated April 23, 2024
Created October 22, 2018