1. Home
  2. Datasets
  3. Rakennukset alue ...
To download the data set, please sign up or log in

Rakennukset alue rekisteritiedot

Rakennukset alue rekisteritiedot

Tables

Column Descriptions

Rakennukset Alue Rekisteritiedotpolygon, Avoindatarakennukset Alue Rekisteritiedot

Column Type Comment
id int Data source did not contain a description for id. Column id has 54206 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 739588 and maximum value is 794899.
kuntarekis int Data source did not contain a description for kuntarekis. Column kuntarekis has 54206 rows, out of which 5557 are empty, making the null percent 10.25. Minimum value is 1 and maximum value is 5119742.
kg_krakenn int Data source did not contain a description for kg_krakenn. Column kg_krakenn has 54206 rows, out of which 5622 are empty, making the null percent 10.37. Minimum value is 1 and maximum value is 5119742.
ratu int Data source did not contain a description for ratu. Column ratu has 54206 rows, out of which 5087 are empty, making the null percent 9.38. Minimum value is 1 and maximum value is 67153.
vtj_prt int Data source did not contain a description for vtj_prt. Column vtj_prt has 54206 rows, out of which 38410 are empty, making the null percent 70.86. Minimum value is 1000857320 and maximum value is 1037147846.
tyyppi string Data source did not contain a description for tyyppi. Column tyyppi has 54206 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asuinrakennus and maximum string is Talousrakennus.
tyyppi_koo int Data source did not contain a description for tyyppi_koo. Column tyyppi_koo has 54206 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 6.
tila string Data source did not contain a description for tila. Column tila has 54206 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is purettu and maximum string is voimassa.
tila_koodi int Data source did not contain a description for tila_koodi. Column tila_koodi has 54206 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 2.
ratu_vasta string Data source did not contain a description for ratu_vasta. Column ratu_vasta has 54206 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0 = geometriaan ei liity ... and first 25 characters of maximum string: 1/n = 1 geometria / n RAT...
ratu_vast0 int Data source did not contain a description for ratu_vast0. Column ratu_vast0 has 54206 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 3.
ratu_laatu string Data source did not contain a description for ratu_laatu. Column ratu_laatu has 54206 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is määritelty luotettavasti and maximum string is vaikeasti selvitettävissä.
ratu_laat0 int Data source did not contain a description for ratu_laat0. Column ratu_laat0 has 54206 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 3.
i_raktilav int Data source did not contain a description for i_raktilav. Column i_raktilav has 54206 rows, out of which 6532 are empty, making the null percent 12.05. Minimum value is -324461 and maximum value is 1134427.
i_pyraknro int Data source did not contain a description for i_pyraknro. Column i_pyraknro has 54206 rows, out of which 5622 are empty, making the null percent 10.37. Minimum value is 1 and maximum value is 67078.
i_nkoord int Data source did not contain a description for i_nkoord. Column i_nkoord has 54206 rows, out of which 5622 are empty, making the null percent 10.37. Minimum value is 6665487 and maximum value is 6687039.
i_ekoord int Data source did not contain a description for i_ekoord. Column i_ekoord has 54206 rows, out of which 5622 are empty, making the null percent 10.37. Minimum value is 25490735 and maximum value is 25513654.
i_kokala int Data source did not contain a description for i_kokala. Column i_kokala has 54206 rows, out of which 7522 are empty, making the null percent 13.88. Minimum value is -7993 and maximum value is 145963.
i_kerrosal int Data source did not contain a description for i_kerrosal. Column i_kerrosal has 54206 rows, out of which 6247 are empty, making the null percent 11.52. Minimum value is -7993 and maximum value is 116725.
i_kerrlkm int Data source did not contain a description for i_kerrlkm. Column i_kerrlkm has 54206 rows, out of which 6284 are empty, making the null percent 11.59. Minimum value is 1 and maximum value is 930.
i_kellaral int Data source did not contain a description for i_kellaral. Column i_kellaral has 54206 rows, out of which 50266 are empty, making the null percent 92.73. Minimum value is 7 and maximum value is 52000.
i_huoneist int Data source did not contain a description for i_huoneist. Column i_huoneist has 54206 rows, out of which 17700 are empty, making the null percent 32.65. Minimum value is 1 and maximum value is 302.
d_ashuoala int Data source did not contain a description for d_ashuoala. Column d_ashuoala has 54206 rows, out of which 18485 are empty, making the null percent 34.10. Minimum value is 7 and maximum value is 18011.
c_vtj_prt int Data source did not contain a description for c_vtj_prt. Column c_vtj_prt has 54206 rows, out of which 38570 are empty, making the null percent 71.15. Minimum value is 1000857320 and maximum value is 1037123301.
c_viemlii string Data source did not contain a description for c_viemlii. Column c_viemlii has 54206 rows, out of which 13078 are empty, making the null percent 24.13. The single string value is: .
c_vesilii string Data source did not contain a description for c_vesilii. Column c_vesilii has 54206 rows, out of which 13129 are empty, making the null percent 24.22. The single string value is: .
c_valmpvm string Data source did not contain a description for c_valmpvm. Column is empty.
c_sahkolii string Data source did not contain a description for c_sahkolii. Column c_sahkolii has 54206 rows, out of which 16140 are empty, making the null percent 29.78. The single string value is: .
c_rakeaine int Data source did not contain a description for c_rakeaine. Column c_rakeaine has 54206 rows, out of which 6524 are empty, making the null percent 12.04. Minimum value is 1 and maximum value is 5.
c_poltaine int Data source did not contain a description for c_poltaine. Column c_poltaine has 54206 rows, out of which 11413 are empty, making the null percent 21.05. Minimum value is 1 and maximum value is 10.
c_lammtapa int Data source did not contain a description for c_lammtapa. Column c_lammtapa has 54206 rows, out of which 6835 are empty, making the null percent 12.61. Minimum value is 1 and maximum value is 5.
c_kiinteis string Data source did not contain a description for c_kiinteis. Column c_kiinteis has 54206 rows, out of which 5622 are empty, making the null percent 10.37. Minimum string is and maximum string is 091-041-0115-0004.
c_kayttark int Data source did not contain a description for c_kayttark. Column c_kayttark has 54206 rows, out of which 5623 are empty, making the null percent 10.37. Minimum value is 11 and maximum value is 999.
c_julkisiv int Data source did not contain a description for c_julkisiv. Column c_julkisiv has 54206 rows, out of which 23053 are empty, making the null percent 42.53. Minimum value is 1 and maximum value is 7.
c_hissi string Data source did not contain a description for c_hissi. Column c_hissi has 54206 rows, out of which 47089 are empty, making the null percent 86.87. The single string value is: .
katunimi_s string Data source did not contain a description for katunimi_s. Column katunimi_s has 54206 rows, out of which 5737 are empty, making the null percent 10.58. Minimum string is and maximum string is Laitatie.
katunimi_r string Data source did not contain a description for katunimi_r. Column katunimi_r has 54206 rows, out of which 5737 are empty, making the null percent 10.58. Minimum string is and maximum string is Yttervägen.
osoitenume int Data source did not contain a description for osoitenume. Column osoitenume has 54206 rows, out of which 13200 are empty, making the null percent 24.35. Minimum value is 1 and maximum value is 924.
postinumer int Data source did not contain a description for postinumer. Column postinumer has 54206 rows, out of which 5740 are empty, making the null percent 10.59. Minimum value is 100 and maximum value is 990.
muokkauspv string Data source did not contain a description for muokkauspv. Column is empty.
luontipvm string Data source did not contain a description for luontipvm. Column is empty.
datanomist string Data source did not contain a description for datanomist. Column datanomist has 54206 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Helsinki/RAVA.
paivitetty string Data source did not contain a description for paivitetty. Column is empty.
tietopalve int Data source did not contain a description for tietopalve. Column tietopalve has 54206 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 54206.
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