1. Home
  2. Datasets
  3. Mun:Viistoilmakuvat
To download the data set, please sign up or log in

Mun:Viistoilmakuvat

Mun:Viistoilmakuvat

Tables

Column Descriptions

Viistoilmakuvat, Munviistoilmakuvat

Column Type Comment
ogr_pkid string Data source did not contain a description for ogr_pkid. Column ogr_pkid has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 1E7A145BF9E673D8BCCC433A9... and first 25 characters of maximum string: 1E7A145BF9E673D8BCCC433A9...
id1 string Data source did not contain a description for id1. Column is empty.
description_href string Data source did not contain a description for description_href. Column is empty.
description_title string Data source did not contain a description for description_title. Column is empty.
description string Data source did not contain a description for description. Column is empty.
location_location_pkid string Data source did not contain a description for location_location_pkid. Column is empty.
area int Data source did not contain a description for area. Column area has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
classid int Data source did not contain a description for classid. Column classid has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 22.
id2 int Data source did not contain a description for id2. Column id2 has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 225742539 and maximum value is 236014198.
municipality int Data source did not contain a description for municipality. Column municipality has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 895.
streetlang1 string Data source did not contain a description for streetlang1. Column is empty.
streetlang2 string Data source did not contain a description for streetlang2. Column is empty.
text string Data source did not contain a description for text. Column text has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Viistoilmakuva 2012 - 121... and first 25 characters of maximum string: Viistoilmakuva 2017 - 171...
textdir int Data source did not contain a description for textdir. Column textdir has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
textoffsetdx int Data source did not contain a description for textoffsetdx. Column textoffsetdx has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
textoffsetdy int Data source did not contain a description for textoffsetdy. Column textoffsetdy has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
ilmakuvan_20_tyyppi string Data source did not contain a description for ilmakuvan_20_tyyppi. Column ilmakuvan_20_tyyppi has 100 rows, out of which 2 are empty, making the null percent 2.00. Minimum string is Viistoilmakuva_2012 and maximum string is Viistoilmakuva_2017.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (21.5888633 60.7924... and first 25 characters of maximum string: POINT (21.6923163 60.7420...
geom_center_x double Longitude of the centroid of the geometry. Column is empty.
geom_center_y double Latitude of the centroid of the geometry. Column is empty.
geom_type string Geometry type. Column geom_type has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 12, 2019
Created November 26, 2018