1. Home
  2. Datasets
  3. Auringon säteilyenergia ...
To download the data set, please sign up or log in

Auringon säteilyenergia katoille (rakennukset alueina + ominaisuustiedot)

Auringon säteilyenergia katoille (rakennukset alueina + ominaisuustiedot)

Tables

Column Descriptions

Aurinkoenergiapotentiaali Polygon Tm35polygon, Opendataaurinkoenergiapotentiaali Polygon Tm35

Column Type Comment
tunnari string Data source did not contain a description for tunnari. Column tunnari has 42120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is M4211D4_1 and maximum string is M4211F3_490.
kwh_vuosi float Data source did not contain a description for kwh_vuosi. Column kwh_vuosi has 42120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 377.97 and maximum value is 44473708.00.
kwh_vuosi_c2 float Data source did not contain a description for kwh_vuosi_c2. Column kwh_vuosi_c2 has 42120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 56.70 and maximum value is 6671056.00.
kwh_vuosi0 float Data source did not contain a description for kwh_vuosi0. Column kwh_vuosi0 has 42120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 151.19 and maximum value is 17789484.00.
soveltuvuu string Data source did not contain a description for soveltuvuu. Column soveltuvuu has 42120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0/10.0 and maximum string is 761/3393.0.
luotettavu float Data source did not contain a description for luotettavu. Column luotettavu has 42120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.00 and maximum value is 1.00.
piste_x float Data source did not contain a description for piste_x. Column piste_x has 42120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 316221.50 and maximum value is 347601.50.
piste_y float Data source did not contain a description for piste_y. Column piste_y has 42120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6814407.50 and maximum value is 6857999.50.
kiinteisto int Data source did not contain a description for kiinteisto. Column kiinteisto has 42120 rows, out of which 40160 are empty, making the null percent 95.35. Minimum value is 148010001 and maximum value is 2099080000.
rakennustu string Data source did not contain a description for rakennustu. Column rakennustu has 42120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 837-101-1-18-11 and maximum string is 837-302-785-19-.
pys_rak_nr int Data source did not contain a description for pys_rak_nr. Column pys_rak_nr has 42120 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 122985.
pys_rak__1 int Data source did not contain a description for pys_rak__1. Column pys_rak__1 has 42120 rows, out of which 30585 are empty, making the null percent 72.61. Minimum value is 1000061561 and maximum value is 1035370649.
valmistumi timestamp Data source did not contain a description for valmistumi.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 42120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: MULTIPOLYGON (((23.591828... and first 25 characters of maximum string: POLYGON ((23.728369696775...
geom_center_x double Longitude of the centroid of the geometry. Column geom_center_x has 42120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 23.54 and maximum value is 24.11.
geom_center_y double Latitude of the centroid of the geometry. Column geom_center_y has 42120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 61.43 and maximum value is 61.82.
geom_type string Geometry type. Column geom_type has 42120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_MULTIPOLYGON and maximum string is ST_POLYGON.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 12, 2019
Created November 25, 2018