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

Maankäyttö: Asemakaava, Erityisalue

Maankäyttö: Asemakaava, Erityisalue

Tables

Column Descriptions

Erityisalue, Akaavaerityisalue

Column Type Comment
gml_id string Data source did not contain a description for gml_id. Column is empty.
tunnus int Data source did not contain a description for tunnus. Column tunnus has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 16852594 and maximum value is 127834298.
kaavatunnus int Data source did not contain a description for kaavatunnus. Column kaavatunnus has 100 rows, out of which 3 are empty, making the null percent 3.00. Minimum value is 205275 and maximum value is 205512.
kaavamerkinta string Data source did not contain a description for kaavamerkinta. Column kaavamerkinta has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is EH and maximum string is EV.
poistettava int Data source did not contain a description for poistettava. Column poistettava has 100 rows, out of which 54 are empty, making the null percent 54.00. Constant value is 0.
maanalainen int Data source did not contain a description for maanalainen. Column maanalainen has 100 rows, out of which 54 are empty, making the null percent 54.00. Constant value is 0.
kohteenvaihe string Data source did not contain a description for kohteenvaihe. Column kohteenvaihe has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: lainvoimainen.
ilmentymaelementinnimi string Data source did not contain a description for ilmentymaElementinNimi. Column ilmentymaelementinnimi has 100 rows, out of which 54 are empty, making the null percent 54.00. The single string value is: .
suunta int Data source did not contain a description for suunta. Column suunta has 100 rows, out of which 54 are empty, making the null percent 54.00. Minimum value is 1 and maximum value is 2.
suunta_uom string Data source did not contain a description for suunta_uom. Column suunta_uom has 100 rows, out of which 54 are empty, making the null percent 54.00. The single string value is: .
kayttotarkoitus string Data source did not contain a description for kayttotarkoitus. Column kayttotarkoitus has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is EH and maximum string is EV.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 100 rows, out of which 4 are empty, making the null percent 4.00. First 25 characters of minimum string: ... and first 25 characters of maximum string: POLYGON ((27.7466267 64.2...
geom_center_x double Longitude of the centroid of the geometry. Column geom_center_x has 100 rows, out of which 50 are empty, making the null percent 50.00. Minimum value is 27.01 and maximum value is 27.79.
geom_center_y double Latitude of the centroid of the geometry. Column geom_center_y has 100 rows, out of which 50 are empty, making the null percent 50.00. Minimum value is 64.11 and maximum value is 64.26.
geom_type string Geometry type. Column geom_type has 100 rows, out of which 4 are empty, making the null percent 4.00. 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 April 12, 2019
Created November 23, 2018