1. Home
  2. Datasets
  3. Vapaanaolon valvonta
To download the data set, please sign up or log in

Vapaanaolon valvonta

Vapaanaolon valvonta

Tables

Column Descriptions

Rata vapaanaolon valvonta, Avoinrata vapaanaolon valvonta, Latest

Column Type Comment
alkukm_m string Data source did not contain a description for ALKUKM_M. Column alkukm_m has 1968 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0001+0290 and maximum string is 1065+0950.
alkupvm date Data source did not contain a description for ALKUPVM. Column is empty.
id int Data source did not contain a description for ID. Column id has 1968 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 629460 and maximum value is 909181.
irrotus_pv timestamp Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 1968 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2020-05-25 21:02:18 and maximum value is 2020-05-25 21:02:23.
kisko string Data source did not contain a description for KISKO. Column kisko has 1968 rows, out of which 1381 are empty, making the null percent 70.17. Minimum string is and maximum string is V.
kpitoalue int Data source did not contain a description for KPITOALUE. Column kpitoalue has 1968 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 12.
lahde string Data source did not contain a description for LAHDE. Column is empty.
lahdekoodi string Data source did not contain a description for LAHDEKOODI. Column lahdekoodi has 1968 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: TKO.
laji string Data source did not contain a description for LAJI. Column laji has 1968 rows, out of which 11 are empty, making the null percent 0.56. Minimum string is and maximum string is 230M.
latauspvm date Data source did not contain a description for LATAUSPVM. Column is empty.
lehti int Data source did not contain a description for LEHTI. Column lehti has 1968 rows, out of which 12 are empty, making the null percent 0.61. Minimum value is 1 and maximum value is 22.
loc_error string Data source did not contain a description for LOC_ERROR. Column loc_error has 1968 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: NO ERROR.
loppukm_m string Data source did not contain a description for LOPPUKM_M. Column loppukm_m has 1968 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0001+0290 and maximum string is 1065+0950.
loppupvm date Data source did not contain a description for LOPPUPVM. Column is empty.
malli string Data source did not contain a description for MALLI. Column malli has 1968 rows, out of which 1967 are empty, making the null percent 99.95. The single string value is: .
muutospvm date Data source did not contain a description for MUUTOSPVM. Column is empty.
nimi string Data source did not contain a description for NIMI. Column is empty.
numero int Data source did not contain a description for NUMERO. Column numero has 1968 rows, out of which 1286 are empty, making the null percent 65.35. Minimum value is 15 and maximum value is 24893.
objectid int Data source did not contain a description for OBJECTID. Column objectid has 1968 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 197507 and maximum value is 199643.
paikka int Data source did not contain a description for PAIKKA. Column paikka has 1968 rows, out of which 11 are empty, making the null percent 0.56. Minimum value is 400 and maximum value is 4950.
pistekm_m string Data source did not contain a description for PISTEKM_M. Column pistekm_m has 1968 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0001+0290 and maximum string is 1065+0950.
pluku_alku int Data source did not contain a description for PLUKU_ALKU. Column pluku_alku has 1968 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10290 and maximum value is 10650950.
pluku_lopp int Data source did not contain a description for PLUKU_LOPP. Column pluku_lopp has 1968 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10290 and maximum value is 10650950.
pluku_pist int Data source did not contain a description for PLUKU_PIST. Column pluku_pist has 1968 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10290 and maximum value is 10650950.
ratanumero int Data source did not contain a description for RATANUMERO. Column ratanumero has 1968 rows, out of which 7 are empty, making the null percent 0.36. Minimum value is 1 and maximum value is 751.
sijraidtun int Data source did not contain a description for SIJRAIDTUN. Column sijraidtun has 1968 rows, out of which 1519 are empty, making the null percent 77.18. Minimum value is 2 and maximum value is 751.
tarkkuus string Data source did not contain a description for TARKKUUS. Column tarkkuus has 1968 rows, out of which 1944 are empty, making the null percent 98.78. First 25 characters of minimum string: ... and first 25 characters of maximum string: Äänitaajuus raidevirtapii...
tila string Data source did not contain a description for TILA. Column tila has 1968 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is KAYTOSSA and maximum string is KÄYTÖSSÄ.
tunnus string Data source did not contain a description for TUNNUS. Column tunnus has 1968 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AL//161/571 and maximum string is KsV333/V322.
tyyppi string Data source did not contain a description for TYYPPI. Column tyyppi has 1968 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AL and maximum string is RVP.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 1968 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.48974725018068 ... and first 25 characters of maximum string: POINT (30.623148588148048...
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 1968 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.

Additional Info

Last Updated September 10, 2020
Created July 9, 2018