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

Paavo-postinumeroalueet 2017

Paavo-postinumeroalueet 2017

Tables

  • Pno 2017, Postialuepno 2017, Full historyTSV

    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 2017, Postialuepno 2017, LatestTSV

    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...

Column Descriptions

Pno 2017, Postialuepno 2017, Latest

Column Type Comment
objectid int Data source did not contain a description for objectid. Column objectid has 3036 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 3036.
posti_alue int Data source did not contain a description for posti_alue. Column posti_alue has 3036 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 3036 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 Hyvinkää Keskus.
namn string Data source did not contain a description for namn. Column namn has 3036 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 Hyvinge centrum.
kunta int Data source did not contain a description for kunta. Column kunta has 3036 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 3036 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 3036 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2017.
pinta_ala int Data source did not contain a description for pinta_ala. Column pinta_ala has 3036 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.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 3036 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 (((19.575350... and first 25 characters of maximum string: MULTIPOLYGON (((24.867263...
geom_center_x float Longitude of center. Column geom_center_x has 3036 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19.58 and maximum value is 31.34.
geom_center_y float Latitude of center. Column geom_center_y has 3036 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.80 and maximum value is 69.91.
geom_type string Geometry type. Column geom_type has 3036 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.

Pno 2017, Postialuepno 2017, Full history

Column Type Comment
objectid int Data source did not contain a description for objectid. Column objectid has 3036 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 3036.
posti_alue int Data source did not contain a description for posti_alue. Column posti_alue has 3036 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 3036 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 Hyvinkää Keskus.
namn string Data source did not contain a description for namn. Column namn has 3036 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 Hyvinge centrum.
kunta int Data source did not contain a description for kunta. Column kunta has 3036 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 3036 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 3036 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2017.
pinta_ala int Data source did not contain a description for pinta_ala. Column pinta_ala has 3036 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.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 3036 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 (((19.575350... and first 25 characters of maximum string: MULTIPOLYGON (((24.867263...
geom_center_x float Longitude of center. Column geom_center_x has 3036 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19.58 and maximum value is 31.34.
geom_center_y float Latitude of center. Column geom_center_y has 3036 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.80 and maximum value is 69.91.
geom_type string Geometry type. Column geom_type has 3036 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.

Additional Info

Last Updated February 10, 2020
Created September 7, 2018