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

Maankäyttö:Kantakartta:Hallintoalue

Maankäyttö:Kantakartta:Hallintoalue

Tables

Column Descriptions

Hallintoalue, Kantahallintoalue, Latest

Column Type Comment
gml_id string Data source did not contain a description for gml_id. Column gml_id has 5653 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Hallintoalue.10009195 and maximum string is Hallintoalue.9992669.
kplkoodi int Data source did not contain a description for kplkoodi. Column kplkoodi has 5653 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 501300 and maximum value is 501360.
sijaintiepavarmuus int Data source did not contain a description for sijaintiepavarmuus. Column sijaintiepavarmuus has 5653 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 5.
luontitapa string Data source did not contain a description for luontitapa. Column luontitapa has 5653 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: maastomittaus.
alkupvm timestamp Data source did not contain a description for alkuPvm. Column alkupvm has 5653 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1997-10-24 09:12:03 and maximum value is 2020-09-08 11:11:10.
ilmentymaelementinnimi string Data source did not contain a description for ilmentymaElementinNimi. Column ilmentymaelementinnimi has 5653 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: nimi.
suunta int Data source did not contain a description for suunta. Column suunta has 5653 rows, out of which 2 are empty, making the null percent 0.04. Minimum value is 0 and maximum value is 6.
suunta_uom string Data source did not contain a description for suunta_uom. Column suunta_uom has 5653 rows, out of which 2 are empty, making the null percent 0.04. The single string value is: .
nimi int Data source did not contain a description for nimi. Column nimi has 5653 rows, out of which 3769 are empty, making the null percent 66.67. Minimum value is 10 and maximum value is 91.
tyyppi string Data source did not contain a description for tyyppi. Column tyyppi has 5653 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is kaupunginosa and maximum string is kunta.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 5653 rows, out of which 40 are empty, making the null percent 0.71. First 25 characters of minimum string: ... and first 25 characters of maximum string: POLYGON ((24.7961081 60.2...
geom_center_x float Longitude of center. Column geom_center_x has 5653 rows, out of which 40 are empty, making the null percent 0.71. Minimum value is 24.50 and maximum value is 24.85.
geom_center_y float Latitude of center. Column geom_center_y has 5653 rows, out of which 40 are empty, making the null percent 0.71. Minimum value is 60.02 and maximum value is 60.36.
geom_type string Geometry type. Column geom_type has 5653 rows, out of which 40 are empty, making the null percent 0.71. Minimum string is and maximum string is ST_POLYGON.

Hallintoalue, Kantahallintoalue, Full history

Column Type Comment
gml_id string Data source did not contain a description for gml_id. Column gml_id has 5653 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Hallintoalue.10009195 and maximum string is Hallintoalue.9992669.
kplkoodi int Data source did not contain a description for kplkoodi. Column kplkoodi has 5653 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 501300 and maximum value is 501360.
sijaintiepavarmuus int Data source did not contain a description for sijaintiepavarmuus. Column sijaintiepavarmuus has 5653 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 5.
luontitapa string Data source did not contain a description for luontitapa. Column luontitapa has 5653 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: maastomittaus.
alkupvm timestamp Data source did not contain a description for alkuPvm. Column alkupvm has 5653 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1997-10-24 09:12:03 and maximum value is 2020-09-08 11:11:10.
ilmentymaelementinnimi string Data source did not contain a description for ilmentymaElementinNimi. Column ilmentymaelementinnimi has 5653 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: nimi.
suunta int Data source did not contain a description for suunta. Column suunta has 5653 rows, out of which 2 are empty, making the null percent 0.04. Minimum value is 0 and maximum value is 6.
suunta_uom string Data source did not contain a description for suunta_uom. Column suunta_uom has 5653 rows, out of which 2 are empty, making the null percent 0.04. The single string value is: .
nimi int Data source did not contain a description for nimi. Column nimi has 5653 rows, out of which 3769 are empty, making the null percent 66.67. Minimum value is 10 and maximum value is 91.
tyyppi string Data source did not contain a description for tyyppi. Column tyyppi has 5653 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is kaupunginosa and maximum string is kunta.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 5653 rows, out of which 40 are empty, making the null percent 0.71. First 25 characters of minimum string: ... and first 25 characters of maximum string: POLYGON ((24.7961081 60.2...
geom_center_x float Longitude of center. Column geom_center_x has 5653 rows, out of which 40 are empty, making the null percent 0.71. Minimum value is 24.50 and maximum value is 24.85.
geom_center_y float Latitude of center. Column geom_center_y has 5653 rows, out of which 40 are empty, making the null percent 0.71. Minimum value is 60.02 and maximum value is 60.36.
geom_type string Geometry type. Column geom_type has 5653 rows, out of which 40 are empty, making the null percent 0.71. Minimum string is 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 11, 2020
Created September 8, 2020