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

Rakennukset alue

Rakennukset alue

Tables

Column Descriptions

Rakennukset Aluepolygon, Avoindatarakennukset Alue

Column Type Comment
id int Data source did not contain a description for id. Column id has 53915 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 53915 rows, out of which 5556 are empty, making the null percent 10.31. Minimum value is 1 and maximum value is 5119742.
ratu int Data source did not contain a description for ratu. Column ratu has 53915 rows, out of which 5088 are empty, making the null percent 9.44. 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 53915 rows, out of which 38212 are empty, making the null percent 70.87. Minimum value is 1000857320 and maximum value is 1037147846.
ratu_vasta string Data source did not contain a description for ratu_vasta. Column ratu_vasta has 53915 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/1 = 1 geometria / 1 RAT...
ratu_vast0 int Data source did not contain a description for ratu_vast0. Column ratu_vast0 has 53915 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 53915 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 53915 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.
tila string Data source did not contain a description for tila. Column tila has 53915 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 53915 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.
tyyppi string Data source did not contain a description for tyyppi. Column tyyppi has 53915 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 53915 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.
luontipvm string Data source did not contain a description for luontipvm. Column is empty.
muokkauspv string Data source did not contain a description for muokkauspv. Column is empty.
katunimi_s string Data source did not contain a description for katunimi_s. Column katunimi_s has 53915 rows, out of which 5206 are empty, making the null percent 9.66. Minimum string is and maximum string is Kuilukuja.
katunimi_r string Data source did not contain a description for katunimi_r. Column katunimi_r has 53915 rows, out of which 5206 are empty, making the null percent 9.66. Minimum string is and maximum string is Schaktgränden.
osoitenume int Data source did not contain a description for osoitenume. Column osoitenume has 53915 rows, out of which 12751 are empty, making the null percent 23.65. Minimum value is 1 and maximum value is 924.
postinumer int Data source did not contain a description for postinumer. Column postinumer has 53915 rows, out of which 5209 are empty, making the null percent 9.66. Minimum value is 100 and maximum value is 990.
datanomist string Data source did not contain a description for datanomist. Column datanomist has 53915 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Helsinki/Kami.
paivitetty string Data source did not contain a description for paivitetty. Column is empty.
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