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

Akaava:Kaavayksikko

Akaava:Kaavayksikko

Tables

Column Descriptions

Kaavayksikko, Akaavakaavayksikko

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 846435420 and maximum value is 901807241.
kaavatunnus string Data source did not contain a description for kaavatunnus. Column kaavatunnus has 100 rows, out of which 1 are empty, making the null percent 1.00. Minimum string is and maximum string is 398 A-2508a.
kaavayksikontunnus string Data source did not contain a description for kaavayksikonTunnus. Column kaavayksikontunnus has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 398-10-289-2 and maximum string is 398-10-294-7.
kaavayksikonlaji string Data source did not contain a description for kaavayksikonlaji. Column kaavayksikonlaji 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: hyväksytyn tonttijaon muk... and first 25 characters of maximum string: korttelin osa...
tonttijaonlaji string Data source did not contain a description for tonttijaonlaji. Column tonttijaonlaji 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: erillinen tonttijako... and first 25 characters of maximum string: kaavaan sisältyy ohjeell...
kaavallinenolotila string Data source did not contain a description for kaavallinenOlotila. Column kaavallinenolotila 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: asemakaava, lainvoimainen.
voimassaolo string Data source did not contain a description for voimassaolo. Column voimassaolo has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is muu and maximum string is voimassa.
perusmaara int Data source did not contain a description for perusmaara. Column perusmaara has 100 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 8541.
kaytetty int Data source did not contain a description for kaytetty. Column kaytetty has 100 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 5311.
kerrostenlkm string Data source did not contain a description for kerrostenLkm. Column kerrostenlkm has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-Ei tietoa and maximum string is 2-.
kerrosjaonmaaraytymistapa string Data source did not contain a description for kerrosjaonMaaraytymistapa. Column kerrosjaonmaaraytymistapa has 100 rows, out of which 2 are empty, making the null percent 2.00. Minimum string is and maximum string is 1/2r II.
tehokkuusluku int Data source did not contain a description for tehokkuusluku. Column tehokkuusluku has 100 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 2.
maarittamistapakoodi string Data source did not contain a description for maarittamisTapaKoodi. Column maarittamistapakoodi has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 and maximum string is kerrosneliömetreinä.
maankayttomuoto string Data source did not contain a description for maankayttomuoto. Column maankayttomuoto has 100 rows, out of which 1 are empty, making the null percent 1.00. Minimum string is and maximum string is AO.
pintaala int Data source did not contain a description for pintaAla. Column pintaala has 100 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 21354.
pintaalanmaarittamistapa string Data source did not contain a description for pintaAlanMaarittamistapa. Column pintaalanmaarittamistapa has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 and maximum string is geodeettinen.
kayttotarkoitus string Data source did not contain a description for kayttotarkoitus. Column kayttotarkoitus has 100 rows, out of which 2 are empty, making the null percent 2.00. First 25 characters of minimum string: ... and first 25 characters of maximum string: ERILLISPIENTALOJEN KORTTE...
tonttijaontunnus string Data source did not contain a description for tonttijaontunnus. Column tonttijaontunnus has 100 rows, out of which 62 are empty, making the null percent 62.00. Minimum string is and maximum string is 398M-13-68.
yksilointitieto int Data source did not contain a description for yksilointitieto. Column yksilointitieto has 100 rows, out of which 61 are empty, making the null percent 61.00. Minimum value is 836666029 and maximum value is 898963926.
alkuhetki string Data source did not contain a description for alkuHetki. Column alkuhetki has 100 rows, out of which 61 are empty, making the null percent 61.00. The single string value is: .
kunta string Data source did not contain a description for kunta. Column kunta has 100 rows, out of which 61 are empty, making the null percent 61.00. The single string value is: .
teksti string Data source did not contain a description for teksti. Column teksti has 100 rows, out of which 61 are empty, making the null percent 61.00. Minimum string is and maximum string is Laudekatu.
osoitenumero int Data source did not contain a description for osoitenumero. Column osoitenumero has 100 rows, out of which 61 are empty, making the null percent 61.00. Minimum value is 1 and maximum value is 64.
postinumero int Data source did not contain a description for postinumero. Column postinumero has 100 rows, out of which 61 are empty, making the null percent 61.00. Minimum value is 15150 and maximum value is 15680.
postitoimipaikannimi string Data source did not contain a description for postitoimipaikannimi. Column postitoimipaikannimi has 100 rows, out of which 61 are empty, making the null percent 61.00. Minimum string is and maximum string is LAHTI.
geom_geojson string Geometry in GeoJSON format.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 12, 2019
Created August 7, 2018