1. Home
  2. Datasets
  3. GIS:Kaavoitushankkeet
To download the data set, please sign up or log in

GIS:Kaavoitushankkeet

GIS:Kaavoitushankkeet

Tables

Column Descriptions

Kaavoitushankkeet, Giskaavoitushankkeet

Column Type Comment
ogr_pkid string Data source did not contain a description for ogr_pkid. Column ogr_pkid has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 8B31E53D00FE6B686423E99A5... and first 25 characters of maximum string: 8B31E53D00FE6B686423E99A5...
id string Data source did not contain a description for id. Column is empty.
description_href string Data source did not contain a description for description_href. Column is empty.
description_title string Data source did not contain a description for description_title. Column is empty.
description string Data source did not contain a description for description. Column is empty.
location_location_pkid string Data source did not contain a description for location_location_pkid. Column is empty.
kaavatunnus string Data source did not contain a description for kaavatunnus. Column kaavatunnus has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 398 A-2476b and maximum string is 398 A-2750.
kaavalaji string Data source did not contain a description for kaavalaji. Column kaavalaji has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asemakaava and maximum string is Kaavarunko.
lajintarkenne string Data source did not contain a description for lajintarkenne. Column lajintarkenne has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Asemakaava... and first 25 characters of maximum string: Tutkittava yleiskaava/kaa...
kaavannimi string Data source did not contain a description for kaavannimi. Column kaavannimi has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: AHTIALA 13, KORTTELI 1340... and first 25 characters of maximum string: KOISKALA 14, MYLLYPOHJA 1...
kaavantyonimi string Data source did not contain a description for kaavantyonimi. Column kaavantyonimi has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: AHTIALA, MARKKINAKUJA 3... and first 25 characters of maximum string: KOISKALA/MYLLYPOHJA, KOIS...
kaavatilanne string Data source did not contain a description for kaavatilanne. Column kaavatilanne has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Työohjelmassa and maximum string is Vireillä.
alkuppintaala int Data source did not contain a description for alkuppintaala. Column alkuppintaala has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
voimpintaala int Data source did not contain a description for voimpintaala. Column voimpintaala has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
kaavampaatos string Data source did not contain a description for kaavampaatos. Column kaavampaatos 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: Ymp.min. 31.3.2000.
arkistotunnus string Data source did not contain a description for arkistotunnus. Column is empty.
viimeinenvaihe string Data source did not contain a description for viimeinenvaihe. Column viimeinenvaihe has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aloitusilmoitus... and first 25 characters of maximum string: Elinvoima ja työllisyysja...
viimvaihepvm string Data source did not contain a description for viimvaihepvm. Column is empty.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 100 rows, out of which 99 are empty, making the null percent 99.00. The single string value is: POINT (25.6566488 60.9836...
geom_center_x double Longitude of the centroid of the geometry. Column is empty.
geom_center_y double Latitude of the centroid of the geometry. Column is empty.
geom_type string Geometry type. Column geom_type has 100 rows, out of which 99 are empty, making the null percent 99.00. The single string value is: .
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 12, 2019
Created November 25, 2018