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