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

Pornainen tilastoalueet

Pornainen tilastoalueet

Tables

Column Descriptions

Pornainen tilastoalueetpolygon, Seutukarttapornainen tilastoalueet, Full history

Column Type Comment
kokotun int Data source did not contain a description for kokotun. Column is empty.
kunta int Data source did not contain a description for kunta. Column kunta has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 611.
suur string Data source did not contain a description for suur. Column is empty.
tila int Data source did not contain a description for tila. Column tila has 10 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 905.
nimi string Data source did not contain a description for nimi. Column nimi has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Halkia and maximum string is Vähä-Laukkoski.
nimi_iso string Data source did not contain a description for nimi_iso. Column nimi_iso has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is HALKIA and maximum string is VÄHÄ-LAUKKOSKI.
mtryhm int Data source did not contain a description for mtryhm. Column mtryhm has 10 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 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POLYGON ((25.272332662563... and first 25 characters of maximum string: POLYGON ((25.482280952863...
geom_center_x float Longitude of center. Column geom_center_x has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 25.24 and maximum value is 25.45.
geom_center_y float Latitude of center. Column geom_center_y has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.43 and maximum value is 60.53.
geom_type string Geometry type. Column geom_type has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POLYGON.
orig_extractdate string The date when the data was originally fetched from the source.

Pornainen tilastoalueetpolygon, Seutukarttapornainen tilastoalueet, Latest

Column Type Comment
kokotun int Data source did not contain a description for kokotun. Column is empty.
kunta int Data source did not contain a description for kunta. Column kunta has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 611.
suur string Data source did not contain a description for suur. Column is empty.
tila int Data source did not contain a description for tila. Column tila has 10 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 905.
nimi string Data source did not contain a description for nimi. Column nimi has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Halkia and maximum string is Vähä-Laukkoski.
nimi_iso string Data source did not contain a description for nimi_iso. Column nimi_iso has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is HALKIA and maximum string is VÄHÄ-LAUKKOSKI.
mtryhm int Data source did not contain a description for mtryhm. Column mtryhm has 10 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 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POLYGON ((25.272332662563... and first 25 characters of maximum string: POLYGON ((25.482280952863...
geom_center_x float Longitude of center. Column geom_center_x has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 25.24 and maximum value is 25.45.
geom_center_y float Latitude of center. Column geom_center_y has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.43 and maximum value is 60.53.
geom_type string Geometry type. Column geom_type has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POLYGON.

Additional Info

Last Updated September 7, 2020
Created September 7, 2020