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

Pääkaupunkiseudun postinumeroalueet

Pääkaupunkiseudun postinumeroalueet

Tables

Column Descriptions

Postinumeroalueet, Helpostinumeroalueet, Latest

Column Type Comment
posno int Data source did not contain a description for posno. Column posno has 172 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 4320.
toimip string Data source did not contain a description for toimip. Column toimip has 172 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ESPOO and maximum string is VANTAA.
toimip_ru string Data source did not contain a description for toimip_ru. Column toimip_ru has 172 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ESBO and maximum string is VANDA.
nimi string Data source did not contain a description for nimi. Column nimi has 172 rows, out of which 1 are empty, making the null percent 0.58. Minimum string is and maximum string is Ylästö.
nimi_ru string Data source did not contain a description for nimi_ru. Column nimi_ru has 172 rows, out of which 1 are empty, making the null percent 0.58. Minimum string is and maximum string is Övitsböle.
kunta string Data source did not contain a description for kunta. Column kunta has 172 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Espoo and maximum string is Vantaa.
kunta_nro int Data source did not contain a description for kunta_nro. Column kunta_nro has 172 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 49 and maximum value is 543.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 172 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 (((24.681276... and first 25 characters of maximum string: POLYGON ((25.195652564801...
geom_center_x float Longitude of center. Column geom_center_x has 172 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.52 and maximum value is 25.19.
geom_center_y float Latitude of center. Column geom_center_y has 172 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.02 and maximum value is 60.37.
geom_type string Geometry type. Column geom_type has 172 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.

Postinumeroalueet, Helpostinumeroalueet, Full history

Column Type Comment
posno int Data source did not contain a description for posno. Column posno has 172 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 4320.
toimip string Data source did not contain a description for toimip. Column toimip has 172 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ESPOO and maximum string is VANTAA.
toimip_ru string Data source did not contain a description for toimip_ru. Column toimip_ru has 172 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ESBO and maximum string is VANDA.
nimi string Data source did not contain a description for nimi. Column nimi has 172 rows, out of which 1 are empty, making the null percent 0.58. Minimum string is and maximum string is Ylästö.
nimi_ru string Data source did not contain a description for nimi_ru. Column nimi_ru has 172 rows, out of which 1 are empty, making the null percent 0.58. Minimum string is and maximum string is Övitsböle.
kunta string Data source did not contain a description for kunta. Column kunta has 172 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Espoo and maximum string is Vantaa.
kunta_nro int Data source did not contain a description for kunta_nro. Column kunta_nro has 172 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 49 and maximum value is 543.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 172 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 (((24.681276... and first 25 characters of maximum string: POLYGON ((25.195652564801...
geom_center_x float Longitude of center. Column geom_center_x has 172 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.52 and maximum value is 25.19.
geom_center_y float Latitude of center. Column geom_center_y has 172 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.02 and maximum value is 60.37.
geom_type string Geometry type. Column geom_type has 172 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 September 7, 2020
Created September 7, 2020