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

Rakennukset piste rekisteritiedot

Helsingin rakennukset paikkatietoaineisto perustuu kantakartan rakennuskohteisiin, jotka ovat geometrialtaan alueita (polygon). Aineistossa on mukana kaikki kantakartan aluemaiset kohteet.

Tables

Column Descriptions

Rakennukset piste rekisteritiedotpoint, Avoindatarakennukset piste rekisteritiedot, Latest

Column Type Comment
id int Data source did not contain a description for id. Column id has 51596 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 51595.
kg_krakenn int Data source did not contain a description for kg_krakenn. Column kg_krakenn has 51596 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 5149029.
i_pyraknro int Data source did not contain a description for i_pyraknro. Column i_pyraknro has 51596 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 71923.
c_vtj_prt int Data source did not contain a description for c_vtj_prt. Column c_vtj_prt has 51596 rows, out of which 34874 are empty, making the null percent 67.59. Minimum value is 1000857320 and maximum value is 1040155477.
c_kiinteis string Data source did not contain a description for c_kiinteis. Column c_kiinteis has 51596 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is 091-000-0000-0000 and maximum string is 091-895-0002-0045.
i_nkoord int Data source did not contain a description for i_nkoord. Column i_nkoord has 51596 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 6687039.
i_ekoord int Data source did not contain a description for i_ekoord. Column i_ekoord has 51596 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 25513654.
c_valmpvm date Data source did not contain a description for c_valmpvm. Column is empty.
c_julkisiv int Data source did not contain a description for c_julkisiv. Column c_julkisiv has 51596 rows, out of which 16105 are empty, making the null percent 31.21. Minimum value is 1 and maximum value is 7.
i_kokala int Data source did not contain a description for i_kokala. Column i_kokala has 51596 rows, out of which 1802 are empty, making the null percent 3.49. Minimum value is 3 and maximum value is 167432.
i_kerrlkm int Data source did not contain a description for i_kerrlkm. Column i_kerrlkm has 51596 rows, out of which 975 are empty, making the null percent 1.89. Minimum value is 1 and maximum value is 35.
i_kerrosal int Data source did not contain a description for i_kerrosal. Column i_kerrosal has 51596 rows, out of which 812 are empty, making the null percent 1.57. Minimum value is 3 and maximum value is 114866.
i_kellaral int Data source did not contain a description for i_kellaral. Column i_kellaral has 51596 rows, out of which 46820 are empty, making the null percent 90.74. Minimum value is 1 and maximum value is 124960.
d_ashuoala int Data source did not contain a description for d_ashuoala. Column d_ashuoala has 51596 rows, out of which 14368 are empty, making the null percent 27.85. Minimum value is 7 and maximum value is 18011.
c_kayttark int Data source did not contain a description for c_kayttark. Column c_kayttark has 51596 rows, out of which 3 are empty, making the null percent 0.01. Minimum value is 11 and maximum value is 999.
c_lammtapa int Data source did not contain a description for c_lammtapa. Column c_lammtapa has 51596 rows, out of which 1214 are empty, making the null percent 2.35. 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 51596 rows, out of which 4097 are empty, making the null percent 7.94. Minimum value is 1 and maximum value is 10.
c_rakeaine int Data source did not contain a description for c_rakeaine. Column c_rakeaine has 51596 rows, out of which 903 are empty, making the null percent 1.75. Minimum value is 1 and maximum value is 5.
i_raktilav int Data source did not contain a description for i_raktilav. Column i_raktilav has 51596 rows, out of which 948 are empty, making the null percent 1.84. Minimum value is 8 and maximum value is 1135220.
c_hissi string Data source did not contain a description for c_hissi. Column c_hissi has 51596 rows, out of which 43871 are empty, making the null percent 85.03. The single string value is: .
c_viemlii string Data source did not contain a description for c_viemlii. Column c_viemlii has 51596 rows, out of which 8311 are empty, making the null percent 16.11. The single string value is: .
c_vesilii string Data source did not contain a description for c_vesilii. Column c_vesilii has 51596 rows, out of which 8471 are empty, making the null percent 16.42. The single string value is: .
c_sahkolii string Data source did not contain a description for c_sahkolii. Column c_sahkolii has 51596 rows, out of which 9991 are empty, making the null percent 19.36. The single string value is: .
i_huoneist int Data source did not contain a description for i_huoneist. Column i_huoneist has 51596 rows, out of which 13601 are empty, making the null percent 26.36. Minimum value is 1 and maximum value is 312.
katunimi_s string Data source did not contain a description for katunimi_s. Column katunimi_s has 51596 rows, out of which 28 are empty, making the null percent 0.05. Minimum string is and maximum string is Östersundomin kartano.
katunimi_r string Data source did not contain a description for katunimi_r. Column katunimi_r has 51596 rows, out of which 28 are empty, making the null percent 0.05. Minimum string is and maximum string is Övre Malms torg.
osoitenume int Data source did not contain a description for osoitenume. Column osoitenume has 51596 rows, out of which 8207 are empty, making the null percent 15.91. Minimum value is 1 and maximum value is 1174.
postinumer int Data source did not contain a description for postinumer. Column postinumer has 51596 rows, out of which 31 are empty, making the null percent 0.06. Minimum value is 100 and maximum value is 990.
datanomist string Data source did not contain a description for datanomist. Column datanomist has 51596 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Helsinki/RAVA.
paivitetty date Data source did not contain a description for paivitetty. Column is empty.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 51596 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: POINT (24.832680380342634... and first 25 characters of maximum string: POINT (-85.43679636980745...
geom_center_x float Longitude of center. Column geom_center_x has 51596 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is -85.44 and maximum value is 25.25.
geom_center_y float Latitude of center. Column geom_center_y has 51596 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 60.3.
geom_type string Geometry type. Column geom_type has 51596 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POINT.

Additional Info

Last Updated July 6, 2022
Created August 7, 2018