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

Pääkaupunkiseudun pienaluejako

Pääkaupunkiseudun pienaluejako

Tables

Column Descriptions

Seutu pienalueetpolygon, Seutukarttaseutu pienalueet, Latest

Column Type Comment
kokotun int Data source did not contain a description for kokotun. Column kokotun has 824 rows, out of which 417 are empty, making the null percent 50.61. Minimum value is 491011111 and maximum value is 1868025000.
kunta int Data source did not contain a description for kunta. Column kunta has 824 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 927.
suur int Data source did not contain a description for suur. Column suur has 824 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 9.
tila int Data source did not contain a description for tila. Column tila has 824 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 905.
pien int Data source did not contain a description for pien. Column pien has 824 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 70502.
nimi string Data source did not contain a description for nimi. Column nimi has 824 rows, out of which 179 are empty, making the null percent 21.72. Minimum string is and maximum string is Överby.
nimi_iso string Data source did not contain a description for nimi_iso. Column nimi_iso has 824 rows, out of which 34 are empty, making the null percent 4.13. Minimum string is and maximum string is ÖVERBY.
mtryhm int Data source did not contain a description for mtryhm. Column mtryhm has 824 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 50.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 824 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.937906... and first 25 characters of maximum string: POLYGON ((25.482280952863...
geom_center_x float Longitude of center. Column geom_center_x has 824 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.19 and maximum value is 25.48.
geom_center_y float Latitude of center. Column geom_center_y has 824 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.90 and maximum value is 60.81.
geom_type string Geometry type. Column geom_type has 824 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.

Seutu pienalueetpolygon, Seutukarttaseutu pienalueet, Full history

Column Type Comment
kokotun int Data source did not contain a description for kokotun. Column kokotun has 824 rows, out of which 417 are empty, making the null percent 50.61. Minimum value is 491011111 and maximum value is 1868025000.
kunta int Data source did not contain a description for kunta. Column kunta has 824 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 927.
suur int Data source did not contain a description for suur. Column suur has 824 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 9.
tila int Data source did not contain a description for tila. Column tila has 824 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 905.
pien int Data source did not contain a description for pien. Column pien has 824 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 70502.
nimi string Data source did not contain a description for nimi. Column nimi has 824 rows, out of which 179 are empty, making the null percent 21.72. Minimum string is and maximum string is Överby.
nimi_iso string Data source did not contain a description for nimi_iso. Column nimi_iso has 824 rows, out of which 34 are empty, making the null percent 4.13. Minimum string is and maximum string is ÖVERBY.
mtryhm int Data source did not contain a description for mtryhm. Column mtryhm has 824 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 50.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 824 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.937906... and first 25 characters of maximum string: POLYGON ((25.482280952863...
geom_center_x float Longitude of center. Column geom_center_x has 824 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.19 and maximum value is 25.48.
geom_center_y float Latitude of center. Column geom_center_y has 824 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.90 and maximum value is 60.81.
geom_type string Geometry type. Column geom_type has 824 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