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

Paavo-postinumeroalueet (merialueille ulottuva)

Paavo-postinumeroalueet (merialueille ulottuva)

Tables

  • Pno Meri, Postialuepno MeriTSV

    Paavo - Open data by postal code area contain the following geographic data: 1) Paavo postal code areas 2) Paavo postal code areas (extended to sea areas) 3) Paavo statistical data (103 variables) combined with the postal code areas There are two different versions of the map data: extending to sea areas mainly produced for statistics production, and the version produced from this for map visualisation cut with the coastline. The map data contain the surface areas of the postal code areas and the municipality codes defined for the postal code areas. The statistical data contain data on the population structure, the degree of education, the income of the inhabitants and households, the size of house-holds and life stage, buildings and dwellings, workplaces, and the main ac-tivities...

  • Pno meripolygon, Postialuepno meri, Full historyTSV

    Paavo-postinumeroalueet (merialueille ulottuva)

  • Pno meripolygon, Postialuepno meri, LatestTSV

    Paavo-postinumeroalueet (merialueille ulottuva)

Column Descriptions

Pno Meri, Postialuepno Meri

Column Type Comment
objectid int Data source did not contain a description for objectid. Column objectid has 3030 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 3030.
posti_alue int Data source did not contain a description for posti_alue. Column posti_alue has 3030 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 100 and maximum value is 99990.
nimi string Data source did not contain a description for nimi. Column nimi has 3030 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aapajoki and maximum string is Kuusamo.
namn string Data source did not contain a description for namn. Column namn has 3030 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aapajoki and maximum string is Kuusamo.
kunta int Data source did not contain a description for kunta. Column kunta has 3030 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 992.
kuntanro int Data source did not contain a description for kuntanro. Column kuntanro has 3030 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 992.
vuosi int Data source did not contain a description for vuosi. Column vuosi has 3030 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2018.
pinta_ala int Data source did not contain a description for pinta_ala. Column pinta_ala has 3030 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 61422 and maximum value is 2147483647.
shape_leng float Data source did not contain a description for shape_leng. Column shape_leng has 3030 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1048.54 and maximum value is 776824.25.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 3030 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: MULTIPOLYGON (((21.281872... and first 25 characters of maximum string: POLYGON ((29.283833095136...
geom_center_x float Longitude of center. Column geom_center_x has 3030 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19.38 and maximum value is 31.34.
geom_center_y float Latitude of center. Column geom_center_y has 3030 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.67 and maximum value is 69.91.
geom_type string Geometry type. Column geom_type has 3030 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_MULTIPOLYGON and maximum string is ST_POLYGON.
orig_extractdate string The date when the data was originally fetched from the source.

Pno meripolygon, Postialuepno meri, Full history

Column Type Comment
objectid int Data source did not contain a description for objectid. Column objectid has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 3026.
posti_alue int Data source did not contain a description for posti_alue. Column posti_alue has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 100 and maximum value is 99990.
vuosi int Data source did not contain a description for vuosi. Column vuosi has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2020.
nimi string Data source did not contain a description for nimi. Column nimi has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aapajoki and maximum string is Nuorgam.
namn string Data source did not contain a description for namn. Column namn has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aapajoki and maximum string is Nuorgam.
kunta int Data source did not contain a description for kunta. Column kunta has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 992.
kuntanro int Data source did not contain a description for kuntanro. Column kuntanro has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 992.
pinta_ala int Data source did not contain a description for pinta_ala. Column pinta_ala has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 78367 and maximum value is 2147483647.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: MULTIPOLYGON (((21.674185... and first 25 characters of maximum string: POLYGON ((28.000762315770...
geom_center_x float Longitude of center. Column geom_center_x has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19.38 and maximum value is 31.34.
geom_center_y float Latitude of center. Column geom_center_y has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.67 and maximum value is 69.91.
geom_type string Geometry type. Column geom_type has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_MULTIPOLYGON and maximum string is ST_POLYGON.
orig_extractdate string The date when the data was originally fetched from the source.

Pno meripolygon, Postialuepno meri, Latest

Column Type Comment
objectid int Data source did not contain a description for objectid. Column objectid has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 3026.
posti_alue int Data source did not contain a description for posti_alue. Column posti_alue has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 100 and maximum value is 99990.
vuosi int Data source did not contain a description for vuosi. Column vuosi has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2020.
nimi string Data source did not contain a description for nimi. Column nimi has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aapajoki and maximum string is Nuorgam.
namn string Data source did not contain a description for namn. Column namn has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aapajoki and maximum string is Nuorgam.
kunta int Data source did not contain a description for kunta. Column kunta has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 992.
kuntanro int Data source did not contain a description for kuntanro. Column kuntanro has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 992.
pinta_ala int Data source did not contain a description for pinta_ala. Column pinta_ala has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 78367 and maximum value is 2147483647.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: MULTIPOLYGON (((21.674185... and first 25 characters of maximum string: POLYGON ((28.000762315770...
geom_center_x float Longitude of center. Column geom_center_x has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19.38 and maximum value is 31.34.
geom_center_y float Latitude of center. Column geom_center_y has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.67 and maximum value is 69.91.
geom_type string Geometry type. Column geom_type has 3026 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_MULTIPOLYGON and maximum string is ST_POLYGON.

Additional Info

Last Updated February 10, 2020
Created June 9, 2018