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

Palvelukohteet

Palvelukohteet

Tables

Column Descriptions

Palvelukohteet, Postgispalvelukohteet

Column Type Comment
id_1 int Data source did not contain a description for id_1. Column id_1 has 246 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 246.
id int Data source did not contain a description for id. Column id has 246 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
kohde string Data source did not contain a description for kohde. Column kohde has 246 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Opetus ja koulutus and maximum string is Turvallisuus ja järjestys.
nimi string Data source did not contain a description for nimi. Column nimi has 246 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Jämsän Kristillinen Kansa... and first 25 characters of maximum string: Yhdyskuntatoimi: Kaavoitu...
linkki string Data source did not contain a description for linkki. Column linkki has 246 rows, out of which 214 are empty, making the null percent 86.99. First 25 characters of minimum string: http://www.jamsanopisto.f... and first 25 characters of maximum string: https://www.gradia.fi/yht...
alaluokka string Data source did not contain a description for alaluokka. Column alaluokka has 246 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Muut oppilaitokset and maximum string is Yritykset.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 246 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: MULTIPOINT ((25.215793444... and first 25 characters of maximum string: MULTIPOINT ((25.324544647...
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 246 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_MULTIPOINT.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 12, 2019
Created November 24, 2018