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

Helsingin kaupungin rakennushankkeet 2018

Helsingin kaupungin rakennushankkeet 2018

Tables

Column Descriptions

Helsingin Kaupungin Rakennushankkeet 2018point, Avoindatahelsingin Kaupungin Rakennushankkeet 2018

Column Type Comment
id int Data source did not contain a description for id. Column id has 58 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 58.
listaan string Data source did not contain a description for listaan. Column listaan has 58 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. This column is filled with a constant value. The single string value is: TOSI.
kartalle string Data source did not contain a description for kartalle. Column kartalle has 58 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. This column is filled with a constant value. The single string value is: TOSI.
alakategor string Data source did not contain a description for alakategor. Column alakategor has 58 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Kaupunkiympäristön toim... and first 25 characters of maximum string: Sosiaali- ja terveystoimi...
hankenumer string Data source did not contain a description for hankenumer. Column hankenumer has 58 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is X20170024 and maximum string is X20170081.
hanke string Data source did not contain a description for hanke. Column hanke has 58 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Koskelantien risteyssilla... and first 25 characters of maximum string: Vesalan yläaste...
hanke_ruot string Data source did not contain a description for hanke_ruot. Column hanke_ruot has 58 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Forsbyvägens broar... and first 25 characters of maximum string: Ärtholmens och Dockstran...
hanke_engl string Data source did not contain a description for hanke_engl. Column hanke_engl has 58 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Koskelantie bridges and maximum string is Vesalan yläaste.
sisalto string Data source did not contain a description for sisalto. Column sisalto has 58 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Peruskorjaus and maximum string is Vesikaton korjaus.
sisalto_ru string Data source did not contain a description for sisalto_ru. Column sisalto_ru has 58 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ombyggnad... and first 25 characters of maximum string: Ändringsarbeten på camp...
sisalto_en string Data source did not contain a description for sisalto_en. Column sisalto_en has 58 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Rebuilding... and first 25 characters of maximum string: Temporary premises in Roi...
omistaja string Data source did not contain a description for omistaja. Column omistaja has 58 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Kaupunkiympäristön toim... and first 25 characters of maximum string: Koy tai vuokra...
laajuus_m2 int Data source did not contain a description for laajuus_m2. Column laajuus_m2 has 58 rows, out of which 28 are empty, making the null percent 48.28.
kust_arvio float Data source did not contain a description for kust_arvio. Column kust_arvio has 58 rows, out of which 7 are empty, making the null percent 12.07. Minimum value is 1.00 and maximum value is 165.00.
alkaavuosi int Data source did not contain a description for alkaavuosi. Column alkaavuosi has 58 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2008 and maximum value is 2018.
paattyyvuo int Data source did not contain a description for paattyyvuo. Column paattyyvuo has 58 rows, out of which 13 are empty, making the null percent 22.41. Minimum value is 2018 and maximum value is 2020.
rakentamin int Data source did not contain a description for rakentamin. Column rakentamin has 58 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2008 and maximum value is 2018.
valmistumi int Data source did not contain a description for valmistumi. Column valmistumi has 58 rows, out of which 13 are empty, making the null percent 22.41. Minimum value is 2018 and maximum value is 2020.
uudisraken string Data source did not contain a description for uudisraken. Column uudisraken has 58 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is EPÄTOSI and maximum string is TOSI.
korjausrak string Data source did not contain a description for korjausrak. Column korjausrak has 58 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is EPÄTOSI and maximum string is TOSI.
katuosoite string Data source did not contain a description for katuosoite. Column katuosoite has 58 rows, out of which 25 are empty, making the null percent 43.10.
p int Data source did not contain a description for p. Column p has 58 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6671335 and maximum value is 6684545.
i int Data source did not contain a description for i. Column i has 58 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 25491896 and maximum value is 25508746.
paivitetty string Data source did not contain a description for paivitetty. Column is empty.
datanomist string Data source did not contain a description for datanomist. Column datanomist has 58 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. This column is filled with a constant value. The single string value is: Helsinki/Kanslia.
geom_geojson string Geometry in GeoJSON format.
orig_extractdate string

Additional Info

Last Updated September 2, 2023
Created August 7, 2018