1. Home
  2. Datasets
  3. Oppilaitokset 2017 - ...
To download the data set, please sign up or log in

Oppilaitokset 2017 - Educational institutions

Oppilaitokset 2017 - Educational institutions

Tables

  • Oppilaitokset, OppilaitoksetoppilaitoksetTSV

    Location (x,y) and name of educational institutions. Statistical reference year 2017. Data includes a location and a name of every comprehensive and upper secondary level schools in Finland. The source of data is the yearly updated register of educational institutions which is maintained by Statistics Finland. An educational institution is defined as an administrative unit as such not the school building or the operating place. Coordinates are mostly accurate based on the centroid of the building althought there exists some educational institutions with estimated coordinates. Estimations are based to the street address of the educational institutions. There are 4 types of educational institutes: OLTYP 11=Comprehensive schools OLTYO 12= Comprehensive school level special education...

Column Descriptions

Oppilaitokset, Oppilaitoksetoppilaitokset

Column Type Comment
til_vuosi int Data source did not contain a description for til_vuosi. Column til_vuosi has 2812 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2017.
onimi string Data source did not contain a description for onimi. Column onimi has 2812 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aapiskujan koulu and maximum string is Övernäs skola.
oltyp int Data source did not contain a description for oltyp. Column oltyp has 2812 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 11 and maximum value is 19.
oltyp_nimi string Data source did not contain a description for oltyp_nimi. Column oltyp_nimi has 2812 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Lukiot and maximum string is Peruskoulut.
euref_x int Data source did not contain a description for euref_x. Column euref_x has 2812 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 88231 and maximum value is 717092.
euref_y int Data source did not contain a description for euref_y. Column euref_y has 2812 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6638926 and maximum value is 7775275.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 2812 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 (19.556694418509647... and first 25 characters of maximum string: POINT (19.93300430967445 ...
geom_center_x float Longitude of center. Column geom_center_x has 2812 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19.56 and maximum value is 31.28.
geom_center_y float Latitude of center. Column geom_center_y has 2812 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.78 and maximum value is 70.08.
geom_type string Geometry type. Column geom_type has 2812 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 September 7, 2018