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

Paavo-postinumeroalueet (merialueille ulottuva) 2020

Paavo-postinumeroalueet (merialueille ulottuva) 2020

Tables

Column Descriptions

Pno meri 2020polygon, Postialuepno meri 2020, 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.

Pno meri 2020polygon, Postialuepno meri 2020, 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.

Additional Info

Last Updated February 10, 2020
Created February 10, 2020