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

PTM-kontrollimittaukset

PTM-kontrollimittaukset

Tables

Column Descriptions

Tl714, Avointl714

Column Type Comment
aet int Data source did not contain a description for AET. Column aet has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 19215.
ajr int Data source did not contain a description for AJR. Column ajr has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 2.
alkupvm string Data source did not contain a description for ALKUPVM. Column is empty.
aosa int Data source did not contain a description for AOSA. Column aosa has 45238 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 448.
ely int Data source did not contain a description for ELY. Column ely has 45238 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 14.
id int Data source did not contain a description for ID. Column is empty.
kaista int Data source did not contain a description for KAISTA. Column kaista has 45238 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 22.
kharjannek float Data source did not contain a description for KHARJANNEK. Column kharjannek has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -1.10 and maximum value is 50.90.
kharjannem string Data source did not contain a description for KHARJANNEM. Column is empty.
kiri100 float Data source did not contain a description for KIRI100. Column kiri100 has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.48 and maximum value is 99.99.
kirioik float Data source did not contain a description for KIRIOIK. Column kirioik has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.48 and maximum value is 99.99.
kirivas float Data source did not contain a description for KIRIVAS. Column kirivas has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.24 and maximum value is 99.99.
kkaartalku float Data source did not contain a description for KKAARTALKU. Column kkaartalku has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -358.62 and maximum value is 323.18.
kkaartlopp float Data source did not contain a description for KKAARTLOPP. Column kkaartlopp has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -999.99 and maximum value is 857.08.
kkalt1alku float Data source did not contain a description for KKALT1ALKU. Column kkalt1alku has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -10.66 and maximum value is 9.47.
kkalt1lopp float Data source did not contain a description for KKALT1LOPP. Column kkalt1lopp has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -13.15 and maximum value is 8.55.
kkaus714 int Data source did not contain a description for KKAUS714. Column kkaus714 has 45238 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 3.
klriski string Data source did not contain a description for KLRISKI. Column is empty.
km_su714 int Data source did not contain a description for KM_SU714. Column km_su714 has 45238 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 2.
kphriski string Data source did not contain a description for KPHRISKI. Column is empty.
kpitkaltal float Data source did not contain a description for KPITKALTAL. Column kpitkaltal has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -12.84 and maximum value is 12.78.
kpitkaltlo float Data source did not contain a description for KPITKALTLO. Column kpitkaltlo has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -17.43 and maximum value is 14.22.
kpoik_ka string Data source did not contain a description for KPOIK_KA. Column is empty.
kpoik_max string Data source did not contain a description for KPOIK_MAX. Column is empty.
kpoik_t_ka string Data source did not contain a description for KPOIK_T_KA. Column is empty.
kpoik_t_ma string Data source did not contain a description for KPOIK_T_MA. Column is empty.
krms10oik float Data source did not contain a description for KRMS10OIK. Column krms10oik has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.21 and maximum value is 95.25.
krms10vas float Data source did not contain a description for KRMS10VAS. Column krms10vas has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.18 and maximum value is 102.40.
krms1oik float Data source did not contain a description for KRMS1OIK. Column krms1oik has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.06 and maximum value is 5.20.
krms1vas float Data source did not contain a description for KRMS1VAS. Column krms1vas has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.05 and maximum value is 5.88.
krms30oik float Data source did not contain a description for KRMS30OIK. Column krms30oik has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.30 and maximum value is 290.24.
krms30vas float Data source did not contain a description for KRMS30VAS. Column krms30vas has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.17 and maximum value is 301.39.
krms3oik float Data source did not contain a description for KRMS3OIK. Column krms3oik has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.11 and maximum value is 22.01.
krms3vas float Data source did not contain a description for KRMS3VAS. Column krms3vas has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.09 and maximum value is 23.97.
krmsmegake float Data source did not contain a description for KRMSMEGAKE. Column krmsmegake has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.12 and maximum value is 1.79.
krmsmegaoi float Data source did not contain a description for KRMSMEGAOI. Column krmsmegaoi has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.11 and maximum value is 2.72.
krms_h_kes string Data source did not contain a description for KRMS_H_KES. Column is empty.
krms_h_oik string Data source did not contain a description for KRMS_H_OIK. Column is empty.
krms_k_kes float Data source did not contain a description for KRMS_K_KES. Column krms_k_kes has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.09 and maximum value is 1.96.
krms_k_oik float Data source did not contain a description for KRMS_K_OIK. Column krms_k_oik has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.09 and maximum value is 1.86.
kshriski string Data source did not contain a description for KSHRISKI. Column is empty.
ksuurinhei string Data source did not contain a description for KSUURINHEI. Column is empty.
kunta string Data source did not contain a description for KUNTA. Column kunta has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alajärvi and maximum string is Ruovesi.
kuntakoodi int Data source did not contain a description for KUNTAKOODI. Column kuntakoodi has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 992.
kura100 float Data source did not contain a description for KURA100. Column kura100 has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.60 and maximum value is 43.00.
kuramax float Data source did not contain a description for KURAMAX. Column kuramax has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.60 and maximum value is 43.00.
kuraoik float Data source did not contain a description for KURAOIK. Column kuraoik has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.30 and maximum value is 43.00.
kuravas float Data source did not contain a description for KURAVAS. Column kuravas has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.20 and maximum value is 40.70.
kvesiuraoi string Data source did not contain a description for KVESIURAOI. Column is empty.
kvesiurava string Data source did not contain a description for KVESIURAVA. Column is empty.
laani string Data source did not contain a description for LAANI. Column laani has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Suomen lääni and maximum string is Länsi-Suomen lääni.
lakkautpvm string Data source did not contain a description for LAKKAUTPVM. Column is empty.
let int Data source did not contain a description for LET. Column let has 45238 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 19295.
liva string Data source did not contain a description for LIVA. Column liva has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Pohjanmaan ELY and maximum string is Pirkanmaan ELY.
loppupvm string Data source did not contain a description for LOPPUPVM. Column is empty.
losa int Data source did not contain a description for LOSA. Column losa has 45238 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 448.
maakunta string Data source did not contain a description for MAAKUNTA. Column maakunta has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Karjala and maximum string is Pirkanmaa.
maakuntako int Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 45238 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 19.
muutospvm string Data source did not contain a description for MUUTOSPVM. Column is empty.
objectid int Data source did not contain a description for OBJECTID. Column objectid has 45238 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 45507.
shape string Data source did not contain a description for SHAPE. Column is empty.
s_kkausi71 string Data source did not contain a description for S_KKAUSI71. Column s_kkausi71 has 45238 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is kesamitta and maximum string is kevatmitta.
s_ualue string Data source did not contain a description for S_UALUE. Column s_ualue has 45238 rows, out of which 123 are empty, making the null percent 0.27. Minimum string is and maximum string is Virrat 15 -20.
tie int Data source did not contain a description for TIE. Column tie has 45238 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 19664.
ualue int Data source did not contain a description for UALUE. Column ualue has 45238 rows, out of which 123 are empty, making the null percent 0.27. Minimum value is 127 and maximum value is 1435.
geom_geojson string Geometry in GeoJSON format.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 12, 2019
Created August 1, 2018